=========================================================================
2025-07-16 16:25:29 Wed START TASK.01 future_1d future_spot
=========================================================================
2025-07-16 16:25:31,525 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-16 16:25:31,862 - 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-16 16:25:32,035 - future_1d - INFO - save future_spot 2025-07-10 completed
2025-07-16 16:25:35,988 - 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-16 16:25:36,154 - future_1d - INFO - save future_spot 2025-07-11 completed
2025-07-16 16:25:42,556 - 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-16 16:25:42,711 - future_1d - INFO - save future_spot 2025-07-14 completed
2025-07-16 16:25:50,205 - 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-16 16:25:50,361 - future_1d - INFO - save future_spot 2025-07-15 completed
2025-07-16 16:25:57,381 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-16, end_day=2025-07-16) done
2025-07-16 16:25:57,399 - future_1d - INFO - save future_spot 2025-07-16 failed
=========================================================================
2025-07-16 18:25:19 Wed START TASK.01 future_1d future_spot
=========================================================================
2025-07-16 18:25:21,721 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-16 18:25:22,047 - 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 OI 9585.0 ... -0.013354 OI509 OI
20 2025-07-10 MA 2397.5 ... -0.001877 MA509 MA
21 2025-07-10 FG 1122.4 ... -0.052922 FG509 FG
22 2025-07-10 RM 2523.33 ... 0.028403 RM509 RM
23 2025-07-10 SF 5178.57 ... 0.068249 SF509 SF
24 2025-07-10 SM 5622.0 ... 0.030238 SM509 SM
25 2025-07-10 CY 23200.0 ... -0.137716 CY509 CY
26 2025-07-10 UR 1845.0 ... -0.036856 UR509 UR
27 2025-07-10 SA 1247.5 ... -0.027655 SA509 SA
28 2025-07-10 PF 6700.5 ... -0.039773 PF509 PF
29 2025-07-10 PX 7250.0 ... -0.068966 PX509 PX
30 2025-07-10 SH 847.0 ... 1.945691 SH509 SH
31 2025-07-10 CU 78678.33 ... -0.003665 cu2508 cu
32 2025-07-10 AL 20680.0 ... -0.000484 al2508 al
33 2025-07-10 ZN 22376.0 ... -0.004067 zn2508 zn
34 2025-07-10 PB 17093.75 ... 0.007093 pb2508 pb
35 2025-07-10 NI 120916.67 ... -0.008325 ni2508 ni
36 2025-07-10 SN 265075.0 ... -0.000283 sn2508 sn
37 2025-07-10 AU 767.05 ... 0.005358 au2510 au
38 2025-07-10 AG 8873.67 ... 0.001277 ag2510 ag
39 2025-07-10 RB 3138.5 ... -0.012586 rb2510 rb
40 2025-07-10 WR 3315.0 ... 0.004223 wr2601 wr
41 2025-07-10 HC 3290.0 ... -0.017325 hc2510 hc
42 2025-07-10 FU 5400.0 ... -0.451481 fu2509 fu
43 2025-07-10 BU 3690.0 ... -0.017615 bu2509 bu
44 2025-07-10 RU 14466.67 ... -0.015668 ru2509 ru
45 2025-07-10 SP 5933.33 ... -0.129325 sp2509 sp
46 2025-07-10 SS 12887.5 ... -0.005626 ss2508 ss
47 2025-07-10 BR 11810.0 ... -0.033023 br2509 br
48 2025-07-10 SI 8920.0 ... -0.061099 SI2509 si
49 2025-07-10 LC 62766.67 ... 0.026978 LC2509 lc
[50 rows x 15 columns]
2025-07-16 18:25:22,236 - future_1d - INFO - save future_spot 2025-07-10 add
2025-07-16 18:25:22,240 - future_1d - INFO - 19 20
date 2025-07-10 2025-07-10
variety OI MA
spot_price 9585.0 2397.5
near_contract OI507 MA507
near_contract_price 9600.0 2353.0
dominant_contract OI509 MA509
dominant_contract_price 9457.0 2393.0
near_month 2507 2507
dominant_month 2509 2509
near_basis 15.0 -44.5
dom_basis -128.0 -4.5
near_basis_rate 0.0016 -0.0186
dom_basis_rate -0.0134 -0.0019
symbol OI509 MA509
comd OI MA
created_at 2025-07-16 18:25:22.200894 2025-07-16 18:25:22.200894
updated_at 2025-07-16 18:25:22.201421 2025-07-16 18:25:22.201421
2025-07-16 18:25:26,720 - 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-16 18:25:26,892 - future_1d - INFO - save future_spot 2025-07-11 add
2025-07-16 18:25:26,896 - future_1d - INFO - 19 20
date 2025-07-11 2025-07-11
variety OI MA
spot_price 9568.33 2378.33
near_contract OI507 MA507
near_contract_price 9600.0 2353.0
dominant_contract OI509 MA509
dominant_contract_price 9455.0 2380.0
near_month 2507 2507
dominant_month 2509 2509
near_basis 31.67 -25.33
dom_basis -113.33 1.67
near_basis_rate 0.0033 -0.0107
dom_basis_rate -0.0118 0.0007
symbol OI509 MA509
comd OI MA
created_at 2025-07-16 18:25:26.859172 2025-07-16 18:25:26.859172
updated_at 2025-07-16 18:25:26.859535 2025-07-16 18:25:26.859535
2025-07-16 18:25:32,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-16 18:25:32,417 - future_1d - INFO - save future_spot 2025-07-14 add
2025-07-16 18:25:32,422 - future_1d - INFO - 19 20
date 2025-07-14 2025-07-14
variety OI MA
spot_price 9541.67 2390.0
near_contract OI507 MA507
near_contract_price 9557.0 2383.0
dominant_contract OI509 MA509
dominant_contract_price 9413.0 2387.0
near_month 2507 2507
dominant_month 2509 2509
near_basis 15.33 -7.0
dom_basis -128.67 -3.0
near_basis_rate 0.0016 -0.0029
dom_basis_rate -0.0135 -0.0013
symbol OI509 MA509
comd OI MA
created_at 2025-07-16 18:25:32.383366 2025-07-16 18:25:32.383366
updated_at 2025-07-16 18:25:32.383770 2025-07-16 18:25:32.383770
2025-07-16 18:25:40,282 - 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-16 18:25:40,452 - future_1d - INFO - save future_spot 2025-07-15 add
2025-07-16 18:25:40,456 - future_1d - INFO - 19 20
date 2025-07-15 2025-07-15
variety OI MA
spot_price 9533.33 2390.0
near_contract OI509 MA508
near_contract_price 9441.0 2383.0
dominant_contract OI509 MA509
dominant_contract_price 9441.0 2392.0
near_month 2509 2508
dominant_month 2509 2509
near_basis -92.33 -7.0
dom_basis -92.33 2.0
near_basis_rate -0.0097 -0.0029
dom_basis_rate -0.0097 0.0008
symbol OI509 MA509
comd OI MA
created_at 2025-07-16 18:25:40.420448 2025-07-16 18:25:40.420448
updated_at 2025-07-16 18:25:40.420844 2025-07-16 18:25:40.420844
2025-07-16 18:25:44,438 - 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-16 18:25:44,611 - future_1d - INFO - save future_spot 2025-07-16 add
2025-07-16 18:25:44,619 - future_1d - INFO - 0 ... 4
date 2025-07-16 ... 2025-07-16
variety C ... P
spot_price 2327.14 ... 8864.0
near_contract c2509 ... p2508
near_contract_price 2294.0 ... 8740.0
dominant_contract c2509 ... p2509
dominant_contract_price 2294.0 ... 8720.0
near_month 2509 ... 2508
dominant_month 2509 ... 2509
near_basis -33.14 ... -124.0
dom_basis -33.14 ... -144.0
near_basis_rate -0.0142 ... -0.014
dom_basis_rate -0.0142 ... -0.0162
symbol c2509 ... p2509
comd c ... p
created_at 2025-07-16 18:25:44.568020 ... 2025-07-16 18:25:44.568020
updated_at 2025-07-16 18:25:44.568438 ... 2025-07-16 18:25:44.568438
[17 rows x 5 columns]