股票 python tick

# -*- coding: utf-8 -*-
import tushare as ts
import os
import re
from sqlalchemy import create_engine
import cx_Oracle
import sys
reload(sys)
sys.setdefaultencoding('utf-8')  
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'  


sql="select substr(the_date,0,4)||'-'||substr(the_date,5,2)||'-'||substr(the_date,7,2) num,the_date from time_dimension t where the_year >='2014' and the_year <= '2016' and week_day not in ('星期六','星期日') order by the_date "
sql_1="select stockcode from stock_temp order by stockcode "


engine = create_engine('oracle+cx_oracle://stock:stock@192.168.1.10:1521/orcl')
cnx = engine.connect()


#result = cnx.execute(sql)
#result_1 = cnx.execute(sql_1)
i = 0
for stockcode in cnx.execute(sql_1):
    stockname = stockcode[i]
    print stockname
    for row in cnx.execute(sql):
        t_date = row.num
        print t_date
        df = ts.get_tick_data(code=stockname[2:8],date=t_date)
        df.index.names = ['op_index']
        df['STOCKID']= stockname
        df['T_DATE']=t_date
        df.to_sql('iq_stock_tick',cnx,if_exists='append',chunksize=100) 
i+=1


cnx.close()
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值