=========================================================================
2025-06-13 16:25:25 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-06-13 16:25:27,159 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-13 16:25:27,479 - 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-13 16:25:27,652 - future_1d - INFO - save future_spot 2025-06-09 completed
2025-06-13 16:25:36,764 - 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-13 16:25:36,923 - future_1d - INFO - save future_spot 2025-06-10 completed
2025-06-13 16:25:40,319 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-11, end_day=2025-06-11) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-11 C 2318.57 ... 0.025632 c2507 c
1 2025-06-11 A 4295.0 ... -0.028172 a2509 a
2 2025-06-11 M 2978.0 ... 0.020819 m2509 m
3 2025-06-11 Y 7964.0 ... -0.030387 y2509 y
4 2025-06-11 P 8452.0 ... -0.050166 p2509 p
5 2025-06-11 JD 2860.0 ... 0.226573 jd2508 jd
6 2025-06-11 L 7366.67 ... -0.035521 l2509 l
7 2025-06-11 V 4613.0 ... 0.046174 v2509 v
8 2025-06-11 PP 7378.33 ... -0.05751 pp2509 pp
9 2025-06-11 I 744.22 ... -0.052028 i2509 i
10 2025-06-11 EG 4488.33 ... -0.046639 eg2509 eg
11 2025-06-11 EB 7886.0 ... -0.070251 eb2507 eb
12 2025-06-11 PG 4797.5 ... -0.141428 pg2507 pg
13 2025-06-11 LH 14150.0 ... -0.037809 lh2509 lh
14 2025-06-11 CF 14783.0 ... -0.083068 CF509 CF
15 2025-06-11 SR 6080.0 ... -0.063816 SR509 SR
16 2025-06-11 TA 4871.75 ... -0.054549 TA509 TA
17 2025-06-11 OI 9303.33 ... -0.014331 OI509 OI
18 2025-06-11 MA 2363.0 ... -0.035125 MA509 MA
19 2025-06-11 FG 1104.0 ... -0.097826 FG509 FG
20 2025-06-11 RM 2568.33 ... 0.027127 RM509 RM
21 2025-06-11 SF 5048.57 ... 0.031183 SF509 SF
22 2025-06-11 SM 5526.0 ... -0.001086 SM509 SM
23 2025-06-11 CY 23725.0 ... -0.16628 CY509 CY
24 2025-06-11 UR 1820.0 ... -0.08022 UR509 UR
25 2025-06-11 SA 1370.0 ... -0.121898 SA509 SA
26 2025-06-11 PF 6510.62 ... -0.03235 PF508 PF
27 2025-06-11 PX 7000.0 ... -0.070571 PX509 PX
28 2025-06-11 SH 883.0 ... 1.638732 SH509 SH
29 2025-06-11 CU 79341.67 ... -0.002038 cu2507 cu
30 2025-06-11 AL 20420.0 ... -0.012243 al2507 al
31 2025-06-11 ZN 22294.0 ... -0.01229 zn2507 zn
32 2025-06-11 PB 16712.5 ... 0.007629 pb2507 pb
33 2025-06-11 NI 122883.33 ... -0.011176 ni2507 ni
34 2025-06-11 SN 265850.0 ... -0.002445 sn2507 sn
35 2025-06-11 AU 774.63 ... 0.003137 au2508 au
36 2025-06-11 AG 8886.67 ... 0.001162 ag2508 ag
37 2025-06-11 RB 3098.22 ... -0.035252 rb2510 rb
38 2025-06-11 WR 3267.5 ... 0.013619 wr2510 wr
39 2025-06-11 HC 3173.33 ... -0.020902 hc2510 hc
40 2025-06-11 FU 5262.5 ... -0.445701 fu2509 fu
41 2025-06-11 BU 3630.0 ... -0.042424 bu2509 bu
42 2025-06-11 RU 13758.33 ... 0.005573 ru2509 ru
43 2025-06-11 SP 6216.67 ... -0.152923 sp2509 sp
44 2025-06-11 SS 13012.5 ... -0.037464 ss2508 ss
45 2025-06-11 BR 11650.0 ... -0.057082 br2508 br
46 2025-06-11 SI 8620.0 ... -0.134571 SI2509 si
47 2025-06-11 LC 60233.33 ... 0.021361 LC2509 lc
[48 rows x 15 columns]
2025-06-13 16:25:40,472 - future_1d - INFO - save future_spot 2025-06-11 completed
2025-06-13 16:25:46,054 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-12, end_day=2025-06-12) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-12 C 2330.0 ... 0.018884 c2507 c
1 2025-06-12 A 4295.0 ... -0.02468 a2509 a
2 2025-06-12 M 2982.0 ... 0.021462 m2509 m
3 2025-06-12 Y 7954.0 ... -0.031682 y2509 y
4 2025-06-12 P 8424.0 ... -0.049383 p2509 p
5 2025-06-12 JD 2810.0 ... 0.23879 jd2508 jd
6 2025-06-12 L 7388.33 ... -0.035777 l2509 l
7 2025-06-12 V 4617.0 ... 0.046134 v2509 v
8 2025-06-12 PP 7378.33 ... -0.053986 pp2509 pp
9 2025-06-12 I 742.11 ... -0.051354 i2509 i
10 2025-06-12 EG 4488.33 ... -0.049758 eg2509 eg
11 2025-06-12 EB 8002.0 ... -0.076856 eb2507 eb
12 2025-06-12 PG 4797.5 ... -0.159354 pg2508 pg
13 2025-06-12 LH 14120.0 ... -0.032932 lh2509 lh
14 2025-06-12 CF 14848.67 ... -0.090491 CF509 CF
15 2025-06-12 SR 6060.0 ... -0.065677 SR509 SR
16 2025-06-12 TA 4880.75 ... -0.050146 TA509 TA
17 2025-06-12 OI 9333.33 ... -0.017071 OI509 OI
18 2025-06-12 MA 2362.0 ... -0.028789 MA509 MA
19 2025-06-12 FG 1104.0 ... -0.105978 FG509 FG
20 2025-06-12 RM 2576.67 ... 0.0304 RM509 RM
21 2025-06-12 SF 5048.57 ... 0.024845 SF509 SF
22 2025-06-12 SM 5470.0 ... -0.004022 SM509 SM
23 2025-06-12 CY 23725.0 ... -0.167966 CY509 CY
24 2025-06-12 UR 1816.67 ... -0.089543 UR509 UR
25 2025-06-12 SA 1370.0 ... -0.133577 SA509 SA
26 2025-06-12 PF 6535.21 ... -0.032013 PF508 PF
27 2025-06-12 PX 7000.0 ... -0.064 PX509 PX
28 2025-06-12 SH 883.0 ... 1.619479 SH509 SH
29 2025-06-12 CU 79101.67 ... -0.005331 cu2507 cu
30 2025-06-12 AL 20420.0 ... -0.003918 al2507 al
31 2025-06-12 ZN 22304.0 ... -0.011164 zn2507 zn
32 2025-06-12 PB 16768.75 ... 0.007827 pb2507 pb
33 2025-06-12 NI 122066.67 ... -0.01308 ni2507 ni
34 2025-06-12 SN 265225.0 ... -0.002168 sn2507 sn
35 2025-06-12 AU 774.63 ... 0.008172 au2508 au
36 2025-06-12 AG 8886.67 ... -0.005927 ag2508 ag
37 2025-06-12 RB 3095.89 ... -0.039049 rb2510 rb
38 2025-06-12 WR 3257.5 ... 0.030852 wr2601 wr
39 2025-06-12 HC 3176.67 ... -0.027283 hc2510 hc
40 2025-06-12 FU 5287.5 ... -0.436028 fu2509 fu
41 2025-06-12 BU 3620.0 ... -0.030939 bu2509 bu
42 2025-06-12 RU 13458.33 ... 0.023158 ru2509 ru
43 2025-06-12 SP 6216.67 ... -0.157427 sp2509 sp
44 2025-06-12 SS 13012.5 ... -0.033237 ss2508 ss
45 2025-06-12 BR 11650.0 ... -0.053648 br2508 br
46 2025-06-12 SI 8620.0 ... -0.138051 SI2509 si
47 2025-06-12 LC 60633.33 ... 0.003738 LC2509 lc
[48 rows x 15 columns]
2025-06-13 16:25:46,215 - future_1d - INFO - save future_spot 2025-06-12 completed
2025-06-13 16:25:53,542 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-13, end_day=2025-06-13) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-13 C 2334.29 ... 0.015298 c2507 c
1 2025-06-13 A 4295.0 ... -0.017928 a2509 a
2 2025-06-13 M 2982.0 ... 0.022133 m2509 m
3 2025-06-13 Y 8064.0 ... -0.036458 y2509 y
4 2025-06-13 P 8424.0 ... -0.0349 p2509 p
5 2025-06-13 JD 2790.0 ... 0.266308 jd2508 jd
6 2025-06-13 L 7396.67 ... -0.025102 l2509 l
7 2025-06-13 V 4656.0 ... 0.040163 v2509 v
8 2025-06-13 PP 7403.33 ... -0.047456 pp2509 pp
9 2025-06-13 I 737.0 ... -0.046133 i2509 i
10 2025-06-13 EG 4535.0 ... -0.043881 eg2509 eg
11 2025-06-13 EB 8068.0 ... -0.056396 eb2507 eb
12 2025-06-13 PG 4822.5 ... -0.131156 pg2508 pg
13 2025-06-13 LH 14120.0 ... -0.024079 lh2509 lh
14 2025-06-13 CF 14831.17 ... -0.092115 CF509 CF
15 2025-06-13 SR 6050.0 ... -0.067438 SR509 SR
16 2025-06-13 TA 4932.75 ... -0.02975 TA509 TA
17 2025-06-13 OI 9333.33 ... -0.00325 OI509 OI
18 2025-06-13 MA 2484.0 ... -0.042673 MA509 MA
19 2025-06-13 FG 1104.0 ... -0.113225 FG509 FG
20 2025-06-13 RM 2606.67 ... 0.025446 RM509 RM
21 2025-06-13 SF 5048.57 ... 0.027222 SF509 SF
22 2025-06-13 SM 5476.0 ... -0.003652 SM509 SM
23 2025-06-13 CY 23725.0 ... -0.168599 CY509 CY
24 2025-06-13 UR 1796.0 ... -0.07294 UR509 UR
25 2025-06-13 SA 1370.0 ... -0.150365 SA509 SA
26 2025-06-13 PF 6640.21 ... -0.023826 PF508 PF
27 2025-06-13 PX 7000.0 ... -0.032571 PX509 PX
28 2025-06-13 SH 883.0 ... 1.586636 SH509 SH
29 2025-06-13 CU 78933.33 ... -0.006757 cu2507 cu
30 2025-06-13 AL 20740.0 ... -0.015188 al2507 al
31 2025-06-13 ZN 22246.0 ... -0.013306 zn2507 zn
32 2025-06-13 PB 16850.0 ... 0.005935 pb2507 pb
33 2025-06-13 NI 122066.67 ... -0.016685 ni2507 ni
34 2025-06-13 SN 265562.5 ... -0.00498 sn2507 sn
35 2025-06-13 AU 793.04 ... -0.000101 au2508 au
36 2025-06-13 AG 8833.33 ... -0.001735 ag2508 ag
37 2025-06-13 RB 3055.0 ... -0.030769 rb2510 rb
38 2025-06-13 WR 3237.5 ... 0.03722 wr2601 wr
39 2025-06-13 HC 3166.67 ... -0.030212 hc2510 hc
40 2025-06-13 FU 5350.0 ... -0.407664 fu2509 fu
41 2025-06-13 BU 3696.67 ... -0.015601 bu2509 bu
42 2025-06-13 RU 13758.33 ... 0.004119 ru2509 ru
43 2025-06-13 SP 6183.33 ... -0.158382 sp2509 sp
44 2025-06-13 SS 12962.5 ... -0.031051 ss2508 ss
45 2025-06-13 BR 11650.0 ... -0.043348 br2508 br
46 2025-06-13 SI 8620.0 ... -0.148492 SI2509 si
47 2025-06-13 LC 60700.0 ... -0.008237 LC2509 lc
[48 rows x 15 columns]
2025-06-13 16:25:53,712 - future_1d - INFO - save future_spot 2025-06-13 add
2025-06-13 16:25:53,720 - future_1d - INFO - 0 ... 4
date 2025-06-13 ... 2025-06-13
variety C ... P
spot_price 2334.29 ... 8424.0
near_contract c2507 ... p2506
near_contract_price 2370.0 ... 8600.0
dominant_contract c2507 ... p2509
dominant_contract_price 2370.0 ... 8130.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 35.71 ... 176.0
dom_basis 35.71 ... -294.0
near_basis_rate 0.0153 ... 0.0209
dom_basis_rate 0.0153 ... -0.0349
symbol c2507 ... p2509
comd c ... p
created_at 2025-06-13 16:25:53.672887 ... 2025-06-13 16:25:53.672887
updated_at 2025-06-13 16:25:53.673262 ... 2025-06-13 16:25:53.673262
[17 rows x 5 columns]
=========================================================================
2025-06-13 18:25:21 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-06-13 18:25:23,615 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-13 18:25:24,091 - 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-13 18:25:24,262 - future_1d - INFO - save future_spot 2025-06-09 completed
2025-06-13 18:25:28,000 - 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-13 18:25:28,156 - future_1d - INFO - save future_spot 2025-06-10 completed
2025-06-13 18:25:34,158 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-11, end_day=2025-06-11) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-11 C 2318.57 ... 0.025632 c2507 c
1 2025-06-11 A 4295.0 ... -0.028172 a2509 a
2 2025-06-11 M 2978.0 ... 0.020819 m2509 m
3 2025-06-11 Y 7964.0 ... -0.030387 y2509 y
4 2025-06-11 P 8452.0 ... -0.050166 p2509 p
5 2025-06-11 JD 2860.0 ... 0.226573 jd2508 jd
6 2025-06-11 L 7366.67 ... -0.035521 l2509 l
7 2025-06-11 V 4613.0 ... 0.046174 v2509 v
8 2025-06-11 PP 7378.33 ... -0.05751 pp2509 pp
9 2025-06-11 I 744.22 ... -0.052028 i2509 i
10 2025-06-11 EG 4488.33 ... -0.046639 eg2509 eg
11 2025-06-11 EB 7886.0 ... -0.070251 eb2507 eb
12 2025-06-11 PG 4797.5 ... -0.141428 pg2507 pg
13 2025-06-11 LH 14150.0 ... -0.037809 lh2509 lh
14 2025-06-11 CF 14783.0 ... -0.083068 CF509 CF
15 2025-06-11 SR 6080.0 ... -0.063816 SR509 SR
16 2025-06-11 TA 4871.75 ... -0.054549 TA509 TA
17 2025-06-11 OI 9303.33 ... -0.014331 OI509 OI
18 2025-06-11 MA 2363.0 ... -0.035125 MA509 MA
19 2025-06-11 FG 1104.0 ... -0.097826 FG509 FG
20 2025-06-11 RM 2568.33 ... 0.027127 RM509 RM
21 2025-06-11 SF 5048.57 ... 0.031183 SF509 SF
22 2025-06-11 SM 5526.0 ... -0.001086 SM509 SM
23 2025-06-11 CY 23725.0 ... -0.16628 CY509 CY
24 2025-06-11 UR 1820.0 ... -0.08022 UR509 UR
25 2025-06-11 SA 1370.0 ... -0.121898 SA509 SA
26 2025-06-11 PF 6510.62 ... -0.03235 PF508 PF
27 2025-06-11 PX 7000.0 ... -0.070571 PX509 PX
28 2025-06-11 SH 883.0 ... 1.638732 SH509 SH
29 2025-06-11 CU 79341.67 ... -0.002038 cu2507 cu
30 2025-06-11 AL 20420.0 ... -0.012243 al2507 al
31 2025-06-11 ZN 22294.0 ... -0.01229 zn2507 zn
32 2025-06-11 PB 16712.5 ... 0.007629 pb2507 pb
33 2025-06-11 NI 122883.33 ... -0.011176 ni2507 ni
34 2025-06-11 SN 265850.0 ... -0.002445 sn2507 sn
35 2025-06-11 AU 774.63 ... 0.003137 au2508 au
36 2025-06-11 AG 8886.67 ... 0.001162 ag2508 ag
37 2025-06-11 RB 3098.22 ... -0.035252 rb2510 rb
38 2025-06-11 WR 3267.5 ... 0.013619 wr2510 wr
39 2025-06-11 HC 3173.33 ... -0.020902 hc2510 hc
40 2025-06-11 FU 5262.5 ... -0.445701 fu2509 fu
41 2025-06-11 BU 3630.0 ... -0.042424 bu2509 bu
42 2025-06-11 RU 13758.33 ... 0.005573 ru2509 ru
43 2025-06-11 SP 6216.67 ... -0.152923 sp2509 sp
44 2025-06-11 SS 13012.5 ... -0.037464 ss2508 ss
45 2025-06-11 BR 11650.0 ... -0.057082 br2508 br
46 2025-06-11 SI 8620.0 ... -0.134571 SI2509 si
47 2025-06-11 LC 60233.33 ... 0.021361 LC2509 lc
[48 rows x 15 columns]
2025-06-13 18:25:34,312 - future_1d - INFO - save future_spot 2025-06-11 completed
2025-06-13 18:25:43,572 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-12, end_day=2025-06-12) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-12 C 2330.0 ... 0.018884 c2507 c
1 2025-06-12 A 4295.0 ... -0.02468 a2509 a
2 2025-06-12 M 2982.0 ... 0.021462 m2509 m
3 2025-06-12 Y 7954.0 ... -0.031682 y2509 y
4 2025-06-12 P 8424.0 ... -0.049383 p2509 p
5 2025-06-12 JD 2810.0 ... 0.23879 jd2508 jd
6 2025-06-12 L 7388.33 ... -0.035777 l2509 l
7 2025-06-12 V 4617.0 ... 0.046134 v2509 v
8 2025-06-12 PP 7378.33 ... -0.053986 pp2509 pp
9 2025-06-12 I 742.11 ... -0.051354 i2509 i
10 2025-06-12 EG 4488.33 ... -0.049758 eg2509 eg
11 2025-06-12 EB 8002.0 ... -0.076856 eb2507 eb
12 2025-06-12 PG 4797.5 ... -0.159354 pg2508 pg
13 2025-06-12 LH 14120.0 ... -0.032932 lh2509 lh
14 2025-06-12 CF 14848.67 ... -0.090491 CF509 CF
15 2025-06-12 SR 6060.0 ... -0.065677 SR509 SR
16 2025-06-12 TA 4880.75 ... -0.050146 TA509 TA
17 2025-06-12 OI 9333.33 ... -0.017071 OI509 OI
18 2025-06-12 MA 2362.0 ... -0.028789 MA509 MA
19 2025-06-12 FG 1104.0 ... -0.105978 FG509 FG
20 2025-06-12 RM 2576.67 ... 0.0304 RM509 RM
21 2025-06-12 SF 5048.57 ... 0.024845 SF509 SF
22 2025-06-12 SM 5470.0 ... -0.004022 SM509 SM
23 2025-06-12 CY 23725.0 ... -0.167966 CY509 CY
24 2025-06-12 UR 1816.67 ... -0.089543 UR509 UR
25 2025-06-12 SA 1370.0 ... -0.133577 SA509 SA
26 2025-06-12 PF 6535.21 ... -0.032013 PF508 PF
27 2025-06-12 PX 7000.0 ... -0.064 PX509 PX
28 2025-06-12 SH 883.0 ... 1.619479 SH509 SH
29 2025-06-12 CU 79101.67 ... -0.005331 cu2507 cu
30 2025-06-12 AL 20420.0 ... -0.003918 al2507 al
31 2025-06-12 ZN 22304.0 ... -0.011164 zn2507 zn
32 2025-06-12 PB 16768.75 ... 0.007827 pb2507 pb
33 2025-06-12 NI 122066.67 ... -0.01308 ni2507 ni
34 2025-06-12 SN 265225.0 ... -0.002168 sn2507 sn
35 2025-06-12 AU 774.63 ... 0.008172 au2508 au
36 2025-06-12 AG 8886.67 ... -0.005927 ag2508 ag
37 2025-06-12 RB 3095.89 ... -0.039049 rb2510 rb
38 2025-06-12 WR 3257.5 ... 0.030852 wr2601 wr
39 2025-06-12 HC 3176.67 ... -0.027283 hc2510 hc
40 2025-06-12 FU 5287.5 ... -0.436028 fu2509 fu
41 2025-06-12 BU 3620.0 ... -0.030939 bu2509 bu
42 2025-06-12 RU 13458.33 ... 0.023158 ru2509 ru
43 2025-06-12 SP 6216.67 ... -0.157427 sp2509 sp
44 2025-06-12 SS 13012.5 ... -0.033237 ss2508 ss
45 2025-06-12 BR 11650.0 ... -0.053648 br2508 br
46 2025-06-12 SI 8620.0 ... -0.138051 SI2509 si
47 2025-06-12 LC 60633.33 ... 0.003738 LC2509 lc
[48 rows x 15 columns]
2025-06-13 18:25:43,724 - future_1d - INFO - save future_spot 2025-06-12 completed
2025-06-13 18:25:53,409 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-13, end_day=2025-06-13) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-13 C 2334.29 ... 0.015298 c2507 c
1 2025-06-13 A 4295.0 ... -0.017928 a2509 a
2 2025-06-13 M 2994.0 ... 0.018036 m2509 m
3 2025-06-13 Y 8064.0 ... -0.036458 y2509 y
4 2025-06-13 P 8528.0 ... -0.04667 p2509 p
5 2025-06-13 JD 2790.0 ... 0.266308 jd2508 jd
6 2025-06-13 L 7396.67 ... -0.025102 l2509 l
7 2025-06-13 V 4656.0 ... 0.040163 v2509 v
8 2025-06-13 PP 7403.33 ... -0.047456 pp2509 pp
9 2025-06-13 I 737.0 ... -0.046133 i2509 i
10 2025-06-13 EG 4535.0 ... -0.043881 eg2509 eg
11 2025-06-13 EB 8068.0 ... -0.056396 eb2507 eb
12 2025-06-13 PG 4822.5 ... -0.131156 pg2508 pg
13 2025-06-13 LH 14120.0 ... -0.024079 lh2509 lh
14 2025-06-13 CF 14831.17 ... -0.092115 CF509 CF
15 2025-06-13 SR 6050.0 ... -0.067438 SR509 SR
16 2025-06-13 TA 4932.75 ... -0.02975 TA509 TA
17 2025-06-13 OI 9473.33 ... -0.01798 OI509 OI
18 2025-06-13 MA 2484.0 ... -0.042673 MA509 MA
19 2025-06-13 FG 1104.0 ... -0.113225 FG509 FG
20 2025-06-13 RM 2606.67 ... 0.025446 RM509 RM
21 2025-06-13 SF 5048.57 ... 0.027222 SF509 SF
22 2025-06-13 SM 5476.0 ... -0.003652 SM509 SM
23 2025-06-13 CY 23725.0 ... -0.168599 CY509 CY
24 2025-06-13 UR 1796.0 ... -0.07294 UR509 UR
25 2025-06-13 SA 1370.0 ... -0.150365 SA509 SA
26 2025-06-13 PF 6640.21 ... -0.023826 PF508 PF
27 2025-06-13 PX 7000.0 ... -0.032571 PX509 PX
28 2025-06-13 SH 883.0 ... 1.586636 SH509 SH
29 2025-06-13 CU 78933.33 ... -0.006757 cu2507 cu
30 2025-06-13 AL 20740.0 ... -0.015188 al2507 al
31 2025-06-13 ZN 22246.0 ... -0.013306 zn2507 zn
32 2025-06-13 PB 16850.0 ... 0.005935 pb2507 pb
33 2025-06-13 NI 121800.0 ... -0.014532 ni2507 ni
34 2025-06-13 SN 265562.5 ... -0.00498 sn2507 sn
35 2025-06-13 AU 793.04 ... -0.000101 au2508 au
36 2025-06-13 AG 8833.33 ... -0.001735 ag2508 ag
37 2025-06-13 RB 3055.0 ... -0.030769 rb2510 rb
38 2025-06-13 WR 3237.5 ... 0.03722 wr2601 wr
39 2025-06-13 HC 3166.67 ... -0.030212 hc2510 hc
40 2025-06-13 FU 5350.0 ... -0.407664 fu2509 fu
41 2025-06-13 BU 3696.67 ... -0.015601 bu2509 bu
42 2025-06-13 RU 13758.33 ... 0.004119 ru2509 ru
43 2025-06-13 SP 6183.33 ... -0.158382 sp2509 sp
44 2025-06-13 SS 12962.5 ... -0.031051 ss2508 ss
45 2025-06-13 BR 11750.0 ... -0.051489 br2508 br
46 2025-06-13 SI 8620.0 ... -0.148492 SI2509 si
47 2025-06-13 LC 60700.0 ... -0.008237 LC2509 lc
[48 rows x 15 columns]
2025-06-13 18:25:53,582 - future_1d - INFO - save future_spot 2025-06-13 add
2025-06-13 18:25:53,590 - future_1d - INFO - 2 ... 45
date 2025-06-13 ... 2025-06-13
variety M ... BR
spot_price 2994.0 ... 11750.0
near_contract m2507 ... br2506
near_contract_price 2872.0 ... 11155.0
dominant_contract m2509 ... br2508
dominant_contract_price 3048.0 ... 11145.0
near_month 2507 ... 2506
dominant_month 2509 ... 2508
near_basis -122.0 ... -595.0
dom_basis 54.0 ... -605.0
near_basis_rate -0.0407 ... -0.0506
dom_basis_rate 0.018 ... -0.0515
symbol m2509 ... br2508
comd m ... br
created_at 2025-06-13 18:25:53.548168 ... 2025-06-13 18:25:53.548168
updated_at 2025-06-13 18:25:53.548537 ... 2025-06-13 18:25:53.548537
[17 rows x 5 columns]