=========================================================================
2025-06-27 16:25:39 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-06-27 16:25:41,306 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-27 16:25:41,621 - 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-27 16:25:41,795 - future_1d - INFO - save future_spot 2025-06-23 completed
2025-06-27 16:25:48,094 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-24, end_day=2025-06-24) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-24 C 2345.71 ... 0.02016 c2509 c
1 2025-06-24 A 4295.0 ... -0.01397 a2509 a
2 2025-06-24 M 2974.0 ... 0.018494 m2509 m
3 2025-06-24 Y 8214.0 ... -0.025566 y2509 y
4 2025-06-24 P 8602.0 ... -0.026505 p2509 p
5 2025-06-24 JD 2925.0 ... 0.215385 jd2508 jd
6 2025-06-24 L 7571.67 ... -0.037068 l2509 l
7 2025-06-24 V 4635.0 ... 0.04466 v2509 v
8 2025-06-24 PP 7501.67 ... -0.051678 pp2509 pp
9 2025-06-24 JM 1221.25 ... -0.346162 jm2509 jm
10 2025-06-24 I 723.11 ... -0.024353 i2509 i
11 2025-06-24 EG 4460.0 ... -0.019058 eg2509 eg
12 2025-06-24 EB 8264.0 ... -0.111931 eb2508 eb
13 2025-06-24 PG 5080.0 ... -0.143504 pg2508 pg
14 2025-06-24 LH 14280.0 ... -0.021359 lh2509 lh
15 2025-06-24 CF 14868.0 ... -0.089656 CF509 CF
16 2025-06-24 SR 6050.0 ... -0.055041 SR509 SR
17 2025-06-24 TA 5114.0 ... -0.054752 TA509 TA
18 2025-06-24 FG 1105.6 ... -0.082851 FG509 FG
19 2025-06-24 RM 2588.33 ... 0.024985 RM509 RM
20 2025-06-24 SF 5128.57 ... 0.028747 SF509 SF
21 2025-06-24 SM 5518.0 ... 0.006524 SM509 SM
22 2025-06-24 CY 23200.0 ... -0.147414 CY509 CY
23 2025-06-24 UR 1804.0 ... -0.058758 UR509 UR
24 2025-06-24 SA 1350.0 ... -0.137037 SA509 SA
25 2025-06-24 PF 6838.75 ... -0.024383 PF508 PF
26 2025-06-24 PX 7300.0 ... -0.059178 PX509 PX
27 2025-06-24 SH 839.0 ... 1.713945 SH509 SH
28 2025-06-24 CU 78471.67 ... -0.00257 cu2508 cu
29 2025-06-24 AL 20553.33 ... -0.010866 al2508 al
30 2025-06-24 ZN 22134.0 ... -0.009668 zn2508 zn
31 2025-06-24 PB 16850.0 ... 0.005341 pb2508 pb
32 2025-06-24 NI 119050.0 ... -0.014196 ni2508 ni
33 2025-06-24 SN 263612.5 ... -0.001792 sn2508 sn
34 2025-06-24 AU 773.36 ... 0.008301 au2508 au
35 2025-06-24 AG 8719.33 ... 0.005238 ag2508 ag
36 2025-06-24 RB 3071.0 ... -0.027678 rb2510 rb
37 2025-06-24 WR 3255.0 ... 0.010753 wr2510 wr
38 2025-06-24 HC 3190.0 ... -0.026332 hc2510 hc
39 2025-06-24 FU 5550.0 ... -0.422342 fu2509 fu
40 2025-06-24 BU 3773.33 ... -0.03454 bu2509 bu
41 2025-06-24 RU 13538.33 ... 0.017481 ru2509 ru
42 2025-06-24 SP 6066.67 ... -0.147143 sp2509 sp
43 2025-06-24 SS 12762.5 ... -0.029579 ss2508 ss
44 2025-06-24 BR 12000.0 ... -0.0675 br2508 br
45 2025-06-24 SI 8620.0 ... -0.136891 SI2509 si
46 2025-06-24 LC 59966.67 ... 0.005559 LC2509 lc
[47 rows x 15 columns]
2025-06-27 16:25:48,248 - future_1d - INFO - save future_spot 2025-06-24 completed
2025-06-27 16:25:56,524 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-25, end_day=2025-06-25) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-25 C 2350.0 ... 0.013191 c2509 c
1 2025-06-25 A 4295.0 ... -0.025378 a2509 a
2 2025-06-25 M 2958.0 ... 0.017241 m2509 m
3 2025-06-25 Y 8244.0 ... -0.035177 y2509 y
4 2025-06-25 P 8560.0 ... -0.02757 p2509 p
5 2025-06-25 JD 2890.0 ... 0.233564 jd2508 jd
6 2025-06-25 L 7548.33 ... -0.039788 l2509 l
7 2025-06-25 V 4661.0 ... 0.040549 v2509 v
8 2025-06-25 PP 7493.33 ... -0.056494 pp2509 pp
9 2025-06-25 JM 1221.25 ... -0.352303 jm2509 jm
10 2025-06-25 I 717.44 ... -0.022915 i2509 i
11 2025-06-25 EG 4423.33 ... -0.023586 eg2509 eg
12 2025-06-25 EB 8224.0 ... -0.118677 eb2508 eb
13 2025-06-25 PG 5055.0 ... -0.167359 pg2508 pg
14 2025-06-25 LH 14320.0 ... -0.023743 lh2509 lh
15 2025-06-25 CF 14913.67 ... -0.087079 CF509 CF
16 2025-06-25 SR 6053.33 ... -0.053909 SR509 SR
17 2025-06-25 TA 5114.0 ... -0.065311 TA509 TA
18 2025-06-25 FG 1105.6 ... -0.08466 FG509 FG
19 2025-06-25 RM 2566.67 ... 0.020778 RM509 RM
20 2025-06-25 SF 5125.71 ... 0.040246 SF509 SF
21 2025-06-25 SM 5520.0 ... 0.018478 SM509 SM
22 2025-06-25 CY 23200.0 ... -0.140733 CY509 CY
23 2025-06-25 UR 1804.0 ... -0.046009 UR509 UR
24 2025-06-25 SA 1337.5 ... -0.13271 SA509 SA
25 2025-06-25 PF 6801.88 ... -0.030856 PF508 PF
26 2025-06-25 PX 7300.0 ... -0.075068 PX509 PX
27 2025-06-25 SH 839.0 ... 1.707986 SH509 SH
28 2025-06-25 CU 78630.0 ... -0.002416 cu2508 cu
29 2025-06-25 AL 20550.0 ... -0.012409 al2508 al
30 2025-06-25 ZN 22176.0 ... -0.009515 zn2508 zn
31 2025-06-25 PB 17031.25 ... 0.005211 pb2508 pb
32 2025-06-25 NI 119733.33 ... -0.013808 ni2508 ni
33 2025-06-25 SN 262250.0 ... -0.000038 sn2508 sn
34 2025-06-25 AU 770.24 ... -0.000338 au2508 au
35 2025-06-25 AG 8668.67 ... -0.002269 ag2508 ag
36 2025-06-25 RB 3062.33 ... -0.03015 rb2510 rb
37 2025-06-25 WR 3242.5 ... 0.029761 wr2601 wr
38 2025-06-25 HC 3180.0 ... -0.027987 hc2510 hc
39 2025-06-25 FU 5525.0 ... -0.453394 fu2509 fu
40 2025-06-25 BU 3700.0 ... -0.038919 bu2509 bu
41 2025-06-25 RU 13628.33 ... 0.008928 ru2509 ru
42 2025-06-25 SP 6000.0 ... -0.153333 sp2509 sp
43 2025-06-25 SS 12725.0 ... -0.018468 ss2508 ss
44 2025-06-25 BR 11800.0 ... -0.062288 br2508 br
45 2025-06-25 SI 8620.0 ... -0.12761 SI2509 si
46 2025-06-25 LC 59900.0 ... 0.015025 LC2509 lc
[47 rows x 15 columns]
2025-06-27 16:25:56,681 - future_1d - INFO - save future_spot 2025-06-25 completed
2025-06-27 16:26:03,610 - 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-06-27 16:26:03,764 - future_1d - INFO - save future_spot 2025-06-26 completed
2025-06-27 16:26:10,243 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-27, end_day=2025-06-27) done
2025-06-27 16:26:10,258 - future_1d - INFO - save future_spot 2025-06-27 failed
=========================================================================
2025-06-27 18:25:25 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-06-27 18:25:27,369 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-27 18:25:27,696 - 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-27 18:25:27,866 - future_1d - INFO - save future_spot 2025-06-23 completed
2025-06-27 18:25:37,360 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-24, end_day=2025-06-24) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-24 C 2345.71 ... 0.02016 c2509 c
1 2025-06-24 A 4295.0 ... -0.01397 a2509 a
2 2025-06-24 M 2974.0 ... 0.018494 m2509 m
3 2025-06-24 Y 8214.0 ... -0.025566 y2509 y
4 2025-06-24 P 8602.0 ... -0.026505 p2509 p
5 2025-06-24 JD 2925.0 ... 0.215385 jd2508 jd
6 2025-06-24 L 7571.67 ... -0.037068 l2509 l
7 2025-06-24 V 4635.0 ... 0.04466 v2509 v
8 2025-06-24 PP 7501.67 ... -0.051678 pp2509 pp
9 2025-06-24 JM 1221.25 ... -0.346162 jm2509 jm
10 2025-06-24 I 723.11 ... -0.024353 i2509 i
11 2025-06-24 EG 4460.0 ... -0.019058 eg2509 eg
12 2025-06-24 EB 8264.0 ... -0.111931 eb2508 eb
13 2025-06-24 PG 5080.0 ... -0.143504 pg2508 pg
14 2025-06-24 LH 14280.0 ... -0.021359 lh2509 lh
15 2025-06-24 CF 14868.0 ... -0.089656 CF509 CF
16 2025-06-24 SR 6050.0 ... -0.055041 SR509 SR
17 2025-06-24 TA 5114.0 ... -0.054752 TA509 TA
18 2025-06-24 FG 1105.6 ... -0.082851 FG509 FG
19 2025-06-24 RM 2588.33 ... 0.024985 RM509 RM
20 2025-06-24 SF 5128.57 ... 0.028747 SF509 SF
21 2025-06-24 SM 5518.0 ... 0.006524 SM509 SM
22 2025-06-24 CY 23200.0 ... -0.147414 CY509 CY
23 2025-06-24 UR 1804.0 ... -0.058758 UR509 UR
24 2025-06-24 SA 1350.0 ... -0.137037 SA509 SA
25 2025-06-24 PF 6838.75 ... -0.024383 PF508 PF
26 2025-06-24 PX 7300.0 ... -0.059178 PX509 PX
27 2025-06-24 SH 839.0 ... 1.713945 SH509 SH
28 2025-06-24 CU 78471.67 ... -0.00257 cu2508 cu
29 2025-06-24 AL 20553.33 ... -0.010866 al2508 al
30 2025-06-24 ZN 22134.0 ... -0.009668 zn2508 zn
31 2025-06-24 PB 16850.0 ... 0.005341 pb2508 pb
32 2025-06-24 NI 119050.0 ... -0.014196 ni2508 ni
33 2025-06-24 SN 263612.5 ... -0.001792 sn2508 sn
34 2025-06-24 AU 773.36 ... 0.008301 au2508 au
35 2025-06-24 AG 8719.33 ... 0.005238 ag2508 ag
36 2025-06-24 RB 3071.0 ... -0.027678 rb2510 rb
37 2025-06-24 WR 3255.0 ... 0.010753 wr2510 wr
38 2025-06-24 HC 3190.0 ... -0.026332 hc2510 hc
39 2025-06-24 FU 5550.0 ... -0.422342 fu2509 fu
40 2025-06-24 BU 3773.33 ... -0.03454 bu2509 bu
41 2025-06-24 RU 13538.33 ... 0.017481 ru2509 ru
42 2025-06-24 SP 6066.67 ... -0.147143 sp2509 sp
43 2025-06-24 SS 12762.5 ... -0.029579 ss2508 ss
44 2025-06-24 BR 12000.0 ... -0.0675 br2508 br
45 2025-06-24 SI 8620.0 ... -0.136891 SI2509 si
46 2025-06-24 LC 59966.67 ... 0.005559 LC2509 lc
[47 rows x 15 columns]
2025-06-27 18:25:37,519 - future_1d - INFO - save future_spot 2025-06-24 completed
2025-06-27 18:25:42,926 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-25, end_day=2025-06-25) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-25 C 2350.0 ... 0.013191 c2509 c
1 2025-06-25 A 4295.0 ... -0.025378 a2509 a
2 2025-06-25 M 2958.0 ... 0.017241 m2509 m
3 2025-06-25 Y 8244.0 ... -0.035177 y2509 y
4 2025-06-25 P 8560.0 ... -0.02757 p2509 p
5 2025-06-25 JD 2890.0 ... 0.233564 jd2508 jd
6 2025-06-25 L 7548.33 ... -0.039788 l2509 l
7 2025-06-25 V 4661.0 ... 0.040549 v2509 v
8 2025-06-25 PP 7493.33 ... -0.056494 pp2509 pp
9 2025-06-25 JM 1221.25 ... -0.352303 jm2509 jm
10 2025-06-25 I 717.44 ... -0.022915 i2509 i
11 2025-06-25 EG 4423.33 ... -0.023586 eg2509 eg
12 2025-06-25 EB 8224.0 ... -0.118677 eb2508 eb
13 2025-06-25 PG 5055.0 ... -0.167359 pg2508 pg
14 2025-06-25 LH 14320.0 ... -0.023743 lh2509 lh
15 2025-06-25 CF 14913.67 ... -0.087079 CF509 CF
16 2025-06-25 SR 6053.33 ... -0.053909 SR509 SR
17 2025-06-25 TA 5114.0 ... -0.065311 TA509 TA
18 2025-06-25 FG 1105.6 ... -0.08466 FG509 FG
19 2025-06-25 RM 2566.67 ... 0.020778 RM509 RM
20 2025-06-25 SF 5125.71 ... 0.040246 SF509 SF
21 2025-06-25 SM 5520.0 ... 0.018478 SM509 SM
22 2025-06-25 CY 23200.0 ... -0.140733 CY509 CY
23 2025-06-25 UR 1804.0 ... -0.046009 UR509 UR
24 2025-06-25 SA 1337.5 ... -0.13271 SA509 SA
25 2025-06-25 PF 6801.88 ... -0.030856 PF508 PF
26 2025-06-25 PX 7300.0 ... -0.075068 PX509 PX
27 2025-06-25 SH 839.0 ... 1.707986 SH509 SH
28 2025-06-25 CU 78630.0 ... -0.002416 cu2508 cu
29 2025-06-25 AL 20550.0 ... -0.012409 al2508 al
30 2025-06-25 ZN 22176.0 ... -0.009515 zn2508 zn
31 2025-06-25 PB 17031.25 ... 0.005211 pb2508 pb
32 2025-06-25 NI 119733.33 ... -0.013808 ni2508 ni
33 2025-06-25 SN 262250.0 ... -0.000038 sn2508 sn
34 2025-06-25 AU 770.24 ... -0.000338 au2508 au
35 2025-06-25 AG 8668.67 ... -0.002269 ag2508 ag
36 2025-06-25 RB 3062.33 ... -0.03015 rb2510 rb
37 2025-06-25 WR 3242.5 ... 0.029761 wr2601 wr
38 2025-06-25 HC 3180.0 ... -0.027987 hc2510 hc
39 2025-06-25 FU 5525.0 ... -0.453394 fu2509 fu
40 2025-06-25 BU 3700.0 ... -0.038919 bu2509 bu
41 2025-06-25 RU 13628.33 ... 0.008928 ru2509 ru
42 2025-06-25 SP 6000.0 ... -0.153333 sp2509 sp
43 2025-06-25 SS 12725.0 ... -0.018468 ss2508 ss
44 2025-06-25 BR 11800.0 ... -0.062288 br2508 br
45 2025-06-25 SI 8620.0 ... -0.12761 SI2509 si
46 2025-06-25 LC 59900.0 ... 0.015025 LC2509 lc
[47 rows x 15 columns]
2025-06-27 18:25:43,084 - future_1d - INFO - save future_spot 2025-06-25 completed
2025-06-27 18:25:47,693 - 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-06-27 18:25:47,851 - future_1d - INFO - save future_spot 2025-06-26 completed
2025-06-27 18:25:56,162 - 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-06-27 18:25:56,358 - future_1d - INFO - save future_spot 2025-06-27 add
2025-06-27 18:25:56,370 - future_1d - INFO - 0 ... 4
date 2025-06-27 ... 2025-06-27
variety C ... P
spot_price 2352.86 ... 8586.0
near_contract c2507 ... p2507
near_contract_price 2356.0 ... 8424.0
dominant_contract c2509 ... p2509
dominant_contract_price 2378.0 ... 8366.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 3.14 ... -162.0
dom_basis 25.14 ... -220.0
near_basis_rate 0.0013 ... -0.0189
dom_basis_rate 0.0107 ... -0.0256
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-27 18:25:56.311251 ... 2025-06-27 18:25:56.311251
updated_at 2025-06-27 18:25:56.311824 ... 2025-06-27 18:25:56.311824
[17 rows x 5 columns]