历史财务数据

[yssource]

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

[yssource]

#43

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

[yutiansut]

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

[datochan]

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

数据获取

财务数据列表

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]

卧槽 帅啊

[yutiansut]

@yssource 666

[yutiansut]

@rainx

[yssource]

@datochan @yutiansut 💥 💥 👍 👏

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

[rainx]

@yutiansut @datochan cool

[rainx]

@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]

我尝试一下

[yutiansut]

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

完整的结果

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]

• @rainx @datochan: 的解析结果都是 一致对的, 但是 @rainx 解析的数据多一些.

作者	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