[go: nahoru, domu]

Skip to content
This repository has been archived by the owner on Apr 15, 2020. It is now read-only.

历史财务数据 #133

Closed
yssource opened this issue Jan 12, 2018 · 39 comments
Closed

历史财务数据 #133

yssource opened this issue Jan 12, 2018 · 39 comments

Comments

@yssource
Copy link

@rainx @yutiansut @JaysonAlbert
get_finance_info, 只能拿到当前的财务.
有没有办法拿到历史的财务数据呢?
谢谢.

@yssource
Copy link
Author
yssource commented Jan 12, 2018

#43

这个办法, 应该也能拿到 一些历史数据, 再计算出其他数据.
如果 get_finance_info 提供一个 datetime range 参数, 拿到历史数据 就 更方便.

@yutiansut
Copy link
Collaborator

这个是tdx的问题 没办法 考虑其他办法吧

@rainx rainx closed this as completed Jan 17, 2018
@datochan
Copy link
datochan commented Feb 12, 2018

我这边的历史财务数据是这样拿的, 看看是否有帮助,这里直接贴我的笔记:

数据获取

财务数据列表

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
Copy link
Collaborator

卧槽 帅啊

@yutiansut
Copy link
Collaborator

@yssource 666

@yutiansut
Copy link
Collaborator

@rainx

@yssource
Copy link
Author

@datochan @yutiansut 💥 💥 👍 👏

先祝贺, 我也 ollydbg 一下, 发现了问题再给你们 feedback

@rainx
Copy link
Owner
rainx commented Feb 12, 2018

@yutiansut @datochan cool

@rainx
Copy link
Owner
rainx commented Feb 13, 2018

@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
Copy link
Collaborator

我尝试一下

@yutiansut
Copy link
Collaborator

咦 为啥我解析出来有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
Copy link
Collaborator

完整的结果

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
Copy link
Author
作者 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
Copy link
Collaborator
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
Copy link
Owner
rainx commented Feb 14, 2018

@yutiansut @yssource @datochan 因为我看到官方的文档有更新,然后对照了一下字段数量,感觉多了一些,对照了具体代码 header 里面的一个字段,感觉有点像字节长度么,然后除以 sizeof(float) , 得出来的字段数,我不确定是否准确,但是感觉是差不多的,不过我看官方文档只更新到 276 个,不知道后面的2个是否有实际的用途

@yutiansut
Copy link
Collaborator

@rainx 而且有重复的

@yssource
Copy link
Author

对照中文字段说明和实际数值, 感觉那些重复的数值不太对. 比如 col256 ~ col263

@rainx
Copy link
Owner
rainx commented Feb 14, 2018

这个 float -4.03981033463327e+34 对应二进制 f8f8 f8f8, 感觉是它这里设定的一个特殊的数值,代表这个字段没有对应值的感觉..

In [3]: struct.pack("f", -4.03981033463327e+34)
Out[3]: b'\xf8\xf8\xf8\xf8'

另外,我把代码更新到主干了 ,并提交了1.65版本

文档简单写了一下

https://rainx.gitbooks.io/pytdx/content/pytdx_crawler.html

@yutiansut
Copy link
Collaborator
yutiansut commented Feb 14, 2018

我建议是 有一种直接 request.get()然后就直接parse 不用先下载到本地 @rainx

@yutiansut
Copy link
Collaborator

直接下载到本地版本 @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
Copy link

@rainx @yssource @yutiansut
财报会一直更新的,哪怕是90年代的财报也在不停更新的。
我的程序是每次都通过http://down.tdx.com.cn:8001/fin/gpcw.txt这个列表检查文件hash是否有变化,有变化就更新到本地。

我上面贴的是我2016年的笔记,里面的字段比较久,少一些都正常的。

@rainx
Copy link
Owner
rainx commented Feb 22, 2018

@yutiansut @datochan 春节没碰电脑,刚看到,

的确,主要是考虑到更新的问题,本地可以维护一个历史信息的列表,所以才进行下载,如果不加下载参数,我默认使用临时文件的形式来维护的

@datochan
Copy link

@rainx 我是本地维护zip文件,代码直接操作zip文件查询财务数据。每次要更新财务数据的时候,就对这些zip文件计算下md5的hash值,与 http://down.tdx.com.cn:8001/fin/gpcw.txt 列表中文件的hash对比,有变化就更新,没变化就不更新。不需要临时文件或者加什么参数的。

@rainx
Copy link
Owner
rainx commented Feb 22, 2018

嗯,这样更新比较好,可以减少下载次数

@2496206029
Copy link

导出的数据很多是科学计算法,能否导出是普通的数字?

@2496206029
Copy link

导出的数据很多是科学计算法,能否导出是普通的数字?比如有很多数据不知道是不是重复还是什么问题,数据都是-4.03981033463327e+30

@gzadigo
Copy link
gzadigo commented Jan 25, 2019

现在已经有284列了,持续扩张中,是不是现有的数据含义保持不变?否则用起来也很痛苦的

@yutiansut
Copy link
Collaborator

已经自动扩展了 @gzadigo

@gzadigo
Copy link
gzadigo commented Feb 11, 2019

研究了下通达信财务数据,有个问题,那些没有的数据,他默认填了0,但是也有真实情况下就是0的情况吧,这个容易混淆,不过关系应该不大。有一个比较麻烦的是,他有些数据的单位是万元,有的是元,这个就不好处理了,也不知道他会不会变化

@yutiansut
Copy link
Collaborator

没有数据 是一个很大的负数吧

@testttt0
Copy link

这个数据源好像停更了

@yutiansut
Copy link
Collaborator

@testttt0 是的 通达信的软件上2018年年报也没 不过确实部分公司年报没出完

@chinobing
Copy link

@yutiansut 财务数据的文件包好像好几个月都没有更新了, 知道啥情况不?

@chinobing
Copy link

年度报告最迟4月份要出,估计要等到4月底

@godietion
Copy link

期待更新中...

@datochan
Copy link

年度报告最迟4月份要出,估计要等到4月底

4月底也不会出的,官网针对性的升级了。不允许这样使用财报数据了,大家再想别的办法吧~

@asdfzxh8
Copy link

我通过 @JaysonAlbert 的 rq-data 也拿到了 ricequant 的 历史财务数据. 现在 如果能通过像 @datochan 这样拿到 tdx 的财务数据, 那太开心了.

不存在,数据无影响

@wisfern
Copy link
wisfern commented May 5, 2019

我也发现财务数据不再更新了。

@tfangz888
Copy link

打开通达信金融终端,可以看到最新的文件为20180930。这说明通达信官方并没有新的文件产生。至于为何2019年的没有产生,就不清楚了。

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests