获取股票基本信息
import tushare as ts
import pymysql
ts.set_token("a092010283267f9ddfgd066612d5773de95dfgcbf80cebfed")
pro = ts.pro_api()
df = pro.daily(trade_date='20240616')
# 初始化数据库连接
mydb = pymysql.connect(host='localhost', user='root', password='pwd123gyb', database='stock_data')
# 使用 cursor() 方法创建一个游标对象 cursor
cursor = mydb.cursor()
# sql查询语句
sql = "select * from stock_data"
# 使用 execute() 方法执行 SQL 语句
cursor.execute(sql)
# 关## 标题闭数据库连接
mydb.close()
# 建表---股票基础信息(stock_basic_info)
# 根据tushare接口查询数据,并将数据添加至所建的表里
# 查询当前所有正常上市交易的股票列表
data = pro.stock_basic(exchange='', list_status='L',
fields='ts_code,symbol,name,area,industry,fullname,enname,list_status,market')
print(data)
data.to_csv(r'E:\data\2.csv',index=False)
# 通过循环语句逐行添加数据
for index, row in data.iterrows():
sql = "INSERT INTO stock_base_info(id ,ts_code, \
symbol,name,area,industry,fullname,list_status ,market) \
VALUES ('%d','%s', '%s', '%s', '%s', '%s','%s', '%s', '%s')" % \
(index, row['ts_code'], row['symbol'], row['name'], row['area'], row['industry'], row['fullname'],
row['list_status'], row['market'])
# print(index)
# 执行sql语句
cursor.execute(sql)
# 执行sql语句
mydb.commit()
获取股票日交易信息接口数据
#获取股票日数据
import tushare
import tushare as ts
import pymysql
token = 'a0922010283267f9ddfgd066612d5773de95dfgcbf80cebfedfed'
ts.set_token(token)
pro = ts.pro_api()
#多个股票
df = pro.daily(ts_code='000001.SZ,600000.SH', start_date='20240604', end_date='20240605')
print(df)
# data = pro.stock_basic(exchange='', list_status='L', fields='ts_code,symbol,name,area,industry,fullname,enname,list_status,market')
mydb = pymysql.connect(host='localhost',user='username',password='password',database='stock_data')
cursor = mydb.cursor()
# 通过循环语句逐行添加数据
# ts_code ,trade_date, open_p high,low,close,vol,amount,pct_chg,change,
for index, row in df.iterrows():
sql = "INSERT INTO stock_data(ts_code ,trade_date, \
open_p ,high,low,close_p,vol,amount,pct_chg,change_p) \
VALUES ('%s','%s', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f')" % \
(row['ts_code'], row['trade_date'], row['open'], row['high'], row['low'], row['close'], row['vol'], row['amount'], row['pct_chg'], row['change'])
# print(index)
# 执行sql语句
cursor.execute(sql)
# 执行sql语句
mydb.commit()