前段时间玩Python时无意看到了获取股票交易数据的tushare模块,由于自己对股票交易挺有兴趣,加上现在又在做数据挖掘工作,故想先将股票数据下载到数据库中,以便日后分析:
# 导入需要用到的模块
from queue import Queue
import threading
import os
import datetime
import tushare as ts
from sqlalchemy import create_engine
from sqlalchemy import types
# 创建myql数据库引擎,便于后期链接数据库
mysql_info = {'host':'localhost','port':3306,'user':'******','passwd':'******','db':'stock','charset':'utf8'}
engine = create_engine('mysql+pymysql://%s:%s@%s:%s/%s?charset=%s' %(mysql_info['user'],mysql_info['passwd'],
mysql_info['host'],mysql_info['port'],
mysql_info['db'],mysql_info['charset']),
echo=False)
# 获取所有股票数据,利用股票代码获取复权数据
stock_basics = ts.get_stock_basics