=========================================================================
2025-07-15 16:25:32 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-07-15 16:25:34,595 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-15 16:25:34,930 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-09, end_day=2025-07-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-09 C 2357.14 ... -0.014908 c2509 c
1 2025-07-09 A 4295.0 ... -0.042608 a2509 a
2 2025-07-09 M 2882.0 ... 0.020125 m2509 m
3 2025-07-09 Y 8182.0 ... -0.031777 y2509 y
4 2025-07-09 P 8874.0 ... -0.024566 p2509 p
5 2025-07-09 JD 2750.0 ... 0.303636 jd2509 jd
6 2025-07-09 L 7411.67 ... -0.020868 l2509 l
7 2025-07-09 V 4688.0 ... 0.051408 v2509 v
8 2025-07-09 PP 7376.67 ... -0.043471 pp2509 pp
9 2025-07-09 JM 1236.25 ... -0.303943 jm2509 jm
10 2025-07-09 I 739.0 ... -0.003383 i2509 i
11 2025-07-09 EG 4393.33 ... -0.026934 eg2509 eg
12 2025-07-09 EB 7908.0 ... -0.074355 eb2508 eb
13 2025-07-09 PG 4870.0 ... -0.142094 pg2508 pg
14 2025-07-09 LH 14900.0 ... -0.045638 lh2509 lh
15 2025-07-09 BZ 5818.67 ... 0.033741 bz2603 bz
16 2025-07-09 CF 15188.83 ... -0.093413 CF509 CF
17 2025-07-09 SR 6050.0 ... -0.047438 SR509 SR
18 2025-07-09 TA 4852.5 ... -0.028542 TA509 TA
19 2025-07-09 FG 1122.4 ... -0.083215 FG509 FG
20 2025-07-09 RM 2505.0 ... 0.027146 RM509 RM
21 2025-07-09 SF 5138.57 ... 0.046984 SF509 SF
22 2025-07-09 SM 5546.0 ... 0.024522 SM509 SM
23 2025-07-09 CY 23200.0 ... -0.141595 CY509 CY
24 2025-07-09 UR 1843.0 ... -0.039067 UR509 UR
25 2025-07-09 SA 1247.5 ... -0.048497 SA509 SA
26 2025-07-09 PF 6702.71 ... -0.043372 PF509 PF
27 2025-07-09 PX 7250.0 ... -0.073655 PX509 PX
28 2025-07-09 SH 841.0 ... 1.876338 SH509 SH
29 2025-07-09 CU 79245.0 ... -0.004227 cu2508 cu
30 2025-07-09 AL 20680.0 ... -0.007979 al2508 al
31 2025-07-09 ZN 22144.0 ... -0.00289 zn2508 zn
32 2025-07-09 PB 17087.5 ... 0.006584 pb2508 pb
33 2025-07-09 NI 120516.67 ... -0.008768 ni2508 ni
34 2025-07-09 SN 265262.5 ... -0.00638 sn2508 sn
35 2025-07-09 AU 767.05 ... 0.00322 au2510 au
36 2025-07-09 AG 8873.67 ... 0.002855 ag2510 ag
37 2025-07-09 RB 3112.5 ... -0.015261 rb2510 rb
38 2025-07-09 WR 3300.0 ... 0.01 wr2601 wr
39 2025-07-09 HC 3276.67 ... -0.025535 hc2510 hc
40 2025-07-09 FU 5412.5 ... -0.449053 fu2509 fu
41 2025-07-09 BU 3696.67 ... -0.021011 bu2509 bu
42 2025-07-09 RU 13908.33 ... 0.006951 ru2509 ru
43 2025-07-09 SP 5900.0 ... -0.13661 sp2509 sp
44 2025-07-09 SS 12887.5 ... -0.012221 ss2508 ss
45 2025-07-09 BR 11690.0 ... -0.038067 br2509 br
46 2025-07-09 SI 8910.0 ... -0.083614 SI2509 si
47 2025-07-09 LC 62600.0 ... 0.029712 LC2509 lc
[48 rows x 15 columns]
2025-07-15 16:25:35,101 - future_1d - INFO - save future_spot 2025-07-09 completed
2025-07-15 16:25:39,516 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-10, end_day=2025-07-10) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-10 C 2354.29 ... -0.015414 c2509 c
1 2025-07-10 A 4295.0 ... -0.043073 a2509 a
2 2025-07-10 M 2888.0 ... 0.019044 m2509 m
3 2025-07-10 Y 8214.0 ... -0.034819 y2509 y
4 2025-07-10 P 8836.0 ... -0.02354 p2509 p
5 2025-07-10 JD 2750.0 ... 0.298909 jd2509 jd
6 2025-07-10 L 7415.0 ... -0.014295 l2509 l
7 2025-07-10 V 4768.0 ... 0.049706 v2509 v
8 2025-07-10 PP 7360.0 ... -0.03519 pp2509 pp
9 2025-07-10 JM 1241.25 ... -0.288218 jm2509 jm
10 2025-07-10 I 748.44 ... 0.002752 i2509 i
11 2025-07-10 EG 4393.33 ... -0.01965 eg2509 eg
12 2025-07-10 EB 7908.0 ... -0.059686 eb2508 eb
13 2025-07-10 PG 4882.5 ... -0.13999 pg2508 pg
14 2025-07-10 LH 14830.0 ... -0.033715 lh2509 lh
15 2025-07-10 BZ 5835.33 ... 0.065064 bz2603 bz
16 2025-07-10 CF 15201.0 ... -0.087889 CF509 CF
17 2025-07-10 SR 6046.67 ... -0.040794 SR509 SR
18 2025-07-10 TA 4852.5 ... -0.025657 TA509 TA
19 2025-07-10 FG 1122.4 ... -0.052922 FG509 FG
20 2025-07-10 RM 2523.33 ... 0.028403 RM509 RM
21 2025-07-10 SF 5178.57 ... 0.068249 SF509 SF
22 2025-07-10 SM 5622.0 ... 0.030238 SM509 SM
23 2025-07-10 CY 23200.0 ... -0.137716 CY509 CY
24 2025-07-10 UR 1845.0 ... -0.036856 UR509 UR
25 2025-07-10 SA 1247.5 ... -0.027655 SA509 SA
26 2025-07-10 PF 6700.5 ... -0.039773 PF509 PF
27 2025-07-10 PX 7250.0 ... -0.068966 PX509 PX
28 2025-07-10 SH 847.0 ... 1.945691 SH509 SH
29 2025-07-10 CU 78678.33 ... -0.003665 cu2508 cu
30 2025-07-10 AL 20680.0 ... -0.000484 al2508 al
31 2025-07-10 ZN 22376.0 ... -0.004067 zn2508 zn
32 2025-07-10 PB 17093.75 ... 0.007093 pb2508 pb
33 2025-07-10 NI 120916.67 ... -0.008325 ni2508 ni
34 2025-07-10 SN 265075.0 ... -0.000283 sn2508 sn
35 2025-07-10 AU 767.05 ... 0.005358 au2510 au
36 2025-07-10 AG 8873.67 ... 0.001277 ag2510 ag
37 2025-07-10 RB 3138.5 ... -0.012586 rb2510 rb
38 2025-07-10 WR 3315.0 ... 0.004223 wr2601 wr
39 2025-07-10 HC 3290.0 ... -0.017325 hc2510 hc
40 2025-07-10 FU 5400.0 ... -0.451481 fu2509 fu
41 2025-07-10 BU 3690.0 ... -0.017615 bu2509 bu
42 2025-07-10 RU 14466.67 ... -0.015668 ru2509 ru
43 2025-07-10 SP 5933.33 ... -0.129325 sp2509 sp
44 2025-07-10 SS 12887.5 ... -0.005626 ss2508 ss
45 2025-07-10 BR 11810.0 ... -0.033023 br2509 br
46 2025-07-10 SI 8920.0 ... -0.061099 SI2509 si
47 2025-07-10 LC 62766.67 ... 0.026978 LC2509 lc
[48 rows x 15 columns]
2025-07-15 16:25:39,670 - future_1d - INFO - save future_spot 2025-07-10 completed
2025-07-15 16:25:43,387 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-11, end_day=2025-07-11) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-11 C 2351.43 ... -0.016769 c2509 c
1 2025-07-11 A 4295.0 ... -0.045867 a2509 a
2 2025-07-11 M 2924.0 ... 0.016074 m2509 m
3 2025-07-11 Y 8254.0 ... -0.034408 y2509 y
4 2025-07-11 P 8944.0 ... -0.028846 p2509 p
5 2025-07-11 JD 2775.0 ... 0.290811 jd2509 jd
6 2025-07-11 L 7416.67 ... -0.015461 l2509 l
7 2025-07-11 V 4733.0 ... 0.059159 v2509 v
8 2025-07-11 PP 7355.0 ... -0.037933 pp2509 pp
9 2025-07-11 JM 1241.25 ... -0.267271 jm2509 jm
10 2025-07-11 I 762.56 ... 0.002544 i2509 i
11 2025-07-11 EG 4405.0 ... -0.019977 eg2509 eg
12 2025-07-11 EB 7908.0 ... -0.055893 eb2508 eb
13 2025-07-11 PG 4875.0 ... -0.145846 pg2508 pg
14 2025-07-11 LH 14820.0 ... -0.031714 lh2509 lh
15 2025-07-11 BZ 5878.67 ... 0.061124 bz2603 bz
16 2025-07-11 CF 15282.0 ... -0.090106 CF509 CF
17 2025-07-11 SR 6046.67 ... -0.039471 SR509 SR
18 2025-07-11 TA 4852.5 ... -0.029366 TA509 TA
19 2025-07-11 FG 1128.0 ... -0.033688 FG509 FG
20 2025-07-11 RM 2551.67 ... 0.030698 RM509 RM
21 2025-07-11 SF 5217.14 ... 0.058434 SF509 SF
22 2025-07-11 SM 5630.0 ... 0.025577 SM509 SM
23 2025-07-11 CY 23200.0 ... -0.134914 CY509 CY
24 2025-07-11 UR 1861.25 ... -0.045803 UR509 UR
25 2025-07-11 SA 1247.5 ... -0.018036 SA509 SA
26 2025-07-11 PF 6668.46 ... -0.040258 PF509 PF
27 2025-07-11 PX 7250.0 ... -0.073103 PX509 PX
28 2025-07-11 SH 851.0 ... 1.944771 SH509 SH
29 2025-07-11 CU 78733.33 ... -0.002583 cu2508 cu
30 2025-07-11 AL 20806.67 ... -0.004406 al2508 al
31 2025-07-11 ZN 22404.0 ... -0.000179 zn2508 zn
32 2025-07-11 PB 16993.75 ... 0.006547 pb2508 pb
33 2025-07-11 NI 122500.0 ... -0.010694 ni2508 ni
34 2025-07-11 SN 266737.5 ... -0.004152 sn2508 sn
35 2025-07-11 AU 770.24 ... 0.003817 au2510 au
36 2025-07-11 AG 9005.0 ... 0.001333 ag2510 ag
37 2025-07-11 RB 3164.5 ... -0.009954 rb2510 rb
38 2025-07-11 WR 3355.0 ... 0.002385 wr2510 wr
39 2025-07-11 HC 3326.67 ... -0.016133 hc2510 hc
40 2025-07-11 FU 5362.5 ... -0.457716 fu2509 fu
41 2025-07-11 BU 3700.0 ... -0.025135 bu2509 bu
42 2025-07-11 RU 14416.67 ... -0.002197 ru2509 ru
43 2025-07-11 SP 5950.0 ... -0.121345 sp2509 sp
44 2025-07-11 SS 12887.5 ... -0.012997 ss2509 ss
45 2025-07-11 BR 11850.0 ... -0.022363 br2509 br
46 2025-07-11 SI 8940.0 ... -0.058166 SI2509 si
47 2025-07-11 LC 62966.67 ... 0.017999 LC2509 lc
[48 rows x 15 columns]
2025-07-15 16:25:43,545 - future_1d - INFO - save future_spot 2025-07-11 completed
2025-07-15 16:25:50,136 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-14, end_day=2025-07-14) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-14 C 2340.0 ... -0.020085 c2509 c
1 2025-07-14 A 4295.0 ... -0.041676 a2509 a
2 2025-07-14 M 2912.0 ... 0.022321 m2509 m
3 2025-07-14 Y 8254.0 ... -0.032227 y2509 y
4 2025-07-14 P 8890.0 ... -0.021147 p2509 p
5 2025-07-14 JD 2875.0 ... 0.25113 jd2509 jd
6 2025-07-14 L 7411.67 ... -0.017226 l2509 l
7 2025-07-14 V 4720.0 ... 0.056144 v2509 v
8 2025-07-14 PP 7355.0 ... -0.039429 pp2509 pp
9 2025-07-14 JM 1248.75 ... -0.267267 jm2509 jm
10 2025-07-14 I 764.0 ... 0.002618 i2509 i
11 2025-07-14 EG 4410.0 ... -0.017914 eg2509 eg
12 2025-07-14 EB 7936.0 ... -0.059098 eb2508 eb
13 2025-07-14 PG 4817.5 ... -0.131915 pg2508 pg
14 2025-07-14 LH 14730.0 ... -0.032926 lh2509 lh
15 2025-07-14 BZ 5908.67 ... 0.050829 bz2603 bz
16 2025-07-14 CF 15312.67 ... -0.092255 CF509 CF
17 2025-07-14 SR 6050.0 ... -0.03719 SR509 SR
18 2025-07-14 TA 4789.84 ... -0.013328 TA509 TA
19 2025-07-14 FG 1128.0 ... -0.036348 FG509 FG
20 2025-07-14 RM 2566.67 ... 0.027401 RM509 RM
21 2025-07-14 SF 5202.86 ... 0.052498 SF509 SF
22 2025-07-14 SM 5630.0 ... 0.023801 SM509 SM
23 2025-07-14 CY 23200.0 ... -0.132543 CY509 CY
24 2025-07-14 UR 1838.75 ... -0.042284 UR509 UR
25 2025-07-14 SA 1247.5 ... -0.020441 SA509 SA
26 2025-07-14 PF 6667.08 ... -0.03826 PF509 PF
27 2025-07-14 PX 7250.0 ... -0.069241 PX509 PX
28 2025-07-14 SH 861.0 ... 1.934959 SH509 SH
29 2025-07-14 CU 78513.33 ... -0.002844 cu2508 cu
30 2025-07-14 AL 20806.67 ... -0.020506 al2509 al
31 2025-07-14 ZN 22154.0 ... 0.001399 zn2509 zn
32 2025-07-14 PB 16937.5 ... 0.007232 pb2508 pb
33 2025-07-14 NI 122100.0 ... -0.009746 ni2509 ni
34 2025-07-14 SN 266512.5 ... -0.001098 sn2508 sn
35 2025-07-14 AU 770.24 ... 0.010646 au2510 au
36 2025-07-14 AG 9005.0 ... 0.0191 ag2510 ag
37 2025-07-14 RB 3180.0 ... -0.015409 rb2510 rb
38 2025-07-14 WR 3345.0 ... 0.02272 wr2510 wr
39 2025-07-14 HC 3333.33 ... -0.019299 hc2510 hc
40 2025-07-14 FU 5387.5 ... -0.45819 fu2509 fu
41 2025-07-14 BU 3720.0 ... -0.023925 bu2509 bu
42 2025-07-14 RU 14386.67 ... -0.005677 ru2509 ru
43 2025-07-14 SP 5950.0 ... -0.120672 sp2509 sp
44 2025-07-14 SS 12900.0 ... -0.015504 ss2509 ss
45 2025-07-14 BR 11850.0 ... -0.025738 br2509 br
46 2025-07-14 SI 9140.0 ... -0.065098 SI2509 si
47 2025-07-14 LC 63000.0 ... 0.055873 LC2509 lc
[48 rows x 15 columns]
2025-07-15 16:25:50,292 - future_1d - INFO - save future_spot 2025-07-14 completed
2025-07-15 16:25:59,383 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-15, end_day=2025-07-15) done
2025-07-15 16:25:59,398 - future_1d - INFO - save future_spot 2025-07-15 failed
=========================================================================
2025-07-15 18:25:44 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-07-15 18:25:45,926 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-15 18:25:46,245 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-09, end_day=2025-07-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-09 C 2357.14 ... -0.014908 c2509 c
1 2025-07-09 A 4295.0 ... -0.042608 a2509 a
2 2025-07-09 M 2882.0 ... 0.020125 m2509 m
3 2025-07-09 Y 8182.0 ... -0.031777 y2509 y
4 2025-07-09 P 8874.0 ... -0.024566 p2509 p
5 2025-07-09 JD 2750.0 ... 0.303636 jd2509 jd
6 2025-07-09 L 7411.67 ... -0.020868 l2509 l
7 2025-07-09 V 4688.0 ... 0.051408 v2509 v
8 2025-07-09 PP 7376.67 ... -0.043471 pp2509 pp
9 2025-07-09 JM 1236.25 ... -0.303943 jm2509 jm
10 2025-07-09 I 739.0 ... -0.003383 i2509 i
11 2025-07-09 EG 4393.33 ... -0.026934 eg2509 eg
12 2025-07-09 EB 7908.0 ... -0.074355 eb2508 eb
13 2025-07-09 PG 4870.0 ... -0.142094 pg2508 pg
14 2025-07-09 LH 14900.0 ... -0.045638 lh2509 lh
15 2025-07-09 BZ 5818.67 ... 0.033741 bz2603 bz
16 2025-07-09 CF 15188.83 ... -0.093413 CF509 CF
17 2025-07-09 SR 6050.0 ... -0.047438 SR509 SR
18 2025-07-09 TA 4852.5 ... -0.028542 TA509 TA
19 2025-07-09 FG 1122.4 ... -0.083215 FG509 FG
20 2025-07-09 RM 2505.0 ... 0.027146 RM509 RM
21 2025-07-09 SF 5138.57 ... 0.046984 SF509 SF
22 2025-07-09 SM 5546.0 ... 0.024522 SM509 SM
23 2025-07-09 CY 23200.0 ... -0.141595 CY509 CY
24 2025-07-09 UR 1843.0 ... -0.039067 UR509 UR
25 2025-07-09 SA 1247.5 ... -0.048497 SA509 SA
26 2025-07-09 PF 6702.71 ... -0.043372 PF509 PF
27 2025-07-09 PX 7250.0 ... -0.073655 PX509 PX
28 2025-07-09 SH 841.0 ... 1.876338 SH509 SH
29 2025-07-09 CU 79245.0 ... -0.004227 cu2508 cu
30 2025-07-09 AL 20680.0 ... -0.007979 al2508 al
31 2025-07-09 ZN 22144.0 ... -0.00289 zn2508 zn
32 2025-07-09 PB 17087.5 ... 0.006584 pb2508 pb
33 2025-07-09 NI 120516.67 ... -0.008768 ni2508 ni
34 2025-07-09 SN 265262.5 ... -0.00638 sn2508 sn
35 2025-07-09 AU 767.05 ... 0.00322 au2510 au
36 2025-07-09 AG 8873.67 ... 0.002855 ag2510 ag
37 2025-07-09 RB 3112.5 ... -0.015261 rb2510 rb
38 2025-07-09 WR 3300.0 ... 0.01 wr2601 wr
39 2025-07-09 HC 3276.67 ... -0.025535 hc2510 hc
40 2025-07-09 FU 5412.5 ... -0.449053 fu2509 fu
41 2025-07-09 BU 3696.67 ... -0.021011 bu2509 bu
42 2025-07-09 RU 13908.33 ... 0.006951 ru2509 ru
43 2025-07-09 SP 5900.0 ... -0.13661 sp2509 sp
44 2025-07-09 SS 12887.5 ... -0.012221 ss2508 ss
45 2025-07-09 BR 11690.0 ... -0.038067 br2509 br
46 2025-07-09 SI 8910.0 ... -0.083614 SI2509 si
47 2025-07-09 LC 62600.0 ... 0.029712 LC2509 lc
[48 rows x 15 columns]
2025-07-15 18:25:46,421 - future_1d - INFO - save future_spot 2025-07-09 completed
2025-07-15 18:25:54,131 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-10, end_day=2025-07-10) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-10 C 2354.29 ... -0.015414 c2509 c
1 2025-07-10 A 4295.0 ... -0.043073 a2509 a
2 2025-07-10 M 2888.0 ... 0.019044 m2509 m
3 2025-07-10 Y 8214.0 ... -0.034819 y2509 y
4 2025-07-10 P 8836.0 ... -0.02354 p2509 p
5 2025-07-10 JD 2750.0 ... 0.298909 jd2509 jd
6 2025-07-10 L 7415.0 ... -0.014295 l2509 l
7 2025-07-10 V 4768.0 ... 0.049706 v2509 v
8 2025-07-10 PP 7360.0 ... -0.03519 pp2509 pp
9 2025-07-10 JM 1241.25 ... -0.288218 jm2509 jm
10 2025-07-10 I 748.44 ... 0.002752 i2509 i
11 2025-07-10 EG 4393.33 ... -0.01965 eg2509 eg
12 2025-07-10 EB 7908.0 ... -0.059686 eb2508 eb
13 2025-07-10 PG 4882.5 ... -0.13999 pg2508 pg
14 2025-07-10 LH 14830.0 ... -0.033715 lh2509 lh
15 2025-07-10 BZ 5835.33 ... 0.065064 bz2603 bz
16 2025-07-10 CF 15201.0 ... -0.087889 CF509 CF
17 2025-07-10 SR 6046.67 ... -0.040794 SR509 SR
18 2025-07-10 TA 4852.5 ... -0.025657 TA509 TA
19 2025-07-10 FG 1122.4 ... -0.052922 FG509 FG
20 2025-07-10 RM 2523.33 ... 0.028403 RM509 RM
21 2025-07-10 SF 5178.57 ... 0.068249 SF509 SF
22 2025-07-10 SM 5622.0 ... 0.030238 SM509 SM
23 2025-07-10 CY 23200.0 ... -0.137716 CY509 CY
24 2025-07-10 UR 1845.0 ... -0.036856 UR509 UR
25 2025-07-10 SA 1247.5 ... -0.027655 SA509 SA
26 2025-07-10 PF 6700.5 ... -0.039773 PF509 PF
27 2025-07-10 PX 7250.0 ... -0.068966 PX509 PX
28 2025-07-10 SH 847.0 ... 1.945691 SH509 SH
29 2025-07-10 CU 78678.33 ... -0.003665 cu2508 cu
30 2025-07-10 AL 20680.0 ... -0.000484 al2508 al
31 2025-07-10 ZN 22376.0 ... -0.004067 zn2508 zn
32 2025-07-10 PB 17093.75 ... 0.007093 pb2508 pb
33 2025-07-10 NI 120916.67 ... -0.008325 ni2508 ni
34 2025-07-10 SN 265075.0 ... -0.000283 sn2508 sn
35 2025-07-10 AU 767.05 ... 0.005358 au2510 au
36 2025-07-10 AG 8873.67 ... 0.001277 ag2510 ag
37 2025-07-10 RB 3138.5 ... -0.012586 rb2510 rb
38 2025-07-10 WR 3315.0 ... 0.004223 wr2601 wr
39 2025-07-10 HC 3290.0 ... -0.017325 hc2510 hc
40 2025-07-10 FU 5400.0 ... -0.451481 fu2509 fu
41 2025-07-10 BU 3690.0 ... -0.017615 bu2509 bu
42 2025-07-10 RU 14466.67 ... -0.015668 ru2509 ru
43 2025-07-10 SP 5933.33 ... -0.129325 sp2509 sp
44 2025-07-10 SS 12887.5 ... -0.005626 ss2508 ss
45 2025-07-10 BR 11810.0 ... -0.033023 br2509 br
46 2025-07-10 SI 8920.0 ... -0.061099 SI2509 si
47 2025-07-10 LC 62766.67 ... 0.026978 LC2509 lc
[48 rows x 15 columns]
2025-07-15 18:25:54,295 - future_1d - INFO - save future_spot 2025-07-10 completed
2025-07-15 18:25:58,925 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-11, end_day=2025-07-11) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-11 C 2351.43 ... -0.016769 c2509 c
1 2025-07-11 A 4295.0 ... -0.045867 a2509 a
2 2025-07-11 M 2924.0 ... 0.016074 m2509 m
3 2025-07-11 Y 8254.0 ... -0.034408 y2509 y
4 2025-07-11 P 8944.0 ... -0.028846 p2509 p
5 2025-07-11 JD 2775.0 ... 0.290811 jd2509 jd
6 2025-07-11 L 7416.67 ... -0.015461 l2509 l
7 2025-07-11 V 4733.0 ... 0.059159 v2509 v
8 2025-07-11 PP 7355.0 ... -0.037933 pp2509 pp
9 2025-07-11 JM 1241.25 ... -0.267271 jm2509 jm
10 2025-07-11 I 762.56 ... 0.002544 i2509 i
11 2025-07-11 EG 4405.0 ... -0.019977 eg2509 eg
12 2025-07-11 EB 7908.0 ... -0.055893 eb2508 eb
13 2025-07-11 PG 4875.0 ... -0.145846 pg2508 pg
14 2025-07-11 LH 14820.0 ... -0.031714 lh2509 lh
15 2025-07-11 BZ 5878.67 ... 0.061124 bz2603 bz
16 2025-07-11 CF 15282.0 ... -0.090106 CF509 CF
17 2025-07-11 SR 6046.67 ... -0.039471 SR509 SR
18 2025-07-11 TA 4852.5 ... -0.029366 TA509 TA
19 2025-07-11 FG 1128.0 ... -0.033688 FG509 FG
20 2025-07-11 RM 2551.67 ... 0.030698 RM509 RM
21 2025-07-11 SF 5217.14 ... 0.058434 SF509 SF
22 2025-07-11 SM 5630.0 ... 0.025577 SM509 SM
23 2025-07-11 CY 23200.0 ... -0.134914 CY509 CY
24 2025-07-11 UR 1861.25 ... -0.045803 UR509 UR
25 2025-07-11 SA 1247.5 ... -0.018036 SA509 SA
26 2025-07-11 PF 6668.46 ... -0.040258 PF509 PF
27 2025-07-11 PX 7250.0 ... -0.073103 PX509 PX
28 2025-07-11 SH 851.0 ... 1.944771 SH509 SH
29 2025-07-11 CU 78733.33 ... -0.002583 cu2508 cu
30 2025-07-11 AL 20806.67 ... -0.004406 al2508 al
31 2025-07-11 ZN 22404.0 ... -0.000179 zn2508 zn
32 2025-07-11 PB 16993.75 ... 0.006547 pb2508 pb
33 2025-07-11 NI 122500.0 ... -0.010694 ni2508 ni
34 2025-07-11 SN 266737.5 ... -0.004152 sn2508 sn
35 2025-07-11 AU 770.24 ... 0.003817 au2510 au
36 2025-07-11 AG 9005.0 ... 0.001333 ag2510 ag
37 2025-07-11 RB 3164.5 ... -0.009954 rb2510 rb
38 2025-07-11 WR 3355.0 ... 0.002385 wr2510 wr
39 2025-07-11 HC 3326.67 ... -0.016133 hc2510 hc
40 2025-07-11 FU 5362.5 ... -0.457716 fu2509 fu
41 2025-07-11 BU 3700.0 ... -0.025135 bu2509 bu
42 2025-07-11 RU 14416.67 ... -0.002197 ru2509 ru
43 2025-07-11 SP 5950.0 ... -0.121345 sp2509 sp
44 2025-07-11 SS 12887.5 ... -0.012997 ss2509 ss
45 2025-07-11 BR 11850.0 ... -0.022363 br2509 br
46 2025-07-11 SI 8940.0 ... -0.058166 SI2509 si
47 2025-07-11 LC 62966.67 ... 0.017999 LC2509 lc
[48 rows x 15 columns]
2025-07-15 18:25:59,078 - future_1d - INFO - save future_spot 2025-07-11 completed
2025-07-15 18:26:06,073 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-14, end_day=2025-07-14) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-14 C 2340.0 ... -0.020085 c2509 c
1 2025-07-14 A 4295.0 ... -0.041676 a2509 a
2 2025-07-14 M 2912.0 ... 0.022321 m2509 m
3 2025-07-14 Y 8254.0 ... -0.032227 y2509 y
4 2025-07-14 P 8890.0 ... -0.021147 p2509 p
5 2025-07-14 JD 2875.0 ... 0.25113 jd2509 jd
6 2025-07-14 L 7411.67 ... -0.017226 l2509 l
7 2025-07-14 V 4720.0 ... 0.056144 v2509 v
8 2025-07-14 PP 7355.0 ... -0.039429 pp2509 pp
9 2025-07-14 JM 1248.75 ... -0.267267 jm2509 jm
10 2025-07-14 I 764.0 ... 0.002618 i2509 i
11 2025-07-14 EG 4410.0 ... -0.017914 eg2509 eg
12 2025-07-14 EB 7936.0 ... -0.059098 eb2508 eb
13 2025-07-14 PG 4817.5 ... -0.131915 pg2508 pg
14 2025-07-14 LH 14730.0 ... -0.032926 lh2509 lh
15 2025-07-14 BZ 5908.67 ... 0.050829 bz2603 bz
16 2025-07-14 CF 15312.67 ... -0.092255 CF509 CF
17 2025-07-14 SR 6050.0 ... -0.03719 SR509 SR
18 2025-07-14 TA 4789.84 ... -0.013328 TA509 TA
19 2025-07-14 FG 1128.0 ... -0.036348 FG509 FG
20 2025-07-14 RM 2566.67 ... 0.027401 RM509 RM
21 2025-07-14 SF 5202.86 ... 0.052498 SF509 SF
22 2025-07-14 SM 5630.0 ... 0.023801 SM509 SM
23 2025-07-14 CY 23200.0 ... -0.132543 CY509 CY
24 2025-07-14 UR 1838.75 ... -0.042284 UR509 UR
25 2025-07-14 SA 1247.5 ... -0.020441 SA509 SA
26 2025-07-14 PF 6667.08 ... -0.03826 PF509 PF
27 2025-07-14 PX 7250.0 ... -0.069241 PX509 PX
28 2025-07-14 SH 861.0 ... 1.934959 SH509 SH
29 2025-07-14 CU 78513.33 ... -0.002844 cu2508 cu
30 2025-07-14 AL 20806.67 ... -0.020506 al2509 al
31 2025-07-14 ZN 22154.0 ... 0.001399 zn2509 zn
32 2025-07-14 PB 16937.5 ... 0.007232 pb2508 pb
33 2025-07-14 NI 122100.0 ... -0.009746 ni2509 ni
34 2025-07-14 SN 266512.5 ... -0.001098 sn2508 sn
35 2025-07-14 AU 770.24 ... 0.010646 au2510 au
36 2025-07-14 AG 9005.0 ... 0.0191 ag2510 ag
37 2025-07-14 RB 3180.0 ... -0.015409 rb2510 rb
38 2025-07-14 WR 3345.0 ... 0.02272 wr2510 wr
39 2025-07-14 HC 3333.33 ... -0.019299 hc2510 hc
40 2025-07-14 FU 5387.5 ... -0.45819 fu2509 fu
41 2025-07-14 BU 3720.0 ... -0.023925 bu2509 bu
42 2025-07-14 RU 14386.67 ... -0.005677 ru2509 ru
43 2025-07-14 SP 5950.0 ... -0.120672 sp2509 sp
44 2025-07-14 SS 12900.0 ... -0.015504 ss2509 ss
45 2025-07-14 BR 11850.0 ... -0.025738 br2509 br
46 2025-07-14 SI 9140.0 ... -0.065098 SI2509 si
47 2025-07-14 LC 63000.0 ... 0.055873 LC2509 lc
[48 rows x 15 columns]
2025-07-15 18:26:06,227 - future_1d - INFO - save future_spot 2025-07-14 completed
2025-07-15 18:26:10,557 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-15, end_day=2025-07-15) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-15 C 2331.43 ... -0.013052 c2509 c
1 2025-07-15 A 4295.0 ... -0.03539 a2509 a
2 2025-07-15 M 2924.0 ... 0.021204 m2509 m
3 2025-07-15 Y 8264.0 ... -0.030494 y2509 y
4 2025-07-15 P 8844.0 ... -0.010176 p2509 p
5 2025-07-15 JD 2875.0 ... 0.256 jd2509 jd
6 2025-07-15 L 7393.33 ... -0.020333 l2509 l
7 2025-07-15 V 4745.0 ... 0.051844 v2509 v
8 2025-07-15 PP 7366.67 ... -0.044887 pp2509 pp
9 2025-07-15 JM 1248.75 ... -0.270871 jm2509 jm
10 2025-07-15 I 765.0 ... 0.0 i2509 i
11 2025-07-15 EG 4405.0 ... -0.01521 eg2509 eg
12 2025-07-15 EB 7956.0 ... -0.070513 eb2508 eb
13 2025-07-15 PG 4785.0 ... -0.151724 pg2509 pg
14 2025-07-15 LH 14670.0 ... -0.026585 lh2509 lh
15 2025-07-15 BZ 5898.67 ... 0.04532 bz2603 bz
16 2025-07-15 CF 15327.5 ... -0.0977 CF509 CF
17 2025-07-15 SR 6043.33 ... -0.039933 SR509 SR
18 2025-07-15 TA 4735.66 ... -0.005841 TA509 TA
19 2025-07-15 FG 1142.4 ... -0.052871 FG509 FG
20 2025-07-15 RM 2581.67 ... 0.029179 RM509 RM
21 2025-07-15 SF 5202.86 ... 0.057495 SF509 SF
22 2025-07-15 SM 5644.0 ... 0.027286 SM509 SM
23 2025-07-15 CY 23275.0 ... -0.138561 CY509 CY
24 2025-07-15 UR 1837.5 ... -0.05415 UR509 UR
25 2025-07-15 SA 1247.5 ... -0.017234 SA509 SA
26 2025-07-15 PF 6646.46 ... -0.038586 PF509 PF
27 2025-07-15 PX 7250.0 ... -0.073655 PX509 PX
28 2025-07-15 SH 861.0 ... 1.925668 SH509 SH
29 2025-07-15 CU 78135.0 ... -0.002624 cu2508 cu
30 2025-07-15 AL 20523.33 ... -0.007715 al2509 al
31 2025-07-15 ZN 22118.0 ... -0.000588 zn2509 zn
32 2025-07-15 PB 16925.0 ... 0.005022 pb2508 pb
33 2025-07-15 NI 120666.67 ... -0.008923 ni2509 ni
34 2025-07-15 SN 264687.5 ... -0.003617 sn2508 sn
35 2025-07-15 AU 774.93 ... 0.004246 au2510 au
36 2025-07-15 AG 9149.67 ... 0.003752 ag2510 ag
37 2025-07-15 RB 3173.0 ... -0.016388 rb2510 rb
38 2025-07-15 WR 3345.0 ... 0.006278 wr2510 wr
39 2025-07-15 HC 3333.33 ... -0.021099 hc2510 hc
40 2025-07-15 FU 5387.5 ... -0.467842 fu2509 fu
41 2025-07-15 BU 3720.0 ... -0.023925 bu2509 bu
42 2025-07-15 RU 14508.33 ... -0.006088 ru2509 ru
43 2025-07-15 SP 5950.0 ... -0.119328 sp2509 sp
44 2025-07-15 SS 12900.0 ... -0.016667 ss2509 ss
45 2025-07-15 BR 11850.0 ... -0.025316 br2509 br
46 2025-07-15 SI 9330.0 ... -0.060557 SI2509 si
47 2025-07-15 LC 63733.33 ... 0.038075 LC2509 lc
[48 rows x 15 columns]
2025-07-15 18:26:10,724 - future_1d - INFO - save future_spot 2025-07-15 add
2025-07-15 18:26:10,731 - future_1d - INFO - 0 ... 4
date 2025-07-15 ... 2025-07-15
variety C ... P
spot_price 2331.43 ... 8844.0
near_contract c2509 ... p2508
near_contract_price 2301.0 ... 8768.0
dominant_contract c2509 ... p2509
dominant_contract_price 2301.0 ... 8754.0
near_month 2509 ... 2508
dominant_month 2509 ... 2509
near_basis -30.43 ... -76.0
dom_basis -30.43 ... -90.0
near_basis_rate -0.0131 ... -0.0086
dom_basis_rate -0.0131 ... -0.0102
symbol c2509 ... p2509
comd c ... p
created_at 2025-07-15 18:26:10.688390 ... 2025-07-15 18:26:10.688390
updated_at 2025-07-15 18:26:10.688799 ... 2025-07-15 18:26:10.688799
[17 rows x 5 columns]