9 IH2510 20250825 2958.400 ... 2982.800 2928.000 IH
10 IH2512 20250825 2960.000 ... 2986.000 2931.000 IH
11 IH2603 20250825 2965.000 ... 2988.200 2932.800 IH
12 IM2509 20250825 7400.000 ... 7423.000 7319.600 IM
13 IM2510 20250825 7361.200 ... 7374.000 7272.600 IM
14 IM2512 20250825 7242.000 ... 7273.600 7159.200 IM
15 IM2603 20250825 7081.200 ... 7121.800 7009.800 IM
16 T2509 20250825 107.765 ... 108.125 107.905 T
17 T2512 20250825 107.580 ... 107.925 107.655 T
18 T2603 20250825 107.355 ... 107.670 107.405 T
19 TF2509 20250825 105.460 ... 105.575 105.470 TF
20 TF2512 20250825 105.300 ... 105.515 105.370 TF
21 TF2603 20250825 105.350 ... 105.360 105.285 TF
22 TL2509 20250825 116.290 ... 117.150 116.440 TL
23 TL2512 20250825 115.680 ... 116.720 115.900 TL
24 TL2603 20250825 115.390 ... 116.370 115.540 TL
25 TS2509 20250825 102.318 ... 102.334 102.318 TS
26 TS2512 20250825 102.312 ... 102.390 102.318 TS
27 TS2603 20250825 102.278 ... 102.316 102.298 TS
[28 rows x 12 columns]
2025-08-27 18:32:15,168 - future_1d - INFO - ak.get_cffex_daily('2025-08-25') done
symbol date open high ... turnover settle pre_settle variety
0 SC2509 20250825 487 488.7 ... 57692.29 486.8 485.6 SC
1 SC2510 20250825 494 495.8 ... 5075120.08 493.5 491 SC
2 SC2511 20250825 492.5 494.1 ... 576690 491.9 489.6 SC
3 SC2512 20250825 489.5 491.5 ... 215543.48 489.5 487.8 SC
4 SC2601 20250825 488.4 489.9 ... 25333.7 488.1 486.8 SC
5 SC2602 20250825 486.6 488.4 ... 4236.7 486.9 486.5 SC
6 SC2603 20250825 486.2 487.6 ... 6169.38 485.7 485.8 SC
7 SC2604 20250825 484.9 488.5 ... 5292.01 485.5 484.4 SC
8 SC2605 20250825 484.1 485.1 ... 3623.98 483.1 483.7 SC
9 SC2606 20250825 482.8 484.9 ... 5366.02 483.4 483.3 SC
10 SC2607 20250825 482.6 482.6 ... 144.35 481.1 482.8 SC
11 SC2608 20250825 482.9 483.2 ... 578.71 482.2 482 SC
12 SC2609 20250825 481.2 481.2 ... 288.44 480.7 480.6 SC
13 SC2612 20250825 483.6 483.7 ... 193.45 483.6 481.2 SC
14 SC2703 20250825 478.9 478.9 ... 47.89 478.9 481.1 SC
15 SC2706 20250825 ... 0 481.1 481.1 SC
16 SC2709 20250825 480 482.5 ... 1152.28 480.1 475 SC
17 SC2712 20250825 477.2 481 ... 958.49 479.2 478.4 SC
18 SC2803 20250825 479.5 479.5 ... 47.95 479.5 469.9 SC
19 SC2806 20250825 469.3 475.9 ... 896.63 471.9 467.9 SC
21 LU2509 20250825 3440 3548 ... 1173.787 3452 3488 LU
22 LU2510 20250825 3504 3532 ... 82723.748 3511 3469 LU
23 LU2511 20250825 3500 3531 ... 434045.122 3521 3467 LU
24 LU2512 20250825 3489 3521 ... 47729.7 3508 3453 LU
25 LU2601 20250825 3461 3499 ... 12132.053 3488 3433 LU
26 LU2602 20250825 3453 3476 ... 86.634 3465 3423 LU
27 LU2603 20250825 3445 3469 ... 38.042 3458 3420 LU
28 LU2604 20250825 3447 3463 ... 48.372 3455 3418 LU
29 LU2605 20250825 3409 3460 ... 199.719 3443 3405 LU
30 LU2606 20250825 3427 3451 ... 24.07 3438 3407 LU
31 LU2607 20250825 3425 3448 ... 48.084 3434 3407 LU
32 LU2608 20250825 3426 3446 ... 27.482 3435 3401 LU
34 NR2509 20250825 12500 12785 ... 31928.135 12665 12455 NR
35 NR2510 20250825 12570 12845 ... 1079578.47 12720 12515 NR
36 NR2511 20250825 12580 12860 ... 275391.085 12750 12540 NR
37 NR2512 20250825 12620 12880 ... 11771.35 12790 12565 NR
38 NR2601 20250825 12650 12910 ... 96347.26 12805 12595 NR
39 NR2602 20250825 12645 12895 ... 1214.065 12775 12570 NR
40 NR2603 20250825 12725 12885 ... 318.415 12735 12600 NR
41 NR2604 20250825 12770 12775 ... 38.285 12760 12650 NR
42 NR2605 20250825 12915 12915 ... 12.915 12915 12605 NR
43 NR2606 20250825 ... 0 12745 12745 NR
44 NR2607 20250825 ... 0 12780 12650 NR
45 NR2608 20250825 ... 0 12780 12650 NR
47 BC2509 20250825 69780 70880 ... 115669.915 70290 69810 BC
48 BC2510 20250825 69880 70940 ... 48212.825 70380 69840 BC
49 BC2511 20250825 70490 70650 ... 141.07 70530 69880 BC
50 BC2512 20250825 ... 0 69780 69780 BC
51 BC2601 20250825 ... 0 70100 70100 BC
52 BC2602 20250825 ... 0 70100 70100 BC
53 BC2603 20250825 ... 0 70100 70100 BC
54 BC2604 20250825 ... 0 70100 70100 BC
55 BC2605 20250825 ... 0 69800 69800 BC
56 BC2606 20250825 ... 0 69790 69790 BC
57 BC2607 20250825 ... 0 69370 69370 BC
58 BC2608 20250825 ... 0 69370 69370 BC
60 EC2508 20250825 2123 2136 ... 1469.589 2129.8 2125 EC
61 EC2510 20250825 1323 1379.4 ... 266069.164 1356.3 1324 EC
62 EC2512 20250825 1680 1711.6 ... 61630.013 1691 1688.2 EC
63 EC2602 20250825 1480.1 1521 ... 7985.4335 1492.6 1485.3 EC
64 EC2604 20250825 1287.9 1309.8 ... 8077.539 1294.4 1275.8 EC
65 EC2606 20250825 1446 1470 ... 1015.9595 1451.3 1451.2 EC
68 SC_TAS2510 20250825 ... SC_TAS
69 SC_TAS2511 20250825 ... SC_TAS
70 SC_TAS2512 20250825 ... SC_TAS
[65 rows x 12 columns]
2025-08-27 18:32:15,235 - future_1d - INFO - ak.get_ine_daily('2025-08-25') done
2025-08-27 18:32:17,074 - future_1d - INFO - 写入 815 条修改数据到 future_daily_modified 表
2025-08-27 18:32:17,090 - future_1d - INFO - save future_daily 2025-08-25 completed
symbol date open high ... turnover settle pre_settle variety
0 AP510 20250826 8141.0 8186.0 ... 310738.07 8158.0 8143.0 AP
1 AP511 20250826 7979.0 7986.0 ... 2705.43 7957.0 7947.0 AP
2 AP512 20250826 7998.0 7998.0 ... 223.27 7974.0 7960.0 AP
3 AP601 20250826 8035.0 8078.0 ... 71069.61 8061.0 8058.0 AP
4 AP603 20250826 7959.0 7959.0 ... 31.83 7959.0 7959.0 AP
5 AP604 20250826 7986.0 7986.0 ... 79.74 7974.0 7970.0 AP
6 AP605 20250826 8032.0 8050.0 ... 434.00 8037.0 8041.0 AP
7 CF509 20250826 13845.0 13845.0 ... 157607.15 13810.0 13815.0 CF
8 CF511 20250826 14045.0 14070.0 ... 190269.14 14040.0 14020.0 CF
9 CF601 20250826 14135.0 14155.0 ... 1078975.90 14120.0 14115.0 CF
10 CF603 20250826 14085.0 14105.0 ... 894.34 14085.0 14060.0 CF
11 CF605 20250826 14095.0 14105.0 ... 50074.62 14075.0 14065.0 CF
12 CF607 20250826 14095.0 14100.0 ... 155.00 14090.0 14075.0 CF
13 CJ509 20250826 10120.0 10160.0 ... 6556.05 10100.0 10175.0 CJ
14 CJ512 20250826 11285.0 11340.0 ... 6622.27 11290.0 11285.0 CJ
15 CJ601 20250826 11385.0 11450.0 ... 489734.02 11395.0 11395.0 CJ
16 CJ603 20250826 11440.0 11475.0 ... 3621.67 11425.0 11425.0 CJ
17 CJ605 20250826 11530.0 11580.0 ... 48929.36 11540.0 11535.0 CJ
18 CJ607 20250826 11685.0 11730.0 ... 573.15 11695.0 11705.0 CJ
19 CY509 20250826 20115.0 20150.0 ... 332.04 20125.0 20105.0 CY
20 CY510 20250826 0.0 0.0 ... 0.00 19705.0 19705.0 CY
21 CY511 20250826 20155.0 20205.0 ... 54698.35 20160.0 20160.0 CY
22 CY512 20250826 0.0 0.0 ... 0.00 19905.0 19905.0 CY
23 CY601 20250826 20195.0 20195.0 ... 494.01 20165.0 20160.0 CY
24 CY602 20250826 0.0 0.0 ... 0.00 20015.0 20015.0 CY
25 CY603 20250826 0.0 0.0 ... 0.00 20295.0 20295.0 CY
26 CY604 20250826 0.0 0.0 ... 0.00 20030.0 20030.0 CY
27 CY605 20250826 20395.0 20395.0 ... 10.20 20395.0 20385.0 CY
28 CY606 20250826 0.0 0.0 ... 0.00 20010.0 20010.0 CY
29 CY607 20250826 0.0 0.0 ... 0.00 20205.0 20205.0 CY
30 CY608 20250826 0.0 0.0 ... 0.00 20295.0 20375.0 CY
31 FG509 20250826 1004.0 1008.0 ... 224144.38 995.0 1007.0 FG
32 FG510 20250826 1111.0 1114.0 ... 90061.11 1099.0 1110.0 FG
33 FG511 20250826 1098.0 1102.0 ... 136272.74 1088.0 1099.0 FG
34 FG512 20250826 1199.0 1200.0 ... 71599.93 1190.0 1197.0 FG
35 FG601 20250826 1189.0 1194.0 ... 3751837.04 1183.0 1194.0 FG
36 FG602 20250826 1239.0 1243.0 ... 2217.61 1235.0 1245.0 FG
37 FG603 20250826 1242.0 1245.0 ... 1521.44 1235.0 1247.0 FG
38 FG604 20250826 1287.0 1289.0 ... 473.59 1280.0 1293.0 FG
39 FG605 20250826 1281.0 1283.0 ... 60363.98 1271.0 1286.0 FG
40 FG606 20250826 1311.0 1313.0 ... 717.14 1304.0 1312.0 FG
41 FG607 20250826 1302.0 1302.0 ... 959.32 1293.0 1303.0 FG
42 FG608 20250826 1325.0 1325.0 ... 322.07 1320.0 1325.0 FG
43 JR509 20250826 0.0 0.0 ... 0.00 2662.0 2662.0 JR
44 JR511 20250826 0.0 0.0 ... 0.00 2662.0 2662.0 JR
45 JR601 20250826 0.0 0.0 ... 0.00 2662.0 2662.0 JR
46 JR603 20250826 0.0 0.0 ... 0.00 2662.0 2662.0 JR
47 JR605 20250826 0.0 0.0 ... 0.00 2662.0 2662.0 JR
48 JR607 20250826 0.0 0.0 ... 0.00 2662.0 2662.0 JR
49 LR509 20250826 0.0 0.0 ... 0.00 2360.0 2360.0 LR
50 LR511 20250826 0.0 0.0 ... 0.00 2360.0 2360.0 LR
51 LR601 20250826 0.0 0.0 ... 0.00 2360.0 2360.0 LR
52 MA509 20250826 2310.0 2312.0 ... 59181.07 2295.0 2306.0 MA
53 MA510 20250826 2342.0 2349.0 ... 44671.31 2330.0 2341.0 MA
54 MA511 20250826 2368.0 2373.0 ... 78705.15 2352.0 2365.0 MA
55 MA512 20250826 2406.0 2412.0 ... 24133.67 2393.0 2403.0 MA
56 MA601 20250826 2425.0 2430.0 ... 902158.84 2413.0 2423.0 MA
57 MA602 20250826 2433.0 2433.0 ... 130.45 2416.0 2432.0 MA
58 MA603 20250826 2434.0 2434.0 ... 94.19 2415.0 2429.0 MA
59 MA604 20250826 2415.0 2415.0 ... 31.26 2404.0 2416.0 MA
60 MA605 20250826 2401.0 2407.0 ... 34799.71 2394.0 2400.0 MA
61 MA606 20250826 2416.0 2416.0 ... 24.04 2404.0 2406.0 MA
62 MA607 20250826 2409.0 2409.0 ... 105.61 2400.0 2408.0 MA
63 MA608 20250826 2403.0 2408.0 ... 21.60 2400.0 2409.0 MA
64 OI509 20250826 10002.0 10030.0 ... 127501.72 10001.0 9986.0 OI
65 OI511 20250826 9953.0 9995.0 ... 642725.82 9961.0 9948.0 OI
66 OI601 20250826 9905.0 9934.0 ... 2964053.66 9897.0 9890.0 OI
67 OI603 20250826 9819.0 9850.0 ... 2638.20 9807.0 9809.0 OI
68 OI605 20250826 9725.0 9763.0 ... 35872.85 9724.0 9720.0 OI
69 OI607 20250826 9701.0 9731.0 ... 281.03 9691.0 9684.0 OI
70 PF509 20250826 6480.0 6558.0 ... 7063.63 6504.0 6492.0 PF
71 PF510 20250826 6606.0 6672.0 ... 539539.77 6624.0 6604.0 PF
72 PF511 20250826 6606.0 6658.0 ... 233675.02 6612.0 6596.0 PF
73 PF512 20250826 6576.0 6640.0 ... 91509.86 6590.0 6582.0 PF
74 PF601 20250826 6586.0 6634.0 ... 24432.27 6596.0 6576.0 PF
75 PF602 20250826 6582.0 6606.0 ... 79.14 6596.0 6582.0 PF
76 PF603 20250826 6598.0 6646.0 ... 82.68 6614.0 6598.0 PF
77 PF604 20250826 6624.0 6702.0 ... 79.74 6646.0 6636.0 PF
78 PF605 20250826 6640.0 6692.0 ... 103.19 6658.0 6654.0 PF
79 PF606 20250826 6678.0 6678.0 ... 16.70 6678.0 6670.0 PF
80 PF607 20250826 6678.0 6678.0 ... 3.34 6678.0 6676.0 PF
81 PF608 20250826 0.0 0.0 ... 0.00 6662.0 6662.0 PF
82 PK510 20250826 7988.0 8082.0 ... 102350.12 8038.0 7976.0 PK
83 PK511 20250826 7790.0 7844.0 ... 270531.01 7812.0 7778.0 PK
84 PK512 20250826 7850.0 7868.0 ... 49526.52 7842.0 7824.0 PK
85 PK601 20250826 7902.0 7920.0 ... 27720.63 7898.0 7876.0 PK
86 PK603 20250826 7892.0 7914.0 ... 39.53 7906.0 7894.0 PK
87 PK604 20250826 7900.0 7912.0 ... 27.66 7902.0 7890.0 PK
88 PK605 20250826 7896.0 7920.0 ... 2307.81 7904.0 7892.0 PK
89 PL601 20250826 6500.0 6501.0 ... 14481.85 6482.0 6491.0 PL
90 PL602 20250826 6530.0 6538.0 ... 130.56 6528.0 6533.0 PL
91 PL603 20250826 6501.0 6516.0 ... 91.00 6500.0 6527.0 PL
92 PL604 20250826 0.0 0.0 ... 0.00 6498.0 6498.0 PL
93 PL605 20250826 6385.0 6400.0 ... 51.13 6391.0 6383.0 PL
94 PL606 20250826 0.0 0.0 ... 0.00 6479.0 6479.0 PL
95 PL607 20250826 0.0 0.0 ... 0.00 6512.0 6512.0 PL
96 PL608 20250826 0.0 0.0 ... 0.00 6500.0 6500.0 PL
97 PM509 20250826 0.0 0.0 ... 0.00 3122.0 3122.0 PM
98 PM511 20250826 0.0 0.0 ... 0.00 3122.0 3122.0 PM
99 PM601 20250826 0.0 0.0 ... 0.00 3122.0 3122.0 PM
100 PM603 20250826 0.0 0.0 ... 0.00 3122.0 3122.0 PM
101 PM605 20250826 0.0 0.0 ... 0.00 3122.0 3122.0 PM
102 PM607 20250826 0.0 0.0 ... 0.00 3122.0 3122.0 PM
103 PR509 20250826 5898.0 5906.0 ... 7617.03 5892.0 5906.0 PR
104 PR510 20250826 6044.0 6094.0 ... 190747.61 6052.0 6040.0 PR
105 PR511 20250826 6056.0 6104.0 ... 692223.76 6058.0 6050.0 PR
106 PR512 20250826 6048.0 6100.0 ... 314010.49 6052.0 6052.0 PR
107 PR601 20250826 6062.0 6100.0 ... 9156.29 6062.0 6056.0 PR
108 PR602 20250826 0.0 0.0 ... 0.00 6070.0 6070.0 PR
109 PR603 20250826 6072.0 6110.0 ... 27.41 6092.0 6088.0 PR
110 PR604 20250826 6068.0 6122.0 ... 73.04 6088.0 6116.0 PR
111 PR605 20250826 6070.0 6116.0 ... 54.85 6094.0 6114.0 PR
112 PR606 20250826 0.0 0.0 ... 0.00 6080.0 6080.0 PR
113 PR607 20250826 0.0 0.0 ... 0.00 6082.0 6082.0 PR
114 PR608 20250826 0.0 0.0 ... 0.00 6080.0 6080.0 PR
115 PX509 20250826 7028.0 7134.0 ... 24655.50 7048.0 7030.0 PX
116 PX510 20250826 7002.0 7194.0 ... 418737.80 7088.0 7024.0 PX
117 PX511 20250826 6970.0 7154.0 ... 1558283.36 7050.0 6982.0 PX
118 PX512 20250826 6940.0 7068.0 ... 98818.19 6982.0 6946.0 PX
119 PX601 20250826 6908.0 7016.0 ... 210696.78 6954.0 6912.0 PX
120 PX602 20250826 6924.0 6986.0 ... 66.04 6952.0 6922.0 PX
121 PX603 20250826 6922.0 6990.0 ... 17.35 6940.0 6918.0 PX
122 PX604 20250826 6904.0 6960.0 ... 114.56 6944.0 6882.0 PX
123 PX605 20250826 6892.0 6992.0 ... 409.93 6948.0 6880.0 PX
124 PX606 20250826 6878.0 6890.0 ... 13.77 6886.0 6878.0 PX
125 PX607 20250826 6848.0 6922.0 ... 13.75 6878.0 6854.0 PX
126 PX608 20250826 6818.0 6818.0 ... 3.41 6818.0 6842.0 PX
127 RI509 20250826 0.0 0.0 ... 0.00 2479.0 2479.0 RI
128 RI511 20250826 0.0 0.0 ... 0.00 2479.0 2479.0 RI
129 RI601 20250826 0.0 0.0 ... 0.00 2479.0 2479.0 RI
130 RI603 20250826 0.0 0.0 ... 0.00 2479.0 2479.0 RI
131 RI605 20250826 0.0 0.0 ... 0.00 2479.0 2479.0 RI
132 RI607 20250826 0.0 0.0 ... 0.00 2479.0 2479.0 RI
133 RM509 20250826 2603.0 2623.0 ... 27792.40 2606.0 2602.0 RM
134 RM511 20250826 2592.0 2598.0 ... 15333.26 2577.0 2592.0 RM
135 RM601 20250826 2552.0 2567.0 ... 789943.69 2544.0 2559.0 RM
136 RM603 20250826 2494.0 2502.0 ... 8525.88 2484.0 2495.0 RM
137 RM605 20250826 2480.0 2488.0 ... 127689.99 2474.0 2478.0 RM
138 RM607 20250826 2456.0 2466.0 ... 9584.33 2455.0 2460.0 RM
139 RM608 20250826 2531.0 2532.0 ... 178.99 2521.0 2528.0 RM
140 RS509 20250826 4842.0 4875.0 ... 72.78 4852.0 4849.0 RS
141 RS511 20250826 5288.0 5288.0 ... 26.34 5268.0 5310.0 RS
142 RS607 20250826 5635.0 5669.0 ... 90.28 5643.0 5646.0 RS
143 RS608 20250826 0.0 0.0 ... 0.00 5627.0 5627.0 RS
144 SA509 20250826 1227.0 1230.0 ... 127873.18 1214.0 1230.0 SA
145 SA510 20250826 1266.0 1270.0 ... 297170.09 1259.0 1264.0 SA
146 SA511 20250826 1273.0 1275.0 ... 451154.66 1263.0 1268.0 SA
147 SA512 20250826 1329.0 1332.0 ... 145996.13 1321.0 1328.0 SA
148 SA601 20250826 1336.0 1341.0 ... 3428417.10 1327.0 1335.0 SA
149 SA602 20250826 1353.0 1359.0 ... 3613.71 1345.0 1352.0 SA
150 SA603 20250826 1357.0 1360.0 ... 2532.45 1347.0 1353.0 SA
151 SA604 20250826 1389.0 1394.0 ... 2101.04 1386.0 1386.0 SA
152 SA605 20250826 1390.0 1399.0 ... 112217.16 1388.0 1389.0 SA
153 SA606 20250826 1398.0 1403.0 ... 926.23 1391.0 1394.0 SA
154 SA607 20250826 1391.0 1403.0 ... 1122.18 1392.0 1396.0 SA
155 SA608 20250826 1415.0 1415.0 ... 497.87 1406.0 1407.0 SA
156 SF509 20250826 5482.0 5530.0 ... 15439.05 5502.0 5492.0 SF
157 SF510 20250826 5494.0 5548.0 ... 54924.54 5510.0 5502.0 SF
158 SF511 20250826 5680.0 5736.0 ... 450304.56 5692.0 5688.0 SF
159 SF512 20250826 5664.0 5710.0 ... 47503.88 5680.0 5662.0 SF
160 SF601 20250826 5650.0 5708.0 ... 100837.65 5668.0 5666.0 SF
161 SF602 20250826 5616.0 5670.0 ... 793.98 5632.0 5638.0 SF
162 SF603 20250826 5818.0 5822.0 ... 34.88 5814.0 5808.0 SF
163 SF604 20250826 5812.0 5822.0 ... 29.04 5808.0 5800.0 SF
164 SF605 20250826 5786.0 5826.0 ... 958.84 5794.0 5796.0 SF
165 SF606 20250826 5752.0 5758.0 ... 17.25 5752.0 5762.0 SF
166 SF607 20250826 5920.0 5922.0 ... 29.51 5904.0 5898.0 SF
167 SF608 20250826 5884.0 5884.0 ... 2.94 5884.0 5860.0 SF
168 SH509 20250826 2590.0 2613.0 ... 62716.22 2564.0 2599.0 SH
169 SH510 20250826 2740.0 2770.0 ... 520309.58 2701.0 2751.0 SH
170 SH511 20250826 2766.0 2801.0 ... 995043.30 2727.0 2774.0 SH
171 SH512 20250826 2772.0 2809.0 ... 173493.90 2748.0 2776.0 SH
172 SH601 20250826 2741.0 2784.0 ... 4169616.07 2739.0 2740.0 SH
173 SH602 20250826 2747.0 2785.0 ... 11084.88 2749.0 2745.0 SH
174 SH603 20250826 2750.0 2790.0 ... 8195.24 2757.0 2754.0 SH
175 SH604 20250826 2786.0 2825.0 ... 2084.90 2802.0 2795.0 SH
176 SH605 20250826 2805.0 2844.0 ... 73134.74 2815.0 2802.0 SH
177 SH606 20250826 2812.0 2825.0 ... 894.31 2812.0 2801.0 SH
178 SH607 20250826 2776.0 2800.0 ... 560.63 2789.0 2776.0 SH
179 SH608 20250826 2786.0 2800.0 ... 586.57 2793.0 2797.0 SH
180 SM509 20250826 5802.0 5814.0 ... 66810.03 5794.0 5794.0 SM
181 SM510 20250826 5806.0 5828.0 ... 91014.53 5800.0 5800.0 SM
182 SM511 20250826 5876.0 5904.0 ... 173921.06 5872.0 5872.0 SM
183 SM512 20250826 5882.0 5908.0 ... 24592.81 5880.0 5880.0 SM
184 SM601 20250826 5896.0 5918.0 ... 487160.62 5886.0 5884.0 SM
185 SM602 20250826 5914.0 5924.0 ... 324.15 5894.0 5898.0 SM
186 SM603 20250826 5928.0 5928.0 ... 259.98 5910.0 5912.0 SM
187 SM604 20250826 5922.0 5922.0 ... 8.87 5910.0 5918.0 SM
188 SM605 20250826 5954.0 5960.0 ... 5887.26 5930.0 5932.0 SM
189 SM606 20250826 5942.0 5956.0 ... 17.84 5946.0 5936.0 SM
190 SM607 20250826 5960.0 5972.0 ... 14.91 5962.0 5960.0 SM
191 SM608 20250826 5974.0 5974.0 ... 35.78 5964.0 5964.0 SM
192 SR509 20250826 5725.0 5725.0 ... 38607.57 5696.0 5729.0 SR
193 SR511 20250826 5668.0 5671.0 ... 165377.40 5647.0 5665.0 SR
194 SR601 20250826 5685.0 5688.0 ... 1194544.25 5658.0 5685.0 SR
195 SR603 20250826 5657.0 5662.0 ... 3874.42 5631.0 5662.0 SR
196 SR605 20250826 5648.0 5649.0 ... 51237.89 5623.0 5643.0 SR
197 SR607 20250826 5628.0 5636.0 ... 1290.29 5610.0 5634.0 SR
198 TA509 20250826 4816.0 4886.0 ... 288532.55 4844.0 4844.0 TA
199 TA510 20250826 4870.0 4940.0 ... 390634.39 4898.0 4884.0 TA
200 TA511 20250826 4866.0 4932.0 ... 297115.10 4882.0 4870.0 TA
201 TA512 20250826 4862.0 4930.0 ... 97255.49 4878.0 4870.0 TA
202 TA601 20250826 4862.0 4922.0 ... 1997292.43 4882.0 4874.0 TA
203 TA602 20250826 4868.0 4916.0 ... 78.28 4892.0 4874.0 TA
204 TA603 20250826 4882.0 4930.0 ... 100.54 4904.0 4888.0 TA
205 TA604 20250826 4886.0 4932.0 ... 22.05 4900.0 4890.0 TA
206 TA605 20250826 4902.0 4946.0 ... 45965.26 4914.0 4902.0 TA
207 TA606 20250826 4920.0 4952.0 ... 14.78 4926.0 4912.0 TA
208 TA607 20250826 4956.0 4956.0 ... 7.41 4942.0 4924.0 TA
209 TA608 20250826 4950.0 4950.0 ... 7.40 4934.0 4914.0 TA
210 UR509 20250826 1709.0 1716.0 ... 22227.70 1710.0 1717.0 UR
211 UR510 20250826 1720.0 1729.0 ... 17399.75 1717.0 1726.0 UR
212 UR511 20250826 1746.0 1750.0 ... 28333.17 1743.0 1746.0 UR
213 UR512 20250826 1732.0 1745.0 ... 2196.48 1740.0 1744.0 UR
214 UR601 20250826 1741.0 1749.0 ... 450797.81 1742.0 1746.0 UR
215 UR602 20250826 1737.0 1746.0 ... 410.15 1738.0 1746.0 UR
216 UR603 20250826 1778.0 1786.0 ... 170.91 1780.0 1786.0 UR
217 UR604 20250826 1777.0 1788.0 ... 124.72 1782.0 1783.0 UR
218 UR605 20250826 1784.0 1790.0 ... 21769.28 1783.0 1789.0 UR
219 UR606 20250826 1779.0 1783.0 ... 248.62 1776.0 1784.0 UR
220 UR607 20250826 1790.0 1796.0 ... 240.16 1792.0 1800.0 UR
221 UR608 20250826 1785.0 1794.0 ... 365.41 1791.0 1794.0 UR
222 WH509 20250826 0.0 0.0 ... 0.00 3198.0 3198.0 WH
223 WH511 20250826 0.0 0.0 ... 0.00 3198.0 3198.0 WH
224 WH601 20250826 0.0 0.0 ... 0.00 3198.0 3198.0 WH
225 WH603 20250826 0.0 0.0 ... 0.00 3198.0 3198.0 WH
226 WH605 20250826 0.0 0.0 ... 0.00 3198.0 3198.0 WH
227 WH607 20250826 0.0 0.0 ... 0.00 3198.0 3198.0 WH
228 ZC509 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
229 ZC510 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
230 ZC511 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
231 ZC512 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
232 ZC601 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
233 ZC602 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
234 ZC603 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
235 ZC604 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
236 ZC605 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
237 ZC606 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
238 ZC607 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
239 ZC608 20250826 0.0 0.0 ... 0.00 801.4 801.4 ZC
[240 rows x 12 columns]
2025-08-27 18:32:22,136 - future_1d - INFO - ak.get_czce_daily('2025-08-26') done
symbol date open ... settle pre_settle variety
0 PS2509 20250826 52000.0 ... 51230.0 52030.0 PS
1 PS2510 20250826 51435.0 ... 51330.0 52220.0 PS
2 PS2511 20250826 51480.0 ... 51195.0 52055.0 PS
3 PS2512 20250826 53995.0 ... 53530.0 54365.0 PS
4 PS2601 20250826 54110.0 ... 53640.0 54450.0 PS
5 PS2602 20250826 53915.0 ... 53830.0 54765.0 PS
6 PS2603 20250826 53965.0 ... 53945.0 54725.0 PS
7 PS2604 20250826 54470.0 ... 54155.0 55040.0 PS
8 PS2605 20250826 54500.0 ... 54130.0 54890.0 PS
9 PS2606 20250826 56925.0 ... 56815.0 57365.0 PS
10 PS2607 20250826 57025.0 ... 56930.0 57525.0 PS
11 PS2608 20250826 57200.0 ... 57030.0 57555.0 PS
13 SI2509 20250826 8690.0 ... 8625.0 8745.0 SI
14 SI2510 20250826 8610.0 ... 8640.0 8760.0 SI
15 SI2511 20250826 8680.0 ... 8660.0 8765.0 SI
16 SI2512 20250826 9000.0 ... 9005.0 9120.0 SI
17 SI2601 20250826 9045.0 ... 9005.0 9120.0 SI
18 SI2602 20250826 8975.0 ... 9005.0 9105.0 SI
19 SI2603 20250826 9110.0 ... 8990.0 9100.0 SI
20 SI2604 20250826 9110.0 ... 8995.0 9135.0 SI
21 SI2605 20250826 9090.0 ... 9035.0 9150.0 SI
22 SI2606 20250826 9150.0 ... 9000.0 9165.0 SI
23 SI2607 20250826 9050.0 ... 9035.0 9155.0 SI
24 SI2608 20250826 8995.0 ... 8980.0 9195.0 SI
27 LC2509 20250826 78680.0 ... 79080.0 80100.0 LC
28 LC2510 20250826 79380.0 ... 79200.0 79840.0 LC
29 LC2511 20250826 79260.0 ... 79040.0 79620.0 LC
30 LC2512 20250826 78940.0 ... 78740.0 79220.0 LC
31 LC2601 20250826 78840.0 ... 78520.0 78840.0 LC
32 LC2602 20250826 77220.0 ... 77920.0 79220.0 LC
33 LC2603 20250826 78000.0 ... 77700.0 78440.0 LC
34 LC2604 20250826 77960.0 ... 77480.0 77960.0 LC
35 LC2605 20250826 77560.0 ... 77480.0 77880.0 LC
36 LC2606 20250826 77380.0 ... 77320.0 77880.0 LC
37 LC2607 20250826 77400.0 ... 77160.0 77680.0 LC
38 LC2608 20250826 77360.0 ... 77460.0 78180.0 LC
[36 rows x 12 columns]
2025-08-27 18:32:22,315 - future_1d - INFO - ak.get_gfex_daily('2025-08-26') done
index symbol date ... settle pre_settle variety
0 0 CU2509 20250826 ... 79450 79260 CU
1 1 CU2510 20250826 ... 79460 79290 CU
2 2 CU2511 20250826 ... 79440 79290 CU
3 3 CU2512 20250826 ... 79410 79230 CU
4 4 CU2601 20250826 ... 79410 79240 CU
5 5 CU2602 20250826 ... 79340 79250 CU
6 6 CU2603 20250826 ... 79360 79240 CU
7 7 CU2604 20250826 ... 79390 79260 CU
8 8 CU2605 20250826 ... 79400 79350 CU
9 9 CU2606 20250826 ... 79380 79290 CU
10 10 CU2607 20250826 ... 79390 79350 CU
11 11 CU2608 20250826 ... 79250 79380 CU
12 12 BC2509 20250826 ... 70620 70290 BC
13 13 BC2510 20250826 ... 70630 70380 BC
14 14 BC2511 20250826 ... 70440 70530 BC
15 15 BC2512 20250826 ... 70180 69780 BC
16 16 BC2601 20250826 ... 70100 70100 BC
17 17 BC2602 20250826 ... 70100 70100 BC
18 18 BC2603 20250826 ... 70100 70100 BC
19 19 BC2604 20250826 ... 70100 70100 BC
20 20 BC2605 20250826 ... 70490 69800 BC
21 21 BC2606 20250826 ... 69790 69790 BC
22 22 BC2607 20250826 ... 69370 69370 BC
23 23 BC2608 20250826 ... 69370 69370 BC
24 24 AL2509 20250826 ... 20750 20760 AL
25 25 AL2510 20250826 ... 20730 20740 AL
26 26 AL2511 20250826 ... 20710 20710 AL
27 27 AL2512 20250826 ... 20670 20670 AL
28 28 AL2601 20250826 ... 20640 20640 AL
29 29 AL2602 20250826 ... 20645 20665 AL
30 30 AL2603 20250826 ... 20660 20685 AL
31 31 AL2604 20250826 ... 20695 20710 AL
32 32 AL2605 20250826 ... 20705 20720 AL
33 33 AL2606 20250826 ... 20715 20725 AL
34 34 AL2607 20250826 ... 20720 20720 AL
35 35 AL2608 20250826 ... 20755 20730 AL
36 36 ZN2509 20250826 ... 22300 22365 ZN
37 37 ZN2510 20250826 ... 22305 22355 ZN
38 38 ZN2511 20250826 ... 22300 22350 ZN
39 39 ZN2512 20250826 ... 22310 22345 ZN
40 40 ZN2601 20250826 ... 22290 22350 ZN
41 41 ZN2602 20250826 ... 22290 22310 ZN
42 42 ZN2603 20250826 ... 22335 22380 ZN
43 43 ZN2604 20250826 ... 22360 22405 ZN
44 44 ZN2605 20250826 ... 22370 22400 ZN
45 45 ZN2606 20250826 ... 22365 22415 ZN
46 46 ZN2607 20250826 ... 22405 22450 ZN
47 47 ZN2608 20250826 ... 22440 22465 ZN
48 48 PB2509 20250826 ... 16895 16830 PB
49 49 PB2510 20250826 ... 16915 16845 PB
50 50 PB2511 20250826 ... 16915 16865 PB
51 51 PB2512 20250826 ... 16930 16885 PB
52 52 PB2601 20250826 ... 16945 16895 PB
53 53 PB2602 20250826 ... 16965 16945 PB
54 54 PB2603 20250826 ... 17005 16910 PB
55 55 PB2604 20250826 ... 17030 16900 PB
56 56 PB2605 20250826 ... 17050 17000 PB
57 57 PB2606 20250826 ... 17055 17055 PB
58 58 PB2607 20250826 ... 17095 16975 PB
59 59 PB2608 20250826 ... 17100 16990 PB
60 60 NI2509 20250826 ... 120180 120100 NI
61 61 NI2510 20250826 ... 120350 120270 NI
62 62 NI2511 20250826 ... 120500 120450 NI
63 63 NI2512 20250826 ... 120750 120680 NI
64 64 NI2601 20250826 ... 121010 120990 NI
65 65 NI2602 20250826 ... 121230 121350 NI
66 66 NI2603 20250826 ... 121530 121660 NI
67 67 NI2604 20250826 ... 121860 121850 NI
68 68 NI2605 20250826 ... 122100 122100 NI
69 69 NI2606 20250826 ... 122400 122600 NI
70 70 NI2607 20250826 ... 122710 122840 NI
71 71 NI2608 20250826 ... 123030 123310 NI
72 72 SN2509 20250826 ... 269350 269030 SN
73 73 SN2510 20250826 ... 269730 269340 SN
74 74 SN2511 20250826 ... 269930 269660 SN
75 75 SN2512 20250826 ... 269870 269710 SN
76 76 SN2601 20250826 ... 269800 269710 SN
77 77 SN2602 20250826 ... 270010 269800 SN
78 78 SN2603 20250826 ... 270300 270160 SN
79 79 SN2604 20250826 ... 270550 271600 SN
80 80 SN2605 20250826 ... 270740 271840 SN
81 81 SN2606 20250826 ... 270910 271820 SN
82 82 SN2607 20250826 ... 270930 271600 SN
83 83 SN2608 20250826 ... 271730 272450 SN
84 84 AO2509 20250826 ... 3107 3157 AO
85 85 AO2510 20250826 ... 3117 3151 AO
86 86 AO2511 20250826 ... 3113 3158 AO
87 87 AO2512 20250826 ... 3165 3167 AO
88 88 AO2601 20250826 ... 3129 3180 AO
89 89 AO2602 20250826 ... 3125 3173 AO
90 90 AO2603 20250826 ... 3123 3174 AO
91 91 AO2604 20250826 ... 3107 3172 AO
92 92 AO2605 20250826 ... 3122 3171 AO
93 93 AO2606 20250826 ... 3131 3175 AO
94 94 AO2607 20250826 ... 3114 3175 AO
95 95 AO2608 20250826 ... 3111 3186 AO
96 96 AD2511 20250826 ... 20285 20280 AD
97 97 AD2512 20250826 ... 20285 20275 AD
98 98 AD2601 20250826 ... 20280 20270 AD
99 99 AD2602 20250826 ... 20220 20210 AD
100 100 AD2603 20250826 ... 20220 20220 AD
101 101 AD2604 20250826 ... 19975 19975 AD
102 102 AD2605 20250826 ... 19975 19990 AD
103 103 AD2606 20250826 ... 19795 19765 AD
104 104 AD2607 20250826 ... 19925 19925 AD
105 105 AD2608 20250826 ... 19925 19925 AD
106 106 AU2509 20250826 ... 779.02 778.3 AU
107 107 AU2510 20250826 ... 780.24 778.94 AU
108 108 AU2511 20250826 ... 782.08 780.54 AU
109 109 AU2512 20250826 ... 782.68 781.2 AU
110 110 AU2602 20250826 ... 784.64 783 AU
111 111 AU2604 20250826 ... 786.86 785.58 AU
112 112 AU2606 20250826 ... 789.16 787.32 AU
113 113 AU2608 20250826 ... 791.64 789.1 AU
114 114 AG2509 20250826 ... 9333 9331 AG
115 115 AG2510 20250826 ... 9354 9344 AG
116 116 AG2511 20250826 ... 9365 9342 AG
117 117 AG2512 20250826 ... 9375 9364 AG
118 118 AG2601 20250826 ... 9386 9367 AG
119 119 AG2602 20250826 ... 9399 9376 AG
120 120 AG2603 20250826 ... 9412 9388 AG
121 121 AG2604 20250826 ... 9424 9400 AG
122 122 AG2605 20250826 ... 9437 9410 AG
123 123 AG2606 20250826 ... 9450 9431 AG
124 124 AG2607 20250826 ... 9463 9451 AG
125 125 AG2608 20250826 ... 9476 9471 AG
126 126 RB2509 20250826 ... 3099 3119 RB
127 127 RB2510 20250826 ... 3126 3144 RB
128 128 RB2511 20250826 ... 3136 3154 RB
129 129 RB2512 20250826 ... 3188 3211 RB
130 130 RB2601 20250826 ... 3206 3224 RB
131 131 RB2602 20250826 ... 3190 3209 RB
132 132 RB2603 20250826 ... 3211 3226 RB
133 133 RB2604 20250826 ... 3228 3244 RB
134 134 RB2605 20250826 ... 3242 3258 RB
135 135 RB2606 20250826 ... 3257 3272 RB
136 136 RB2607 20250826 ... 3268 3285 RB
137 137 RB2608 20250826 ... 3281 3282 RB
138 138 WR2509 20250826 ... 3342 3342 WR
139 139 WR2510 20250826 ... 3365 3387 WR
140 140 WR2511 20250826 ... 3376 3373 WR
141 141 WR2512 20250826 ... 3486 3486 WR
142 142 WR2601 20250826 ... 3380 3380 WR
143 143 WR2602 20250826 ... 3459 3503 WR
144 144 WR2603 20250826 ... 3438 3438 WR
145 145 WR2604 20250826 ... 3455 3455 WR
146 146 WR2605 20250826 ... 3429 3429 WR
147 147 WR2606 20250826 ... 3441 3435 WR
148 148 WR2607 20250826 ... 3488 3453 WR
149 149 WR2608 20250826 ... 3477 3477 WR
150 150 HC2509 20250826 ... 3407 3416 HC
151 151 HC2510 20250826 ... 3380 3391 HC
152 152 HC2511 20250826 ... 3379 3389 HC
153 153 HC2512 20250826 ... 3386 3390 HC
154 154 HC2601 20250826 ... 3370 3378 HC
155 155 HC2602 20250826 ... 3371 3379 HC
156 156 HC2603 20250826 ... 3375 3384 HC
157 157 HC2604 20250826 ... 3385 3384 HC
158 158 HC2605 20250826 ... 3377 3385 HC
159 159 HC2606 20250826 ... 3386 3391 HC
160 160 HC2607 20250826 ... 3394 3401 HC
161 161 HC2608 20250826 ... 3405 3396 HC
162 162 SS2509 20250826 ... 12785 12750 SS
163 163 SS2510 20250826 ... 12865 12830 SS
164 164 SS2511 20250826 ... 12930 12900 SS
165 165 SS2512 20250826 ... 12975 12945 SS
166 166 SS2601 20250826 ... 13035 13000 SS
167 167 SS2602 20250826 ... 13050 13020 SS
168 168 SS2603 20250826 ... 13135 13095 SS
169 169 SS2604 20250826 ... 13190 13180 SS
170 170 SS2605 20250826 ... 13270 13220 SS
171 171 SS2606 20250826 ... 13315 13285 SS
172 172 SS2607 20250826 ... 13380 13345 SS
173 173 SS2608 20250826 ... 13445 13300 SS
174 174 SC2509 20250826 ... 488.7 486.8 SC
175 175 SC2510 20250826 ... 497.7 493.5 SC
176 176 SC2511 20250826 ... 496 491.9 SC
177 177 SC2512 20250826 ... 493.2 489.5 SC
178 178 SC2601 20250826 ... 491.7 488.1 SC
179 179 SC2602 20250826 ... 490.5 486.9 SC
180 180 SC2603 20250826 ... 488.2 485.7 SC
181 181 SC2604 20250826 ... 486.4 485.5 SC
182 182 SC2605 20250826 ... 485.8 483.1 SC
183 183 SC2606 20250826 ... 484.9 483.4 SC
184 184 SC2607 20250826 ... 482.3 481.1 SC
185 185 SC2608 20250826 ... 481.3 482.2 SC
186 186 SC2609 20250826 ... 482.3 480.7 SC
187 187 SC2612 20250826 ... 482.2 483.6 SC
188 188 SC2703 20250826 ... 483.7 478.9 SC
189 189 SC2706 20250826 ... 479.5 481.1 SC
190 190 SC2709 20250826 ... 482.5 480.1 SC
191 191 SC2712 20250826 ... 481 479.2 SC
192 192 SC2803 20250826 ... 479.5 479.5 SC
193 193 SC2806 20250826 ... 474.5 471.9 SC
194 194 LU2509 20250826 ... 3426 3452 LU
195 195 LU2510 20250826 ... 3532 3511 LU
196 196 LU2511 20250826 ... 3537 3521 LU
197 197 LU2512 20250826 ... 3522 3508 LU
198 198 LU2601 20250826 ... 3498 3488 LU
199 199 LU2602 20250826 ... 3476 3465 LU
200 200 LU2603 20250826 ... 3469 3458 LU
201 201 LU2604 20250826 ... 3463 3455 LU
202 202 LU2605 20250826 ... 3455 3443 LU
203 203 LU2606 20250826 ... 3454 3438 LU
204 204 LU2607 20250826 ... 3454 3434 LU
205 205 LU2608 20250826 ... 3450 3435 LU
206 206 FU2509 20250826 ... 2841 2805 FU
207 207 FU2510 20250826 ... 2890 2878 FU
208 208 FU2511 20250826 ... 2871 2848 FU
209 209 FU2512 20250826 ... 2856 2829 FU
210 210 FU2601 20250826 ... 2845 2812 FU
211 211 FU2602 20250826 ... 2830 2806 FU
212 212 FU2603 20250826 ... 2820 2793 FU
213 213 FU2604 20250826 ... 2813 2786 FU
214 214 FU2605 20250826 ... 2803 2782 FU
215 215 FU2606 20250826 ... 2791 2771 FU
216 216 FU2607 20250826 ... 2765 2749 FU
217 217 FU2608 20250826 ... 2742 2732 FU
218 218 BU2509 20250826 ... 3550 3540 BU
219 219 BU2510 20250826 ... 3525 3504 BU
220 220 BU2511 20250826 ... 3497 3470 BU
221 221 BU2512 20250826 ... 3447 3422 BU
222 222 BU2601 20250826 ... 3407 3386 BU
223 223 BU2602 20250826 ... 3407 3388 BU
224 224 BU2603 20250826 ... 3406 3385 BU
225 225 BU2604 20250826 ... 3390 3357 BU
226 226 BU2605 20250826 ... 3386 3381 BU
227 227 BU2606 20250826 ... 3387 3372 BU
228 228 BU2607 20250826 ... 3354 3347 BU
229 229 BU2608 20250826 ... 3356 3356 BU
230 230 BU2609 20250826 ... 3364 3361 BU
231 231 BU2612 20250826 ... 3336 3319 BU
232 232 BU2703 20250826 ... 3339 3335 BU
233 233 BU2706 20250826 ... 3348 3340 BU
234 234 BR2509 20250826 ... 11950 11920 BR
235 235 BR2510 20250826 ... 11980 11925 BR
236 236 BR2511 20250826 ... 11960 11915 BR
237 237 BR2512 20250826 ... 11950 11920 BR
238 238 BR2601 20250826 ... 11960 11920 BR
239 239 BR2602 20250826 ... 12010 11960 BR
240 240 BR2603 20250826 ... 11975 11975 BR
241 241 BR2604 20250826 ... 12050 12025 BR
242 242 BR2605 20250826 ... 12080 12030 BR
243 243 BR2606 20250826 ... 12085 12115 BR
244 244 BR2607 20250826 ... 12285 12080 BR
245 245 BR2608 20250826 ... 12005 12005 BR
246 246 RU2509 20250826 ... 14965 14850 RU
247 247 RU2510 20250826 ... 14925 14840 RU
248 248 RU2511 20250826 ... 14985 14850 RU
249 249 RU2601 20250826 ... 15975 15840 RU
250 250 RU2603 20250826 ... 16015 15915 RU
251 251 RU2604 20250826 ... 16045 15920 RU
252 252 RU2605 20250826 ... 16080 15955 RU
253 253 RU2606 20250826 ... 16060 15945 RU
254 254 RU2607 20250826 ... 16165 16035 RU
255 255 RU2608 20250826 ... 16115 16090 RU
256 256 NR2509 20250826 ... 12755 12665 NR
257 257 NR2510 20250826 ... 12840 12720 NR
258 258 NR2511 20250826 ... 12865 12750 NR
259 259 NR2512 20250826 ... 12875 12790 NR
260 260 NR2601 20250826 ... 12920 12805 NR
261 261 NR2602 20250826 ... 12860 12775 NR
262 262 NR2603 20250826 ... 12910 12735 NR
263 263 NR2604 20250826 ... 13055 12760 NR
264 264 NR2605 20250826 ... 13080 12915 NR
265 265 NR2606 20250826 ... 13140 12745 NR
266 266 NR2607 20250826 ... 12780 12780 NR
267 267 NR2608 20250826 ... 12780 12780 NR
268 268 SP2509 20250826 ... 5056 5084 SP
269 269 SP2510 20250826 ... 5088 5110 SP
270 270 SP2511 20250826 ... 5106 5130 SP
271 271 SP2512 20250826 ... 5122 5144 SP
272 272 SP2601 20250826 ... 5392 5398 SP
273 273 SP2602 20250826 ... 5360 5382 SP
274 274 SP2603 20250826 ... 5384 5394 SP
275 275 SP2604 20250826 ... 5366 5378 SP
276 276 SP2605 20250826 ... 5388 5392 SP
277 277 SP2606 20250826 ... 5400 5402 SP
278 278 SP2607 20250826 ... 5386 5412 SP
279 279 SP2608 20250826 ... 5410 5416 SP
280 280 EC2510 20250826 ... 1327.8 1356.3 EC
281 281 EC2512 20250826 ... 1663.1 1691 EC
282 282 EC2602 20250826 ... 1472.8 1492.6 EC
283 283 EC2604 20250826 ... 1276.1 1294.4 EC
284 284 EC2606 20250826 ... 1432.5 1451.3 EC
285 285 EC2608 20250826 ... 1626.3 1451.3 EC
286 286 SC_TAS2510 20250826 ... SC_TAS
287 287 SC_TAS2511 20250826 ... SC_TAS
288 288 SC_TAS2512 20250826 ... SC_TAS
[289 rows x 13 columns]
2025-08-27 18:32:22,411 - future_1d - INFO - ak.get_shfe_daily('2025-08-26') done
symbol date open ... settle pre_settle variety
0 a2509 20250826 4114.00 ... 4096.00 4114.00 A
1 a2511 20250826 3996.00 ... 3988.00 3998.00 A
2 a2601 20250826 4004.00 ... 3992.00 4003.00 A
3 a2603 20250826 4010.00 ... 3999.00 4010.00 A
4 a2605 20250826 4055.00 ... 4043.00 4054.00 A
5 a2607 20250826 4060.00 ... 4049.00 4056.00 A
6 b2509 20250826 3727.00 ... 3724.00 3718.00 B
7 b2510 20250826 3767.00 ... 3747.00 3763.00 B
8 b2511 20250826 3821.00 ... 3814.00 3815.00 B
9 b2512 20250826 3859.00 ... 3845.00 3849.00 B
10 b2601 20250826 3852.00 ... 3840.00 3839.00 B
11 b2602 20250826 3831.00 ... 3809.00 3813.00 B
12 b2603 20250826 3766.00 ... 3749.00 3749.00 B
13 b2604 20250826 3663.00 ... 3648.00 3647.00 B
14 b2605 20250826 3590.00 ... 3579.00 3577.00 B
15 b2606 20250826 3565.00 ... 3559.00 3563.00 B
16 b2607 20250826 3556.00 ... 3549.00 3556.00 B
17 b2608 20250826 0.00 ... 3619.00 3619.00 B
18 bb2509 20250826 0.00 ... 143.15 143.15 BB
19 bb2511 20250826 144.60 ... 144.85 145.00 BB
20 bb2601 20250826 147.35 ... 147.60 146.90 BB
21 bb2603 20250826 0.00 ... 147.35 146.70 BB
22 bb2605 20250826 0.00 ... 141.15 140.50 BB
23 bb2607 20250826 0.00 ... 146.90 146.25 BB
24 bz2603 20250826 6217.00 ... 6195.00 6217.00 BZ
25 bz2604 20250826 6183.00 ... 6171.00 6182.00 BZ
26 bz2605 20250826 6170.00 ... 6162.00 6183.00 BZ
27 bz2606 20250826 6184.00 ... 6170.00 6180.00 BZ
28 bz2607 20250826 0.00 ... 6175.00 6175.00 BZ
29 c2509 20250826 2200.00 ... 2206.00 2212.00 C
30 c2511 20250826 2154.00 ... 2157.00 2164.00 C
31 c2601 20250826 2158.00 ... 2163.00 2166.00 C
32 c2603 20250826 2175.00 ... 2181.00 2183.00 C
33 c2605 20250826 2236.00 ... 2236.00 2236.00 C
34 c2607 20250826 2252.00 ... 2253.00 2254.00 C
35 cs2509 20250826 2569.00 ... 2550.00 2578.00 CS
36 cs2511 20250826 2480.00 ... 2483.00 2491.00 CS
37 cs2601 20250826 2507.00 ... 2514.00 2520.00 CS
38 cs2603 20250826 2521.00 ... 2522.00 2531.00 CS
39 cs2605 20250826 2591.00 ... 2591.00 2596.00 CS
40 cs2607 20250826 2602.00 ... 2599.00 2599.00 CS
41 eb2508 20250826 0.00 ... 7260.00 7000.00 EB
42 eb2509 20250826 7285.00 ... 7286.00 7357.00 EB
43 eb2510 20250826 7345.00 ... 7317.00 7380.00 EB
44 eb2511 20250826 7357.00 ... 7333.00 7388.00 EB
45 eb2512 20250826 7355.00 ... 7346.00 7394.00 EB
46 eb2601 20250826 7368.00 ... 7361.00 7408.00 EB
47 eb2602 20250826 7388.00 ... 7383.00 7423.00 EB
48 eb2603 20250826 7411.00 ... 7402.00 7435.00 EB
49 eb2604 20250826 7424.00 ... 7412.00 7469.00 EB
50 eb2605 20250826 7472.00 ... 7438.00 7493.00 EB
51 eb2606 20250826 7460.00 ... 7446.00 7482.00 EB
52 eb2607 20250826 7401.00 ... 7410.00 7341.00 EB
53 eg2508 20250826 0.00 ... 4407.00 4407.00 EG
54 eg2509 20250826 4440.00 ... 4452.00 4443.00 EG
55 eg2510 20250826 4469.00 ... 4470.00 4460.00 EG
56 eg2511 20250826 4489.00 ... 4487.00 4480.00 EG
57 eg2512 20250826 4513.00 ... 4502.00 4491.00 EG
58 eg2601 20250826 4510.00 ... 4507.00 4502.00 EG
59 eg2602 20250826 0.00 ... 4514.00 4514.00 EG
60 eg2603 20250826 4523.00 ... 4506.00 4516.00 EG
61 eg2604 20250826 4542.00 ... 4533.00 4540.00 EG
62 eg2605 20250826 4540.00 ... 4542.00 4544.00 EG
63 eg2606 20250826 4534.00 ... 4534.00 4524.00 EG
64 eg2607 20250826 0.00 ... 4513.00 4513.00 EG
65 fb2509 20250826 1275.00 ... 1292.50 1266.50 FB
66 fb2510 20250826 1276.00 ... 1276.50 1275.00 FB
67 fb2511 20250826 1274.50 ... 1277.00 1274.50 FB
68 fb2512 20250826 1277.00 ... 1277.00 1275.50 FB
69 fb2601 20250826 1275.50 ... 1277.00 1277.00 FB
70 fb2602 20250826 1278.50 ... 1278.50 1278.00 FB
71 fb2603 20250826 0.00 ... 1313.50 1313.50 FB
72 fb2604 20250826 0.00 ... 1310.50 1310.50 FB
73 fb2605 20250826 0.00 ... 1311.00 1311.00 FB
74 fb2606 20250826 0.00 ... 1330.00 1330.00 FB
75 fb2607 20250826 0.00 ... 1302.50 1302.50 FB
76 fb2608 20250826 0.00 ... 1302.50 1302.50 FB
77 i2509 20250826 809.00 ... 800.00 800.00 I
78 i2510 20250826 802.00 ... 795.00 795.50 I
79 i2511 20250826 798.00 ... 792.00 793.00 I
80 i2512 20250826 794.50 ... 787.50 790.00 I
81 i2601 20250826 787.00 ... 780.50 782.00 I
82 i2602 20250826 781.00 ... 775.00 777.00 I
83 i2603 20250826 777.00 ... 770.50 772.50 I
84 i2604 20250826 771.00 ... 765.50 767.00 I
85 i2605 20250826 765.00 ... 757.50 759.00 I
86 i2606 20250826 758.50 ... 753.00 755.00 I
87 i2607 20250826 755.50 ... 749.50 750.50 I
88 i2608 20250826 750.50 ... 746.50 746.00 I
89 j2509 20250826 1650.00 ... 1636.00 1650.00 J
90 j2510 20250826 1671.00 ... 1653.00 1662.00 J
91 j2511 20250826 1693.50 ... 1677.00 1686.00 J
92 j2512 20250826 1714.00 ... 1686.50 1712.00 J
93 j2601 20250826 1737.00 ... 1718.00 1722.50 J
94 j2602 20250826 1755.00 ... 1750.00 1739.50 J
95 j2603 20250826 1771.00 ... 1763.00 1755.00 J
96 j2604 20250826 1800.00 ... 1800.00 1800.00 J
97 j2605 20250826 1815.50 ... 1806.50 1819.50 J
98 j2606 20250826 1842.00 ... 1816.50 1799.50 J
99 j2607 20250826 1839.50 ... 1823.50 1833.00 J
100 j2608 20250826 1829.00 ... 1838.00 1818.50 J
101 jd2508 20250826 0.00 ... 2932.00 2940.00 JD
102 jd2509 20250826 2949.00 ... 2914.00 2955.00 JD
103 jd2510 20250826 3015.00 ... 3011.00 3031.00 JD
104 jd2511 20250826 3075.00 ... 3056.00 3084.00 JD
105 jd2512 20250826 3226.00 ... 3203.00 3231.00 JD
106 jd2601 20250826 3381.00 ... 3370.00 3394.00 JD
107 jd2602 20250826 3120.00 ... 3114.00 3124.00 JD
108 jd2603 20250826 3135.00 ... 3131.00 3140.00 JD
109 jd2604 20250826 3389.00 ... 3331.00 3340.00 JD
110 jd2605 20250826 3487.00 ... 3478.00 3495.00 JD
111 jd2606 20250826 3338.00 ... 3334.00 3344.00 JD
112 jd2607 20250826 3600.00 ... 3595.00 3603.00 JD
113 jm2509 20250826 1063.00 ... 1058.00 1063.00 JM
114 jm2510 20250826 1092.00 ... 1085.00 1092.00 JM
115 jm2511 20250826 1135.00 ... 1127.00 1133.50 JM
116 jm2512 20250826 1184.00 ... 1162.50 1168.50 JM
117 jm2601 20250826 1224.50 ... 1200.50 1198.50 JM
118 jm2602 20250826 1236.50 ... 1214.00 1219.50 JM
119 jm2603 20250826 1249.00 ... 1230.00 1225.00 JM
120 jm2604 20250826 1259.50 ... 1228.00 1237.50 JM
121 jm2605 20250826 1260.00 ... 1241.50 1244.00 JM
122 jm2606 20250826 1267.50 ... 1243.50 1252.00 JM
123 jm2607 20250826 1273.00 ... 1249.50 1261.00 JM
124 jm2608 20250826 1274.50 ... 1257.50 1267.50 JM
125 l2509 20250826 7359.00 ... 7373.00 7352.00 L
126 l2510 20250826 7390.00 ... 7393.00 7381.00 L
127 l2511 20250826 7417.00 ... 7410.00 7402.00 L
128 l2512 20250826 7432.00 ... 7426.00 7413.00 L
129 l2601 20250826 7427.00 ... 7427.00 7411.00 L
130 l2602 20250826 7415.00 ... 7420.00 7404.00 L
131 l2603 20250826 7426.00 ... 7419.00 7401.00 L
132 l2604 20250826 7450.00 ... 7445.00 7427.00 L
133 l2605 20250826 7427.00 ... 7433.00 7414.00 L
134 l2606 20250826 0.00 ... 7407.00 7407.00 L
135 l2607 20250826 0.00 ... 7416.00 7416.00 L
136 l2608 20250826 7395.00 ... 7394.00 7426.00 L
137 lg2509 20250826 805.00 ... 803.50 805.00 LG
138 lg2511 20250826 818.00 ... 822.00 818.00 LG
139 lg2601 20250826 830.50 ... 833.50 828.50 LG
140 lg2603 20250826 845.00 ... 838.50 835.00 LG
141 lg2605 20250826 847.50 ... 837.50 835.50 LG
142 lg2607 20250826 836.00 ... 837.00 835.50 LG
143 lh2509 20250826 13720.00 ... 13695.00 13795.00 LH
144 lh2511 20250826 13800.00 ... 13840.00 13925.00 LH
145 lh2601 20250826 14240.00 ... 14210.00 14210.00 LH
146 lh2603 20250826 13310.00 ... 13275.00 13325.00 LH
147 lh2605 20250826 13725.00 ... 13665.00 13760.00 LH
148 lh2607 20250826 14165.00 ... 14155.00 14175.00 LH
149 m2509 20250826 3063.00 ... 3046.00 3061.00 M
150 m2511 20250826 3095.00 ... 3069.00 3080.00 M
151 m2512 20250826 3132.00 ... 3112.00 3122.00 M
152 m2601 20250826 3122.00 ... 3097.00 3110.00 M
153 m2603 20250826 3037.00 ... 3027.00 3031.00 M
154 m2605 20250826 2845.00 ... 2841.00 2841.00 M
155 m2607 20250826 2840.00 ... 2832.00 2832.00 M
156 m2608 20250826 2963.00 ... 2957.00 2955.00 M
157 p2509 20250826 9480.00 ... 9460.00 9530.00 P
158 p2510 20250826 9568.00 ... 9542.00 9604.00 P
159 p2511 20250826 9590.00 ... 9536.00 9602.00 P
160 p2512 20250826 9592.00 ... 9536.00 9604.00 P
161 p2601 20250826 9610.00 ... 9544.00 9614.00 P
162 p2602 20250826 9546.00 ... 9488.00 9564.00 P
163 p2603 20250826 9470.00 ... 9434.00 9494.00 P
164 p2604 20250826 9400.00 ... 9374.00 9408.00 P
165 p2605 20250826 9320.00 ... 9278.00 9324.00 P
166 p2606 20250826 9140.00 ... 9158.00 9184.00 P
167 p2607 20250826 9042.00 ... 9036.00 9086.00 P
168 p2608 20250826 8964.00 ... 8964.00 8948.00 P
169 pg2508 20250826 0.00 ... 3888.00 3888.00 PG
170 pg2509 20250826 3854.00 ... 3866.00 3871.00 PG
171 pg2510 20250826 4447.00 ... 4444.00 4420.00 PG
172 pg2511 20250826 4382.00 ... 4357.00 4339.00 PG
173 pg2512 20250826 4313.00 ... 4295.00 4279.00 PG
174 pg2601 20250826 4249.00 ... 4242.00 4227.00 PG
175 pg2602 20250826 4182.00 ... 4165.00 4156.00 PG
176 pg2603 20250826 4068.00 ... 4074.00 4068.00 PG
177 pg2604 20250826 4376.00 ... 4374.00 4365.00 PG
178 pg2605 20250826 4273.00 ... 4271.00 4278.00 PG
179 pg2606 20250826 0.00 ... 4209.00 4209.00 PG
180 pg2607 20250826 4141.00 ... 4141.00 4122.00 PG
181 pp2509 20250826 7014.00 ... 7014.00 7019.00 PP
182 pp2510 20250826 7029.00 ... 7026.00 7018.00 PP
183 pp2511 20250826 7040.00 ... 7040.00 7036.00 PP
184 pp2512 20250826 7058.00 ... 7058.00 7055.00 PP
185 pp2601 20250826 7079.00 ... 7072.00 7067.00 PP
186 pp2602 20250826 7058.00 ... 7048.00 7045.00 PP
187 pp2603 20250826 0.00 ... 7032.00 7039.00 PP
188 pp2604 20250826 7076.00 ... 7077.00 7066.00 PP
189 pp2605 20250826 7082.00 ... 7089.00 7086.00 PP
190 pp2606 20250826 7054.00 ... 7057.00 7050.00 PP
191 pp2607 20250826 7034.00 ... 7033.00 7031.00 PP
192 pp2608 20250826 7046.00 ... 7046.00 7047.00 PP
193 rr2509 20250826 3563.00 ... 3567.00 3576.00 RR
194 rr2510 20250826 3611.00 ... 3610.00 3610.00 RR
195 rr2511 20250826 3615.00 ... 3613.00 3613.00 RR
196 rr2512 20250826 3606.00 ... 3606.00 3608.00 RR
197 rr2601 20250826 3621.00 ... 3620.00 3622.00 RR
198 rr2602 20250826 3604.00 ... 3606.00 3608.00 RR
199 rr2603 20250826 0.00 ... 3610.00 3610.00 RR
200 rr2604 20250826 3618.00 ... 3617.00 3613.00 RR
201 rr2605 20250826 0.00 ... 3615.00 3615.00 RR
202 rr2606 20250826 0.00 ... 3605.00 3605.00 RR
203 rr2607 20250826 0.00 ... 3625.00 3625.00 RR
204 rr2608 20250826 3609.00 ... 3609.00 3581.00 RR
205 v2509 20250826 4894.00 ... 4878.00 4899.00 V
206 v2510 20250826 4939.00 ... 4922.00 4936.00 V
207 v2511 20250826 4980.00 ... 4957.00 4971.00 V
208 v2512 20250826 5020.00 ... 5002.00 5010.00 V
209 v2601 20250826 5062.00 ... 5026.00 5045.00 V
210 v2602 20250826 5093.00 ... 5067.00 5083.00 V
211 v2603 20250826 5120.00 ... 5096.00 5116.00 V
212 v2604 20250826 5317.00 ... 5292.00 5318.00 V
213 v2605 20250826 5360.00 ... 5332.00 5346.00 V
214 v2606 20250826 5388.00 ... 5359.00 5366.00 V
215 v2607 20250826 5418.00 ... 5390.00 5406.00 V
216 v2608 20250826 5417.00 ... 5385.00 5408.00 V
217 y2509 20250826 8560.00 ... 8554.00 8514.00 Y
218 y2511 20250826 8536.00 ... 8516.00 8500.00 Y
219 y2512 20250826 8526.00 ... 8542.00 8520.00 Y
220 y2601 20250826 8504.00 ... 8492.00 8472.00 Y
221 y2603 20250826 8438.00 ... 8438.00 8380.00 Y
222 y2605 20250826 8198.00 ... 8194.00 8164.00 Y
223 y2607 20250826 8144.00 ... 8122.00 8104.00 Y
224 y2608 20250826 8146.00 ... 8114.00 8112.00 Y
[225 rows x 12 columns]
2025-08-27 18:32:23,034 - future_1d - INFO - ak.get_dce_daily('2025-08-26') done
symbol date open ... settle pre_settle variety
0 IC2509 20250826 6886.000 ... 6942.400 6904.000 IC
1 IC2510 20250826 6860.800 ... 6905.400 6872.000 IC
2 IC2512 20250826 6767.000 ... 6817.000 6786.600 IC
3 IC2603 20250826 6650.000 ... 6692.000 6665.800 IC
4 IF2509 20250826 4474.800 ... 4460.200 4458.400 IF
5 IF2510 20250826 4458.000 ... 4454.200 4451.600 IF
6 IF2512 20250826 4441.400 ... 4441.400 4441.400 IF
7 IF2603 20250826 4430.000 ... 4422.200 4423.400 IF
8 IH2509 20250826 2982.000 ... 2975.000 2983.600 IH
9 IH2510 20250826 2981.000 ... 2976.000 2982.800 IH
10 IH2512 20250826 2984.000 ... 2977.000 2986.000 IH
11 IH2603 20250826 2982.400 ... 2980.800 2988.200 IH
12 IM2509 20250826 7391.400 ... 7442.000 7423.000 IM
13 IM2510 20250826 7349.800 ... 7388.200 7374.000 IM
14 IM2512 20250826 7244.200 ... 7282.200 7273.600 IM
15 IM2603 20250826 7100.000 ... 7124.000 7121.800 IM
16 T2509 20250826 108.165 ... 108.125 108.125 T
17 T2512 20250826 107.930 ... 107.935 107.925 T
18 T2603 20250826 107.720 ... 107.670 107.670 T
19 TF2509 20250826 105.545 ... 105.585 105.575 TF
20 TF2512 20250826 105.555 ... 105.520 105.515 TF
21 TF2603 20250826 105.430 ... 105.405 105.360 TF
22 TL2509 20250826 117.400 ... 117.520 117.150 TL
23 TL2512 20250826 116.950 ... 117.120 116.720 TL
24 TL2603 20250826 116.520 ... 116.770 116.370 TL
25 TS2509 20250826 102.322 ... 102.324 102.334 TS
26 TS2512 20250826 102.416 ... 102.382 102.390 TS
27 TS2603 20250826 102.352 ... 102.324 102.316 TS
[28 rows x 12 columns]
2025-08-27 18:32:23,341 - future_1d - INFO - ak.get_cffex_daily('2025-08-26') done
symbol date open ... settle pre_settle variety
0 SC2509 20250826 486.9 ... 488.7 486.8 SC
1 SC2510 20250826 494.5 ... 497.7 493.5 SC
2 SC2511 20250826 492.6 ... 496 491.9 SC
3 SC2512 20250826 490.4 ... 493.2 489.5 SC
4 SC2601 20250826 488.6 ... 491.7 488.1 SC
5 SC2602 20250826 487.6 ... 490.5 486.9 SC
6 SC2603 20250826 486.1 ... 488.2 485.7 SC
7 SC2604 20250826 486.6 ... 486.4 485.5 SC
8 SC2605 20250826 485.4 ... 485.8 483.1 SC
9 SC2606 20250826 484.3 ... 484.9 483.4 SC
10 SC2607 20250826 482.3 ... 482.3 481.1 SC
11 SC2608 20250826 481.3 ... 481.3 482.2 SC
12 SC2609 20250826 482.6 ... 482.3 480.7 SC
13 SC2612 20250826 482.2 ... 482.2 483.6 SC
14 SC2703 20250826 483.7 ... 483.7 478.9 SC
15 SC2706 20250826 479.5 ... 479.5 481.1 SC
16 SC2709 20250826 481.8 ... 482.5 480.1 SC
17 SC2712 20250826 480.3 ... 481 479.2 SC
18 SC2803 20250826 479.5 ... 479.5 479.5 SC
19 SC2806 20250826 472.2 ... 474.5 471.9 SC
21 LU2509 20250826 3421 ... 3426 3452 LU
22 LU2510 20250826 3546 ... 3532 3511 LU
23 LU2511 20250826 3531 ... 3537 3521 LU
24 LU2512 20250826 3523 ... 3522 3508 LU
25 LU2601 20250826 3499 ... 3498 3488 LU
26 LU2602 20250826 3468 ... 3476 3465 LU
27 LU2603 20250826 3460 ... 3469 3458 LU
28 LU2604 20250826 3466 ... 3463 3455 LU
29 LU2605 20250826 3457 ... 3455 3443 LU
30 LU2606 20250826 3452 ... 3454 3438 LU
31 LU2607 20250826 3457 ... 3454 3434 LU
32 LU2608 20250826 3449 ... 3450 3435 LU
34 NR2509 20250826 12705 ... 12755 12665 NR
35 NR2510 20250826 12735 ... 12840 12720 NR
36 NR2511 20250826 12765 ... 12865 12750 NR
37 NR2512 20250826 12805 ... 12875 12790 NR
38 NR2601 20250826 12825 ... 12920 12805 NR
39 NR2602 20250826 12840 ... 12860 12775 NR
40 NR2603 20250826 12890 ... 12910 12735 NR
41 NR2604 20250826 13055 ... 13055 12760 NR
42 NR2605 20250826 13110 ... 13080 12915 NR
43 NR2606 20250826 13140 ... 13140 12745 NR
44 NR2607 20250826 ... 12780 12780 NR
45 NR2608 20250826 ... 12780 12780 NR
47 BC2509 20250826 70700 ... 70620 70290 BC
48 BC2510 20250826 70860 ... 70630 70380 BC
49 BC2511 20250826 70430 ... 70440 70530 BC
50 BC2512 20250826 ... 70180 69780 BC
51 BC2601 20250826 ... 70100 70100 BC
52 BC2602 20250826 ... 70100 70100 BC
53 BC2603 20250826 ... 70100 70100 BC
54 BC2604 20250826 ... 70100 70100 BC
55 BC2605 20250826 70490 ... 70490 69800 BC
56 BC2606 20250826 ... 69790 69790 BC
57 BC2607 20250826 ... 69370 69370 BC
58 BC2608 20250826 ... 69370 69370 BC
60 EC2510 20250826 1345 ... 1327.8 1356.3 EC
61 EC2512 20250826 1686.7 ... 1663.1 1691 EC
62 EC2602 20250826 1486.9 ... 1472.8 1492.6 EC
63 EC2604 20250826 1284 ... 1276.1 1294.4 EC
64 EC2606 20250826 1435.2 ... 1432.5 1451.3 EC
65 EC2608 20250826 1598.6 ... 1626.3 1451.3 EC
68 SC_TAS2510 20250826 ... SC_TAS
69 SC_TAS2511 20250826 ... SC_TAS
70 SC_TAS2512 20250826 ... SC_TAS
[65 rows x 12 columns]
2025-08-27 18:32:23,416 - future_1d - INFO - ak.get_ine_daily('2025-08-26') done
2025-08-27 18:32:25,264 - future_1d - INFO - 写入 815 条修改数据到 future_daily_modified 表
2025-08-27 18:32:25,281 - future_1d - INFO - save future_daily 2025-08-26 completed
symbol date open high ... turnover settle pre_settle variety
0 AP510 20250827 8146.0 8320.0 ... 926963.07 8249.0 8158.0 AP
1 AP511 20250827 7965.0 8063.0 ... 8291.69 8019.0 7957.0 AP
2 AP512 20250827 7998.0 8068.0 ... 2190.20 8052.0 7974.0 AP
3 AP601 20250827 8055.0 8160.0 ... 157852.48 8106.0 8061.0 AP
4 AP603 20250827 7964.0 8045.0 ... 409.48 8029.0 7959.0 AP
5 AP604 20250827 7981.0 8054.0 ... 152.54 8028.0 7974.0 AP
6 AP605 20250827 8031.0 8110.0 ... 1229.23 8087.0 8037.0 AP
7 CF509 20250827 13760.0 13800.0 ... 140783.76 13775.0 13810.0 CF
8 CF511 20250827 14015.0 14070.0 ... 291023.09 14015.0 14040.0 CF
9 CF601 20250827 14080.0 14150.0 ... 1358089.94 14095.0 14120.0 CF
10 CF603 20250827 14045.0 14100.0 ... 2017.40 14060.0 14085.0 CF
11 CF605 20250827 14030.0 14100.0 ... 51710.60 14050.0 14075.0 CF
12 CF607 20250827 14060.0 14095.0 ... 126.53 14060.0 14090.0 CF
13 CJ509 20250827 10105.0 10140.0 ... 6307.22 10075.0 10100.0 CJ
14 CJ512 20250827 11300.0 11325.0 ... 10499.98 11280.0 11290.0 CJ
15 CJ601 20250827 11380.0 11435.0 ... 546132.08 11385.0 11395.0 CJ
16 CJ603 20250827 11460.0 11465.0 ... 5836.30 11420.0 11425.0 CJ
17 CJ605 20250827 11530.0 11590.0 ... 69411.21 11545.0 11540.0 CJ
18 CJ607 20250827 11735.0 11735.0 ... 695.95 11695.0 11695.0 CJ
19 CY509 20250827 20235.0 20575.0 ... 334.83 20295.0 20125.0 CY
20 CY510 20250827 0.0 0.0 ... 0.00 19705.0 19705.0 CY
21 CY511 20250827 20105.0 20155.0 ... 71404.22 20120.0 20160.0 CY
22 CY512 20250827 0.0 0.0 ... 0.00 19905.0 19905.0 CY
23 CY601 20250827 20095.0 20150.0 ... 814.10 20100.0 20165.0 CY
24 CY602 20250827 0.0 0.0 ... 0.00 20015.0 20015.0 CY
25 CY603 20250827 0.0 0.0 ... 0.00 20295.0 20295.0 CY
26 CY604 20250827 0.0 0.0 ... 0.00 20030.0 20030.0 CY
27 CY605 20250827 0.0 0.0 ... 0.00 20395.0 20395.0 CY
28 CY606 20250827 0.0 0.0 ... 0.00 20010.0 20010.0 CY
29 CY607 20250827 0.0 0.0 ... 0.00 20205.0 20205.0 CY
30 CY608 20250827 0.0 0.0 ... 0.00 20295.0 20295.0 CY
31 FG509 20250827 987.0 994.0 ... 183644.63 988.0 995.0 FG
32 FG510 20250827 1085.0 1094.0 ... 61235.63 1087.0 1099.0 FG
33 FG511 20250827 1075.0 1089.0 ... 99568.72 1080.0 1088.0 FG
34 FG512 20250827 1179.0 1191.0 ... 61776.24 1183.0 1190.0 FG
35 FG601 20250827 1171.0 1188.0 ... 3047260.58 1178.0 1183.0 FG
36 FG602 20250827 1220.0 1238.0 ... 1110.80 1229.0 1235.0 FG
37 FG603 20250827 1226.0 1239.0 ... 797.62 1231.0 1235.0 FG
38 FG604 20250827 1277.0 1284.0 ... 541.37 1277.0 1280.0 FG
39 FG605 20250827 1266.0 1279.0 ... 45100.95 1269.0 1271.0 FG
40 FG606 20250827 1292.0 1306.0 ... 317.05 1299.0 1304.0 FG
41 FG607 20250827 1282.0 1300.0 ... 578.56 1291.0 1293.0 FG
42 FG608 20250827 1311.0 1322.0 ... 271.05 1316.0 1320.0 FG
43 JR509 20250827 0.0 0.0 ... 0.00 2662.0 2662.0 JR
44 JR511 20250827 0.0 0.0 ... 0.00 2662.0 2662.0 JR
45 JR601 20250827 0.0 0.0 ... 0.00 2662.0 2662.0 JR
46 JR603 20250827 0.0 0.0 ... 0.00 2662.0 2662.0 JR
47 JR605 20250827 0.0 0.0 ... 0.00 2662.0 2662.0 JR
48 JR607 20250827 0.0 0.0 ... 0.00 2662.0 2662.0 JR
49 LR509 20250827 0.0 0.0 ... 0.00 2360.0 2360.0 LR
50 LR511 20250827 0.0 0.0 ... 0.00 2360.0 2360.0 LR
51 LR601 20250827 0.0 0.0 ... 0.00 2360.0 2360.0 LR
52 MA509 20250827 2272.0 2275.0 ... 52972.52 2262.0 2295.0 MA
53 MA510 20250827 2311.0 2313.0 ... 66260.92 2298.0 2330.0 MA
54 MA511 20250827 2336.0 2336.0 ... 116686.04 2320.0 2352.0 MA
55 MA512 20250827 2376.0 2377.0 ... 33349.53 2363.0 2393.0 MA
56 MA601 20250827 2393.0 2396.0 ... 1149229.47 2383.0 2413.0 MA
57 MA602 20250827 2400.0 2404.0 ... 107.77 2395.0 2416.0 MA
58 MA603 20250827 2396.0 2402.0 ... 102.85 2392.0 2415.0 MA
59 MA604 20250827 2379.0 2392.0 ... 16.72 2388.0 2404.0 MA
60 MA605 20250827 2383.0 2384.0 ... 37229.83 2373.0 2394.0 MA
61 MA606 20250827 2387.0 2387.0 ... 33.32 2380.0 2404.0 MA
62 MA607 20250827 2387.0 2387.0 ... 102.28 2379.0 2400.0 MA
63 MA608 20250827 2383.0 2385.0 ... 40.46 2380.0 2400.0 MA
64 OI509 20250827 9930.0 10000.0 ... 80313.77 9952.0 10001.0 OI
65 OI511 20250827 9880.0 9969.0 ... 452914.45 9919.0 9961.0 OI
66 OI601 20250827 9805.0 9888.0 ... 2578158.14 9840.0 9897.0 OI
67 OI603 20250827 9735.0 9806.0 ... 1756.73 9760.0 9807.0 OI
68 OI605 20250827 9639.0 9715.0 ... 27420.95 9676.0 9724.0 OI
69 OI607 20250827 9624.0 9671.0 ... 607.22 9638.0 9691.0 OI
70 PF509 20250827 6486.0 6514.0 ... 1166.65 6482.0 6504.0 PF
71 PF510 20250827 6598.0 6644.0 ... 460230.86 6610.0 6624.0 PF
72 PF511 20250827 6578.0 6622.0 ... 213319.68 6586.0 6612.0 PF
73 PF512 20250827 6558.0 6606.0 ... 68745.78 6574.0 6590.0 PF
74 PF601 20250827 6564.0 6602.0 ... 23842.54 6566.0 6596.0 PF
75 PF602 20250827 6676.0 6676.0 ... 151.34 6580.0 6596.0 PF
76 PF603 20250827 6690.0 6690.0 ... 72.49 6590.0 6614.0 PF
77 PF604 20250827 6624.0 6654.0 ... 82.80 6624.0 6646.0 PF
78 PF605 20250827 6624.0 6670.0 ... 122.70 6632.0 6658.0 PF
79 PF606 20250827 6638.0 6674.0 ... 56.45 6642.0 6678.0 PF
80 PF607 20250827 6658.0 6658.0 ... 13.27 6638.0 6678.0 PF
81 PF608 20250827 0.0 0.0 ... 0.00 6640.0 6662.0 PF
82 PK510 20250827 8080.0 8086.0 ... 57448.49 8054.0 8038.0 PK
83 PK511 20250827 7836.0 7848.0 ... 283468.56 7810.0 7812.0 PK
84 PK512 20250827 7848.0 7866.0 ... 73296.42 7824.0 7842.0 PK
85 PK601 20250827 7900.0 7918.0 ... 32612.27 7882.0 7898.0 PK
86 PK603 20250827 7894.0 7898.0 ... 177.21 7876.0 7906.0 PK
87 PK604 20250827 7906.0 7906.0 ... 189.41 7892.0 7902.0 PK
88 PK605 20250827 7918.0 7922.0 ... 4204.28 7896.0 7904.0 PK
89 PL601 20250827 6460.0 6474.0 ... 10374.77 6460.0 6482.0 PL
90 PL602 20250827 6499.0 6509.0 ... 272.60 6490.0 6528.0 PL
91 PL603 20250827 6501.0 6501.0 ... 38.89 6482.0 6500.0 PL
92 PL604 20250827 6473.0 6473.0 ... 12.95 6473.0 6498.0 PL
93 PL605 20250827 6372.0 6374.0 ... 50.97 6372.0 6391.0 PL
94 PL606 20250827 0.0 0.0 ... 0.00 6470.0 6479.0 PL
95 PL607 20250827 0.0 0.0 ... 0.00 6494.0 6512.0 PL
96 PL608 20250827 0.0 0.0 ... 0.00 6500.0 6500.0 PL
97 PM509 20250827 0.0 0.0 ... 0.00 3122.0 3122.0 PM
98 PM511 20250827 0.0 0.0 ... 0.00 3122.0 3122.0 PM
99 PM601 20250827 0.0 0.0 ... 0.00 3122.0 3122.0 PM
100 PM603 20250827 0.0 0.0 ... 0.00 3122.0 3122.0 PM
101 PM605 20250827 0.0 0.0 ... 0.00 3122.0 3122.0 PM
102 PM607 20250827 0.0 0.0 ... 0.00 3122.0 3122.0 PM
103 PR509 20250827 5838.0 5894.0 ... 2325.49 5850.0 5892.0 PR
104 PR510 20250827 6012.0 6056.0 ... 111464.45 6020.0 6052.0 PR
105 PR511 20250827 6022.0 6068.0 ... 759067.61 6028.0 6058.0 PR
106 PR512 20250827 6020.0 6072.0 ... 492386.21 6032.0 6052.0 PR
107 PR601 20250827 6030.0 6068.0 ... 5812.95 6028.0 6062.0 PR
108 PR602 20250827 6048.0 6048.0 ... 9.07 6048.0 6070.0 PR
109 PR603 20250827 0.0 0.0 ... 0.00 6034.0 6092.0 PR
110 PR604 20250827 6056.0 6056.0 ... 9.08 6056.0 6088.0 PR
111 PR605 20250827 6056.0 6058.0 ... 18.17 6058.0 6094.0 PR
112 PR606 20250827 6058.0 6060.0 ... 18.18 6060.0 6080.0 PR
113 PR607 20250827 0.0 0.0 ... 0.00 6082.0 6082.0 PR
114 PR608 20250827 0.0 0.0 ... 0.00 6080.0 6080.0 PR
115 PX509 20250827 6990.0 7046.0 ... 4944.58 6980.0 7048.0 PX
116 PX510 20250827 6994.0 7118.0 ... 567806.15 7022.0 7088.0 PX
117 PX511 20250827 6972.0 7094.0 ... 1475445.76 7010.0 7050.0 PX
118 PX512 20250827 6926.0 7020.0 ... 102569.87 6942.0 6982.0 PX
119 PX601 20250827 6900.0 6972.0 ... 169888.82 6916.0 6954.0 PX
120 PX602 20250827 6904.0 6942.0 ... 20.73 6912.0 6952.0 PX
121 PX603 20250827 6940.0 6940.0 ... 6.93 6928.0 6940.0 PX
122 PX604 20250827 0.0 0.0 ... 0.00 6852.0 6944.0 PX
123 PX605 20250827 6902.0 6956.0 ... 295.87 6882.0 6948.0 PX
124 PX606 20250827 0.0 0.0 ... 0.00 6842.0 6886.0 PX
125 PX607 20250827 6858.0 6858.0 ... 3.43 6858.0 6878.0 PX
126 PX608 20250827 6788.0 6830.0 ... 6.81 6810.0 6818.0 PX
127 RI509 20250827 0.0 0.0 ... 0.00 2479.0 2479.0 RI
128 RI511 20250827 0.0 0.0 ... 0.00 2479.0 2479.0 RI
129 RI601 20250827 0.0 0.0 ... 0.00 2479.0 2479.0 RI
130 RI603 20250827 0.0 0.0 ... 0.00 2479.0 2479.0 RI
131 RI605 20250827 0.0 0.0 ... 0.00 2479.0 2479.0 RI
132 RI607 20250827 0.0 0.0 ... 0.00 2479.0 2479.0 RI
133 RM509 20250827 2615.0 2615.0 ... 34464.73 2574.0 2606.0 RM
134 RM511 20250827 2552.0 2554.0 ... 21167.22 2531.0 2577.0 RM
135 RM601 20250827 2520.0 2520.0 ... 1072008.77 2501.0 2544.0 RM
136 RM603 20250827 2464.0 2465.0 ... 35822.86 2437.0 2484.0 RM
137 RM605 20250827 2460.0 2461.0 ... 178174.21 2449.0 2474.0 RM
138 RM607 20250827 2442.0 2444.0 ... 10095.49 2431.0 2455.0 RM
139 RM608 20250827 2508.0 2508.0 ... 222.46 2500.0 2521.0 RM
140 RS509 20250827 4877.0 4877.0 ... 53.28 4844.0 4852.0 RS
141 RS511 20250827 5200.0 5200.0 ... 15.54 5181.0 5268.0 RS
142 RS607 20250827 5600.0 5633.0 ... 112.26 5613.0 5643.0 RS
143 RS608 20250827 0.0 0.0 ... 0.00 5627.0 5627.0 RS
144 SA509 20250827 1195.0 1208.0 ... 110500.64 1198.0 1214.0 SA
145 SA510 20250827 1243.0 1252.0 ... 188678.40 1245.0 1259.0 SA
146 SA511 20250827 1246.0 1258.0 ... 312162.64 1249.0 1263.0 SA
147 SA512 20250827 1306.0 1316.0 ... 101487.75 1307.0 1321.0 SA
148 SA601 20250827 1312.0 1325.0 ... 2895057.23 1314.0 1327.0 SA
149 SA602 20250827 1339.0 1346.0 ... 3013.11 1336.0 1345.0 SA
150 SA603 20250827 1335.0 1349.0 ... 2024.22 1339.0 1347.0 SA
151 SA604 20250827 1372.0 1384.0 ... 718.60 1377.0 1386.0 SA
152 SA605 20250827 1375.0 1390.0 ... 80453.14 1380.0 1388.0 SA
153 SA606 20250827 1379.0 1395.0 ... 751.55 1387.0 1391.0 SA
154 SA607 20250827 1382.0 1409.0 ... 1920.70 1390.0 1392.0 SA
155 SA608 20250827 1395.0 1430.0 ... 595.92 1405.0 1406.0 SA
156 SF509 20250827 5468.0 5506.0 ... 19456.46 5466.0 5502.0 SF
157 SF510 20250827 5478.0 5514.0 ... 123983.55 5470.0 5510.0 SF
158 SF511 20250827 5656.0 5698.0 ... 503108.15 5658.0 5692.0 SF
159 SF512 20250827 5656.0 5678.0 ... 63029.73 5636.0 5680.0 SF
160 SF601 20250827 5636.0 5672.0 ... 92274.24 5630.0 5668.0 SF
161 SF602 20250827 5624.0 5634.0 ... 495.55 5600.0 5632.0 SF
162 SF603 20250827 5790.0 5800.0 ... 46.29 5786.0 5814.0 SF
163 SF604 20250827 5800.0 5800.0 ... 23.15 5788.0 5808.0 SF
164 SF605 20250827 5780.0 5788.0 ... 1359.53 5762.0 5794.0 SF
165 SF606 20250827 5744.0 5754.0 ... 34.41 5736.0 5752.0 SF
166 SF607 20250827 5908.0 5908.0 ... 20.59 5884.0 5904.0 SF
167 SF608 20250827 5854.0 5854.0 ... 2.93 5854.0 5884.0 SF
168 SH509 20250827 2540.0 2562.0 ... 30450.02 2551.0 2564.0 SH
169 SH510 20250827 2671.0 2687.0 ... 384752.20 2661.0 2701.0 SH
170 SH511 20250827 2686.0 2708.0 ... 764206.52 2679.0 2727.0 SH
171 SH512 20250827 2700.0 2733.0 ... 189483.02 2707.0 2748.0 SH
172 SH601 20250827 2700.0 2726.0 ... 3476304.62 2702.0 2739.0 SH
173 SH602 20250827 2719.0 2737.0 ... 8069.88 2717.0 2749.0 SH
174 SH603 20250827 2692.0 2746.0 ... 4354.43 2728.0 2757.0 SH
175 SH604 20250827 2781.0 2787.0 ... 998.01 2772.0 2802.0 SH
176 SH605 20250827 2791.0 2804.0 ... 45296.05 2788.0 2815.0 SH
177 SH606 20250827 2790.0 2801.0 ... 410.22 2791.0 2812.0 SH
178 SH607 20250827 2771.0 2778.0 ... 83.09 2770.0 2789.0 SH
179 SH608 20250827 2780.0 2785.0 ... 241.28 2773.0 2793.0 SH
180 SM509 20250827 5760.0 5784.0 ... 43070.78 5756.0 5794.0 SM
181 SM510 20250827 5778.0 5800.0 ... 99261.45 5770.0 5800.0 SM
182 SM511 20250827 5842.0 5876.0 ... 204141.18 5844.0 5872.0 SM
183 SM512 20250827 5858.0 5876.0 ... 35796.72 5852.0 5880.0 SM
184 SM601 20250827 5860.0 5886.0 ... 379198.22 5856.0 5886.0 SM
185 SM602 20250827 5890.0 5890.0 ... 129.25 5876.0 5894.0 SM
186 SM603 20250827 5906.0 5906.0 ... 109.05 5896.0 5910.0 SM
187 SM604 20250827 5900.0 5900.0 ... 5.89 5892.0 5910.0 SM
188 SM605 20250827 5920.0 5930.0 ... 8566.43 5904.0 5930.0 SM
189 SM606 20250827 5908.0 5908.0 ... 5.90 5902.0 5946.0 SM
190 SM607 20250827 5956.0 5956.0 ... 14.80 5922.0 5962.0 SM
191 SM608 20250827 5936.0 5948.0 ... 14.83 5932.0 5964.0 SM
192 SR509 20250827 5683.0 5683.0 ... 25856.77 5647.0 5696.0 SR
193 SR511 20250827 5625.0 5625.0 ... 193997.04 5611.0 5647.0 SR
194 SR601 20250827 5632.0 5639.0 ... 829540.50 5625.0 5658.0 SR
195 SR603 20250827 5608.0 5616.0 ... 2135.64 5605.0 5631.0 SR
196 SR605 20250827 5601.0 5604.0 ... 30929.99 5593.0 5623.0 SR
197 SR607 20250827 5593.0 5598.0 ... 1000.40 5589.0 5610.0 SR
198 TA509 20250827 4830.0 4848.0 ... 142268.56 4816.0 4844.0 TA
199 TA510 20250827 4860.0 4900.0 ... 323537.31 4856.0 4898.0 TA
200 TA511 20250827 4850.0 4896.0 ... 258008.27 4852.0 4882.0 TA
201 TA512 20250827 4852.0 4896.0 ... 72401.63 4856.0 4878.0 TA
202 TA601 20250827 4854.0 4892.0 ... 1664651.22 4854.0 4882.0 TA
203 TA602 20250827 4870.0 4890.0 ... 60.77 4862.0 4892.0 TA
204 TA603 20250827 4864.0 4904.0 ... 149.28 4896.0 4904.0 TA
205 TA604 20250827 4864.0 4906.0 ... 24.47 4896.0 4900.0 TA
206 TA605 20250827 4894.0 4918.0 ... 27613.75 4886.0 4914.0 TA
207 TA606 20250827 4900.0 4900.0 ... 14.68 4892.0 4926.0 TA
208 TA607 20250827 4884.0 4884.0 ... 21.95 4878.0 4942.0 TA
209 TA608 20250827 4902.0 4902.0 ... 7.34 4892.0 4934.0 TA
210 UR509 20250827 1703.0 1728.0 ... 19636.29 1710.0 1710.0 UR
211 UR510 20250827 1708.0 1735.0 ... 24795.19 1719.0 1717.0 UR
212 UR511 20250827 1743.0 1761.0 ... 39305.24 1743.0 1743.0 UR
213 UR512 20250827 1733.0 1759.0 ... 365.99 1743.0 1740.0 UR
214 UR601 20250827 1740.0 1763.0 ... 650016.47 1745.0 1742.0 UR
215 UR602 20250827 1739.0 1760.0 ... 617.81 1745.0 1738.0 UR
216 UR603 20250827 1776.0 1795.0 ... 389.21 1785.0 1780.0 UR
217 UR604 20250827 1775.0 1793.0 ... 282.06 1785.0 1782.0 UR
218 UR605 20250827 1778.0 1794.0 ... 25228.61 1781.0 1783.0 UR
219 UR606 20250827 1770.0 1787.0 ... 184.42 1773.0 1776.0 UR
220 UR607 20250827 1790.0 1804.0 ... 375.91 1790.0 1792.0 UR
221 UR608 20250827 1789.0 1800.0 ... 186.26 1791.0 1791.0 UR
222 WH509 20250827 0.0 0.0 ... 0.00 3198.0 3198.0 WH
223 WH511 20250827 0.0 0.0 ... 0.00 3198.0 3198.0 WH
224 WH601 20250827 0.0 0.0 ... 0.00 3198.0 3198.0 WH
225 WH603 20250827 0.0 0.0 ... 0.00 3198.0 3198.0 WH
226 WH605 20250827 0.0 0.0 ... 0.00 3198.0 3198.0 WH
227 WH607 20250827 0.0 0.0 ... 0.00 3198.0 3198.0 WH
228 ZC509 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
229 ZC510 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
230 ZC511 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
231 ZC512 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
232 ZC601 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
233 ZC602 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
234 ZC603 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
235 ZC604 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
236 ZC605 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
237 ZC606 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
238 ZC607 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
239 ZC608 20250827 0.0 0.0 ... 0.00 801.4 801.4 ZC
[240 rows x 12 columns]
2025-08-27 18:32:34,200 - future_1d - INFO - ak.get_czce_daily('2025-08-27') done
symbol date open ... settle pre_settle variety
0 PS2509 20250827 51580.0 ... 50050.0 51230.0 PS
1 PS2510 20250827 51150.0 ... 49980.0 51330.0 PS
2 PS2511 20250827 50915.0 ... 49715.0 51195.0 PS
3 PS2512 20250827 53490.0 ... 52155.0 53530.0 PS
4 PS2601 20250827 53350.0 ... 52280.0 53640.0 PS
5 PS2602 20250827 53580.0 ... 52570.0 53830.0 PS
6 PS2603 20250827 53590.0 ... 52555.0 53945.0 PS
7 PS2604 20250827 53980.0 ... 52860.0 54155.0 PS
8 PS2605 20250827 54000.0 ... 52810.0 54130.0 PS
9 PS2606 20250827 56545.0 ... 55380.0 56815.0 PS
10 PS2607 20250827 56700.0 ... 55400.0 56930.0 PS
11 PS2608 20250827 56810.0 ... 55415.0 57030.0 PS
13 SI2509 20250827 8540.0 ... 8505.0 8625.0 SI
14 SI2510 20250827 8495.0 ... 8530.0 8640.0 SI
15 SI2511 20250827 8525.0 ... 8540.0 8660.0 SI
16 SI2512 20250827 8885.0 ... 8900.0 9005.0 SI
17 SI2601 20250827 8890.0 ... 8885.0 9005.0 SI
18 SI2602 20250827 8880.0 ... 8870.0 9005.0 SI
19 SI2603 20250827 8910.0 ... 8905.0 8990.0 SI
20 SI2604 20250827 8900.0 ... 8915.0 8995.0 SI
21 SI2605 20250827 8955.0 ... 8915.0 9035.0 SI
22 SI2606 20250827 8935.0 ... 8935.0 9000.0 SI
23 SI2607 20250827 8965.0 ... 8930.0 9035.0 SI
24 SI2608 20250827 8930.0 ... 8915.0 8980.0 SI
27 LC2509 20250827 78960.0 ... 79880.0 79080.0 LC
28 LC2510 20250827 79240.0 ... 80140.0 79200.0 LC
29 LC2511 20250827 79260.0 ... 80000.0 79040.0 LC
30 LC2512 20250827 78960.0 ... 79540.0 78740.0 LC
31 LC2601 20250827 78800.0 ... 79320.0 78520.0 LC
32 LC2602 20250827 78120.0 ... 78780.0 77920.0 LC
33 LC2603 20250827 78120.0 ... 78500.0 77700.0 LC
34 LC2604 20250827 77840.0 ... 78360.0 77480.0 LC
35 LC2605 20250827 77700.0 ... 78160.0 77480.0 LC
36 LC2606 20250827 77300.0 ... 77840.0 77320.0 LC
37 LC2607 20250827 77440.0 ... 77780.0 77160.0 LC
38 LC2608 20250827 78000.0 ... 78180.0 77460.0 LC
[36 rows x 12 columns]
2025-08-27 18:32:34,454 - future_1d - INFO - ak.get_gfex_daily('2025-08-27') done
index symbol date ... settle pre_settle variety
0 0 CU2509 20250827 ... 79340 79450 CU
1 1 CU2510 20250827 ... 79350 79460 CU
2 2 CU2511 20250827 ... 79340 79440 CU
3 3 CU2512 20250827 ... 79310 79410 CU
4 4 CU2601 20250827 ... 79330 79410 CU
5 5 CU2602 20250827 ... 79330 79340 CU
6 6 CU2603 20250827 ... 79330 79360 CU
7 7 CU2604 20250827 ... 79360 79390 CU
8 8 CU2605 20250827 ... 79370 79400 CU
9 9 CU2606 20250827 ... 79360 79380 CU
10 10 CU2607 20250827 ... 79410 79390 CU
11 11 CU2608 20250827 ... 79440 79250 CU
12 12 BC2509 20250827 ... 70410 70620 BC
13 13 BC2510 20250827 ... 70470 70630 BC
14 14 BC2511 20250827 ... 70390 70440 BC
15 15 BC2512 20250827 ... 70180 70180 BC
16 16 BC2601 20250827 ... 70100 70100 BC
17 17 BC2602 20250827 ... 70100 70100 BC
18 18 BC2603 20250827 ... 70100 70100 BC
19 19 BC2604 20250827 ... 70100 70100 BC
20 20 BC2605 20250827 ... 70490 70490 BC
21 21 BC2606 20250827 ... 69790 69790 BC
22 22 BC2607 20250827 ... 69370 69370 BC
23 23 BC2608 20250827 ... 69370 69370 BC
24 24 AL2509 20250827 ... 20855 20750 AL
25 25 AL2510 20250827 ... 20850 20730 AL
26 26 AL2511 20250827 ... 20830 20710 AL
27 27 AL2512 20250827 ... 20790 20670 AL
28 28 AL2601 20250827 ... 20765 20640 AL
29 29 AL2602 20250827 ... 20760 20645 AL
30 30 AL2603 20250827 ... 20795 20660 AL
31 31 AL2604 20250827 ... 20820 20695 AL
32 32 AL2605 20250827 ... 20835 20705 AL
33 33 AL2606 20250827 ... 20785 20715 AL
34 34 AL2607 20250827 ... 20785 20720 AL
35 35 AL2608 20250827 ... 20845 20755 AL
36 36 ZN2509 20250827 ... 22335 22300 ZN
37 37 ZN2510 20250827 ... 22350 22305 ZN
38 38 ZN2511 20250827 ... 22340 22300 ZN
39 39 ZN2512 20250827 ... 22335 22310 ZN
40 40 ZN2601 20250827 ... 22335 22290 ZN
41 41 ZN2602 20250827 ... 22325 22290 ZN
42 42 ZN2603 20250827 ... 22335 22335 ZN
43 43 ZN2604 20250827 ... 22360 22360 ZN
44 44 ZN2605 20250827 ... 22350 22370 ZN
45 45 ZN2606 20250827 ... 22375 22365 ZN
46 46 ZN2607 20250827 ... 22390 22405 ZN
47 47 ZN2608 20250827 ... 22395 22440 ZN
48 48 PB2509 20250827 ... 16890 16895 PB
49 49 PB2510 20250827 ... 16915 16915 PB
50 50 PB2511 20250827 ... 16905 16915 PB
51 51 PB2512 20250827 ... 16905 16930 PB
52 52 PB2601 20250827 ... 16930 16945 PB
53 53 PB2602 20250827 ... 16965 16965 PB
54 54 PB2603 20250827 ... 16995 17005 PB
55 55 PB2604 20250827 ... 17005 17030 PB
56 56 PB2605 20250827 ... 17035 17050 PB
57 57 PB2606 20250827 ... 17060 17055 PB
58 58 PB2607 20250827 ... 17085 17095 PB
59 59 PB2608 20250827 ... 17090 17100 PB
60 60 NI2509 20250827 ... 121550 120180 NI
61 61 NI2510 20250827 ... 121830 120350 NI
62 62 NI2511 20250827 ... 122040 120500 NI
63 63 NI2512 20250827 ... 122230 120750 NI
64 64 NI2601 20250827 ... 122450 121010 NI
65 65 NI2602 20250827 ... 122520 121230 NI
66 66 NI2603 20250827 ... 122840 121530 NI
67 67 NI2604 20250827 ... 123180 121860 NI
68 68 NI2605 20250827 ... 123490 122100 NI
69 69 NI2606 20250827 ... 123750 122400 NI
70 70 NI2607 20250827 ... 123810 122710 NI
71 71 NI2608 20250827 ... 123950 123030 NI
72 72 SN2509 20250827 ... 270810 269350 SN
73 73 SN2510 20250827 ... 271490 269730 SN
74 74 SN2511 20250827 ... 271880 269930 SN
75 75 SN2512 20250827 ... 271990 269870 SN
76 76 SN2601 20250827 ... 272130 269800 SN
77 77 SN2602 20250827 ... 272110 270010 SN
78 78 SN2603 20250827 ... 271400 270300 SN
79 79 SN2604 20250827 ... 272420 270550 SN
80 80 SN2605 20250827 ... 272750 270740 SN
81 81 SN2606 20250827 ... 273130 270910 SN
82 82 SN2607 20250827 ... 273260 270930 SN
83 83 SN2608 20250827 ... 271540 271730 SN
84 84 AO2509 20250827 ... 3053 3107 AO
85 85 AO2510 20250827 ... 3053 3117 AO
86 86 AO2511 20250827 ... 3054 3113 AO
87 87 AO2512 20250827 ... 3057 3165 AO
88 88 AO2601 20250827 ... 3066 3129 AO
89 89 AO2602 20250827 ... 3063 3125 AO
90 90 AO2603 20250827 ... 3070 3123 AO
91 91 AO2604 20250827 ... 3072 3107 AO
92 92 AO2605 20250827 ... 3076 3122 AO
93 93 AO2606 20250827 ... 3082 3131 AO
94 94 AO2607 20250827 ... 3083 3114 AO
95 95 AO2608 20250827 ... 3082 3111 AO
96 96 AD2511 20250827 ... 20440 20285 AD
97 97 AD2512 20250827 ... 20425 20285 AD
98 98 AD2601 20250827 ... 20425 20280 AD
99 99 AD2602 20250827 ... 20425 20220 AD
100 100 AD2603 20250827 ... 20220 20220 AD
101 101 AD2604 20250827 ... 19975 19975 AD
102 102 AD2605 20250827 ... 20160 19975 AD
103 103 AD2606 20250827 ... 19795 19795 AD
104 104 AD2607 20250827 ... 19925 19925 AD
105 105 AD2608 20250827 ... 20315 19925 AD
106 106 AU2509 20250827 ... 780.46 779.02 AU
107 107 AU2510 20250827 ... 781.56 780.24 AU
108 108 AU2511 20250827 ... 783.48 782.08 AU
109 109 AU2512 20250827 ... 783.86 782.68 AU
110 110 AU2602 20250827 ... 785.86 784.64 AU
111 111 AU2604 20250827 ... 788.12 786.86 AU
112 112 AU2606 20250827 ... 790.16 789.16 AU
113 113 AU2608 20250827 ... 792.34 791.64 AU
114 114 AG2509 20250827 ... 9313 9333 AG
115 115 AG2510 20250827 ... 9325 9354 AG
116 116 AG2511 20250827 ... 9336 9365 AG
117 117 AG2512 20250827 ... 9345 9375 AG
118 118 AG2601 20250827 ... 9356 9386 AG
119 119 AG2602 20250827 ... 9370 9399 AG
120 120 AG2603 20250827 ... 9380 9412 AG
121 121 AG2604 20250827 ... 9394 9424 AG
122 122 AG2605 20250827 ... 9406 9437 AG
123 123 AG2606 20250827 ... 9417 9450 AG
124 124 AG2607 20250827 ... 9432 9463 AG
125 125 AG2608 20250827 ... 9449 9476 AG
126 126 RB2509 20250827 ... 3082 3099 RB
127 127 RB2510 20250827 ... 3112 3126 RB
128 128 RB2511 20250827 ... 3114 3136 RB
129 129 RB2512 20250827 ... 3166 3188 RB
130 130 RB2601 20250827 ... 3180 3206 RB
131 131 RB2602 20250827 ... 3166 3190 RB
132 132 RB2603 20250827 ... 3183 3211 RB
133 133 RB2604 20250827 ... 3200 3228 RB
134 134 RB2605 20250827 ... 3221 3242 RB
135 135 RB2606 20250827 ... 3232 3257 RB
136 136 RB2607 20250827 ... 3243 3268 RB
137 137 RB2608 20250827 ... 3243 3281 RB
138 138 WR2509 20250827 ... 3342 3342 WR
139 139 WR2510 20250827 ... 3322 3365 WR
140 140 WR2511 20250827 ... 3368 3376 WR
141 141 WR2512 20250827 ... 3474 3486 WR
142 142 WR2601 20250827 ... 3380 3380 WR
143 143 WR2602 20250827 ... 3450 3459 WR
144 144 WR2603 20250827 ... 3438 3438 WR
145 145 WR2604 20250827 ... 3455 3455 WR
146 146 WR2605 20250827 ... 3429 3429 WR
147 147 WR2606 20250827 ... 3440 3441 WR
148 148 WR2607 20250827 ... 3460 3488 WR
149 149 WR2608 20250827 ... 3475 3477 WR
150 150 HC2509 20250827 ... 3389 3407 HC
151 151 HC2510 20250827 ... 3357 3380 HC
152 152 HC2511 20250827 ... 3355 3379 HC
153 153 HC2512 20250827 ... 3356 3386 HC
154 154 HC2601 20250827 ... 3346 3370 HC
155 155 HC2602 20250827 ... 3348 3371 HC
156 156 HC2603 20250827 ... 3351 3375 HC
157 157 HC2604 20250827 ... 3365 3385 HC
158 158 HC2605 20250827 ... 3353 3377 HC
159 159 HC2606 20250827 ... 3358 3386 HC
160 160 HC2607 20250827 ... 3357 3394 HC
161 161 HC2608 20250827 ... 3369 3405 HC
162 162 SS2509 20250827 ... 12785 12785 SS
163 163 SS2510 20250827 ... 12875 12865 SS
164 164 SS2511 20250827 ... 12945 12930 SS
165 165 SS2512 20250827 ... 12995 12975 SS
166 166 SS2601 20250827 ... 13045 13035 SS
167 167 SS2602 20250827 ... 13075 13050 SS
168 168 SS2603 20250827 ... 13160 13135 SS
169 169 SS2604 20250827 ... 13225 13190 SS
170 170 SS2605 20250827 ... 13275 13270 SS
171 171 SS2606 20250827 ... 13315 13315 SS
172 172 SS2607 20250827 ... 13395 13380 SS
173 173 SS2608 20250827 ... 13440 13445 SS
174 174 SC2509 20250827 ... 479.4 488.7 SC
175 175 SC2510 20250827 ... 486.4 497.7 SC
176 176 SC2511 20250827 ... 485.7 496 SC
177 177 SC2512 20250827 ... 484.4 493.2 SC
178 178 SC2601 20250827 ... 483.2 491.7 SC
179 179 SC2602 20250827 ... 482.2 490.5 SC
180 180 SC2603 20250827 ... 480.7 488.2 SC
181 181 SC2604 20250827 ... 479.2 486.4 SC
182 182 SC2605 20250827 ... 478.7 485.8 SC
183 183 SC2606 20250827 ... 478.4 484.9 SC
184 184 SC2607 20250827 ... 477.5 482.3 SC
185 185 SC2608 20250827 ... 476.7 481.3 SC
186 186 SC2609 20250827 ... 476.9 482.3 SC
187 187 SC2612 20250827 ... 479 482.2 SC
188 188 SC2703 20250827 ... 477.3 483.7 SC
189 189 SC2706 20250827 ... 476.9 479.5 SC
190 190 SC2709 20250827 ... 472.1 482.5 SC
191 191 SC2712 20250827 ... 473 481 SC
192 192 SC2803 20250827 ... 471.9 479.5 SC
193 193 SC2806 20250827 ... 467.6 474.5 SC
194 194 LU2509 20250827 ... 3478 3426 LU
195 195 LU2510 20250827 ... 3487 3532 LU
196 196 LU2511 20250827 ... 3489 3537 LU
197 197 LU2512 20250827 ... 3470 3522 LU
198 198 LU2601 20250827 ... 3449 3498 LU
199 199 LU2602 20250827 ... 3441 3476 LU
200 200 LU2603 20250827 ... 3421 3469 LU
201 201 LU2604 20250827 ... 3415 3463 LU
202 202 LU2605 20250827 ... 3401 3455 LU
203 203 LU2606 20250827 ... 3423 3454 LU
204 204 LU2607 20250827 ... 3406 3454 LU
205 205 LU2608 20250827 ... 3403 3450 LU
206 206 FU2509 20250827 ... 2789 2841 FU
207 207 FU2510 20250827 ... 2829 2890 FU
208 208 FU2511 20250827 ... 2817 2871 FU
209 209 FU2512 20250827 ... 2807 2856 FU
210 210 FU2601 20250827 ... 2798 2845 FU
211 211 FU2602 20250827 ... 2783 2830 FU
212 212 FU2603 20250827 ... 2778 2820 FU
213 213 FU2604 20250827 ... 2770 2813 FU
214 214 FU2605 20250827 ... 2762 2803 FU
215 215 FU2606 20250827 ... 2752 2791 FU
216 216 FU2607 20250827 ... 2732 2765 FU
217 217 FU2608 20250827 ... 2709 2742 FU
218 218 BU2509 20250827 ... 3500 3550 BU
219 219 BU2510 20250827 ... 3485 3525 BU
220 220 BU2511 20250827 ... 3454 3497 BU
221 221 BU2512 20250827 ... 3408 3447 BU
222 222 BU2601 20250827 ... 3375 3407 BU
223 223 BU2602 20250827 ... 3373 3407 BU
224 224 BU2603 20250827 ... 3373 3406 BU
225 225 BU2604 20250827 ... 3371 3390 BU
226 226 BU2605 20250827 ... 3361 3386 BU
227 227 BU2606 20250827 ... 3352 3387 BU
228 228 BU2607 20250827 ... 3354 3354 BU
229 229 BU2608 20250827 ... 3356 3356 BU
230 230 BU2609 20250827 ... 3346 3364 BU
231 231 BU2612 20250827 ... 3291 3336 BU
232 232 BU2703 20250827 ... 3300 3339 BU
233 233 BU2706 20250827 ... 3309 3348 BU
234 234 BR2509 20250827 ... 11850 11950 BR
235 235 BR2510 20250827 ... 11860 11980 BR
236 236 BR2511 20250827 ... 11840 11960 BR
237 237 BR2512 20250827 ... 11845 11950 BR
238 238 BR2601 20250827 ... 11825 11960 BR
239 239 BR2602 20250827 ... 11785 12010 BR
240 240 BR2603 20250827 ... 11775 11975 BR
241 241 BR2604 20250827 ... 11795 12050 BR
242 242 BR2605 20250827 ... 11915 12080 BR
243 243 BR2606 20250827 ... 12025 12085 BR
244 244 BR2607 20250827 ... 12100 12285 BR
245 245 BR2608 20250827 ... 11975 12005 BR
246 246 RU2509 20250827 ... 14915 14965 RU
247 247 RU2510 20250827 ... 14880 14925 RU
248 248 RU2511 20250827 ... 14900 14985 RU
249 249 RU2601 20250827 ... 15900 15975 RU
250 250 RU2603 20250827 ... 15900 16015 RU
251 251 RU2604 20250827 ... 15915 16045 RU
252 252 RU2605 20250827 ... 15975 16080 RU
253 253 RU2606 20250827 ... 16025 16060 RU
254 254 RU2607 20250827 ... 16000 16165 RU
255 255 RU2608 20250827 ... 15960 16115 RU
256 256 NR2509 20250827 ... 12695 12755 NR
257 257 NR2510 20250827 ... 12780 12840 NR
258 258 NR2511 20250827 ... 12800 12865 NR
259 259 NR2512 20250827 ... 12830 12875 NR
260 260 NR2601 20250827 ... 12835 12920 NR
261 261 NR2602 20250827 ... 12860 12860 NR
262 262 NR2603 20250827 ... 12860 12910 NR
263 263 NR2604 20250827 ... 12965 13055 NR
264 264 NR2605 20250827 ... 13015 13080 NR
265 265 NR2606 20250827 ... 12965 13140 NR
266 266 NR2607 20250827 ... 12975 12780 NR
267 267 NR2608 20250827 ... 13000 12780 NR
268 268 SP2509 20250827 ... 4984 5056 SP
269 269 SP2510 20250827 ... 5024 5088 SP
270 270 SP2511 20250827 ... 5034 5106 SP
271 271 SP2512 20250827 ... 5054 5122 SP
272 272 SP2601 20250827 ... 5316 5392 SP
273 273 SP2602 20250827 ... 5296 5360 SP
274 274 SP2603 20250827 ... 5316 5384 SP
275 275 SP2604 20250827 ... 5326 5366 SP
276 276 SP2605 20250827 ... 5330 5388 SP
277 277 SP2606 20250827 ... 5330 5400 SP
278 278 SP2607 20250827 ... 5344 5386 SP
279 279 SP2608 20250827 ... 5358 5410 SP
280 280 EC2510 20250827 ... 1329 1327.8 EC
281 281 EC2512 20250827 ... 1633.9 1663.1 EC
282 282 EC2602 20250827 ... 1455.2 1472.8 EC
283 283 EC2604 20250827 ... 1254.7 1276.1 EC
284 284 EC2606 20250827 ... 1418 1432.5 EC
285 285 EC2608 20250827 ... 1613.6 1626.3 EC
286 287 SC_TAS2510 20250827 ... SC_TAS
287 288 SC_TAS2511 20250827 ... SC_TAS
288 289 SC_TAS2512 20250827 ... SC_TAS
[289 rows x 13 columns]
2025-08-27 18:32:34,599 - future_1d - INFO - ak.get_shfe_daily('2025-08-27') done
symbol date open ... settle pre_settle variety
0 a2509 20250827 4086.0 ... 4086.00 4096.00 A
1 a2511 20250827 3978.0 ... 3956.00 3988.00 A
2 a2601 20250827 3971.0 ... 3959.00 3992.00 A
3 a2603 20250827 3991.0 ... 3966.00 3999.00 A
4 a2605 20250827 4030.0 ... 4005.00 4043.00 A
5 a2607 20250827 4039.0 ... 4013.00 4049.00 A
6 b2509 20250827 3717.0 ... 3674.00 3724.00 B
7 b2510 20250827 3725.0 ... 3693.00 3747.00 B
8 b2511 20250827 3786.0 ... 3748.00 3814.00 B
9 b2512 20250827 3817.0 ... 3786.00 3845.00 B
10 b2601 20250827 3813.0 ... 3776.00 3840.00 B
11 b2602 20250827 3789.0 ... 3758.00 3809.00 B
12 b2603 20250827 3736.0 ... 3711.00 3749.00 B
13 b2604 20250827 3627.0 ... 3601.00 3648.00 B
14 b2605 20250827 3567.0 ... 3553.00 3579.00 B
15 b2606 20250827 3540.0 ... 3533.00 3559.00 B
16 b2607 20250827 3539.0 ... 3533.00 3549.00 B
17 b2608 20250827 3619.0 ... 3615.00 3619.00 B
18 bb2509 20250827 0.0 ... 143.15 143.15 BB
19 bb2511 20250827 144.5 ... 144.50 144.85 BB
20 bb2601 20250827 147.5 ... 147.40 147.60 BB
21 bb2603 20250827 0.0 ... 147.20 147.35 BB
22 bb2605 20250827 0.0 ... 141.00 141.15 BB
23 bb2607 20250827 0.0 ... 146.75 146.90 BB
24 bz2603 20250827 6156.0 ... 6152.00 6195.00 BZ
25 bz2604 20250827 6164.0 ... 6138.00 6171.00 BZ
26 bz2605 20250827 6151.0 ... 6137.00 6162.00 BZ
27 bz2606 20250827 0.0 ... 6170.00 6170.00 BZ
28 bz2607 20250827 0.0 ... 6175.00 6175.00 BZ
29 bz2608 20250827 0.0 ... 6175.00 6175.00 BZ
30 c2509 20250827 2212.0 ... 2213.00 2206.00 C
31 c2511 20250827 2159.0 ... 2159.00 2157.00 C
32 c2601 20250827 2163.0 ... 2165.00 2163.00 C
33 c2603 20250827 2182.0 ... 2184.00 2181.00 C
34 c2605 20250827 2232.0 ... 2234.00 2236.00 C
35 c2607 20250827 2254.0 ... 2251.00 2253.00 C
36 cs2509 20250827 2532.0 ... 2523.00 2550.00 CS
37 cs2511 20250827 2470.0 ... 2470.00 2483.00 CS
38 cs2601 20250827 2505.0 ... 2509.00 2514.00 CS
39 cs2603 20250827 2518.0 ... 2517.00 2522.00 CS
40 cs2605 20250827 2592.0 ... 2590.00 2591.00 CS
41 cs2607 20250827 2597.0 ... 2595.00 2599.00 CS
42 eb2509 20250827 7208.0 ... 7185.00 7286.00 EB
43 eb2510 20250827 7247.0 ... 7227.00 7317.00 EB
44 eb2511 20250827 7256.0 ... 7243.00 7333.00 EB
45 eb2512 20250827 7278.0 ... 7268.00 7346.00 EB
46 eb2601 20250827 7300.0 ... 7290.00 7361.00 EB
47 eb2602 20250827 7342.0 ... 7321.00 7383.00 EB
48 eb2603 20250827 7363.0 ... 7340.00 7402.00 EB
49 eb2604 20250827 7390.0 ... 7356.00 7412.00 EB
50 eb2605 20250827 7393.0 ... 7383.00 7438.00 EB
51 eb2606 20250827 7374.0 ... 7341.00 7446.00 EB
52 eb2607 20250827 7387.0 ... 7376.00 7410.00 EB
53 eb2608 20250827 0.0 ... 7410.00 7410.00 EB
54 eg2509 20250827 4411.0 ... 4440.00 4452.00 EG
55 eg2510 20250827 4458.0 ... 4460.00 4470.00 EG
56 eg2511 20250827 4473.0 ... 4473.00 4487.00 EG
57 eg2512 20250827 4491.0 ... 4488.00 4502.00 EG
58 eg2601 20250827 4485.0 ... 4492.00 4507.00 EG
59 eg2602 20250827 4502.0 ... 4502.00 4514.00 EG
60 eg2603 20250827 4498.0 ... 4505.00 4506.00 EG
61 eg2604 20250827 0.0 ... 4533.00 4533.00 EG
62 eg2605 20250827 4529.0 ... 4523.00 4542.00 EG
63 eg2606 20250827 4534.0 ... 4522.00 4534.00 EG
64 eg2607 20250827 4553.0 ... 4525.00 4513.00 EG
65 eg2608 20250827 0.0 ... 4513.00 4513.00 EG
66 fb2509 20250827 1300.5 ... 1306.00 1292.50 FB
67 fb2510 20250827 1276.5 ... 1276.00 1276.50 FB
68 fb2511 20250827 1278.5 ... 1276.50 1277.00 FB
69 fb2512 20250827 1276.5 ... 1278.50 1277.00 FB
70 fb2601 20250827 1279.0 ... 1276.00 1277.00 FB
71 fb2602 20250827 1277.0 ... 1274.00 1278.50 FB
72 fb2603 20250827 0.0 ... 1313.50 1313.50 FB
73 fb2604 20250827 0.0 ... 1310.50 1310.50 FB
74 fb2605 20250827 0.0 ... 1311.00 1311.00 FB
75 fb2606 20250827 0.0 ... 1330.00 1330.00 FB
76 fb2607 20250827 0.0 ... 1302.50 1302.50 FB
77 fb2608 20250827 0.0 ... 1302.50 1302.50 FB
78 i2509 20250827 797.0 ... 797.00 800.00 I
79 i2510 20250827 792.0 ... 793.00 795.00 I
80 i2511 20250827 789.0 ... 790.50 792.00 I
81 i2512 20250827 783.5 ... 785.50 787.50 I
82 i2601 20250827 776.0 ... 777.00 780.50 I
83 i2602 20250827 771.0 ... 772.50 775.00 I
84 i2603 20250827 766.5 ... 767.00 770.50 I
85 i2604 20250827 762.0 ... 762.50 765.50 I
86 i2605 20250827 754.0 ... 754.50 757.50 I
87 i2606 20250827 749.5 ... 750.50 753.00 I
88 i2607 20250827 746.5 ... 747.00 749.50 I
89 i2608 20250827 744.0 ... 743.50 746.50 I
90 j2509 20250827 1610.0 ... 1608.00 1636.00 J
91 j2510 20250827 1627.5 ... 1627.00 1653.00 J
92 j2511 20250827 1650.0 ... 1654.00 1677.00 J
93 j2512 20250827 1652.5 ... 1651.00 1686.50 J
94 j2601 20250827 1685.0 ... 1681.00 1718.00 J
95 j2602 20250827 1716.0 ... 1703.00 1750.00 J
96 j2603 20250827 1717.5 ... 1721.00 1763.00 J
97 j2604 20250827 0.0 ... 1752.50 1800.00 J
98 j2605 20250827 1779.0 ... 1768.00 1806.50 J
99 j2606 20250827 0.0 ... 1804.00 1816.50 J
100 j2607 20250827 0.0 ... 1805.50 1823.50 J
101 j2608 20250827 0.0 ... 1806.00 1838.00 J
102 jd2509 20250827 2910.0 ... 2909.00 2914.00 JD
103 jd2510 20250827 3000.0 ... 2997.00 3011.00 JD
104 jd2511 20250827 3054.0 ... 3047.00 3056.00 JD
105 jd2512 20250827 3208.0 ... 3174.00 3203.00 JD
106 jd2601 20250827 3361.0 ... 3366.00 3370.00 JD
107 jd2602 20250827 3113.0 ... 3100.00 3114.00 JD
108 jd2603 20250827 3129.0 ... 3121.00 3131.00 JD
109 jd2604 20250827 3327.0 ... 3320.00 3331.00 JD
110 jd2605 20250827 3475.0 ... 3452.00 3478.00 JD
111 jd2606 20250827 3336.0 ... 3301.00 3334.00 JD
112 jd2607 20250827 3599.0 ... 3531.00 3595.00 JD
113 jd2608 20250827 4026.0 ... 3980.00 3595.00 JD
114 jm2509 20250827 1029.5 ... 1025.00 1058.00 JM
115 jm2510 20250827 1065.0 ... 1052.50 1085.00 JM
116 jm2511 20250827 1099.0 ... 1097.50 1127.00 JM
117 jm2512 20250827 1128.0 ... 1133.50 1162.50 JM
118 jm2601 20250827 1162.0 ... 1164.50 1200.50 JM
119 jm2602 20250827 1174.0 ... 1179.00 1214.00 JM
120 jm2603 20250827 1189.0 ... 1189.50 1230.00 JM
121 jm2604 20250827 1192.5 ... 1195.50 1228.00 JM
122 jm2605 20250827 1200.0 ... 1204.00 1241.50 JM
123 jm2606 20250827 1207.5 ... 1209.00 1243.50 JM
124 jm2607 20250827 1220.0 ... 1221.00 1249.50 JM
125 jm2608 20250827 1224.0 ... 1224.50 1257.50 JM
126 l2509 20250827 7344.0 ... 7338.00 7373.00 L
127 l2510 20250827 7365.0 ... 7362.00 7393.00 L
128 l2511 20250827 7386.0 ... 7381.00 7410.00 L
129 l2512 20250827 7397.0 ... 7390.00 7426.00 L
130 l2601 20250827 7399.0 ... 7389.00 7427.00 L
131 l2602 20250827 7396.0 ... 7380.00 7420.00 L
132 l2603 20250827 7401.0 ... 7367.00 7419.00 L
133 l2604 20250827 7426.0 ... 7407.00 7445.00 L
134 l2605 20250827 7407.0 ... 7394.00 7433.00 L
135 l2606 20250827 7413.0 ... 7393.00 7407.00 L
136 l2607 20250827 7416.0 ... 7398.00 7416.00 L
137 l2608 20250827 7389.0 ... 7389.00 7394.00 L
138 lg2509 20250827 803.0 ... 797.50 803.50 LG
139 lg2511 20250827 821.5 ... 819.00 822.00 LG
140 lg2601 20250827 836.0 ... 830.00 833.50 LG
141 lg2603 20250827 835.5 ... 835.00 838.50 LG
142 lg2605 20250827 835.5 ... 835.00 837.50 LG
143 lg2607 20250827 835.5 ... 833.00 837.00 LG
144 lh2509 20250827 13660.0 ... 13525.00 13695.00 LH
145 lh2511 20250827 13800.0 ... 13780.00 13840.00 LH
146 lh2601 20250827 14200.0 ... 14130.00 14210.00 LH
147 lh2603 20250827 13285.0 ... 13240.00 13275.00 LH
148 lh2605 20250827 13665.0 ... 13640.00 13665.00 LH
149 lh2607 20250827 14160.0 ... 14165.00 14155.00 LH
150 m2509 20250827 3020.0 ... 3005.00 3046.00 M
151 m2511 20250827 3044.0 ... 3021.00 3069.00 M
152 m2512 20250827 3091.0 ... 3063.00 3112.00 M
153 m2601 20250827 3081.0 ... 3055.00 3097.00 M
154 m2603 20250827 3012.0 ... 2999.00 3027.00 M
155 m2605 20250827 2840.0 ... 2827.00 2841.00 M
156 m2607 20250827 2834.0 ... 2823.00 2832.00 M
157 m2608 20250827 2952.0 ... 2951.00 2957.00 M
158 p2509 20250827 9392.0 ... 9432.00 9460.00 P
159 p2510 20250827 9472.0 ... 9498.00 9542.00 P
160 p2511 20250827 9458.0 ... 9494.00 9536.00 P
161 p2512 20250827 9462.0 ... 9508.00 9536.00 P
162 p2601 20250827 9470.0 ... 9518.00 9544.00 P
163 p2602 20250827 9436.0 ... 9476.00 9488.00 P
164 p2603 20250827 9356.0 ... 9414.00 9434.00 P
165 p2604 20250827 0.0 ... 9374.00 9374.00 P
166 p2605 20250827 9218.0 ... 9266.00 9278.00 P
167 p2606 20250827 9124.0 ... 9142.00 9158.00 P
168 p2607 20250827 9010.0 ... 9018.00 9036.00 P
169 p2608 20250827 8934.0 ... 8956.00 8964.00 P
170 pg2509 20250827 3868.0 ... 3884.00 3866.00 PG
171 pg2510 20250827 4429.0 ... 4430.00 4444.00 PG
172 pg2511 20250827 4337.0 ... 4335.00 4357.00 PG
173 pg2512 20250827 4276.0 ... 4274.00 4295.00 PG
174 pg2601 20250827 4220.0 ... 4217.00 4242.00 PG
175 pg2602 20250827 4141.0 ... 4144.00 4165.00 PG
176 pg2603 20250827 4052.0 ... 4052.00 4074.00 PG
177 pg2604 20250827 4359.0 ... 4352.00 4374.00 PG
178 pg2605 20250827 4255.0 ... 4276.00 4271.00 PG
179 pg2606 20250827 0.0 ... 4209.00 4209.00 PG
180 pg2607 20250827 4126.0 ... 4126.00 4141.00 PG
181 pg2608 20250827 0.0 ... 4141.00 4141.00 PG
182 pp2509 20250827 6987.0 ... 6982.00 7014.00 PP
183 pp2510 20250827 6997.0 ... 6987.00 7026.00 PP
184 pp2511 20250827 7015.0 ... 7008.00 7040.00 PP
185 pp2512 20250827 7035.0 ... 7026.00 7058.00 PP
186 pp2601 20250827 7041.0 ... 7036.00 7072.00 PP
187 pp2602 20250827 7016.0 ... 7015.00 7048.00 PP
188 pp2603 20250827 7028.0 ... 7013.00 7032.00 PP
189 pp2604 20250827 7038.0 ... 7027.00 7077.00 PP
190 pp2605 20250827 7060.0 ... 7054.00 7089.00 PP
191 pp2606 20250827 0.0 ... 7012.00 7057.00 PP
192 pp2607 20250827 6990.0 ... 6985.00 7033.00 PP
193 pp2608 20250827 0.0 ... 7044.00 7046.00 PP
194 rr2509 20250827 3568.0 ... 3558.00 3567.00 RR
195 rr2510 20250827 3612.0 ... 3611.00 3610.00 RR
196 rr2511 20250827 3613.0 ... 3613.00 3613.00 RR
197 rr2512 20250827 3610.0 ... 3610.00 3606.00 RR
198 rr2601 20250827 3620.0 ... 3621.00 3620.00 RR
199 rr2602 20250827 0.0 ... 3606.00 3606.00 RR
200 rr2603 20250827 0.0 ... 3610.00 3610.00 RR
201 rr2604 20250827 0.0 ... 3617.00 3617.00 RR
202 rr2605 20250827 0.0 ... 3615.00 3615.00 RR
203 rr2606 20250827 0.0 ... 3605.00 3605.00 RR
204 rr2607 20250827 0.0 ... 3625.00 3625.00 RR
205 rr2608 20250827 3625.0 ... 3625.00 3609.00 RR
206 v2509 20250827 4832.0 ... 4840.00 4878.00 V
207 v2510 20250827 4887.0 ... 4878.00 4922.00 V
208 v2511 20250827 4922.0 ... 4913.00 4957.00 V
209 v2512 20250827 4975.0 ... 4956.00 5002.00 V
210 v2601 20250827 4995.0 ... 4990.00 5026.00 V
211 v2602 20250827 5031.0 ... 5023.00 5067.00 V
212 v2603 20250827 5066.0 ... 5058.00 5096.00 V
213 v2604 20250827 5271.0 ... 5274.00 5292.00 V
214 v2605 20250827 5302.0 ... 5301.00 5332.00 V
215 v2606 20250827 5335.0 ... 5324.00 5359.00 V
216 v2607 20250827 5369.0 ... 5356.00 5390.00 V
217 v2608 20250827 5391.0 ... 5369.00 5385.00 V
218 y2509 20250827 8506.0 ... 8492.00 8554.00 Y
219 y2511 20250827 8478.0 ... 8452.00 8516.00 Y
220 y2512 20250827 8502.0 ... 8470.00 8542.00 Y
221 y2601 20250827 8432.0 ... 8418.00 8492.00 Y
222 y2603 20250827 8374.0 ... 8352.00 8438.00 Y
223 y2605 20250827 8136.0 ... 8128.00 8194.00 Y
224 y2607 20250827 8080.0 ... 8068.00 8122.00 Y
225 y2608 20250827 8062.0 ... 8068.00 8114.00 Y
[226 rows x 12 columns]
2025-08-27 18:32:35,127 - future_1d - INFO - ak.get_dce_daily('2025-08-27') done
symbol date open ... settle pre_settle variety
0 IC2509 20250827 6929.800 ... 6897.600 6942.400 IC
1 IC2510 20250827 6890.000 ... 6854.000 6905.400 IC
2 IC2512 20250827 6797.000 ... 6768.600 6817.000 IC
3 IC2603 20250827 6678.200 ... 6634.800 6692.000 IC
4 IF2509 20250827 4451.200 ... 4416.000 4460.200 IF
5 IF2510 20250827 4448.000 ... 4410.600 4454.200 IF
6 IF2512 20250827 4433.000 ... 4397.000 4441.400 IF
7 IF2603 20250827 4415.800 ... 4375.600 4422.200 IF
8 IH2509 20250827 2978.200 ... 2937.200 2975.000 IH
9 IH2510 20250827 2975.200 ... 2936.600 2976.000 IH
10 IH2512 20250827 2973.200 ... 2941.000 2977.000 IH
11 IH2603 20250827 2980.000 ... 2944.000 2980.800 IH
12 IM2509 20250827 7440.000 ... 7356.200 7442.000 IM
13 IM2510 20250827 7367.000 ... 7296.400 7388.200 IM
14 IM2512 20250827 7278.000 ... 7192.000 7282.200 IM
15 IM2603 20250827 7120.000 ... 7030.000 7124.000 IM
16 T2509 20250827 108.125 ... 108.180 108.125 T
17 T2512 20250827 107.955 ... 108.005 107.935 T
18 T2603 20250827 107.690 ... 107.755 107.670 T
19 TF2509 20250827 105.620 ... 105.645 105.585 TF
20 TF2512 20250827 105.520 ... 105.560 105.520 TF
21 TF2603 20250827 105.410 ... 105.450 105.405 TF
22 TL2509 20250827 117.430 ... 117.740 117.520 TL
23 TL2512 20250827 117.120 ... 117.300 117.120 TL
24 TL2603 20250827 116.870 ... 116.940 116.770 TL
25 TS2509 20250827 102.328 ... 102.332 102.324 TS
26 TS2512 20250827 102.400 ... 102.396 102.382 TS
27 TS2603 20250827 102.310 ... 102.342 102.324 TS
[28 rows x 12 columns]
2025-08-27 18:32:35,436 - future_1d - INFO - ak.get_cffex_daily('2025-08-27') done
symbol date open high ... turnover settle pre_settle variety
0 SC2509 20250827 484.9 486.8 ... 47801.07 479.4 488.7 SC
1 SC2510 20250827 491.7 493.3 ... 6099210.66 486.4 497.7 SC
2 SC2511 20250827 490.5 492.8 ... 928963.62 485.7 496 SC
3 SC2512 20250827 489.1 490.6 ... 431590.93 484.4 493.2 SC
4 SC2601 20250827 487.5 489 ... 80080.2 483.2 491.7 SC
5 SC2602 20250827 485.7 487.9 ... 11863.32 482.2 490.5 SC
6 SC2603 20250827 484.9 487.3 ... 22258.92 480.7 488.2 SC
7 SC2604 20250827 484 485.1 ... 5847.29 479.2 486.4 SC
8 SC2605 20250827 482.1 483.9 ... 6127.55 478.7 485.8 SC
9 SC2606 20250827 481.5 481.7 ... 3875.31 478.4 484.9 SC
10 SC2607 20250827 480.8 480.8 ... 238.79 477.5 482.3 SC
11 SC2608 20250827 479.8 479.8 ... 143.03 476.7 481.3 SC
12 SC2609 20250827 478.7 478.7 ... 476.97 476.9 482.3 SC
13 SC2612 20250827 478.7 479.3 ... 95.8 479 482.2 SC
14 SC2703 20250827 ... 0 477.3 483.7 SC
15 SC2706 20250827 ... 0 476.9 479.5 SC
16 SC2709 20250827 472.7 472.7 ... 94.42 472.1 482.5 SC
17 SC2712 20250827 475.4 475.5 ... 189.23 473 481 SC
18 SC2803 20250827 ... 0 471.9 479.5 SC
19 SC2806 20250827 468.9 469.8 ... 420.86 467.6 474.5 SC
21 LU2509 20250827 3460 3500 ... 6880.618 3478 3426 LU
22 LU2510 20250827 3499 3525 ... 56605.393 3487 3532 LU
23 LU2511 20250827 3504 3527 ... 339272.428 3489 3537 LU
24 LU2512 20250827 3489 3508 ... 89025.752 3470 3522 LU
25 LU2601 20250827 3470 3484 ... 18633.103 3449 3498 LU
26 LU2602 20250827 3452 3459 ... 3476.043 3441 3476 LU
27 LU2603 20250827 3442 3450 ... 116.332 3421 3469 LU
28 LU2604 20250827 3439 3439 ... 20.49 3415 3463 LU
29 LU2605 20250827 3405 3408 ... 40.812 3401 3455 LU
30 LU2606 20250827 3425 3425 ... 10.27 3423 3454 LU
31 LU2607 20250827 3421 3421 ... 44.29 3406 3454 LU
32 LU2608 20250827 3424 3435 ... 17.017 3403 3450 LU
34 NR2509 20250827 12765 12840 ... 47355.925 12695 12755 NR
35 NR2510 20250827 12750 12910 ... 1445915.24 12780 12840 NR
36 NR2511 20250827 12750 12910 ... 602704.765 12800 12865 NR
37 NR2512 20250827 12770 12925 ... 109530.39 12830 12875 NR
38 NR2601 20250827 12840 12945 ... 118992.655 12835 12920 NR
39 NR2602 20250827 12865 12920 ... 4128.725 12860 12860 NR
40 NR2603 20250827 12855 12950 ... 38.59 12860 12910 NR
41 NR2604 20250827 12940 13000 ... 64.825 12965 13055 NR
42 NR2605 20250827 12930 13295 ... 221.31 13015 13080 NR
43 NR2606 20250827 12965 12965 ... 51.86 12965 13140 NR
44 NR2607 20250827 12980 13010 ... 64.89 12975 12780 NR
45 NR2608 20250827 13050 13050 ... 52 13000 12780 NR
47 BC2509 20250827 70320 70590 ... 67563.61 70410 70620 BC
48 BC2510 20250827 70380 70650 ... 43728.8 70470 70630 BC
49 BC2511 20250827 70300 72350 ... 4998.295 70390 70440 BC
50 BC2512 20250827 ... 0 70180 70180 BC
51 BC2601 20250827 ... 0 70100 70100 BC
52 BC2602 20250827 ... 0 70100 70100 BC
53 BC2603 20250827 ... 0 70100 70100 BC
54 BC2604 20250827 ... 0 70100 70100 BC
55 BC2605 20250827 ... 0 70490 70490 BC
56 BC2606 20250827 ... 0 69790 69790 BC
57 BC2607 20250827 ... 0 69370 69370 BC
58 BC2608 20250827 ... 0 69370 69370 BC
60 EC2510 20250827 1327.8 1341 ... 119684.668 1329 1327.8 EC
61 EC2512 20250827 1654.1 1654.1 ... 44704.0665 1633.9 1663.1 EC
62 EC2602 20250827 1454.7 1466 ... 5610.086 1455.2 1472.8 EC
63 EC2604 20250827 1266 1272.1 ... 6110.4125 1254.7 1276.1 EC
64 EC2606 20250827 1422.5 1426.5 ... 623.9255 1418 1432.5 EC
65 EC2608 20250827 1633.8 1633.8 ... 871.3515 1613.6 1626.3 EC
69 SC_TAS2510 20250827 ... SC_TAS
70 SC_TAS2511 20250827 ... SC_TAS
71 SC_TAS2512 20250827 ... SC_TAS
[65 rows x 12 columns]
2025-08-27 18:32:35,507 - future_1d - INFO - ak.get_ine_daily('2025-08-27') done
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.DataError: (1366, "Incorrect decimal value: 'nan' for column 'opencol' at row 292")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/future_1d/future_daily.py", line 10, in
client.save_future_daily(check=True, check_last=7)
File "/root/project/future_1d/future1d_request.py", line 1072, in save_future_daily
data_add.to_sql(tablebase.__tablename__, self.engine, index=False, if_exists='append', chunksize=1000)
File "/usr/local/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/pandas/core/generic.py", line 3106, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 844, in to_sql
return pandas_sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 2030, in to_sql
total_inserted = sql_engine.insert_records(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1579, in insert_records
raise err
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1570, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1121, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1012, in _execute_insert
result = conn.execute(self.table.insert(), data)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1936, in _exec_single_context
self.dialect.do_executemany(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 196, in do_executemany
rowcount = cursor.executemany(statement, parameters)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 187, in executemany
return self._do_execute_many(
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 225, in _do_execute_many
rows += self.execute(sql + postfix)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "/usr/local/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 1157, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.DataError: (pymysql.err.DataError) (1366, "Incorrect decimal value: 'nan' for column 'opencol' at row 292")
[SQL: INSERT INTO future_daily (symbol, date, opencol, high, low, close, volume, open_interest, turnover, settle, pre_settle, variety, exchange, comd, contract, contract_yymm, maturity_month, maturity_day) VALUES (%(symbol)s, %(date)s, %(opencol)s, %(high)s, %(low)s, %(close)s, %(volume)s, %(open_interest)s, %(turnover)s, %(settle)s, %(pre_settle)s, %(variety)s, %(exchange)s, %(comd)s, %(contract)s, %(contract_yymm)s, %(maturity_month)s, %(maturity_day)s)]
[parameters: [{'symbol': 'AP510', 'date': '2025-08-27', 'opencol': '8146.0', 'high': '8320.0', 'low': '8140.0', 'close': '8278.0', 'volume': '112486.0', 'open_interest': '92405.0', 'turnover': '926963.07', 'settle': '8249.0', 'pre_settle': '8158.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP510', 'contract_yymm': '2510', 'maturity_month': '2', 'maturity_day': '35'}, {'symbol': 'AP511', 'date': '2025-08-27', 'opencol': '7965.0', 'high': '8063.0', 'low': '7961.0', 'close': '8055.0', 'volume': '1034.0', 'open_interest': '3255.0', 'turnover': '8291.69', 'settle': '8019.0', 'pre_settle': '7957.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP511', 'contract_yymm': '2511', 'maturity_month': '3', 'maturity_day': '66'}, {'symbol': 'AP512', 'date': '2025-08-27', 'opencol': '7998.0', 'high': '8068.0', 'low': '7982.0', 'close': '8067.0', 'volume': '272.0', 'open_interest': '304.0', 'turnover': '2190.2', 'settle': '8052.0', 'pre_settle': '7974.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP512', 'contract_yymm': '2512', 'maturity_month': '4', 'maturity_day': '96'}, {'symbol': 'AP601', 'date': '2025-08-27', 'opencol': '8055.0', 'high': '8160.0', 'low': '8038.0', 'close': '8152.0', 'volume': '19474.0', 'open_interest': '30355.0', 'turnover': '157852.48', 'settle': '8106.0', 'pre_settle': '8061.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP601', 'contract_yymm': '2601', 'maturity_month': '5', 'maturity_day': '127'}, {'symbol': 'AP603', 'date': '2025-08-27', 'opencol': '7964.0', 'high': '8045.0', 'low': '7955.0', 'close': '8040.0', 'volume': '51.0', 'open_interest': '155.0', 'turnover': '409.48', 'settle': '8029.0', 'pre_settle': '7959.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP603', 'contract_yymm': '2603', 'maturity_month': '7', 'maturity_day': '186'}, {'symbol': 'AP604', 'date': '2025-08-27', 'opencol': '7981.0', 'high': '8054.0', 'low': '7973.0', 'close': '8034.0', 'volume': '19.0', 'open_interest': '90.0', 'turnover': '152.54', 'settle': '8028.0', 'pre_settle': '7974.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP604', 'contract_yymm': '2604', 'maturity_month': '8', 'maturity_day': '217'}, {'symbol': 'AP605', 'date': '2025-08-27', 'opencol': '8031.0', 'high': '8110.0', 'low': '8031.0', 'close': '8090.0', 'volume': '152.0', 'open_interest': '514.0', 'turnover': '1229.23', 'settle': '8087.0', 'pre_settle': '8037.0', 'variety': 'AP', 'exchange': 'CZCE', 'comd': 'AP', 'contract': 'AP605', 'contract_yymm': '2605', 'maturity_month': '9', 'maturity_day': '247'}, {'symbol': 'CF509', 'date': '2025-08-27', 'opencol': '13760.0', 'high': '13800.0', 'low': '13740.0', 'close': '13760.0', 'volume': '20444.0', 'open_interest': '44086.0', 'turnover': '140783.76', 'settle': '13775.0', 'pre_settle': '13810.0', 'variety': 'CF', 'exchange': 'CZCE', 'comd': 'CF', 'contract': 'CF509', 'contract_yymm': '2509', 'maturity_month': '1', 'maturity_day': '5'} ... displaying 10 of 816 total bound parameter sets ... {'symbol': 'TS2512', 'date': '2025-08-27', 'opencol': '102.4', 'high': '102.41', 'low': '102.364', 'close': '102.406', 'volume': '27789.0', 'open_interest': '65408.0', 'turnover': '5690426.916', 'settle': '102.396', 'pre_settle': '102.382', 'variety': 'TS', 'exchange': 'CFFEX', 'comd': 'TS', 'contract': 'TS2512', 'contract_yymm': '2512', 'maturity_month': '4', 'maturity_day': '96'}, {'symbol': 'TS2603', 'date': '2025-08-27', 'opencol': '102.31', 'high': '102.352', 'low': '102.31', 'close': '102.35', 'volume': '723.0', 'open_interest': '3031.0', 'turnover': '147973.76', 'settle': '102.342', 'pre_settle': '102.324', 'variety': 'TS', 'exchange': 'CFFEX', 'comd': 'TS', 'contract': 'TS2603', 'contract_yymm': '2603', 'maturity_month': '7', 'maturity_day': '186'}]]
(Background on this error at: https://sqlalche.me/e/20/9h9h)