=========================================================================
2025-07-17 16:25:16 Thu START TASK.01 future_1d future_spot
=========================================================================
2025-07-17 16:25:17,944 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-17 16:25:18,285 - 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 OI 9568.33 ... -0.011844 OI509 OI
20 2025-07-11 MA 2378.33 ... 0.000702 MA509 MA
21 2025-07-11 FG 1128.0 ... -0.033688 FG509 FG
22 2025-07-11 RM 2551.67 ... 0.030698 RM509 RM
23 2025-07-11 SF 5217.14 ... 0.058434 SF509 SF
24 2025-07-11 SM 5630.0 ... 0.025577 SM509 SM
25 2025-07-11 CY 23200.0 ... -0.134914 CY509 CY
26 2025-07-11 UR 1861.25 ... -0.045803 UR509 UR
27 2025-07-11 SA 1247.5 ... -0.018036 SA509 SA
28 2025-07-11 PF 6668.46 ... -0.040258 PF509 PF
29 2025-07-11 PX 7250.0 ... -0.073103 PX509 PX
30 2025-07-11 SH 851.0 ... 1.944771 SH509 SH
31 2025-07-11 CU 78733.33 ... -0.002583 cu2508 cu
32 2025-07-11 AL 20806.67 ... -0.004406 al2508 al
33 2025-07-11 ZN 22404.0 ... -0.000179 zn2508 zn
34 2025-07-11 PB 16993.75 ... 0.006547 pb2508 pb
35 2025-07-11 NI 122500.0 ... -0.010694 ni2508 ni
36 2025-07-11 SN 266737.5 ... -0.004152 sn2508 sn
37 2025-07-11 AU 770.24 ... 0.003817 au2510 au
38 2025-07-11 AG 9005.0 ... 0.001333 ag2510 ag
39 2025-07-11 RB 3164.5 ... -0.009954 rb2510 rb
40 2025-07-11 WR 3355.0 ... 0.002385 wr2510 wr
41 2025-07-11 HC 3326.67 ... -0.016133 hc2510 hc
42 2025-07-11 FU 5362.5 ... -0.457716 fu2509 fu
43 2025-07-11 BU 3700.0 ... -0.025135 bu2509 bu
44 2025-07-11 RU 14416.67 ... -0.002197 ru2509 ru
45 2025-07-11 SP 5950.0 ... -0.121345 sp2509 sp
46 2025-07-11 SS 12887.5 ... -0.012997 ss2509 ss
47 2025-07-11 BR 11850.0 ... -0.022363 br2509 br
48 2025-07-11 SI 8940.0 ... -0.058166 SI2509 si
49 2025-07-11 LC 62966.67 ... 0.017999 LC2509 lc
[50 rows x 15 columns]
2025-07-17 16:25:18,464 - future_1d - INFO - save future_spot 2025-07-11 completed
2025-07-17 16:25:28,244 - 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 OI 9541.67 ... -0.013485 OI509 OI
20 2025-07-14 MA 2390.0 ... -0.001255 MA509 MA
21 2025-07-14 FG 1128.0 ... -0.036348 FG509 FG
22 2025-07-14 RM 2566.67 ... 0.027401 RM509 RM
23 2025-07-14 SF 5202.86 ... 0.052498 SF509 SF
24 2025-07-14 SM 5630.0 ... 0.023801 SM509 SM
25 2025-07-14 CY 23200.0 ... -0.132543 CY509 CY
26 2025-07-14 UR 1838.75 ... -0.042284 UR509 UR
27 2025-07-14 SA 1247.5 ... -0.020441 SA509 SA
28 2025-07-14 PF 6667.08 ... -0.03826 PF509 PF
29 2025-07-14 PX 7250.0 ... -0.069241 PX509 PX
30 2025-07-14 SH 861.0 ... 1.934959 SH509 SH
31 2025-07-14 CU 78513.33 ... -0.002844 cu2508 cu
32 2025-07-14 AL 20806.67 ... -0.020506 al2509 al
33 2025-07-14 ZN 22154.0 ... 0.001399 zn2509 zn
34 2025-07-14 PB 16937.5 ... 0.007232 pb2508 pb
35 2025-07-14 NI 122100.0 ... -0.009746 ni2509 ni
36 2025-07-14 SN 266512.5 ... -0.001098 sn2508 sn
37 2025-07-14 AU 770.24 ... 0.010646 au2510 au
38 2025-07-14 AG 9005.0 ... 0.0191 ag2510 ag
39 2025-07-14 RB 3180.0 ... -0.015409 rb2510 rb
40 2025-07-14 WR 3345.0 ... 0.02272 wr2510 wr
41 2025-07-14 HC 3333.33 ... -0.019299 hc2510 hc
42 2025-07-14 FU 5387.5 ... -0.45819 fu2509 fu
43 2025-07-14 BU 3720.0 ... -0.023925 bu2509 bu
44 2025-07-14 RU 14386.67 ... -0.005677 ru2509 ru
45 2025-07-14 SP 5950.0 ... -0.120672 sp2509 sp
46 2025-07-14 SS 12900.0 ... -0.015504 ss2509 ss
47 2025-07-14 BR 11850.0 ... -0.025738 br2509 br
48 2025-07-14 SI 9140.0 ... -0.065098 SI2509 si
49 2025-07-14 LC 63000.0 ... 0.055873 LC2509 lc
[50 rows x 15 columns]
2025-07-17 16:25:28,399 - future_1d - INFO - save future_spot 2025-07-14 completed
2025-07-17 16:25:36,834 - 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 OI 9533.33 ... -0.009685 OI509 OI
20 2025-07-15 MA 2390.0 ... 0.000837 MA509 MA
21 2025-07-15 FG 1142.4 ... -0.052871 FG509 FG
22 2025-07-15 RM 2581.67 ... 0.029179 RM509 RM
23 2025-07-15 SF 5202.86 ... 0.057495 SF509 SF
24 2025-07-15 SM 5644.0 ... 0.027286 SM509 SM
25 2025-07-15 CY 23275.0 ... -0.138561 CY509 CY
26 2025-07-15 UR 1837.5 ... -0.05415 UR509 UR
27 2025-07-15 SA 1247.5 ... -0.017234 SA509 SA
28 2025-07-15 PF 6646.46 ... -0.038586 PF509 PF
29 2025-07-15 PX 7250.0 ... -0.073655 PX509 PX
30 2025-07-15 SH 861.0 ... 1.925668 SH509 SH
31 2025-07-15 CU 78135.0 ... -0.002624 cu2508 cu
32 2025-07-15 AL 20523.33 ... -0.007715 al2509 al
33 2025-07-15 ZN 22118.0 ... -0.000588 zn2509 zn
34 2025-07-15 PB 16925.0 ... 0.005022 pb2508 pb
35 2025-07-15 NI 120666.67 ... -0.008923 ni2509 ni
36 2025-07-15 SN 264687.5 ... -0.003617 sn2508 sn
37 2025-07-15 AU 774.93 ... 0.004246 au2510 au
38 2025-07-15 AG 9149.67 ... 0.003752 ag2510 ag
39 2025-07-15 RB 3173.0 ... -0.016388 rb2510 rb
40 2025-07-15 WR 3345.0 ... 0.006278 wr2510 wr
41 2025-07-15 HC 3333.33 ... -0.021099 hc2510 hc
42 2025-07-15 FU 5387.5 ... -0.467842 fu2509 fu
43 2025-07-15 BU 3720.0 ... -0.023925 bu2509 bu
44 2025-07-15 RU 14508.33 ... -0.006088 ru2509 ru
45 2025-07-15 SP 5950.0 ... -0.119328 sp2509 sp
46 2025-07-15 SS 12900.0 ... -0.016667 ss2509 ss
47 2025-07-15 BR 11850.0 ... -0.025316 br2509 br
48 2025-07-15 SI 9330.0 ... -0.060557 SI2509 si
49 2025-07-15 LC 63733.33 ... 0.038075 LC2509 lc
[50 rows x 15 columns]
2025-07-17 16:25:36,994 - future_1d - INFO - save future_spot 2025-07-15 completed
2025-07-17 16:25:40,578 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-16, end_day=2025-07-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-16 C 2327.14 ... -0.014241 c2509 c
1 2025-07-16 A 4295.0 ... -0.030035 a2509 a
2 2025-07-16 M 2916.0 ... 0.021262 m2509 m
3 2025-07-16 Y 8304.0 ... -0.032755 y2509 y
4 2025-07-16 P 8864.0 ... -0.016245 p2509 p
5 2025-07-16 JD 2885.0 ... 0.249567 jd2509 jd
6 2025-07-16 L 7393.33 ... -0.02412 l2509 l
7 2025-07-16 V 4736.0 ... 0.045186 v2509 v
8 2025-07-16 PP 7358.33 ... -0.046795 pp2509 pp
9 2025-07-16 JM 1248.75 ... -0.275676 jm2509 jm
10 2025-07-16 I 765.0 ... 0.008497 i2509 i
11 2025-07-16 EG 4405.0 ... -0.016345 eg2509 eg
12 2025-07-16 EB 7946.0 ... -0.087214 eb2509 eb
13 2025-07-16 PG 4747.5 ... -0.153449 pg2509 pg
14 2025-07-16 LH 14600.0 ... -0.034247 lh2509 lh
15 2025-07-16 BZ 5885.33 ... 0.045481 bz2603 bz
16 2025-07-16 CF 15291.33 ... -0.088045 CF509 CF
17 2025-07-16 SR 6043.33 ... -0.039602 SR509 SR
18 2025-07-16 TA 4735.66 ... -0.005841 TA509 TA
19 2025-07-16 OI 9581.67 ... -0.013429 OI509 OI
20 2025-07-16 MA 2381.67 ... -0.002381 MA509 MA
21 2025-07-16 FG 1142.4 ... -0.065126 FG509 FG
22 2025-07-16 RM 2576.67 ... 0.0304 RM509 RM
23 2025-07-16 SF 5202.86 ... 0.047885 SF509 SF
24 2025-07-16 SM 5630.0 ... 0.023801 SM509 SM
25 2025-07-16 CY 23275.0 ... -0.134909 CY509 CY
26 2025-07-16 UR 1827.5 ... -0.051163 UR509 UR
27 2025-07-16 SA 1247.5 ... -0.029259 SA509 SA
28 2025-07-16 PF 6633.96 ... -0.041297 PF509 PF
29 2025-07-16 PX 7250.0 ... -0.072828 PX509 PX
30 2025-07-16 SH 861.0 ... 1.898955 SH509 SH
31 2025-07-16 CU 78096.67 ... -0.00175 cu2508 cu
32 2025-07-16 AL 20540.0 ... -0.006816 al2509 al
33 2025-07-16 ZN 22018.0 ... -0.000818 zn2509 zn
34 2025-07-16 PB 16825.0 ... 0.00416 pb2508 pb
35 2025-07-16 NI 122216.67 ... -0.012328 ni2509 ni
36 2025-07-16 SN 263625.0 ... -0.000588 sn2508 sn
37 2025-07-16 AU 771.38 ... 0.006637 au2510 au
38 2025-07-16 AG 9113.0 ... 0.005157 ag2510 ag
39 2025-07-16 RB 3172.0 ... -0.020177 rb2510 rb
40 2025-07-16 WR 3345.0 ... 0.003587 wr2510 wr
41 2025-07-16 HC 3326.67 ... -0.022446 hc2510 hc
42 2025-07-16 FU 5387.5 ... -0.4671 fu2509 fu
43 2025-07-16 BU 3713.33 ... -0.025942 bu2509 bu
44 2025-07-16 RU 14516.67 ... -0.007693 ru2509 ru
45 2025-07-16 SP 5916.67 ... -0.114367 sp2509 sp
46 2025-07-16 SS 12950.0 ... -0.020077 ss2509 ss
47 2025-07-16 BR 11850.0 ... -0.036287 br2509 br
48 2025-07-16 SI 9380.0 ... -0.074627 SI2509 si
49 2025-07-16 LC 64100.0 ... 0.034633 LC2509 lc
[50 rows x 15 columns]
2025-07-17 16:25:40,739 - future_1d - INFO - save future_spot 2025-07-16 completed
2025-07-17 16:25:45,092 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-17, end_day=2025-07-17) done
2025-07-17 16:25:45,107 - future_1d - INFO - save future_spot 2025-07-17 failed
=========================================================================
2025-07-17 18:25:29 Thu START TASK.01 future_1d future_spot
=========================================================================
2025-07-17 18:25:31,387 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-17 18:25:31,723 - 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 OI 9568.33 ... -0.011844 OI509 OI
20 2025-07-11 MA 2378.33 ... 0.000702 MA509 MA
21 2025-07-11 FG 1128.0 ... -0.033688 FG509 FG
22 2025-07-11 RM 2551.67 ... 0.030698 RM509 RM
23 2025-07-11 SF 5217.14 ... 0.058434 SF509 SF
24 2025-07-11 SM 5630.0 ... 0.025577 SM509 SM
25 2025-07-11 CY 23200.0 ... -0.134914 CY509 CY
26 2025-07-11 UR 1861.25 ... -0.045803 UR509 UR
27 2025-07-11 SA 1247.5 ... -0.018036 SA509 SA
28 2025-07-11 PF 6668.46 ... -0.040258 PF509 PF
29 2025-07-11 PX 7250.0 ... -0.073103 PX509 PX
30 2025-07-11 SH 851.0 ... 1.944771 SH509 SH
31 2025-07-11 CU 78733.33 ... -0.002583 cu2508 cu
32 2025-07-11 AL 20806.67 ... -0.004406 al2508 al
33 2025-07-11 ZN 22404.0 ... -0.000179 zn2508 zn
34 2025-07-11 PB 16993.75 ... 0.006547 pb2508 pb
35 2025-07-11 NI 122500.0 ... -0.010694 ni2508 ni
36 2025-07-11 SN 266737.5 ... -0.004152 sn2508 sn
37 2025-07-11 AU 770.24 ... 0.003817 au2510 au
38 2025-07-11 AG 9005.0 ... 0.001333 ag2510 ag
39 2025-07-11 RB 3164.5 ... -0.009954 rb2510 rb
40 2025-07-11 WR 3355.0 ... 0.002385 wr2510 wr
41 2025-07-11 HC 3326.67 ... -0.016133 hc2510 hc
42 2025-07-11 FU 5362.5 ... -0.457716 fu2509 fu
43 2025-07-11 BU 3700.0 ... -0.025135 bu2509 bu
44 2025-07-11 RU 14416.67 ... -0.002197 ru2509 ru
45 2025-07-11 SP 5950.0 ... -0.121345 sp2509 sp
46 2025-07-11 SS 12887.5 ... -0.012997 ss2509 ss
47 2025-07-11 BR 11850.0 ... -0.022363 br2509 br
48 2025-07-11 SI 8940.0 ... -0.058166 SI2509 si
49 2025-07-11 LC 62966.67 ... 0.017999 LC2509 lc
[50 rows x 15 columns]
2025-07-17 18:25:31,897 - future_1d - INFO - save future_spot 2025-07-11 completed
2025-07-17 18:25:41,254 - 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 OI 9541.67 ... -0.013485 OI509 OI
20 2025-07-14 MA 2390.0 ... -0.001255 MA509 MA
21 2025-07-14 FG 1128.0 ... -0.036348 FG509 FG
22 2025-07-14 RM 2566.67 ... 0.027401 RM509 RM
23 2025-07-14 SF 5202.86 ... 0.052498 SF509 SF
24 2025-07-14 SM 5630.0 ... 0.023801 SM509 SM
25 2025-07-14 CY 23200.0 ... -0.132543 CY509 CY
26 2025-07-14 UR 1838.75 ... -0.042284 UR509 UR
27 2025-07-14 SA 1247.5 ... -0.020441 SA509 SA
28 2025-07-14 PF 6667.08 ... -0.03826 PF509 PF
29 2025-07-14 PX 7250.0 ... -0.069241 PX509 PX
30 2025-07-14 SH 861.0 ... 1.934959 SH509 SH
31 2025-07-14 CU 78513.33 ... -0.002844 cu2508 cu
32 2025-07-14 AL 20806.67 ... -0.020506 al2509 al
33 2025-07-14 ZN 22154.0 ... 0.001399 zn2509 zn
34 2025-07-14 PB 16937.5 ... 0.007232 pb2508 pb
35 2025-07-14 NI 122100.0 ... -0.009746 ni2509 ni
36 2025-07-14 SN 266512.5 ... -0.001098 sn2508 sn
37 2025-07-14 AU 770.24 ... 0.010646 au2510 au
38 2025-07-14 AG 9005.0 ... 0.0191 ag2510 ag
39 2025-07-14 RB 3180.0 ... -0.015409 rb2510 rb
40 2025-07-14 WR 3345.0 ... 0.02272 wr2510 wr
41 2025-07-14 HC 3333.33 ... -0.019299 hc2510 hc
42 2025-07-14 FU 5387.5 ... -0.45819 fu2509 fu
43 2025-07-14 BU 3720.0 ... -0.023925 bu2509 bu
44 2025-07-14 RU 14386.67 ... -0.005677 ru2509 ru
45 2025-07-14 SP 5950.0 ... -0.120672 sp2509 sp
46 2025-07-14 SS 12900.0 ... -0.015504 ss2509 ss
47 2025-07-14 BR 11850.0 ... -0.025738 br2509 br
48 2025-07-14 SI 9140.0 ... -0.065098 SI2509 si
49 2025-07-14 LC 63000.0 ... 0.055873 LC2509 lc
[50 rows x 15 columns]
2025-07-17 18:25:41,413 - future_1d - INFO - save future_spot 2025-07-14 completed
2025-07-17 18:25:48,526 - 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 OI 9533.33 ... -0.009685 OI509 OI
20 2025-07-15 MA 2390.0 ... 0.000837 MA509 MA
21 2025-07-15 FG 1142.4 ... -0.052871 FG509 FG
22 2025-07-15 RM 2581.67 ... 0.029179 RM509 RM
23 2025-07-15 SF 5202.86 ... 0.057495 SF509 SF
24 2025-07-15 SM 5644.0 ... 0.027286 SM509 SM
25 2025-07-15 CY 23275.0 ... -0.138561 CY509 CY
26 2025-07-15 UR 1837.5 ... -0.05415 UR509 UR
27 2025-07-15 SA 1247.5 ... -0.017234 SA509 SA
28 2025-07-15 PF 6646.46 ... -0.038586 PF509 PF
29 2025-07-15 PX 7250.0 ... -0.073655 PX509 PX
30 2025-07-15 SH 861.0 ... 1.925668 SH509 SH
31 2025-07-15 CU 78135.0 ... -0.002624 cu2508 cu
32 2025-07-15 AL 20523.33 ... -0.007715 al2509 al
33 2025-07-15 ZN 22118.0 ... -0.000588 zn2509 zn
34 2025-07-15 PB 16925.0 ... 0.005022 pb2508 pb
35 2025-07-15 NI 120666.67 ... -0.008923 ni2509 ni
36 2025-07-15 SN 264687.5 ... -0.003617 sn2508 sn
37 2025-07-15 AU 774.93 ... 0.004246 au2510 au
38 2025-07-15 AG 9149.67 ... 0.003752 ag2510 ag
39 2025-07-15 RB 3173.0 ... -0.016388 rb2510 rb
40 2025-07-15 WR 3345.0 ... 0.006278 wr2510 wr
41 2025-07-15 HC 3333.33 ... -0.021099 hc2510 hc
42 2025-07-15 FU 5387.5 ... -0.467842 fu2509 fu
43 2025-07-15 BU 3720.0 ... -0.023925 bu2509 bu
44 2025-07-15 RU 14508.33 ... -0.006088 ru2509 ru
45 2025-07-15 SP 5950.0 ... -0.119328 sp2509 sp
46 2025-07-15 SS 12900.0 ... -0.016667 ss2509 ss
47 2025-07-15 BR 11850.0 ... -0.025316 br2509 br
48 2025-07-15 SI 9330.0 ... -0.060557 SI2509 si
49 2025-07-15 LC 63733.33 ... 0.038075 LC2509 lc
[50 rows x 15 columns]
2025-07-17 18:25:48,690 - future_1d - INFO - save future_spot 2025-07-15 completed
2025-07-17 18:25:57,603 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-16, end_day=2025-07-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-16 C 2327.14 ... -0.014241 c2509 c
1 2025-07-16 A 4295.0 ... -0.030035 a2509 a
2 2025-07-16 M 2916.0 ... 0.021262 m2509 m
3 2025-07-16 Y 8304.0 ... -0.032755 y2509 y
4 2025-07-16 P 8864.0 ... -0.016245 p2509 p
5 2025-07-16 JD 2885.0 ... 0.249567 jd2509 jd
6 2025-07-16 L 7393.33 ... -0.02412 l2509 l
7 2025-07-16 V 4736.0 ... 0.045186 v2509 v
8 2025-07-16 PP 7358.33 ... -0.046795 pp2509 pp
9 2025-07-16 JM 1248.75 ... -0.275676 jm2509 jm
10 2025-07-16 I 765.0 ... 0.008497 i2509 i
11 2025-07-16 EG 4405.0 ... -0.016345 eg2509 eg
12 2025-07-16 EB 7946.0 ... -0.087214 eb2509 eb
13 2025-07-16 PG 4747.5 ... -0.153449 pg2509 pg
14 2025-07-16 LH 14600.0 ... -0.034247 lh2509 lh
15 2025-07-16 BZ 5885.33 ... 0.045481 bz2603 bz
16 2025-07-16 CF 15291.33 ... -0.088045 CF509 CF
17 2025-07-16 SR 6043.33 ... -0.039602 SR509 SR
18 2025-07-16 TA 4735.66 ... -0.005841 TA509 TA
19 2025-07-16 OI 9581.67 ... -0.013429 OI509 OI
20 2025-07-16 MA 2381.67 ... -0.002381 MA509 MA
21 2025-07-16 FG 1142.4 ... -0.065126 FG509 FG
22 2025-07-16 RM 2576.67 ... 0.0304 RM509 RM
23 2025-07-16 SF 5202.86 ... 0.047885 SF509 SF
24 2025-07-16 SM 5630.0 ... 0.023801 SM509 SM
25 2025-07-16 CY 23275.0 ... -0.134909 CY509 CY
26 2025-07-16 UR 1827.5 ... -0.051163 UR509 UR
27 2025-07-16 SA 1247.5 ... -0.029259 SA509 SA
28 2025-07-16 PF 6633.96 ... -0.041297 PF509 PF
29 2025-07-16 PX 7250.0 ... -0.072828 PX509 PX
30 2025-07-16 SH 861.0 ... 1.898955 SH509 SH
31 2025-07-16 CU 78096.67 ... -0.00175 cu2508 cu
32 2025-07-16 AL 20540.0 ... -0.006816 al2509 al
33 2025-07-16 ZN 22018.0 ... -0.000818 zn2509 zn
34 2025-07-16 PB 16825.0 ... 0.00416 pb2508 pb
35 2025-07-16 NI 122216.67 ... -0.012328 ni2509 ni
36 2025-07-16 SN 263625.0 ... -0.000588 sn2508 sn
37 2025-07-16 AU 771.38 ... 0.006637 au2510 au
38 2025-07-16 AG 9113.0 ... 0.005157 ag2510 ag
39 2025-07-16 RB 3172.0 ... -0.020177 rb2510 rb
40 2025-07-16 WR 3345.0 ... 0.003587 wr2510 wr
41 2025-07-16 HC 3326.67 ... -0.022446 hc2510 hc
42 2025-07-16 FU 5387.5 ... -0.4671 fu2509 fu
43 2025-07-16 BU 3713.33 ... -0.025942 bu2509 bu
44 2025-07-16 RU 14516.67 ... -0.007693 ru2509 ru
45 2025-07-16 SP 5916.67 ... -0.114367 sp2509 sp
46 2025-07-16 SS 12950.0 ... -0.020077 ss2509 ss
47 2025-07-16 BR 11850.0 ... -0.036287 br2509 br
48 2025-07-16 SI 9380.0 ... -0.074627 SI2509 si
49 2025-07-16 LC 64100.0 ... 0.034633 LC2509 lc
[50 rows x 15 columns]
2025-07-17 18:25:57,759 - future_1d - INFO - save future_spot 2025-07-16 completed
2025-07-17 18:26:07,336 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-17, end_day=2025-07-17) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-17 C 2327.14 ... -0.017678 c2509 c
1 2025-07-17 A 4295.0 ... -0.023516 a2509 a
2 2025-07-17 M 2952.0 ... 0.019986 m2509 m
3 2025-07-17 Y 8334.0 ... -0.033837 y2509 y
4 2025-07-17 P 8894.0 ... -0.014617 p2509 p
5 2025-07-17 JD 2885.0 ... 0.245754 jd2509 jd
6 2025-07-17 L 7373.33 ... -0.022287 l2509 l
7 2025-07-17 V 4710.0 ... 0.049682 v2509 v
8 2025-07-17 PP 7321.67 ... -0.042568 pp2509 pp
9 2025-07-17 JM 1268.75 ... -0.288276 jm2509 jm
10 2025-07-17 I 779.67 ... 0.002988 i2509 i
11 2025-07-17 EG 4416.67 ... -0.011246 eg2509 eg
12 2025-07-17 EB 7900.0 ... -0.085949 eb2509 eb
13 2025-07-17 PG 4760.0 ... -0.161345 pg2509 pg
14 2025-07-17 LH 14600.0 ... -0.042123 lh2509 lh
15 2025-07-17 BZ 5825.33 ... 0.053846 bz2603 bz
16 2025-07-17 CF 15375.33 ... -0.079369 CF509 CF
17 2025-07-17 SR 6046.67 ... -0.038479 SR509 SR
18 2025-07-17 TA 4762.66 ... -0.011477 TA509 TA
19 2025-07-17 OI 9561.67 ... -0.013666 OI509 OI
20 2025-07-17 MA 2391.67 ... -0.009479 MA509 MA
21 2025-07-17 FG 1142.4 ... -0.051996 FG509 FG
22 2025-07-17 RM 2611.67 ... 0.031524 RM509 RM
23 2025-07-17 SF 5185.71 ... 0.052122 SF509 SF
24 2025-07-17 SM 5622.0 ... 0.027037 SM509 SM
25 2025-07-17 CY 23275.0 ... -0.125456 CY509 CY
26 2025-07-17 UR 1825.0 ... -0.046575 UR509 UR
27 2025-07-17 SA 1250.0 ... -0.0272 SA509 SA
28 2025-07-17 PF 6626.04 ... -0.041056 PF509 PF
29 2025-07-17 PX 7250.0 ... -0.073931 PX509 PX
30 2025-07-17 SH 863.0 ... 1.866744 SH509 SH
31 2025-07-17 CU 78055.0 ... -0.001986 cu2508 cu
32 2025-07-17 AL 20586.67 ... -0.007853 al2509 al
33 2025-07-17 ZN 22082.0 ... -0.000996 zn2509 zn
34 2025-07-17 PB 16762.5 ... 0.006413 pb2508 pb
35 2025-07-17 NI 120800.0 ... -0.008609 ni2509 ni
36 2025-07-17 SN 261962.5 ... -0.000849 sn2508 sn
37 2025-07-17 AU 772.5 ... 0.00668 au2510 au
38 2025-07-17 AG 9127.67 ... 0.002337 ag2510 ag
39 2025-07-17 RB 3173.5 ... -0.015598 rb2510 rb
40 2025-07-17 WR 3347.5 ... 0.008813 wr2510 wr
41 2025-07-17 HC 3343.33 ... -0.018942 hc2510 hc
42 2025-07-17 FU 5325.0 ... -0.462723 fu2509 fu
43 2025-07-17 BU 3710.0 ... -0.022102 bu2509 bu
44 2025-07-17 RU 14658.33 ... -0.006026 ru2509 ru
45 2025-07-17 SP 5916.67 ... -0.113353 sp2509 sp
46 2025-07-17 SS 12950.0 ... -0.021236 ss2509 ss
47 2025-07-17 BR 11850.0 ... -0.031224 br2509 br
48 2025-07-17 SI 9380.0 ... -0.071429 SI2509 si
49 2025-07-17 LC 64400.0 ... 0.056522 LC2509 lc
[50 rows x 15 columns]
2025-07-17 18:26:07,507 - future_1d - INFO - save future_spot 2025-07-17 add
2025-07-17 18:26:07,514 - future_1d - INFO - 0 ... 4
date 2025-07-17 ... 2025-07-17
variety C ... P
spot_price 2327.14 ... 8894.0
near_contract c2509 ... p2508
near_contract_price 2286.0 ... 8758.0
dominant_contract c2509 ... p2509
dominant_contract_price 2286.0 ... 8764.0
near_month 2509 ... 2508
dominant_month 2509 ... 2509
near_basis -41.14 ... -136.0
dom_basis -41.14 ... -130.0
near_basis_rate -0.0177 ... -0.0153
dom_basis_rate -0.0177 ... -0.0146
symbol c2509 ... p2509
comd c ... p
created_at 2025-07-17 18:26:07.468775 ... 2025-07-17 18:26:07.468775
updated_at 2025-07-17 18:26:07.469154 ... 2025-07-17 18:26:07.469154
[17 rows x 5 columns]