=========================================================================
2025-06-10 16:25:37 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-06-10 16:25:39,612 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-10 16:25:39,939 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-04, end_day=2025-06-04) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-04 C 2297.14 ... 0.012999 c2507 c
1 2025-06-04 A 4255.0 ... -0.032432 a2507 a
2 2025-06-04 M 2892.0 ... 0.015906 m2509 m
3 2025-06-04 Y 7954.0 ... -0.033191 y2509 y
4 2025-06-04 P 8540.0 ... -0.044965 p2509 p
5 2025-06-04 JD 2975.0 ... 0.199664 jd2508 jd
6 2025-06-04 L 7346.67 ... -0.04569 l2509 l
7 2025-06-04 V 4589.0 ... 0.041839 v2509 v
8 2025-06-04 PP 7393.33 ... -0.065239 pp2509 pp
9 2025-06-04 I 752.11 ... -0.066626 i2509 i
10 2025-06-04 EG 4495.0 ... -0.046051 eg2509 eg
11 2025-06-04 EB 8040.0 ... -0.120149 eb2507 eb
12 2025-06-04 PG 4765.0 ... -0.145855 pg2507 pg
13 2025-06-04 LH 14470.0 ... -0.070145 lh2509 lh
14 2025-06-04 CF 14553.0 ... -0.089878 CF509 CF
15 2025-06-04 SR 6095.0 ... -0.059557 SR509 SR
16 2025-06-04 TA 4896.5 ... -0.046258 TA509 TA
17 2025-06-04 OI 9238.33 ... -0.007396 OI509 OI
18 2025-06-04 MA 2293.0 ... -0.019625 MA509 MA
19 2025-06-04 FG 1136.0 ... -0.144366 FG509 FG
20 2025-06-04 RM 2495.0 ... 0.02004 RM509 RM
21 2025-06-04 SF 5152.86 ... -0.007541 SF509 SF
22 2025-06-04 SM 5510.0 ... -0.0098 SM509 SM
23 2025-06-04 CY 23800.0 ... -0.182563 CY509 CY
24 2025-06-04 UR 1898.0 ... -0.065859 UR509 UR
25 2025-06-04 SA 1375.0 ... -0.120727 SA509 SA
26 2025-06-04 PF 6519.17 ... -0.0192 PF507 PF
27 2025-06-04 PX 7000.0 ... -0.061714 PX509 PX
28 2025-06-04 SH 885.0 ... 1.657627 SH509 SH
29 2025-06-04 CU 78535.0 ... -0.004266 cu2507 cu
30 2025-06-04 AL 20293.33 ... -0.013715 al2507 al
31 2025-06-04 ZN 22886.0 ... -0.02211 zn2507 zn
32 2025-06-04 PB 16525.0 ... 0.006657 pb2507 pb
33 2025-06-04 NI 123641.67 ... -0.01255 ni2507 ni
34 2025-06-04 SN 255450.0 ... -0.001174 sn2507 sn
35 2025-06-04 AU 780.92 ... 0.001332 au2508 au
36 2025-06-04 AG 8455.67 ... 0.002168 ag2508 ag
37 2025-06-04 RB 3057.33 ... -0.03347 rb2510 rb
38 2025-06-04 WR 3237.5 ... 0.026409 wr2601 wr
39 2025-06-04 HC 3183.33 ... -0.031517 hc2510 hc
40 2025-06-04 FU 5337.5 ... -0.466604 fu2509 fu
41 2025-06-04 BU 3630.0 ... -0.041322 bu2509 bu
42 2025-06-04 RU 13558.33 ... -0.006515 ru2509 ru
43 2025-06-04 SP 6216.67 ... -0.160644 sp2509 sp
44 2025-06-04 SS 13125.0 ... -0.032762 ss2508 ss
45 2025-06-04 BR 11600.0 ... -0.06681 br2508 br
46 2025-06-04 SI 8640.0 ... -0.168403 SI2509 si
47 2025-06-04 LC 59900.0 ... 0.007679 LC2507 lc
[48 rows x 15 columns]
2025-06-10 16:25:40,114 - future_1d - INFO - save future_spot 2025-06-04 completed
2025-06-10 16:25:44,566 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-05, end_day=2025-06-05) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-05 C 2294.29 ... 0.016436 c2507 c
1 2025-06-05 A 4255.0 ... -0.039483 a2509 a
2 2025-06-05 M 2900.0 ... 0.018621 m2509 m
3 2025-06-05 Y 7934.0 ... -0.033527 y2509 y
4 2025-06-05 P 8542.0 ... -0.051042 p2509 p
5 2025-06-05 JD 2975.0 ... 0.200336 jd2508 jd
6 2025-06-05 L 7346.67 ... -0.041334 l2509 l
7 2025-06-05 V 4565.0 ... 0.043154 v2509 v
8 2025-06-05 PP 7388.33 ... -0.063523 pp2509 pp
9 2025-06-05 I 750.0 ... -0.064667 i2509 i
10 2025-06-05 EG 4498.33 ... -0.045868 eg2509 eg
11 2025-06-05 EB 7970.0 ... -0.115182 eb2507 eb
12 2025-06-05 PG 4770.0 ... -0.141509 pg2507 pg
13 2025-06-05 LH 14420.0 ... -0.065187 lh2509 lh
14 2025-06-05 CF 14555.5 ... -0.089004 CF509 CF
15 2025-06-05 SR 6095.0 ... -0.059065 SR509 SR
16 2025-06-05 TA 4880.66 ... -0.051768 TA509 TA
17 2025-06-05 OI 9296.67 ... -0.018035 OI509 OI
18 2025-06-05 MA 2302.0 ... -0.019548 MA509 MA
19 2025-06-05 FG 1120.0 ... -0.135714 FG509 FG
20 2025-06-05 RM 2498.33 ... 0.022283 RM509 RM
21 2025-06-05 SF 5152.86 ... -0.010258 SF509 SF
22 2025-06-05 SM 5500.0 ... -0.004727 SM509 SM
23 2025-06-05 CY 23725.0 ... -0.177871 CY509 CY
24 2025-06-05 UR 1868.33 ... -0.069222 UR509 UR
25 2025-06-05 SA 1375.0 ... -0.125818 SA509 SA
26 2025-06-05 PF 6495.83 ... -0.019679 PF507 PF
27 2025-06-05 PX 7000.0 ... -0.069143 PX509 PX
28 2025-06-05 SH 885.0 ... 1.633898 SH509 SH
29 2025-06-05 CU 78410.0 ... -0.003699 cu2507 cu
30 2025-06-05 AL 20266.67 ... -0.010444 al2507 al
31 2025-06-05 ZN 22870.0 ... -0.022956 zn2507 zn
32 2025-06-05 PB 16593.75 ... 0.007006 pb2507 pb
33 2025-06-05 NI 123133.33 ... -0.011478 ni2507 ni
34 2025-06-05 SN 259812.5 ... -0.003243 sn2507 sn
35 2025-06-05 AU 781.27 ... 0.003981 au2508 au
36 2025-06-05 AG 8443.0 ... 0.003198 ag2508 ag
37 2025-06-05 RB 3063.0 ... -0.03428 rb2510 rb
38 2025-06-05 WR 3240.0 ... 0.025617 wr2601 wr
39 2025-06-05 HC 3176.67 ... -0.032005 hc2510 hc
40 2025-06-05 FU 5312.5 ... -0.463153 fu2509 fu
41 2025-06-05 BU 3610.0 ... -0.041274 bu2509 bu
42 2025-06-05 RU 13458.33 ... 0.007183 ru2509 ru
43 2025-06-05 SP 6216.67 ... -0.159679 sp2509 sp
44 2025-06-05 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-05 BR 11600.0 ... -0.063362 br2508 br
46 2025-06-05 SI 8640.0 ... -0.170718 SI2509 si
47 2025-06-05 LC 60166.67 ... 0.002216 LC2507 lc
[48 rows x 15 columns]
2025-06-10 16:25:44,723 - future_1d - INFO - save future_spot 2025-06-05 completed
2025-06-10 16:25:48,273 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-06, end_day=2025-06-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-06 C 2294.29 ... 0.01818 c2507 c
1 2025-06-06 A 4270.0 ... -0.040281 a2509 a
2 2025-06-06 M 2940.0 ... 0.017347 m2509 m
3 2025-06-06 Y 7994.0 ... -0.035026 y2509 y
4 2025-06-06 P 8520.0 ... -0.046479 p2509 p
5 2025-06-06 JD 2940.0 ... 0.211905 jd2508 jd
6 2025-06-06 L 7346.67 ... -0.037387 l2509 l
7 2025-06-06 V 4604.0 ... 0.039096 v2509 v
8 2025-06-06 PP 7380.0 ... -0.061518 pp2509 pp
9 2025-06-06 I 751.44 ... -0.057809 i2509 i
10 2025-06-06 EG 4498.33 ... -0.048091 eg2509 eg
11 2025-06-06 EB 7970.0 ... -0.109159 eb2507 eb
12 2025-06-06 PG 4770.0 ... -0.140252 pg2507 pg
13 2025-06-06 LH 14300.0 ... -0.055944 lh2509 lh
14 2025-06-06 CF 14569.33 ... -0.083692 CF509 CF
15 2025-06-06 SR 6095.0 ... -0.062182 SR509 SR
16 2025-06-06 TA 4903.25 ... -0.047163 TA509 TA
17 2025-06-06 OI 9296.67 ... -0.013733 OI509 OI
18 2025-06-06 MA 2313.0 ... -0.02032 MA509 MA
19 2025-06-06 FG 1120.0 ... -0.113393 FG509 FG
20 2025-06-06 RM 2535.0 ... 0.024063 RM509 RM
21 2025-06-06 SF 5090.0 ... 0.010609 SF509 SF
22 2025-06-06 SM 5536.0 ... 0.002529 SM509 SM
23 2025-06-06 CY 23725.0 ... -0.173656 CY509 CY
24 2025-06-06 UR 1850.0 ... -0.065946 UR509 UR
25 2025-06-06 SA 1375.0 ... -0.117818 SA509 SA
26 2025-06-06 PF 6507.5 ... -0.02574 PF508 PF
27 2025-06-06 PX 7000.0 ... -0.059143 PX509 PX
28 2025-06-06 SH 885.0 ... 1.650847 SH509 SH
29 2025-06-06 CU 78913.33 ... -0.001309 cu2507 cu
30 2025-06-06 AL 20246.67 ... -0.008973 al2507 al
31 2025-06-06 ZN 22680.0 ... -0.016314 zn2507 zn
32 2025-06-06 PB 16568.75 ... 0.007016 pb2507 pb
33 2025-06-06 NI 123450.0 ... -0.010612 ni2507 ni
34 2025-06-06 SN 264462.5 ... -0.005833 sn2507 sn
35 2025-06-06 AU 779.86 ... 0.003616 au2508 au
36 2025-06-06 AG 8746.0 ... 0.000915 ag2508 ag
37 2025-06-06 RB 3080.33 ... -0.031922 rb2510 rb
38 2025-06-06 WR 3262.5 ... 0.018544 wr2601 wr
39 2025-06-06 HC 3170.0 ... -0.023028 hc2510 hc
40 2025-06-06 FU 5312.5 ... -0.460518 fu2509 fu
41 2025-06-06 BU 3610.0 ... -0.036565 bu2509 bu
42 2025-06-06 RU 13508.33 ... 0.013819 ru2509 ru
43 2025-06-06 SP 6216.67 ... -0.159357 sp2509 sp
44 2025-06-06 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-06 BR 11630.0 ... -0.044282 br2508 br
46 2025-06-06 SI 8640.0 ... -0.155093 SI2509 si
47 2025-06-06 LC 60166.67 ... 0.010526 LC2507 lc
[48 rows x 15 columns]
2025-06-10 16:25:48,430 - future_1d - INFO - save future_spot 2025-06-06 completed
2025-06-10 16:25:56,782 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-09, end_day=2025-06-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-09 C 2300.0 ... 0.022174 c2507 c
1 2025-06-09 A 4295.0 ... -0.044237 a2509 a
2 2025-06-09 M 2944.0 ... 0.022758 m2509 m
3 2025-06-09 Y 8024.0 ... -0.032652 y2509 y
4 2025-06-09 P 8644.0 ... -0.056687 p2509 p
5 2025-06-09 JD 2915.0 ... 0.204117 jd2508 jd
6 2025-06-09 L 7346.67 ... -0.036434 l2509 l
7 2025-06-09 V 4602.0 ... 0.044111 v2509 v
8 2025-06-09 PP 7380.0 ... -0.060298 pp2509 pp
9 2025-06-09 I 746.11 ... -0.055769 i2509 i
10 2025-06-09 EG 4498.33 ... -0.051426 eg2509 eg
11 2025-06-09 EB 7870.0 ... -0.090216 eb2507 eb
12 2025-06-09 PG 4782.5 ... -0.141662 pg2507 pg
13 2025-06-09 LH 14270.0 ... -0.057463 lh2509 lh
14 2025-06-09 CF 14623.0 ... -0.07919 CF509 CF
15 2025-06-09 SR 6095.0 ... -0.059721 SR509 SR
16 2025-06-09 TA 4884.5 ... -0.050466 TA509 TA
17 2025-06-09 OI 9331.67 ... -0.019361 OI509 OI
18 2025-06-09 MA 2331.0 ... -0.026169 MA509 MA
19 2025-06-09 FG 1120.0 ... -0.105357 FG509 FG
20 2025-06-09 RM 2543.33 ... 0.022675 RM509 RM
21 2025-06-09 SF 5088.57 ... 0.014037 SF509 SF
22 2025-06-09 SM 5530.0 ... 0.003978 SM509 SM
23 2025-06-09 CY 23725.0 ... -0.168809 CY509 CY
24 2025-06-09 UR 1821.67 ... -0.067339 UR509 UR
25 2025-06-09 SA 1370.0 ... -0.114599 SA509 SA
26 2025-06-09 PF 6518.12 ... -0.027634 PF508 PF
27 2025-06-09 PX 7000.0 ... -0.065714 PX509 PX
28 2025-06-09 SH 885.0 ... 1.625989 SH509 SH
29 2025-06-09 CU 78891.67 ... -0.00281 cu2507 cu
30 2025-06-09 AL 20246.67 ... -0.011936 al2507 al
31 2025-06-09 ZN 22582.0 ... -0.020237 zn2507 zn
32 2025-06-09 PB 16593.75 ... 0.008211 pb2507 pb
33 2025-06-09 NI 124133.33 ... -0.011627 ni2507 ni
34 2025-06-09 SN 263900.0 ... -0.003941 sn2507 sn
35 2025-06-09 AU 768.07 ... 0.009361 au2508 au
36 2025-06-09 AG 8792.0 ... 0.00455 ag2508 ag
37 2025-06-09 RB 3069.0 ... -0.030303 rb2510 rb
38 2025-06-09 WR 3260.0 ... 0.011963 wr2510 wr
39 2025-06-09 HC 3170.0 ... -0.025552 hc2510 hc
40 2025-06-09 FU 5275.0 ... -0.453839 fu2509 fu
41 2025-06-09 BU 3630.0 ... -0.032782 bu2509 bu
42 2025-06-09 RU 13573.33 ... 0.004912 ru2509 ru
43 2025-06-09 SP 6216.67 ... -0.154531 sp2509 sp
44 2025-06-09 SS 13100.0 ... -0.034733 ss2508 ss
45 2025-06-09 BR 11760.0 ... -0.058673 br2508 br
46 2025-06-09 SI 8620.0 ... -0.147912 SI2509 si
47 2025-06-09 LC 60166.67 ... 0.008199 LC2507 lc
[48 rows x 15 columns]
2025-06-10 16:25:56,950 - future_1d - INFO - save future_spot 2025-06-09 completed
2025-06-10 16:26:02,789 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-10, end_day=2025-06-10) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-10 C 2308.57 ... 0.027476 c2507 c
1 2025-06-10 A 4295.0 ... -0.033527 a2509 a
2 2025-06-10 M 2952.0 ... 0.022696 m2509 m
3 2025-06-10 Y 8024.0 ... -0.032154 y2509 y
4 2025-06-10 P 8630.0 ... -0.054461 p2509 p
5 2025-06-10 JD 2915.0 ... 0.204117 jd2508 jd
6 2025-06-10 L 7361.67 ... -0.035681 l2509 l
7 2025-06-10 V 4608.0 ... 0.042752 v2509 v
8 2025-06-10 PP 7380.0 ... -0.059485 pp2509 pp
9 2025-06-10 I 740.0 ... -0.054054 i2509 i
10 2025-06-10 EG 4490.0 ... -0.049443 eg2509 eg
11 2025-06-10 EB 7870.0 ... -0.069632 eb2507 eb
12 2025-06-10 PG 4772.5 ... -0.139026 pg2507 pg
13 2025-06-10 LH 14250.0 ... -0.04807 lh2509 lh
14 2025-06-10 CF 14623.0 ... -0.077139 CF509 CF
15 2025-06-10 SR 6085.0 ... -0.059326 SR509 SR
16 2025-06-10 TA 4880.5 ... -0.049278 TA509 TA
17 2025-06-10 OI 9345.0 ... -0.017014 OI509 OI
18 2025-06-10 MA 2378.0 ... -0.042052 MA509 MA
19 2025-06-10 FG 1120.0 ... -0.110714 FG509 FG
20 2025-06-10 RM 2543.33 ... 0.028573 RM509 RM
21 2025-06-10 SF 5088.57 ... 0.015216 SF509 SF
22 2025-06-10 SM 5536.0 ... 0.003251 SM509 SM
23 2025-06-10 CY 23725.0 ... -0.168599 CY509 CY
24 2025-06-10 UR 1821.67 ... -0.071182 UR509 UR
25 2025-06-10 SA 1370.0 ... -0.121898 SA509 SA
26 2025-06-10 PF 6522.5 ... -0.028593 PF508 PF
27 2025-06-10 PX 7000.0 ... -0.064 PX509 PX
28 2025-06-10 SH 885.0 ... 1.629379 SH509 SH
29 2025-06-10 CU 79293.33 ... -0.00206 cu2507 cu
30 2025-06-10 AL 20193.33 ... -0.009574 al2507 al
31 2025-06-10 ZN 22232.0 ... -0.016283 zn2507 zn
32 2025-06-10 PB 16681.25 ... 0.010416 pb2507 pb
33 2025-06-10 NI 123000.0 ... -0.010894 ni2507 ni
34 2025-06-10 SN 264625.0 ... -0.003458 sn2507 sn
35 2025-06-10 AU 768.76 ... 0.005802 au2508 au
36 2025-06-10 AG 8792.0 ... 0.015355 ag2508 ag
37 2025-06-10 RB 3090.22 ... -0.03858 rb2510 rb
38 2025-06-10 WR 3267.5 ... 0.007804 wr2510 wr
39 2025-06-10 HC 3173.33 ... -0.02815 hc2510 hc
40 2025-06-10 FU 5275.0 ... -0.447583 fu2509 fu
41 2025-06-10 BU 3623.33 ... -0.03459 bu2509 bu
42 2025-06-10 RU 13670.83 ... 0.00762 ru2509 ru
43 2025-06-10 SP 6216.67 ... -0.150671 sp2509 sp
44 2025-06-10 SS 13100.0 ... -0.042748 ss2508 ss
45 2025-06-10 BR 11760.0 ... -0.056973 br2508 br
46 2025-06-10 SI 8620.0 ... -0.141531 SI2509 si
47 2025-06-10 LC 60066.67 ... 0.01354 LC2509 lc
[48 rows x 15 columns]
2025-06-10 16:26:02,963 - future_1d - INFO - save future_spot 2025-06-10 add
2025-06-10 16:26:02,971 - future_1d - INFO - 0 ... 4
date 2025-06-10 ... 2025-06-10
variety C ... P
spot_price 2308.57 ... 8630.0
near_contract c2507 ... p2506
near_contract_price 2372.0 ... 8600.0
dominant_contract c2507 ... p2509
dominant_contract_price 2372.0 ... 8160.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 63.43 ... -30.0
dom_basis 63.43 ... -470.0
near_basis_rate 0.0275 ... -0.0035
dom_basis_rate 0.0275 ... -0.0545
symbol c2507 ... p2509
comd c ... p
created_at 2025-06-10 16:26:02.920763 ... 2025-06-10 16:26:02.920763
updated_at 2025-06-10 16:26:02.921190 ... 2025-06-10 16:26:02.921190
[17 rows x 5 columns]
=========================================================================
2025-06-10 18:25:42 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-06-10 18:25:44,048 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-10 18:25:44,381 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-04, end_day=2025-06-04) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-04 C 2297.14 ... 0.012999 c2507 c
1 2025-06-04 A 4255.0 ... -0.032432 a2507 a
2 2025-06-04 M 2892.0 ... 0.015906 m2509 m
3 2025-06-04 Y 7954.0 ... -0.033191 y2509 y
4 2025-06-04 P 8540.0 ... -0.044965 p2509 p
5 2025-06-04 JD 2975.0 ... 0.199664 jd2508 jd
6 2025-06-04 L 7346.67 ... -0.04569 l2509 l
7 2025-06-04 V 4589.0 ... 0.041839 v2509 v
8 2025-06-04 PP 7393.33 ... -0.065239 pp2509 pp
9 2025-06-04 I 752.11 ... -0.066626 i2509 i
10 2025-06-04 EG 4495.0 ... -0.046051 eg2509 eg
11 2025-06-04 EB 8040.0 ... -0.120149 eb2507 eb
12 2025-06-04 PG 4765.0 ... -0.145855 pg2507 pg
13 2025-06-04 LH 14470.0 ... -0.070145 lh2509 lh
14 2025-06-04 CF 14553.0 ... -0.089878 CF509 CF
15 2025-06-04 SR 6095.0 ... -0.059557 SR509 SR
16 2025-06-04 TA 4896.5 ... -0.046258 TA509 TA
17 2025-06-04 OI 9238.33 ... -0.007396 OI509 OI
18 2025-06-04 MA 2293.0 ... -0.019625 MA509 MA
19 2025-06-04 FG 1136.0 ... -0.144366 FG509 FG
20 2025-06-04 RM 2495.0 ... 0.02004 RM509 RM
21 2025-06-04 SF 5152.86 ... -0.007541 SF509 SF
22 2025-06-04 SM 5510.0 ... -0.0098 SM509 SM
23 2025-06-04 CY 23800.0 ... -0.182563 CY509 CY
24 2025-06-04 UR 1898.0 ... -0.065859 UR509 UR
25 2025-06-04 SA 1375.0 ... -0.120727 SA509 SA
26 2025-06-04 PF 6519.17 ... -0.0192 PF507 PF
27 2025-06-04 PX 7000.0 ... -0.061714 PX509 PX
28 2025-06-04 SH 885.0 ... 1.657627 SH509 SH
29 2025-06-04 CU 78535.0 ... -0.004266 cu2507 cu
30 2025-06-04 AL 20293.33 ... -0.013715 al2507 al
31 2025-06-04 ZN 22886.0 ... -0.02211 zn2507 zn
32 2025-06-04 PB 16525.0 ... 0.006657 pb2507 pb
33 2025-06-04 NI 123641.67 ... -0.01255 ni2507 ni
34 2025-06-04 SN 255450.0 ... -0.001174 sn2507 sn
35 2025-06-04 AU 780.92 ... 0.001332 au2508 au
36 2025-06-04 AG 8455.67 ... 0.002168 ag2508 ag
37 2025-06-04 RB 3057.33 ... -0.03347 rb2510 rb
38 2025-06-04 WR 3237.5 ... 0.026409 wr2601 wr
39 2025-06-04 HC 3183.33 ... -0.031517 hc2510 hc
40 2025-06-04 FU 5337.5 ... -0.466604 fu2509 fu
41 2025-06-04 BU 3630.0 ... -0.041322 bu2509 bu
42 2025-06-04 RU 13558.33 ... -0.006515 ru2509 ru
43 2025-06-04 SP 6216.67 ... -0.160644 sp2509 sp
44 2025-06-04 SS 13125.0 ... -0.032762 ss2508 ss
45 2025-06-04 BR 11600.0 ... -0.06681 br2508 br
46 2025-06-04 SI 8640.0 ... -0.168403 SI2509 si
47 2025-06-04 LC 59900.0 ... 0.007679 LC2507 lc
[48 rows x 15 columns]
2025-06-10 18:25:44,556 - future_1d - INFO - save future_spot 2025-06-04 completed
2025-06-10 18:25:50,698 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-05, end_day=2025-06-05) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-05 C 2294.29 ... 0.016436 c2507 c
1 2025-06-05 A 4255.0 ... -0.039483 a2509 a
2 2025-06-05 M 2900.0 ... 0.018621 m2509 m
3 2025-06-05 Y 7934.0 ... -0.033527 y2509 y
4 2025-06-05 P 8542.0 ... -0.051042 p2509 p
5 2025-06-05 JD 2975.0 ... 0.200336 jd2508 jd
6 2025-06-05 L 7346.67 ... -0.041334 l2509 l
7 2025-06-05 V 4565.0 ... 0.043154 v2509 v
8 2025-06-05 PP 7388.33 ... -0.063523 pp2509 pp
9 2025-06-05 I 750.0 ... -0.064667 i2509 i
10 2025-06-05 EG 4498.33 ... -0.045868 eg2509 eg
11 2025-06-05 EB 7970.0 ... -0.115182 eb2507 eb
12 2025-06-05 PG 4770.0 ... -0.141509 pg2507 pg
13 2025-06-05 LH 14420.0 ... -0.065187 lh2509 lh
14 2025-06-05 CF 14555.5 ... -0.089004 CF509 CF
15 2025-06-05 SR 6095.0 ... -0.059065 SR509 SR
16 2025-06-05 TA 4880.66 ... -0.051768 TA509 TA
17 2025-06-05 OI 9296.67 ... -0.018035 OI509 OI
18 2025-06-05 MA 2302.0 ... -0.019548 MA509 MA
19 2025-06-05 FG 1120.0 ... -0.135714 FG509 FG
20 2025-06-05 RM 2498.33 ... 0.022283 RM509 RM
21 2025-06-05 SF 5152.86 ... -0.010258 SF509 SF
22 2025-06-05 SM 5500.0 ... -0.004727 SM509 SM
23 2025-06-05 CY 23725.0 ... -0.177871 CY509 CY
24 2025-06-05 UR 1868.33 ... -0.069222 UR509 UR
25 2025-06-05 SA 1375.0 ... -0.125818 SA509 SA
26 2025-06-05 PF 6495.83 ... -0.019679 PF507 PF
27 2025-06-05 PX 7000.0 ... -0.069143 PX509 PX
28 2025-06-05 SH 885.0 ... 1.633898 SH509 SH
29 2025-06-05 CU 78410.0 ... -0.003699 cu2507 cu
30 2025-06-05 AL 20266.67 ... -0.010444 al2507 al
31 2025-06-05 ZN 22870.0 ... -0.022956 zn2507 zn
32 2025-06-05 PB 16593.75 ... 0.007006 pb2507 pb
33 2025-06-05 NI 123133.33 ... -0.011478 ni2507 ni
34 2025-06-05 SN 259812.5 ... -0.003243 sn2507 sn
35 2025-06-05 AU 781.27 ... 0.003981 au2508 au
36 2025-06-05 AG 8443.0 ... 0.003198 ag2508 ag
37 2025-06-05 RB 3063.0 ... -0.03428 rb2510 rb
38 2025-06-05 WR 3240.0 ... 0.025617 wr2601 wr
39 2025-06-05 HC 3176.67 ... -0.032005 hc2510 hc
40 2025-06-05 FU 5312.5 ... -0.463153 fu2509 fu
41 2025-06-05 BU 3610.0 ... -0.041274 bu2509 bu
42 2025-06-05 RU 13458.33 ... 0.007183 ru2509 ru
43 2025-06-05 SP 6216.67 ... -0.159679 sp2509 sp
44 2025-06-05 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-05 BR 11600.0 ... -0.063362 br2508 br
46 2025-06-05 SI 8640.0 ... -0.170718 SI2509 si
47 2025-06-05 LC 60166.67 ... 0.002216 LC2507 lc
[48 rows x 15 columns]
2025-06-10 18:25:50,854 - future_1d - INFO - save future_spot 2025-06-05 completed
2025-06-10 18:25:58,856 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-06, end_day=2025-06-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-06 C 2294.29 ... 0.01818 c2507 c
1 2025-06-06 A 4270.0 ... -0.040281 a2509 a
2 2025-06-06 M 2940.0 ... 0.017347 m2509 m
3 2025-06-06 Y 7994.0 ... -0.035026 y2509 y
4 2025-06-06 P 8520.0 ... -0.046479 p2509 p
5 2025-06-06 JD 2940.0 ... 0.211905 jd2508 jd
6 2025-06-06 L 7346.67 ... -0.037387 l2509 l
7 2025-06-06 V 4604.0 ... 0.039096 v2509 v
8 2025-06-06 PP 7380.0 ... -0.061518 pp2509 pp
9 2025-06-06 I 751.44 ... -0.057809 i2509 i
10 2025-06-06 EG 4498.33 ... -0.048091 eg2509 eg
11 2025-06-06 EB 7970.0 ... -0.109159 eb2507 eb
12 2025-06-06 PG 4770.0 ... -0.140252 pg2507 pg
13 2025-06-06 LH 14300.0 ... -0.055944 lh2509 lh
14 2025-06-06 CF 14569.33 ... -0.083692 CF509 CF
15 2025-06-06 SR 6095.0 ... -0.062182 SR509 SR
16 2025-06-06 TA 4903.25 ... -0.047163 TA509 TA
17 2025-06-06 OI 9296.67 ... -0.013733 OI509 OI
18 2025-06-06 MA 2313.0 ... -0.02032 MA509 MA
19 2025-06-06 FG 1120.0 ... -0.113393 FG509 FG
20 2025-06-06 RM 2535.0 ... 0.024063 RM509 RM
21 2025-06-06 SF 5090.0 ... 0.010609 SF509 SF
22 2025-06-06 SM 5536.0 ... 0.002529 SM509 SM
23 2025-06-06 CY 23725.0 ... -0.173656 CY509 CY
24 2025-06-06 UR 1850.0 ... -0.065946 UR509 UR
25 2025-06-06 SA 1375.0 ... -0.117818 SA509 SA
26 2025-06-06 PF 6507.5 ... -0.02574 PF508 PF
27 2025-06-06 PX 7000.0 ... -0.059143 PX509 PX
28 2025-06-06 SH 885.0 ... 1.650847 SH509 SH
29 2025-06-06 CU 78913.33 ... -0.001309 cu2507 cu
30 2025-06-06 AL 20246.67 ... -0.008973 al2507 al
31 2025-06-06 ZN 22680.0 ... -0.016314 zn2507 zn
32 2025-06-06 PB 16568.75 ... 0.007016 pb2507 pb
33 2025-06-06 NI 123450.0 ... -0.010612 ni2507 ni
34 2025-06-06 SN 264462.5 ... -0.005833 sn2507 sn
35 2025-06-06 AU 779.86 ... 0.003616 au2508 au
36 2025-06-06 AG 8746.0 ... 0.000915 ag2508 ag
37 2025-06-06 RB 3080.33 ... -0.031922 rb2510 rb
38 2025-06-06 WR 3262.5 ... 0.018544 wr2601 wr
39 2025-06-06 HC 3170.0 ... -0.023028 hc2510 hc
40 2025-06-06 FU 5312.5 ... -0.460518 fu2509 fu
41 2025-06-06 BU 3610.0 ... -0.036565 bu2509 bu
42 2025-06-06 RU 13508.33 ... 0.013819 ru2509 ru
43 2025-06-06 SP 6216.67 ... -0.159357 sp2509 sp
44 2025-06-06 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-06 BR 11630.0 ... -0.044282 br2508 br
46 2025-06-06 SI 8640.0 ... -0.155093 SI2509 si
47 2025-06-06 LC 60166.67 ... 0.010526 LC2507 lc
[48 rows x 15 columns]
2025-06-10 18:25:59,009 - future_1d - INFO - save future_spot 2025-06-06 completed
2025-06-10 18:26:08,883 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-09, end_day=2025-06-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-09 C 2300.0 ... 0.022174 c2507 c
1 2025-06-09 A 4295.0 ... -0.044237 a2509 a
2 2025-06-09 M 2944.0 ... 0.022758 m2509 m
3 2025-06-09 Y 8024.0 ... -0.032652 y2509 y
4 2025-06-09 P 8644.0 ... -0.056687 p2509 p
5 2025-06-09 JD 2915.0 ... 0.204117 jd2508 jd
6 2025-06-09 L 7346.67 ... -0.036434 l2509 l
7 2025-06-09 V 4602.0 ... 0.044111 v2509 v
8 2025-06-09 PP 7380.0 ... -0.060298 pp2509 pp
9 2025-06-09 I 746.11 ... -0.055769 i2509 i
10 2025-06-09 EG 4498.33 ... -0.051426 eg2509 eg
11 2025-06-09 EB 7870.0 ... -0.090216 eb2507 eb
12 2025-06-09 PG 4782.5 ... -0.141662 pg2507 pg
13 2025-06-09 LH 14270.0 ... -0.057463 lh2509 lh
14 2025-06-09 CF 14623.0 ... -0.07919 CF509 CF
15 2025-06-09 SR 6095.0 ... -0.059721 SR509 SR
16 2025-06-09 TA 4884.5 ... -0.050466 TA509 TA
17 2025-06-09 OI 9331.67 ... -0.019361 OI509 OI
18 2025-06-09 MA 2331.0 ... -0.026169 MA509 MA
19 2025-06-09 FG 1120.0 ... -0.105357 FG509 FG
20 2025-06-09 RM 2543.33 ... 0.022675 RM509 RM
21 2025-06-09 SF 5088.57 ... 0.014037 SF509 SF
22 2025-06-09 SM 5530.0 ... 0.003978 SM509 SM
23 2025-06-09 CY 23725.0 ... -0.168809 CY509 CY
24 2025-06-09 UR 1821.67 ... -0.067339 UR509 UR
25 2025-06-09 SA 1370.0 ... -0.114599 SA509 SA
26 2025-06-09 PF 6518.12 ... -0.027634 PF508 PF
27 2025-06-09 PX 7000.0 ... -0.065714 PX509 PX
28 2025-06-09 SH 885.0 ... 1.625989 SH509 SH
29 2025-06-09 CU 78891.67 ... -0.00281 cu2507 cu
30 2025-06-09 AL 20246.67 ... -0.011936 al2507 al
31 2025-06-09 ZN 22582.0 ... -0.020237 zn2507 zn
32 2025-06-09 PB 16593.75 ... 0.008211 pb2507 pb
33 2025-06-09 NI 124133.33 ... -0.011627 ni2507 ni
34 2025-06-09 SN 263900.0 ... -0.003941 sn2507 sn
35 2025-06-09 AU 768.07 ... 0.009361 au2508 au
36 2025-06-09 AG 8792.0 ... 0.00455 ag2508 ag
37 2025-06-09 RB 3069.0 ... -0.030303 rb2510 rb
38 2025-06-09 WR 3260.0 ... 0.011963 wr2510 wr
39 2025-06-09 HC 3170.0 ... -0.025552 hc2510 hc
40 2025-06-09 FU 5275.0 ... -0.453839 fu2509 fu
41 2025-06-09 BU 3630.0 ... -0.032782 bu2509 bu
42 2025-06-09 RU 13573.33 ... 0.004912 ru2509 ru
43 2025-06-09 SP 6216.67 ... -0.154531 sp2509 sp
44 2025-06-09 SS 13100.0 ... -0.034733 ss2508 ss
45 2025-06-09 BR 11760.0 ... -0.058673 br2508 br
46 2025-06-09 SI 8620.0 ... -0.147912 SI2509 si
47 2025-06-09 LC 60166.67 ... 0.008199 LC2507 lc
[48 rows x 15 columns]
2025-06-10 18:26:09,041 - future_1d - INFO - save future_spot 2025-06-09 completed
2025-06-10 18:26:18,292 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-10, end_day=2025-06-10) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-10 C 2308.57 ... 0.027476 c2507 c
1 2025-06-10 A 4295.0 ... -0.033527 a2509 a
2 2025-06-10 M 2952.0 ... 0.022696 m2509 m
3 2025-06-10 Y 8024.0 ... -0.032154 y2509 y
4 2025-06-10 P 8630.0 ... -0.054461 p2509 p
5 2025-06-10 JD 2915.0 ... 0.204117 jd2508 jd
6 2025-06-10 L 7361.67 ... -0.035681 l2509 l
7 2025-06-10 V 4608.0 ... 0.042752 v2509 v
8 2025-06-10 PP 7380.0 ... -0.059485 pp2509 pp
9 2025-06-10 I 740.0 ... -0.054054 i2509 i
10 2025-06-10 EG 4490.0 ... -0.049443 eg2509 eg
11 2025-06-10 EB 7886.0 ... -0.071519 eb2507 eb
12 2025-06-10 PG 4772.5 ... -0.139026 pg2507 pg
13 2025-06-10 LH 14250.0 ... -0.04807 lh2509 lh
14 2025-06-10 CF 14623.0 ... -0.077139 CF509 CF
15 2025-06-10 SR 6085.0 ... -0.059326 SR509 SR
16 2025-06-10 TA 4880.5 ... -0.049278 TA509 TA
17 2025-06-10 OI 9345.0 ... -0.017014 OI509 OI
18 2025-06-10 MA 2378.0 ... -0.042052 MA509 MA
19 2025-06-10 FG 1104.0 ... -0.097826 FG509 FG
20 2025-06-10 RM 2550.0 ... 0.025882 RM509 RM
21 2025-06-10 SF 5088.57 ... 0.015216 SF509 SF
22 2025-06-10 SM 5536.0 ... 0.003251 SM509 SM
23 2025-06-10 CY 23725.0 ... -0.168599 CY509 CY
24 2025-06-10 UR 1821.67 ... -0.071182 UR509 UR
25 2025-06-10 SA 1370.0 ... -0.121898 SA509 SA
26 2025-06-10 PF 6522.5 ... -0.028593 PF508 PF
27 2025-06-10 PX 7000.0 ... -0.064 PX509 PX
28 2025-06-10 SH 885.0 ... 1.629379 SH509 SH
29 2025-06-10 CU 79293.33 ... -0.00206 cu2507 cu
30 2025-06-10 AL 20193.33 ... -0.009574 al2507 al
31 2025-06-10 ZN 22146.0 ... -0.012463 zn2507 zn
32 2025-06-10 PB 16706.25 ... 0.008904 pb2507 pb
33 2025-06-10 NI 123000.0 ... -0.010894 ni2507 ni
34 2025-06-10 SN 264850.0 ... -0.004304 sn2507 sn
35 2025-06-10 AU 768.76 ... 0.005802 au2508 au
36 2025-06-10 AG 8792.0 ... 0.015355 ag2508 ag
37 2025-06-10 RB 3090.22 ... -0.03858 rb2510 rb
38 2025-06-10 WR 3267.5 ... 0.007804 wr2510 wr
39 2025-06-10 HC 3173.33 ... -0.02815 hc2510 hc
40 2025-06-10 FU 5275.0 ... -0.447583 fu2509 fu
41 2025-06-10 BU 3623.33 ... -0.03459 bu2509 bu
42 2025-06-10 RU 13670.83 ... 0.00762 ru2509 ru
43 2025-06-10 SP 6216.67 ... -0.150671 sp2509 sp
44 2025-06-10 SS 13100.0 ... -0.042748 ss2508 ss
45 2025-06-10 BR 11760.0 ... -0.056973 br2508 br
46 2025-06-10 SI 8620.0 ... -0.141531 SI2509 si
47 2025-06-10 LC 60066.67 ... 0.01354 LC2509 lc
[48 rows x 15 columns]
2025-06-10 18:26:18,466 - future_1d - INFO - save future_spot 2025-06-10 add
2025-06-10 18:26:18,474 - future_1d - INFO - 11 ... 32
date 2025-06-10 ... 2025-06-10
variety EB ... PB
spot_price 7886.0 ... 16706.25
near_contract eb2506 ... pb2506
near_contract_price 7378.0 ... 16825.0
dominant_contract eb2507 ... pb2507
dominant_contract_price 7322.0 ... 16855.0
near_month 2506 ... 2506
dominant_month 2507 ... 2507
near_basis -508.0 ... 118.75
dom_basis -564.0 ... 148.75
near_basis_rate -0.0644 ... 0.0071
dom_basis_rate -0.0715 ... 0.0089
symbol eb2507 ... pb2507
comd eb ... pb
created_at 2025-06-10 18:26:18.430804 ... 2025-06-10 18:26:18.430804
updated_at 2025-06-10 18:26:18.431182 ... 2025-06-10 18:26:18.431182
[17 rows x 5 columns]