1.获取某一股票数据

最新推荐文章于 2023-11-01 15:00:37 发布

duqiumail

最新推荐文章于 2023-11-01 15:00:37 发布

阅读量1.2k

点赞数

分类专栏：金融

本文链接：https://blog.csdn.net/duqiumail/article/details/107820591

版权

0 篇文章 0 订阅

订阅专栏

import pandas as pd
import numpy as np
from matplotlib import pyplot as plt


import tushare as ts
ts.set_token('自己注册tushare后获取')
pro = ts.pro_api()

df = ts.pro_bar(ts_code = '000001.sz',start_date = '20190101')

df

	ts_code	trade_date	open	high	low	close	pre_close	change	pct_chg	vol	amount
0	000001.SZ	20200804	13.66	14.15	13.48	14.04	13.59	0.45	3.3113	2445663.25	3388510.059
1	000001.SZ	20200803	13.47	13.62	13.43	13.59	13.34	0.25	1.8741	1445096.16	1954607.257
2	000001.SZ	20200731	13.28	13.53	13.25	13.34	13.37	-0.03	-0.2244	1165821.91	1559068.291
3	000001.SZ	20200730	13.50	13.51	13.37	13.37	13.54	-0.17	-1.2555	964067.63	1294444.933
4	000001.SZ	20200729	13.35	13.63	13.21	13.54	13.34	0.20	1.4993	1519580.25	2043847.472
...	...	...	...	...	...	...	...	...	...	...	...
381	000001.SZ	20190108	9.73	9.74	9.62	9.66	9.74	-0.08	-0.8214	402388.11	389247.795
382	000001.SZ	20190107	9.84	9.85	9.63	9.74	9.75	-0.01	-0.1026	865687.66	841166.430
383	000001.SZ	20190104	9.24	9.82	9.22	9.75	9.28	0.47	5.0647	1481159.06	1422149.888
384	000001.SZ	20190103	9.18	9.33	9.15	9.28	9.19	0.09	0.9793	415537.95	384457.707
385	000001.SZ	20190102	9.39	9.42	9.16	9.19	9.38	-0.19	-2.0256	539386.32	498695.109

386 rows × 11 columns

# 索引倒序排列
alldata = df.sort_index(ascending=False)

alldata.head()

	ts_code	trade_date	open	high	low	close	pre_close	change	pct_chg	vol	amount
385	000001.SZ	20190102	9.39	9.42	9.16	9.19	9.38	-0.19	-2.0256	539386.32	498695.109
384	000001.SZ	20190103	9.18	9.33	9.15	9.28	9.19	0.09	0.9793	415537.95	384457.707
383	000001.SZ	20190104	9.24	9.82	9.22	9.75	9.28	0.47	5.0647	1481159.06	1422149.888
382	000001.SZ	20190107	9.84	9.85	9.63	9.74	9.75	-0.01	-0.1026	865687.66	841166.430
381	000001.SZ	20190108	9.73	9.74	9.62	9.66	9.74	-0.08	-0.8214	402388.11	389247.795

# 更换索引index
alldata.index = alldata.trade_date

alldata.head()

	ts_code	trade_date	open	high	low	close	pre_close	change	pct_chg	vol	amount
trade_date
20190102	000001.SZ	20190102	9.39	9.42	9.16	9.19	9.38	-0.19	-2.0256	539386.32	498695.109
20190103	000001.SZ	20190103	9.18	9.33	9.15	9.28	9.19	0.09	0.9793	415537.95	384457.707
20190104	000001.SZ	20190104	9.24	9.82	9.22	9.75	9.28	0.47	5.0647	1481159.06	1422149.888
20190107	000001.SZ	20190107	9.84	9.85	9.63	9.74	9.75	-0.01	-0.1026	865687.66	841166.430
20190108	000001.SZ	20190108	9.73	9.74	9.62	9.66	9.74	-0.08	-0.8214	402388.11	389247.795

# 删除trade_data列
alldata = alldata.drop(columns=['trade_date'])

alldata

	ts_code	open	high	low	close	pre_close	change	pct_chg	vol	amount
trade_date
20190102	000001.SZ	9.39	9.42	9.16	9.19	9.38	-0.19	-2.0256	539386.32	498695.109
20190103	000001.SZ	9.18	9.33	9.15	9.28	9.19	0.09	0.9793	415537.95	384457.707
20190104	000001.SZ	9.24	9.82	9.22	9.75	9.28	0.47	5.0647	1481159.06	1422149.888
20190107	000001.SZ	9.84	9.85	9.63	9.74	9.75	-0.01	-0.1026	865687.66	841166.430
20190108	000001.SZ	9.73	9.74	9.62	9.66	9.74	-0.08	-0.8214	402388.11	389247.795
...	...	...	...	...	...	...	...	...	...	...
20200729	000001.SZ	13.35	13.63	13.21	13.54	13.34	0.20	1.4993	1519580.25	2043847.472
20200730	000001.SZ	13.50	13.51	13.37	13.37	13.54	-0.17	-1.2555	964067.63	1294444.933
20200731	000001.SZ	13.28	13.53	13.25	13.34	13.37	-0.03	-0.2244	1165821.91	1559068.291
20200803	000001.SZ	13.47	13.62	13.43	13.59	13.34	0.25	1.8741	1445096.16	1954607.257
20200804	000001.SZ	13.66	14.15	13.48	14.04	13.59	0.45	3.3113	2445663.25	3388510.059

386 rows × 10 columns

# 数据写入excel
alldata.to_excel('C:/Users/he/Desktop/xdata/sc_index.xlsx')

alldata['close'].plot()

在这里插入图片描述

# 也可以单独截取其中某一或多列看
alldata[['close']]

386 rows × 1 columns

关注