=========================================================================
2025-05-09 16:25:40 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-05-09 16:25:42,719 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-09 16:25:43,045 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-30, end_day=2025-04-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-30 C 2252.86 ... 0.049777 c2507 c
1 2025-04-30 A 4245.0 ... -0.014841 a2507 a
2 2025-04-30 M 3476.67 ... -0.152925 m2509 m
3 2025-04-30 Y 8126.0 ... -0.040364 y2509 y
4 2025-04-30 P 8760.0 ... -0.074658 p2509 p
5 2025-04-30 JD 3375.0 ... -0.125333 jd2506 jd
6 2025-04-30 L 7553.33 ... -0.059885 l2509 l
7 2025-04-30 V 4679.0 ... 0.053644 v2509 v
8 2025-04-30 PP 7481.67 ... -0.056093 pp2509 pp
9 2025-04-30 I 778.11 ... -0.094601 i2509 i
10 2025-04-30 EG 4331.67 ... -0.035707 eg2509 eg
11 2025-04-30 EB 7680.0 ... -0.082292 eb2506 eb
12 2025-04-30 PG 4980.0 ... -0.117871 pg2506 pg
13 2025-04-30 LH 14830.0 ... -0.061699 lh2509 lh
14 2025-04-30 CF 14208.83 ... -0.100911 CF509 CF
15 2025-04-30 SR 6160.0 ... -0.043994 SR509 SR
16 2025-04-30 TA 4584.38 ... -0.034111 TA509 TA
17 2025-04-30 OI 9378.33 ... -0.011338 OI509 OI
18 2025-04-30 MA 2440.0 ... -0.070902 MA509 MA
19 2025-04-30 FG 1246.4 ... -0.126284 FG509 FG
20 2025-04-30 RM 2531.67 ... 0.012375 RM509 RM
21 2025-04-30 SF 5548.57 ... 0.024048 SF507 SF
22 2025-04-30 SM 5640.0 ... 0.01383 SM509 SM
23 2025-04-30 CY 23775.0 ... -0.209674 CY507 CY
24 2025-04-30 UR 1875.0 ... -0.016 UR509 UR
25 2025-04-30 SA 1502.5 ... -0.097504 SA509 SA
26 2025-04-30 PF 6351.46 ... -0.037072 PF507 PF
27 2025-04-30 PX 6800.0 ... -0.087647 PX509 PX
28 2025-04-30 SH 807.0 ... 2.042131 SH509 SH
29 2025-04-30 CU 77996.67 ... -0.026753 cu2503 cu
30 2025-04-30 AL 20073.33 ... 0.008054 al2503 al
31 2025-04-30 ZN 22904.0 ... 0.019473 zn2503 zn
32 2025-04-30 PB 16812.5 ... 0.016506 pb2503 pb
33 2025-04-30 NI 125175.0 ... 0.001318 ni2503 ni
34 2025-04-30 SN 261175.0 ... -0.014875 sn2503 sn
35 2025-04-30 AU 780.65 ... -0.139435 au2504 au
36 2025-04-30 AG 8204.33 ... -0.014301 ag2504 ag
37 2025-04-30 RB 3183.22 ... 0.049252 rb2505 rb
38 2025-04-30 WR 3377.5 ... 0.057291 wr2505 wr
39 2025-04-30 HC 3276.67 ... 0.048015 hc2505 hc
40 2025-04-30 FU 5462.5 ... -0.371167 fu2505 fu
41 2025-04-30 BU 3647.5 ... 0.033859 bu2503 bu
42 2025-04-30 RU 14308.33 ... 0.200699 ru2505 ru
43 2025-04-30 SP 6250.0 ... -0.01312 sp2503 sp
44 2025-04-30 SS 13050.0 ... 0.027203 ss2503 ss
45 2025-04-30 BR 11950.0 ... 0.2 br2504 br
46 2025-04-30 SI 9880.0 ... -0.135121 SI2506 si
47 2025-04-30 LC 68933.33 ... -0.038781 LC2507 lc
[48 rows x 15 columns]
2025-05-09 16:25:43,214 - future_1d - INFO - save future_spot 2025-04-30 completed
2025-05-09 16:25:50,021 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-06, end_day=2025-05-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-06 C 2272.86 ... 0.039659 c2507 c
1 2025-05-06 A 4230.0 ... -0.013002 a2507 a
2 2025-05-06 M 3270.0 ... -0.106728 m2509 m
3 2025-05-06 Y 8056.0 ... -0.037736 y2509 y
4 2025-05-06 P 8678.0 ... -0.079972 p2509 p
5 2025-05-06 JD 3375.0 ... -0.141037 jd2506 jd
6 2025-05-06 L 7500.0 ... -0.065333 l2509 l
7 2025-05-06 V 4653.0 ... 0.05072 v2509 v
8 2025-05-06 PP 7481.67 ... -0.063712 pp2509 pp
9 2025-05-06 I 781.44 ... -0.09718 i2509 i
10 2025-05-06 EG 4331.67 ... -0.045403 eg2509 eg
11 2025-05-06 EB 7650.0 ... -0.089542 eb2506 eb
12 2025-05-06 PG 4967.5 ... -0.114444 pg2506 pg
13 2025-05-06 LH 14820.0 ... -0.060729 lh2509 lh
14 2025-05-06 CF 14138.67 ... -0.095742 CF509 CF
15 2025-05-06 SR 6156.67 ... -0.043152 SR509 SR
16 2025-05-06 TA 4529.17 ... -0.037793 TA509 TA
17 2025-05-06 OI 9330.0 ... -0.009432 OI509 OI
18 2025-05-06 MA 2428.75 ... -0.07895 MA509 MA
19 2025-05-06 FG 1214.4 ... -0.116436 FG509 FG
20 2025-05-06 RM 2511.67 ... 0.017251 RM509 RM
21 2025-05-06 SF 5548.57 ... -0.000463 SF507 SF
22 2025-05-06 SM 5610.0 ... 0.001783 SM509 SM
23 2025-05-06 CY 23775.0 ... -0.209674 CY507 CY
24 2025-05-06 UR 1893.33 ... -0.013379 UR509 UR
25 2025-05-06 SA 1502.5 ... -0.111481 SA509 SA
26 2025-05-06 PF 6313.75 ... -0.043358 PF507 PF
27 2025-05-06 PX 6600.0 ... -0.073333 PX509 PX
28 2025-05-06 SH 807.0 ... 2.090458 SH509 SH
29 2025-05-06 CU 78233.33 ... -0.007201 cu2506 cu
30 2025-05-06 AL 20073.33 ... -0.010129 al2506 al
31 2025-05-06 ZN 22864.0 ... -0.019419 zn2506 zn
32 2025-05-06 PB 16706.25 ... -0.000973 pb2506 pb
33 2025-05-06 NI 125775.0 ... -0.00974 ni2506 ni
34 2025-05-06 SN 260362.5 ... -0.000163 sn2506 sn
35 2025-05-06 AU 793.83 ... 0.003389 au2508 au
36 2025-05-06 AG 8237.67 ... 0.00004 ag2506 ag
37 2025-05-06 RB 3176.33 ... -0.02655 rb2510 rb
38 2025-05-06 WR 3377.5 ... 0.02117 wr2510 wr
39 2025-05-06 HC 3263.33 ... -0.017568 hc2510 hc
40 2025-05-06 FU 5425.0 ... -0.478341 fu2507 fu
41 2025-05-06 BU 3590.0 ... -0.068802 bu2506 bu
42 2025-05-06 RU 14593.33 ... 0.014847 ru2509 ru
43 2025-05-06 SP 6250.0 ... -0.18816 sp2507 sp
44 2025-05-06 SS 13062.5 ... -0.027751 ss2506 ss
45 2025-05-06 BR 11950.0 ... -0.053556 br2507 br
46 2025-05-06 SI 9780.0 ... -0.144172 SI2506 si
47 2025-05-06 LC 68733.33 ... -0.047624 LC2507 lc
[48 rows x 15 columns]
2025-05-09 16:25:50,173 - future_1d - INFO - save future_spot 2025-05-06 completed
2025-05-09 16:25:55,859 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-07, end_day=2025-05-07) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-07 C 2282.86 ... 0.0408 c2507 c
1 2025-05-07 A 4230.0 ... -0.000473 a2507 a
2 2025-05-07 M 3302.0 ... -0.116596 m2509 m
3 2025-05-07 Y 8076.0 ... -0.03789 y2509 y
4 2025-05-07 P 8584.0 ... -0.076887 p2509 p
5 2025-05-07 JD 3300.0 ... -0.123636 jd2506 jd
6 2025-05-07 L 7491.67 ... -0.057753 l2509 l
7 2025-05-07 V 4665.0 ... 0.050804 v2509 v
8 2025-05-07 PP 7481.67 ... -0.058633 pp2509 pp
9 2025-05-07 I 789.44 ... -0.096828 i2509 i
10 2025-05-07 EG 4340.0 ... -0.030184 eg2509 eg
11 2025-05-07 EB 7650.0 ... -0.079608 eb2506 eb
12 2025-05-07 PG 4930.0 ... -0.097363 pg2506 pg
13 2025-05-07 LH 14830.0 ... -0.056642 lh2509 lh
14 2025-05-07 CF 14124.33 ... -0.087036 CF509 CF
15 2025-05-07 SR 6156.67 ... -0.043476 SR509 SR
16 2025-05-07 TA 4555.84 ... -0.021476 TA509 TA
17 2025-05-07 OI 9430.0 ... -0.015589 OI509 OI
18 2025-05-07 MA 2410.0 ... -0.065975 MA509 MA
19 2025-05-07 FG 1214.4 ... -0.110672 FG509 FG
20 2025-05-07 RM 2511.67 ... 0.016057 RM509 RM
21 2025-05-07 SF 5402.86 ... 0.025013 SF507 SF
22 2025-05-07 SM 5586.0 ... 0.005371 SM509 SM
23 2025-05-07 CY 23775.0 ... -0.202103 CY507 CY
24 2025-05-07 UR 1906.67 ... -0.01189 UR509 UR
25 2025-05-07 SA 1462.5 ... -0.087179 SA509 SA
26 2025-05-07 PF 6377.5 ... -0.036299 PF507 PF
27 2025-05-07 PX 6600.0 ... -0.05 PX509 PX
28 2025-05-07 SH 811.0 ... 2.08508 SH509 SH
29 2025-05-07 CU 78520.0 ... -0.00624 cu2506 cu
30 2025-05-07 AL 19630.0 ... 0.000764 al2506 al
31 2025-05-07 ZN 22758.0 ... -0.017928 zn2506 zn
32 2025-05-07 PB 16637.5 ... 0.00586 pb2506 pb
33 2025-05-07 NI 125683.33 ... -0.012757 ni2506 ni
34 2025-05-07 SN 261137.5 ... 0.00292 sn2506 sn
35 2025-05-07 AU 795.68 ... 0.008069 au2508 au
36 2025-05-07 AG 8188.67 ... 0.006391 ag2506 ag
37 2025-05-07 RB 3177.22 ... -0.022416 rb2510 rb
38 2025-05-07 WR 3377.5 ... 0.022946 wr2510 wr
39 2025-05-07 HC 3283.33 ... -0.016547 hc2510 hc
40 2025-05-07 FU 5425.0 ... -0.471889 fu2507 fu
41 2025-05-07 BU 3590.0 ... -0.054875 bu2507 bu
42 2025-05-07 RU 14578.33 ... 0.020007 ru2509 ru
43 2025-05-07 SP 6200.0 ... -0.175806 sp2507 sp
44 2025-05-07 SS 13062.5 ... -0.020861 ss2507 ss
45 2025-05-07 BR 11970.0 ... -0.047619 br2507 br
46 2025-05-07 SI 9690.0 ... -0.138803 SI2506 si
47 2025-05-07 LC 68233.33 ... -0.050611 LC2507 lc
[48 rows x 15 columns]
2025-05-09 16:25:56,015 - future_1d - INFO - save future_spot 2025-05-07 completed
2025-05-09 16:26:01,301 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-08, end_day=2025-05-08) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-08 C 2285.71 ... 0.036002 c2507 c
1 2025-05-08 A 4230.0 ... -0.014421 a2507 a
2 2025-05-08 M 3300.0 ... -0.117576 m2509 m
3 2025-05-08 Y 8056.0 ... -0.038481 y2509 y
4 2025-05-08 P 8538.0 ... -0.078941 p2509 p
5 2025-05-08 JD 3225.0 ... -0.063566 jd2507 jd
6 2025-05-08 L 7465.0 ... -0.061487 l2509 l
7 2025-05-08 V 4632.0 ... 0.044257 v2509 v
8 2025-05-08 PP 7440.0 ... -0.061022 pp2509 pp
9 2025-05-08 I 776.22 ... -0.098194 i2509 i
10 2025-05-08 EG 4340.0 ... -0.034793 eg2509 eg
11 2025-05-08 EB 7686.0 ... -0.091725 eb2506 eb
12 2025-05-08 PG 4917.5 ... -0.104016 pg2506 pg
13 2025-05-08 LH 14830.0 ... -0.061699 lh2509 lh
14 2025-05-08 CF 14150.33 ... -0.090834 CF509 CF
15 2025-05-08 SR 6156.67 ... -0.054034 SR509 SR
16 2025-05-08 TA 4688.34 ... -0.041452 TA509 TA
17 2025-05-08 OI 9471.67 ... -0.015485 OI509 OI
18 2025-05-08 MA 2390.0 ... -0.07113 MA509 MA
19 2025-05-08 FG 1214.4 ... -0.131258 FG509 FG
20 2025-05-08 RM 2550.0 ... 0.006667 RM509 RM
21 2025-05-08 SF 5402.86 ... 0.0202 SF507 SF
22 2025-05-08 SM 5590.0 ... 0.017889 SM509 SM
23 2025-05-08 CY 23775.0 ... -0.196845 CY507 CY
24 2025-05-08 UR 1911.67 ... -0.019705 UR509 UR
25 2025-05-08 SA 1462.5 ... -0.104274 SA509 SA
26 2025-05-08 PF 6364.79 ... -0.029662 PF507 PF
27 2025-05-08 PX 6600.0 ... -0.041212 PX509 PX
28 2025-05-08 SH 815.0 ... 2.045399 SH509 SH
29 2025-05-08 CU 78458.33 ... -0.011195 cu2506 cu
30 2025-05-08 AL 19630.0 ... -0.007641 al2506 al
31 2025-05-08 ZN 22832.0 ... -0.024177 zn2506 zn
32 2025-05-08 PB 16737.5 ... 0.002838 pb2506 pb
33 2025-05-08 NI 125050.0 ... -0.010956 ni2506 ni
34 2025-05-08 SN 262050.0 ... -0.005304 sn2506 sn
35 2025-05-08 AU 795.94 ... 0.006282 au2508 au
36 2025-05-08 AG 8188.67 ... -0.000082 ag2508 ag
37 2025-05-08 RB 3162.78 ... -0.028703 rb2510 rb
38 2025-05-08 WR 3367.5 ... 0.020341 wr2510 wr
39 2025-05-08 HC 3276.67 ... -0.023399 hc2510 hc
40 2025-05-08 FU 5450.0 ... -0.473211 fu2507 fu
41 2025-05-08 BU 3582.5 ... -0.056804 bu2507 bu
42 2025-05-08 RU 14458.33 ... 0.016369 ru2509 ru
43 2025-05-08 SP 6200.0 ... -0.17129 sp2507 sp
44 2025-05-08 SS 13042.5 ... -0.020127 ss2507 ss
45 2025-05-08 BR 11970.0 ... -0.051796 br2507 br
46 2025-05-08 SI 9640.0 ... -0.144191 SI2506 si
47 2025-05-08 LC 67733.33 ... -0.05689 LC2507 lc
[48 rows x 15 columns]
2025-05-09 16:26:01,471 - future_1d - INFO - save future_spot 2025-05-08 add
2025-05-09 16:26:01,478 - future_1d - INFO - 0 ... 4
date 2025-05-08 ... 2025-05-08
variety C ... P
spot_price 2285.71 ... 8538.0
near_contract c2505 ... p2505
near_contract_price 2339.0 ... 8226.0
dominant_contract c2507 ... p2509
dominant_contract_price 2368.0 ... 7864.0
near_month 2505 ... 2505
dominant_month 2507 ... 2509
near_basis 53.29 ... -312.0
dom_basis 82.29 ... -674.0
near_basis_rate 0.0233 ... -0.0365
dom_basis_rate 0.036 ... -0.0789
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-09 16:26:01.431684 ... 2025-05-09 16:26:01.431684
updated_at 2025-05-09 16:26:01.432089 ... 2025-05-09 16:26:01.432089
[17 rows x 5 columns]
2025-05-09 16:26:09,998 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-09, end_day=2025-05-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-09 C 2292.86 ... 0.033644 c2507 c
1 2025-05-09 A 4230.0 ... -0.013002 a2507 a
2 2025-05-09 M 3300.0 ... -0.117273 m2509 m
3 2025-05-09 Y 8056.0 ... -0.030288 y2509 y
4 2025-05-09 P 8538.0 ... -0.07004 p2509 p
5 2025-05-09 JD 3225.0 ... -0.058915 jd2507 jd
6 2025-05-09 L 7458.33 ... -0.059575 l2509 l
7 2025-05-09 V 4634.0 ... 0.040785 v2509 v
8 2025-05-09 PP 7440.0 ... -0.059946 pp2509 pp
9 2025-05-09 I 770.89 ... -0.096499 i2509 i
10 2025-05-09 EG 4340.0 ... -0.02788 eg2509 eg
11 2025-05-09 EB 7680.0 ... -0.091276 eb2506 eb
12 2025-05-09 PG 4917.5 ... -0.108287 pg2506 pg
13 2025-05-09 LH 14780.0 ... -0.05954 lh2509 lh
14 2025-05-09 CF 14150.33 ... -0.086594 CF509 CF
15 2025-05-09 SR 6146.67 ... -0.049892 SR509 SR
16 2025-05-09 TA 4750.84 ... -0.038486 TA509 TA
17 2025-05-09 OI 9463.33 ... -0.00796 OI509 OI
18 2025-05-09 MA 2402.5 ... -0.0718 MA509 MA
19 2025-05-09 FG 1214.4 ... -0.137022 FG509 FG
20 2025-05-09 RM 2506.67 ... 0.020078 RM509 RM
21 2025-05-09 SF 5402.86 ... 0.027234 SF507 SF
22 2025-05-09 SM 5634.0 ... 0.022719 SM509 SM
23 2025-05-09 CY 23775.0 ... -0.187802 CY507 CY
24 2025-05-09 UR 1921.67 ... -0.010236 UR509 UR
25 2025-05-09 SA 1462.5 ... -0.100171 SA509 SA
26 2025-05-09 PF 6377.92 ... -0.019116 PF507 PF
27 2025-05-09 PX 6600.0 ... -0.023333 PX509 PX
28 2025-05-09 SH 821.0 ... 2.021924 SH509 SH
29 2025-05-09 CU 78258.33 ... -0.007646 cu2506 cu
30 2025-05-09 AL 19630.0 ... -0.006623 al2507 al
31 2025-05-09 ZN 22756.0 ... -0.022236 zn2506 zn
32 2025-05-09 PB 16718.75 ... 0.004262 pb2506 pb
33 2025-05-09 NI 125050.0 ... -0.011116 ni2506 ni
34 2025-05-09 SN 259500.0 ... 0.005318 sn2506 sn
35 2025-05-09 AU 795.94 ... -0.009775 au2508 au
36 2025-05-09 AG 8188.67 ... -0.002036 ag2508 ag
37 2025-05-09 RB 3141.44 ... -0.033564 rb2510 rb
38 2025-05-09 WR 3367.5 ... 0.004009 wr2510 wr
39 2025-05-09 HC 3273.33 ... -0.030956 hc2510 hc
40 2025-05-09 FU 5470.0 ... -0.465631 fu2507 fu
41 2025-05-09 BU 3585.0 ... -0.049372 bu2507 bu
42 2025-05-09 RU 14408.33 ... 0.02059 ru2509 ru
43 2025-05-09 SP 6200.0 ... -0.164194 sp2507 sp
44 2025-05-09 SS 13042.5 ... -0.021277 ss2507 ss
45 2025-05-09 BR 11970.0 ... -0.037594 br2507 br
46 2025-05-09 SI 9640.0 ... -0.139004 SI2506 si
47 2025-05-09 LC 67133.33 ... -0.051142 LC2507 lc
[48 rows x 15 columns]
2025-05-09 16:26:10,165 - future_1d - INFO - save future_spot 2025-05-09 add
2025-05-09 16:26:10,172 - future_1d - INFO - 0 ... 4
date 2025-05-09 ... 2025-05-09
variety C ... P
spot_price 2292.86 ... 8538.0
near_contract c2505 ... p2505
near_contract_price 2333.0 ... 8226.0
dominant_contract c2507 ... p2509
dominant_contract_price 2370.0 ... 7940.0
near_month 2505 ... 2505
dominant_month 2507 ... 2509
near_basis 40.14 ... -312.0
dom_basis 77.14 ... -598.0
near_basis_rate 0.0175 ... -0.0365
dom_basis_rate 0.0336 ... -0.07
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-09 16:26:10.129074 ... 2025-05-09 16:26:10.129074
updated_at 2025-05-09 16:26:10.129448 ... 2025-05-09 16:26:10.129448
[17 rows x 5 columns]
=========================================================================
2025-05-09 18:25:11 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-05-09 18:25:13,122 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-09 18:25:13,442 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-30, end_day=2025-04-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-30 C 2252.86 ... 0.049777 c2507 c
1 2025-04-30 A 4245.0 ... -0.014841 a2507 a
2 2025-04-30 M 3476.67 ... -0.152925 m2509 m
3 2025-04-30 Y 8126.0 ... -0.040364 y2509 y
4 2025-04-30 P 8760.0 ... -0.074658 p2509 p
5 2025-04-30 JD 3375.0 ... -0.125333 jd2506 jd
6 2025-04-30 L 7553.33 ... -0.059885 l2509 l
7 2025-04-30 V 4679.0 ... 0.053644 v2509 v
8 2025-04-30 PP 7481.67 ... -0.056093 pp2509 pp
9 2025-04-30 I 778.11 ... -0.094601 i2509 i
10 2025-04-30 EG 4331.67 ... -0.035707 eg2509 eg
11 2025-04-30 EB 7680.0 ... -0.082292 eb2506 eb
12 2025-04-30 PG 4980.0 ... -0.117871 pg2506 pg
13 2025-04-30 LH 14830.0 ... -0.061699 lh2509 lh
14 2025-04-30 CF 14208.83 ... -0.100911 CF509 CF
15 2025-04-30 SR 6160.0 ... -0.043994 SR509 SR
16 2025-04-30 TA 4584.38 ... -0.034111 TA509 TA
17 2025-04-30 OI 9378.33 ... -0.011338 OI509 OI
18 2025-04-30 MA 2440.0 ... -0.070902 MA509 MA
19 2025-04-30 FG 1246.4 ... -0.126284 FG509 FG
20 2025-04-30 RM 2531.67 ... 0.012375 RM509 RM
21 2025-04-30 SF 5548.57 ... 0.024048 SF507 SF
22 2025-04-30 SM 5640.0 ... 0.01383 SM509 SM
23 2025-04-30 CY 23775.0 ... -0.209674 CY507 CY
24 2025-04-30 UR 1875.0 ... -0.016 UR509 UR
25 2025-04-30 SA 1502.5 ... -0.097504 SA509 SA
26 2025-04-30 PF 6351.46 ... -0.037072 PF507 PF
27 2025-04-30 PX 6800.0 ... -0.087647 PX509 PX
28 2025-04-30 SH 807.0 ... 2.042131 SH509 SH
29 2025-04-30 CU 77996.67 ... -0.026753 cu2503 cu
30 2025-04-30 AL 20073.33 ... 0.008054 al2503 al
31 2025-04-30 ZN 22904.0 ... 0.019473 zn2503 zn
32 2025-04-30 PB 16812.5 ... 0.016506 pb2503 pb
33 2025-04-30 NI 125175.0 ... 0.001318 ni2503 ni
34 2025-04-30 SN 261175.0 ... -0.014875 sn2503 sn
35 2025-04-30 AU 780.65 ... -0.139435 au2504 au
36 2025-04-30 AG 8204.33 ... -0.014301 ag2504 ag
37 2025-04-30 RB 3183.22 ... 0.049252 rb2505 rb
38 2025-04-30 WR 3377.5 ... 0.057291 wr2505 wr
39 2025-04-30 HC 3276.67 ... 0.048015 hc2505 hc
40 2025-04-30 FU 5462.5 ... -0.371167 fu2505 fu
41 2025-04-30 BU 3647.5 ... 0.033859 bu2503 bu
42 2025-04-30 RU 14308.33 ... 0.200699 ru2505 ru
43 2025-04-30 SP 6250.0 ... -0.01312 sp2503 sp
44 2025-04-30 SS 13050.0 ... 0.027203 ss2503 ss
45 2025-04-30 BR 11950.0 ... 0.2 br2504 br
46 2025-04-30 SI 9880.0 ... -0.135121 SI2506 si
47 2025-04-30 LC 68933.33 ... -0.038781 LC2507 lc
[48 rows x 15 columns]
2025-05-09 18:25:13,620 - future_1d - INFO - save future_spot 2025-04-30 completed
2025-05-09 18:25:20,841 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-06, end_day=2025-05-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-06 C 2272.86 ... 0.039659 c2507 c
1 2025-05-06 A 4230.0 ... -0.013002 a2507 a
2 2025-05-06 M 3270.0 ... -0.106728 m2509 m
3 2025-05-06 Y 8056.0 ... -0.037736 y2509 y
4 2025-05-06 P 8678.0 ... -0.079972 p2509 p
5 2025-05-06 JD 3375.0 ... -0.141037 jd2506 jd
6 2025-05-06 L 7500.0 ... -0.065333 l2509 l
7 2025-05-06 V 4653.0 ... 0.05072 v2509 v
8 2025-05-06 PP 7481.67 ... -0.063712 pp2509 pp
9 2025-05-06 I 781.44 ... -0.09718 i2509 i
10 2025-05-06 EG 4331.67 ... -0.045403 eg2509 eg
11 2025-05-06 EB 7650.0 ... -0.089542 eb2506 eb
12 2025-05-06 PG 4967.5 ... -0.114444 pg2506 pg
13 2025-05-06 LH 14820.0 ... -0.060729 lh2509 lh
14 2025-05-06 CF 14138.67 ... -0.095742 CF509 CF
15 2025-05-06 SR 6156.67 ... -0.043152 SR509 SR
16 2025-05-06 TA 4529.17 ... -0.037793 TA509 TA
17 2025-05-06 OI 9330.0 ... -0.009432 OI509 OI
18 2025-05-06 MA 2428.75 ... -0.07895 MA509 MA
19 2025-05-06 FG 1214.4 ... -0.116436 FG509 FG
20 2025-05-06 RM 2511.67 ... 0.017251 RM509 RM
21 2025-05-06 SF 5548.57 ... -0.000463 SF507 SF
22 2025-05-06 SM 5610.0 ... 0.001783 SM509 SM
23 2025-05-06 CY 23775.0 ... -0.209674 CY507 CY
24 2025-05-06 UR 1893.33 ... -0.013379 UR509 UR
25 2025-05-06 SA 1502.5 ... -0.111481 SA509 SA
26 2025-05-06 PF 6313.75 ... -0.043358 PF507 PF
27 2025-05-06 PX 6600.0 ... -0.073333 PX509 PX
28 2025-05-06 SH 807.0 ... 2.090458 SH509 SH
29 2025-05-06 CU 78233.33 ... -0.007201 cu2506 cu
30 2025-05-06 AL 20073.33 ... -0.010129 al2506 al
31 2025-05-06 ZN 22864.0 ... -0.019419 zn2506 zn
32 2025-05-06 PB 16706.25 ... -0.000973 pb2506 pb
33 2025-05-06 NI 125775.0 ... -0.00974 ni2506 ni
34 2025-05-06 SN 260362.5 ... -0.000163 sn2506 sn
35 2025-05-06 AU 793.83 ... 0.003389 au2508 au
36 2025-05-06 AG 8237.67 ... 0.00004 ag2506 ag
37 2025-05-06 RB 3176.33 ... -0.02655 rb2510 rb
38 2025-05-06 WR 3377.5 ... 0.02117 wr2510 wr
39 2025-05-06 HC 3263.33 ... -0.017568 hc2510 hc
40 2025-05-06 FU 5425.0 ... -0.478341 fu2507 fu
41 2025-05-06 BU 3590.0 ... -0.068802 bu2506 bu
42 2025-05-06 RU 14593.33 ... 0.014847 ru2509 ru
43 2025-05-06 SP 6250.0 ... -0.18816 sp2507 sp
44 2025-05-06 SS 13062.5 ... -0.027751 ss2506 ss
45 2025-05-06 BR 11950.0 ... -0.053556 br2507 br
46 2025-05-06 SI 9780.0 ... -0.144172 SI2506 si
47 2025-05-06 LC 68733.33 ... -0.047624 LC2507 lc
[48 rows x 15 columns]
2025-05-09 18:25:20,999 - future_1d - INFO - save future_spot 2025-05-06 completed
2025-05-09 18:25:27,427 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-07, end_day=2025-05-07) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-07 C 2282.86 ... 0.0408 c2507 c
1 2025-05-07 A 4230.0 ... -0.000473 a2507 a
2 2025-05-07 M 3302.0 ... -0.116596 m2509 m
3 2025-05-07 Y 8076.0 ... -0.03789 y2509 y
4 2025-05-07 P 8584.0 ... -0.076887 p2509 p
5 2025-05-07 JD 3300.0 ... -0.123636 jd2506 jd
6 2025-05-07 L 7491.67 ... -0.057753 l2509 l
7 2025-05-07 V 4665.0 ... 0.050804 v2509 v
8 2025-05-07 PP 7481.67 ... -0.058633 pp2509 pp
9 2025-05-07 I 789.44 ... -0.096828 i2509 i
10 2025-05-07 EG 4340.0 ... -0.030184 eg2509 eg
11 2025-05-07 EB 7650.0 ... -0.079608 eb2506 eb
12 2025-05-07 PG 4930.0 ... -0.097363 pg2506 pg
13 2025-05-07 LH 14830.0 ... -0.056642 lh2509 lh
14 2025-05-07 CF 14124.33 ... -0.087036 CF509 CF
15 2025-05-07 SR 6156.67 ... -0.043476 SR509 SR
16 2025-05-07 TA 4555.84 ... -0.021476 TA509 TA
17 2025-05-07 OI 9430.0 ... -0.015589 OI509 OI
18 2025-05-07 MA 2410.0 ... -0.065975 MA509 MA
19 2025-05-07 FG 1214.4 ... -0.110672 FG509 FG
20 2025-05-07 RM 2511.67 ... 0.016057 RM509 RM
21 2025-05-07 SF 5402.86 ... 0.025013 SF507 SF
22 2025-05-07 SM 5586.0 ... 0.005371 SM509 SM
23 2025-05-07 CY 23775.0 ... -0.202103 CY507 CY
24 2025-05-07 UR 1906.67 ... -0.01189 UR509 UR
25 2025-05-07 SA 1462.5 ... -0.087179 SA509 SA
26 2025-05-07 PF 6377.5 ... -0.036299 PF507 PF
27 2025-05-07 PX 6600.0 ... -0.05 PX509 PX
28 2025-05-07 SH 811.0 ... 2.08508 SH509 SH
29 2025-05-07 CU 78520.0 ... -0.00624 cu2506 cu
30 2025-05-07 AL 19630.0 ... 0.000764 al2506 al
31 2025-05-07 ZN 22758.0 ... -0.017928 zn2506 zn
32 2025-05-07 PB 16637.5 ... 0.00586 pb2506 pb
33 2025-05-07 NI 125683.33 ... -0.012757 ni2506 ni
34 2025-05-07 SN 261137.5 ... 0.00292 sn2506 sn
35 2025-05-07 AU 795.68 ... 0.008069 au2508 au
36 2025-05-07 AG 8188.67 ... 0.006391 ag2506 ag
37 2025-05-07 RB 3177.22 ... -0.022416 rb2510 rb
38 2025-05-07 WR 3377.5 ... 0.022946 wr2510 wr
39 2025-05-07 HC 3283.33 ... -0.016547 hc2510 hc
40 2025-05-07 FU 5425.0 ... -0.471889 fu2507 fu
41 2025-05-07 BU 3590.0 ... -0.054875 bu2507 bu
42 2025-05-07 RU 14578.33 ... 0.020007 ru2509 ru
43 2025-05-07 SP 6200.0 ... -0.175806 sp2507 sp
44 2025-05-07 SS 13062.5 ... -0.020861 ss2507 ss
45 2025-05-07 BR 11970.0 ... -0.047619 br2507 br
46 2025-05-07 SI 9690.0 ... -0.138803 SI2506 si
47 2025-05-07 LC 68233.33 ... -0.050611 LC2507 lc
[48 rows x 15 columns]
2025-05-09 18:25:27,580 - future_1d - INFO - save future_spot 2025-05-07 completed
2025-05-09 18:25:33,262 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-08, end_day=2025-05-08) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-08 C 2285.71 ... 0.036002 c2507 c
1 2025-05-08 A 4230.0 ... -0.014421 a2507 a
2 2025-05-08 M 3300.0 ... -0.117576 m2509 m
3 2025-05-08 Y 8056.0 ... -0.038481 y2509 y
4 2025-05-08 P 8538.0 ... -0.078941 p2509 p
5 2025-05-08 JD 3225.0 ... -0.063566 jd2507 jd
6 2025-05-08 L 7465.0 ... -0.061487 l2509 l
7 2025-05-08 V 4632.0 ... 0.044257 v2509 v
8 2025-05-08 PP 7440.0 ... -0.061022 pp2509 pp
9 2025-05-08 I 776.22 ... -0.098194 i2509 i
10 2025-05-08 EG 4340.0 ... -0.034793 eg2509 eg
11 2025-05-08 EB 7686.0 ... -0.091725 eb2506 eb
12 2025-05-08 PG 4917.5 ... -0.104016 pg2506 pg
13 2025-05-08 LH 14830.0 ... -0.061699 lh2509 lh
14 2025-05-08 CF 14150.33 ... -0.090834 CF509 CF
15 2025-05-08 SR 6156.67 ... -0.054034 SR509 SR
16 2025-05-08 TA 4688.34 ... -0.041452 TA509 TA
17 2025-05-08 OI 9471.67 ... -0.015485 OI509 OI
18 2025-05-08 MA 2390.0 ... -0.07113 MA509 MA
19 2025-05-08 FG 1214.4 ... -0.131258 FG509 FG
20 2025-05-08 RM 2550.0 ... 0.006667 RM509 RM
21 2025-05-08 SF 5402.86 ... 0.0202 SF507 SF
22 2025-05-08 SM 5590.0 ... 0.017889 SM509 SM
23 2025-05-08 CY 23775.0 ... -0.196845 CY507 CY
24 2025-05-08 UR 1911.67 ... -0.019705 UR509 UR
25 2025-05-08 SA 1462.5 ... -0.104274 SA509 SA
26 2025-05-08 PF 6364.79 ... -0.029662 PF507 PF
27 2025-05-08 PX 6600.0 ... -0.041212 PX509 PX
28 2025-05-08 SH 815.0 ... 2.045399 SH509 SH
29 2025-05-08 CU 78458.33 ... -0.011195 cu2506 cu
30 2025-05-08 AL 19630.0 ... -0.007641 al2506 al
31 2025-05-08 ZN 22832.0 ... -0.024177 zn2506 zn
32 2025-05-08 PB 16737.5 ... 0.002838 pb2506 pb
33 2025-05-08 NI 125050.0 ... -0.010956 ni2506 ni
34 2025-05-08 SN 262050.0 ... -0.005304 sn2506 sn
35 2025-05-08 AU 795.94 ... 0.006282 au2508 au
36 2025-05-08 AG 8188.67 ... -0.000082 ag2508 ag
37 2025-05-08 RB 3162.78 ... -0.028703 rb2510 rb
38 2025-05-08 WR 3367.5 ... 0.020341 wr2510 wr
39 2025-05-08 HC 3276.67 ... -0.023399 hc2510 hc
40 2025-05-08 FU 5450.0 ... -0.473211 fu2507 fu
41 2025-05-08 BU 3582.5 ... -0.056804 bu2507 bu
42 2025-05-08 RU 14458.33 ... 0.016369 ru2509 ru
43 2025-05-08 SP 6200.0 ... -0.17129 sp2507 sp
44 2025-05-08 SS 13042.5 ... -0.020127 ss2507 ss
45 2025-05-08 BR 11970.0 ... -0.051796 br2507 br
46 2025-05-08 SI 9640.0 ... -0.144191 SI2506 si
47 2025-05-08 LC 67733.33 ... -0.05689 LC2507 lc
[48 rows x 15 columns]
2025-05-09 18:25:33,451 - future_1d - INFO - save future_spot 2025-05-08 completed
2025-05-09 18:25:37,185 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-09, end_day=2025-05-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-09 C 2292.86 ... 0.033644 c2507 c
1 2025-05-09 A 4245.0 ... -0.01649 a2507 a
2 2025-05-09 M 3300.0 ... -0.117273 m2509 m
3 2025-05-09 Y 8076.0 ... -0.032689 y2509 y
4 2025-05-09 P 8510.0 ... -0.06698 p2509 p
5 2025-05-09 JD 3225.0 ... -0.058915 jd2507 jd
6 2025-05-09 L 7458.33 ... -0.059575 l2509 l
7 2025-05-09 V 4629.0 ... 0.04191 v2509 v
8 2025-05-09 PP 7440.0 ... -0.059946 pp2509 pp
9 2025-05-09 I 770.89 ... -0.096499 i2509 i
10 2025-05-09 EG 4340.0 ... -0.02788 eg2509 eg
11 2025-05-09 EB 7680.0 ... -0.091276 eb2506 eb
12 2025-05-09 PG 4917.5 ... -0.108287 pg2506 pg
13 2025-05-09 LH 14780.0 ... -0.05954 lh2509 lh
14 2025-05-09 CF 14136.0 ... -0.085668 CF509 CF
15 2025-05-09 SR 6146.67 ... -0.049892 SR509 SR
16 2025-05-09 TA 4750.84 ... -0.038486 TA509 TA
17 2025-05-09 OI 9463.33 ... -0.00796 OI509 OI
18 2025-05-09 MA 2402.5 ... -0.0718 MA509 MA
19 2025-05-09 FG 1210.4 ... -0.134171 FG509 FG
20 2025-05-09 RM 2506.67 ... 0.020078 RM509 RM
21 2025-05-09 SF 5402.86 ... 0.027234 SF507 SF
22 2025-05-09 SM 5634.0 ... 0.022719 SM509 SM
23 2025-05-09 CY 23775.0 ... -0.187802 CY507 CY
24 2025-05-09 UR 1921.67 ... -0.010236 UR509 UR
25 2025-05-09 SA 1462.5 ... -0.100171 SA509 SA
26 2025-05-09 PF 6377.92 ... -0.019116 PF507 PF
27 2025-05-09 PX 6600.0 ... -0.023333 PX509 PX
28 2025-05-09 SH 821.0 ... 2.021924 SH509 SH
29 2025-05-09 CU 78258.33 ... -0.007646 cu2506 cu
30 2025-05-09 AL 19630.0 ... -0.006623 al2507 al
31 2025-05-09 ZN 22756.0 ... -0.022236 zn2506 zn
32 2025-05-09 PB 16718.75 ... 0.004262 pb2506 pb
33 2025-05-09 NI 124758.33 ... -0.008804 ni2506 ni
34 2025-05-09 SN 259500.0 ... 0.005318 sn2506 sn
35 2025-05-09 AU 795.94 ... -0.009775 au2508 au
36 2025-05-09 AG 8188.67 ... -0.002036 ag2508 ag
37 2025-05-09 RB 3141.44 ... -0.033564 rb2510 rb
38 2025-05-09 WR 3367.5 ... 0.004009 wr2510 wr
39 2025-05-09 HC 3273.33 ... -0.030956 hc2510 hc
40 2025-05-09 FU 5470.0 ... -0.465631 fu2507 fu
41 2025-05-09 BU 3585.0 ... -0.049372 bu2507 bu
42 2025-05-09 RU 14408.33 ... 0.02059 ru2509 ru
43 2025-05-09 SP 6200.0 ... -0.164194 sp2507 sp
44 2025-05-09 SS 13042.5 ... -0.021277 ss2507 ss
45 2025-05-09 BR 12010.0 ... -0.040799 br2507 br
46 2025-05-09 SI 9640.0 ... -0.139004 SI2506 si
47 2025-05-09 LC 67133.33 ... -0.051142 LC2507 lc
[48 rows x 15 columns]
2025-05-09 18:25:37,362 - future_1d - INFO - save future_spot 2025-05-09 add
2025-05-09 18:25:37,370 - future_1d - INFO - 1 ... 14
date 2025-05-09 ... 2025-05-09
variety A ... CF
spot_price 4245.0 ... 14136.0
near_contract a2505 ... CF505
near_contract_price 4133.0 ... 12645.0
dominant_contract a2507 ... CF509
dominant_contract_price 4175.0 ... 12925.0
near_month 2505 ... 2505
dominant_month 2507 ... 2509
near_basis -112.0 ... -1491.0
dom_basis -70.0 ... -1211.0
near_basis_rate -0.0264 ... -0.1055
dom_basis_rate -0.0165 ... -0.0857
symbol a2507 ... CF509
comd a ... CF
created_at 2025-05-09 18:25:37.324832 ... 2025-05-09 18:25:37.324832
updated_at 2025-05-09 18:25:37.325213 ... 2025-05-09 18:25:37.325213
[17 rows x 5 columns]