采用外排序的方法,将每日股票行情数据按照日期由近及远、涨跌幅从大到小排列。即对数据集按照日期和涨跌幅两列进行降序排列,先排日期,最靠近现在的日期排在最前;再对同一日内的所有股票行情按照涨跌幅的降序排列。
将排序结果存入文件。
中国股市历史行情数据all_zh_stock_daily.csv:868 MB (910,323,100字节),10,788,819条记录(行),每行记录是关于中国股市中某股票在某日的交易行情数据,包含用逗号分隔开的9列信息,说明如下表所示:
列名
类型
描述
示例
date
datetime
交易日期
2006-04-20
symbol
string
股票代码
sh600004
open
float
开盘价
2.94
high
float
最高价
2.94
low
float
最低价
2.88
close
float
收盘价
2.89
volume
float
成交量
7889751.0
outstanding_share
float
流动股本
476000000.0
turnover
float
换手率=成交量/流动股本
0.01657510714285714
数据示例:
……
2006-04-07,sh600004,3.01,3.02,2.95,2.97,4990932.0,476000000.0,0.010485151260504201
2006-04-10,sh600004,2.96,3.01,2.93,3.0,9397461.0,476000000.0,0.01974256512605042
2006-04-11,sh600004,3.0,3.07,3.0,3.04,11665241.0,476000000.0,0.024506808823529413
2006-04-12,sh600004,3.03,3.05,3.0,3.01,7258373.0,476000000.0,0.015248682773109245
2006-04-13,sh600004,3.01,3.04,2.95,2.96,4800957.0,476000000.0,0.01008604411764706
2006-04-14,sh600004,2.95,3.0,2.95,2.99,3881573.0,476000000.0,0.008154565126050421
2006-04-17,sh600004,2.98,3.0,2.96,3.0,4553116.0,476000000.0,0.00956536974789916
2006-04-18,sh600004,3.0,3.0,2.95,2.97,4601889.0,476000000.0,0.009667834033613446
2006-04-19,sh600004,2.96,2.99,2.92,2.94,6649499.0,476000000.0,0.013969535714285714
2006-04-20,sh600004,2.94,2.94,2.88,2.89,7889751.0,476000000.0,0.01657510714285714
2006-04-21,sh600004,2.89,2.91,2.85,2.91,8583388.0,476000000.0,0.018032327731092437
2006-04-24,sh600004,2.9,2.9,2.8,2.8,7811603.0,476000000.0,0.016410930672268908
2006-04-25,sh600004,2.79,2.89,2.77,2.81,4784060.0,476000000.0,0.010050546218487395
2006-04-26,sh600004,2.81,2.88,2.8,2.87,5244592.0,476000000.0,0.011018050420168067
2006-04-27,sh600004,2.86,2.87,2.82,2.85,4587654.0,476000000.0,0.009637928571428572
……
下载地址:https://pan.baidu.com/s/1NBCrhAd6f6Vg03ROKhhHUg,提取码:v5qs
数据量太大了,你主要实现哪一部分的功能?麻烦在这里详细说明一下,我们可以给你提供思路
数据量挺大,文件挺大,处理时间可能比较长,mark一下,有时间试试
您的问题已经有小伙伴解答了,请点击【采纳】按钮,采纳帮您提供解决思路的答案,给回答的人一些鼓励哦~~
ps:开通问答VIP,享受5次/月 有问必答服务,了解详情↓↓↓
【电脑端】戳>>> https://vip.csdn.net/askvip?utm_source=1146287632
【APP 】 戳>>> https://mall.csdn.net/item/52471?utm_source=1146287632