=========================================================================
2025-07-02 16:25:27 Wed START TASK.01 future_1d future_spot
=========================================================================
2025-07-02 16:25:29,011 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-02 16:25:29,346 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-26, end_day=2025-06-26) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-26 C 2352.86 ... 0.01111 c2509 c
1 2025-06-26 A 4295.0 ... -0.033295 a2509 a
2 2025-06-26 M 2916.0 ... 0.012003 m2509 m
3 2025-06-26 Y 8254.0 ... -0.032954 y2509 y
4 2025-06-26 P 8560.0 ... -0.024766 p2509 p
5 2025-06-26 JD 2890.0 ... 0.230104 jd2508 jd
6 2025-06-26 L 7511.67 ... -0.029643 l2509 l
7 2025-06-26 V 4655.0 ... 0.044683 v2509 v
8 2025-06-26 PP 7483.33 ... -0.052962 pp2509 pp
9 2025-06-26 JM 1216.25 ... -0.335663 jm2509 jm
10 2025-06-26 I 715.78 ... -0.018553 i2509 i
11 2025-06-26 EG 4416.67 ... -0.025963 eg2509 eg
12 2025-06-26 EB 8164.0 ... -0.105953 eb2508 eb
13 2025-06-26 PG 4967.5 ... -0.143835 pg2508 pg
14 2025-06-26 LH 14330.0 ... -0.021284 lh2509 lh
15 2025-06-26 CF 15004.5 ... -0.08794 CF509 CF
16 2025-06-26 SR 6050.0 ... -0.044793 SR509 SR
17 2025-06-26 TA 5083.25 ... -0.063198 TA509 TA
18 2025-06-26 FG 1105.6 ... -0.082851 FG509 FG
19 2025-06-26 RM 2478.33 ... 0.028112 RM509 RM
20 2025-06-26 SF 5132.86 ... 0.048149 SF509 SF
21 2025-06-26 SM 5562.0 ... 0.018339 SM509 SM
22 2025-06-26 CY 23200.0 ... -0.134483 CY509 CY
23 2025-06-26 UR 1822.6 ... -0.056293 UR509 UR
24 2025-06-26 SA 1337.5 ... -0.123738 SA509 SA
25 2025-06-26 PF 6767.29 ... -0.028267 PF508 PF
26 2025-06-26 PX 7300.0 ... -0.080822 PX509 PX
27 2025-06-26 SH 839.0 ... 1.740167 SH509 SH
28 2025-06-26 CU 78886.67 ... -0.001859 cu2508 cu
29 2025-06-26 AL 20620.0 ... -0.011639 al2508 al
30 2025-06-26 ZN 22244.0 ... -0.004001 zn2508 zn
31 2025-06-26 PB 17075.0 ... 0.007613 pb2508 pb
32 2025-06-26 NI 121966.67 ... -0.017928 ni2508 ni
33 2025-06-26 SN 265425.0 ... 0.004766 sn2508 sn
34 2025-06-26 AU 771.53 ... 0.004731 au2510 au
35 2025-06-26 AG 8747.0 ... -0.000343 ag2508 ag
36 2025-06-26 RB 3060.33 ... -0.030823 rb2510 rb
37 2025-06-26 WR 3242.5 ... 0.02606 wr2601 wr
38 2025-06-26 HC 3200.0 ... -0.03375 hc2510 hc
39 2025-06-26 FU 5525.0 ... -0.45629 fu2509 fu
40 2025-06-26 BU 3700.0 ... -0.037297 bu2509 bu
41 2025-06-26 RU 13878.33 ... 0.000481 ru2509 ru
42 2025-06-26 SP 5983.33 ... -0.152646 sp2509 sp
43 2025-06-26 SS 12725.0 ... -0.007859 ss2508 ss
44 2025-06-26 BR 11800.0 ... -0.060169 br2508 br
45 2025-06-26 SI 8620.0 ... -0.104408 SI2509 si
46 2025-06-26 LC 60033.33 ... 0.020433 LC2509 lc
[47 rows x 15 columns]
2025-07-02 16:25:29,529 - future_1d - INFO - save future_spot 2025-06-26 completed
2025-07-02 16:25:35,796 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-27, end_day=2025-06-27) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-27 C 2352.86 ... 0.010685 c2509 c
1 2025-06-27 A 4295.0 ... -0.035157 a2509 a
2 2025-06-27 M 2906.0 ... 0.011012 m2509 m
3 2025-06-27 Y 8254.0 ... -0.030531 y2509 y
4 2025-06-27 P 8586.0 ... -0.025623 p2509 p
5 2025-06-27 JD 2890.0 ... 0.225606 jd2508 jd
6 2025-06-27 L 7511.67 ... -0.027114 l2509 l
7 2025-06-27 V 4673.0 ... 0.050931 v2509 v
8 2025-06-27 PP 7483.33 ... -0.049621 pp2509 pp
9 2025-06-27 JM 1216.25 ... -0.314286 jm2509 jm
10 2025-06-27 I 725.44 ... -0.01577 i2509 i
11 2025-06-27 EG 4416.67 ... -0.031171 eg2509 eg
12 2025-06-27 EB 8084.0 ... -0.095497 eb2508 eb
13 2025-06-27 PG 4967.5 ... -0.14464 pg2508 pg
14 2025-06-27 LH 14420.0 ... -0.02982 lh2509 lh
15 2025-06-27 CF 15105.67 ... -0.090408 CF509 CF
16 2025-06-27 SR 6056.67 ... -0.044524 SR509 SR
17 2025-06-27 TA 5084.75 ... -0.062294 TA509 TA
18 2025-06-27 FG 1105.6 ... -0.078329 FG509 FG
19 2025-06-27 RM 2475.0 ... 0.027475 RM509 RM
20 2025-06-27 SF 5158.57 ... 0.045251 SF509 SF
21 2025-06-27 SM 5572.0 ... 0.020101 SM509 SM
22 2025-06-27 CY 23200.0 ... -0.133405 CY509 CY
23 2025-06-27 UR 1827.0 ... -0.056924 UR509 UR
24 2025-06-27 SA 1337.5 ... -0.108785 SA509 SA
25 2025-06-27 PF 6736.04 ... -0.030291 PF508 PF
26 2025-06-27 PX 7300.0 ... -0.078356 PX509 PX
27 2025-06-27 SH 837.0 ... 1.783751 SH509 SH
28 2025-06-27 CU 80195.0 ... -0.005674 cu2508 cu
29 2025-06-27 AL 20903.33 ... -0.015707 al2508 al
30 2025-06-27 ZN 22568.0 ... -0.006336 zn2508 zn
31 2025-06-27 PB 17072.5 ... 0.007175 pb2508 pb
32 2025-06-27 NI 122433.33 ... -0.014729 ni2508 ni
33 2025-06-27 SN 269425.0 ... 0.001132 sn2508 sn
34 2025-06-27 AU 765.87 ... 0.008578 au2510 au
35 2025-06-27 AG 8800.67 ... 0.00106 ag2508 ag
36 2025-06-27 RB 3072.0 ... -0.026693 rb2510 rb
37 2025-06-27 WR 3252.5 ... 0.021368 wr2510 wr
38 2025-06-27 HC 3206.67 ... -0.02734 hc2510 hc
39 2025-06-27 FU 5525.0 ... -0.456109 fu2509 fu
40 2025-06-27 BU 3700.0 ... -0.038108 bu2509 bu
41 2025-06-27 RU 13878.33 ... 0.012009 ru2509 ru
42 2025-06-27 SP 5983.33 ... -0.149637 sp2509 sp
43 2025-06-27 SS 12762.5 ... -0.013516 ss2508 ss
44 2025-06-27 BR 11800.0 ... -0.05 br2508 br
45 2025-06-27 SI 8620.0 ... -0.091647 SI2509 si
46 2025-06-27 LC 60533.33 ... 0.036454 LC2509 lc
[47 rows x 15 columns]
2025-07-02 16:25:35,953 - future_1d - INFO - save future_spot 2025-06-27 completed
2025-07-02 16:25:44,647 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-30, end_day=2025-06-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-30 C 2357.14 ... 0.008001 c2509 c
1 2025-06-30 A 4295.0 ... -0.034459 a2509 a
2 2025-06-30 M 2906.0 ... 0.017894 m2509 m
3 2025-06-30 Y 8234.0 ... -0.031576 y2509 y
4 2025-06-30 P 8570.0 ... -0.030105 p2509 p
5 2025-06-30 JD 2810.0 ... 0.259431 jd2508 jd
6 2025-06-30 L 7503.33 ... -0.028964 l2509 l
7 2025-06-30 V 4658.0 ... 0.057106 v2509 v
8 2025-06-30 PP 7466.67 ... -0.050179 pp2509 pp
9 2025-06-30 JM 1216.25 ... -0.307297 jm2509 jm
10 2025-06-30 I 726.56 ... -0.011782 i2509 i
11 2025-06-30 EG 4413.33 ... -0.032023 eg2509 eg
12 2025-06-30 EB 8050.0 ... -0.092422 eb2508 eb
13 2025-06-30 PG 4922.5 ... -0.140681 pg2508 pg
14 2025-06-30 LH 14480.0 ... -0.040746 lh2509 lh
15 2025-06-30 CF 15159.83 ... -0.08871 CF509 CF
16 2025-06-30 SR 6053.33 ... -0.041519 SR509 SR
17 2025-06-30 TA 5104.75 ... -0.054998 TA509 TA
18 2025-06-30 FG 1105.6 ... -0.079233 FG509 FG
19 2025-06-30 RM 2500.0 ... 0.0276 RM509 RM
20 2025-06-30 SF 5158.57 ... 0.042925 SF509 SF
21 2025-06-30 SM 5564.0 ... 0.020489 SM509 SM
22 2025-06-30 CY 23200.0 ... -0.13319 CY509 CY
23 2025-06-30 UR 1823.0 ... -0.059243 UR509 UR
24 2025-06-30 SA 1325.0 ... -0.095094 SA509 SA
25 2025-06-30 PF 6727.92 ... -0.02704 PF508 PF
26 2025-06-30 PX 7300.0 ... -0.064932 PX509 PX
27 2025-06-30 SH 835.0 ... 1.802395 SH509 SH
28 2025-06-30 CU 80001.67 ... -0.002896 cu2508 cu
29 2025-06-30 AL 20786.67 ... -0.011386 al2508 al
30 2025-06-30 ZN 22486.0 ... -0.002268 zn2508 zn
31 2025-06-30 PB 17043.75 ... 0.005941 pb2508 pb
32 2025-06-30 NI 122400.0 ... -0.011683 ni2508 ni
33 2025-06-30 SN 267487.5 ... 0.002439 sn2508 sn
34 2025-06-30 AU 762.1 ... 0.003622 au2510 au
35 2025-06-30 AG 8680.0 ... 0.003802 ag2508 ag
36 2025-06-30 RB 3072.0 ... -0.020508 rb2510 rb
37 2025-06-30 WR 3260.0 ... 0.020859 wr2510 wr
38 2025-06-30 HC 3210.0 ... -0.023676 hc2510 hc
39 2025-06-30 FU 5462.5 ... -0.452632 fu2509 fu
40 2025-06-30 BU 3673.33 ... -0.031941 bu2509 bu
41 2025-06-30 RU 13858.33 ... 0.010944 ru2509 ru
42 2025-06-30 SP 5950.0 ... -0.148571 sp2509 sp
43 2025-06-30 SS 12775.0 ... -0.008219 ss2508 ss
44 2025-06-30 BR 11820.0 ... -0.046531 br2508 br
45 2025-06-30 SI 8730.0 ... -0.070447 SI2509 si
46 2025-06-30 LC 61466.67 ... 0.01974 LC2509 lc
[47 rows x 15 columns]
2025-07-02 16:25:44,800 - future_1d - INFO - save future_spot 2025-06-30 completed
2025-07-02 16:25:50,114 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-01, end_day=2025-07-01) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-01 C 2365.71 ... 0.006463 c2509 c
1 2025-07-01 A 4295.0 ... -0.03865 a2509 a
2 2025-07-01 M 2930.0 ... 0.01058 m2509 m
3 2025-07-01 Y 8224.0 ... -0.031128 y2509 y
4 2025-07-01 P 8600.0 ... -0.033256 p2509 p
5 2025-07-01 JD 2790.0 ... 0.278853 jd2508 jd
6 2025-07-01 L 7486.67 ... -0.032146 l2509 l
7 2025-07-01 V 4597.0 ... 0.052643 v2509 v
8 2025-07-01 PP 7458.33 ... -0.055016 pp2509 pp
9 2025-07-01 JM 1216.25 ... -0.327852 jm2509 jm
10 2025-07-01 I 723.44 ... -0.017887 i2509 i
11 2025-07-01 EG 4396.67 ... -0.03063 eg2509 eg
12 2025-07-01 EB 8036.0 ... -0.094948 eb2508 eb
13 2025-07-01 PG 4922.5 ... -0.147994 pg2508 pg
14 2025-07-01 LH 14620.0 ... -0.04959 lh2509 lh
15 2025-07-01 CF 15210.0 ... -0.096976 CF509 CF
16 2025-07-01 SR 6060.0 ... -0.04604 SR509 SR
17 2025-07-01 TA 5081.66 ... -0.05464 TA509 TA
18 2025-07-01 FG 1108.0 ... -0.108303 FG509 FG
19 2025-07-01 RM 2516.67 ... 0.026356 RM509 RM
20 2025-07-01 SF 5158.57 ... 0.019275 SF509 SF
21 2025-07-01 SM 5536.0 ... 0.013367 SM509 SM
22 2025-07-01 CY 23200.0 ... -0.137931 CY509 CY
23 2025-07-01 UR 1829.0 ... -0.065063 UR509 UR
24 2025-07-01 SA 1325.0 ... -0.117736 SA509 SA
25 2025-07-01 PF 6735.0 ... -0.023311 PF508 PF
26 2025-07-01 PX 7250.0 ... -0.062345 PX509 PX
27 2025-07-01 SH 833.0 ... 1.781513 SH509 SH
28 2025-07-01 CU 80235.0 ... -0.00268 cu2508 cu
29 2025-07-01 AL 20786.67 ... -0.010905 al2508 al
30 2025-07-01 ZN 22258.0 ... -0.000135 zn2508 zn
31 2025-07-01 PB 17018.75 ... 0.006831 pb2508 pb
32 2025-07-01 NI 121700.0 ... -0.010764 ni2508 ni
33 2025-07-01 SN 266637.5 ... 0.002635 sn2508 sn
34 2025-07-01 AU 768.73 ... 0.002485 au2510 au
35 2025-07-01 AG 8698.67 ... 0.004636 ag2508 ag
36 2025-07-01 RB 3069.0 ... -0.026719 rb2510 rb
37 2025-07-01 WR 3252.5 ... 0.015527 wr2510 wr
38 2025-07-01 HC 3206.67 ... -0.026716 hc2510 hc
39 2025-07-01 FU 5437.5 ... -0.453241 fu2509 fu
40 2025-07-01 BU 3670.0 ... -0.028338 bu2509 bu
41 2025-07-01 RU 13928.33 ... 0.003351 ru2509 ru
42 2025-07-01 SP 5950.0 ... -0.152269 sp2509 sp
43 2025-07-01 SS 12775.0 ... -0.018787 ss2508 ss
44 2025-07-01 BR 11820.0 ... -0.050761 br2508 br
45 2025-07-01 SI 8730.0 ... -0.10252 SI2509 si
46 2025-07-01 LC 61666.67 ... 0.005081 LC2509 lc
[47 rows x 15 columns]
2025-07-02 16:25:50,269 - future_1d - INFO - save future_spot 2025-07-01 completed
2025-07-02 16:25:59,077 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-02, end_day=2025-07-02) done
2025-07-02 16:25:59,092 - future_1d - INFO - save future_spot 2025-07-02 failed
=========================================================================
2025-07-02 18:25:47 Wed START TASK.01 future_1d future_spot
=========================================================================
2025-07-02 18:25:49,490 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-02 18:25:49,814 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-26, end_day=2025-06-26) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-26 C 2352.86 ... 0.01111 c2509 c
1 2025-06-26 A 4295.0 ... -0.033295 a2509 a
2 2025-06-26 M 2916.0 ... 0.012003 m2509 m
3 2025-06-26 Y 8254.0 ... -0.032954 y2509 y
4 2025-06-26 P 8560.0 ... -0.024766 p2509 p
5 2025-06-26 JD 2890.0 ... 0.230104 jd2508 jd
6 2025-06-26 L 7511.67 ... -0.029643 l2509 l
7 2025-06-26 V 4655.0 ... 0.044683 v2509 v
8 2025-06-26 PP 7483.33 ... -0.052962 pp2509 pp
9 2025-06-26 JM 1216.25 ... -0.335663 jm2509 jm
10 2025-06-26 I 715.78 ... -0.018553 i2509 i
11 2025-06-26 EG 4416.67 ... -0.025963 eg2509 eg
12 2025-06-26 EB 8164.0 ... -0.105953 eb2508 eb
13 2025-06-26 PG 4967.5 ... -0.143835 pg2508 pg
14 2025-06-26 LH 14330.0 ... -0.021284 lh2509 lh
15 2025-06-26 CF 15004.5 ... -0.08794 CF509 CF
16 2025-06-26 SR 6050.0 ... -0.044793 SR509 SR
17 2025-06-26 TA 5083.25 ... -0.063198 TA509 TA
18 2025-06-26 FG 1105.6 ... -0.082851 FG509 FG
19 2025-06-26 RM 2478.33 ... 0.028112 RM509 RM
20 2025-06-26 SF 5132.86 ... 0.048149 SF509 SF
21 2025-06-26 SM 5562.0 ... 0.018339 SM509 SM
22 2025-06-26 CY 23200.0 ... -0.134483 CY509 CY
23 2025-06-26 UR 1822.6 ... -0.056293 UR509 UR
24 2025-06-26 SA 1337.5 ... -0.123738 SA509 SA
25 2025-06-26 PF 6767.29 ... -0.028267 PF508 PF
26 2025-06-26 PX 7300.0 ... -0.080822 PX509 PX
27 2025-06-26 SH 839.0 ... 1.740167 SH509 SH
28 2025-06-26 CU 78886.67 ... -0.001859 cu2508 cu
29 2025-06-26 AL 20620.0 ... -0.011639 al2508 al
30 2025-06-26 ZN 22244.0 ... -0.004001 zn2508 zn
31 2025-06-26 PB 17075.0 ... 0.007613 pb2508 pb
32 2025-06-26 NI 121966.67 ... -0.017928 ni2508 ni
33 2025-06-26 SN 265425.0 ... 0.004766 sn2508 sn
34 2025-06-26 AU 771.53 ... 0.004731 au2510 au
35 2025-06-26 AG 8747.0 ... -0.000343 ag2508 ag
36 2025-06-26 RB 3060.33 ... -0.030823 rb2510 rb
37 2025-06-26 WR 3242.5 ... 0.02606 wr2601 wr
38 2025-06-26 HC 3200.0 ... -0.03375 hc2510 hc
39 2025-06-26 FU 5525.0 ... -0.45629 fu2509 fu
40 2025-06-26 BU 3700.0 ... -0.037297 bu2509 bu
41 2025-06-26 RU 13878.33 ... 0.000481 ru2509 ru
42 2025-06-26 SP 5983.33 ... -0.152646 sp2509 sp
43 2025-06-26 SS 12725.0 ... -0.007859 ss2508 ss
44 2025-06-26 BR 11800.0 ... -0.060169 br2508 br
45 2025-06-26 SI 8620.0 ... -0.104408 SI2509 si
46 2025-06-26 LC 60033.33 ... 0.020433 LC2509 lc
[47 rows x 15 columns]
2025-07-02 18:25:49,986 - future_1d - INFO - save future_spot 2025-06-26 completed
2025-07-02 18:25:57,314 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-27, end_day=2025-06-27) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-27 C 2352.86 ... 0.010685 c2509 c
1 2025-06-27 A 4295.0 ... -0.035157 a2509 a
2 2025-06-27 M 2906.0 ... 0.011012 m2509 m
3 2025-06-27 Y 8254.0 ... -0.030531 y2509 y
4 2025-06-27 P 8586.0 ... -0.025623 p2509 p
5 2025-06-27 JD 2890.0 ... 0.225606 jd2508 jd
6 2025-06-27 L 7511.67 ... -0.027114 l2509 l
7 2025-06-27 V 4673.0 ... 0.050931 v2509 v
8 2025-06-27 PP 7483.33 ... -0.049621 pp2509 pp
9 2025-06-27 JM 1216.25 ... -0.314286 jm2509 jm
10 2025-06-27 I 725.44 ... -0.01577 i2509 i
11 2025-06-27 EG 4416.67 ... -0.031171 eg2509 eg
12 2025-06-27 EB 8084.0 ... -0.095497 eb2508 eb
13 2025-06-27 PG 4967.5 ... -0.14464 pg2508 pg
14 2025-06-27 LH 14420.0 ... -0.02982 lh2509 lh
15 2025-06-27 CF 15105.67 ... -0.090408 CF509 CF
16 2025-06-27 SR 6056.67 ... -0.044524 SR509 SR
17 2025-06-27 TA 5084.75 ... -0.062294 TA509 TA
18 2025-06-27 FG 1105.6 ... -0.078329 FG509 FG
19 2025-06-27 RM 2475.0 ... 0.027475 RM509 RM
20 2025-06-27 SF 5158.57 ... 0.045251 SF509 SF
21 2025-06-27 SM 5572.0 ... 0.020101 SM509 SM
22 2025-06-27 CY 23200.0 ... -0.133405 CY509 CY
23 2025-06-27 UR 1827.0 ... -0.056924 UR509 UR
24 2025-06-27 SA 1337.5 ... -0.108785 SA509 SA
25 2025-06-27 PF 6736.04 ... -0.030291 PF508 PF
26 2025-06-27 PX 7300.0 ... -0.078356 PX509 PX
27 2025-06-27 SH 837.0 ... 1.783751 SH509 SH
28 2025-06-27 CU 80195.0 ... -0.005674 cu2508 cu
29 2025-06-27 AL 20903.33 ... -0.015707 al2508 al
30 2025-06-27 ZN 22568.0 ... -0.006336 zn2508 zn
31 2025-06-27 PB 17072.5 ... 0.007175 pb2508 pb
32 2025-06-27 NI 122433.33 ... -0.014729 ni2508 ni
33 2025-06-27 SN 269425.0 ... 0.001132 sn2508 sn
34 2025-06-27 AU 765.87 ... 0.008578 au2510 au
35 2025-06-27 AG 8800.67 ... 0.00106 ag2508 ag
36 2025-06-27 RB 3072.0 ... -0.026693 rb2510 rb
37 2025-06-27 WR 3252.5 ... 0.021368 wr2510 wr
38 2025-06-27 HC 3206.67 ... -0.02734 hc2510 hc
39 2025-06-27 FU 5525.0 ... -0.456109 fu2509 fu
40 2025-06-27 BU 3700.0 ... -0.038108 bu2509 bu
41 2025-06-27 RU 13878.33 ... 0.012009 ru2509 ru
42 2025-06-27 SP 5983.33 ... -0.149637 sp2509 sp
43 2025-06-27 SS 12762.5 ... -0.013516 ss2508 ss
44 2025-06-27 BR 11800.0 ... -0.05 br2508 br
45 2025-06-27 SI 8620.0 ... -0.091647 SI2509 si
46 2025-06-27 LC 60533.33 ... 0.036454 LC2509 lc
[47 rows x 15 columns]
2025-07-02 18:25:57,470 - future_1d - INFO - save future_spot 2025-06-27 completed
2025-07-02 18:26:05,029 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-30, end_day=2025-06-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-30 C 2357.14 ... 0.008001 c2509 c
1 2025-06-30 A 4295.0 ... -0.034459 a2509 a
2 2025-06-30 M 2906.0 ... 0.017894 m2509 m
3 2025-06-30 Y 8234.0 ... -0.031576 y2509 y
4 2025-06-30 P 8570.0 ... -0.030105 p2509 p
5 2025-06-30 JD 2810.0 ... 0.259431 jd2508 jd
6 2025-06-30 L 7503.33 ... -0.028964 l2509 l
7 2025-06-30 V 4658.0 ... 0.057106 v2509 v
8 2025-06-30 PP 7466.67 ... -0.050179 pp2509 pp
9 2025-06-30 JM 1216.25 ... -0.307297 jm2509 jm
10 2025-06-30 I 726.56 ... -0.011782 i2509 i
11 2025-06-30 EG 4413.33 ... -0.032023 eg2509 eg
12 2025-06-30 EB 8050.0 ... -0.092422 eb2508 eb
13 2025-06-30 PG 4922.5 ... -0.140681 pg2508 pg
14 2025-06-30 LH 14480.0 ... -0.040746 lh2509 lh
15 2025-06-30 CF 15159.83 ... -0.08871 CF509 CF
16 2025-06-30 SR 6053.33 ... -0.041519 SR509 SR
17 2025-06-30 TA 5104.75 ... -0.054998 TA509 TA
18 2025-06-30 FG 1105.6 ... -0.079233 FG509 FG
19 2025-06-30 RM 2500.0 ... 0.0276 RM509 RM
20 2025-06-30 SF 5158.57 ... 0.042925 SF509 SF
21 2025-06-30 SM 5564.0 ... 0.020489 SM509 SM
22 2025-06-30 CY 23200.0 ... -0.13319 CY509 CY
23 2025-06-30 UR 1823.0 ... -0.059243 UR509 UR
24 2025-06-30 SA 1325.0 ... -0.095094 SA509 SA
25 2025-06-30 PF 6727.92 ... -0.02704 PF508 PF
26 2025-06-30 PX 7300.0 ... -0.064932 PX509 PX
27 2025-06-30 SH 835.0 ... 1.802395 SH509 SH
28 2025-06-30 CU 80001.67 ... -0.002896 cu2508 cu
29 2025-06-30 AL 20786.67 ... -0.011386 al2508 al
30 2025-06-30 ZN 22486.0 ... -0.002268 zn2508 zn
31 2025-06-30 PB 17043.75 ... 0.005941 pb2508 pb
32 2025-06-30 NI 122400.0 ... -0.011683 ni2508 ni
33 2025-06-30 SN 267487.5 ... 0.002439 sn2508 sn
34 2025-06-30 AU 762.1 ... 0.003622 au2510 au
35 2025-06-30 AG 8680.0 ... 0.003802 ag2508 ag
36 2025-06-30 RB 3072.0 ... -0.020508 rb2510 rb
37 2025-06-30 WR 3260.0 ... 0.020859 wr2510 wr
38 2025-06-30 HC 3210.0 ... -0.023676 hc2510 hc
39 2025-06-30 FU 5462.5 ... -0.452632 fu2509 fu
40 2025-06-30 BU 3673.33 ... -0.031941 bu2509 bu
41 2025-06-30 RU 13858.33 ... 0.010944 ru2509 ru
42 2025-06-30 SP 5950.0 ... -0.148571 sp2509 sp
43 2025-06-30 SS 12775.0 ... -0.008219 ss2508 ss
44 2025-06-30 BR 11820.0 ... -0.046531 br2508 br
45 2025-06-30 SI 8730.0 ... -0.070447 SI2509 si
46 2025-06-30 LC 61466.67 ... 0.01974 LC2509 lc
[47 rows x 15 columns]
2025-07-02 18:26:05,193 - future_1d - INFO - save future_spot 2025-06-30 completed
2025-07-02 18:26:13,925 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-01, end_day=2025-07-01) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-01 C 2365.71 ... 0.006463 c2509 c
1 2025-07-01 A 4295.0 ... -0.03865 a2509 a
2 2025-07-01 M 2930.0 ... 0.01058 m2509 m
3 2025-07-01 Y 8224.0 ... -0.031128 y2509 y
4 2025-07-01 P 8600.0 ... -0.033256 p2509 p
5 2025-07-01 JD 2790.0 ... 0.278853 jd2508 jd
6 2025-07-01 L 7486.67 ... -0.032146 l2509 l
7 2025-07-01 V 4597.0 ... 0.052643 v2509 v
8 2025-07-01 PP 7458.33 ... -0.055016 pp2509 pp
9 2025-07-01 JM 1216.25 ... -0.327852 jm2509 jm
10 2025-07-01 I 723.44 ... -0.017887 i2509 i
11 2025-07-01 EG 4396.67 ... -0.03063 eg2509 eg
12 2025-07-01 EB 8036.0 ... -0.094948 eb2508 eb
13 2025-07-01 PG 4922.5 ... -0.147994 pg2508 pg
14 2025-07-01 LH 14620.0 ... -0.04959 lh2509 lh
15 2025-07-01 CF 15210.0 ... -0.096976 CF509 CF
16 2025-07-01 SR 6060.0 ... -0.04604 SR509 SR
17 2025-07-01 TA 5081.66 ... -0.05464 TA509 TA
18 2025-07-01 FG 1108.0 ... -0.108303 FG509 FG
19 2025-07-01 RM 2516.67 ... 0.026356 RM509 RM
20 2025-07-01 SF 5158.57 ... 0.019275 SF509 SF
21 2025-07-01 SM 5536.0 ... 0.013367 SM509 SM
22 2025-07-01 CY 23200.0 ... -0.137931 CY509 CY
23 2025-07-01 UR 1829.0 ... -0.065063 UR509 UR
24 2025-07-01 SA 1325.0 ... -0.117736 SA509 SA
25 2025-07-01 PF 6735.0 ... -0.023311 PF508 PF
26 2025-07-01 PX 7250.0 ... -0.062345 PX509 PX
27 2025-07-01 SH 833.0 ... 1.781513 SH509 SH
28 2025-07-01 CU 80235.0 ... -0.00268 cu2508 cu
29 2025-07-01 AL 20786.67 ... -0.010905 al2508 al
30 2025-07-01 ZN 22258.0 ... -0.000135 zn2508 zn
31 2025-07-01 PB 17018.75 ... 0.006831 pb2508 pb
32 2025-07-01 NI 121700.0 ... -0.010764 ni2508 ni
33 2025-07-01 SN 266637.5 ... 0.002635 sn2508 sn
34 2025-07-01 AU 768.73 ... 0.002485 au2510 au
35 2025-07-01 AG 8698.67 ... 0.004636 ag2508 ag
36 2025-07-01 RB 3069.0 ... -0.026719 rb2510 rb
37 2025-07-01 WR 3252.5 ... 0.015527 wr2510 wr
38 2025-07-01 HC 3206.67 ... -0.026716 hc2510 hc
39 2025-07-01 FU 5437.5 ... -0.453241 fu2509 fu
40 2025-07-01 BU 3670.0 ... -0.028338 bu2509 bu
41 2025-07-01 RU 13928.33 ... 0.003351 ru2509 ru
42 2025-07-01 SP 5950.0 ... -0.152269 sp2509 sp
43 2025-07-01 SS 12775.0 ... -0.018787 ss2508 ss
44 2025-07-01 BR 11820.0 ... -0.050761 br2508 br
45 2025-07-01 SI 8730.0 ... -0.10252 SI2509 si
46 2025-07-01 LC 61666.67 ... 0.005081 LC2509 lc
[47 rows x 15 columns]
2025-07-02 18:26:14,080 - future_1d - INFO - save future_spot 2025-07-01 completed
2025-07-02 18:26:17,554 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-02, end_day=2025-07-02) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-02 C 2367.14 ... 0.000786 c2509 c
1 2025-07-02 A 4295.0 ... -0.036787 a2509 a
2 2025-07-02 M 2922.0 ... 0.008556 m2509 m
3 2025-07-02 Y 8284.0 ... -0.036456 y2509 y
4 2025-07-02 P 8638.0 ... -0.030331 p2509 p
5 2025-07-02 JD 2790.0 ... 0.276344 jd2508 jd
6 2025-07-02 L 7466.67 ... -0.027277 l2509 l
7 2025-07-02 V 4654.0 ... 0.047916 v2509 v
8 2025-07-02 PP 7325.0 ... -0.036451 pp2509 pp
9 2025-07-02 JM 1226.25 ... -0.327217 jm2509 jm
10 2025-07-02 I 720.22 ... -0.006554 i2509 i
11 2025-07-02 EG 4400.0 ... -0.025227 eg2509 eg
12 2025-07-02 EB 8036.0 ... -0.09781 eb2508 eb
13 2025-07-02 PG 4947.5 ... -0.150682 pg2508 pg
14 2025-07-02 LH 14750.0 ... -0.037966 lh2509 lh
15 2025-07-02 CF 15160.33 ... -0.090719 CF509 CF
16 2025-07-02 SR 6050.0 ... -0.052066 SR509 SR
17 2025-07-02 TA 5031.25 ... -0.050335 TA509 TA
18 2025-07-02 FG 1108.0 ... -0.076715 FG509 FG
19 2025-07-02 RM 2506.67 ... 0.028057 RM509 RM
20 2025-07-02 SF 5122.86 ... 0.047852 SF509 SF
21 2025-07-02 SM 5544.0 ... 0.027056 SM509 SM
22 2025-07-02 CY 23200.0 ... -0.135129 CY509 CY
23 2025-07-02 UR 1825.0 ... -0.052055 UR509 UR
24 2025-07-02 SA 1252.5 ... -0.053892 SA509 SA
25 2025-07-02 PF 6744.17 ... -0.021674 PF508 PF
26 2025-07-02 PX 7250.0 ... -0.067586 PX509 PX
27 2025-07-02 SH 827.0 ... 1.870617 SH509 SH
28 2025-07-02 CU 80983.33 ... -0.004486 cu2508 cu
29 2025-07-02 AL 20786.67 ... -0.005853 al2508 al
30 2025-07-02 ZN 22270.0 ... -0.00247 zn2508 zn
31 2025-07-02 PB 17010.0 ... 0.008818 pb2508 pb
32 2025-07-02 NI 122383.33 ... -0.012774 ni2508 ni
33 2025-07-02 SN 268537.5 ... 0.002839 sn2508 sn
34 2025-07-02 AU 768.73 ... 0.011565 au2510 au
35 2025-07-02 AG 8698.67 ... 0.009695 ag2508 ag
36 2025-07-02 RB 3087.5 ... -0.017976 rb2510 rb
37 2025-07-02 WR 3292.5 ... 0.010782 wr2510 wr
38 2025-07-02 HC 3216.67 ... -0.016996 hc2510 hc
39 2025-07-02 FU 5425.0 ... -0.455115 fu2509 fu
40 2025-07-02 BU 3670.0 ... -0.024796 bu2509 bu
41 2025-07-02 RU 13983.33 ... 0.007628 ru2509 ru
42 2025-07-02 SP 5950.0 ... -0.151597 sp2509 sp
43 2025-07-02 SS 12825.0 ... -0.014425 ss2508 ss
44 2025-07-02 BR 11820.0 ... -0.049915 br2508 br
45 2025-07-02 SI 8850.0 ... -0.086441 SI2509 si
46 2025-07-02 LC 61966.67 ... 0.024744 LC2509 lc
[47 rows x 15 columns]
2025-07-02 18:26:17,727 - future_1d - INFO - save future_spot 2025-07-02 add
2025-07-02 18:26:17,736 - future_1d - INFO - 0 ... 4
date 2025-07-02 ... 2025-07-02
variety C ... P
spot_price 2367.14 ... 8638.0
near_contract c2507 ... p2507
near_contract_price 2356.0 ... 8452.0
dominant_contract c2509 ... p2509
dominant_contract_price 2369.0 ... 8376.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis -11.14 ... -186.0
dom_basis 1.86 ... -262.0
near_basis_rate -0.0047 ... -0.0215
dom_basis_rate 0.0008 ... -0.0303
symbol c2509 ... p2509
comd c ... p
created_at 2025-07-02 18:26:17.684723 ... 2025-07-02 18:26:17.684723
updated_at 2025-07-02 18:26:17.685147 ... 2025-07-02 18:26:17.685147
[17 rows x 5 columns]