198 198 LU2601 20250819 ... 3412 3422 LU
199 199 LU2602 20250819 ... 3400 3411 LU
200 200 LU2603 20250819 ... 3389 3403 LU
201 201 LU2604 20250819 ... 3395 3395 LU
202 202 LU2605 20250819 ... 3382 3389 LU
203 203 LU2606 20250819 ... 3383 3383 LU
204 204 LU2607 20250819 ... 3377 3390 LU
205 205 LU2608 20250819 ... 3375 3389 LU
206 206 FU2509 20250819 ... 2680 2700 FU
207 207 FU2510 20250819 ... 2705 2722 FU
208 208 FU2511 20250819 ... 2712 2724 FU
209 209 FU2512 20250819 ... 2715 2727 FU
210 210 FU2601 20250819 ... 2719 2731 FU
211 211 FU2602 20250819 ... 2719 2730 FU
212 212 FU2603 20250819 ... 2721 2732 FU
213 213 FU2604 20250819 ... 2724 2733 FU
214 214 FU2605 20250819 ... 2719 2727 FU
215 215 FU2606 20250819 ... 2715 2726 FU
216 216 FU2607 20250819 ... 2698 2707 FU
217 217 FU2608 20250819 ... 2692 2703 FU
218 218 BU2509 20250819 ... 3482 3504 BU
219 219 BU2510 20250819 ... 3450 3474 BU
220 220 BU2511 20250819 ... 3408 3428 BU
221 221 BU2512 20250819 ... 3356 3375 BU
222 222 BU2601 20250819 ... 3321 3338 BU
223 223 BU2602 20250819 ... 3319 3331 BU
224 224 BU2603 20250819 ... 3321 3328 BU
225 225 BU2604 20250819 ... 3316 3320 BU
226 226 BU2605 20250819 ... 3318 3319 BU
227 227 BU2606 20250819 ... 3310 3322 BU
228 228 BU2607 20250819 ... 3309 3309 BU
229 229 BU2608 20250819 ... 3316 3316 BU
230 230 BU2609 20250819 ... 3303 3312 BU
231 231 BU2612 20250819 ... 3272 3290 BU
232 232 BU2703 20250819 ... 3279 3296 BU
233 233 BU2706 20250819 ... 3289 3307 BU
234 234 BR2509 20250819 ... 11860 11800 BR
235 235 BR2510 20250819 ... 11865 11810 BR
236 236 BR2511 20250819 ... 11860 11810 BR
237 237 BR2512 20250819 ... 11865 11830 BR
238 238 BR2601 20250819 ... 11890 11835 BR
239 239 BR2602 20250819 ... 11960 11750 BR
240 240 BR2603 20250819 ... 11990 11785 BR
241 241 BR2604 20250819 ... 11955 11880 BR
242 242 BR2605 20250819 ... 12005 11880 BR
243 243 BR2606 20250819 ... 12040 11915 BR
244 244 BR2607 20250819 ... 12080 11950 BR
245 245 BR2608 20250819 ... 11925 11925 BR
246 246 RU2509 20250819 ... 14860 14795 RU
247 247 RU2510 20250819 ... 14860 14805 RU
248 248 RU2511 20250819 ... 14875 14815 RU
249 249 RU2601 20250819 ... 15880 15825 RU
250 250 RU2603 20250819 ... 15905 15850 RU
251 251 RU2604 20250819 ... 15925 15850 RU
252 252 RU2605 20250819 ... 15960 15910 RU
253 253 RU2606 20250819 ... 16035 15975 RU
254 254 RU2607 20250819 ... 16055 15985 RU
255 255 RU2608 20250819 ... 16010 16025 RU
256 256 NR2509 20250819 ... 12630 12590 NR
257 257 NR2510 20250819 ... 12700 12660 NR
258 258 NR2511 20250819 ... 12725 12695 NR
259 259 NR2512 20250819 ... 12760 12730 NR
260 260 NR2601 20250819 ... 12800 12775 NR
261 261 NR2602 20250819 ... 12770 12740 NR
262 262 NR2603 20250819 ... 12820 12745 NR
263 263 NR2604 20250819 ... 12815 12745 NR
264 264 NR2605 20250819 ... 12905 12815 NR
265 265 NR2606 20250819 ... 12760 12760 NR
266 266 NR2607 20250819 ... 12900 12900 NR
267 267 NR2608 20250819 ... 12830 12830 NR
268 268 SP2509 20250819 ... 5168 5226 SP
269 269 SP2510 20250819 ... 5176 5260 SP
270 270 SP2511 20250819 ... 5220 5276 SP
271 271 SP2512 20250819 ... 5210 5270 SP
272 272 SP2601 20250819 ... 5442 5496 SP
273 273 SP2602 20250819 ... 5392 5462 SP
274 274 SP2603 20250819 ... 5386 5460 SP
275 275 SP2604 20250819 ... 5410 5462 SP
276 276 SP2605 20250819 ... 5400 5466 SP
277 277 SP2606 20250819 ... 5406 5474 SP
278 278 SP2607 20250819 ... 5410 5458 SP
279 279 SP2608 20250819 ... 5470 5484 SP
280 280 EC2508 20250819 ... 2120.1 2085.9 EC
281 281 EC2510 20250819 ... 1373.2 1381.4 EC
282 282 EC2512 20250819 ... 1769.7 1782.3 EC
283 283 EC2602 20250819 ... 1531.1 1539 EC
284 284 EC2604 20250819 ... 1325.8 1339.8 EC
285 285 EC2606 20250819 ... 1485.8 1496.5 EC
286 286 SC_TAS2509 20250819 ... SC_TAS
287 287 SC_TAS2510 20250819 ... SC_TAS
288 288 SC_TAS2511 20250819 ... SC_TAS
289 289 SC_TAS2512 20250819 ... SC_TAS
[290 rows x 13 columns]
2025-08-20 11:22:26,941 - future_1d - INFO - ak.get_shfe_daily('2025-08-19') done
symbol date open high ... turnover settle pre_settle variety
0 AP510 20250819 8220.0 8220.0 ... 379516.48 8156.0 8155.0 AP
1 AP511 20250819 7932.0 7957.0 ... 1728.77 7930.0 7900.0 AP
2 AP512 20250819 7984.0 7993.0 ... 143.21 7956.0 7960.0 AP
3 AP601 20250819 8095.0 8098.0 ... 55700.65 8046.0 8038.0 AP
4 AP603 20250819 7968.0 7985.0 ... 127.20 7950.0 7956.0 AP
5 AP604 20250819 7989.0 7998.0 ... 55.82 7974.0 7974.0 AP
6 AP605 20250819 8039.0 8050.0 ... 424.56 8011.0 8028.0 AP
7 CF509 20250819 13830.0 13875.0 ... 219015.08 13835.0 13835.0 CF
8 CF511 20250819 14050.0 14080.0 ... 127064.73 14030.0 14030.0 CF
9 CF601 20250819 14135.0 14170.0 ... 1036946.74 14125.0 14115.0 CF
10 CF603 20250819 14100.0 14125.0 ... 1218.11 14080.0 14075.0 CF
11 CF605 20250819 14105.0 14140.0 ... 88622.51 14095.0 14075.0 CF
12 CF607 20250819 14100.0 14125.0 ... 246.74 14100.0 14080.0 CF
13 CJ509 20250819 10475.0 10705.0 ... 14294.76 10535.0 10495.0 CJ
14 CJ512 20250819 11425.0 11700.0 ... 23075.91 11505.0 11435.0 CJ
15 CJ601 20250819 11505.0 11825.0 ... 1646270.88 11620.0 11545.0 CJ
16 CJ603 20250819 11550.0 11850.0 ... 10844.80 11640.0 11595.0 CJ
17 CJ605 20250819 11645.0 11955.0 ... 189067.10 11770.0 11715.0 CJ
18 CJ607 20250819 11825.0 12060.0 ... 4742.37 11945.0 11880.0 CJ
19 CY509 20250819 20130.0 20140.0 ... 592.97 20100.0 20095.0 CY
20 CY510 20250819 0.0 0.0 ... 0.00 19705.0 19705.0 CY
21 CY511 20250819 20180.0 20215.0 ... 79404.60 20155.0 20165.0 CY
22 CY512 20250819 0.0 0.0 ... 0.00 19905.0 19855.0 CY
23 CY601 20250819 20205.0 20205.0 ... 1259.82 20155.0 20145.0 CY
24 CY602 20250819 0.0 0.0 ... 0.00 20015.0 20015.0 CY
25 CY603 20250819 0.0 0.0 ... 0.00 20365.0 20365.0 CY
26 CY604 20250819 0.0 0.0 ... 0.00 20030.0 20030.0 CY
27 CY605 20250819 0.0 0.0 ... 0.00 20340.0 20340.0 CY
28 CY606 20250819 0.0 0.0 ... 0.00 20010.0 20010.0 CY
29 CY607 20250819 0.0 0.0 ... 0.00 20410.0 20410.0 CY
30 CY608 20250819 0.0 0.0 ... 0.00 20410.0 20410.0 CY
31 FG509 20250819 1040.0 1050.0 ... 584252.83 1035.0 1044.0 FG
32 FG510 20250819 1151.0 1167.0 ... 110668.70 1145.0 1156.0 FG
33 FG511 20250819 1137.0 1156.0 ... 142650.04 1135.0 1143.0 FG
34 FG512 20250819 1226.0 1245.0 ... 90602.86 1223.0 1226.0 FG
35 FG601 20250819 1218.0 1237.0 ... 5169810.47 1215.0 1218.0 FG
36 FG602 20250819 1277.0 1289.0 ... 1392.41 1268.0 1270.0 FG
37 FG603 20250819 1270.0 1290.0 ... 2477.99 1268.0 1272.0 FG
38 FG604 20250819 1324.0 1333.0 ... 733.61 1315.0 1317.0 FG
39 FG605 20250819 1313.0 1330.0 ... 73138.89 1309.0 1316.0 FG
40 FG606 20250819 1344.0 1356.0 ... 860.30 1336.0 1338.0 FG
41 FG607 20250819 1331.0 1350.0 ... 1341.54 1331.0 1335.0 FG
42 FG608 20250819 1357.0 1364.0 ... 474.77 1349.0 1352.0 FG
43 JR509 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
44 JR511 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
45 JR601 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
46 JR603 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
47 JR605 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
48 JR607 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
49 LR509 20250819 0.0 0.0 ... 0.00 2360.0 2360.0 LR
50 LR511 20250819 0.0 0.0 ... 0.00 2360.0 2360.0 LR
51 LR601 20250819 0.0 0.0 ... 0.00 2360.0 2360.0 LR
52 MA509 20250819 2291.0 2297.0 ... 240760.83 2278.0 2306.0 MA
53 MA510 20250819 2323.0 2327.0 ... 179108.33 2306.0 2334.0 MA
54 MA511 20250819 2338.0 2346.0 ... 247869.61 2325.0 2350.0 MA
55 MA512 20250819 2377.0 2384.0 ... 97642.59 2364.0 2383.0 MA
56 MA601 20250819 2397.0 2406.0 ... 1350905.33 2386.0 2400.0 MA
57 MA602 20250819 2400.0 2402.0 ... 508.75 2377.0 2411.0 MA
58 MA603 20250819 2397.0 2409.0 ... 226.98 2389.0 2415.0 MA
59 MA604 20250819 2384.0 2389.0 ... 40.48 2381.0 2410.0 MA
60 MA605 20250819 2380.0 2387.0 ... 39341.12 2369.0 2379.0 MA
61 MA606 20250819 2379.0 2386.0 ... 40.37 2375.0 2393.0 MA
62 MA607 20250819 2375.0 2384.0 ... 54.56 2372.0 2387.0 MA
63 MA608 20250819 2376.0 2388.0 ... 21.43 2381.0 2398.0 MA
64 OI509 20250819 9861.0 9964.0 ... 290846.96 9922.0 9887.0 OI
65 OI511 20250819 9850.0 9980.0 ... 251570.51 9933.0 9890.0 OI
66 OI601 20250819 9837.0 9943.0 ... 3172077.79 9894.0 9847.0 OI
67 OI603 20250819 9770.0 9856.0 ... 2247.12 9813.0 9765.0 OI
68 OI605 20250819 9702.0 9781.0 ... 112758.97 9744.0 9704.0 OI
69 OI607 20250819 9719.0 9755.0 ... 107.02 9729.0 9685.0 OI
70 PF509 20250819 6360.0 6398.0 ... 20321.70 6374.0 6332.0 PF
71 PF510 20250819 6452.0 6480.0 ... 529813.26 6452.0 6414.0 PF
72 PF511 20250819 6432.0 6468.0 ... 228008.05 6438.0 6392.0 PF
73 PF512 20250819 6420.0 6452.0 ... 60843.73 6426.0 6388.0 PF
74 PF601 20250819 6420.0 6448.0 ... 12871.15 6426.0 6400.0 PF
75 PF602 20250819 6442.0 6452.0 ... 125.60 6442.0 6416.0 PF
76 PF603 20250819 0.0 0.0 ... 0.00 6442.0 6430.0 PF
77 PF604 20250819 6486.0 6486.0 ... 3.24 6486.0 6458.0 PF
78 PF605 20250819 6480.0 6480.0 ... 3.24 6480.0 6486.0 PF
79 PF606 20250819 6492.0 6492.0 ... 3.25 6492.0 6474.0 PF
80 PF607 20250819 0.0 0.0 ... 0.00 6500.0 6490.0 PF
81 PF608 20250819 0.0 0.0 ... 0.00 6512.0 6486.0 PF
82 PK510 20250819 8046.0 8050.0 ... 55666.68 8036.0 8062.0 PK
83 PK511 20250819 7826.0 7840.0 ... 196717.02 7818.0 7822.0 PK
84 PK512 20250819 7836.0 7862.0 ... 51310.43 7848.0 7848.0 PK
85 PK601 20250819 7894.0 7930.0 ... 26485.91 7912.0 7914.0 PK
86 PK603 20250819 7916.0 7926.0 ... 261.31 7918.0 7926.0 PK
87 PK604 20250819 7910.0 7930.0 ... 106.91 7920.0 7916.0 PK
88 PK605 20250819 7916.0 7930.0 ... 2300.45 7920.0 7922.0 PK
89 PL601 20250819 6444.0 6463.0 ... 25252.45 6426.0 6467.0 PL
90 PL602 20250819 6499.0 6499.0 ... 103.55 6472.0 6503.0 PL
91 PL603 20250819 6443.0 6443.0 ... 25.74 6434.0 6476.0 PL
92 PL604 20250819 6435.0 6435.0 ... 12.87 6435.0 6502.0 PL
93 PL605 20250819 6368.0 6368.0 ... 139.51 6342.0 6380.0 PL
94 PL606 20250819 0.0 0.0 ... 0.00 6450.0 6482.0 PL
95 PL607 20250819 6475.0 6475.0 ... 12.95 6475.0 6500.0 PL
96 PL608 20250819 0.0 0.0 ... 0.00 6500.0 6500.0 PL
97 PM509 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
98 PM511 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
99 PM601 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
100 PM603 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
101 PM605 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
102 PM607 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
103 PR509 20250819 5848.0 5860.0 ... 6927.20 5846.0 5844.0 PR
104 PR510 20250819 5914.0 5936.0 ... 202685.89 5912.0 5898.0 PR
105 PR511 20250819 5918.0 5940.0 ... 378257.78 5916.0 5896.0 PR
106 PR512 20250819 5926.0 5948.0 ... 73536.65 5924.0 5902.0 PR
107 PR601 20250819 5940.0 5958.0 ... 2895.76 5940.0 5924.0 PR
108 PR602 20250819 0.0 0.0 ... 0.00 5950.0 5950.0 PR
109 PR603 20250819 0.0 0.0 ... 0.00 5946.0 5940.0 PR
110 PR604 20250819 0.0 0.0 ... 0.00 5966.0 5970.0 PR
111 PR605 20250819 5964.0 5964.0 ... 8.95 5964.0 5950.0 PR
112 PR606 20250819 0.0 0.0 ... 0.00 5956.0 5948.0 PR
113 PR607 20250819 0.0 0.0 ... 0.00 5962.0 5954.0 PR
114 PR608 20250819 0.0 0.0 ... 0.00 5968.0 5966.0 PR
115 PX509 20250819 6842.0 6860.0 ... 97946.03 6826.0 6756.0 PX
116 PX510 20250819 6804.0 6876.0 ... 245824.17 6820.0 6732.0 PX
117 PX511 20250819 6770.0 6852.0 ... 753960.19 6792.0 6702.0 PX
118 PX512 20250819 6750.0 6820.0 ... 85602.52 6772.0 6698.0 PX
119 PX601 20250819 6734.0 6770.0 ... 164474.23 6738.0 6692.0 PX
120 PX602 20250819 6740.0 6750.0 ... 6.75 6746.0 6714.0 PX
121 PX603 20250819 0.0 0.0 ... 0.00 6712.0 6692.0 PX
122 PX604 20250819 0.0 0.0 ... 0.00 6712.0 6710.0 PX
123 PX605 20250819 6716.0 6766.0 ... 398.37 6752.0 6696.0 PX
124 PX606 20250819 6742.0 6748.0 ... 20.23 6744.0 6706.0 PX
125 PX607 20250819 6748.0 6766.0 ... 10.14 6758.0 6696.0 PX
126 PX608 20250819 0.0 0.0 ... 0.00 6726.0 6726.0 PX
127 RI509 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
128 RI511 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
129 RI601 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
130 RI603 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
131 RI605 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
132 RI607 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
133 RM509 20250819 2691.0 2712.0 ... 105984.94 2692.0 2686.0 RM
134 RM511 20250819 2601.0 2643.0 ... 30345.08 2630.0 2596.0 RM
135 RM601 20250819 2591.0 2626.0 ... 1065922.17 2611.0 2578.0 RM
136 RM603 20250819 2539.0 2567.0 ... 9296.43 2553.0 2531.0 RM
137 RM605 20250819 2500.0 2531.0 ... 135307.60 2514.0 2502.0 RM
138 RM607 20250819 2473.0 2496.0 ... 5280.42 2483.0 2470.0 RM
139 RM608 20250819 2578.0 2578.0 ... 285.56 2550.0 2533.0 RM
140 RS509 20250819 4985.0 5098.0 ... 835.12 4971.0 5012.0 RS
141 RS511 20250819 5320.0 5441.0 ... 86.43 5402.0 5442.0 RS
142 RS607 20250819 5676.0 5676.0 ... 56.13 5613.0 5643.0 RS
143 RS608 20250819 0.0 0.0 ... 0.00 5627.0 5627.0 RS
144 SA509 20250819 1272.0 1284.0 ... 302072.84 1265.0 1282.0 SA
145 SA510 20250819 1310.0 1318.0 ... 334622.38 1296.0 1317.0 SA
146 SA511 20250819 1304.0 1328.0 ... 480657.04 1304.0 1324.0 SA
147 SA512 20250819 1378.0 1389.0 ... 170609.73 1369.0 1382.0 SA
148 SA601 20250819 1388.0 1398.0 ... 4903929.59 1378.0 1394.0 SA
149 SA602 20250819 1400.0 1409.0 ... 7471.12 1390.0 1402.0 SA
150 SA603 20250819 1402.0 1412.0 ... 3390.11 1395.0 1404.0 SA
151 SA604 20250819 1444.0 1448.0 ... 2054.03 1428.0 1440.0 SA
152 SA605 20250819 1436.0 1455.0 ... 129717.32 1436.0 1447.0 SA
153 SA606 20250819 1451.0 1456.0 ... 895.68 1435.0 1450.0 SA
154 SA607 20250819 1448.0 1455.0 ... 1595.66 1435.0 1449.0 SA
155 SA608 20250819 1466.0 1468.0 ... 165.39 1451.0 1463.0 SA
156 SF509 20250819 5702.0 5704.0 ... 123600.80 5578.0 5718.0 SF
157 SF510 20250819 5676.0 5680.0 ... 223430.22 5548.0 5686.0 SF
158 SF511 20250819 5880.0 5880.0 ... 1065687.52 5722.0 5886.0 SF
159 SF512 20250819 5872.0 5872.0 ... 56057.22 5710.0 5872.0 SF
160 SF601 20250819 5860.0 5860.0 ... 257066.20 5702.0 5874.0 SF
161 SF602 20250819 5806.0 5812.0 ... 2611.43 5666.0 5838.0 SF
162 SF603 20250819 5970.0 5970.0 ... 628.55 5794.0 6046.0 SF
163 SF604 20250819 5912.0 5914.0 ... 57.95 5796.0 6032.0 SF
164 SF605 20250819 6000.0 6000.0 ... 4344.56 5836.0 5998.0 SF
165 SF606 20250819 6040.0 6040.0 ... 206.36 5814.0 5970.0 SF
166 SF607 20250819 6060.0 6064.0 ... 285.98 5958.0 6124.0 SF
167 SF608 20250819 0.0 0.0 ... 0.00 5898.0 6100.0 SF
168 SH509 20250819 2569.0 2571.0 ... 385505.54 2531.0 2564.0 SH
169 SH510 20250819 2691.0 2695.0 ... 551702.33 2654.0 2688.0 SH
170 SH511 20250819 2691.0 2705.0 ... 874025.26 2667.0 2703.0 SH
171 SH512 20250819 2685.0 2694.0 ... 159317.08 2663.0 2695.0 SH
172 SH601 20250819 2641.0 2642.0 ... 1645559.52 2608.0 2647.0 SH
173 SH602 20250819 2653.0 2654.0 ... 1495.23 2623.0 2662.0 SH
174 SH603 20250819 2670.0 2679.0 ... 1494.27 2635.0 2677.0 SH
175 SH604 20250819 2709.0 2709.0 ... 638.12 2692.0 2721.0 SH
176 SH605 20250819 2726.0 2728.0 ... 23013.44 2700.0 2730.0 SH
177 SH606 20250819 2719.0 2728.0 ... 293.02 2713.0 2742.0 SH
178 SH607 20250819 2718.0 2718.0 ... 32.51 2709.0 2726.0 SH
179 SH608 20250819 2710.0 2710.0 ... 81.30 2710.0 2727.0 SH
180 SM509 20250819 5996.0 6012.0 ... 568912.42 5894.0 6018.0 SM
181 SM510 20250819 6026.0 6026.0 ... 164811.84 5892.0 6022.0 SM
182 SM511 20250819 6088.0 6090.0 ... 275213.92 5938.0 6096.0 SM
183 SM512 20250819 6098.0 6098.0 ... 72507.68 5934.0 6108.0 SM
184 SM601 20250819 6102.0 6104.0 ... 927827.87 5970.0 6110.0 SM
185 SM602 20250819 6096.0 6096.0 ... 412.65 5938.0 6094.0 SM
186 SM603 20250819 6048.0 6058.0 ... 119.58 5980.0 6124.0 SM
187 SM604 20250819 6064.0 6068.0 ... 24.15 6038.0 6144.0 SM
188 SM605 20250819 6128.0 6130.0 ... 11513.12 6012.0 6140.0 SM
189 SM606 20250819 6092.0 6094.0 ... 170.98 6000.0 6148.0 SM
190 SM607 20250819 6100.0 6112.0 ... 217.68 6048.0 6160.0 SM
191 SM608 20250819 5990.0 5990.0 ... 17.93 5978.0 6160.0 SM
192 SR509 20250819 5739.0 5750.0 ... 106925.87 5733.0 5728.0 SR
193 SR511 20250819 5688.0 5692.0 ... 118664.01 5681.0 5663.0 SR
194 SR601 20250819 5672.0 5683.0 ... 967271.89 5673.0 5657.0 SR
195 SR603 20250819 5640.0 5655.0 ... 2439.97 5648.0 5633.0 SR
196 SR605 20250819 5620.0 5638.0 ... 30673.51 5629.0 5615.0 SR
197 SR607 20250819 5607.0 5630.0 ... 1253.39 5621.0 5607.0 SR
198 TA509 20250819 4708.0 4714.0 ... 342718.65 4696.0 4680.0 TA
199 TA510 20250819 4736.0 4764.0 ... 216223.43 4738.0 4710.0 TA
200 TA511 20250819 4752.0 4770.0 ... 195275.22 4744.0 4712.0 TA
201 TA512 20250819 4746.0 4768.0 ... 46121.60 4746.0 4718.0 TA
202 TA601 20250819 4748.0 4768.0 ... 1303122.10 4746.0 4726.0 TA
203 TA602 20250819 4760.0 4762.0 ... 19.04 4762.0 4742.0 TA
204 TA603 20250819 4772.0 4772.0 ... 19.07 4768.0 4752.0 TA
205 TA604 20250819 4784.0 4784.0 ... 2.39 4784.0 4782.0 TA
206 TA605 20250819 4794.0 4810.0 ... 39042.38 4790.0 4768.0 TA
207 TA606 20250819 0.0 0.0 ... 0.00 4792.0 4804.0 TA
208 TA607 20250819 4824.0 4824.0 ... 7.22 4816.0 4820.0 TA
209 TA608 20250819 4834.0 4834.0 ... 7.23 4824.0 4790.0 TA
210 UR509 20250819 1731.0 1785.0 ... 127941.25 1756.0 1732.0 UR
211 UR510 20250819 1733.0 1780.0 ... 34036.73 1749.0 1736.0 UR
212 UR511 20250819 1754.0 1822.0 ... 49784.51 1771.0 1755.0 UR
213 UR512 20250819 1749.0 1820.0 ... 2625.50 1796.0 1754.0 UR
214 UR601 20250819 1756.0 1826.0 ... 1438395.88 1789.0 1755.0 UR
215 UR602 20250819 1746.0 1818.0 ... 1784.59 1785.0 1752.0 UR
216 UR603 20250819 1781.0 1843.0 ... 943.90 1822.0 1789.0 UR
217 UR604 20250819 1784.0 1845.0 ... 295.46 1824.0 1793.0 UR
218 UR605 20250819 1790.0 1852.0 ... 47348.94 1820.0 1793.0 UR
219 UR606 20250819 1786.0 1839.0 ... 782.92 1812.0 1790.0 UR
220 UR607 20250819 1795.0 1845.0 ... 608.69 1822.0 1799.0 UR
221 UR608 20250819 1799.0 1835.0 ... 128.81 1789.0 1799.0 UR
222 WH509 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
223 WH511 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
224 WH601 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
225 WH603 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
226 WH605 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
227 WH607 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
228 ZC509 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
229 ZC510 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
230 ZC511 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
231 ZC512 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
232 ZC601 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
233 ZC602 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
234 ZC603 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
235 ZC604 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
236 ZC605 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
237 ZC606 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
238 ZC607 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
239 ZC608 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
[240 rows x 12 columns]
2025-08-20 11:22:27,241 - future_1d - INFO - ak.get_czce_daily('2025-08-19') done
symbol date open ... settle pre_settle variety
0 PS2509 20250819 51985.0 ... 52100.0 52495.0 PS
1 PS2510 20250819 52500.0 ... 52225.0 52595.0 PS
2 PS2511 20250819 52275.0 ... 52145.0 52540.0 PS
3 PS2512 20250819 54805.0 ... 54490.0 54905.0 PS
4 PS2601 20250819 54815.0 ... 54565.0 55035.0 PS
5 PS2602 20250819 54915.0 ... 54720.0 55530.0 PS
6 PS2603 20250819 54985.0 ... 54800.0 55775.0 PS
7 PS2604 20250819 55290.0 ... 54965.0 55975.0 PS
8 PS2605 20250819 55220.0 ... 54995.0 55475.0 PS
9 PS2606 20250819 57975.0 ... 57710.0 58225.0 PS
10 PS2607 20250819 58115.0 ... 57915.0 58455.0 PS
11 PS2608 20250819 58140.0 ... 58185.0 58360.0 PS
13 SI2509 20250819 8600.0 ... 8610.0 8720.0 SI
14 SI2510 20250819 8600.0 ... 8635.0 8715.0 SI
15 SI2511 20250819 8615.0 ... 8640.0 8735.0 SI
16 SI2512 20250819 9055.0 ... 8990.0 9085.0 SI
17 SI2601 20250819 8955.0 ... 8990.0 9090.0 SI
18 SI2602 20250819 8960.0 ... 9000.0 9065.0 SI
19 SI2603 20250819 8970.0 ... 9015.0 9105.0 SI
20 SI2604 20250819 9000.0 ... 9025.0 9125.0 SI
21 SI2605 20250819 9030.0 ... 9040.0 9165.0 SI
22 SI2606 20250819 9025.0 ... 9030.0 9175.0 SI
23 SI2607 20250819 9045.0 ... 9060.0 9160.0 SI
24 SI2608 20250819 9050.0 ... 9070.0 9210.0 SI
27 LC2509 20250819 89300.0 ... 88080.0 89040.0 LC
28 LC2510 20250819 89200.0 ... 88040.0 89160.0 LC
29 LC2511 20250819 89500.0 ... 88020.0 89140.0 LC
30 LC2512 20250819 90000.0 ... 87900.0 89080.0 LC
31 LC2601 20250819 88640.0 ... 87640.0 88800.0 LC
32 LC2602 20250819 89160.0 ... 87200.0 88480.0 LC
33 LC2603 20250819 88000.0 ... 86820.0 87980.0 LC
34 LC2604 20250819 90020.0 ... 87080.0 87760.0 LC
35 LC2605 20250819 87300.0 ... 86280.0 87300.0 LC
36 LC2606 20250819 89240.0 ... 87120.0 86900.0 LC
37 LC2607 20250819 87040.0 ... 85660.0 86620.0 LC
38 LC2608 20250819 86400.0 ... 85680.0 86480.0 LC
[36 rows x 12 columns]
2025-08-20 11:22:27,481 - future_1d - INFO - ak.get_gfex_daily('2025-08-19') done
symbol date open ... settle pre_settle variety
0 a2509 20250819 4139.00 ... 4137.00 4137.00 A
1 a2511 20250819 4055.00 ... 4052.00 4056.00 A
2 a2601 20250819 4047.00 ... 4052.00 4055.00 A
3 a2603 20250819 4044.00 ... 4050.00 4052.00 A
4 a2605 20250819 4089.00 ... 4094.00 4096.00 A
5 a2607 20250819 4087.00 ... 4090.00 4090.00 A
6 b2509 20250819 3801.00 ... 3820.00 3800.00 B
7 b2510 20250819 3842.00 ... 3864.00 3845.00 B
8 b2511 20250819 3890.00 ... 3908.00 3891.00 B
9 b2512 20250819 3895.00 ... 3917.00 3902.00 B
10 b2601 20250819 3873.00 ... 3898.00 3883.00 B
11 b2602 20250819 3848.00 ... 3869.00 3850.00 B
12 b2603 20250819 3775.00 ... 3781.00 3766.00 B
13 b2604 20250819 3662.00 ... 3668.00 3645.00 B
14 b2605 20250819 3571.00 ... 3590.00 3566.00 B
15 b2606 20250819 3563.00 ... 3566.00 3549.00 B
16 b2607 20250819 3548.00 ... 3558.00 3532.00 B
17 b2608 20250819 3637.00 ... 3640.00 3612.00 B
18 bb2509 20250819 144.30 ... 144.30 144.60 BB
19 bb2511 20250819 144.95 ... 145.10 145.85 BB
20 bb2601 20250819 147.50 ... 147.40 147.45 BB
21 bb2603 20250819 146.30 ... 146.30 146.25 BB
22 bb2605 20250819 0.00 ... 140.20 140.20 BB
23 bb2607 20250819 0.00 ... 145.95 145.95 BB
24 bz2603 20250819 6186.00 ... 6190.00 6171.00 BZ
25 bz2604 20250819 6150.00 ... 6150.00 6138.00 BZ
26 bz2605 20250819 6150.00 ... 6150.00 6155.00 BZ
27 bz2606 20250819 0.00 ... 6143.00 6143.00 BZ
28 bz2607 20250819 0.00 ... 6175.00 6175.00 BZ
29 c2509 20250819 2261.00 ... 2256.00 2267.00 C
30 c2511 20250819 2180.00 ... 2176.00 2183.00 C
31 c2601 20250819 2170.00 ... 2173.00 2181.00 C
32 c2603 20250819 2195.00 ... 2191.00 2201.00 C
33 c2605 20250819 2252.00 ... 2248.00 2254.00 C
34 c2607 20250819 2269.00 ... 2266.00 2271.00 C
35 cs2509 20250819 2603.00 ... 2591.00 2608.00 CS
36 cs2511 20250819 2509.00 ... 2498.00 2514.00 CS
37 cs2601 20250819 2537.00 ... 2529.00 2544.00 CS
38 cs2603 20250819 2539.00 ... 2534.00 2545.00 CS
39 cs2605 20250819 2608.00 ... 2605.00 2613.00 CS
40 cs2607 20250819 2614.00 ... 2612.00 2617.00 CS
41 eb2508 20250819 7693.00 ... 7263.00 7322.00 EB
42 eb2509 20250819 7219.00 ... 7226.00 7207.00 EB
43 eb2510 20250819 7235.00 ... 7239.00 7225.00 EB
44 eb2511 20250819 7263.00 ... 7258.00 7251.00 EB
45 eb2512 20250819 7283.00 ... 7279.00 7272.00 EB
46 eb2601 20250819 7311.00 ... 7302.00 7292.00 EB
47 eb2602 20250819 7330.00 ... 7330.00 7317.00 EB
48 eb2603 20250819 7341.00 ... 7351.00 7340.00 EB
49 eb2604 20250819 7380.00 ... 7380.00 7341.00 EB
50 eb2605 20250819 7391.00 ... 7393.00 7383.00 EB
51 eb2606 20250819 7393.00 ... 7393.00 7381.00 EB
52 eb2607 20250819 0.00 ... 7384.00 7384.00 EB
53 eg2508 20250819 0.00 ... 4407.00 4407.00 EG
54 eg2509 20250819 4355.00 ... 4363.00 4353.00 EG
55 eg2510 20250819 4368.00 ... 4388.00 4372.00 EG
56 eg2511 20250819 4388.00 ... 4392.00 4380.00 EG
57 eg2512 20250819 4386.00 ... 4399.00 4387.00 EG
58 eg2601 20250819 4404.00 ... 4406.00 4391.00 EG
59 eg2602 20250819 4428.00 ... 4426.00 4401.00 EG
60 eg2603 20250819 4372.00 ... 4433.00 4405.00 EG
61 eg2604 20250819 4444.00 ... 4453.00 4430.00 EG
62 eg2605 20250819 4441.00 ... 4452.00 4433.00 EG
63 eg2606 20250819 4451.00 ... 4459.00 4427.00 EG
64 eg2607 20250819 4497.00 ... 4497.00 4429.00 EG
65 fb2509 20250819 1258.00 ... 1256.50 1271.00 FB
66 fb2510 20250819 1296.00 ... 1294.00 1293.50 FB
67 fb2511 20250819 1286.50 ... 1287.50 1287.00 FB
68 fb2512 20250819 1284.00 ... 1288.50 1287.50 FB
69 fb2601 20250819 1284.50 ... 1288.50 1287.50 FB
70 fb2602 20250819 1288.00 ... 1290.00 1290.50 FB
71 fb2603 20250819 0.00 ... 1313.50 1313.50 FB
72 fb2604 20250819 0.00 ... 1310.50 1310.50 FB
73 fb2605 20250819 0.00 ... 1311.00 1311.00 FB
74 fb2606 20250819 0.00 ... 1349.50 1356.00 FB
75 fb2607 20250819 0.00 ... 1302.50 1302.50 FB
76 fb2608 20250819 0.00 ... 1302.50 1302.50 FB
77 i2509 20250819 790.50 ... 788.00 792.00 I
78 i2510 20250819 789.50 ... 786.50 791.00 I
79 i2511 20250819 784.50 ... 783.00 787.50 I
80 i2512 20250819 780.00 ... 777.50 783.50 I
81 i2601 20250819 773.00 ... 770.50 776.00 I
82 i2602 20250819 767.00 ... 766.00 772.50 I
83 i2603 20250819 763.00 ... 762.00 767.50 I
84 i2604 20250819 757.50 ... 756.00 763.50 I
85 i2605 20250819 751.50 ... 749.00 754.50 I
86 i2606 20250819 746.50 ... 744.50 751.00 I
87 i2607 20250819 743.50 ... 741.00 746.50 I
88 i2608 20250819 738.50 ... 737.00 742.50 I
89 j2509 20250819 1634.00 ... 1645.50 1645.50 J
90 j2510 20250819 1669.00 ... 1669.50 1669.00 J
91 j2511 20250819 1691.00 ... 1691.00 1692.50 J
92 j2512 20250819 1700.00 ... 1711.50 1701.00 J
93 j2601 20250819 1716.50 ... 1718.00 1725.00 J
94 j2602 20250819 1724.50 ... 1734.50 1755.50 J
95 j2603 20250819 0.00 ... 1785.00 1791.00 J
96 j2604 20250819 1795.50 ... 1795.50 1814.00 J
97 j2605 20250819 1806.00 ... 1808.00 1820.50 J
98 j2606 20250819 1808.00 ... 1808.00 1826.50 J
99 j2607 20250819 0.00 ... 1826.00 1826.00 J
100 j2608 20250819 0.00 ... 1826.00 1826.00 J
101 jd2508 20250819 2940.00 ... 2940.00 2900.00 JD
102 jd2509 20250819 3080.00 ... 3023.00 3116.00 JD
103 jd2510 20250819 3098.00 ... 3083.00 3134.00 JD
104 jd2511 20250819 3208.00 ... 3174.00 3241.00 JD
105 jd2512 20250819 3350.00 ... 3364.00 3407.00 JD
106 jd2601 20250819 3474.00 ... 3482.00 3526.00 JD
107 jd2602 20250819 3140.00 ... 3119.00 3174.00 JD
108 jd2603 20250819 3150.00 ... 3128.00 3178.00 JD
109 jd2604 20250819 3341.00 ... 3328.00 3352.00 JD
110 jd2605 20250819 3468.00 ... 3454.00 3478.00 JD
111 jd2606 20250819 3306.00 ... 3304.00 3313.00 JD
112 jd2607 20250819 3561.00 ... 3555.00 3559.00 JD
113 jm2509 20250819 1035.00 ... 1048.50 1062.00 JM
114 jm2510 20250819 1072.00 ... 1081.50 1097.50 JM
115 jm2511 20250819 1133.00 ... 1130.50 1144.00 JM
116 jm2512 20250819 1176.00 ... 1167.00 1182.50 JM
117 jm2601 20250819 1189.50 ... 1193.50 1217.50 JM
118 jm2602 20250819 1204.50 ... 1207.50 1223.50 JM
119 jm2603 20250819 1221.50 ... 1215.50 1245.50 JM
120 jm2604 20250819 1222.00 ... 1225.00 1262.00 JM
121 jm2605 20250819 1239.00 ... 1233.00 1264.50 JM
122 jm2606 20250819 1243.50 ... 1239.50 1273.00 JM
123 jm2607 20250819 1258.00 ... 1250.00 1278.50 JM
124 jm2608 20250819 1259.50 ... 1245.00 1281.00 JM
125 l2509 20250819 7266.00 ... 7284.00 7292.00 L
126 l2510 20250819 7310.00 ... 7298.00 7309.00 L
127 l2511 20250819 7328.00 ... 7320.00 7335.00 L
128 l2512 20250819 7336.00 ... 7327.00 7346.00 L
129 l2601 20250819 7334.00 ... 7320.00 7338.00 L
130 l2602 20250819 7324.00 ... 7312.00 7329.00 L
131 l2603 20250819 7323.00 ... 7311.00 7328.00 L
132 l2604 20250819 7320.00 ... 7327.00 7349.00 L
133 l2605 20250819 7311.00 ... 7303.00 7318.00 L
134 l2606 20250819 7312.00 ... 7303.00 7311.00 L
135 l2607 20250819 7302.00 ... 7302.00 7351.00 L
136 l2608 20250819 0.00 ... 7380.00 7380.00 L
137 lg2509 20250819 809.50 ... 811.00 816.00 LG
138 lg2511 20250819 821.50 ... 822.00 827.00 LG
139 lg2601 20250819 828.50 ... 829.00 831.00 LG
140 lg2603 20250819 831.50 ... 833.00 836.50 LG
141 lg2605 20250819 835.00 ... 834.00 838.00 LG
142 lg2607 20250819 831.00 ... 833.00 837.50 LG
143 lh2509 20250819 13640.00 ... 13740.00 13670.00 LH
144 lh2511 20250819 13855.00 ... 13875.00 13875.00 LH
145 lh2601 20250819 14140.00 ... 14180.00 14175.00 LH
146 lh2603 20250819 13290.00 ... 13320.00 13305.00 LH
147 lh2605 20250819 13795.00 ... 13800.00 13815.00 LH
148 lh2607 20250819 14215.00 ... 14250.00 14210.00 LH
149 m2509 20250819 3098.00 ... 3115.00 3093.00 M
150 m2511 20250819 3135.00 ... 3149.00 3123.00 M
151 m2512 20250819 3173.00 ... 3183.00 3171.00 M
152 m2601 20250819 3155.00 ... 3167.00 3147.00 M
153 m2603 20250819 3052.00 ... 3057.00 3042.00 M
154 m2605 20250819 2848.00 ... 2853.00 2837.00 M
155 m2607 20250819 2819.00 ... 2824.00 2805.00 M
156 m2608 20250819 2943.00 ... 2945.00 2926.00 M
157 p2509 20250819 9566.00 ... 9616.00 9552.00 P
158 p2510 20250819 9610.00 ... 9658.00 9568.00 P
159 p2511 20250819 9606.00 ... 9646.00 9586.00 P
160 p2512 20250819 9616.00 ... 9652.00 9586.00 P
161 p2601 20250819 9602.00 ... 9660.00 9606.00 P
162 p2602 20250819 9572.00 ... 9616.00 9552.00 P
163 p2603 20250819 9496.00 ... 9532.00 9470.00 P
164 p2604 20250819 9410.00 ... 9446.00 9380.00 P
165 p2605 20250819 9296.00 ... 9354.00 9292.00 P
166 p2606 20250819 9272.00 ... 9264.00 9172.00 P
167 p2607 20250819 9146.00 ... 9134.00 9070.00 P
168 p2608 20250819 9092.00 ... 9066.00 8962.00 P
169 pg2508 20250819 3888.00 ... 3888.00 3888.00 PG
170 pg2509 20250819 3855.00 ... 3860.00 3849.00 PG
171 pg2510 20250819 4327.00 ... 4314.00 4308.00 PG
172 pg2511 20250819 4249.00 ... 4240.00 4230.00 PG
173 pg2512 20250819 4194.00 ... 4181.00 4178.00 PG
174 pg2601 20250819 4140.00 ... 4132.00 4130.00 PG
175 pg2602 20250819 4090.00 ... 4075.00 4077.00 PG
176 pg2603 20250819 4002.00 ... 3982.00 3995.00 PG
177 pg2604 20250819 4278.00 ... 4276.00 4289.00 PG
178 pg2605 20250819 4185.00 ... 4185.00 4194.00 PG
179 pg2606 20250819 4122.00 ... 4118.00 4123.00 PG
180 pg2607 20250819 4065.00 ... 4063.00 4068.00 PG
181 pp2509 20250819 7031.00 ... 7002.00 7036.00 PP
182 pp2510 20250819 7002.00 ... 6995.00 7028.00 PP
183 pp2511 20250819 7025.00 ... 7008.00 7038.00 PP
184 pp2512 20250819 7044.00 ... 7028.00 7065.00 PP
185 pp2601 20250819 7046.00 ... 7028.00 7058.00 PP
186 pp2602 20250819 7024.00 ... 7010.00 7038.00 PP
187 pp2603 20250819 7019.00 ... 7007.00 7026.00 PP
188 pp2604 20250819 7026.00 ... 7026.00 7053.00 PP
189 pp2605 20250819 7049.00 ... 7034.00 7056.00 PP
190 pp2606 20250819 7009.00 ... 7004.00 7036.00 PP
191 pp2607 20250819 7027.00 ... 7026.00 7030.00 PP
192 pp2608 20250819 0.00 ... 7034.00 7054.00 PP
193 rr2509 20250819 3580.00 ... 3574.00 3574.00 RR
194 rr2510 20250819 3615.00 ... 3609.00 3613.00 RR
195 rr2511 20250819 3613.00 ... 3612.00 3613.00 RR
196 rr2512 20250819 3607.00 ... 3606.00 3609.00 RR
197 rr2601 20250819 3616.00 ... 3616.00 3619.00 RR
198 rr2602 20250819 0.00 ... 3608.00 3608.00 RR
199 rr2603 20250819 0.00 ... 3612.00 3612.00 RR
200 rr2604 20250819 3613.00 ... 3613.00 3619.00 RR
201 rr2605 20250819 3610.00 ... 3610.00 3619.00 RR
202 rr2606 20250819 3606.00 ... 3606.00 3625.00 RR
203 rr2607 20250819 0.00 ... 3625.00 3625.00 RR
204 rr2608 20250819 0.00 ... 3625.00 3625.00 RR
205 v2509 20250819 4920.00 ... 4880.00 4937.00 V
206 v2510 20250819 4959.00 ... 4918.00 4968.00 V
207 v2511 20250819 4990.00 ... 4947.00 5009.00 V
208 v2512 20250819 5026.00 ... 4984.00 5042.00 V
209 v2601 20250819 5057.00 ... 5019.00 5069.00 V
210 v2602 20250819 5091.00 ... 5057.00 5097.00 V
211 v2603 20250819 5126.00 ... 5086.00 5132.00 V
212 v2604 20250819 5330.00 ... 5327.00 5340.00 V
213 v2605 20250819 5372.00 ... 5324.00 5368.00 V
214 v2606 20250819 5387.00 ... 5377.00 5390.00 V
215 v2607 20250819 5422.00 ... 5390.00 5428.00 V
216 v2608 20250819 5454.00 ... 5413.00 5457.00 V
217 y2509 20250819 8546.00 ... 8580.00 8596.00 Y
218 y2511 20250819 8566.00 ... 8594.00 8600.00 Y
219 y2512 20250819 8574.00 ... 8592.00 8600.00 Y
220 y2601 20250819 8544.00 ... 8552.00 8562.00 Y
221 y2603 20250819 8436.00 ... 8490.00 8448.00 Y
222 y2605 20250819 8146.00 ... 8216.00 8138.00 Y
223 y2607 20250819 8130.00 ... 8166.00 8104.00 Y
224 y2608 20250819 8216.00 ... 8226.00 8140.00 Y
[225 rows x 12 columns]
2025-08-20 11:22:27,971 - future_1d - INFO - ak.get_dce_daily('2025-08-19') done
2025-08-20 11:22:29,773 - future_1d - INFO - save future_daily 2025-08-19 add
2025-08-20 11:22:29,780 - future_1d - INFO - 0 1 2 3 4
symbol IC2509 IC2510 IC2512 IC2603 IF2509
date 2025-08-19 2025-08-19 2025-08-19 2025-08-19 2025-08-19
opencol 6600.0 6571.0 6488.8 6359.8 4244.0
high 6652.0 6610.6 6528.0 6413.6 4260.4
low 6583.2 6547.4 6456.8 6332.2 4208.8
close 6600.0 6556.6 6463.0 6340.0 4216.2
volume 64150.0 3075.0 24132.0 10995.0 73558.0
open_interest 123458.0 3059.0 67050.0 27183.0 154897.0
turnover 8491013.408 404415.284 3134451.06 1401335.556 9348115.656
settle 6602.8 6560.2 6475.0 6346.8 4221.0
pre_settle 6608.4 6568.6 6488.8 6367.8 4237.4
variety IC IC IC IC IF
exchange CFFEX CFFEX CFFEX CFFEX CFFEX
comd IC IC IC IC IF
contract IC2509 IC2510 IC2512 IC2603 IF2509
contract_yymm 2509 2510 2512 2603 2509
maturity_month 1 2 4 7 1
maturity_day 13 43 104 194 13
symbol date open high ... turnover settle pre_settle variety
0 AP510 20250819 8220.0 8220.0 ... 379516.48 8156.0 8155.0 AP
1 AP511 20250819 7932.0 7957.0 ... 1728.77 7930.0 7900.0 AP
2 AP512 20250819 7984.0 7993.0 ... 143.21 7956.0 7960.0 AP
3 AP601 20250819 8095.0 8098.0 ... 55700.65 8046.0 8038.0 AP
4 AP603 20250819 7968.0 7985.0 ... 127.20 7950.0 7956.0 AP
5 AP604 20250819 7989.0 7998.0 ... 55.82 7974.0 7974.0 AP
6 AP605 20250819 8039.0 8050.0 ... 424.56 8011.0 8028.0 AP
7 CF509 20250819 13830.0 13875.0 ... 219015.08 13835.0 13835.0 CF
8 CF511 20250819 14050.0 14080.0 ... 127064.73 14030.0 14030.0 CF
9 CF601 20250819 14135.0 14170.0 ... 1036946.74 14125.0 14115.0 CF
10 CF603 20250819 14100.0 14125.0 ... 1218.11 14080.0 14075.0 CF
11 CF605 20250819 14105.0 14140.0 ... 88622.51 14095.0 14075.0 CF
12 CF607 20250819 14100.0 14125.0 ... 246.74 14100.0 14080.0 CF
13 CJ509 20250819 10475.0 10705.0 ... 14294.76 10535.0 10495.0 CJ
14 CJ512 20250819 11425.0 11700.0 ... 23075.91 11505.0 11435.0 CJ
15 CJ601 20250819 11505.0 11825.0 ... 1646270.88 11620.0 11545.0 CJ
16 CJ603 20250819 11550.0 11850.0 ... 10844.80 11640.0 11595.0 CJ
17 CJ605 20250819 11645.0 11955.0 ... 189067.10 11770.0 11715.0 CJ
18 CJ607 20250819 11825.0 12060.0 ... 4742.37 11945.0 11880.0 CJ
19 CY509 20250819 20130.0 20140.0 ... 592.97 20100.0 20095.0 CY
20 CY510 20250819 0.0 0.0 ... 0.00 19705.0 19705.0 CY
21 CY511 20250819 20180.0 20215.0 ... 79404.60 20155.0 20165.0 CY
22 CY512 20250819 0.0 0.0 ... 0.00 19905.0 19855.0 CY
23 CY601 20250819 20205.0 20205.0 ... 1259.82 20155.0 20145.0 CY
24 CY602 20250819 0.0 0.0 ... 0.00 20015.0 20015.0 CY
25 CY603 20250819 0.0 0.0 ... 0.00 20365.0 20365.0 CY
26 CY604 20250819 0.0 0.0 ... 0.00 20030.0 20030.0 CY
27 CY605 20250819 0.0 0.0 ... 0.00 20340.0 20340.0 CY
28 CY606 20250819 0.0 0.0 ... 0.00 20010.0 20010.0 CY
29 CY607 20250819 0.0 0.0 ... 0.00 20410.0 20410.0 CY
30 CY608 20250819 0.0 0.0 ... 0.00 20410.0 20410.0 CY
31 FG509 20250819 1040.0 1050.0 ... 584252.83 1035.0 1044.0 FG
32 FG510 20250819 1151.0 1167.0 ... 110668.70 1145.0 1156.0 FG
33 FG511 20250819 1137.0 1156.0 ... 142650.04 1135.0 1143.0 FG
34 FG512 20250819 1226.0 1245.0 ... 90602.86 1223.0 1226.0 FG
35 FG601 20250819 1218.0 1237.0 ... 5169810.47 1215.0 1218.0 FG
36 FG602 20250819 1277.0 1289.0 ... 1392.41 1268.0 1270.0 FG
37 FG603 20250819 1270.0 1290.0 ... 2477.99 1268.0 1272.0 FG
38 FG604 20250819 1324.0 1333.0 ... 733.61 1315.0 1317.0 FG
39 FG605 20250819 1313.0 1330.0 ... 73138.89 1309.0 1316.0 FG
40 FG606 20250819 1344.0 1356.0 ... 860.30 1336.0 1338.0 FG
41 FG607 20250819 1331.0 1350.0 ... 1341.54 1331.0 1335.0 FG
42 FG608 20250819 1357.0 1364.0 ... 474.77 1349.0 1352.0 FG
43 JR509 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
44 JR511 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
45 JR601 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
46 JR603 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
47 JR605 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
48 JR607 20250819 0.0 0.0 ... 0.00 2662.0 2662.0 JR
49 LR509 20250819 0.0 0.0 ... 0.00 2360.0 2360.0 LR
50 LR511 20250819 0.0 0.0 ... 0.00 2360.0 2360.0 LR
51 LR601 20250819 0.0 0.0 ... 0.00 2360.0 2360.0 LR
52 MA509 20250819 2291.0 2297.0 ... 240760.83 2278.0 2306.0 MA
53 MA510 20250819 2323.0 2327.0 ... 179108.33 2306.0 2334.0 MA
54 MA511 20250819 2338.0 2346.0 ... 247869.61 2325.0 2350.0 MA
55 MA512 20250819 2377.0 2384.0 ... 97642.59 2364.0 2383.0 MA
56 MA601 20250819 2397.0 2406.0 ... 1350905.33 2386.0 2400.0 MA
57 MA602 20250819 2400.0 2402.0 ... 508.75 2377.0 2411.0 MA
58 MA603 20250819 2397.0 2409.0 ... 226.98 2389.0 2415.0 MA
59 MA604 20250819 2384.0 2389.0 ... 40.48 2381.0 2410.0 MA
60 MA605 20250819 2380.0 2387.0 ... 39341.12 2369.0 2379.0 MA
61 MA606 20250819 2379.0 2386.0 ... 40.37 2375.0 2393.0 MA
62 MA607 20250819 2375.0 2384.0 ... 54.56 2372.0 2387.0 MA
63 MA608 20250819 2376.0 2388.0 ... 21.43 2381.0 2398.0 MA
64 OI509 20250819 9861.0 9964.0 ... 290846.96 9922.0 9887.0 OI
65 OI511 20250819 9850.0 9980.0 ... 251570.51 9933.0 9890.0 OI
66 OI601 20250819 9837.0 9943.0 ... 3172077.79 9894.0 9847.0 OI
67 OI603 20250819 9770.0 9856.0 ... 2247.12 9813.0 9765.0 OI
68 OI605 20250819 9702.0 9781.0 ... 112758.97 9744.0 9704.0 OI
69 OI607 20250819 9719.0 9755.0 ... 107.02 9729.0 9685.0 OI
70 PF509 20250819 6360.0 6398.0 ... 20321.70 6374.0 6332.0 PF
71 PF510 20250819 6452.0 6480.0 ... 529813.26 6452.0 6414.0 PF
72 PF511 20250819 6432.0 6468.0 ... 228008.05 6438.0 6392.0 PF
73 PF512 20250819 6420.0 6452.0 ... 60843.73 6426.0 6388.0 PF
74 PF601 20250819 6420.0 6448.0 ... 12871.15 6426.0 6400.0 PF
75 PF602 20250819 6442.0 6452.0 ... 125.60 6442.0 6416.0 PF
76 PF603 20250819 0.0 0.0 ... 0.00 6442.0 6430.0 PF
77 PF604 20250819 6486.0 6486.0 ... 3.24 6486.0 6458.0 PF
78 PF605 20250819 6480.0 6480.0 ... 3.24 6480.0 6486.0 PF
79 PF606 20250819 6492.0 6492.0 ... 3.25 6492.0 6474.0 PF
80 PF607 20250819 0.0 0.0 ... 0.00 6500.0 6490.0 PF
81 PF608 20250819 0.0 0.0 ... 0.00 6512.0 6486.0 PF
82 PK510 20250819 8046.0 8050.0 ... 55666.68 8036.0 8062.0 PK
83 PK511 20250819 7826.0 7840.0 ... 196717.02 7818.0 7822.0 PK
84 PK512 20250819 7836.0 7862.0 ... 51310.43 7848.0 7848.0 PK
85 PK601 20250819 7894.0 7930.0 ... 26485.91 7912.0 7914.0 PK
86 PK603 20250819 7916.0 7926.0 ... 261.31 7918.0 7926.0 PK
87 PK604 20250819 7910.0 7930.0 ... 106.91 7920.0 7916.0 PK
88 PK605 20250819 7916.0 7930.0 ... 2300.45 7920.0 7922.0 PK
89 PL601 20250819 6444.0 6463.0 ... 25252.45 6426.0 6467.0 PL
90 PL602 20250819 6499.0 6499.0 ... 103.55 6472.0 6503.0 PL
91 PL603 20250819 6443.0 6443.0 ... 25.74 6434.0 6476.0 PL
92 PL604 20250819 6435.0 6435.0 ... 12.87 6435.0 6502.0 PL
93 PL605 20250819 6368.0 6368.0 ... 139.51 6342.0 6380.0 PL
94 PL606 20250819 0.0 0.0 ... 0.00 6450.0 6482.0 PL
95 PL607 20250819 6475.0 6475.0 ... 12.95 6475.0 6500.0 PL
96 PL608 20250819 0.0 0.0 ... 0.00 6500.0 6500.0 PL
97 PM509 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
98 PM511 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
99 PM601 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
100 PM603 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
101 PM605 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
102 PM607 20250819 0.0 0.0 ... 0.00 3122.0 3122.0 PM
103 PR509 20250819 5848.0 5860.0 ... 6927.20 5846.0 5844.0 PR
104 PR510 20250819 5914.0 5936.0 ... 202685.89 5912.0 5898.0 PR
105 PR511 20250819 5918.0 5940.0 ... 378257.78 5916.0 5896.0 PR
106 PR512 20250819 5926.0 5948.0 ... 73536.65 5924.0 5902.0 PR
107 PR601 20250819 5940.0 5958.0 ... 2895.76 5940.0 5924.0 PR
108 PR602 20250819 0.0 0.0 ... 0.00 5950.0 5950.0 PR
109 PR603 20250819 0.0 0.0 ... 0.00 5946.0 5940.0 PR
110 PR604 20250819 0.0 0.0 ... 0.00 5966.0 5970.0 PR
111 PR605 20250819 5964.0 5964.0 ... 8.95 5964.0 5950.0 PR
112 PR606 20250819 0.0 0.0 ... 0.00 5956.0 5948.0 PR
113 PR607 20250819 0.0 0.0 ... 0.00 5962.0 5954.0 PR
114 PR608 20250819 0.0 0.0 ... 0.00 5968.0 5966.0 PR
115 PX509 20250819 6842.0 6860.0 ... 97946.03 6826.0 6756.0 PX
116 PX510 20250819 6804.0 6876.0 ... 245824.17 6820.0 6732.0 PX
117 PX511 20250819 6770.0 6852.0 ... 753960.19 6792.0 6702.0 PX
118 PX512 20250819 6750.0 6820.0 ... 85602.52 6772.0 6698.0 PX
119 PX601 20250819 6734.0 6770.0 ... 164474.23 6738.0 6692.0 PX
120 PX602 20250819 6740.0 6750.0 ... 6.75 6746.0 6714.0 PX
121 PX603 20250819 0.0 0.0 ... 0.00 6712.0 6692.0 PX
122 PX604 20250819 0.0 0.0 ... 0.00 6712.0 6710.0 PX
123 PX605 20250819 6716.0 6766.0 ... 398.37 6752.0 6696.0 PX
124 PX606 20250819 6742.0 6748.0 ... 20.23 6744.0 6706.0 PX
125 PX607 20250819 6748.0 6766.0 ... 10.14 6758.0 6696.0 PX
126 PX608 20250819 0.0 0.0 ... 0.00 6726.0 6726.0 PX
127 RI509 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
128 RI511 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
129 RI601 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
130 RI603 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
131 RI605 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
132 RI607 20250819 0.0 0.0 ... 0.00 2479.0 2479.0 RI
133 RM509 20250819 2691.0 2712.0 ... 105984.94 2692.0 2686.0 RM
134 RM511 20250819 2601.0 2643.0 ... 30345.08 2630.0 2596.0 RM
135 RM601 20250819 2591.0 2626.0 ... 1065922.17 2611.0 2578.0 RM
136 RM603 20250819 2539.0 2567.0 ... 9296.43 2553.0 2531.0 RM
137 RM605 20250819 2500.0 2531.0 ... 135307.60 2514.0 2502.0 RM
138 RM607 20250819 2473.0 2496.0 ... 5280.42 2483.0 2470.0 RM
139 RM608 20250819 2578.0 2578.0 ... 285.56 2550.0 2533.0 RM
140 RS509 20250819 4985.0 5098.0 ... 835.12 4971.0 5012.0 RS
141 RS511 20250819 5320.0 5441.0 ... 86.43 5402.0 5442.0 RS
142 RS607 20250819 5676.0 5676.0 ... 56.13 5613.0 5643.0 RS
143 RS608 20250819 0.0 0.0 ... 0.00 5627.0 5627.0 RS
144 SA509 20250819 1272.0 1284.0 ... 302072.84 1265.0 1282.0 SA
145 SA510 20250819 1310.0 1318.0 ... 334622.38 1296.0 1317.0 SA
146 SA511 20250819 1304.0 1328.0 ... 480657.04 1304.0 1324.0 SA
147 SA512 20250819 1378.0 1389.0 ... 170609.73 1369.0 1382.0 SA
148 SA601 20250819 1388.0 1398.0 ... 4903929.59 1378.0 1394.0 SA
149 SA602 20250819 1400.0 1409.0 ... 7471.12 1390.0 1402.0 SA
150 SA603 20250819 1402.0 1412.0 ... 3390.11 1395.0 1404.0 SA
151 SA604 20250819 1444.0 1448.0 ... 2054.03 1428.0 1440.0 SA
152 SA605 20250819 1436.0 1455.0 ... 129717.32 1436.0 1447.0 SA
153 SA606 20250819 1451.0 1456.0 ... 895.68 1435.0 1450.0 SA
154 SA607 20250819 1448.0 1455.0 ... 1595.66 1435.0 1449.0 SA
155 SA608 20250819 1466.0 1468.0 ... 165.39 1451.0 1463.0 SA
156 SF509 20250819 5702.0 5704.0 ... 123600.80 5578.0 5718.0 SF
157 SF510 20250819 5676.0 5680.0 ... 223430.22 5548.0 5686.0 SF
158 SF511 20250819 5880.0 5880.0 ... 1065687.52 5722.0 5886.0 SF
159 SF512 20250819 5872.0 5872.0 ... 56057.22 5710.0 5872.0 SF
160 SF601 20250819 5860.0 5860.0 ... 257066.20 5702.0 5874.0 SF
161 SF602 20250819 5806.0 5812.0 ... 2611.43 5666.0 5838.0 SF
162 SF603 20250819 5970.0 5970.0 ... 628.55 5794.0 6046.0 SF
163 SF604 20250819 5912.0 5914.0 ... 57.95 5796.0 6032.0 SF
164 SF605 20250819 6000.0 6000.0 ... 4344.56 5836.0 5998.0 SF
165 SF606 20250819 6040.0 6040.0 ... 206.36 5814.0 5970.0 SF
166 SF607 20250819 6060.0 6064.0 ... 285.98 5958.0 6124.0 SF
167 SF608 20250819 0.0 0.0 ... 0.00 5898.0 6100.0 SF
168 SH509 20250819 2569.0 2571.0 ... 385505.54 2531.0 2564.0 SH
169 SH510 20250819 2691.0 2695.0 ... 551702.33 2654.0 2688.0 SH
170 SH511 20250819 2691.0 2705.0 ... 874025.26 2667.0 2703.0 SH
171 SH512 20250819 2685.0 2694.0 ... 159317.08 2663.0 2695.0 SH
172 SH601 20250819 2641.0 2642.0 ... 1645559.52 2608.0 2647.0 SH
173 SH602 20250819 2653.0 2654.0 ... 1495.23 2623.0 2662.0 SH
174 SH603 20250819 2670.0 2679.0 ... 1494.27 2635.0 2677.0 SH
175 SH604 20250819 2709.0 2709.0 ... 638.12 2692.0 2721.0 SH
176 SH605 20250819 2726.0 2728.0 ... 23013.44 2700.0 2730.0 SH
177 SH606 20250819 2719.0 2728.0 ... 293.02 2713.0 2742.0 SH
178 SH607 20250819 2718.0 2718.0 ... 32.51 2709.0 2726.0 SH
179 SH608 20250819 2710.0 2710.0 ... 81.30 2710.0 2727.0 SH
180 SM509 20250819 5996.0 6012.0 ... 568912.42 5894.0 6018.0 SM
181 SM510 20250819 6026.0 6026.0 ... 164811.84 5892.0 6022.0 SM
182 SM511 20250819 6088.0 6090.0 ... 275213.92 5938.0 6096.0 SM
183 SM512 20250819 6098.0 6098.0 ... 72507.68 5934.0 6108.0 SM
184 SM601 20250819 6102.0 6104.0 ... 927827.87 5970.0 6110.0 SM
185 SM602 20250819 6096.0 6096.0 ... 412.65 5938.0 6094.0 SM
186 SM603 20250819 6048.0 6058.0 ... 119.58 5980.0 6124.0 SM
187 SM604 20250819 6064.0 6068.0 ... 24.15 6038.0 6144.0 SM
188 SM605 20250819 6128.0 6130.0 ... 11513.12 6012.0 6140.0 SM
189 SM606 20250819 6092.0 6094.0 ... 170.98 6000.0 6148.0 SM
190 SM607 20250819 6100.0 6112.0 ... 217.68 6048.0 6160.0 SM
191 SM608 20250819 5990.0 5990.0 ... 17.93 5978.0 6160.0 SM
192 SR509 20250819 5739.0 5750.0 ... 106925.87 5733.0 5728.0 SR
193 SR511 20250819 5688.0 5692.0 ... 118664.01 5681.0 5663.0 SR
194 SR601 20250819 5672.0 5683.0 ... 967271.89 5673.0 5657.0 SR
195 SR603 20250819 5640.0 5655.0 ... 2439.97 5648.0 5633.0 SR
196 SR605 20250819 5620.0 5638.0 ... 30673.51 5629.0 5615.0 SR
197 SR607 20250819 5607.0 5630.0 ... 1253.39 5621.0 5607.0 SR
198 TA509 20250819 4708.0 4714.0 ... 342718.65 4696.0 4680.0 TA
199 TA510 20250819 4736.0 4764.0 ... 216223.43 4738.0 4710.0 TA
200 TA511 20250819 4752.0 4770.0 ... 195275.22 4744.0 4712.0 TA
201 TA512 20250819 4746.0 4768.0 ... 46121.60 4746.0 4718.0 TA
202 TA601 20250819 4748.0 4768.0 ... 1303122.10 4746.0 4726.0 TA
203 TA602 20250819 4760.0 4762.0 ... 19.04 4762.0 4742.0 TA
204 TA603 20250819 4772.0 4772.0 ... 19.07 4768.0 4752.0 TA
205 TA604 20250819 4784.0 4784.0 ... 2.39 4784.0 4782.0 TA
206 TA605 20250819 4794.0 4810.0 ... 39042.38 4790.0 4768.0 TA
207 TA606 20250819 0.0 0.0 ... 0.00 4792.0 4804.0 TA
208 TA607 20250819 4824.0 4824.0 ... 7.22 4816.0 4820.0 TA
209 TA608 20250819 4834.0 4834.0 ... 7.23 4824.0 4790.0 TA
210 UR509 20250819 1731.0 1785.0 ... 127941.25 1756.0 1732.0 UR
211 UR510 20250819 1733.0 1780.0 ... 34036.73 1749.0 1736.0 UR
212 UR511 20250819 1754.0 1822.0 ... 49784.51 1771.0 1755.0 UR
213 UR512 20250819 1749.0 1820.0 ... 2625.50 1796.0 1754.0 UR
214 UR601 20250819 1756.0 1826.0 ... 1438395.88 1789.0 1755.0 UR
215 UR602 20250819 1746.0 1818.0 ... 1784.59 1785.0 1752.0 UR
216 UR603 20250819 1781.0 1843.0 ... 943.90 1822.0 1789.0 UR
217 UR604 20250819 1784.0 1845.0 ... 295.46 1824.0 1793.0 UR
218 UR605 20250819 1790.0 1852.0 ... 47348.94 1820.0 1793.0 UR
219 UR606 20250819 1786.0 1839.0 ... 782.92 1812.0 1790.0 UR
220 UR607 20250819 1795.0 1845.0 ... 608.69 1822.0 1799.0 UR
221 UR608 20250819 1799.0 1835.0 ... 128.81 1789.0 1799.0 UR
222 WH509 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
223 WH511 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
224 WH601 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
225 WH603 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
226 WH605 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
227 WH607 20250819 0.0 0.0 ... 0.00 3198.0 3198.0 WH
228 ZC509 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
229 ZC510 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
230 ZC511 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
231 ZC512 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
232 ZC601 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
233 ZC602 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
234 ZC603 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
235 ZC604 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
236 ZC605 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
237 ZC606 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
238 ZC607 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
239 ZC608 20250819 0.0 0.0 ... 0.00 801.4 801.4 ZC
[240 rows x 12 columns]
2025-08-20 11:22:34,515 - future_1d - INFO - ak.get_czce_daily('2025-08-19') done
symbol date open ... settle pre_settle variety
0 a2509 20250819 4139.00 ... 4137.00 4137.00 A
1 a2511 20250819 4055.00 ... 4052.00 4056.00 A
2 a2601 20250819 4047.00 ... 4052.00 4055.00 A
3 a2603 20250819 4044.00 ... 4050.00 4052.00 A
4 a2605 20250819 4089.00 ... 4094.00 4096.00 A
5 a2607 20250819 4087.00 ... 4090.00 4090.00 A
6 b2509 20250819 3801.00 ... 3820.00 3800.00 B
7 b2510 20250819 3842.00 ... 3864.00 3845.00 B
8 b2511 20250819 3890.00 ... 3908.00 3891.00 B
9 b2512 20250819 3895.00 ... 3917.00 3902.00 B
10 b2601 20250819 3873.00 ... 3898.00 3883.00 B
11 b2602 20250819 3848.00 ... 3869.00 3850.00 B
12 b2603 20250819 3775.00 ... 3781.00 3766.00 B
13 b2604 20250819 3662.00 ... 3668.00 3645.00 B
14 b2605 20250819 3571.00 ... 3590.00 3566.00 B
15 b2606 20250819 3563.00 ... 3566.00 3549.00 B
16 b2607 20250819 3548.00 ... 3558.00 3532.00 B
17 b2608 20250819 3637.00 ... 3640.00 3612.00 B
18 bb2509 20250819 144.30 ... 144.30 144.60 BB
19 bb2511 20250819 144.95 ... 145.10 145.85 BB
20 bb2601 20250819 147.50 ... 147.40 147.45 BB
21 bb2603 20250819 146.30 ... 146.30 146.25 BB
22 bb2605 20250819 0.00 ... 140.20 140.20 BB
23 bb2607 20250819 0.00 ... 145.95 145.95 BB
24 bz2603 20250819 6186.00 ... 6190.00 6171.00 BZ
25 bz2604 20250819 6150.00 ... 6150.00 6138.00 BZ
26 bz2605 20250819 6150.00 ... 6150.00 6155.00 BZ
27 bz2606 20250819 0.00 ... 6143.00 6143.00 BZ
28 bz2607 20250819 0.00 ... 6175.00 6175.00 BZ
29 c2509 20250819 2261.00 ... 2256.00 2267.00 C
30 c2511 20250819 2180.00 ... 2176.00 2183.00 C
31 c2601 20250819 2170.00 ... 2173.00 2181.00 C
32 c2603 20250819 2195.00 ... 2191.00 2201.00 C
33 c2605 20250819 2252.00 ... 2248.00 2254.00 C
34 c2607 20250819 2269.00 ... 2266.00 2271.00 C
35 cs2509 20250819 2603.00 ... 2591.00 2608.00 CS
36 cs2511 20250819 2509.00 ... 2498.00 2514.00 CS
37 cs2601 20250819 2537.00 ... 2529.00 2544.00 CS
38 cs2603 20250819 2539.00 ... 2534.00 2545.00 CS
39 cs2605 20250819 2608.00 ... 2605.00 2613.00 CS
40 cs2607 20250819 2614.00 ... 2612.00 2617.00 CS
41 eb2508 20250819 7693.00 ... 7263.00 7322.00 EB
42 eb2509 20250819 7219.00 ... 7226.00 7207.00 EB
43 eb2510 20250819 7235.00 ... 7239.00 7225.00 EB
44 eb2511 20250819 7263.00 ... 7258.00 7251.00 EB
45 eb2512 20250819 7283.00 ... 7279.00 7272.00 EB
46 eb2601 20250819 7311.00 ... 7302.00 7292.00 EB
47 eb2602 20250819 7330.00 ... 7330.00 7317.00 EB
48 eb2603 20250819 7341.00 ... 7351.00 7340.00 EB
49 eb2604 20250819 7380.00 ... 7380.00 7341.00 EB
50 eb2605 20250819 7391.00 ... 7393.00 7383.00 EB
51 eb2606 20250819 7393.00 ... 7393.00 7381.00 EB
52 eb2607 20250819 0.00 ... 7384.00 7384.00 EB
53 eg2508 20250819 0.00 ... 4407.00 4407.00 EG
54 eg2509 20250819 4355.00 ... 4363.00 4353.00 EG
55 eg2510 20250819 4368.00 ... 4388.00 4372.00 EG
56 eg2511 20250819 4388.00 ... 4392.00 4380.00 EG
57 eg2512 20250819 4386.00 ... 4399.00 4387.00 EG
58 eg2601 20250819 4404.00 ... 4406.00 4391.00 EG
59 eg2602 20250819 4428.00 ... 4426.00 4401.00 EG
60 eg2603 20250819 4372.00 ... 4433.00 4405.00 EG
61 eg2604 20250819 4444.00 ... 4453.00 4430.00 EG
62 eg2605 20250819 4441.00 ... 4452.00 4433.00 EG
63 eg2606 20250819 4451.00 ... 4459.00 4427.00 EG
64 eg2607 20250819 4497.00 ... 4497.00 4429.00 EG
65 fb2509 20250819 1258.00 ... 1256.50 1271.00 FB
66 fb2510 20250819 1296.00 ... 1294.00 1293.50 FB
67 fb2511 20250819 1286.50 ... 1287.50 1287.00 FB
68 fb2512 20250819 1284.00 ... 1288.50 1287.50 FB
69 fb2601 20250819 1284.50 ... 1288.50 1287.50 FB
70 fb2602 20250819 1288.00 ... 1290.00 1290.50 FB
71 fb2603 20250819 0.00 ... 1313.50 1313.50 FB
72 fb2604 20250819 0.00 ... 1310.50 1310.50 FB
73 fb2605 20250819 0.00 ... 1311.00 1311.00 FB
74 fb2606 20250819 0.00 ... 1349.50 1356.00 FB
75 fb2607 20250819 0.00 ... 1302.50 1302.50 FB
76 fb2608 20250819 0.00 ... 1302.50 1302.50 FB
77 i2509 20250819 790.50 ... 788.00 792.00 I
78 i2510 20250819 789.50 ... 786.50 791.00 I
79 i2511 20250819 784.50 ... 783.00 787.50 I
80 i2512 20250819 780.00 ... 777.50 783.50 I
81 i2601 20250819 773.00 ... 770.50 776.00 I
82 i2602 20250819 767.00 ... 766.00 772.50 I
83 i2603 20250819 763.00 ... 762.00 767.50 I
84 i2604 20250819 757.50 ... 756.00 763.50 I
85 i2605 20250819 751.50 ... 749.00 754.50 I
86 i2606 20250819 746.50 ... 744.50 751.00 I
87 i2607 20250819 743.50 ... 741.00 746.50 I
88 i2608 20250819 738.50 ... 737.00 742.50 I
89 j2509 20250819 1634.00 ... 1645.50 1645.50 J
90 j2510 20250819 1669.00 ... 1669.50 1669.00 J
91 j2511 20250819 1691.00 ... 1691.00 1692.50 J
92 j2512 20250819 1700.00 ... 1711.50 1701.00 J
93 j2601 20250819 1716.50 ... 1718.00 1725.00 J
94 j2602 20250819 1724.50 ... 1734.50 1755.50 J
95 j2603 20250819 0.00 ... 1785.00 1791.00 J
96 j2604 20250819 1795.50 ... 1795.50 1814.00 J
97 j2605 20250819 1806.00 ... 1808.00 1820.50 J
98 j2606 20250819 1808.00 ... 1808.00 1826.50 J
99 j2607 20250819 0.00 ... 1826.00 1826.00 J
100 j2608 20250819 0.00 ... 1826.00 1826.00 J
101 jd2508 20250819 2940.00 ... 2940.00 2900.00 JD
102 jd2509 20250819 3080.00 ... 3023.00 3116.00 JD
103 jd2510 20250819 3098.00 ... 3083.00 3134.00 JD
104 jd2511 20250819 3208.00 ... 3174.00 3241.00 JD
105 jd2512 20250819 3350.00 ... 3364.00 3407.00 JD
106 jd2601 20250819 3474.00 ... 3482.00 3526.00 JD
107 jd2602 20250819 3140.00 ... 3119.00 3174.00 JD
108 jd2603 20250819 3150.00 ... 3128.00 3178.00 JD
109 jd2604 20250819 3341.00 ... 3328.00 3352.00 JD
110 jd2605 20250819 3468.00 ... 3454.00 3478.00 JD
111 jd2606 20250819 3306.00 ... 3304.00 3313.00 JD
112 jd2607 20250819 3561.00 ... 3555.00 3559.00 JD
113 jm2509 20250819 1035.00 ... 1048.50 1062.00 JM
114 jm2510 20250819 1072.00 ... 1081.50 1097.50 JM
115 jm2511 20250819 1133.00 ... 1130.50 1144.00 JM
116 jm2512 20250819 1176.00 ... 1167.00 1182.50 JM
117 jm2601 20250819 1189.50 ... 1193.50 1217.50 JM
118 jm2602 20250819 1204.50 ... 1207.50 1223.50 JM
119 jm2603 20250819 1221.50 ... 1215.50 1245.50 JM
120 jm2604 20250819 1222.00 ... 1225.00 1262.00 JM
121 jm2605 20250819 1239.00 ... 1233.00 1264.50 JM
122 jm2606 20250819 1243.50 ... 1239.50 1273.00 JM
123 jm2607 20250819 1258.00 ... 1250.00 1278.50 JM
124 jm2608 20250819 1259.50 ... 1245.00 1281.00 JM
125 l2509 20250819 7266.00 ... 7284.00 7292.00 L
126 l2510 20250819 7310.00 ... 7298.00 7309.00 L
127 l2511 20250819 7328.00 ... 7320.00 7335.00 L
128 l2512 20250819 7336.00 ... 7327.00 7346.00 L
129 l2601 20250819 7334.00 ... 7320.00 7338.00 L
130 l2602 20250819 7324.00 ... 7312.00 7329.00 L
131 l2603 20250819 7323.00 ... 7311.00 7328.00 L
132 l2604 20250819 7320.00 ... 7327.00 7349.00 L
133 l2605 20250819 7311.00 ... 7303.00 7318.00 L
134 l2606 20250819 7312.00 ... 7303.00 7311.00 L
135 l2607 20250819 7302.00 ... 7302.00 7351.00 L
136 l2608 20250819 0.00 ... 7380.00 7380.00 L
137 lg2509 20250819 809.50 ... 811.00 816.00 LG
138 lg2511 20250819 821.50 ... 822.00 827.00 LG
139 lg2601 20250819 828.50 ... 829.00 831.00 LG
140 lg2603 20250819 831.50 ... 833.00 836.50 LG
141 lg2605 20250819 835.00 ... 834.00 838.00 LG
142 lg2607 20250819 831.00 ... 833.00 837.50 LG
143 lh2509 20250819 13640.00 ... 13740.00 13670.00 LH
144 lh2511 20250819 13855.00 ... 13875.00 13875.00 LH
145 lh2601 20250819 14140.00 ... 14180.00 14175.00 LH
146 lh2603 20250819 13290.00 ... 13320.00 13305.00 LH
147 lh2605 20250819 13795.00 ... 13800.00 13815.00 LH
148 lh2607 20250819 14215.00 ... 14250.00 14210.00 LH
149 m2509 20250819 3098.00 ... 3115.00 3093.00 M
150 m2511 20250819 3135.00 ... 3149.00 3123.00 M
151 m2512 20250819 3173.00 ... 3183.00 3171.00 M
152 m2601 20250819 3155.00 ... 3167.00 3147.00 M
153 m2603 20250819 3052.00 ... 3057.00 3042.00 M
154 m2605 20250819 2848.00 ... 2853.00 2837.00 M
155 m2607 20250819 2819.00 ... 2824.00 2805.00 M
156 m2608 20250819 2943.00 ... 2945.00 2926.00 M
157 p2509 20250819 9566.00 ... 9616.00 9552.00 P
158 p2510 20250819 9610.00 ... 9658.00 9568.00 P
159 p2511 20250819 9606.00 ... 9646.00 9586.00 P
160 p2512 20250819 9616.00 ... 9652.00 9586.00 P
161 p2601 20250819 9602.00 ... 9660.00 9606.00 P
162 p2602 20250819 9572.00 ... 9616.00 9552.00 P
163 p2603 20250819 9496.00 ... 9532.00 9470.00 P
164 p2604 20250819 9410.00 ... 9446.00 9380.00 P
165 p2605 20250819 9296.00 ... 9354.00 9292.00 P
166 p2606 20250819 9272.00 ... 9264.00 9172.00 P
167 p2607 20250819 9146.00 ... 9134.00 9070.00 P
168 p2608 20250819 9092.00 ... 9066.00 8962.00 P
169 pg2508 20250819 3888.00 ... 3888.00 3888.00 PG
170 pg2509 20250819 3855.00 ... 3860.00 3849.00 PG
171 pg2510 20250819 4327.00 ... 4314.00 4308.00 PG
172 pg2511 20250819 4249.00 ... 4240.00 4230.00 PG
173 pg2512 20250819 4194.00 ... 4181.00 4178.00 PG
174 pg2601 20250819 4140.00 ... 4132.00 4130.00 PG
175 pg2602 20250819 4090.00 ... 4075.00 4077.00 PG
176 pg2603 20250819 4002.00 ... 3982.00 3995.00 PG
177 pg2604 20250819 4278.00 ... 4276.00 4289.00 PG
178 pg2605 20250819 4185.00 ... 4185.00 4194.00 PG
179 pg2606 20250819 4122.00 ... 4118.00 4123.00 PG
180 pg2607 20250819 4065.00 ... 4063.00 4068.00 PG
181 pp2509 20250819 7031.00 ... 7002.00 7036.00 PP
182 pp2510 20250819 7002.00 ... 6995.00 7028.00 PP
183 pp2511 20250819 7025.00 ... 7008.00 7038.00 PP
184 pp2512 20250819 7044.00 ... 7028.00 7065.00 PP
185 pp2601 20250819 7046.00 ... 7028.00 7058.00 PP
186 pp2602 20250819 7024.00 ... 7010.00 7038.00 PP
187 pp2603 20250819 7019.00 ... 7007.00 7026.00 PP
188 pp2604 20250819 7026.00 ... 7026.00 7053.00 PP
189 pp2605 20250819 7049.00 ... 7034.00 7056.00 PP
190 pp2606 20250819 7009.00 ... 7004.00 7036.00 PP
191 pp2607 20250819 7027.00 ... 7026.00 7030.00 PP
192 pp2608 20250819 0.00 ... 7034.00 7054.00 PP
193 rr2509 20250819 3580.00 ... 3574.00 3574.00 RR
194 rr2510 20250819 3615.00 ... 3609.00 3613.00 RR
195 rr2511 20250819 3613.00 ... 3612.00 3613.00 RR
196 rr2512 20250819 3607.00 ... 3606.00 3609.00 RR
197 rr2601 20250819 3616.00 ... 3616.00 3619.00 RR
198 rr2602 20250819 0.00 ... 3608.00 3608.00 RR
199 rr2603 20250819 0.00 ... 3612.00 3612.00 RR
200 rr2604 20250819 3613.00 ... 3613.00 3619.00 RR
201 rr2605 20250819 3610.00 ... 3610.00 3619.00 RR
202 rr2606 20250819 3606.00 ... 3606.00 3625.00 RR
203 rr2607 20250819 0.00 ... 3625.00 3625.00 RR
204 rr2608 20250819 0.00 ... 3625.00 3625.00 RR
205 v2509 20250819 4920.00 ... 4880.00 4937.00 V
206 v2510 20250819 4959.00 ... 4918.00 4968.00 V
207 v2511 20250819 4990.00 ... 4947.00 5009.00 V
208 v2512 20250819 5026.00 ... 4984.00 5042.00 V
209 v2601 20250819 5057.00 ... 5019.00 5069.00 V
210 v2602 20250819 5091.00 ... 5057.00 5097.00 V
211 v2603 20250819 5126.00 ... 5086.00 5132.00 V
212 v2604 20250819 5330.00 ... 5327.00 5340.00 V
213 v2605 20250819 5372.00 ... 5324.00 5368.00 V
214 v2606 20250819 5387.00 ... 5377.00 5390.00 V
215 v2607 20250819 5422.00 ... 5390.00 5428.00 V
216 v2608 20250819 5454.00 ... 5413.00 5457.00 V
217 y2509 20250819 8546.00 ... 8580.00 8596.00 Y
218 y2511 20250819 8566.00 ... 8594.00 8600.00 Y
219 y2512 20250819 8574.00 ... 8592.00 8600.00 Y
220 y2601 20250819 8544.00 ... 8552.00 8562.00 Y
221 y2603 20250819 8436.00 ... 8490.00 8448.00 Y
222 y2605 20250819 8146.00 ... 8216.00 8138.00 Y
223 y2607 20250819 8130.00 ... 8166.00 8104.00 Y
224 y2608 20250819 8216.00 ... 8226.00 8140.00 Y
[225 rows x 12 columns]
2025-08-20 11:22:35,004 - future_1d - INFO - ak.get_dce_daily('2025-08-19') done
symbol date open ... settle pre_settle variety
0 SC2509 20250819 481.2 ... 479.8 483 SC
1 SC2510 20250819 487.9 ... 485.1 485.2 SC
2 SC2511 20250819 482.6 ... 482.4 482.3 SC
3 SC2512 20250819 481 ... 479.1 479.9 SC
4 SC2601 20250819 477.6 ... 478.1 478.5 SC
5 SC2602 20250819 477 ... 476.1 477.1 SC
6 SC2603 20250819 475.9 ... 476.4 476 SC
7 SC2604 20250819 474.2 ... 476.4 475.1 SC
8 SC2605 20250819 473.4 ... 476.7 473.1 SC
9 SC2606 20250819 472 ... 475 472.8 SC
10 SC2607 20250819 469.1 ... 472.4 470.7 SC
11 SC2608 20250819 468.5 ... 471.2 470.8 SC
12 SC2609 20250819 466 ... 469 468.2 SC
13 SC2612 20250819 ... 462 462 SC
14 SC2703 20250819 ... 464.2 464.2 SC
15 SC2706 20250819 460.2 ... 461.7 458.5 SC
16 SC2709 20250819 458.9 ... 459.2 458 SC
17 SC2712 20250819 ... 459 459 SC
18 SC2803 20250819 ... 456 456 SC
19 SC2806 20250819 450.2 ... 452 451.9 SC
21 LU2509 20250819 3474 ... 3447 3444 LU
22 LU2510 20250819 3478 ... 3458 3459 LU
23 LU2511 20250819 3462 ... 3449 3451 LU
24 LU2512 20250819 3450 ... 3427 3437 LU
25 LU2601 20250819 3443 ... 3412 3422 LU
26 LU2602 20250819 3402 ... 3400 3411 LU
27 LU2603 20250819 3398 ... 3389 3403 LU
28 LU2604 20250819 ... 3395 3395 LU
29 LU2605 20250819 3386 ... 3382 3389 LU
30 LU2606 20250819 ... 3383 3383 LU
31 LU2607 20250819 3376 ... 3377 3390 LU
32 LU2608 20250819 3362 ... 3375 3389 LU
34 NR2509 20250819 12570 ... 12630 12590 NR
35 NR2510 20250819 12620 ... 12700 12660 NR
36 NR2511 20250819 12670 ... 12725 12695 NR
37 NR2512 20250819 12720 ... 12760 12730 NR
38 NR2601 20250819 12755 ... 12800 12775 NR
39 NR2602 20250819 12830 ... 12770 12740 NR
40 NR2603 20250819 12815 ... 12820 12745 NR
41 NR2604 20250819 12830 ... 12815 12745 NR
42 NR2605 20250819 12960 ... 12905 12815 NR
43 NR2606 20250819 ... 12760 12760 NR
44 NR2607 20250819 ... 12900 12900 NR
45 NR2608 20250819 ... 12830 12830 NR
47 BC2509 20250819 69910 ... 69970 70180 BC
48 BC2510 20250819 70030 ... 70040 70250 BC
49 BC2511 20250819 ... 70230 70620 BC
50 BC2512 20250819 70030 ... 70030 70300 BC
51 BC2601 20250819 ... 70250 70250 BC
52 BC2602 20250819 ... 70710 70710 BC
53 BC2603 20250819 70290 ... 70290 71120 BC
54 BC2604 20250819 ... 70350 70350 BC
55 BC2605 20250819 69800 ... 69400 70750 BC
56 BC2606 20250819 ... 69790 69790 BC
57 BC2607 20250819 ... 69370 69370 BC
58 BC2608 20250819 ... 69370 69370 BC
60 EC2508 20250819 2126 ... 2120.1 2085.9 EC
61 EC2510 20250819 1388.5 ... 1373.2 1381.4 EC
62 EC2512 20250819 1780 ... 1769.7 1782.3 EC
63 EC2602 20250819 1545 ... 1531.1 1539 EC
64 EC2604 20250819 1320 ... 1325.8 1339.8 EC
65 EC2606 20250819 1488.7 ... 1485.8 1496.5 EC
68 SC_TAS2509 20250819 ... SC_TAS
69 SC_TAS2510 20250819 ... SC_TAS
70 SC_TAS2511 20250819 ... SC_TAS
71 SC_TAS2512 20250819 ... SC_TAS
[66 rows x 12 columns]
2025-08-20 11:22:35,074 - future_1d - INFO - ak.get_ine_daily('2025-08-19') done
symbol date open ... settle pre_settle variety
0 IC2509 20250819 6600.000 ... 6602.800 6608.400 IC
1 IC2510 20250819 6571.000 ... 6560.200 6568.600 IC
2 IC2512 20250819 6488.800 ... 6475.000 6488.800 IC
3 IC2603 20250819 6359.800 ... 6346.800 6367.800 IC
4 IF2509 20250819 4244.000 ... 4221.000 4237.400 IF
5 IF2510 20250819 4235.400 ... 4214.600 4233.800 IF
6 IF2512 20250819 4225.000 ... 4203.400 4220.200 IF
7 IF2603 20250819 4204.200 ... 4183.600 4201.400 IF
8 IH2509 20250819 2850.000 ... 2820.800 2849.200 IH
9 IH2510 20250819 2855.000 ... 2820.600 2849.000 IH
10 IH2512 20250819 2858.800 ... 2824.200 2853.200 IH
11 IH2603 20250819 2861.000 ... 2826.600 2854.200 IH
12 IM2509 20250819 7184.400 ... 7187.400 7179.800 IM
13 IM2510 20250819 7144.400 ... 7134.600 7138.200 IM
14 IM2512 20250819 7022.200 ... 7021.200 7025.800 IM
15 IM2603 20250819 6880.000 ... 6859.000 6874.400 IM
16 T2509 20250819 108.050 ... 108.050 108.020 T
17 T2512 20250819 107.970 ... 107.935 107.890 T
18 T2603 20250819 107.705 ... 107.730 107.655 T
19 TF2509 20250819 105.500 ... 105.535 105.465 TF
20 TF2512 20250819 105.415 ... 105.470 105.410 TF
21 TF2603 20250819 105.395 ... 105.430 105.385 TF
22 TL2509 20250819 116.230 ... 116.460 116.270 TL
23 TL2512 20250819 115.800 ... 115.980 115.760 TL
24 TL2603 20250819 115.240 ... 115.630 115.460 TL
25 TS2509 20250819 102.314 ... 102.328 102.302 TS
26 TS2512 20250819 102.330 ... 102.338 102.334 TS
27 TS2603 20250819 102.326 ... 102.330 102.318 TS
[28 rows x 12 columns]
2025-08-20 11:22:35,293 - future_1d - INFO - ak.get_cffex_daily('2025-08-19') done
symbol date open ... settle pre_settle variety
0 PS2509 20250819 51985.0 ... 52100.0 52495.0 PS
1 PS2510 20250819 52500.0 ... 52225.0 52595.0 PS
2 PS2511 20250819 52275.0 ... 52145.0 52540.0 PS
3 PS2512 20250819 54805.0 ... 54490.0 54905.0 PS
4 PS2601 20250819 54815.0 ... 54565.0 55035.0 PS
5 PS2602 20250819 54915.0 ... 54720.0 55530.0 PS
6 PS2603 20250819 54985.0 ... 54800.0 55775.0 PS
7 PS2604 20250819 55290.0 ... 54965.0 55975.0 PS
8 PS2605 20250819 55220.0 ... 54995.0 55475.0 PS
9 PS2606 20250819 57975.0 ... 57710.0 58225.0 PS
10 PS2607 20250819 58115.0 ... 57915.0 58455.0 PS
11 PS2608 20250819 58140.0 ... 58185.0 58360.0 PS
13 SI2509 20250819 8600.0 ... 8610.0 8720.0 SI
14 SI2510 20250819 8600.0 ... 8635.0 8715.0 SI
15 SI2511 20250819 8615.0 ... 8640.0 8735.0 SI
16 SI2512 20250819 9055.0 ... 8990.0 9085.0 SI
17 SI2601 20250819 8955.0 ... 8990.0 9090.0 SI
18 SI2602 20250819 8960.0 ... 9000.0 9065.0 SI
19 SI2603 20250819 8970.0 ... 9015.0 9105.0 SI
20 SI2604 20250819 9000.0 ... 9025.0 9125.0 SI
21 SI2605 20250819 9030.0 ... 9040.0 9165.0 SI
22 SI2606 20250819 9025.0 ... 9030.0 9175.0 SI
23 SI2607 20250819 9045.0 ... 9060.0 9160.0 SI
24 SI2608 20250819 9050.0 ... 9070.0 9210.0 SI
27 LC2509 20250819 89300.0 ... 88080.0 89040.0 LC
28 LC2510 20250819 89200.0 ... 88040.0 89160.0 LC
29 LC2511 20250819 89500.0 ... 88020.0 89140.0 LC
30 LC2512 20250819 90000.0 ... 87900.0 89080.0 LC
31 LC2601 20250819 88640.0 ... 87640.0 88800.0 LC
32 LC2602 20250819 89160.0 ... 87200.0 88480.0 LC
33 LC2603 20250819 88000.0 ... 86820.0 87980.0 LC
34 LC2604 20250819 90020.0 ... 87080.0 87760.0 LC
35 LC2605 20250819 87300.0 ... 86280.0 87300.0 LC
36 LC2606 20250819 89240.0 ... 87120.0 86900.0 LC
37 LC2607 20250819 87040.0 ... 85660.0 86620.0 LC
38 LC2608 20250819 86400.0 ... 85680.0 86480.0 LC
[36 rows x 12 columns]
2025-08-20 11:22:35,498 - future_1d - INFO - ak.get_gfex_daily('2025-08-19') done
index symbol date ... settle pre_settle variety
0 0 CU2509 20250819 ... 78880 79020 CU
1 1 CU2510 20250819 ... 78850 79020 CU
2 2 CU2511 20250819 ... 78840 79000 CU
3 3 CU2512 20250819 ... 78840 78960 CU
4 4 CU2601 20250819 ... 78820 78970 CU
5 5 CU2602 20250819 ... 78840 78930 CU
6 6 CU2603 20250819 ... 78850 78940 CU
7 7 CU2604 20250819 ... 78880 78960 CU
8 8 CU2605 20250819 ... 78900 78980 CU
9 9 CU2606 20250819 ... 78880 78990 CU
10 10 CU2607 20250819 ... 78890 79000 CU
11 11 CU2608 20250819 ... 78950 78930 CU
12 12 BC2509 20250819 ... 69970 70180 BC
13 13 BC2510 20250819 ... 70040 70250 BC
14 14 BC2511 20250819 ... 70230 70620 BC
15 15 BC2512 20250819 ... 70030 70300 BC
16 16 BC2601 20250819 ... 70250 70250 BC
17 17 BC2602 20250819 ... 70710 70710 BC
18 18 BC2603 20250819 ... 70290 71120 BC
19 19 BC2604 20250819 ... 70350 70350 BC
20 20 BC2605 20250819 ... 69400 70750 BC
21 21 BC2606 20250819 ... 69790 69790 BC
22 22 BC2607 20250819 ... 69370 69370 BC
23 23 BC2608 20250819 ... 69370 69370 BC
24 24 AL2509 20250819 ... 20590 20610 AL
25 25 AL2510 20250819 ... 20575 20585 AL
26 26 AL2511 20250819 ... 20540 20540 AL
27 27 AL2512 20250819 ... 20510 20510 AL
28 28 AL2601 20250819 ... 20490 20485 AL
29 29 AL2602 20250819 ... 20485 20475 AL
30 30 AL2603 20250819 ... 20510 20495 AL
31 31 AL2604 20250819 ... 20530 20530 AL
32 32 AL2605 20250819 ... 20550 20560 AL
33 33 AL2606 20250819 ... 20565 20555 AL
34 34 AL2607 20250819 ... 20585 20600 AL
35 35 AL2608 20250819 ... 20570 20570 AL
36 36 ZN2509 20250819 ... 22245 22375 ZN
37 37 ZN2510 20250819 ... 22245 22395 ZN
38 38 ZN2511 20250819 ... 22245 22400 ZN
39 39 ZN2512 20250819 ... 22245 22390 ZN
40 40 ZN2601 20250819 ... 22220 22380 ZN
41 41 ZN2602 20250819 ... 22235 22380 ZN
42 42 ZN2603 20250819 ... 22240 22420 ZN
43 43 ZN2604 20250819 ... 22235 22360 ZN
44 44 ZN2605 20250819 ... 22225 22395 ZN
45 45 ZN2606 20250819 ... 22200 22365 ZN
46 46 ZN2607 20250819 ... 22215 22360 ZN
47 47 ZN2608 20250819 ... 22225 22355 ZN
48 48 PB2509 20250819 ... 16810 16790 PB
49 49 PB2510 20250819 ... 16815 16805 PB
50 50 PB2511 20250819 ... 16845 16830 PB
51 51 PB2512 20250819 ... 16870 16865 PB
52 52 PB2601 20250819 ... 16895 16870 PB
53 53 PB2602 20250819 ... 16915 16875 PB
54 54 PB2603 20250819 ... 16930 16930 PB
55 55 PB2604 20250819 ... 16970 16960 PB
56 56 PB2605 20250819 ... 16965 16980 PB
57 57 PB2606 20250819 ... 16985 16985 PB
58 58 PB2607 20250819 ... 17060 17060 PB
59 59 PB2608 20250819 ... 17015 17015 PB
60 60 NI2509 20250819 ... 120510 120780 NI
61 61 NI2510 20250819 ... 120610 120850 NI
62 62 NI2511 20250819 ... 120870 120980 NI
63 63 NI2512 20250819 ... 121060 121230 NI
64 64 NI2601 20250819 ... 121380 121610 NI
65 65 NI2602 20250819 ... 121730 121950 NI
66 66 NI2603 20250819 ... 122030 122260 NI
67 67 NI2604 20250819 ... 122330 122660 NI
68 68 NI2605 20250819 ... 122620 122770 NI
69 69 NI2606 20250819 ... 122840 123070 NI
70 70 NI2607 20250819 ... 123000 123370 NI
71 71 NI2608 20250819 ... 123090 123650 NI
72 72 SN2509 20250819 ... 266510 266860 SN
73 73 SN2510 20250819 ... 266810 267150 SN
74 74 SN2511 20250819 ... 267200 267260 SN
75 75 SN2512 20250819 ... 267290 267220 SN
76 76 SN2601 20250819 ... 267310 267430 SN
77 77 SN2602 20250819 ... 267470 267480 SN
78 78 SN2603 20250819 ... 267820 267990 SN
79 79 SN2604 20250819 ... 268820 268640 SN
80 80 SN2605 20250819 ... 269170 268430 SN
81 81 SN2606 20250819 ... 269000 269000 SN
82 82 SN2607 20250819 ... 269440 269320 SN
83 83 SN2608 20250819 ... 269500 269500 SN
84 84 AO2509 20250819 ... 3132 3174 AO
85 85 AO2510 20250819 ... 3128 3173 AO
86 86 AO2511 20250819 ... 3130 3176 AO
87 87 AO2512 20250819 ... 3134 3183 AO
88 88 AO2601 20250819 ... 3146 3199 AO
89 89 AO2602 20250819 ... 3138 3189 AO
90 90 AO2603 20250819 ... 3137 3190 AO
91 91 AO2604 20250819 ... 3150 3201 AO
92 92 AO2605 20250819 ... 3146 3197 AO
93 93 AO2606 20250819 ... 3144 3203 AO
94 94 AO2607 20250819 ... 3158 3208 AO
95 95 AO2608 20250819 ... 3163 3175 AO
96 96 AD2511 20250819 ... 20085 20060 AD
97 97 AD2512 20250819 ... 20060 20040 AD
98 98 AD2601 20250819 ... 20040 19990 AD
99 99 AD2602 20250819 ... 19915 19915 AD
100 100 AD2603 20250819 ... 20050 20050 AD
101 101 AD2604 20250819 ... 19865 19865 AD
102 102 AD2605 20250819 ... 19860 19860 AD
103 103 AD2606 20250819 ... 19720 19720 AD
104 104 AD2607 20250819 ... 19925 19925 AD
105 105 AD2608 20250819 ... 19925 19925 AD
106 106 AU2509 20250819 ... 773.86 774.94 AU
107 107 AU2510 20250819 ... 775.36 776.06 AU
108 108 AU2511 20250819 ... 777.26 777.88 AU
109 109 AU2512 20250819 ... 777.44 778.48 AU
110 110 AU2602 20250819 ... 779.62 780.44 AU
111 111 AU2604 20250819 ... 781.66 782.52 AU
112 112 AU2606 20250819 ... 783.8 785 AU
113 113 AU2608 20250819 ... 785.72 787.2 AU
114 114 AG2509 20250819 ... 9194 9203 AG
115 115 AG2510 20250819 ... 9213 9210 AG
116 116 AG2511 20250819 ... 9223 9220 AG
117 117 AG2512 20250819 ... 9232 9232 AG
118 118 AG2601 20250819 ... 9245 9243 AG
119 119 AG2602 20250819 ... 9260 9256 AG
120 120 AG2603 20250819 ... 9270 9275 AG
121 121 AG2604 20250819 ... 9278 9282 AG
122 122 AG2605 20250819 ... 9292 9294 AG
123 123 AG2606 20250819 ... 9304 9306 AG
124 124 AG2607 20250819 ... 9313 9320 AG
125 125 AG2608 20250819 ... 9336 9350 AG
126 126 RB2509 20250819 ... 3116 3143 RB
127 127 RB2510 20250819 ... 3144 3173 RB
128 128 RB2511 20250819 ... 3158 3190 RB
129 129 RB2512 20250819 ... 3203 3235 RB
130 130 RB2601 20250819 ... 3224 3249 RB
131 131 RB2602 20250819 ... 3223 3243 RB
132 132 RB2603 20250819 ... 3238 3266 RB
133 133 RB2604 20250819 ... 3254 3283 RB
134 134 RB2605 20250819 ... 3273 3295 RB
135 135 RB2606 20250819 ... 3281 3317 RB
136 136 RB2607 20250819 ... 3290 3310 RB
137 137 RB2608 20250819 ... 3298 3322 RB
138 138 WR2509 20250819 ... 3342 3342 WR
139 139 WR2510 20250819 ... 3373 3392 WR
140 140 WR2511 20250819 ... 3349 3421 WR
141 141 WR2512 20250819 ... 3471 3471 WR
142 142 WR2601 20250819 ... 3372 3372 WR
143 143 WR2602 20250819 ... 3426 3426 WR
144 144 WR2603 20250819 ... 3438 3438 WR
145 145 WR2604 20250819 ... 3460 3460 WR
146 146 WR2605 20250819 ... 3455 3455 WR
147 147 WR2606 20250819 ... 3446 3446 WR
148 148 WR2607 20250819 ... 3522 3524 WR
149 149 WR2608 20250819 ... 3504 3524 WR
150 150 HC2509 20250819 ... 3444 3441 HC
151 151 HC2510 20250819 ... 3423 3429 HC
152 152 HC2511 20250819 ... 3418 3425 HC
153 153 HC2512 20250819 ... 3421 3435 HC
154 154 HC2601 20250819 ... 3413 3423 HC
155 155 HC2602 20250819 ... 3408 3422 HC
156 156 HC2603 20250819 ... 3413 3423 HC
157 157 HC2604 20250819 ... 3426 3429 HC
158 158 HC2605 20250819 ... 3415 3430 HC
159 159 HC2606 20250819 ... 3423 3452 HC
160 160 HC2607 20250819 ... 3430 3446 HC
161 161 HC2608 20250819 ... 3430 3448 HC
162 162 SS2509 20250819 ... 12865 12950 SS
163 163 SS2510 20250819 ... 12925 13025 SS
164 164 SS2511 20250819 ... 12980 13085 SS
165 165 SS2512 20250819 ... 13025 13130 SS
166 166 SS2601 20250819 ... 13110 13205 SS
167 167 SS2602 20250819 ... 13120 13195 SS
168 168 SS2603 20250819 ... 13190 13255 SS
169 169 SS2604 20250819 ... 13260 13345 SS
170 170 SS2605 20250819 ... 13305 13385 SS
171 171 SS2606 20250819 ... 13295 13460 SS
172 172 SS2607 20250819 ... 13455 13495 SS
173 173 SS2608 20250819 ... 13465 13510 SS
174 174 SC2509 20250819 ... 479.8 483 SC
175 175 SC2510 20250819 ... 485.1 485.2 SC
176 176 SC2511 20250819 ... 482.4 482.3 SC
177 177 SC2512 20250819 ... 479.1 479.9 SC
178 178 SC2601 20250819 ... 478.1 478.5 SC
179 179 SC2602 20250819 ... 476.1 477.1 SC
180 180 SC2603 20250819 ... 476.4 476 SC
181 181 SC2604 20250819 ... 476.4 475.1 SC
182 182 SC2605 20250819 ... 476.7 473.1 SC
183 183 SC2606 20250819 ... 475 472.8 SC
184 184 SC2607 20250819 ... 472.4 470.7 SC
185 185 SC2608 20250819 ... 471.2 470.8 SC
186 186 SC2609 20250819 ... 469 468.2 SC
187 187 SC2612 20250819 ... 462 462 SC
188 188 SC2703 20250819 ... 464.2 464.2 SC
189 189 SC2706 20250819 ... 461.7 458.5 SC
190 190 SC2709 20250819 ... 459.2 458 SC
191 191 SC2712 20250819 ... 459 459 SC
192 192 SC2803 20250819 ... 456 456 SC
193 193 SC2806 20250819 ... 452 451.9 SC
194 194 LU2509 20250819 ... 3447 3444 LU
195 195 LU2510 20250819 ... 3458 3459 LU
196 196 LU2511 20250819 ... 3449 3451 LU
197 197 LU2512 20250819 ... 3427 3437 LU
198 198 LU2601 20250819 ... 3412 3422 LU
199 199 LU2602 20250819 ... 3400 3411 LU
200 200 LU2603 20250819 ... 3389 3403 LU
201 201 LU2604 20250819 ... 3395 3395 LU
202 202 LU2605 20250819 ... 3382 3389 LU
203 203 LU2606 20250819 ... 3383 3383 LU
204 204 LU2607 20250819 ... 3377 3390 LU
205 205 LU2608 20250819 ... 3375 3389 LU
206 206 FU2509 20250819 ... 2680 2700 FU
207 207 FU2510 20250819 ... 2705 2722 FU
208 208 FU2511 20250819 ... 2712 2724 FU
209 209 FU2512 20250819 ... 2715 2727 FU
210 210 FU2601 20250819 ... 2719 2731 FU
211 211 FU2602 20250819 ... 2719 2730 FU
212 212 FU2603 20250819 ... 2721 2732 FU
213 213 FU2604 20250819 ... 2724 2733 FU
214 214 FU2605 20250819 ... 2719 2727 FU
215 215 FU2606 20250819 ... 2715 2726 FU
216 216 FU2607 20250819 ... 2698 2707 FU
217 217 FU2608 20250819 ... 2692 2703 FU
218 218 BU2509 20250819 ... 3482 3504 BU
219 219 BU2510 20250819 ... 3450 3474 BU
220 220 BU2511 20250819 ... 3408 3428 BU
221 221 BU2512 20250819 ... 3356 3375 BU
222 222 BU2601 20250819 ... 3321 3338 BU
223 223 BU2602 20250819 ... 3319 3331 BU
224 224 BU2603 20250819 ... 3321 3328 BU
225 225 BU2604 20250819 ... 3316 3320 BU
226 226 BU2605 20250819 ... 3318 3319 BU
227 227 BU2606 20250819 ... 3310 3322 BU
228 228 BU2607 20250819 ... 3309 3309 BU
229 229 BU2608 20250819 ... 3316 3316 BU
230 230 BU2609 20250819 ... 3303 3312 BU
231 231 BU2612 20250819 ... 3272 3290 BU
232 232 BU2703 20250819 ... 3279 3296 BU
233 233 BU2706 20250819 ... 3289 3307 BU
234 234 BR2509 20250819 ... 11860 11800 BR
235 235 BR2510 20250819 ... 11865 11810 BR
236 236 BR2511 20250819 ... 11860 11810 BR
237 237 BR2512 20250819 ... 11865 11830 BR
238 238 BR2601 20250819 ... 11890 11835 BR
239 239 BR2602 20250819 ... 11960 11750 BR
240 240 BR2603 20250819 ... 11990 11785 BR
241 241 BR2604 20250819 ... 11955 11880 BR
242 242 BR2605 20250819 ... 12005 11880 BR
243 243 BR2606 20250819 ... 12040 11915 BR
244 244 BR2607 20250819 ... 12080 11950 BR
245 245 BR2608 20250819 ... 11925 11925 BR
246 246 RU2509 20250819 ... 14860 14795 RU
247 247 RU2510 20250819 ... 14860 14805 RU
248 248 RU2511 20250819 ... 14875 14815 RU
249 249 RU2601 20250819 ... 15880 15825 RU
250 250 RU2603 20250819 ... 15905 15850 RU
251 251 RU2604 20250819 ... 15925 15850 RU
252 252 RU2605 20250819 ... 15960 15910 RU
253 253 RU2606 20250819 ... 16035 15975 RU
254 254 RU2607 20250819 ... 16055 15985 RU
255 255 RU2608 20250819 ... 16010 16025 RU
256 256 NR2509 20250819 ... 12630 12590 NR
257 257 NR2510 20250819 ... 12700 12660 NR
258 258 NR2511 20250819 ... 12725 12695 NR
259 259 NR2512 20250819 ... 12760 12730 NR
260 260 NR2601 20250819 ... 12800 12775 NR
261 261 NR2602 20250819 ... 12770 12740 NR
262 262 NR2603 20250819 ... 12820 12745 NR
263 263 NR2604 20250819 ... 12815 12745 NR
264 264 NR2605 20250819 ... 12905 12815 NR
265 265 NR2606 20250819 ... 12760 12760 NR
266 266 NR2607 20250819 ... 12900 12900 NR
267 267 NR2608 20250819 ... 12830 12830 NR
268 268 SP2509 20250819 ... 5168 5226 SP
269 269 SP2510 20250819 ... 5176 5260 SP
270 270 SP2511 20250819 ... 5220 5276 SP
271 271 SP2512 20250819 ... 5210 5270 SP
272 272 SP2601 20250819 ... 5442 5496 SP
273 273 SP2602 20250819 ... 5392 5462 SP
274 274 SP2603 20250819 ... 5386 5460 SP
275 275 SP2604 20250819 ... 5410 5462 SP
276 276 SP2605 20250819 ... 5400 5466 SP
277 277 SP2606 20250819 ... 5406 5474 SP
278 278 SP2607 20250819 ... 5410 5458 SP
279 279 SP2608 20250819 ... 5470 5484 SP
280 280 EC2508 20250819 ... 2120.1 2085.9 EC
281 281 EC2510 20250819 ... 1373.2 1381.4 EC
282 282 EC2512 20250819 ... 1769.7 1782.3 EC
283 283 EC2602 20250819 ... 1531.1 1539 EC
284 284 EC2604 20250819 ... 1325.8 1339.8 EC
285 285 EC2606 20250819 ... 1485.8 1496.5 EC
286 286 SC_TAS2509 20250819 ... SC_TAS
287 287 SC_TAS2510 20250819 ... SC_TAS
288 288 SC_TAS2511 20250819 ... SC_TAS
289 289 SC_TAS2512 20250819 ... SC_TAS
[290 rows x 13 columns]
2025-08-20 11:22:35,595 - future_1d - INFO - ak.get_shfe_daily('2025-08-19') done
2025-08-20 11:22:37,357 - future_1d - INFO - save future_daily 2025-08-19 completed
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
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 1070, in save_future_daily
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', 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 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
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 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
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 1070, in save_future_daily
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', 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 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
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 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
ConnectionResetError: [Errno 104] Connection reset by peer
Traceback (most recent call last):
During handling of the above exception, another exception occurred:
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
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
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
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 1070, in save_future_daily
client.save_future_daily(check=True, check_last=7)
File "/root/project/future_1d/future1d_request.py", line 1070, in save_future_daily
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', 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
df_log.to_sql('future_log', 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 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 843, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self.connection._commit_impl()
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
self._handle_dbapi_exception(e, None, None, None, None)
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 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most recent call last):
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 736, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
data = self._rfile.read(num_bytes)
File "/usr/local/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
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 1070, in save_future_daily
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
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 1070, in save_future_daily
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
self.save_log(date=td, status='completed', category=tablebase.__tablename__)
File "/root/project/future_1d/future1d_request.py", line 429, in save_log
df_log.to_sql('future_log', 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
df_log.to_sql('future_log', 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 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
return sql.to_sql(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 843, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1657, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
self.exit_stack.close()
File "/usr/local/lib/python3.10/contextlib.py", line 584, in close
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
self.__exit__(None, None, None)
File "/usr/local/lib/python3.10/contextlib.py", line 576, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_details[1]
File "/usr/local/lib/python3.10/contextlib.py", line 561, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
if cb(*exc_details):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2632, in commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._do_commit()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2737, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self._connection_commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2708, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
self.connection._commit_impl()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1147, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
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 1145, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1145, in _commit_impl
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 714, in do_commit
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
dbapi_connection.commit()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 472, in commit
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
self._read_ok_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 442, in _read_ok_packet
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
pkt = self._read_packet()
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 696, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/site-packages/pymysql/connections.py", line 742, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)