=========================================================================
2025-06-18 16:25:34 Wed START TASK.01 future_1d future_spot
=========================================================================
2025-06-18 16:25:35,913 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-18 16:25:36,231 - 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 JM 1253.75 ... -0.382652 jm2509 jm
10 2025-06-12 I 742.11 ... -0.051354 i2509 i
11 2025-06-12 EG 4488.33 ... -0.049758 eg2509 eg
12 2025-06-12 EB 8002.0 ... -0.076856 eb2507 eb
13 2025-06-12 PG 4797.5 ... -0.159354 pg2508 pg
14 2025-06-12 LH 14120.0 ... -0.032932 lh2509 lh
15 2025-06-12 CF 14848.67 ... -0.090491 CF509 CF
16 2025-06-12 SR 6060.0 ... -0.065677 SR509 SR
17 2025-06-12 TA 4880.75 ... -0.050146 TA509 TA
18 2025-06-12 OI 9333.33 ... -0.017071 OI509 OI
19 2025-06-12 MA 2362.0 ... -0.028789 MA509 MA
20 2025-06-12 FG 1104.0 ... -0.105978 FG509 FG
21 2025-06-12 RM 2576.67 ... 0.0304 RM509 RM
22 2025-06-12 SF 5048.57 ... 0.024845 SF509 SF
23 2025-06-12 SM 5470.0 ... -0.004022 SM509 SM
24 2025-06-12 CY 23725.0 ... -0.167966 CY509 CY
25 2025-06-12 UR 1816.67 ... -0.089543 UR509 UR
26 2025-06-12 SA 1370.0 ... -0.133577 SA509 SA
27 2025-06-12 PF 6535.21 ... -0.032013 PF508 PF
28 2025-06-12 PX 7000.0 ... -0.064 PX509 PX
29 2025-06-12 SH 883.0 ... 1.619479 SH509 SH
30 2025-06-12 CU 79101.67 ... -0.005331 cu2507 cu
31 2025-06-12 AL 20420.0 ... -0.003918 al2507 al
32 2025-06-12 ZN 22304.0 ... -0.011164 zn2507 zn
33 2025-06-12 PB 16768.75 ... 0.007827 pb2507 pb
34 2025-06-12 NI 122066.67 ... -0.01308 ni2507 ni
35 2025-06-12 SN 265225.0 ... -0.002168 sn2507 sn
36 2025-06-12 AU 774.63 ... 0.008172 au2508 au
37 2025-06-12 AG 8886.67 ... -0.005927 ag2508 ag
38 2025-06-12 RB 3095.89 ... -0.039049 rb2510 rb
39 2025-06-12 WR 3257.5 ... 0.030852 wr2601 wr
40 2025-06-12 HC 3176.67 ... -0.027283 hc2510 hc
41 2025-06-12 FU 5287.5 ... -0.436028 fu2509 fu
42 2025-06-12 BU 3620.0 ... -0.030939 bu2509 bu
43 2025-06-12 RU 13458.33 ... 0.023158 ru2509 ru
44 2025-06-12 SP 6216.67 ... -0.157427 sp2509 sp
45 2025-06-12 SS 13012.5 ... -0.033237 ss2508 ss
46 2025-06-12 BR 11650.0 ... -0.053648 br2508 br
47 2025-06-12 SI 8620.0 ... -0.138051 SI2509 si
48 2025-06-12 LC 60633.33 ... 0.003738 LC2509 lc
[49 rows x 15 columns]
2025-06-18 16:25:36,401 - future_1d - INFO - save future_spot 2025-06-12 completed
2025-06-18 16:25:43,736 - 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 JM 1228.75 ... -0.370498 jm2509 jm
10 2025-06-13 I 737.0 ... -0.046133 i2509 i
11 2025-06-13 EG 4535.0 ... -0.043881 eg2509 eg
12 2025-06-13 EB 8068.0 ... -0.056396 eb2507 eb
13 2025-06-13 PG 4822.5 ... -0.131156 pg2508 pg
14 2025-06-13 LH 14120.0 ... -0.024079 lh2509 lh
15 2025-06-13 CF 14831.17 ... -0.092115 CF509 CF
16 2025-06-13 SR 6050.0 ... -0.067438 SR509 SR
17 2025-06-13 TA 4932.75 ... -0.02975 TA509 TA
18 2025-06-13 OI 9473.33 ... -0.01798 OI509 OI
19 2025-06-13 MA 2484.0 ... -0.042673 MA509 MA
20 2025-06-13 FG 1104.0 ... -0.113225 FG509 FG
21 2025-06-13 RM 2606.67 ... 0.025446 RM509 RM
22 2025-06-13 SF 5048.57 ... 0.027222 SF509 SF
23 2025-06-13 SM 5476.0 ... -0.003652 SM509 SM
24 2025-06-13 CY 23725.0 ... -0.168599 CY509 CY
25 2025-06-13 UR 1796.0 ... -0.07294 UR509 UR
26 2025-06-13 SA 1370.0 ... -0.150365 SA509 SA
27 2025-06-13 PF 6640.21 ... -0.023826 PF508 PF
28 2025-06-13 PX 7000.0 ... -0.032571 PX509 PX
29 2025-06-13 SH 883.0 ... 1.586636 SH509 SH
30 2025-06-13 CU 78933.33 ... -0.006757 cu2507 cu
31 2025-06-13 AL 20740.0 ... -0.015188 al2507 al
32 2025-06-13 ZN 22246.0 ... -0.013306 zn2507 zn
33 2025-06-13 PB 16850.0 ... 0.005935 pb2507 pb
34 2025-06-13 NI 121800.0 ... -0.014532 ni2507 ni
35 2025-06-13 SN 265562.5 ... -0.00498 sn2507 sn
36 2025-06-13 AU 793.04 ... -0.000101 au2508 au
37 2025-06-13 AG 8833.33 ... -0.001735 ag2508 ag
38 2025-06-13 RB 3055.0 ... -0.030769 rb2510 rb
39 2025-06-13 WR 3237.5 ... 0.03722 wr2601 wr
40 2025-06-13 HC 3166.67 ... -0.030212 hc2510 hc
41 2025-06-13 FU 5350.0 ... -0.407664 fu2509 fu
42 2025-06-13 BU 3696.67 ... -0.015601 bu2509 bu
43 2025-06-13 RU 13758.33 ... 0.004119 ru2509 ru
44 2025-06-13 SP 6183.33 ... -0.158382 sp2509 sp
45 2025-06-13 SS 12962.5 ... -0.031051 ss2508 ss
46 2025-06-13 BR 11750.0 ... -0.051489 br2508 br
47 2025-06-13 SI 8620.0 ... -0.148492 SI2509 si
48 2025-06-13 LC 60700.0 ... -0.008237 LC2509 lc
[49 rows x 15 columns]
2025-06-18 16:25:43,898 - future_1d - INFO - save future_spot 2025-06-13 completed
2025-06-18 16:25:52,706 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-16, end_day=2025-06-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-16 C 2335.71 ... 0.02624 c2509 c
1 2025-06-16 A 4295.0 ... -0.011409 a2509 a
2 2025-06-16 M 3002.0 ... 0.012325 m2509 m
3 2025-06-16 Y 8224.0 ... -0.036235 y2509 y
4 2025-06-16 P 8804.0 ... -0.050659 p2509 p
5 2025-06-16 JD 2775.0 ... 0.290811 jd2508 jd
6 2025-06-16 L 7438.33 ... -0.021286 l2509 l
7 2025-06-16 V 4620.0 ... 0.044805 v2509 v
8 2025-06-16 PP 7403.33 ... -0.040027 pp2509 pp
9 2025-06-16 JM 1228.75 ... -0.361953 jm2509 jm
10 2025-06-16 I 736.56 ... -0.050315 i2509 i
11 2025-06-16 EG 4530.0 ... -0.043488 eg2509 eg
12 2025-06-16 EB 8230.0 ... -0.076185 eb2507 eb
13 2025-06-16 PG 4885.0 ... -0.125281 pg2508 pg
14 2025-06-16 LH 14130.0 ... -0.023355 lh2509 lh
15 2025-06-16 CF 14810.0 ... -0.087441 CF509 CF
16 2025-06-16 SR 6050.0 ... -0.065785 SR509 SR
17 2025-06-16 TA 5008.25 ... -0.046373 TA509 TA
18 2025-06-16 OI 9656.67 ... -0.022437 OI509 OI
19 2025-06-16 MA 2597.0 ... -0.058144 MA509 MA
20 2025-06-16 FG 1104.0 ... -0.115942 FG509 FG
21 2025-06-16 RM 2591.67 ... 0.026751 RM509 RM
22 2025-06-16 SF 5054.29 ... 0.03239 SF509 SF
23 2025-06-16 SM 5480.0 ... 0.007664 SM509 SM
24 2025-06-16 CY 23725.0 ... -0.166913 CY509 CY
25 2025-06-16 UR 1804.0 ... -0.054324 UR509 UR
26 2025-06-16 SA 1370.0 ... -0.151095 SA509 SA
27 2025-06-16 PF 6646.04 ... -0.022275 PF508 PF
28 2025-06-16 PX 7000.0 ... -0.032571 PX509 PX
29 2025-06-16 SH 877.0 ... 1.574686 SH509 SH
30 2025-06-16 CU 78610.0 ... -0.003944 cu2507 cu
31 2025-06-16 AL 20636.67 ... -0.011953 al2507 al
32 2025-06-16 ZN 22002.0 ... -0.009181 zn2507 zn
33 2025-06-16 PB 16812.5 ... 0.006394 pb2507 pb
34 2025-06-16 NI 120875.0 ... -0.009969 ni2507 ni
35 2025-06-16 SN 265350.0 ... -0.00309 sn2507 sn
36 2025-06-16 AU 793.47 ... 0.004096 au2508 au
37 2025-06-16 AG 8792.33 ... 0.003602 ag2508 ag
38 2025-06-16 RB 3070.0 ... -0.030619 rb2510 rb
39 2025-06-16 WR 3237.5 ... 0.020541 wr2510 wr
40 2025-06-16 HC 3170.0 ... -0.025552 hc2510 hc
41 2025-06-16 FU 5350.0 ... -0.393271 fu2509 fu
42 2025-06-16 BU 3716.67 ... -0.019283 bu2509 bu
43 2025-06-16 RU 13768.33 ... 0.004479 ru2509 ru
44 2025-06-16 SP 6183.33 ... -0.157412 sp2509 sp
45 2025-06-16 SS 12912.5 ... -0.028848 ss2508 ss
46 2025-06-16 BR 11810.0 ... -0.045301 br2508 br
47 2025-06-16 SI 8620.0 ... -0.155452 SI2509 si
48 2025-06-16 LC 60700.0 ... -0.021087 LC2509 lc
[49 rows x 15 columns]
2025-06-18 16:25:52,862 - future_1d - INFO - save future_spot 2025-06-16 completed
2025-06-18 16:25:59,166 - 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-18 16:25:59,320 - future_1d - INFO - save future_spot 2025-06-17 completed
2025-06-18 16:26:06,892 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-18, end_day=2025-06-18) done
2025-06-18 16:26:06,908 - future_1d - INFO - save future_spot 2025-06-18 failed
=========================================================================
2025-06-18 18:25:13 Wed START TASK.01 future_1d future_spot
=========================================================================
2025-06-18 18:25:15,200 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-18 18:25:15,516 - 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 JM 1253.75 ... -0.382652 jm2509 jm
10 2025-06-12 I 742.11 ... -0.051354 i2509 i
11 2025-06-12 EG 4488.33 ... -0.049758 eg2509 eg
12 2025-06-12 EB 8002.0 ... -0.076856 eb2507 eb
13 2025-06-12 PG 4797.5 ... -0.159354 pg2508 pg
14 2025-06-12 LH 14120.0 ... -0.032932 lh2509 lh
15 2025-06-12 CF 14848.67 ... -0.090491 CF509 CF
16 2025-06-12 SR 6060.0 ... -0.065677 SR509 SR
17 2025-06-12 TA 4880.75 ... -0.050146 TA509 TA
18 2025-06-12 OI 9333.33 ... -0.017071 OI509 OI
19 2025-06-12 MA 2362.0 ... -0.028789 MA509 MA
20 2025-06-12 FG 1104.0 ... -0.105978 FG509 FG
21 2025-06-12 RM 2576.67 ... 0.0304 RM509 RM
22 2025-06-12 SF 5048.57 ... 0.024845 SF509 SF
23 2025-06-12 SM 5470.0 ... -0.004022 SM509 SM
24 2025-06-12 CY 23725.0 ... -0.167966 CY509 CY
25 2025-06-12 UR 1816.67 ... -0.089543 UR509 UR
26 2025-06-12 SA 1370.0 ... -0.133577 SA509 SA
27 2025-06-12 PF 6535.21 ... -0.032013 PF508 PF
28 2025-06-12 PX 7000.0 ... -0.064 PX509 PX
29 2025-06-12 SH 883.0 ... 1.619479 SH509 SH
30 2025-06-12 CU 79101.67 ... -0.005331 cu2507 cu
31 2025-06-12 AL 20420.0 ... -0.003918 al2507 al
32 2025-06-12 ZN 22304.0 ... -0.011164 zn2507 zn
33 2025-06-12 PB 16768.75 ... 0.007827 pb2507 pb
34 2025-06-12 NI 122066.67 ... -0.01308 ni2507 ni
35 2025-06-12 SN 265225.0 ... -0.002168 sn2507 sn
36 2025-06-12 AU 774.63 ... 0.008172 au2508 au
37 2025-06-12 AG 8886.67 ... -0.005927 ag2508 ag
38 2025-06-12 RB 3095.89 ... -0.039049 rb2510 rb
39 2025-06-12 WR 3257.5 ... 0.030852 wr2601 wr
40 2025-06-12 HC 3176.67 ... -0.027283 hc2510 hc
41 2025-06-12 FU 5287.5 ... -0.436028 fu2509 fu
42 2025-06-12 BU 3620.0 ... -0.030939 bu2509 bu
43 2025-06-12 RU 13458.33 ... 0.023158 ru2509 ru
44 2025-06-12 SP 6216.67 ... -0.157427 sp2509 sp
45 2025-06-12 SS 13012.5 ... -0.033237 ss2508 ss
46 2025-06-12 BR 11650.0 ... -0.053648 br2508 br
47 2025-06-12 SI 8620.0 ... -0.138051 SI2509 si
48 2025-06-12 LC 60633.33 ... 0.003738 LC2509 lc
[49 rows x 15 columns]
2025-06-18 18:25:15,691 - future_1d - INFO - save future_spot 2025-06-12 completed
2025-06-18 18:25:22,022 - 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 JM 1228.75 ... -0.370498 jm2509 jm
10 2025-06-13 I 737.0 ... -0.046133 i2509 i
11 2025-06-13 EG 4535.0 ... -0.043881 eg2509 eg
12 2025-06-13 EB 8068.0 ... -0.056396 eb2507 eb
13 2025-06-13 PG 4822.5 ... -0.131156 pg2508 pg
14 2025-06-13 LH 14120.0 ... -0.024079 lh2509 lh
15 2025-06-13 CF 14831.17 ... -0.092115 CF509 CF
16 2025-06-13 SR 6050.0 ... -0.067438 SR509 SR
17 2025-06-13 TA 4932.75 ... -0.02975 TA509 TA
18 2025-06-13 OI 9473.33 ... -0.01798 OI509 OI
19 2025-06-13 MA 2484.0 ... -0.042673 MA509 MA
20 2025-06-13 FG 1104.0 ... -0.113225 FG509 FG
21 2025-06-13 RM 2606.67 ... 0.025446 RM509 RM
22 2025-06-13 SF 5048.57 ... 0.027222 SF509 SF
23 2025-06-13 SM 5476.0 ... -0.003652 SM509 SM
24 2025-06-13 CY 23725.0 ... -0.168599 CY509 CY
25 2025-06-13 UR 1796.0 ... -0.07294 UR509 UR
26 2025-06-13 SA 1370.0 ... -0.150365 SA509 SA
27 2025-06-13 PF 6640.21 ... -0.023826 PF508 PF
28 2025-06-13 PX 7000.0 ... -0.032571 PX509 PX
29 2025-06-13 SH 883.0 ... 1.586636 SH509 SH
30 2025-06-13 CU 78933.33 ... -0.006757 cu2507 cu
31 2025-06-13 AL 20740.0 ... -0.015188 al2507 al
32 2025-06-13 ZN 22246.0 ... -0.013306 zn2507 zn
33 2025-06-13 PB 16850.0 ... 0.005935 pb2507 pb
34 2025-06-13 NI 121800.0 ... -0.014532 ni2507 ni
35 2025-06-13 SN 265562.5 ... -0.00498 sn2507 sn
36 2025-06-13 AU 793.04 ... -0.000101 au2508 au
37 2025-06-13 AG 8833.33 ... -0.001735 ag2508 ag
38 2025-06-13 RB 3055.0 ... -0.030769 rb2510 rb
39 2025-06-13 WR 3237.5 ... 0.03722 wr2601 wr
40 2025-06-13 HC 3166.67 ... -0.030212 hc2510 hc
41 2025-06-13 FU 5350.0 ... -0.407664 fu2509 fu
42 2025-06-13 BU 3696.67 ... -0.015601 bu2509 bu
43 2025-06-13 RU 13758.33 ... 0.004119 ru2509 ru
44 2025-06-13 SP 6183.33 ... -0.158382 sp2509 sp
45 2025-06-13 SS 12962.5 ... -0.031051 ss2508 ss
46 2025-06-13 BR 11750.0 ... -0.051489 br2508 br
47 2025-06-13 SI 8620.0 ... -0.148492 SI2509 si
48 2025-06-13 LC 60700.0 ... -0.008237 LC2509 lc
[49 rows x 15 columns]
2025-06-18 18:25:22,175 - future_1d - INFO - save future_spot 2025-06-13 completed
2025-06-18 18:25:31,362 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-16, end_day=2025-06-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-16 C 2335.71 ... 0.02624 c2509 c
1 2025-06-16 A 4295.0 ... -0.011409 a2509 a
2 2025-06-16 M 3002.0 ... 0.012325 m2509 m
3 2025-06-16 Y 8224.0 ... -0.036235 y2509 y
4 2025-06-16 P 8804.0 ... -0.050659 p2509 p
5 2025-06-16 JD 2775.0 ... 0.290811 jd2508 jd
6 2025-06-16 L 7438.33 ... -0.021286 l2509 l
7 2025-06-16 V 4620.0 ... 0.044805 v2509 v
8 2025-06-16 PP 7403.33 ... -0.040027 pp2509 pp
9 2025-06-16 JM 1228.75 ... -0.361953 jm2509 jm
10 2025-06-16 I 736.56 ... -0.050315 i2509 i
11 2025-06-16 EG 4530.0 ... -0.043488 eg2509 eg
12 2025-06-16 EB 8230.0 ... -0.076185 eb2507 eb
13 2025-06-16 PG 4885.0 ... -0.125281 pg2508 pg
14 2025-06-16 LH 14130.0 ... -0.023355 lh2509 lh
15 2025-06-16 CF 14810.0 ... -0.087441 CF509 CF
16 2025-06-16 SR 6050.0 ... -0.065785 SR509 SR
17 2025-06-16 TA 5008.25 ... -0.046373 TA509 TA
18 2025-06-16 OI 9656.67 ... -0.022437 OI509 OI
19 2025-06-16 MA 2597.0 ... -0.058144 MA509 MA
20 2025-06-16 FG 1104.0 ... -0.115942 FG509 FG
21 2025-06-16 RM 2591.67 ... 0.026751 RM509 RM
22 2025-06-16 SF 5054.29 ... 0.03239 SF509 SF
23 2025-06-16 SM 5480.0 ... 0.007664 SM509 SM
24 2025-06-16 CY 23725.0 ... -0.166913 CY509 CY
25 2025-06-16 UR 1804.0 ... -0.054324 UR509 UR
26 2025-06-16 SA 1370.0 ... -0.151095 SA509 SA
27 2025-06-16 PF 6646.04 ... -0.022275 PF508 PF
28 2025-06-16 PX 7000.0 ... -0.032571 PX509 PX
29 2025-06-16 SH 877.0 ... 1.574686 SH509 SH
30 2025-06-16 CU 78610.0 ... -0.003944 cu2507 cu
31 2025-06-16 AL 20636.67 ... -0.011953 al2507 al
32 2025-06-16 ZN 22002.0 ... -0.009181 zn2507 zn
33 2025-06-16 PB 16812.5 ... 0.006394 pb2507 pb
34 2025-06-16 NI 120875.0 ... -0.009969 ni2507 ni
35 2025-06-16 SN 265350.0 ... -0.00309 sn2507 sn
36 2025-06-16 AU 793.47 ... 0.004096 au2508 au
37 2025-06-16 AG 8792.33 ... 0.003602 ag2508 ag
38 2025-06-16 RB 3070.0 ... -0.030619 rb2510 rb
39 2025-06-16 WR 3237.5 ... 0.020541 wr2510 wr
40 2025-06-16 HC 3170.0 ... -0.025552 hc2510 hc
41 2025-06-16 FU 5350.0 ... -0.393271 fu2509 fu
42 2025-06-16 BU 3716.67 ... -0.019283 bu2509 bu
43 2025-06-16 RU 13768.33 ... 0.004479 ru2509 ru
44 2025-06-16 SP 6183.33 ... -0.157412 sp2509 sp
45 2025-06-16 SS 12912.5 ... -0.028848 ss2508 ss
46 2025-06-16 BR 11810.0 ... -0.045301 br2508 br
47 2025-06-16 SI 8620.0 ... -0.155452 SI2509 si
48 2025-06-16 LC 60700.0 ... -0.021087 LC2509 lc
[49 rows x 15 columns]
2025-06-18 18:25:31,515 - future_1d - INFO - save future_spot 2025-06-16 completed
2025-06-18 18:25:40,034 - 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-18 18:25:40,189 - future_1d - INFO - save future_spot 2025-06-17 completed
2025-06-18 18:25:45,943 - 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-18 18:25:46,111 - future_1d - INFO - save future_spot 2025-06-18 add
2025-06-18 18:25:46,119 - future_1d - INFO - 0 ... 4
date 2025-06-18 ... 2025-06-18
variety C ... P
spot_price 2335.71 ... 8848.0
near_contract c2507 ... p2507
near_contract_price 2367.0 ... 8608.0
dominant_contract c2509 ... p2509
dominant_contract_price 2403.0 ... 8500.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 31.29 ... -240.0
dom_basis 67.29 ... -348.0
near_basis_rate 0.0134 ... -0.0271
dom_basis_rate 0.0288 ... -0.0393
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-18 18:25:46.073902 ... 2025-06-18 18:25:46.073902
updated_at 2025-06-18 18:25:46.074294 ... 2025-06-18 18:25:46.074294
[17 rows x 5 columns]