=========================================================================
2025-06-23 16:25:15 Mon START TASK.01 future_1d future_spot
=========================================================================
2025-06-23 16:25:17,740 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-23 16:25:18,072 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-17, end_day=2025-06-17) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-17 C 2335.71 ... 0.024528 c2509 c
1 2025-06-17 A 4295.0 ... -0.013737 a2509 a
2 2025-06-17 M 2998.0 ... 0.021014 m2509 m
3 2025-06-17 Y 8234.0 ... -0.032305 y2509 y
4 2025-06-17 P 8848.0 ... -0.044304 p2509 p
5 2025-06-17 JD 2800.0 ... 0.268929 jd2508 jd
6 2025-06-17 L 7471.67 ... -0.023779 l2509 l
7 2025-06-17 V 4649.0 ... 0.040654 v2509 v
8 2025-06-17 PP 7461.67 ... -0.047532 pp2509 pp
9 2025-06-17 JM 1221.25 ... -0.349028 jm2509 jm
10 2025-06-17 I 734.22 ... -0.047969 i2509 i
11 2025-06-17 EG 4526.67 ... -0.03461 eg2509 eg
12 2025-06-17 EB 8230.0 ... -0.09271 eb2507 eb
13 2025-06-17 PG 4885.0 ... -0.121801 pg2508 pg
14 2025-06-17 LH 14180.0 ... -0.02574 lh2509 lh
15 2025-06-17 CF 14846.5 ... -0.090695 CF509 CF
16 2025-06-17 SR 6060.0 ... -0.063861 SR509 SR
17 2025-06-17 TA 5045.0 ... -0.058474 TA509 TA
18 2025-06-17 OI 9735.0 ... -0.017874 OI509 OI
19 2025-06-17 MA 2646.0 ... -0.078609 MA509 MA
20 2025-06-17 FG 1104.0 ... -0.115942 FG509 FG
21 2025-06-17 RM 2611.67 ... 0.022334 RM509 RM
22 2025-06-17 SF 5054.29 ... 0.043074 SF509 SF
23 2025-06-17 SM 5502.0 ... 0.008361 SM509 SM
24 2025-06-17 CY 23575.0 ... -0.162248 CY509 CY
25 2025-06-17 UR 1820.0 ... -0.032967 UR509 UR
26 2025-06-17 SA 1370.0 ... -0.149635 SA509 SA
27 2025-06-17 PF 6666.25 ... -0.026739 PF508 PF
28 2025-06-17 PX 7000.0 ... -0.038571 PX509 PX
29 2025-06-17 SH 871.0 ... 1.615385 SH509 SH
30 2025-06-17 CU 78740.0 ... -0.002667 cu2507 cu
31 2025-06-17 AL 20633.33 ... -0.011066 al2507 al
32 2025-06-17 ZN 22008.0 ... -0.006043 zn2507 zn
33 2025-06-17 PB 16800.0 ... 0.00744 pb2507 pb
34 2025-06-17 NI 120008.33 ... -0.008569 ni2507 ni
35 2025-06-17 SN 264275.0 ... -0.000057 sn2507 sn
36 2025-06-17 AU 782.36 ... 0.005982 au2508 au
37 2025-06-17 AG 8805.67 ... 0.003558 ag2508 ag
38 2025-06-17 RB 3062.33 ... -0.026232 rb2510 rb
39 2025-06-17 WR 3252.5 ... 0.02844 wr2601 wr
40 2025-06-17 HC 3173.33 ... -0.025629 hc2510 hc
41 2025-06-17 FU 5425.0 ... -0.402212 fu2509 fu
42 2025-06-17 BU 3710.0 ... -0.022372 bu2509 bu
43 2025-06-17 RU 13718.33 ... 0.009963 ru2509 ru
44 2025-06-17 SP 6140.0 ... -0.151466 sp2509 sp
45 2025-06-17 SS 12912.5 ... -0.031171 ss2508 ss
46 2025-06-17 BR 11870.0 ... -0.046335 br2508 br
47 2025-06-17 SI 8620.0 ... -0.147912 SI2509 si
48 2025-06-17 LC 60366.67 ... -0.009056 LC2509 lc
[49 rows x 15 columns]
2025-06-23 16:25:18,258 - future_1d - INFO - save future_spot 2025-06-17 completed
2025-06-23 16:25:27,043 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-18, end_day=2025-06-18) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-18 C 2335.71 ... 0.028809 c2509 c
1 2025-06-18 A 4295.0 ... -0.007916 a2509 a
2 2025-06-18 M 2998.0 ... 0.02435 m2509 m
3 2025-06-18 Y 8234.0 ... -0.024047 y2509 y
4 2025-06-18 P 8848.0 ... -0.039331 p2509 p
5 2025-06-18 JD 2800.0 ... 0.283214 jd2508 jd
6 2025-06-18 L 7525.0 ... -0.017807 l2509 l
7 2025-06-18 V 4665.0 ... 0.04523 v2509 v
8 2025-06-18 PP 7461.67 ... -0.036543 pp2509 pp
9 2025-06-18 JM 1221.25 ... -0.351894 jm2509 jm
10 2025-06-18 I 728.56 ... -0.046063 i2509 i
11 2025-06-18 EG 4540.0 ... -0.020044 eg2509 eg
12 2025-06-18 EB 8230.0 ... -0.087485 eb2508 eb
13 2025-06-18 PG 4885.0 ... -0.095599 pg2508 pg
14 2025-06-18 LH 14170.0 ... -0.024347 lh2509 lh
15 2025-06-18 CF 14842.17 ... -0.087398 CF509 CF
16 2025-06-18 SR 6060.0 ... -0.064026 SR509 SR
17 2025-06-18 TA 5165.5 ... -0.052173 TA509 TA
18 2025-06-18 FG 1104.0 ... -0.112319 FG509 FG
19 2025-06-18 RM 2630.0 ... 0.022814 RM509 RM
20 2025-06-18 SF 5054.29 ... 0.045053 SF509 SF
21 2025-06-18 SM 5508.0 ... 0.011256 SM509 SM
22 2025-06-18 CY 23575.0 ... -0.158643 CY509 CY
23 2025-06-18 UR 1834.0 ... -0.027263 UR509 UR
24 2025-06-18 SA 1370.0 ... -0.147445 SA509 SA
25 2025-06-18 PF 6778.96 ... -0.016368 PF508 PF
26 2025-06-18 PX 7000.0 ... -0.005714 PX509 PX
27 2025-06-18 SH 867.0 ... 1.643599 SH509 SH
28 2025-06-18 CU 78831.67 ... -0.002685 cu2507 cu
29 2025-06-18 AL 20920.0 ... -0.02175 al2508 al
30 2025-06-18 ZN 22148.0 ... -0.016841 zn2508 zn
31 2025-06-18 PB 16781.25 ... 0.003203 pb2507 pb
32 2025-06-18 NI 119875.0 ... -0.012805 ni2507 ni
33 2025-06-18 SN 264275.0 ... -0.00316 sn2507 sn
34 2025-06-18 AU 781.77 ... 0.00426 au2508 au
35 2025-06-18 AG 8962.67 ... 0.003161 ag2508 ag
36 2025-06-18 RB 3064.0 ... -0.026762 rb2510 rb
37 2025-06-18 WR 3257.5 ... 0.016424 wr2601 wr
38 2025-06-18 HC 3173.33 ... -0.023423 hc2510 hc
39 2025-06-18 FU 5437.5 ... -0.389793 fu2509 fu
40 2025-06-18 BU 3718.33 ... -0.009502 bu2509 bu
41 2025-06-18 RU 13858.33 ... 0.010223 ru2509 ru
42 2025-06-18 SP 6116.67 ... -0.14496 sp2509 sp
43 2025-06-18 SS 12875.0 ... -0.029903 ss2508 ss
44 2025-06-18 BR 12040.0 ... -0.043605 br2508 br
45 2025-06-18 SI 8620.0 ... -0.137471 SI2509 si
46 2025-06-18 LC 60366.67 ... -0.003424 LC2509 lc
[47 rows x 15 columns]
2025-06-23 16:25:27,196 - future_1d - INFO - save future_spot 2025-06-18 completed
2025-06-23 16:25:30,781 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-19, end_day=2025-06-19) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-19 C 2338.57 ... 0.026696 c2509 c
1 2025-06-19 A 4295.0 ... -0.015832 a2509 a
2 2025-06-19 M 3016.0 ... 0.015584 m2509 m
3 2025-06-19 Y 8394.0 ... -0.032642 y2509 y
4 2025-06-19 P 8896.0 ... -0.040917 p2509 p
5 2025-06-19 JD 2875.0 ... 0.254609 jd2508 jd
6 2025-06-19 L 7543.33 ... -0.0133 l2509 l
7 2025-06-19 V 4646.0 ... 0.052303 v2509 v
8 2025-06-19 PP 7471.67 ... -0.029802 pp2509 pp
9 2025-06-19 JM 1221.25 ... -0.355988 jm2509 jm
10 2025-06-19 I 722.56 ... -0.036066 i2509 i
11 2025-06-19 EG 4553.33 ... -0.012152 eg2509 eg
12 2025-06-19 EB 8220.0 ... -0.075547 eb2508 eb
13 2025-06-19 PG 4890.0 ... -0.084458 pg2508 pg
14 2025-06-19 LH 14200.0 ... -0.030282 lh2509 lh
15 2025-06-19 CF 14882.0 ... -0.093536 CF509 CF
16 2025-06-19 SR 6050.0 ... -0.064132 SR509 SR
17 2025-06-19 TA 5246.5 ... -0.062613 TA509 TA
18 2025-06-19 FG 1104.0 ... -0.099638 FG509 FG
19 2025-06-19 RM 2615.0 ... 0.025239 RM509 RM
20 2025-06-19 SF 5114.29 ... 0.034357 SF509 SF
21 2025-06-19 SM 5508.0 ... 0.009804 SM509 SM
22 2025-06-19 CY 23575.0 ... -0.161824 CY509 CY
23 2025-06-19 UR 1842.0 ... -0.033116 UR509 UR
24 2025-06-19 SA 1370.0 ... -0.141606 SA509 SA
25 2025-06-19 PF 6803.96 ... -0.014104 PF508 PF
26 2025-06-19 PX 7000.0 ... 0.0 PX509 PX
27 2025-06-19 SH 863.0 ... 1.651217 SH509 SH
28 2025-06-19 CU 78721.67 ... -0.002943 cu2507 cu
29 2025-06-19 AL 20786.67 ... -0.014994 al2508 al
30 2025-06-19 ZN 21974.0 ... -0.012242 zn2508 zn
31 2025-06-19 PB 16856.25 ... 0.001409 pb2507 pb
32 2025-06-19 NI 120458.33 ... -0.01302 ni2507 ni
33 2025-06-19 SN 264462.5 ... -0.00277 sn2507 sn
34 2025-06-19 AU 780.59 ... 0.005547 au2508 au
35 2025-06-19 AG 8871.0 ... 0.004735 ag2508 ag
36 2025-06-19 RB 3062.33 ... -0.025252 rb2510 rb
37 2025-06-19 WR 3252.5 ... 0.017986 wr2601 wr
38 2025-06-19 HC 3173.33 ... -0.021848 hc2510 hc
39 2025-06-19 FU 5450.0 ... -0.387706 fu2509 fu
40 2025-06-19 BU 3710.0 ... 0.003235 bu2509 bu
41 2025-06-19 RU 13858.33 ... 0.010944 ru2509 ru
42 2025-06-19 SP 6090.0 ... -0.137274 sp2509 sp
43 2025-06-19 SS 12875.0 ... -0.024466 ss2508 ss
44 2025-06-19 BR 12040.0 ... -0.03613 br2508 br
45 2025-06-19 SI 8620.0 ... -0.136891 SI2509 si
46 2025-06-19 LC 60300.0 ... -0.00398 LC2509 lc
[47 rows x 15 columns]
2025-06-23 16:25:30,952 - future_1d - INFO - save future_spot 2025-06-19 add
2025-06-23 16:25:30,959 - future_1d - INFO - 0 ... 4
date 2025-06-19 ... 2025-06-19
variety C ... P
spot_price 2338.57 ... 8896.0
near_contract c2507 ... p2507
near_contract_price 2365.0 ... 8638.0
dominant_contract c2509 ... p2509
dominant_contract_price 2401.0 ... 8532.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 26.43 ... -258.0
dom_basis 62.43 ... -364.0
near_basis_rate 0.0113 ... -0.029
dom_basis_rate 0.0267 ... -0.0409
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-23 16:25:30.913432 ... 2025-06-23 16:25:30.913432
updated_at 2025-06-23 16:25:30.913872 ... 2025-06-23 16:25:30.913872
[17 rows x 5 columns]
2025-06-23 16:25:35,103 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-20, end_day=2025-06-20) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-20 C 2342.86 ... 0.027377 c2509 c
1 2025-06-20 A 4295.0 ... -0.010244 a2509 a
2 2025-06-20 M 3024.0 ... 0.015212 m2509 m
3 2025-06-20 Y 8414.0 ... -0.02995 y2509 y
4 2025-06-20 P 8832.0 ... -0.032156 p2509 p
5 2025-06-20 JD 2925.0 ... 0.238291 jd2508 jd
6 2025-06-20 L 7556.67 ... -0.014645 l2509 l
7 2025-06-20 V 4677.0 ... 0.049818 v2509 v
8 2025-06-20 PP 7471.67 ... -0.027259 pp2509 pp
9 2025-06-20 JM 1221.25 ... -0.34739 jm2509 jm
10 2025-06-20 I 724.67 ... -0.030593 i2509 i
11 2025-06-20 EG 4558.33 ... -0.008848 eg2509 eg
12 2025-06-20 EB 8226.0 ... -0.071845 eb2508 eb
13 2025-06-20 PG 4890.0 ... -0.07362 pg2508 pg
14 2025-06-20 LH 14180.0 ... -0.023272 lh2509 lh
15 2025-06-20 CF 14869.67 ... -0.091775 CF509 CF
16 2025-06-20 SR 6050.0 ... -0.058678 SR509 SR
17 2025-06-20 TA 5271.5 ... -0.049986 TA509 TA
18 2025-06-20 FG 1104.0 ... -0.088768 FG509 FG
19 2025-06-20 RM 2616.67 ... 0.025731 RM509 RM
20 2025-06-20 SF 5128.57 ... 0.038886 SF509 SF
21 2025-06-20 SM 5564.0 ... 0.015457 SM509 SM
22 2025-06-20 CY 23575.0 ... -0.161188 CY509 CY
23 2025-06-20 UR 1834.0 ... -0.047983 UR509 UR
24 2025-06-20 SA 1370.0 ... -0.140876 SA509 SA
25 2025-06-20 PF 6866.46 ... -0.00764 PF508 PF
26 2025-06-20 PX 7000.0 ... 0.018 PX509 PX
27 2025-06-20 SH 857.0 ... 1.64294 SH509 SH
28 2025-06-20 CU 78436.67 ... -0.003272 cu2507 cu
29 2025-06-20 AL 20736.67 ... -0.015512 al2508 al
30 2025-06-20 ZN 22032.0 ... -0.013253 zn2508 zn
31 2025-06-20 PB 16812.5 ... 0.003123 pb2508 pb
32 2025-06-20 NI 120641.67 ... -0.015431 ni2507 ni
33 2025-06-20 SN 263350.0 ... -0.009265 sn2507 sn
34 2025-06-20 AU 773.21 ... 0.010178 au2508 au
35 2025-06-20 AG 8759.0 ... -0.002283 ag2508 ag
36 2025-06-20 RB 3072.67 ... -0.025603 rb2510 rb
37 2025-06-20 WR 3250.0 ... 0.02 wr2601 wr
38 2025-06-20 HC 3190.0 ... -0.022884 hc2510 hc
39 2025-06-20 FU 5450.0 ... -0.38 fu2509 fu
40 2025-06-20 BU 3746.67 ... 0.001156 bu2509 bu
41 2025-06-20 RU 13758.33 ... 0.013931 ru2509 ru
42 2025-06-20 SP 6083.33 ... -0.14652 sp2509 sp
43 2025-06-20 SS 12875.0 ... -0.026408 ss2508 ss
44 2025-06-20 BR 12040.0 ... -0.037375 br2508 br
45 2025-06-20 SI 8620.0 ... -0.137471 SI2509 si
46 2025-06-20 LC 60066.67 ... -0.008102 LC2509 lc
[47 rows x 15 columns]
2025-06-23 16:25:35,284 - future_1d - INFO - save future_spot 2025-06-20 add
2025-06-23 16:25:35,292 - future_1d - INFO - 0 ... 4
date 2025-06-20 ... 2025-06-20
variety C ... P
spot_price 2342.86 ... 8832.0
near_contract c2507 ... p2507
near_contract_price 2371.0 ... 8652.0
dominant_contract c2509 ... p2509
dominant_contract_price 2407.0 ... 8548.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 28.14 ... -180.0
dom_basis 64.14 ... -284.0
near_basis_rate 0.012 ... -0.0204
dom_basis_rate 0.0274 ... -0.0322
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-23 16:25:35.244972 ... 2025-06-23 16:25:35.244972
updated_at 2025-06-23 16:25:35.245346 ... 2025-06-23 16:25:35.245346
[17 rows x 5 columns]
2025-06-23 16:25:43,818 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-23, end_day=2025-06-23) done
2025-06-23 16:25:43,833 - future_1d - INFO - save future_spot 2025-06-23 failed
=========================================================================
2025-06-23 18:25:15 Mon START TASK.01 future_1d future_spot
=========================================================================
2025-06-23 18:25:17,425 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-23 18:25:17,861 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-17, end_day=2025-06-17) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-17 C 2335.71 ... 0.024528 c2509 c
1 2025-06-17 A 4295.0 ... -0.013737 a2509 a
2 2025-06-17 M 2998.0 ... 0.021014 m2509 m
3 2025-06-17 Y 8234.0 ... -0.032305 y2509 y
4 2025-06-17 P 8848.0 ... -0.044304 p2509 p
5 2025-06-17 JD 2800.0 ... 0.268929 jd2508 jd
6 2025-06-17 L 7471.67 ... -0.023779 l2509 l
7 2025-06-17 V 4649.0 ... 0.040654 v2509 v
8 2025-06-17 PP 7461.67 ... -0.047532 pp2509 pp
9 2025-06-17 JM 1221.25 ... -0.349028 jm2509 jm
10 2025-06-17 I 734.22 ... -0.047969 i2509 i
11 2025-06-17 EG 4526.67 ... -0.03461 eg2509 eg
12 2025-06-17 EB 8230.0 ... -0.09271 eb2507 eb
13 2025-06-17 PG 4885.0 ... -0.121801 pg2508 pg
14 2025-06-17 LH 14180.0 ... -0.02574 lh2509 lh
15 2025-06-17 CF 14846.5 ... -0.090695 CF509 CF
16 2025-06-17 SR 6060.0 ... -0.063861 SR509 SR
17 2025-06-17 TA 5045.0 ... -0.058474 TA509 TA
18 2025-06-17 OI 9735.0 ... -0.017874 OI509 OI
19 2025-06-17 MA 2646.0 ... -0.078609 MA509 MA
20 2025-06-17 FG 1104.0 ... -0.115942 FG509 FG
21 2025-06-17 RM 2611.67 ... 0.022334 RM509 RM
22 2025-06-17 SF 5054.29 ... 0.043074 SF509 SF
23 2025-06-17 SM 5502.0 ... 0.008361 SM509 SM
24 2025-06-17 CY 23575.0 ... -0.162248 CY509 CY
25 2025-06-17 UR 1820.0 ... -0.032967 UR509 UR
26 2025-06-17 SA 1370.0 ... -0.149635 SA509 SA
27 2025-06-17 PF 6666.25 ... -0.026739 PF508 PF
28 2025-06-17 PX 7000.0 ... -0.038571 PX509 PX
29 2025-06-17 SH 871.0 ... 1.615385 SH509 SH
30 2025-06-17 CU 78740.0 ... -0.002667 cu2507 cu
31 2025-06-17 AL 20633.33 ... -0.011066 al2507 al
32 2025-06-17 ZN 22008.0 ... -0.006043 zn2507 zn
33 2025-06-17 PB 16800.0 ... 0.00744 pb2507 pb
34 2025-06-17 NI 120008.33 ... -0.008569 ni2507 ni
35 2025-06-17 SN 264275.0 ... -0.000057 sn2507 sn
36 2025-06-17 AU 782.36 ... 0.005982 au2508 au
37 2025-06-17 AG 8805.67 ... 0.003558 ag2508 ag
38 2025-06-17 RB 3062.33 ... -0.026232 rb2510 rb
39 2025-06-17 WR 3252.5 ... 0.02844 wr2601 wr
40 2025-06-17 HC 3173.33 ... -0.025629 hc2510 hc
41 2025-06-17 FU 5425.0 ... -0.402212 fu2509 fu
42 2025-06-17 BU 3710.0 ... -0.022372 bu2509 bu
43 2025-06-17 RU 13718.33 ... 0.009963 ru2509 ru
44 2025-06-17 SP 6140.0 ... -0.151466 sp2509 sp
45 2025-06-17 SS 12912.5 ... -0.031171 ss2508 ss
46 2025-06-17 BR 11870.0 ... -0.046335 br2508 br
47 2025-06-17 SI 8620.0 ... -0.147912 SI2509 si
48 2025-06-17 LC 60366.67 ... -0.009056 LC2509 lc
[49 rows x 15 columns]
2025-06-23 18:25:18,056 - future_1d - INFO - save future_spot 2025-06-17 completed
2025-06-23 18:25:23,466 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-18, end_day=2025-06-18) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-18 C 2335.71 ... 0.028809 c2509 c
1 2025-06-18 A 4295.0 ... -0.007916 a2509 a
2 2025-06-18 M 2998.0 ... 0.02435 m2509 m
3 2025-06-18 Y 8234.0 ... -0.024047 y2509 y
4 2025-06-18 P 8848.0 ... -0.039331 p2509 p
5 2025-06-18 JD 2800.0 ... 0.283214 jd2508 jd
6 2025-06-18 L 7525.0 ... -0.017807 l2509 l
7 2025-06-18 V 4665.0 ... 0.04523 v2509 v
8 2025-06-18 PP 7461.67 ... -0.036543 pp2509 pp
9 2025-06-18 JM 1221.25 ... -0.351894 jm2509 jm
10 2025-06-18 I 728.56 ... -0.046063 i2509 i
11 2025-06-18 EG 4540.0 ... -0.020044 eg2509 eg
12 2025-06-18 EB 8230.0 ... -0.087485 eb2508 eb
13 2025-06-18 PG 4885.0 ... -0.095599 pg2508 pg
14 2025-06-18 LH 14170.0 ... -0.024347 lh2509 lh
15 2025-06-18 CF 14842.17 ... -0.087398 CF509 CF
16 2025-06-18 SR 6060.0 ... -0.064026 SR509 SR
17 2025-06-18 TA 5165.5 ... -0.052173 TA509 TA
18 2025-06-18 FG 1104.0 ... -0.112319 FG509 FG
19 2025-06-18 RM 2630.0 ... 0.022814 RM509 RM
20 2025-06-18 SF 5054.29 ... 0.045053 SF509 SF
21 2025-06-18 SM 5508.0 ... 0.011256 SM509 SM
22 2025-06-18 CY 23575.0 ... -0.158643 CY509 CY
23 2025-06-18 UR 1834.0 ... -0.027263 UR509 UR
24 2025-06-18 SA 1370.0 ... -0.147445 SA509 SA
25 2025-06-18 PF 6778.96 ... -0.016368 PF508 PF
26 2025-06-18 PX 7000.0 ... -0.005714 PX509 PX
27 2025-06-18 SH 867.0 ... 1.643599 SH509 SH
28 2025-06-18 CU 78831.67 ... -0.002685 cu2507 cu
29 2025-06-18 AL 20920.0 ... -0.02175 al2508 al
30 2025-06-18 ZN 22148.0 ... -0.016841 zn2508 zn
31 2025-06-18 PB 16781.25 ... 0.003203 pb2507 pb
32 2025-06-18 NI 119875.0 ... -0.012805 ni2507 ni
33 2025-06-18 SN 264275.0 ... -0.00316 sn2507 sn
34 2025-06-18 AU 781.77 ... 0.00426 au2508 au
35 2025-06-18 AG 8962.67 ... 0.003161 ag2508 ag
36 2025-06-18 RB 3064.0 ... -0.026762 rb2510 rb
37 2025-06-18 WR 3257.5 ... 0.016424 wr2601 wr
38 2025-06-18 HC 3173.33 ... -0.023423 hc2510 hc
39 2025-06-18 FU 5437.5 ... -0.389793 fu2509 fu
40 2025-06-18 BU 3718.33 ... -0.009502 bu2509 bu
41 2025-06-18 RU 13858.33 ... 0.010223 ru2509 ru
42 2025-06-18 SP 6116.67 ... -0.14496 sp2509 sp
43 2025-06-18 SS 12875.0 ... -0.029903 ss2508 ss
44 2025-06-18 BR 12040.0 ... -0.043605 br2508 br
45 2025-06-18 SI 8620.0 ... -0.137471 SI2509 si
46 2025-06-18 LC 60366.67 ... -0.003424 LC2509 lc
[47 rows x 15 columns]
2025-06-23 18:25:23,622 - future_1d - INFO - save future_spot 2025-06-18 completed
2025-06-23 18:25:28,634 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-19, end_day=2025-06-19) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-19 C 2338.57 ... 0.026696 c2509 c
1 2025-06-19 A 4295.0 ... -0.015832 a2509 a
2 2025-06-19 M 3016.0 ... 0.015584 m2509 m
3 2025-06-19 Y 8394.0 ... -0.032642 y2509 y
4 2025-06-19 P 8896.0 ... -0.040917 p2509 p
5 2025-06-19 JD 2875.0 ... 0.254609 jd2508 jd
6 2025-06-19 L 7543.33 ... -0.0133 l2509 l
7 2025-06-19 V 4646.0 ... 0.052303 v2509 v
8 2025-06-19 PP 7471.67 ... -0.029802 pp2509 pp
9 2025-06-19 JM 1221.25 ... -0.355988 jm2509 jm
10 2025-06-19 I 722.56 ... -0.036066 i2509 i
11 2025-06-19 EG 4553.33 ... -0.012152 eg2509 eg
12 2025-06-19 EB 8220.0 ... -0.075547 eb2508 eb
13 2025-06-19 PG 4890.0 ... -0.084458 pg2508 pg
14 2025-06-19 LH 14200.0 ... -0.030282 lh2509 lh
15 2025-06-19 CF 14882.0 ... -0.093536 CF509 CF
16 2025-06-19 SR 6050.0 ... -0.064132 SR509 SR
17 2025-06-19 TA 5246.5 ... -0.062613 TA509 TA
18 2025-06-19 FG 1104.0 ... -0.099638 FG509 FG
19 2025-06-19 RM 2615.0 ... 0.025239 RM509 RM
20 2025-06-19 SF 5114.29 ... 0.034357 SF509 SF
21 2025-06-19 SM 5508.0 ... 0.009804 SM509 SM
22 2025-06-19 CY 23575.0 ... -0.161824 CY509 CY
23 2025-06-19 UR 1842.0 ... -0.033116 UR509 UR
24 2025-06-19 SA 1370.0 ... -0.141606 SA509 SA
25 2025-06-19 PF 6803.96 ... -0.014104 PF508 PF
26 2025-06-19 PX 7000.0 ... 0.0 PX509 PX
27 2025-06-19 SH 863.0 ... 1.651217 SH509 SH
28 2025-06-19 CU 78721.67 ... -0.002943 cu2507 cu
29 2025-06-19 AL 20786.67 ... -0.014994 al2508 al
30 2025-06-19 ZN 21974.0 ... -0.012242 zn2508 zn
31 2025-06-19 PB 16856.25 ... 0.001409 pb2507 pb
32 2025-06-19 NI 120458.33 ... -0.01302 ni2507 ni
33 2025-06-19 SN 264462.5 ... -0.00277 sn2507 sn
34 2025-06-19 AU 780.59 ... 0.005547 au2508 au
35 2025-06-19 AG 8871.0 ... 0.004735 ag2508 ag
36 2025-06-19 RB 3062.33 ... -0.025252 rb2510 rb
37 2025-06-19 WR 3252.5 ... 0.017986 wr2601 wr
38 2025-06-19 HC 3173.33 ... -0.021848 hc2510 hc
39 2025-06-19 FU 5450.0 ... -0.387706 fu2509 fu
40 2025-06-19 BU 3710.0 ... 0.003235 bu2509 bu
41 2025-06-19 RU 13858.33 ... 0.010944 ru2509 ru
42 2025-06-19 SP 6090.0 ... -0.137274 sp2509 sp
43 2025-06-19 SS 12875.0 ... -0.024466 ss2508 ss
44 2025-06-19 BR 12040.0 ... -0.03613 br2508 br
45 2025-06-19 SI 8620.0 ... -0.136891 SI2509 si
46 2025-06-19 LC 60300.0 ... -0.00398 LC2509 lc
[47 rows x 15 columns]
2025-06-23 18:25:28,797 - future_1d - INFO - save future_spot 2025-06-19 completed
2025-06-23 18:25:32,699 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-20, end_day=2025-06-20) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-20 C 2342.86 ... 0.027377 c2509 c
1 2025-06-20 A 4295.0 ... -0.010244 a2509 a
2 2025-06-20 M 3024.0 ... 0.015212 m2509 m
3 2025-06-20 Y 8414.0 ... -0.02995 y2509 y
4 2025-06-20 P 8832.0 ... -0.032156 p2509 p
5 2025-06-20 JD 2925.0 ... 0.238291 jd2508 jd
6 2025-06-20 L 7556.67 ... -0.014645 l2509 l
7 2025-06-20 V 4677.0 ... 0.049818 v2509 v
8 2025-06-20 PP 7471.67 ... -0.027259 pp2509 pp
9 2025-06-20 JM 1221.25 ... -0.34739 jm2509 jm
10 2025-06-20 I 724.67 ... -0.030593 i2509 i
11 2025-06-20 EG 4558.33 ... -0.008848 eg2509 eg
12 2025-06-20 EB 8226.0 ... -0.071845 eb2508 eb
13 2025-06-20 PG 4890.0 ... -0.07362 pg2508 pg
14 2025-06-20 LH 14180.0 ... -0.023272 lh2509 lh
15 2025-06-20 CF 14869.67 ... -0.091775 CF509 CF
16 2025-06-20 SR 6050.0 ... -0.058678 SR509 SR
17 2025-06-20 TA 5271.5 ... -0.049986 TA509 TA
18 2025-06-20 FG 1104.0 ... -0.088768 FG509 FG
19 2025-06-20 RM 2616.67 ... 0.025731 RM509 RM
20 2025-06-20 SF 5128.57 ... 0.038886 SF509 SF
21 2025-06-20 SM 5564.0 ... 0.015457 SM509 SM
22 2025-06-20 CY 23575.0 ... -0.161188 CY509 CY
23 2025-06-20 UR 1834.0 ... -0.047983 UR509 UR
24 2025-06-20 SA 1370.0 ... -0.140876 SA509 SA
25 2025-06-20 PF 6866.46 ... -0.00764 PF508 PF
26 2025-06-20 PX 7000.0 ... 0.018 PX509 PX
27 2025-06-20 SH 857.0 ... 1.64294 SH509 SH
28 2025-06-20 CU 78436.67 ... -0.003272 cu2507 cu
29 2025-06-20 AL 20736.67 ... -0.015512 al2508 al
30 2025-06-20 ZN 22032.0 ... -0.013253 zn2508 zn
31 2025-06-20 PB 16812.5 ... 0.003123 pb2508 pb
32 2025-06-20 NI 120641.67 ... -0.015431 ni2507 ni
33 2025-06-20 SN 263350.0 ... -0.009265 sn2507 sn
34 2025-06-20 AU 773.21 ... 0.010178 au2508 au
35 2025-06-20 AG 8759.0 ... -0.002283 ag2508 ag
36 2025-06-20 RB 3072.67 ... -0.025603 rb2510 rb
37 2025-06-20 WR 3250.0 ... 0.02 wr2601 wr
38 2025-06-20 HC 3190.0 ... -0.022884 hc2510 hc
39 2025-06-20 FU 5450.0 ... -0.38 fu2509 fu
40 2025-06-20 BU 3746.67 ... 0.001156 bu2509 bu
41 2025-06-20 RU 13758.33 ... 0.013931 ru2509 ru
42 2025-06-20 SP 6083.33 ... -0.14652 sp2509 sp
43 2025-06-20 SS 12875.0 ... -0.026408 ss2508 ss
44 2025-06-20 BR 12040.0 ... -0.037375 br2508 br
45 2025-06-20 SI 8620.0 ... -0.137471 SI2509 si
46 2025-06-20 LC 60066.67 ... -0.008102 LC2509 lc
[47 rows x 15 columns]
2025-06-23 18:25:32,857 - future_1d - INFO - save future_spot 2025-06-20 completed
2025-06-23 18:25:36,837 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-23, end_day=2025-06-23) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-23 C 2345.71 ... 0.02826 c2509 c
1 2025-06-23 A 4295.0 ... -0.00908 a2509 a
2 2025-06-23 M 2986.0 ... 0.018754 m2509 m
3 2025-06-23 Y 8394.0 ... -0.031451 y2509 y
4 2025-06-23 P 8732.0 ... -0.025653 p2509 p
5 2025-06-23 JD 2925.0 ... 0.22359 jd2508 jd
6 2025-06-23 L 7593.33 ... -0.022563 l2509 l
7 2025-06-23 V 4669.0 ... 0.050975 v2509 v
8 2025-06-23 PP 7476.67 ... -0.032056 pp2509 pp
9 2025-06-23 JM 1221.25 ... -0.345343 jm2509 jm
10 2025-06-23 I 727.44 ... -0.029473 i2509 i
11 2025-06-23 EG 4550.0 ... -0.01011 eg2509 eg
12 2025-06-23 EB 8244.0 ... -0.078724 eb2508 eb
13 2025-06-23 PG 4935.0 ... -0.082472 pg2508 pg
14 2025-06-23 LH 14300.0 ... -0.023776 lh2509 lh
15 2025-06-23 CF 14881.83 ... -0.094197 CF509 CF
16 2025-06-23 SR 6050.0 ... -0.053554 SR509 SR
17 2025-06-23 TA 5282.0 ... -0.056418 TA509 TA
18 2025-06-23 FG 1105.6 ... -0.091896 FG509 FG
19 2025-06-23 RM 2588.33 ... 0.028462 RM509 RM
20 2025-06-23 SF 5130.0 ... 0.036257 SF509 SF
21 2025-06-23 SM 5524.0 ... 0.017017 SM509 SM
22 2025-06-23 CY 23550.0 ... -0.162208 CY509 CY
23 2025-06-23 UR 1824.0 ... -0.060307 UR509 UR
24 2025-06-23 SA 1350.0 ... -0.134815 SA509 SA
25 2025-06-23 PF 6926.25 ... -0.017073 PF508 PF
26 2025-06-23 PX 7300.0 ... -0.029589 PX509 PX
27 2025-06-23 SH 843.0 ... 1.683274 SH509 SH
28 2025-06-23 CU 78388.33 ... -0.000744 cu2507 cu
29 2025-06-23 AL 20663.33 ... -0.011776 al2508 al
30 2025-06-23 ZN 21922.0 ... -0.00853 zn2508 zn
31 2025-06-23 PB 16812.5 ... 0.004312 pb2508 pb
32 2025-06-23 NI 119616.67 ... -0.013097 ni2508 ni
33 2025-06-23 SN 261975.0 ... 0.003989 sn2507 sn
34 2025-06-23 AU 779.36 ... 0.003054 au2508 au
35 2025-06-23 AG 8717.67 ... 0.001529 ag2508 ag
36 2025-06-23 RB 3071.0 ... -0.025399 rb2510 rb
37 2025-06-23 WR 3255.0 ... 0.021198 wr2601 wr
38 2025-06-23 HC 3190.0 ... -0.023511 hc2510 hc
39 2025-06-23 FU 5537.5 ... -0.391603 fu2509 fu
40 2025-06-23 BU 3746.67 ... 0.00596 bu2509 bu
41 2025-06-23 RU 13808.33 ... 0.005552 ru2509 ru
42 2025-06-23 SP 6083.33 ... -0.124164 sp2509 sp
43 2025-06-23 SS 12762.5 ... -0.022527 ss2508 ss
44 2025-06-23 BR 12000.0 ... -0.044583 br2508 br
45 2025-06-23 SI 8620.0 ... -0.140951 SI2509 si
46 2025-06-23 LC 60066.67 ... -0.019423 LC2509 lc
[47 rows x 15 columns]
2025-06-23 18:25:37,008 - future_1d - INFO - save future_spot 2025-06-23 add
2025-06-23 18:25:37,016 - future_1d - INFO - 0 ... 4
date 2025-06-23 ... 2025-06-23
variety C ... P
spot_price 2345.71 ... 8732.0
near_contract c2507 ... p2507
near_contract_price 2376.0 ... 8606.0
dominant_contract c2509 ... p2509
dominant_contract_price 2412.0 ... 8508.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 30.29 ... -126.0
dom_basis 66.29 ... -224.0
near_basis_rate 0.0129 ... -0.0144
dom_basis_rate 0.0283 ... -0.0257
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-23 18:25:36.968155 ... 2025-06-23 18:25:36.968155
updated_at 2025-06-23 18:25:36.968551 ... 2025-06-23 18:25:36.968551
[17 rows x 5 columns]