=========================================================================
2025-07-08 16:25:36 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-07-08 16:25:38,757 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-08 16:25:39,093 - 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-08 16:25:39,267 - future_1d - INFO - save future_spot 2025-07-02 completed
2025-07-08 16:25:43,489 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-03, end_day=2025-07-03) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-03 C 2367.14 ... -0.001326 c2509 c
1 2025-07-03 A 4295.0 ... -0.034226 a2509 a
2 2025-07-03 M 2930.0 ... 0.010239 m2509 m
3 2025-07-03 Y 8264.0 ... -0.029526 y2509 y
4 2025-07-03 P 8744.0 ... -0.030421 p2509 p
5 2025-07-03 JD 2790.0 ... 0.275269 jd2508 jd
6 2025-07-03 L 7441.67 ... -0.019978 l2509 l
7 2025-07-03 V 4693.0 ... 0.0456 v2509 v
8 2025-07-03 PP 7406.67 ... -0.043565 pp2509 pp
9 2025-07-03 JM 1236.25 ... -0.31365 jm2509 jm
10 2025-07-03 I 730.67 ... -0.003654 i2509 i
11 2025-07-03 EG 4400.0 ... -0.023864 eg2509 eg
12 2025-07-03 EB 7904.0 ... -0.077935 eb2508 eb
13 2025-07-03 PG 4947.5 ... -0.147246 pg2508 pg
14 2025-07-03 LH 14920.0 ... -0.04055 lh2509 lh
15 2025-07-03 CF 15199.83 ... -0.092753 CF509 CF
16 2025-07-03 SR 6050.0 ... -0.047438 SR509 SR
17 2025-07-03 TA 5031.25 ... -0.053516 TA509 TA
18 2025-07-03 FG 1116.0 ... -0.066308 FG509 FG
19 2025-07-03 RM 2530.0 ... 0.028063 RM509 RM
20 2025-07-03 SF 5122.86 ... 0.054099 SF509 SF
21 2025-07-03 SM 5576.0 ... 0.023314 SM509 SM
22 2025-07-03 CY 23200.0 ... -0.135345 CY509 CY
23 2025-07-03 UR 1829.0 ... -0.052488 UR509 UR
24 2025-07-03 SA 1252.5 ... -0.051497 SA509 SA
25 2025-07-03 PF 6748.54 ... -0.0229 PF508 PF
26 2025-07-03 PX 7250.0 ... -0.069241 PX509 PX
27 2025-07-03 SH 827.0 ... 1.88029 SH509 SH
28 2025-07-03 CU 81021.67 ... -0.00323 cu2508 cu
29 2025-07-03 AL 20870.0 ... -0.008864 al2508 al
30 2025-07-03 ZN 22400.0 ... -0.002902 zn2508 zn
31 2025-07-03 PB 17100.0 ... 0.009357 pb2508 pb
32 2025-07-03 NI 122933.33 ... -0.011741 ni2508 ni
33 2025-07-03 SN 268700.0 ... 0.001154 sn2508 sn
34 2025-07-03 AU 775.32 ... 0.004463 au2510 au
35 2025-07-03 AG 8818.33 ... 0.008468 ag2510 ag
36 2025-07-03 RB 3104.0 ... -0.012564 rb2510 rb
37 2025-07-03 WR 3292.5 ... 0.010782 wr2510 wr
38 2025-07-03 HC 3233.33 ... -0.012473 hc2510 hc
39 2025-07-03 FU 5450.0 ... -0.452844 fu2509 fu
40 2025-07-03 BU 3683.33 ... -0.028053 bu2509 bu
41 2025-07-03 RU 13858.33 ... 0.014191 ru2509 ru
42 2025-07-03 SP 5950.0 ... -0.14521 sp2509 sp
43 2025-07-03 SS 12825.0 ... -0.011306 ss2508 ss
44 2025-07-03 BR 11730.0 ... -0.039216 br2508 br
45 2025-07-03 SI 8890.0 ... -0.096175 SI2509 si
46 2025-07-03 LC 61966.67 ... 0.02894 LC2509 lc
[47 rows x 15 columns]
2025-07-08 16:25:43,643 - future_1d - INFO - save future_spot 2025-07-03 completed
2025-07-08 16:25:47,324 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-04, end_day=2025-07-04) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-04 C 2367.14 ... -0.003861 c2509 c
1 2025-07-04 A 4295.0 ... -0.037718 a2509 a
2 2025-07-04 M 2928.0 ... 0.011612 m2509 m
3 2025-07-04 Y 8214.0 ... -0.029949 y2509 y
4 2025-07-04 P 8710.0 ... -0.025029 p2509 p
5 2025-07-04 JD 2790.0 ... 0.32509 jd2509 jd
6 2025-07-04 L 7445.0 ... -0.018402 l2509 l
7 2025-07-04 V 4678.0 ... 0.051518 v2509 v
8 2025-07-04 PP 7406.67 ... -0.04262 pp2509 pp
9 2025-07-04 JM 1236.25 ... -0.312437 jm2509 jm
10 2025-07-04 I 741.78 ... -0.007792 i2509 i
11 2025-07-04 EG 4405.0 ... -0.025426 eg2509 eg
12 2025-07-04 EB 7904.0 ... -0.069205 eb2508 eb
13 2025-07-04 PG 4972.5 ... -0.152338 pg2508 pg
14 2025-07-04 LH 15020.0 ... -0.045273 lh2509 lh
15 2025-07-04 CF 15198.33 ... -0.092663 CF509 CF
16 2025-07-04 SR 6053.33 ... -0.043502 SR509 SR
17 2025-07-04 TA 5031.25 ... -0.058286 TA509 TA
18 2025-07-04 FG 1122.4 ... -0.081433 FG509 FG
19 2025-07-04 RM 2535.0 ... 0.028402 RM509 RM
20 2025-07-04 SF 5152.86 ... 0.048738 SF509 SF
21 2025-07-04 SM 5576.0 ... 0.020445 SM509 SM
22 2025-07-04 CY 23200.0 ... -0.136638 CY509 CY
23 2025-07-04 UR 1829.0 ... -0.041006 UR509 UR
24 2025-07-04 SA 1252.5 ... -0.054691 SA509 SA
25 2025-07-04 PF 6739.58 ... -0.028129 PF508 PF
26 2025-07-04 PX 7250.0 ... -0.072276 PX509 PX
27 2025-07-04 SH 827.0 ... 1.882709 SH509 SH
28 2025-07-04 CU 80533.33 ... -0.004512 cu2508 cu
29 2025-07-04 AL 20780.0 ... -0.006737 al2508 al
30 2025-07-04 ZN 22394.0 ... -0.001965 zn2508 zn
31 2025-07-04 PB 17112.5 ... 0.009204 pb2508 pb
32 2025-07-04 NI 123783.33 ... -0.010529 ni2508 ni
33 2025-07-04 SN 267600.0 ... 0.005157 sn2508 sn
34 2025-07-04 AU 771.61 ... 0.005067 au2510 au
35 2025-07-04 AG 8902.0 ... 0.004718 ag2510 ag
36 2025-07-04 RB 3113.0 ... -0.009958 rb2510 rb
37 2025-07-04 WR 3312.5 ... 0.009208 wr2510 wr
38 2025-07-04 HC 3273.33 ... -0.019042 hc2510 hc
39 2025-07-04 FU 5425.0 ... -0.451244 fu2509 fu
40 2025-07-04 BU 3713.33 ... -0.033751 bu2509 bu
41 2025-07-04 RU 13958.33 ... 0.008358 ru2509 ru
42 2025-07-04 SP 5950.0 ... -0.146218 sp2509 sp
43 2025-07-04 SS 12887.5 ... -0.009893 ss2508 ss
44 2025-07-04 BR 11730.0 ... -0.046462 br2509 br
45 2025-07-04 SI 8890.0 ... -0.101237 SI2509 si
46 2025-07-04 LC 62033.33 ... 0.026223 LC2509 lc
[47 rows x 15 columns]
2025-07-08 16:25:47,481 - future_1d - INFO - save future_spot 2025-07-04 completed
2025-07-08 16:25:52,676 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-07, end_day=2025-07-07) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-07 C 2364.29 ... -0.011543 c2509 c
1 2025-07-07 A 4295.0 ... -0.047497 a2509 a
2 2025-07-07 M 2898.0 ... 0.017253 m2509 m
3 2025-07-07 Y 8154.0 ... -0.031641 y2509 y
4 2025-07-07 P 8668.0 ... -0.025611 p2509 p
5 2025-07-07 JD 2775.0 ... 0.300541 jd2509 jd
6 2025-07-07 L 7433.33 ... -0.024663 l2509 l
7 2025-07-07 V 4651.0 ... 0.051602 v2509 v
8 2025-07-07 PP 7390.0 ... -0.04479 pp2509 pp
9 2025-07-07 JM 1236.25 ... -0.323357 jm2509 jm
10 2025-07-07 I 737.33 ... -0.007229 i2509 i
11 2025-07-07 EG 4405.0 ... -0.027923 eg2509 eg
12 2025-07-07 EB 7914.0 ... -0.070761 eb2508 eb
13 2025-07-07 PG 4935.0 ... -0.153191 pg2508 pg
14 2025-07-07 LH 15000.0 ... -0.049667 lh2509 lh
15 2025-07-07 CF 15202.17 ... -0.092564 CF509 CF
16 2025-07-07 SR 6043.33 ... -0.047214 SR509 SR
17 2025-07-07 TA 4977.5 ... -0.054947 TA509 TA
18 2025-07-07 FG 1122.4 ... -0.086778 FG509 FG
19 2025-07-07 RM 2525.0 ... 0.029703 RM509 RM
20 2025-07-07 SF 5138.57 ... 0.045816 SF509 SF
21 2025-07-07 SM 5556.0 ... 0.016559 SM509 SM
22 2025-07-07 CY 23200.0 ... -0.137069 CY509 CY
23 2025-07-07 UR 1831.0 ... -0.046423 UR509 UR
24 2025-07-07 SA 1252.5 ... -0.06507 SA509 SA
25 2025-07-07 PF 6712.92 ... -0.027249 PF508 PF
26 2025-07-07 PX 7250.0 ... -0.079448 PX509 PX
27 2025-07-07 SH 831.0 ... 1.88207 SH509 SH
28 2025-07-07 CU 79921.67 ... -0.005151 cu2508 cu
29 2025-07-07 AL 20780.0 ... -0.013474 al2508 al
30 2025-07-07 ZN 22242.0 ... -0.002563 zn2508 zn
31 2025-07-07 PB 17050.0 ... 0.009384 pb2508 pb
32 2025-07-07 NI 122383.33 ... -0.009832 ni2508 ni
33 2025-07-07 SN 266850.0 ... -0.004384 sn2508 sn
34 2025-07-07 AU 767.46 ... 0.007114 au2510 au
35 2025-07-07 AG 8907.0 ... 0.002919 ag2510 ag
36 2025-07-07 RB 3104.0 ... -0.01192 rb2510 rb
37 2025-07-07 WR 3302.5 ... 0.000757 wr2510 wr
38 2025-07-07 HC 3276.67 ... -0.025535 hc2510 hc
39 2025-07-07 FU 5425.0 ... -0.458065 fu2509 fu
40 2025-07-07 BU 3690.0 ... -0.034688 bu2509 bu
41 2025-07-07 RU 13878.33 ... 0.004083 ru2509 ru
42 2025-07-07 SP 5950.0 ... -0.146218 sp2509 sp
43 2025-07-07 SS 12887.5 ... -0.017653 ss2508 ss
44 2025-07-07 BR 11690.0 ... -0.062019 br2509 br
45 2025-07-07 SI 8910.0 ... -0.103255 SI2509 si
46 2025-07-07 LC 62100.0 ... 0.021578 LC2509 lc
[47 rows x 15 columns]
2025-07-08 16:25:52,851 - future_1d - INFO - save future_spot 2025-07-07 add
2025-07-08 16:25:52,855 - future_1d - INFO - 23
date 2025-07-07
variety UR
spot_price 1831.0
near_contract UR507
near_contract_price 1734.0
dominant_contract UR509
dominant_contract_price 1746.0
near_month 2507
dominant_month 2509
near_basis -97.0
dom_basis -85.0
near_basis_rate -0.053
dom_basis_rate -0.0464
symbol UR509
comd UR
created_at 2025-07-08 16:25:52.816519
updated_at 2025-07-08 16:25:52.816961
2025-07-08 16:26:01,054 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-08, end_day=2025-07-08) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-08 C 2360.0 ... -0.016949 c2509 c
1 2025-07-08 A 4295.0 ... -0.04773 a2509 a
2 2025-07-08 M 2880.0 ... 0.020139 m2509 m
3 2025-07-08 Y 8194.0 ... -0.034904 y2509 y
4 2025-07-08 P 8668.0 ... -0.013152 p2509 p
5 2025-07-08 JD 2750.0 ... 0.300727 jd2509 jd
6 2025-07-08 L 7416.67 ... -0.022472 l2509 l
7 2025-07-08 V 4648.0 ... 0.051205 v2509 v
8 2025-07-08 PP 7376.67 ... -0.043742 pp2509 pp
9 2025-07-08 JM 1236.25 ... -0.32093 jm2509 jm
10 2025-07-08 I 734.67 ... -0.004315 i2509 i
11 2025-07-08 EG 4400.0 ... -0.028864 eg2509 eg
12 2025-07-08 EB 7914.0 ... -0.073288 eb2508 eb
13 2025-07-08 PG 4885.0 ... -0.143501 pg2508 pg
14 2025-07-08 LH 14980.0 ... -0.047397 lh2509 lh
15 2025-07-08 CF 15202.17 ... -0.094866 CF509 CF
16 2025-07-08 SR 6040.0 ... -0.049007 SR509 SR
17 2025-07-08 TA 4930.84 ... -0.044788 TA509 TA
18 2025-07-08 FG 1122.4 ... -0.087669 FG509 FG
19 2025-07-08 RM 2505.0 ... 0.030339 RM509 RM
20 2025-07-08 SF 5138.57 ... 0.041535 SF509 SF
21 2025-07-08 SM 5536.0 ... 0.01987 SM509 SM
22 2025-07-08 CY 23200.0 ... -0.140086 CY509 CY
23 2025-07-08 UR 1831.0 ... -0.041507 UR509 UR
24 2025-07-08 SA 1252.5 ... -0.060279 SA509 SA
25 2025-07-08 PF 6704.58 ... -0.045727 PF509 PF
26 2025-07-08 PX 7250.0 ... -0.076414 PX509 PX
27 2025-07-08 SH 831.0 ... 1.909747 SH509 SH
28 2025-07-08 CU 79826.67 ... -0.004343 cu2508 cu
29 2025-07-08 AL 20653.33 ... -0.007666 al2508 al
30 2025-07-08 ZN 22056.0 ... -0.002312 zn2508 zn
31 2025-07-08 PB 16987.5 ... 0.007506 pb2508 pb
32 2025-07-08 NI 122383.33 ... -0.014653 ni2508 ni
33 2025-07-08 SN 265387.5 ... -0.004324 sn2508 sn
34 2025-07-08 AU 767.46 ... 0.009225 au2510 au
35 2025-07-08 AG 8912.0 ... 0.000561 ag2510 ag
36 2025-07-08 RB 3106.5 ... -0.014647 rb2510 rb
37 2025-07-08 WR 3302.5 ... 0.00106 wr2510 wr
38 2025-07-08 HC 3276.67 ... -0.027366 hc2510 hc
39 2025-07-08 FU 5425.0 ... -0.453088 fu2509 fu
40 2025-07-08 BU 3690.0 ... -0.026558 bu2509 bu
41 2025-07-08 RU 13858.33 ... 0.009501 ru2509 ru
42 2025-07-08 SP 5916.67 ... -0.142761 sp2509 sp
43 2025-07-08 SS 12887.5 ... -0.012609 ss2508 ss
44 2025-07-08 BR 11690.0 ... -0.047904 br2509 br
45 2025-07-08 SI 8910.0 ... -0.080247 SI2509 si
46 2025-07-08 LC 62600.0 ... 0.027157 LC2509 lc
[47 rows x 15 columns]
2025-07-08 16:26:01,224 - future_1d - INFO - save future_spot 2025-07-08 add
2025-07-08 16:26:01,232 - future_1d - INFO - 0 ... 4
date 2025-07-08 ... 2025-07-08
variety C ... P
spot_price 2360.0 ... 8668.0
near_contract c2507 ... p2507
near_contract_price 2316.0 ... 8468.0
dominant_contract c2509 ... p2509
dominant_contract_price 2320.0 ... 8554.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis -44.0 ... -200.0
dom_basis -40.0 ... -114.0
near_basis_rate -0.0186 ... -0.0231
dom_basis_rate -0.0169 ... -0.0132
symbol c2509 ... p2509
comd c ... p
created_at 2025-07-08 16:26:01.185553 ... 2025-07-08 16:26:01.185553
updated_at 2025-07-08 16:26:01.185955 ... 2025-07-08 16:26:01.185955
[17 rows x 5 columns]
=========================================================================
2025-07-08 18:25:42 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-07-08 18:25:44,095 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-08 18:25:44,501 - 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-08 18:25:44,672 - future_1d - INFO - save future_spot 2025-07-02 completed
2025-07-08 18:25:53,608 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-03, end_day=2025-07-03) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-03 C 2367.14 ... -0.001326 c2509 c
1 2025-07-03 A 4295.0 ... -0.034226 a2509 a
2 2025-07-03 M 2930.0 ... 0.010239 m2509 m
3 2025-07-03 Y 8264.0 ... -0.029526 y2509 y
4 2025-07-03 P 8744.0 ... -0.030421 p2509 p
5 2025-07-03 JD 2790.0 ... 0.275269 jd2508 jd
6 2025-07-03 L 7441.67 ... -0.019978 l2509 l
7 2025-07-03 V 4693.0 ... 0.0456 v2509 v
8 2025-07-03 PP 7406.67 ... -0.043565 pp2509 pp
9 2025-07-03 JM 1236.25 ... -0.31365 jm2509 jm
10 2025-07-03 I 730.67 ... -0.003654 i2509 i
11 2025-07-03 EG 4400.0 ... -0.023864 eg2509 eg
12 2025-07-03 EB 7904.0 ... -0.077935 eb2508 eb
13 2025-07-03 PG 4947.5 ... -0.147246 pg2508 pg
14 2025-07-03 LH 14920.0 ... -0.04055 lh2509 lh
15 2025-07-03 CF 15199.83 ... -0.092753 CF509 CF
16 2025-07-03 SR 6050.0 ... -0.047438 SR509 SR
17 2025-07-03 TA 5031.25 ... -0.053516 TA509 TA
18 2025-07-03 FG 1116.0 ... -0.066308 FG509 FG
19 2025-07-03 RM 2530.0 ... 0.028063 RM509 RM
20 2025-07-03 SF 5122.86 ... 0.054099 SF509 SF
21 2025-07-03 SM 5576.0 ... 0.023314 SM509 SM
22 2025-07-03 CY 23200.0 ... -0.135345 CY509 CY
23 2025-07-03 UR 1829.0 ... -0.052488 UR509 UR
24 2025-07-03 SA 1252.5 ... -0.051497 SA509 SA
25 2025-07-03 PF 6748.54 ... -0.0229 PF508 PF
26 2025-07-03 PX 7250.0 ... -0.069241 PX509 PX
27 2025-07-03 SH 827.0 ... 1.88029 SH509 SH
28 2025-07-03 CU 81021.67 ... -0.00323 cu2508 cu
29 2025-07-03 AL 20870.0 ... -0.008864 al2508 al
30 2025-07-03 ZN 22400.0 ... -0.002902 zn2508 zn
31 2025-07-03 PB 17100.0 ... 0.009357 pb2508 pb
32 2025-07-03 NI 122933.33 ... -0.011741 ni2508 ni
33 2025-07-03 SN 268700.0 ... 0.001154 sn2508 sn
34 2025-07-03 AU 775.32 ... 0.004463 au2510 au
35 2025-07-03 AG 8818.33 ... 0.008468 ag2510 ag
36 2025-07-03 RB 3104.0 ... -0.012564 rb2510 rb
37 2025-07-03 WR 3292.5 ... 0.010782 wr2510 wr
38 2025-07-03 HC 3233.33 ... -0.012473 hc2510 hc
39 2025-07-03 FU 5450.0 ... -0.452844 fu2509 fu
40 2025-07-03 BU 3683.33 ... -0.028053 bu2509 bu
41 2025-07-03 RU 13858.33 ... 0.014191 ru2509 ru
42 2025-07-03 SP 5950.0 ... -0.14521 sp2509 sp
43 2025-07-03 SS 12825.0 ... -0.011306 ss2508 ss
44 2025-07-03 BR 11730.0 ... -0.039216 br2508 br
45 2025-07-03 SI 8890.0 ... -0.096175 SI2509 si
46 2025-07-03 LC 61966.67 ... 0.02894 LC2509 lc
[47 rows x 15 columns]
2025-07-08 18:25:53,765 - future_1d - INFO - save future_spot 2025-07-03 completed
2025-07-08 18:25:58,968 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-04, end_day=2025-07-04) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-04 C 2367.14 ... -0.003861 c2509 c
1 2025-07-04 A 4295.0 ... -0.037718 a2509 a
2 2025-07-04 M 2928.0 ... 0.011612 m2509 m
3 2025-07-04 Y 8214.0 ... -0.029949 y2509 y
4 2025-07-04 P 8710.0 ... -0.025029 p2509 p
5 2025-07-04 JD 2790.0 ... 0.32509 jd2509 jd
6 2025-07-04 L 7445.0 ... -0.018402 l2509 l
7 2025-07-04 V 4678.0 ... 0.051518 v2509 v
8 2025-07-04 PP 7406.67 ... -0.04262 pp2509 pp
9 2025-07-04 JM 1236.25 ... -0.312437 jm2509 jm
10 2025-07-04 I 741.78 ... -0.007792 i2509 i
11 2025-07-04 EG 4405.0 ... -0.025426 eg2509 eg
12 2025-07-04 EB 7904.0 ... -0.069205 eb2508 eb
13 2025-07-04 PG 4972.5 ... -0.152338 pg2508 pg
14 2025-07-04 LH 15020.0 ... -0.045273 lh2509 lh
15 2025-07-04 CF 15198.33 ... -0.092663 CF509 CF
16 2025-07-04 SR 6053.33 ... -0.043502 SR509 SR
17 2025-07-04 TA 5031.25 ... -0.058286 TA509 TA
18 2025-07-04 FG 1122.4 ... -0.081433 FG509 FG
19 2025-07-04 RM 2535.0 ... 0.028402 RM509 RM
20 2025-07-04 SF 5152.86 ... 0.048738 SF509 SF
21 2025-07-04 SM 5576.0 ... 0.020445 SM509 SM
22 2025-07-04 CY 23200.0 ... -0.136638 CY509 CY
23 2025-07-04 UR 1829.0 ... -0.041006 UR509 UR
24 2025-07-04 SA 1252.5 ... -0.054691 SA509 SA
25 2025-07-04 PF 6739.58 ... -0.028129 PF508 PF
26 2025-07-04 PX 7250.0 ... -0.072276 PX509 PX
27 2025-07-04 SH 827.0 ... 1.882709 SH509 SH
28 2025-07-04 CU 80533.33 ... -0.004512 cu2508 cu
29 2025-07-04 AL 20780.0 ... -0.006737 al2508 al
30 2025-07-04 ZN 22394.0 ... -0.001965 zn2508 zn
31 2025-07-04 PB 17112.5 ... 0.009204 pb2508 pb
32 2025-07-04 NI 123783.33 ... -0.010529 ni2508 ni
33 2025-07-04 SN 267600.0 ... 0.005157 sn2508 sn
34 2025-07-04 AU 771.61 ... 0.005067 au2510 au
35 2025-07-04 AG 8902.0 ... 0.004718 ag2510 ag
36 2025-07-04 RB 3113.0 ... -0.009958 rb2510 rb
37 2025-07-04 WR 3312.5 ... 0.009208 wr2510 wr
38 2025-07-04 HC 3273.33 ... -0.019042 hc2510 hc
39 2025-07-04 FU 5425.0 ... -0.451244 fu2509 fu
40 2025-07-04 BU 3713.33 ... -0.033751 bu2509 bu
41 2025-07-04 RU 13958.33 ... 0.008358 ru2509 ru
42 2025-07-04 SP 5950.0 ... -0.146218 sp2509 sp
43 2025-07-04 SS 12887.5 ... -0.009893 ss2508 ss
44 2025-07-04 BR 11730.0 ... -0.046462 br2509 br
45 2025-07-04 SI 8890.0 ... -0.101237 SI2509 si
46 2025-07-04 LC 62033.33 ... 0.026223 LC2509 lc
[47 rows x 15 columns]
2025-07-08 18:25:59,121 - future_1d - INFO - save future_spot 2025-07-04 completed
2025-07-08 18:26:08,267 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-07, end_day=2025-07-07) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-07 C 2364.29 ... -0.011543 c2509 c
1 2025-07-07 A 4295.0 ... -0.047497 a2509 a
2 2025-07-07 M 2898.0 ... 0.017253 m2509 m
3 2025-07-07 Y 8154.0 ... -0.031641 y2509 y
4 2025-07-07 P 8668.0 ... -0.025611 p2509 p
5 2025-07-07 JD 2775.0 ... 0.300541 jd2509 jd
6 2025-07-07 L 7433.33 ... -0.024663 l2509 l
7 2025-07-07 V 4651.0 ... 0.051602 v2509 v
8 2025-07-07 PP 7390.0 ... -0.04479 pp2509 pp
9 2025-07-07 JM 1236.25 ... -0.323357 jm2509 jm
10 2025-07-07 I 737.33 ... -0.007229 i2509 i
11 2025-07-07 EG 4405.0 ... -0.027923 eg2509 eg
12 2025-07-07 EB 7914.0 ... -0.070761 eb2508 eb
13 2025-07-07 PG 4935.0 ... -0.153191 pg2508 pg
14 2025-07-07 LH 15000.0 ... -0.049667 lh2509 lh
15 2025-07-07 CF 15202.17 ... -0.092564 CF509 CF
16 2025-07-07 SR 6043.33 ... -0.047214 SR509 SR
17 2025-07-07 TA 4977.5 ... -0.054947 TA509 TA
18 2025-07-07 FG 1122.4 ... -0.086778 FG509 FG
19 2025-07-07 RM 2525.0 ... 0.029703 RM509 RM
20 2025-07-07 SF 5138.57 ... 0.045816 SF509 SF
21 2025-07-07 SM 5556.0 ... 0.016559 SM509 SM
22 2025-07-07 CY 23200.0 ... -0.137069 CY509 CY
23 2025-07-07 UR 1831.0 ... -0.046423 UR509 UR
24 2025-07-07 SA 1252.5 ... -0.06507 SA509 SA
25 2025-07-07 PF 6712.92 ... -0.027249 PF508 PF
26 2025-07-07 PX 7250.0 ... -0.079448 PX509 PX
27 2025-07-07 SH 831.0 ... 1.88207 SH509 SH
28 2025-07-07 CU 79921.67 ... -0.005151 cu2508 cu
29 2025-07-07 AL 20780.0 ... -0.013474 al2508 al
30 2025-07-07 ZN 22242.0 ... -0.002563 zn2508 zn
31 2025-07-07 PB 17050.0 ... 0.009384 pb2508 pb
32 2025-07-07 NI 122383.33 ... -0.009832 ni2508 ni
33 2025-07-07 SN 266850.0 ... -0.004384 sn2508 sn
34 2025-07-07 AU 767.46 ... 0.007114 au2510 au
35 2025-07-07 AG 8907.0 ... 0.002919 ag2510 ag
36 2025-07-07 RB 3104.0 ... -0.01192 rb2510 rb
37 2025-07-07 WR 3302.5 ... 0.000757 wr2510 wr
38 2025-07-07 HC 3276.67 ... -0.025535 hc2510 hc
39 2025-07-07 FU 5425.0 ... -0.458065 fu2509 fu
40 2025-07-07 BU 3690.0 ... -0.034688 bu2509 bu
41 2025-07-07 RU 13878.33 ... 0.004083 ru2509 ru
42 2025-07-07 SP 5950.0 ... -0.146218 sp2509 sp
43 2025-07-07 SS 12887.5 ... -0.017653 ss2508 ss
44 2025-07-07 BR 11690.0 ... -0.062019 br2509 br
45 2025-07-07 SI 8910.0 ... -0.103255 SI2509 si
46 2025-07-07 LC 62100.0 ... 0.021578 LC2509 lc
[47 rows x 15 columns]
2025-07-08 18:26:08,426 - future_1d - INFO - save future_spot 2025-07-07 completed
2025-07-08 18:26:14,283 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-08, end_day=2025-07-08) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-08 C 2360.0 ... -0.016949 c2509 c
1 2025-07-08 A 4295.0 ... -0.04773 a2509 a
2 2025-07-08 M 2880.0 ... 0.020139 m2509 m
3 2025-07-08 Y 8194.0 ... -0.034904 y2509 y
4 2025-07-08 P 8828.0 ... -0.031038 p2509 p
5 2025-07-08 JD 2750.0 ... 0.300727 jd2509 jd
6 2025-07-08 L 7416.67 ... -0.022472 l2509 l
7 2025-07-08 V 4648.0 ... 0.051205 v2509 v
8 2025-07-08 PP 7376.67 ... -0.043742 pp2509 pp
9 2025-07-08 JM 1236.25 ... -0.32093 jm2509 jm
10 2025-07-08 I 734.67 ... -0.004315 i2509 i
11 2025-07-08 EG 4395.0 ... -0.027759 eg2509 eg
12 2025-07-08 EB 7914.0 ... -0.073288 eb2508 eb
13 2025-07-08 PG 4885.0 ... -0.143501 pg2508 pg
14 2025-07-08 LH 14980.0 ... -0.047397 lh2509 lh
15 2025-07-08 CF 15202.17 ... -0.094866 CF509 CF
16 2025-07-08 SR 6040.0 ... -0.049007 SR509 SR
17 2025-07-08 TA 4930.84 ... -0.044788 TA509 TA
18 2025-07-08 FG 1122.4 ... -0.087669 FG509 FG
19 2025-07-08 RM 2505.0 ... 0.030339 RM509 RM
20 2025-07-08 SF 5138.57 ... 0.041535 SF509 SF
21 2025-07-08 SM 5536.0 ... 0.01987 SM509 SM
22 2025-07-08 CY 23200.0 ... -0.140086 CY509 CY
23 2025-07-08 UR 1831.0 ... -0.041507 UR509 UR
24 2025-07-08 SA 1252.5 ... -0.060279 SA509 SA
25 2025-07-08 PF 6704.58 ... -0.045727 PF509 PF
26 2025-07-08 PX 7250.0 ... -0.076414 PX509 PX
27 2025-07-08 SH 831.0 ... 1.909747 SH509 SH
28 2025-07-08 CU 79826.67 ... -0.004343 cu2508 cu
29 2025-07-08 AL 20613.33 ... -0.00574 al2508 al
30 2025-07-08 ZN 22010.0 ... -0.000227 zn2508 zn
31 2025-07-08 PB 16968.75 ... 0.008619 pb2508 pb
32 2025-07-08 NI 121450.0 ... -0.007081 ni2508 ni
33 2025-07-08 SN 264862.5 ... -0.00235 sn2508 sn
34 2025-07-08 AU 772.12 ... 0.003134 au2510 au
35 2025-07-08 AG 8896.67 ... 0.002285 ag2510 ag
36 2025-07-08 RB 3106.5 ... -0.014647 rb2510 rb
37 2025-07-08 WR 3302.5 ... 0.00106 wr2510 wr
38 2025-07-08 HC 3276.67 ... -0.027366 hc2510 hc
39 2025-07-08 FU 5425.0 ... -0.453088 fu2509 fu
40 2025-07-08 BU 3690.0 ... -0.026558 bu2509 bu
41 2025-07-08 RU 13858.33 ... 0.009501 ru2509 ru
42 2025-07-08 SP 5916.67 ... -0.142761 sp2509 sp
43 2025-07-08 SS 12887.5 ... -0.012609 ss2508 ss
44 2025-07-08 BR 11690.0 ... -0.047904 br2509 br
45 2025-07-08 SI 8910.0 ... -0.080247 SI2509 si
46 2025-07-08 LC 62600.0 ... 0.027157 LC2509 lc
[47 rows x 15 columns]
2025-07-08 18:26:14,455 - future_1d - INFO - save future_spot 2025-07-08 add
2025-07-08 18:26:14,462 - future_1d - INFO - 4 ... 31
date 2025-07-08 ... 2025-07-08
variety P ... PB
spot_price 8828.0 ... 16968.75
near_contract p2507 ... pb2507
near_contract_price 8468.0 ... 17065.0
dominant_contract p2509 ... pb2508
dominant_contract_price 8554.0 ... 17115.0
near_month 2507 ... 2507
dominant_month 2509 ... 2508
near_basis -360.0 ... 96.25
dom_basis -274.0 ... 146.25
near_basis_rate -0.0408 ... 0.0057
dom_basis_rate -0.031 ... 0.0086
symbol p2509 ... pb2508
comd p ... pb
created_at 2025-07-08 18:26:14.420121 ... 2025-07-08 18:26:14.420121
updated_at 2025-07-08 18:26:14.420487 ... 2025-07-08 18:26:14.420487
[17 rows x 5 columns]