dailykt爬取tushare 数据存入本地mysql

在读取数据时候,需要输入你自己的token

import pandas as pd
import pymysql
from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://root:root@127.0.0.1:3306/stock1?charset=utf8") 
import tushare as ts 

cons = ts.get_apis()
#输入你自己的token!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ts.set_token('46fcca1e059c38cde5f56fe7748f53c274036cb8cf0c061c2056alg690')
pro = ts.pro_api()
pp=pro.daily_basic(ts_code='', trade_date='20190418')
code=list(pp['ts_code'])

def savek(k):
    df = pro.daily(ts_code=k,adj='qfq', start_date='20100101', end_date='20190418')
    
    df.to_sql(name = 'dailykt',con = engine,if_exists = 'append',index = False,index_label = False)
    
for h in code:
    print(h)
    savek(h)
    
posted @ 2022-08-19 22:53  luoganttcc  阅读(8)  评论(0)    收藏  举报