获取日交易数据

#encoding:utf-8
import tushare as ts
import pandas as pd
import pymssql  
import datetime
import time
localtime = time.localtime(time.time())
date_now= time.strftime("%Y%m%d", time.localtime())
start_time =datetime.datetime.now()
pro = ts.pro_api('xxxxxxxxxxxxxxxxxx')
conn = pymssql.connect(server = "DESKTOP-IHH4MRQ" , user = "sa" , password = "123qwe", database = "STOCK086")
cs1 = conn.cursor()
sql="delete from daily"
count = cs1.execute(sql)  
conn.commit()
ts_code=pd.read_sql("select ts_code from stock_basic ",conn)
ts_code=pd.DataFrame(data = ts_code,columns =["ts_code"])
for i in range(0,len(ts_code),1):
    ts_code_1=ts_code.iat[i,0]
    df = pro.daily(ts_code=ts_code_1, start_date='19910103', end_date=date_now)
    df = pd.DataFrame(data = df,columns =["ts_code","trade_date","topen","high","low","tclose","pre_close","change","pct_chg","vol","amount"])
    df=df.fillna(0)
    for j in range(0,len(df),1):
        sql4="("
        for k in range(0,11,1):
            sql1=str(df.iat[j,k]).replace("'", "")
            sql2 = "'" + sql1 + "'" + ","
            sql3=sql4+sql2
            sql4=sql3
        sql4=sql4[:-1] +")"
        sql= "insert into daily (ts_code, trade_date, topen, high, low, tclose, pre_close, change, pct_chg, vol, amount) values" + sql4
        count = cs1.execute(sql)  
        conn.commit()
#        结束时间
end_time = datetime.datetime.now()
speed = end_time - start_time
# 打印花费时间
print(speed)