历史财务数据
yssource opened this issue · 39 comments
yssource commented
@rainx @yutiansut @JaysonAlbert
get_finance_info, 只能拿到当前的财务.
有没有办法拿到历史的财务数据呢?
谢谢.
yssource commented
这个办法, 应该也能拿到 一些历史数据, 再计算出其他数据.
如果 get_finance_info 提供一个 datetime range 参数, 拿到历史数据 就 更方便.
yutiansut commented
这个是tdx的问题 没办法 考虑其他办法吧
datochan commented
我这边的历史财务数据是这样拿的, 看看是否有帮助，这里直接贴我的笔记:
数据获取
财务数据列表
http://down.tdx.com.cn:8001/fin/gpcw.txt
文件名称, 文件MD5的hash值, 文件的字节数
gpcw20160930.zip,bf8371400d2325eb47a96243196c197f,2080806
gpcw20160630.zip,7241eab8813a6ad50c203ae53533ec2a,2243971
gpcw20160331.zip,42baabfaaab075302ca53b39443a0cd7,1937253
gpcw20151231.zip,d2d15120271e9fd996e13b233a7e8281,2267129
gpcw20150930.zip,b5cfcf0fc5f0d75853c58134e075c956,1955384
gpcw20150630.zip,a3f9503d68a7be9db695a154ebeea437,2122141
gpcw20150331.zip,b94ac28e56934197b9c9a1f1e0c544f0,1832383
gpcw20141231.zip,bd468ae8e140c56ae3808e258b3a3765,2229083
gpcw20140930.zip,3098884f7fa41a1289c525fc45d6d056,1813196
gpcw20140630.zip,6725ca2c6b1346378217049ac35a0a38,1942731
是逗号分隔的csv，第一项是文件名，第二项目是hash，第三项是字节数
下载流程，直接拼接就可以了
http://down.tdx.com.cn:8001/fin/gpcw20160930.zip
数据解析
004757B3 |. 8D5424 20 ||lea edx, dword ptr [esp+0x20]
004757B7 |. 51 ||push ecx
004757B8 |. 57 ||push edi
004757B9 |. 68 4023A600 ||push 00A62340 ; C:\Program Files\tdx\vipdoc\
004757BE |. 68 F8968B00 ||push 008B96F8 ; %scw\gpcw%04d%04d.dat
004757C3 |. 52 ||push edx
004757C4 |. C74424 3C 000>||mov dword ptr [esp+0x3C], 0x0
004757CC |. E8 ED3B3B00 ||call <jmp.&MFC42.#CString::Format_2818>
004757D1 |. 83C4 14 ||add esp, 0x14
004757D4 |. 8D4C24 38 ||lea ecx, dword ptr [esp+0x38]
004757D8 |. E8 673D3B00 ||call <jmp.&MFC42.#CFile::CFile_354>
004757DD |. 8B4424 20 ||mov eax, dword ptr [esp+0x20]
004757E1 |. 6A 00 ||push 0x0
004757E3 |. 6A 40 ||push 0x40
004757E5 |. 50 ||push eax
004757E6 |. 8D4C24 44 ||lea ecx, dword ptr [esp+0x44]
004757EA |. C64424 70 01 ||mov byte ptr [esp+0x70], 0x1
004757EF |. E8 443D3B00 ||call <jmp.&MFC42.#CFile::Open_5186> ; 打开财报文件
004757F4 |. 85C0 ||test eax, eax
004757F6 |. 0F84 50010000 ||je 0047594C
004757FC |. 8D4C24 48 ||lea ecx, dword ptr [esp+0x48]
00475800 |. 6A 14 ||push 0x14
00475802 |. 51 ||push ecx
00475803 |. 8D4C24 40 ||lea ecx, dword ptr [esp+0x40]
00475807 |. E8 263D3B00 ||call <jmp.&MFC42.#CFile::Read_5442> ; 读取文件
0047580C |. 8B4424 4E ||mov eax, dword ptr [esp+0x4E]
00475810 |. 85C0 ||test eax, eax
00475812 |. 0F8E 2B010000 ||jle 00475943
00475818 |. 8D1480 ||lea edx, dword ptr [eax+eax*4]
0047581B |. 8D0450 ||lea eax, dword ptr [eax+edx*2]
0047581E |. 50 ||push eax
0047581F |. E8 CC393B00 ||call <jmp.&MFC42.#operator new_823> ; 申请2b66大小的缓存
00475824 |. 8BF8 ||mov edi, eax ; 12B443C0
00475826 |. 8B4424 52 ||mov eax, dword ptr [esp+0x52]
0047582A |. 83C4 04 ||add esp, 0x4
0047582D |. 897C24 14 ||mov dword ptr [esp+0x14], edi
00475831 |. 8D0C80 ||lea ecx, dword ptr [eax+eax*4]
00475834 |. 8D1448 ||lea edx, dword ptr [eax+ecx*2]
00475837 |. 8D4C24 38 ||lea ecx, dword ptr [esp+0x38]
0047583B |. 52 ||push edx
0047583C |. 57 ||push edi
0047583D |. E8 F03C3B00 ||call <jmp.&MFC42.#CFile::Read_5442> ; 从财宝中读取2B66大小的内容，存放到刚才申请的缓存中
00475842 |. 8B4424 4E ||mov eax, dword ptr [esp+0x4E]
00475846 |. 33F6 ||xor esi, esi
00475848 |. 85C0 ||test eax, eax
0047584A |. 0F8E E2000000 ||jle 00475932
00475850 |> 57 ||/push edi ; /s
00475851 |. C647 06 00 |||mov byte ptr [edi+0x6], 0x0 ; |在股票代码末尾设置\0防止字符串解析错误
00475855 |. FF15 98638500 |||call dword ptr [<&MSVCRT.atol>] ; \将股票代码转long类型
0047585B |. 8B4C24 78 |||mov ecx, dword ptr [esp+0x78]
0047585F |. 83C4 04 |||add esp, 0x4
00475862 |. 3BC1 |||cmp eax, ecx
00475864 |. 74 11 |||je short 00475877 ; 查找指定的股票
00475866 |. 8B4424 4E |||mov eax, dword ptr [esp+0x4E]
0047586A |. 46 |||inc esi ; 累加器统计目标股票代码的偏移数量
0047586B |. 83C7 0B |||add edi, 0xB
0047586E |. 3BF0 |||cmp esi, eax
00475870 |.^ 7C DE ||\jl short 00475850
00475872 |. E9 B7000000 ||jmp 0047592E ; 如果没找到就跳走，如果找到则获取其财报信息
00475877 |> 8B4C24 14 ||mov ecx, dword ptr [esp+0x14] ; 得到STOCK_ITEM的基地址
0047587B |. 8D04B6 ||lea eax, dword ptr [esi+esi*4] ; 指定股票的偏移+偏移*4
0047587E |. 03CE ||add ecx, esi
00475880 |. 6A 00 ||push 0x0
00475882 |. 8B5441 07 ||mov edx, dword ptr [ecx+eax*2+0x7] ; 得到每只股票代码的下一个成员(offset)
00475886 |. 8B4424 28 ||mov eax, dword ptr [esp+0x28] ; 得到要获取元素的偏移。
0047588A |. 8D4C82 FC ||lea ecx, dword ptr [edx+eax*4-0x4]
0047588E |. 51 ||push ecx
0047588F |. 8D4C24 40 ||lea ecx, dword ptr [esp+0x40]
00475893 |. E8 C6433B00 ||call <jmp.&MFC42.#CFile::Seek_5773> ; 计算其财报信息每股净收益的偏移
00475898 |. 8D5424 28 ||lea edx, dword ptr [esp+0x28]
0047589C |. 6A 04 ||push 0x4
0047589E |. 52 ||push edx
0047589F |. 8D4C24 40 ||lea ecx, dword ptr [esp+0x40]
004758A3 |. E8 8A3C3B00 ||call <jmp.&MFC42.#CFile::Read_5442> ; 得到需要的元素
004758A8 |. 8B83 F8140000 ||mov eax, dword ptr [ebx+0x14F8]
遍历财务数据的代码
from struct import *
cw_file = open('/Users/datochan/Documents/gpcw20160930.dat', 'rb')
header_size = calcsize("<3h1H3L")
stock_item_size = calcsize("<6s1c1L")
data_header = cw_file.read(header_size)
stock_header = unpack("<3h1H3L", data_header)
max_count = stock_header[3]
for stock_idx in range(0, max_count):
cw_file.seek(header_size+stock_idx*calcsize("<6s1c1L"))
si = cw_file.read(stock_item_size)
stock_item = unpack("<6s1c1L", si)
code = stock_item[0].decode()
foa = stock_item[2]
cw_file.seek(foa)
info_data = cw_file.read(calcsize('<264f'))
data_size = len(info_data)
cw_info = unpack('<264f', info_data)
print("%s, %s" % (code, str(cw_info)))
取出数据的含义为:
-------------每股指标-----------------------------
1--基本每股收益
2--扣除非经常性损益每股收益
3--每股未分配利润
4--每股净资产
5--每股资本公积金
6--净资产收益率
7--每股经营现金流量
-------------资产负债表----------------------------
8.--货币资金
9.--交易性金融资产
10.--应收票据
11.--应收账款
12.--预付款项
13.--其他应收款
14.--应收关联公司款
15.--应收利息
16.--应收股利
17.--存货
18.--其中：消耗性生物资产
19.--一年内到期的非流动资产
20.--其他流动资产
21.--流动资产合计
22.--可供出售金融资产
23.--持有至到期投资
24.--长期应收款
25.--长期股权投资
26.--投资性房地产
27.--固定资产
28.--在建工程
29.--工程物资
30.--固定资产清理
31.--生产性生物资产
32.--油气资产
33.--无形资产
34.--开发支出
35.--商誉
36.--长期待摊费用
37.--递延所得税资产
38.--其他非流动资产
39.--非流动资产合计
40.--资产总计
41.--短期借款
42.--交易性金融负债
43.--应付票据
44.--应付账款
45.--预收款项
46.--应付职工薪酬
47.--应交税费
48.--应付利息
49.--应付股利
50.--其他应付款
51.--应付关联公司款
52.--一年内到期的非流动负债
53.--其他流动负债
54.--流动负债合计
55.--长期借款
56.--应付债券
57.--长期应付款
58.--专项应付款
59.--预计负债
60.--递延所得税负债
61.--其他非流动负债
62.--非流动负债合计
63.--负债合计
64.--实收资本（或股本）
65.--资本公积
66.--盈余公积
67.--减：库存股
68.--未分配利润
69.--少数股东权益
70.--外币报表折算价差
71.--非正常经营项目收益调整
72.--所有者权益（或股东权益）合计
73.--负债和所有者（或股东权益）合计
-------------利润表-----------------------------
74.--其中：营业收入
75.--其中：营业成本
76.--营业税金及附加
77.--销售费用
78.--管理费用
79.--堪探费用
80.--财务费用
81.--资产减值损失
82.--加：公允价值变动净收益
83.--投资收益
84.--其中：对联营企业和合营企业的投资收益
85.--影响营业利润的其他科目
86.--三、营业利润
87.--加：补贴收入
88.--营业外收入
89.--减：营业外支出
90.--其中：非流动资产处置净损失
91.--加：影响利润总额的其他科目
92.--四、利润总额
93.--减：所得税
94.--加：影响净利润的其他科目
95.--五、净利润
96.--归属于母公司所有者的净利润
97.--少数股东损益
------------------现金流量表---------------------
98.--销售商品、提供劳务收到的现金
99.--收到的税费返还
100.--收到其他与经营活动有关的现金
101.--经营活动现金流入小计
102.--购买商品、接受劳务支付的现金
103.--支付给职工以及为职工支付的现金
104.--支付的各项税费
105.--支付其他与经营活动有关的现金
106.--经营活动现金流出小计
107.--经营活动产生的现金流量净额
108.--收回投资收到的现金
109.--取得投资收益收到的现金
110.--处置固定资产、无形资产和其他长期资产收回的现金净额
111.--处置子公司及其他营业单位收到的现金净额
112.--收到其他与投资活动有关的现金
113.--投资活动现金流入小计
114.--购建固定资产、无形资产和其他长期资产支付的现金
115.--投资支付的现金
116.--取得子公司及其他营业单位支付的现金净额
117.--支付其他与投资活动有关的现金
118.--投资活动现金流出小计
119.--投资活动产生的现金流量净额
120.--吸收投资收到的现金
121.--取得借款收到的现金
122.--收到其他与筹资活动有关的现金
123.--筹资活动现金流入小计
124.--偿还债务支付的现金
125.--分配股利、利润或偿付利息支付的现金
126.--支付其他与筹资活动有关的现金
127.--筹资活动现金流出小计
128.--筹资活动产生的现金流量净额
129.--四、汇率变动对现金的影响
130.--四(2)、其他原因对现金的影响
131.--五、现金及现金等价物净增加额
132.--期初现金及现金等价物余额
133.--期末现金及现金等价物余额
134.--净利润
135.--加：资产减值准备
136.--固定资产折旧、油气资产折耗、生产性生物资产折旧
137.--无形资产摊销
138.--长期待摊费用摊销
139.--处置固定资产、无形资产和其他长期资产的损失
140.--固定资产报废损失
141.--公允价值变动损失
142.--财务费用
143.--投资损失
144.--递延所得税资产减少
145.--递延所得税负债增加
146.--存货的减少
147.--经营性应收项目的减少
148.--经营性应付项目的增加
149.--其他
150.--经营活动产生的现金流量净额2
151.--债务转为资本
152.--一年内到期的可转换公司债券
153.--融资租入固定资产
154.--现金的期末余额
155.--减：现金的期初余额
156.--加：现金等价物的期末余额
157.--减：现金等价物的期初余额
158.--现金及现金等价物净增加额
---------------------偿债能力分析------------------------
159.--流动比率
160.--速动比率
161.--现金比率
162.--利息保障倍数
163.--非流动负债比率
164.--流动负债比率
165.--现金到期债务比率
166.--有形资产净值债务率
167.--权益乘数(%)
168.--股东的权益/负债合计(%)
169.--有形资产/负债合计(%)
170.--经营活动产生的现金流量净额/负债合计(%)
171.--EBITDA/负债合计(%)
---------------------经营效率分析------------------------
172.--应收帐款周转率
173.--存货周转率
174.--运营资金周转率
175.--总资产周转率
176.--固定资产周转率
177.--应收帐款周转天数
178.--存货周转天数
179.--流动资产周转率
180.--流动资产周转天数
181.--总资产周转天数
182.--股东权益周转率
---------------------发展能力分析------------------------
183.--营业收入增长率
184.--净利润增长率
185.--净资产增长率
186.--固定资产增长率
187.--总资产增长率
188.--投资收益增长率
189.--营业利润增长率
190.--暂无
191.--暂无
192.--暂无
---------------------获利能力分析------------------------
193.--成本费用利润率(%)
194.--营业利润率
195.--营业税金率
196.--营业成本率
197.--净资产收益率
198.--投资收益率
199.--销售净利率(%)
200.--总资产报酬率
201.--净利润率
202.--销售毛利率(%)
203.--三费比重
204.--管理费用率
205.--财务费用率
206.--扣除非经常性损益后的净利润
207.--息税前利润(EBIT)
208.--息税折旧摊销前利润(EBITDA)
209.--EBITDA/营业总收入(%)
---------------------资本结构分析---------------------
210.--资产负债率(%)
211.--流动资产比率
212.--货币资金比率
213.--存货比率
214.--固定资产比率
215.--负债结构比
216.--归属于母公司股东权益/全部投入资本(%)
217.--股东的权益/带息债务(%)
218.--有形资产/净债务(%)
---------------------现金流量分析---------------------
219.--每股经营性现金流(元)
220.--营业收入现金含量(%)
221.--经营活动产生的现金流量净额/经营活动净收益(%)
222.--销售商品提供劳务收到的现金/营业收入(%)
223.--经营活动产生的现金流量净额/营业收入
224.--资本支出/折旧和摊销
225.--每股现金流量净额(元)
226.--经营净现金比率（短期债务）
227.--经营净现金比率（全部债务）
228.--经营活动现金净流量与净利润比率
229.--全部资产现金回收率
---------------------单季度财务指标---------------------
230.--营业收入
231.--营业利润
232.--归属于母公司所有者的净利润
233.--扣除非经常性损益后的净利润
234.--经营活动产生的现金流量净额
235.--投资活动产生的现金流量净额
236.--筹资活动产生的现金流量净额
237.--现金及现金等价物净增加额
---------------------股本股东---------------------
238.--总股本
239.--已上市流通A股
240.--已上市流通B股
241.--已上市流通H股
242.--股东人数(户)
243.--第一大股东的持股数量
244.--十大流通股东持股数量合计(股)
245.--十大股东持股数量合计(股)
---------------------机构持股---------------------
246.--机构总量（家）
247.--机构持股总量(股)
248.--QFII机构数
249.--QFII持股量
250.--券商机构数
251.--券商持股量
252.--保险机构数
253.--保险持股量
254.--基金机构数
255.--基金持股量
256.--社保机构数
257.--社保持股量
258.--私募机构数
259.--私募持股量
260.--财务公司机构数
261.--财务公司持股量
262.--年金机构数
263.--年金持股量
---------------------新增指标---------------------
264.--十大流通股东中持有A股合计(股) [注：季度报告中，若股东同时持有非流通A股性质的股份(如同时持有流通A股和流通B股），指标264取的是包含同时持有非流通A股性质的流通股数]
yutiansut commented
卧槽 帅啊
yssource commented
@datochan @yutiansut 💥 💥 👍 👏
先祝贺, 我也 ollydbg 一下, 发现了问题再给你们 feedback
rainx commented
@yutiansut @datochan cool
rainx commented
@yutiansut @yssource @datochan 根据 @datochan 的代码，创建了一个新的分支
history_financial_crawler https://github.com/rainx/pytdx/compare/history_financial_crawler ， 用于处理历史财务信息，现在已经实现的差不多了, 后面把文档更新上并合并到主干了
增加了
pytdx.crawler.history_financial_crawler.HistoryFinancialListCrawler
下载财务数据文件列表
pytdx.crawler.history_financial_crawler.HistoryFinancialCrawler
下载并解析财务数据
HistoryFinancialReader
专门进行财务数据文件的读取和解析
命令行工具 hqreader 增加对历史财务数据文件支持
hqreader -d hf /tmp/gpcw20170930.dat
或
hqreader -d hf /tmp/gpcw20170930.zip
yutiansut commented
我尝试一下
yutiansut commented
咦 为啥我解析出来有279列
col275 col276 col277 col278
code
000001 8.899357e+08 2.284400e+10 -4.039810e+34 -4.039810e+34
000002 2.928035e+09 1.952733e+10 -4.039810e+34 -4.039810e+34
000004 3.416154e+07 1.356895e+07 -4.039810e+34 -4.039810e+34
000005 2.188648e+08 1.083661e+08 -4.039810e+34 -4.039810e+34
000006 2.149200e+08 2.544113e+08 -4.039810e+34 -4.039810e+34
000007 5.980906e+07 4.306942e+07 1.000000e+00 9.205418e+06
000008 7.099678e+07 3.067550e+08 2.000000e+00 4.555090e+07
000009 3.758013e+08 2.810229e+08 -4.039810e+34 -4.039810e+34
000010 8.164534e+07 5.262458e+07 1.000000e+00 2.180000e+06
000011 3.111445e+07 1.031617e+08 -4.039810e+34 -4.039810e+34
000012 1.914432e+08 8.534831e+08 -4.039810e+34 -4.039810e+34
000014 8.952402e+07 3.641715e+07 -4.039810e+34 -4.039810e+34
000016 5.237469e+08 -4.489407e+08 -4.039810e+34 -4.039810e+34
.......
yutiansut commented
完整的结果
In [7]: HistoryFinancialReader().get_df('C://Users//P8XXTMX-G//Downloads//gpcw20160930.zip')
Out[7]:
report_date col1 col2 col3 col4 col5 \
code
000001 20160930 1.0900 1.0895 4.050000e+00 10.3800 3.290000e+00
000002 20160930 0.7480 0.7331 4.790000e+00 9.1000 7.300000e-01
000004 20160930 0.1750 0.1749 1.000000e-02 1.1458 1.000000e-02
000005 20160930 0.1260 -0.0048 -4.100000e-01 1.2116 6.000000e-01
000006 20160930 0.0848 0.0840 1.040000e+00 3.2185 3.600000e-01
000007 20160930 0.0753 -0.0597 -1.200000e+00 1.6630 1.830000e+00
000008 20160930 0.0367 0.0356 1.400000e-01 2.1056 9.500000e-01
000009 20160930 0.0980 0.0109 8.000000e-01 2.1112 1.600000e-01
000010 20160930 0.0268 0.0291 -1.600000e-01 2.6804 1.820000e+00
000011 20160930 -0.0121 -0.0135 1.980000e+00 3.4324 2.000000e-01
000012 20160930 0.3400 0.3108 1.800000e+00 3.8356 6.100000e-01
000014 20160930 -0.0869 -0.1374 1.290000e+00 3.4212 5.000000e-02
000016 20160930 -0.0184 -0.0507 -2.400000e-01 1.1418 3.000000e-02
000017 20160930 0.0038 0.0030 -2.170000e+00 0.0251 1.140000e+00
000018 20160930 0.1785 0.1668 6.200000e-01 0.9490 -7.700000e-01
000019 20160930 -0.0610 -0.0781 9.000000e-02 2.0107 8.100000e-01
000020 20160930 0.0159 0.0106 -6.700000e-01 1.1167 5.200000e-01
000021 20160930 0.2063 0.0769 1.290000e+00 3.6503 4.600000e-01
000022 20160930 0.6630 0.6593 5.080000e+00 7.1455 2.600000e-01
000023 20160930 0.0600 0.0684 6.900000e-01 2.7794 7.400000e-01
000025 20160930 0.0882 0.0776 1.000000e-01 3.0085 1.900000e+00
000026 20160930 0.2469 0.2447 1.600000e+00 5.4081 2.420000e+00
000027 20160930 0.3375 0.3352 2.070000e+00 5.4015 1.090000e+00
000028 20160930 1.9930 1.5955 1.009000e+01 16.7316 5.140000e+00
000029 20160930 0.2341 0.2265 5.200000e-01 2.5371 9.700000e-01
000030 20160930 0.4000 0.3815 2.190000e+00 3.8788 4.100000e-01
000031 20160930 0.0400 0.0275 1.330000e+00 3.0353 1.500000e-01
000032 20160930 0.1352 0.1282 1.170000e+00 3.3854 6.200000e-01
000034 20160930 0.5670 0.1883 -8.300000e-01 3.9394 3.640000e+00
000035 20160930 0.1091 0.1052 5.200000e-01 1.6031 7.600000e-01
... ... ... ... ... ... ...
603889 20160930 0.4400 0.4229 1.730000e+00 3.5646 7.800000e-01
603898 20160930 0.5200 0.4845 1.590000e+00 3.5222 1.030000e+00
603899 20160930 0.4297 0.3858 1.070000e+00 2.5351 3.000000e-01
603900 20160930 0.9600 0.9576 2.700000e+00 6.3975 2.420000e+00
603901 20160930 0.1800 0.1471 7.200000e-01 2.1865 4.000000e-01
603909 20160930 0.4659 0.3680 2.280000e+00 5.5729 2.150000e+00
603918 20160930 0.0205 0.0044 7.900000e-01 2.5953 6.900000e-01
603919 20160930 0.6200 0.5505 1.860000e+00 5.6434 2.640000e+00
603928 20160930 0.5600 0.5400 -4.039810e+34 3.8900 -4.039810e+34
603929 20160930 0.9500 0.9500 2.310000e+00 4.1500 6.600000e-01
603936 20160930 0.2340 0.1867 2.250000e+00 5.4979 2.050000e+00
603939 20160930 0.4840 0.4317 1.390000e+00 7.9859 5.530000e+00
603955 20160930 0.6097 0.5808 3.880000e+00 10.4726 4.740000e+00
603958 20160930 0.3150 0.1797 1.910000e+00 5.2711 2.130000e+00
603959 20160930 0.2700 0.1911 1.310000e+00 3.6657 1.210000e+00
603966 20160930 0.3044 0.2761 -4.039810e+34 4.1232 -4.039810e+34
603968 20160930 0.5000 0.4351 2.410000e+00 6.0316 1.940000e+00
603969 20160930 0.2500 0.2424 1.050000e+00 3.8704 1.680000e+00
603977 20160930 0.5200 0.3129 2.060000e+00 3.9563 5.800000e-01
603979 20160930 0.4200 0.3482 2.860000e+00 8.1284 3.870000e+00
603986 20160930 1.8600 1.2464 4.380000e+00 12.3687 6.620000e+00
603987 20160930 0.4800 0.4600 1.750000e+00 4.2100 1.270000e+00
603988 20160930 0.3100 0.2431 2.680000e+00 8.0847 4.100000e+00
603989 20160930 0.6690 0.5477 1.370000e+00 5.7263 3.090000e+00
603990 20160930 0.3600 0.3300 -4.039810e+34 3.4700 -4.039810e+34
603993 20160930 0.0346 0.0391 1.900000e-01 1.0560 6.300000e-01
603996 20160930 0.2029 0.1966 1.430000e+00 4.4599 1.860000e+00
603997 20160930 0.4200 0.3964 1.330000e+00 3.4661 9.700000e-01
603998 20160930 0.1300 0.1190 7.700000e-01 2.1109 3.900000e-01
603999 20160930 0.2200 0.1883 2.360000e+00 5.6306 1.970000e+00
col6 col7 col8 col9 ... col269 \
code ...
000001 9.443 -8.910 4.270140e+11 1.598400e+10 ... -4.039810e+34
000002 8.229 3.894 7.518702e+10 -4.039810e+34 ... -1.323910e+08
000004 15.276 1.600 1.404810e+08 -4.039810e+34 ... -4.039810e+34
000005 10.431 -0.092 1.440327e+08 -4.039810e+34 ... -4.039810e+34
000006 2.635 1.124 2.287849e+09 -4.039810e+34 ... -5.466768e+05
000007 4.527 -0.138 2.016645e+07 2.139842e+08 ... -4.039810e+34
000008 3.735 -0.036 1.327967e+09 5.238800e+05 ... -4.039810e+34
000009 4.636 0.012 2.128161e+09 3.582522e+08 ... -5.688474e+07
000010 0.999 -0.228 4.671235e+08 -4.039810e+34 ... -4.039810e+34
000011 -0.352 3.525 2.717239e+09 -4.039810e+34 ... 6.211395e+05
000012 8.981 0.767 3.069944e+08 -4.039810e+34 ... 7.055550e+05
000014 -2.541 0.825 2.034572e+08 -4.039810e+34 ... -4.039810e+34
000016 -1.612 -0.171 2.337841e+09 1.216953e+07 ... -2.369660e+07
000017 15.027 -0.010 1.808437e+07 -4.039810e+34 ... -4.039810e+34
000018 18.812 -0.993 9.742814e+08 5.700000e+07 ... -4.039810e+34
000019 -3.035 -0.003 1.225161e+08 2.709116e+06 ... -4.039810e+34
000020 1.426 -0.251 4.236820e+07 -4.039810e+34 ... -4.039810e+34
000021 5.652 0.039 2.976159e+09 -4.039810e+34 ... -6.325504e+07
000022 9.273 0.889 4.582775e+08 -4.039810e+34 ... 4.500000e+04
000023 2.144 0.362 1.890150e+08 -4.039810e+34 ... -4.039810e+34
000025 2.931 0.116 1.640584e+08 -4.039810e+34 ... -4.039810e+34
000026 4.565 0.663 4.780246e+08 -4.039810e+34 ... 9.198679e+06
000027 6.248 0.512 5.245121e+09 1.939415e+07 ... -7.888285e+08
000028 11.913 1.462 2.095024e+09 -4.039810e+34 ... -4.039810e+34
000029 9.229 0.545 1.329914e+09 -4.039810e+34 ... -2.717649e+06
000030 10.349 0.244 9.903030e+08 -4.039810e+34 ... 1.348427e+05
000031 1.394 2.002 1.462336e+10 -4.039810e+34 ... -2.042459e+06
000032 3.993 -0.115 6.154804e+08 -4.039810e+34 ... -2.995117e+05
000034 12.956 1.479 1.410261e+09 1.399109e+07 ... 2.164345e+07
000035 6.807 0.071 1.883278e+08 -4.039810e+34 ... 2.507310e+04
... ... ... ... ... ... ...
603889 12.241 0.483 2.707596e+08 -4.039810e+34 ... 3.241688e+05
603898 14.553 0.747 2.130302e+08 -4.039810e+34 ... -4.039810e+34
603899 16.948 0.431 3.915420e+08 -4.039810e+34 ... -4.039810e+34
603900 14.951 0.284 9.300240e+07 -4.039810e+34 ... -4.039810e+34
603901 8.039 0.090 2.312585e+08 -4.039810e+34 ... -2.405524e+06
603909 6.967 -0.020 2.498567e+08 -4.039810e+34 ... -4.039810e+34
603918 0.921 -0.410 2.041037e+08 -4.039810e+34 ... 1.811435e+05
603919 10.150 0.424 3.157980e+08 -4.039810e+34 ... -4.039810e+34
603928 14.276 0.500 -4.039810e+34 -4.039810e+34 ... -4.039810e+34
603929 22.875 1.630 4.799040e+08 -4.039810e+34 ... 4.487524e+05
603936 4.261 0.284 7.251769e+07 -4.039810e+34 ... -4.039810e+34
603939 5.502 0.496 8.293762e+08 -4.039810e+34 ... -4.039810e+34
603955 5.823 -0.315 1.074242e+08 -4.039810e+34 ... -4.039810e+34
603958 4.853 -0.345 3.023830e+08 -4.039810e+34 ... 9.406000e+01
603959 6.364 -0.624 2.122187e+08 -4.039810e+34 ... -4.039810e+34
603966 7.384 0.071 -4.039810e+34 -4.039810e+34 ... -4.039810e+34
603968 8.293 0.731 5.611996e+08 -4.039810e+34 ... 8.682933e+07
603969 6.414 -0.372 1.905104e+08 -4.039810e+34 ... -4.039810e+34
603977 12.978 0.138 1.331134e+08 -4.039810e+34 ... -4.039810e+34
603979 4.502 0.039 1.077638e+09 -4.039810e+34 ... 8.011324e+06
603986 11.692 0.341 9.135201e+08 -4.039810e+34 ... 4.080189e+06
603987 11.505 0.950 1.647707e+08 -4.039810e+34 ... 2.212053e+04
603988 3.807 0.312 1.255832e+08 -4.039810e+34 ... -4.039810e+34
603989 11.679 0.871 1.253851e+08 -4.039810e+34 ... -4.039810e+34
603990 10.387 -0.430 -4.039810e+34 -4.039810e+34 ... -4.039810e+34
603993 3.272 0.051 1.379868e+10 -4.039810e+34 ... 4.327319e+08
603996 4.550 -1.612 3.998874e+08 -4.039810e+34 ... -4.039810e+34
603997 12.163 0.232 2.511757e+08 -4.039810e+34 ... -3.578334e+05
603998 6.225 0.095 1.402175e+08 -4.039810e+34 ... -4.039810e+34
603999 3.841 -0.091 7.934580e+08 -4.039810e+34 ... -4.039810e+34
col270 col271 col272 col273 col274 \
code
000001 -4.039810e+34 1.982280e+11 -4.039810e+34 -4.039810e+34 3.000000e+00
000002 1.115786e+10 1.004035e+11 -4.039810e+34 -4.039810e+34 3.000000e+00
000004 2.049414e+07 9.622171e+07 -4.039810e+34 -4.039810e+34 3.000000e+00
000005 1.418844e+08 1.282481e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000006 1.192260e+08 4.345017e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000007 2.610958e+07 3.840931e+08 -4.039810e+34 -4.039810e+34 5.000000e+00
000008 2.192151e+08 5.806598e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
000009 3.095417e+08 4.537704e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000010 2.120866e+07 2.197508e+09 -4.039810e+34 -4.039810e+34 5.000000e+00
000011 -6.581346e+06 2.045647e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000012 7.193658e+08 7.960068e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
000014 -1.807685e+07 6.900746e+08 -4.039810e+34 -4.039810e+34 2.000000e+00
000016 -7.290796e+07 2.749445e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
000017 2.908600e+06 1.384561e+07 -4.039810e+34 -4.039810e+34 1.000000e+00
000018 3.021527e+08 1.611590e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000019 -3.457629e+07 9.080634e+08 -4.039810e+34 -4.039810e+34 4.000000e+00
000020 4.509368e+06 3.162196e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
000021 2.382927e+08 5.370609e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000022 5.357717e+08 4.607139e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000023 1.327638e+07 3.856641e+08 -4.039810e+34 -4.039810e+34 4.000000e+00
000025 2.645007e+07 8.943844e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
000026 1.172294e+08 2.372769e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
000027 6.491590e+08 2.141429e+10 -4.039810e+34 -4.039810e+34 6.000000e+00
000028 7.414438e+08 6.067417e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000029 2.341457e+08 2.566677e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000030 5.261127e+08 5.016260e+09 -4.039810e+34 -4.039810e+34 7.000000e+00
000031 5.697928e+08 5.505274e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000032 4.932095e+07 1.429495e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000034 3.550317e+08 2.576659e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
000035 1.351716e+08 1.985543e+09 -4.039810e+34 -4.039810e+34 5.000000e+00
... ... ... ... ... ...
603889 1.471138e+08 1.157132e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
603898 1.537245e+08 1.056298e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603899 3.915385e+08 2.332281e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
603900 1.744737e+08 1.169201e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603901 6.799456e+07 8.745853e+08 -4.039810e+34 -4.039810e+34 2.000000e+00
603909 3.882492e+07 5.572858e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603918 4.387192e+06 4.567674e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603919 1.603764e+08 1.580145e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603928 -4.039810e+34 5.885758e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603929 1.523837e+08 6.642006e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603936 3.920257e+07 9.200745e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603939 1.621174e+08 2.896458e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
603955 -4.039810e+34 6.833366e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603958 5.319241e+07 1.145718e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603959 5.225857e+07 8.211226e+08 -4.039810e+34 -4.039810e+34 7.000000e+00
603966 -4.039810e+34 4.947879e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603968 1.891111e+08 1.233334e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
603969 1.012892e+08 1.548160e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
603977 8.681725e+07 6.559561e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603979 1.721269e+08 3.657779e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
603986 1.500086e+08 1.236874e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603987 9.139743e+07 6.644750e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603988 2.462353e+07 6.467779e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603989 2.000954e+08 1.717886e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603990 -4.039810e+34 2.082668e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603993 1.000944e+09 1.783349e+10 -4.039810e+34 -4.039810e+34 5.000000e+00
603996 6.090624e+07 1.338631e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603997 1.775536e+08 1.455776e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603998 6.093081e+07 9.145565e+08 -4.039810e+34 -4.039810e+34 2.000000e+00
603999 6.124773e+07 1.621625e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
col275 col276 col277 col278
code
000001 8.899357e+08 2.284400e+10 -4.039810e+34 -4.039810e+34
000002 2.928035e+09 1.952733e+10 -4.039810e+34 -4.039810e+34
000004 3.416154e+07 1.356895e+07 -4.039810e+34 -4.039810e+34
000005 2.188648e+08 1.083661e+08 -4.039810e+34 -4.039810e+34
000006 2.149200e+08 2.544113e+08 -4.039810e+34 -4.039810e+34
000007 5.980906e+07 4.306942e+07 1.000000e+00 9.205418e+06
000008 7.099678e+07 3.067550e+08 2.000000e+00 4.555090e+07
000009 3.758013e+08 2.810229e+08 -4.039810e+34 -4.039810e+34
000010 8.164534e+07 5.262458e+07 1.000000e+00 2.180000e+06
000011 3.111445e+07 1.031617e+08 -4.039810e+34 -4.039810e+34
000012 1.914432e+08 8.534831e+08 -4.039810e+34 -4.039810e+34
000014 8.952402e+07 3.641715e+07 -4.039810e+34 -4.039810e+34
000016 5.237469e+08 -4.489407e+08 -4.039810e+34 -4.039810e+34
000017 6.350875e+07 1.404106e+06 -4.039810e+34 -4.039810e+34
000018 1.178959e+08 4.072863e+08 -4.039810e+34 -4.039810e+34
000019 1.348447e+08 -5.458496e+07 -4.039810e+34 -4.039810e+34
000020 1.164899e+08 -1.968603e+07 -4.039810e+34 -4.039810e+34
000021 7.654823e+08 3.438597e+08 1.000000e+00 2.131809e+07
000022 3.708780e+08 5.374819e+08 -4.039810e+34 -4.039810e+34
000023 6.011656e+07 7.755122e+06 1.000000e+00 2.751968e+06
000025 1.399252e+08 5.028900e+07 -4.039810e+34 -4.039810e+34
000026 1.629773e+08 1.234085e+08 -4.039810e+34 -4.039810e+34
000027 1.131110e+09 1.539587e+09 -4.039810e+34 -4.039810e+34
000028 1.204936e+08 9.100522e+08 -4.039810e+34 -4.039810e+34
000029 6.440498e+08 3.040127e+08 -4.039810e+34 -4.039810e+34
000030 8.882511e+08 6.595002e+08 -4.039810e+34 -4.039810e+34
000031 8.941296e+08 2.848329e+08 -4.039810e+34 -4.039810e+34
000032 1.312180e+08 5.270708e+07 -4.039810e+34 -4.039810e+34
000034 1.225682e+08 3.286727e+08 -4.039810e+34 -4.039810e+34
000035 1.796981e+08 2.424095e+08 -4.039810e+34 -4.039810e+34
... ... ... ... ...
603889 6.820970e+06 1.603828e+08 -4.039810e+34 -4.039810e+34
603898 2.413832e+06 2.107529e+08 -4.039810e+34 -4.039810e+34
603899 5.653920e+07 4.925784e+08 -4.039810e+34 -4.039810e+34
603900 -4.039810e+34 2.144446e+08 -4.039810e+34 -4.039810e+34
603901 6.581622e+06 8.803580e+07 -4.039810e+34 -4.039810e+34
603909 1.898310e+05 5.396724e+07 -4.039810e+34 -4.039810e+34
603918 5.747000e+06 3.381602e+07 -4.039810e+34 -4.039810e+34
603919 -4.039810e+34 2.090605e+08 -4.039810e+34 -4.039810e+34
603928 -4.039810e+34 1.115636e+08 -4.039810e+34 -4.039810e+34
603929 -4.039810e+34 7.947659e+07 -4.039810e+34 -4.039810e+34
603936 2.000000e+05 5.622046e+07 -4.039810e+34 -4.039810e+34
603939 7.600800e+07 2.100408e+08 -4.039810e+34 -4.039810e+34
603955 -4.039810e+34 6.541915e+07 -4.039810e+34 -4.039810e+34
603958 8.297000e+05 9.853183e+07 3.000000e+00 1.389280e+06
603959 1.974217e+06 8.938431e+07 -4.039810e+34 -4.039810e+34
603966 -4.039810e+34 6.442945e+07 -4.039810e+34 -4.039810e+34
603968 4.077678e+07 1.181551e+08 -4.039810e+34 -4.039810e+34
603969 3.383830e+07 1.305681e+08 -4.039810e+34 -4.039810e+34
603977 -4.039810e+34 1.145088e+08 -4.039810e+34 -4.039810e+34
603979 5.604840e+07 1.792680e+08 -4.039810e+34 -4.039810e+34
603986 -4.039810e+34 1.814127e+08 -4.039810e+34 -4.039810e+34
603987 -4.039810e+34 1.016679e+08 -4.039810e+34 -4.039810e+34
603988 1.693000e+05 3.177139e+07 1.000000e+00 1.170000e+05
603989 -4.039810e+34 2.780564e+08 -4.039810e+34 -4.039810e+34
603990 -4.039810e+34 5.574688e+07 -4.039810e+34 -4.039810e+34
603993 1.084705e+10 7.037434e+08 -4.039810e+34 -4.039810e+34
603996 3.500000e+05 8.817671e+07 -4.039810e+34 -4.039810e+34
603997 1.699990e+07 2.242684e+08 -4.039810e+34 -4.039810e+34
603998 6.733272e+07 7.479159e+07 -4.039810e+34 -4.039810e+34
603999 -4.039810e+34 1.010977e+08 -4.039810e+34 -4.039810e+34
[3118 rows x 279 columns]
yssource commented
| 作者 | code | report_date | col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9 | col10 | col11 | col12 | col13 | col14 | col15 | col16 | col17 | col18 | col19 | col20 | col21 | col22 | col23 | col24 | col25 | col26 | col27 | col28 | col29 | col30 | col31 | col32 | col33 | col34 | col35 | col36 | col37 | col38 | col39 | col40 | col41 | col42 | col43 | col44 | col45 | col46 | col47 | col48 | col49 | col50 | col51 | col52 | col53 | col54 | col55 | col56 | col57 | col58 | col59 | col60 | col61 | col62 | col63 | col64 | col65 | col66 | col67 | col68 | col69 | col70 | col71 | col72 | col73 | col74 | col75 | col76 | col77 | col78 | col79 | col80 | col81 | col82 | col83 | col84 | col85 | col86 | col87 | col88 | col89 | col90 | col91 | col92 | col93 | col94 | col95 | col96 | col97 | col98 | col99 | col100 | col101 | col102 | col103 | col104 | col105 | col106 | col107 | col108 | col109 | col110 | col111 | col112 | col113 | col114 | col115 | col116 | col117 | col118 | col119 | col120 | col121 | col122 | col123 | col124 | col125 | col126 | col127 | col128 | col129 | col130 | col131 | col132 | col133 | col134 | col135 | col136 | col137 | col138 | col139 | col140 | col141 | col142 | col143 | col144 | col145 | col146 | col147 | col148 | col149 | col150 | col151 | col152 | col153 | col154 | col155 | col156 | col157 | col158 | col159 | col160 | col161 | col162 | col163 | col164 | col165 | col166 | col167 | col168 | col169 | col170 | col171 | col172 | col173 | col174 | col175 | col176 | col177 | col178 | col179 | col180 | col181 | col182 | col183 | col184 | col185 | col186 | col187 | col188 | col189 | col190 | col191 | col192 | col193 | col194 | col195 | col196 | col197 | col198 | col199 | col200 | col201 | col202 | col203 | col204 | col205 | col206 | col207 | col208 | col209 | col210 | col211 | col212 | col213 | col214 | col215 | col216 | col217 | col218 | col219 | col220 | col221 | col222 | col223 | col224 | col225 | col226 | col227 | col228 | col229 | col230 | col231 | col232 | col233 | col234 | col235 | col236 | col237 | col238 | col239 | col240 | col241 | col242 | col243 | col244 | col245 | col246 | col247 | col248 | col249 | col250 | col251 | col252 | col253 | col254 | col255 | col256 | col257 | col258 | col259 | col260 | col261 | col262 | col263 | col264 | col265 | col266 | col267 | col268 | col269 | col270 | col271 | col272 | col273 | col274 | col275 | col276 | col277 | col278 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| @rainx | 000001 | 20170930 | 1.059999942779541 | 1.059999942779541 | 4.639999866485596 | 11.539999961853027 | 3.2899999618530273 | 8.781999588012695 | -9.199999809265137 | 726502408192.0 | 41327001600.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 18723999744.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 35113000960.0 | 329181003776.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 212000000.0 | 7882999808.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 4579999744.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 22320001024.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 3137480949760.0 | -4.03981033463327e+34 | 10590999552.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 8574000128.0 | 9685000192.0 | 22466000896.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 338306007040.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 60000000.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 2919370063872.0 | 17169999872.0 | 56464998400.0 | 10780999680.0 | -4.03981033463327e+34 | 79709003776.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 218111000576.0 | 3137480949760.0 | 79832997888.0 | 54833000448.0 | 745000000.0 | -4.03981033463327e+34 | 21268000768.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 32820000768.0 | 34000000.0 | 644000000.0 | -4.03981033463327e+34 | 130000000.0 | 24999999488.0 | -4.03981033463327e+34 | 28000000.0 | 89000000.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 24938999808.0 | 5785999872.0 | -4.03981033463327e+34 | 19153000448.0 | 19153000448.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 241456185344.0 | 238846001152.0 | -4.03981033463327e+34 | 11310000128.0 | 19965999104.0 | 365556989952.0 | 396832997376.0 | -157986996224.0 | 403935002624.0 | 24149000192.0 | 4044863.0 | -4.03981033463327e+34 | 4000000.0 | 428088000512.0 | 857000000.0 | 445698015232.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 446554996736.0 | -18467000320.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 721719001088.0 | 644980015104.0 | 5471000064.0 | -4.03981033463327e+34 | 650451025920.0 | 71267999744.0 | -2284999936.0 | -4.03981033463327e+34 | -107471003648.0 | 233414000640.0 | 125942996992.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 1367.18798828125 | 14.380000114440918 | 7.46999979019165 | 25.15999984741211 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -2.5999999046325684 | 2.319999933242798 | 7.883999824523926 | -5.206999778747559 | 6.23199987411499 | -73.88500213623047 | 1.850000023841858 | 0.0 | 0.0 | 0.0 | 113.29000091552734 | 31.31999969482422 | -4.03981033463327e+34 | -4.03981033463327e+34 | 8.781999588012695 | 0.1720000058412552 | 23.989999771118164 | 0.6290000081062317 | -4.03981033463327e+34 | 31.31999969482422 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 19130187776.0 | 24938999808.0 | 24938999808.0 | -4.03981033463327e+34 | 93.05000305175781 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 0.25099998712539673 | -4.03981033463327e+34 | -4.03981033463327e+34 | 6.630000114440918 | 28.639999389648438 | -9.199999809265137 | -4.03981033463327e+34 | -659.9299926757812 | -4.03981033463327e+34 | -19.790000915527344 | -4.03981033463327e+34 | -6.259099960327148 | -4.03981033463327e+34 | -5.4120001792907715 | -824.8679809570312 | -5.034999847412109 | 25760000000.0 | -15184000000.0 | 6599000064.0 | 6618319872.0 | -29806999552.0 | 40087998464.0 | -7706999808.0 | 1640999936.0 | 17170411520.0 | 16917989376.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 331474.0 | 8510493184.0 | 10951613440.0 | 11203861504.0 | 252.0 | 11457491968.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 3.0 | 9697443840.0 | 244.0 | 633340224.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 10951613440.0 | 8258245120.0 | 7610281984.0 | 252421712.0 | 34467999744.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 218111000576.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 5.0 | 1126707456.0 | 23032999936.0 | -4.03981033463327e+34 | -4.03981033463327e+34 |
| @datochan | 000001 | 20170930 | 1.059999942779541 | 1.059999942779541 | 4.639999866485596 | 11.539999961853027 | 3.2899999618530273 | 8.781999588012695 | -9.199999809265137 | 726502408192.0 | 41327001600.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 18723999744.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 35113000960.0 | 329181003776.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 212000000.0 | 7882999808.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 4579999744.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 22320001024.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 3137480949760.0 | -4.03981033463327e+34 | 10590999552.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 8574000128.0 | 9685000192.0 | 22466000896.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 338306007040.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 60000000.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 2919370063872.0 | 17169999872.0 | 56464998400.0 | 10780999680.0 | -4.03981033463327e+34 | 79709003776.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 218111000576.0 | 3137480949760.0 | 79832997888.0 | 54833000448.0 | 745000000.0 | -4.03981033463327e+34 | 21268000768.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 32820000768.0 | 34000000.0 | 644000000.0 | -4.03981033463327e+34 | 130000000.0 | 24999999488.0 | -4.03981033463327e+34 | 28000000.0 | 89000000.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 24938999808.0 | 5785999872.0 | -4.03981033463327e+34 | 19153000448.0 | 19153000448.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 241456185344.0 | 238846001152.0 | -4.03981033463327e+34 | 11310000128.0 | 19965999104.0 | 365556989952.0 | 396832997376.0 | -157986996224.0 | 403935002624.0 | 24149000192.0 | 4044863.0 | -4.03981033463327e+34 | 4000000.0 | 428088000512.0 | 857000000.0 | 445698015232.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 446554996736.0 | -18467000320.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 721719001088.0 | 644980015104.0 | 5471000064.0 | -4.03981033463327e+34 | 650451025920.0 | 71267999744.0 | -2284999936.0 | -4.03981033463327e+34 | -107471003648.0 | 233414000640.0 | 125942996992.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 1367.18798828125 | 14.380000114440918 | 7.46999979019165 | 25.15999984741211 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -2.5999999046325684 | 2.319999933242798 | 7.883999824523926 | -5.206999778747559 | 6.23199987411499 | -73.88500213623047 | 1.850000023841858 | 0.0 | 0.0 | 0.0 | 113.29000091552734 | 31.31999969482422 | -4.03981033463327e+34 | -4.03981033463327e+34 | 8.781999588012695 | 0.1720000058412552 | 23.989999771118164 | 0.6290000081062317 | -4.03981033463327e+34 | 31.31999969482422 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 19130187776.0 | 24938999808.0 | 24938999808.0 | -4.03981033463327e+34 | 93.05000305175781 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 0.25099998712539673 | -4.03981033463327e+34 | -4.03981033463327e+34 | 6.630000114440918 | 28.639999389648438 | -9.199999809265137 | -4.03981033463327e+34 | -659.9299926757812 | -4.03981033463327e+34 | -19.790000915527344 | -4.03981033463327e+34 | -6.259099960327148 | -4.03981033463327e+34 | -5.4120001792907715 | -824.8679809570312 | -5.034999847412109 | 25760000000.0 | -15184000000.0 | 6599000064.0 | 6618319872.0 | -29806999552.0 | 40087998464.0 | -7706999808.0 | 1640999936.0 | 17170411520.0 | 16917989376.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | 331474.0 | 8510493184.0 | 10951613440.0 | 11203861504.0 | 252.0 | 11457491968.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 3.0 | 9697443840.0 | 244.0 | 633340224.0 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | -4.03981033463327e+34 | 10951613440.0 |
yutiansut commented
gpcw20171231.zip,0370b2703a0e23b4f9d87587f4a844cf,49250
gpcw20170930.zip,780bc7c649cdce35567a44dc3700f4ce,2535402
gpcw20170630.zip,5fef91471e01ebf9b5d3628a87d1e73d,2739127
gpcw20170331.zip,a9bcebff37dd1d647f3159596bc2f312,2325626
gpcw20161231.zip,3fb3018c235f6c9d7a1448bdbe72281a,2749415
gpcw20160930.zip,8b629231ee9fad7e7c86f1e683cfb489,2262567
gpcw20160630.zip,f1fbeef0a9f1265f7293e61a1c052016,2422946
gpcw20160331.zip,e53fdbeb3f0cc3feed930652deae97bb,2028529
gpcw20151231.zip,ede67cc93d8375c7363c66c0a8449f82,2697568
gpcw20150930.zip,8a59498d845b3c573bcf0f608c1439d1,2040700
gpcw20150630.zip,bfd003eb549c781a74a247583b242057,2205804
gpcw20150331.zip,5dca659f36b9d44faaf0eb8da0fc6120,1913118
gpcw20141231.zip,3185fd839513964bdc9c380b3b246809,2626605
gpcw20140930.zip,8f5f171f018ed7d2ee4b4da68451de28,1855901
gpcw20140630.zip,268a8b938819223942bd0cb1fb372bda,1989233
gpcw20140331.zip,09e4ff74d509586969791c9a6e2e2722,1704587
gpcw20131231.zip,78a611190bf6cdb367592dc45d504ea5,2305457
gpcw20130930.zip,e2c9f1ce65e6a9dae4c7c8ca93b4cb0a,1718141
gpcw20130630.zip,6cfdb2dd1297859c638713a17d420d41,1870549
gpcw20130331.zip,8fa5e20852e3a4e0458bb93887551e89,1621352
gpcw20121231.zip,996c3a553f8349d1e334ede1738d1aa1,2088246
gpcw20120930.zip,120b871629e284be2dc9fef59b025bca,1689447
gpcw20120630.zip,b1ab19d824ab8ddc187ee500ec0fefb6,1824108
gpcw20120331.zip,3ee83b4b2bc5016b664afea993bb880a,1573614
gpcw20111231.zip,c4466cc28a87f2d37854bbc114001fe8,1947163
gpcw20110930.zip,12d638759e3a769cd82ed7401c931cb2,1582830
gpcw20110630.zip,567087aded8c3f7f8f0b26e1e9ca175a,1715825
gpcw20110331.zip,be4ba9a367da0d02c6e8dae5656a2cd5,1423437
gpcw20101231.zip,089b6d00d3abe8bc157b759992eddd50,1846206
gpcw20100930.zip,89f0683238cb51fe89fcc78d3bfc2e78,1403246
gpcw20100630.zip,8d3816187702ce66af3ac077f0aeb122,1496502
gpcw20100331.zip,c460a76eecaf28d7520b49a21e8af276,1198928
gpcw20091231.zip,964248b9eb22b9324bfbcb5d502eac78,1770408
gpcw20090930.zip,9316f36bf2e2e8b0551c533240fb165a,1157316
gpcw20090630.zip,7a9610afca33e8bf9f87f00ecc2969e2,1243397
gpcw20090331.zip,23dbc8aae126311b8159de2e5693120d,1018844
gpcw20081231.zip,950ae1beda669feab8468cdd0d652f25,1666585
gpcw20080930.zip,e2ff6214cddc574b2c539168e7da84e7,1064708
gpcw20080630.zip,00d37361ace868052229ff38dc970ee3,1152835
gpcw20080331.zip,fa1241f5fd1fefc22a050e2cc965ddc0,1009321
gpcw20071231.zip,4405c6f321f93deb29980f5c7cab8858,1482394
gpcw20070930.zip,b18d090fd0234a382ba73d30f11072d0,1013119
gpcw20070630.zip,31dfa350584ea2ff3e0a128e0aae6d00,1082990
gpcw20070331.zip,2d4cda8f67d5c84f262a8426d2297c31,918832
gpcw20061231.zip,e07a972a31c114054b70553fbe937ea9,1228449
gpcw20060930.zip,7ab160e59137a994427e4fc1b147bc91,1005626
gpcw20060630.zip,30d2b267d45b64958efbcb88fd2a16a3,1005613
gpcw20060331.zip,46831fb0d7d8d4ddf3d52176835b5405,906006
gpcw20051231.zip,f200bef4b1a91643471da6e47a9c4615,1122683
gpcw20050930.zip,c34e33fd9cae02e9fc9d8353bf151266,947357
gpcw20050630.zip,9ffd4fb8bb516bee65599a95f1146a74,948868
gpcw20050331.zip,3c95614696ae085c6c5371f0beeafcac,875715
gpcw20041231.zip,ba865efe5b10e9ee5fd2630c977c8ad5,1076263
gpcw20040930.zip,c6bf79e9964a7b8d49f9ccb1387d741b,933128
gpcw20040630.zip,39d34e7972b4b7b2c800bf989ae5a279,934336
gpcw20040331.zip,229def2ea68baf3dc656168559ce3497,832181
gpcw20031231.zip,4b57f61d228d886a58085531cf689cf6,998641
gpcw20030930.zip,6e7ca8dc7ab7774dbbe163874eecbefb,814054
gpcw20030630.zip,5b5ae00c6060a34b9075740a3175433a,814791
gpcw20030331.zip,efa4392026088557f01011cbfa093105,735871
gpcw20021231.zip,a7b481bec8af9b6ab45ef4bcf023d140,864807
gpcw20020930.zip,2cda09e4da3dbcdc56b531db9b53f815,536929
gpcw20020630.zip,8cdefd03d314209d30cb2a86e8cdcbb8,762128
gpcw20020331.zip,2b46dd33c9a0fb34b41bc2e5fc7b90fd,467914
gpcw20011231.zip,64344b9b9ed909361614ff2a4a76918b,818675
gpcw20010930.zip,093020158eea8b8b8f4105a94c599039,46969
gpcw20010630.zip,630281e616421705d0bb4478ecbcb664,692233
gpcw20010331.zip,a4900d83762dd2dd7f95171a310062f5,7405
gpcw20001231.zip,530e2cf0673f4b5521bce6adfe69530e,773697
gpcw20000930.zip,741349765e1409abbe89e5bce393676e,658
gpcw20000630.zip,b96b3892ae35aab29f4a6311486913d2,646543
gpcw19991231.zip,16a2ea997c6a4d2c1eec1ad98af814d5,717163
gpcw19990630.zip,d4405d5ac3b18c14f069aa94a66fe302,446209
gpcw19981231.zip,641ccaef01ab9a151cae7304da7dc9b6,644643
gpcw19980630.zip,53e0591d6fa6d98cf0aab75110bb28b0,388511
gpcw19971231.zip,316ce733f2a4f6b21c7865f94eee01c8,434680
gpcw19970630.zip,6eb5d8e5f43f7b19d756f0a2d91371f5,196525
gpcw19961231.zip,bfd59d42f9b6651861e84c483edb499b,363568
gpcw19960630.zip,18023e9f84565323874e8e1dbdfb2adb,122145
这个很重要 留存
rainx commented
@yutiansut @yssource @datochan 因为我看到官方的文档有更新，然后对照了一下字段数量，感觉多了一些，对照了具体代码 header 里面的一个字段，感觉有点像字节长度么，然后除以 sizeof(float) , 得出来的字段数，我不确定是否准确，但是感觉是差不多的，不过我看官方文档只更新到 276 个，不知道后面的2个是否有实际的用途
yssource commented
对照中文字段说明和实际数值, 感觉那些重复的数值不太对. 比如 col256 ~ col263
rainx commented
这个 float -4.03981033463327e+34 对应二进制 f8f8 f8f8, 感觉是它这里设定的一个特殊的数值，代表这个字段没有对应值的感觉..
In [3]: struct.pack("f", -4.03981033463327e+34)
Out[3]: b'\xf8\xf8\xf8\xf8'另外，我把代码更新到主干了 ,并提交了1.65版本
文档简单写了一下
yutiansut commented
直接下载到本地版本 @yssource @datochan @rainx
import requests
from pytdx.reader.history_financial_reader import HistoryFinancialReader
from pytdx.crawler.history_financial_crawler import HistoryFinancialCrawler, HistoryFinancialListCrawler
"""
参见PYTDX 1.65
"""
FINANCIAL_URL = 'http://down.tdx.com.cn:8001/fin/gpcw.txt'
def get_filename():
"""
get_filename
"""
return [l[0] for l in [line.strip().split(",") for line in requests.get(FINANCIAL_URL).text.strip().split('\n')]]
def download():
result = get_filename()
for item in result:
r = requests.get('http://down.tdx.com.cn:8001/fin/{}'.format(item))
with open(item, "wb") as code:
code.write(r.content)datochan commented
@rainx @yssource @yutiansut
财报会一直更新的，哪怕是90年代的财报也在不停更新的。
我的程序是每次都通过http://down.tdx.com.cn:8001/fin/gpcw.txt这个列表检查文件hash是否有变化，有变化就更新到本地。
我上面贴的是我2016年的笔记，里面的字段比较久，少一些都正常的。
rainx commented
@yutiansut @datochan 春节没碰电脑，刚看到，
的确，主要是考虑到更新的问题，本地可以维护一个历史信息的列表，所以才进行下载，如果不加下载参数，我默认使用临时文件的形式来维护的
datochan commented
@rainx 我是本地维护zip文件，代码直接操作zip文件查询财务数据。每次要更新财务数据的时候，就对这些zip文件计算下md5的hash值，与 http://down.tdx.com.cn:8001/fin/gpcw.txt 列表中文件的hash对比，有变化就更新，没变化就不更新。不需要临时文件或者加什么参数的。
rainx commented
嗯，这样更新比较好，可以减少下载次数
2496206029 commented
导出的数据很多是科学计算法，能否导出是普通的数字？
2496206029 commented
导出的数据很多是科学计算法，能否导出是普通的数字？比如有很多数据不知道是不是重复还是什么问题，数据都是-4.03981033463327e+30
gzadigo commented
现在已经有284列了，持续扩张中，是不是现有的数据含义保持不变？否则用起来也很痛苦的
gzadigo commented
研究了下通达信财务数据，有个问题，那些没有的数据，他默认填了0，但是也有真实情况下就是0的情况吧，这个容易混淆，不过关系应该不大。有一个比较麻烦的是，他有些数据的单位是万元，有的是元，这个就不好处理了，也不知道他会不会变化
yutiansut commented
没有数据 是一个很大的负数吧
testttt0 commented
这个数据源好像停更了
chinobing commented
@yutiansut 财务数据的文件包好像好几个月都没有更新了， 知道啥情况不？
chinobing commented
年度报告最迟4月份要出，估计要等到4月底
godietion commented
期待更新中...
datochan commented
年度报告最迟4月份要出，估计要等到4月底
4月底也不会出的，官网针对性的升级了。不允许这样使用财报数据了，大家再想别的办法吧~
asdfzxh8 commented
我通过 @JaysonAlbert 的 rq-data 也拿到了 ricequant 的 历史财务数据. 现在 如果能通过像 @datochan 这样拿到 tdx 的财务数据, 那太开心了.
不存在，数据无影响
wisfern commented
我也发现财务数据不再更新了。
tfangz888 commented
打开通达信金融终端，可以看到最新的文件为20180930。这说明通达信官方并没有新的文件产生。至于为何2019年的没有产生，就不清楚了。