=========================================================================
2025-05-27 16:25:31 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-05-27 16:25:32,812 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-27 16:25:33,119 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-21, end_day=2025-05-21) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-21 C 2298.57 ... 0.008018 c2507 c
1 2025-05-21 A 4255.0 ... -0.011516 a2507 a
2 2025-05-21 M 2986.0 ... -0.026122 m2509 m
3 2025-05-21 Y 8074.0 ... -0.03245 y2509 y
4 2025-05-21 P 8584.0 ... -0.055918 p2509 p
5 2025-05-21 JD 3190.0 ... -0.073981 jd2507 jd
6 2025-05-21 L 7583.33 ... -0.046329 l2509 l
7 2025-05-21 V 4721.0 ... 0.048507 v2509 v
8 2025-05-21 PP 7440.0 ... -0.052151 pp2509 pp
9 2025-05-21 I 781.0 ... -0.070423 i2509 i
10 2025-05-21 EG 4543.33 ... -0.027145 eg2509 eg
11 2025-05-21 EB 8130.0 ... -0.088561 eb2507 eb
12 2025-05-21 PG 4715.0 ... -0.115164 pg2507 pg
13 2025-05-21 LH 14570.0 ... -0.063143 lh2509 lh
14 2025-05-21 CF 14550.83 ... -0.073592 CF509 CF
15 2025-05-21 SR 6145.0 ... -0.047844 SR509 SR
16 2025-05-21 TA 4986.25 ... -0.043369 TA509 TA
17 2025-05-21 OI 9541.67 ... -0.013275 OI509 OI
18 2025-05-21 MA 2321.25 ... -0.023802 MA509 MA
19 2025-05-21 FG 1148.0 ... -0.106272 FG509 FG
20 2025-05-21 RM 2485.0 ... 0.016901 RM509 RM
21 2025-05-21 SF 5435.71 ... 0.0328 SF507 SF
22 2025-05-21 SM 5636.0 ... 0.02484 SM509 SM
23 2025-05-21 CY 23775.0 ... -0.168875 CY507 CY
24 2025-05-21 UR 1926.0 ... -0.035306 UR509 UR
25 2025-05-21 SA 1462.5 ... -0.12547 SA509 SA
26 2025-05-21 PF 6660.0 ... -0.01982 PF507 PF
27 2025-05-21 PX 6850.0 ... -0.016642 PX509 PX
28 2025-05-21 SH 867.0 ... 1.916955 SH509 SH
29 2025-05-21 CU 78493.33 ... -0.005138 cu2506 cu
30 2025-05-21 AL 20326.67 ... -0.007708 al2507 al
31 2025-05-21 ZN 22744.0 ... -0.015784 zn2507 zn
32 2025-05-21 PB 16831.25 ... 0.003491 pb2507 pb
33 2025-05-21 NI 124658.33 ... -0.008971 ni2507 ni
34 2025-05-21 SN 268212.5 ... -0.004148 sn2506 sn
35 2025-05-21 AU 767.09 ... 0.004654 au2508 au
36 2025-05-21 AG 8204.33 ... 0.001179 ag2508 ag
37 2025-05-21 RB 3154.44 ... -0.029305 rb2510 rb
38 2025-05-21 WR 3327.5 ... 0.004057 wr2510 wr
39 2025-05-21 HC 3286.67 ... -0.02424 hc2510 hc
40 2025-05-21 FU 5437.5 ... -0.43577 fu2507 fu
41 2025-05-21 BU 3582.5 ... -0.016609 bu2507 bu
42 2025-05-21 RU 14558.33 ... 0.020378 ru2509 ru
43 2025-05-21 SP 6300.0 ... -0.135556 sp2507 sp
44 2025-05-21 SS 13237.5 ... -0.027384 ss2507 ss
45 2025-05-21 BR 12560.0 ... -0.039013 br2507 br
46 2025-05-21 SI 9210.0 ... -0.136265 SI2509 si
47 2025-05-21 LC 63266.67 ... -0.033931 LC2507 lc
[48 rows x 15 columns]
2025-05-27 16:25:33,301 - future_1d - INFO - save future_spot 2025-05-21 completed
2025-05-27 16:25:42,933 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-22, end_day=2025-05-22) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-22 C 2295.71 ... 0.012759 c2507 c
1 2025-05-22 A 4255.0 ... -0.011986 a2507 a
2 2025-05-22 M 2998.0 ... -0.022015 m2509 m
3 2025-05-22 Y 8034.0 ... -0.034105 y2509 y
4 2025-05-22 P 8546.0 ... -0.060145 p2509 p
5 2025-05-22 JD 3160.0 ... -0.064873 jd2507 jd
6 2025-05-22 L 7575.0 ... -0.051089 l2509 l
7 2025-05-22 V 4701.0 ... 0.052329 v2509 v
8 2025-05-22 PP 7440.0 ... -0.055914 pp2509 pp
9 2025-05-22 I 782.56 ... -0.070998 i2509 i
10 2025-05-22 EG 4543.33 ... -0.029566 eg2509 eg
11 2025-05-22 EB 8130.0 ... -0.094219 eb2507 eb
12 2025-05-22 PG 4742.5 ... -0.124934 pg2507 pg
13 2025-05-22 LH 14570.0 ... -0.067948 lh2509 lh
14 2025-05-22 CF 14614.33 ... -0.080355 CF509 CF
15 2025-05-22 SR 6145.0 ... -0.044752 SR509 SR
16 2025-05-22 TA 4913.34 ... -0.036501 TA509 TA
17 2025-05-22 OI 9521.67 ... -0.014039 OI509 OI
18 2025-05-22 MA 2312.5 ... -0.02573 MA509 MA
19 2025-05-22 FG 1152.0 ... -0.114583 FG509 FG
20 2025-05-22 RM 2510.0 ... 0.015936 RM509 RM
21 2025-05-22 SF 5387.14 ... 0.042111 SF507 SF
22 2025-05-22 SM 5652.0 ... 0.049894 SM509 SM
23 2025-05-22 CY 23775.0 ... -0.169506 CY507 CY
24 2025-05-22 UR 1912.0 ... -0.031904 UR509 UR
25 2025-05-22 SA 1462.5 ... -0.121368 SA509 SA
26 2025-05-22 PF 6623.12 ... -0.021005 PF507 PF
27 2025-05-22 PX 6850.0 ... -0.025109 PX509 PX
28 2025-05-22 SH 871.0 ... 1.89093 SH509 SH
29 2025-05-22 CU 78143.33 ... -0.002986 cu2506 cu
30 2025-05-22 AL 20326.67 ... -0.006478 al2507 al
31 2025-05-22 ZN 22634.0 ... -0.016966 zn2507 zn
32 2025-05-22 PB 16731.25 ... 0.002914 pb2507 pb
33 2025-05-22 NI 124633.33 ... -0.008291 ni2507 ni
34 2025-05-22 SN 265400.0 ... 0.001809 sn2506 sn
35 2025-05-22 AU 767.09 ... 0.015943 au2508 au
36 2025-05-22 AG 8204.33 ... 0.01093 ag2508 ag
37 2025-05-22 RB 3146.78 ... -0.027895 rb2510 rb
38 2025-05-22 WR 3327.5 ... 0.003456 wr2510 wr
39 2025-05-22 HC 3283.33 ... -0.02142 hc2510 hc
40 2025-05-22 FU 5437.5 ... -0.441287 fu2507 fu
41 2025-05-22 BU 3570.0 ... -0.011485 bu2507 bu
42 2025-05-22 RU 14578.33 ... 0.021036 ru2509 ru
43 2025-05-22 SP 6300.0 ... -0.143175 sp2507 sp
44 2025-05-22 SS 13237.5 ... -0.027007 ss2507 ss
45 2025-05-22 BR 12500.0 ... -0.0308 br2507 br
46 2025-05-22 SI 9210.0 ... -0.135722 SI2509 si
47 2025-05-22 LC 63133.33 ... -0.018268 LC2507 lc
[48 rows x 15 columns]
2025-05-27 16:25:43,087 - future_1d - INFO - save future_spot 2025-05-22 completed
2025-05-27 16:25:47,697 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-23, end_day=2025-05-23) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-23 C 2295.71 ... 0.01363 c2507 c
1 2025-05-23 A 4255.0 ... -0.014101 a2507 a
2 2025-05-23 M 3024.0 ... -0.024471 m2509 m
3 2025-05-23 Y 8034.0 ... -0.03062 y2509 y
4 2025-05-23 P 8510.0 ... -0.056169 p2509 p
5 2025-05-23 JD 3075.0 ... -0.033171 jd2507 jd
6 2025-05-23 L 7558.33 ... -0.057993 l2509 l
7 2025-05-23 V 4681.0 ... 0.044435 v2509 v
8 2025-05-23 PP 7426.67 ... -0.060548 pp2509 pp
9 2025-05-23 I 777.56 ... -0.070811 i2509 i
10 2025-05-23 EG 4543.33 ... -0.027145 eg2509 eg
11 2025-05-23 EB 8130.0 ... -0.101476 eb2507 eb
12 2025-05-23 PG 4742.5 ... -0.138429 pg2507 pg
13 2025-05-23 LH 14530.0 ... -0.068135 lh2509 lh
14 2025-05-23 CF 14604.0 ... -0.080731 CF509 CF
15 2025-05-23 SR 6145.0 ... -0.050122 SR509 SR
16 2025-05-23 TA 4915.0 ... -0.038454 TA509 TA
17 2025-05-23 OI 9513.33 ... -0.010651 OI509 OI
18 2025-05-23 MA 2300.0 ... -0.025652 MA509 MA
19 2025-05-23 FG 1152.0 ... -0.125868 FG509 FG
20 2025-05-23 RM 2521.67 ... 0.017183 RM509 RM
21 2025-05-23 SF 5387.14 ... 0.033201 SF507 SF
22 2025-05-23 SM 5642.0 ... 0.03793 SM509 SM
23 2025-05-23 CY 23775.0 ... -0.171399 CY507 CY
24 2025-05-23 UR 1912.0 ... -0.039226 UR509 UR
25 2025-05-23 SA 1462.5 ... -0.13094 SA509 SA
26 2025-05-23 PF 6597.08 ... -0.016535 PF507 PF
27 2025-05-23 PX 6850.0 ... -0.026277 PX509 PX
28 2025-05-23 SH 871.0 ... 1.871412 SH509 SH
29 2025-05-23 CU 78110.0 ... -0.003585 cu2506 cu
30 2025-05-23 AL 20390.0 ... -0.011035 al2507 al
31 2025-05-23 ZN 22692.0 ... -0.017275 zn2507 zn
32 2025-05-23 PB 16743.75 ... 0.001866 pb2507 pb
33 2025-05-23 NI 124358.33 ... -0.010681 ni2507 ni
34 2025-05-23 SN 265337.5 ... -0.00244 sn2506 sn
35 2025-05-23 AU 772.67 ... 0.003067 au2508 au
36 2025-05-23 AG 8216.67 ... 0.002839 ag2508 ag
37 2025-05-23 RB 3138.56 ... -0.026624 rb2510 rb
38 2025-05-23 WR 3327.5 ... 0.003456 wr2510 wr
39 2025-05-23 HC 3266.67 ... -0.019491 hc2510 hc
40 2025-05-23 FU 5337.5 ... -0.43719 fu2507 fu
41 2025-05-23 BU 3570.0 ... -0.012885 bu2507 bu
42 2025-05-23 RU 14308.33 ... 0.02947 ru2509 ru
43 2025-05-23 SP 6300.0 ... -0.13619 sp2507 sp
44 2025-05-23 SS 13225.0 ... -0.026087 ss2507 ss
45 2025-05-23 BR 12460.0 ... -0.04374 br2507 br
46 2025-05-23 SI 9180.0 ... -0.132898 SI2509 si
47 2025-05-23 LC 62933.33 ... -0.022458 LC2507 lc
[48 rows x 15 columns]
2025-05-27 16:25:47,851 - future_1d - INFO - save future_spot 2025-05-23 completed
2025-05-27 16:25:53,749 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-26, end_day=2025-05-26) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-26 C 2295.71 ... 0.011887 c2507 c
1 2025-05-26 A 4255.0 ... -0.022562 a2507 a
2 2025-05-26 M 2982.0 ... -0.011737 m2509 m
3 2025-05-26 Y 7964.0 ... -0.030136 y2509 y
4 2025-05-26 P 8468.0 ... -0.057629 p2509 p
5 2025-05-26 JD 3050.0 ... -0.027869 jd2507 jd
6 2025-05-26 L 7496.67 ... -0.055581 l2509 l
7 2025-05-26 V 4673.0 ... 0.042157 v2509 v
8 2025-05-26 PP 7426.67 ... -0.065126 pp2509 pp
9 2025-05-26 I 769.67 ... -0.076227 i2509 i
10 2025-05-26 EG 4548.33 ... -0.030633 eg2509 eg
11 2025-05-26 EB 8110.0 ... -0.106165 eb2507 eb
12 2025-05-26 PG 4730.0 ... -0.140803 pg2507 pg
13 2025-05-26 LH 14520.0 ... -0.063361 lh2509 lh
14 2025-05-26 CF 14605.0 ... -0.083875 CF509 CF
15 2025-05-26 SR 6145.0 ... -0.052075 SR509 SR
16 2025-05-26 TA 4917.5 ... -0.034469 TA509 TA
17 2025-05-26 OI 9493.33 ... -0.010884 OI509 OI
18 2025-05-26 MA 2300.0 ... -0.03 MA509 MA
19 2025-05-26 FG 1152.0 ... -0.115451 FG509 FG
20 2025-05-26 RM 2515.0 ... 0.017893 RM509 RM
21 2025-05-26 SF 5380.0 ... 0.031227 SF507 SF
22 2025-05-26 SM 5614.0 ... 0.012825 SM509 SM
23 2025-05-26 CY 23775.0 ... -0.176025 CY507 CY
24 2025-05-26 UR 1900.0 ... -0.043684 UR509 UR
25 2025-05-26 SA 1462.5 ... -0.138462 SA509 SA
26 2025-05-26 PF 6572.5 ... -0.014682 PF507 PF
27 2025-05-26 PX 6850.0 ... -0.021606 PX509 PX
28 2025-05-26 SH 871.0 ... 1.845006 SH509 SH
29 2025-05-26 CU 78588.33 ... -0.008631 cu2507 cu
30 2025-05-26 AL 20366.67 ... -0.010393 al2507 al
31 2025-05-26 ZN 22556.0 ... -0.016005 zn2507 zn
32 2025-05-26 PB 16768.75 ... 0.004249 pb2507 pb
33 2025-05-26 NI 124200.0 ... -0.009501 ni2507 ni
34 2025-05-26 SN 264400.0 ... 0.000908 sn2507 sn
35 2025-05-26 AU 775.76 ... 0.007451 au2508 au
36 2025-05-26 AG 8242.33 ... 0.003357 ag2508 ag
37 2025-05-26 RB 3115.67 ... -0.031669 rb2510 rb
38 2025-05-26 WR 3295.0 ... -0.016388 wr2510 wr
39 2025-05-26 HC 3256.67 ... -0.031833 hc2510 hc
40 2025-05-26 FU 5325.0 ... -0.436995 fu2507 fu
41 2025-05-26 BU 3570.0 ... -0.015406 bu2507 bu
42 2025-05-26 RU 14158.33 ... 0.01495 ru2509 ru
43 2025-05-26 SP 6300.0 ... -0.139048 sp2507 sp
44 2025-05-26 SS 13225.0 ... -0.026087 ss2507 ss
45 2025-05-26 BR 12230.0 ... -0.053557 br2507 br
46 2025-05-26 SI 9180.0 ... -0.152505 SI2509 si
47 2025-05-26 LC 62533.33 ... -0.034115 LC2507 lc
[48 rows x 15 columns]
2025-05-27 16:25:53,907 - future_1d - INFO - save future_spot 2025-05-26 completed
2025-05-27 16:26:00,233 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-27, end_day=2025-05-27) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-27 C 2294.29 ... 0.01077 c2507 c
1 2025-05-27 A 4255.0 ... -0.028672 a2507 a
2 2025-05-27 M 2962.0 ... -0.00135 m2509 m
3 2025-05-27 Y 7964.0 ... -0.030638 y2509 y
4 2025-05-27 P 8488.0 ... -0.057493 p2509 p
5 2025-05-27 JD 3040.0 ... -0.046382 jd2507 jd
6 2025-05-27 L 7451.67 ... -0.056453 l2509 l
7 2025-05-27 V 4580.0 ... 0.049563 v2509 v
8 2025-05-27 PP 7426.67 ... -0.071859 pp2509 pp
9 2025-05-27 I 757.33 ... -0.07636 i2509 i
10 2025-05-27 EG 4548.33 ... -0.040087 eg2509 eg
11 2025-05-27 EB 8110.0 ... -0.119112 eb2507 eb
12 2025-05-27 PG 4730.0 ... -0.137632 pg2507 pg
13 2025-05-27 LH 14500.0 ... -0.065862 lh2509 lh
14 2025-05-27 CF 14597.17 ... -0.088179 CF509 CF
15 2025-05-27 SR 6145.0 ... -0.051912 SR509 SR
16 2025-05-27 TA 4938.75 ... -0.048342 TA509 TA
17 2025-05-27 OI 9493.33 ... -0.00962 OI509 OI
18 2025-05-27 MA 2253.75 ... -0.024293 MA509 MA
19 2025-05-27 FG 1152.0 ... -0.109375 FG509 FG
20 2025-05-27 RM 2515.0 ... 0.027435 RM509 RM
21 2025-05-27 SF 5380.0 ... 0.016357 SF507 SF
22 2025-05-27 SM 5586.0 ... 0.006087 SM509 SM
23 2025-05-27 CY 23800.0 ... -0.180252 CY507 CY
24 2025-05-27 UR 1886.0 ... -0.033934 UR509 UR
25 2025-05-27 SA 1462.5 ... -0.152137 SA509 SA
26 2025-05-27 PF 6545.21 ... -0.021575 PF507 PF
27 2025-05-27 PX 6850.0 ... -0.031533 PX509 PX
28 2025-05-27 SH 881.0 ... 1.800227 SH509 SH
29 2025-05-27 CU 78556.67 ... -0.007214 cu2507 cu
30 2025-05-27 AL 20366.67 ... -0.015057 al2507 al
31 2025-05-27 ZN 22704.0 ... -0.012949 zn2507 zn
32 2025-05-27 PB 16731.25 ... 0.003511 pb2507 pb
33 2025-05-27 NI 124200.0 ... -0.013527 ni2507 ni
34 2025-05-27 SN 264875.0 ... 0.001831 sn2507 sn
35 2025-05-27 AU 775.76 ... 0.001418 au2508 au
36 2025-05-27 AG 8242.33 ... 0.001537 ag2508 ag
37 2025-05-27 RB 3077.11 ... -0.029284 rb2510 rb
38 2025-05-27 WR 3277.5 ... -0.03341 wr2510 wr
39 2025-05-27 HC 3243.33 ... -0.038951 hc2510 hc
40 2025-05-27 FU 5325.0 ... -0.44 fu2507 fu
41 2025-05-27 BU 3583.33 ... -0.03386 bu2509 bu
42 2025-05-27 RU 14258.33 ... 0.012391 ru2509 ru
43 2025-05-27 SP 6266.67 ... -0.153298 sp2507 sp
44 2025-05-27 SS 13225.0 ... -0.028355 ss2507 ss
45 2025-05-27 BR 12230.0 ... -0.052739 br2507 br
46 2025-05-27 SI 9000.0 ... -0.163333 SI2507 si
47 2025-05-27 LC 62200.0 ... -0.023473 LC2507 lc
[48 rows x 15 columns]
2025-05-27 16:26:00,406 - future_1d - INFO - save future_spot 2025-05-27 add
2025-05-27 16:26:00,417 - future_1d - INFO - 0 ... 4
date 2025-05-27 ... 2025-05-27
variety C ... P
spot_price 2294.29 ... 8488.0
near_contract c2507 ... p2506
near_contract_price 2319.0 ... 8266.0
dominant_contract c2507 ... p2509
dominant_contract_price 2319.0 ... 8000.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 24.71 ... -222.0
dom_basis 24.71 ... -488.0
near_basis_rate 0.0108 ... -0.0262
dom_basis_rate 0.0108 ... -0.0575
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-27 16:26:00.365000 ... 2025-05-27 16:26:00.365000
updated_at 2025-05-27 16:26:00.365381 ... 2025-05-27 16:26:00.365381
[17 rows x 5 columns]
=========================================================================
2025-05-27 18:25:47 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-05-27 18:25:49,219 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-27 18:25:49,534 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-21, end_day=2025-05-21) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-21 C 2298.57 ... 0.008018 c2507 c
1 2025-05-21 A 4255.0 ... -0.011516 a2507 a
2 2025-05-21 M 2986.0 ... -0.026122 m2509 m
3 2025-05-21 Y 8074.0 ... -0.03245 y2509 y
4 2025-05-21 P 8584.0 ... -0.055918 p2509 p
5 2025-05-21 JD 3190.0 ... -0.073981 jd2507 jd
6 2025-05-21 L 7583.33 ... -0.046329 l2509 l
7 2025-05-21 V 4721.0 ... 0.048507 v2509 v
8 2025-05-21 PP 7440.0 ... -0.052151 pp2509 pp
9 2025-05-21 I 781.0 ... -0.070423 i2509 i
10 2025-05-21 EG 4543.33 ... -0.027145 eg2509 eg
11 2025-05-21 EB 8130.0 ... -0.088561 eb2507 eb
12 2025-05-21 PG 4715.0 ... -0.115164 pg2507 pg
13 2025-05-21 LH 14570.0 ... -0.063143 lh2509 lh
14 2025-05-21 CF 14550.83 ... -0.073592 CF509 CF
15 2025-05-21 SR 6145.0 ... -0.047844 SR509 SR
16 2025-05-21 TA 4986.25 ... -0.043369 TA509 TA
17 2025-05-21 OI 9541.67 ... -0.013275 OI509 OI
18 2025-05-21 MA 2321.25 ... -0.023802 MA509 MA
19 2025-05-21 FG 1148.0 ... -0.106272 FG509 FG
20 2025-05-21 RM 2485.0 ... 0.016901 RM509 RM
21 2025-05-21 SF 5435.71 ... 0.0328 SF507 SF
22 2025-05-21 SM 5636.0 ... 0.02484 SM509 SM
23 2025-05-21 CY 23775.0 ... -0.168875 CY507 CY
24 2025-05-21 UR 1926.0 ... -0.035306 UR509 UR
25 2025-05-21 SA 1462.5 ... -0.12547 SA509 SA
26 2025-05-21 PF 6660.0 ... -0.01982 PF507 PF
27 2025-05-21 PX 6850.0 ... -0.016642 PX509 PX
28 2025-05-21 SH 867.0 ... 1.916955 SH509 SH
29 2025-05-21 CU 78493.33 ... -0.005138 cu2506 cu
30 2025-05-21 AL 20326.67 ... -0.007708 al2507 al
31 2025-05-21 ZN 22744.0 ... -0.015784 zn2507 zn
32 2025-05-21 PB 16831.25 ... 0.003491 pb2507 pb
33 2025-05-21 NI 124658.33 ... -0.008971 ni2507 ni
34 2025-05-21 SN 268212.5 ... -0.004148 sn2506 sn
35 2025-05-21 AU 767.09 ... 0.004654 au2508 au
36 2025-05-21 AG 8204.33 ... 0.001179 ag2508 ag
37 2025-05-21 RB 3154.44 ... -0.029305 rb2510 rb
38 2025-05-21 WR 3327.5 ... 0.004057 wr2510 wr
39 2025-05-21 HC 3286.67 ... -0.02424 hc2510 hc
40 2025-05-21 FU 5437.5 ... -0.43577 fu2507 fu
41 2025-05-21 BU 3582.5 ... -0.016609 bu2507 bu
42 2025-05-21 RU 14558.33 ... 0.020378 ru2509 ru
43 2025-05-21 SP 6300.0 ... -0.135556 sp2507 sp
44 2025-05-21 SS 13237.5 ... -0.027384 ss2507 ss
45 2025-05-21 BR 12560.0 ... -0.039013 br2507 br
46 2025-05-21 SI 9210.0 ... -0.136265 SI2509 si
47 2025-05-21 LC 63266.67 ... -0.033931 LC2507 lc
[48 rows x 15 columns]
2025-05-27 18:25:50,027 - future_1d - INFO - save future_spot 2025-05-21 completed
2025-05-27 18:25:55,698 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-22, end_day=2025-05-22) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-22 C 2295.71 ... 0.012759 c2507 c
1 2025-05-22 A 4255.0 ... -0.011986 a2507 a
2 2025-05-22 M 2998.0 ... -0.022015 m2509 m
3 2025-05-22 Y 8034.0 ... -0.034105 y2509 y
4 2025-05-22 P 8546.0 ... -0.060145 p2509 p
5 2025-05-22 JD 3160.0 ... -0.064873 jd2507 jd
6 2025-05-22 L 7575.0 ... -0.051089 l2509 l
7 2025-05-22 V 4701.0 ... 0.052329 v2509 v
8 2025-05-22 PP 7440.0 ... -0.055914 pp2509 pp
9 2025-05-22 I 782.56 ... -0.070998 i2509 i
10 2025-05-22 EG 4543.33 ... -0.029566 eg2509 eg
11 2025-05-22 EB 8130.0 ... -0.094219 eb2507 eb
12 2025-05-22 PG 4742.5 ... -0.124934 pg2507 pg
13 2025-05-22 LH 14570.0 ... -0.067948 lh2509 lh
14 2025-05-22 CF 14614.33 ... -0.080355 CF509 CF
15 2025-05-22 SR 6145.0 ... -0.044752 SR509 SR
16 2025-05-22 TA 4913.34 ... -0.036501 TA509 TA
17 2025-05-22 OI 9521.67 ... -0.014039 OI509 OI
18 2025-05-22 MA 2312.5 ... -0.02573 MA509 MA
19 2025-05-22 FG 1152.0 ... -0.114583 FG509 FG
20 2025-05-22 RM 2510.0 ... 0.015936 RM509 RM
21 2025-05-22 SF 5387.14 ... 0.042111 SF507 SF
22 2025-05-22 SM 5652.0 ... 0.049894 SM509 SM
23 2025-05-22 CY 23775.0 ... -0.169506 CY507 CY
24 2025-05-22 UR 1912.0 ... -0.031904 UR509 UR
25 2025-05-22 SA 1462.5 ... -0.121368 SA509 SA
26 2025-05-22 PF 6623.12 ... -0.021005 PF507 PF
27 2025-05-22 PX 6850.0 ... -0.025109 PX509 PX
28 2025-05-22 SH 871.0 ... 1.89093 SH509 SH
29 2025-05-22 CU 78143.33 ... -0.002986 cu2506 cu
30 2025-05-22 AL 20326.67 ... -0.006478 al2507 al
31 2025-05-22 ZN 22634.0 ... -0.016966 zn2507 zn
32 2025-05-22 PB 16731.25 ... 0.002914 pb2507 pb
33 2025-05-22 NI 124633.33 ... -0.008291 ni2507 ni
34 2025-05-22 SN 265400.0 ... 0.001809 sn2506 sn
35 2025-05-22 AU 767.09 ... 0.015943 au2508 au
36 2025-05-22 AG 8204.33 ... 0.01093 ag2508 ag
37 2025-05-22 RB 3146.78 ... -0.027895 rb2510 rb
38 2025-05-22 WR 3327.5 ... 0.003456 wr2510 wr
39 2025-05-22 HC 3283.33 ... -0.02142 hc2510 hc
40 2025-05-22 FU 5437.5 ... -0.441287 fu2507 fu
41 2025-05-22 BU 3570.0 ... -0.011485 bu2507 bu
42 2025-05-22 RU 14578.33 ... 0.021036 ru2509 ru
43 2025-05-22 SP 6300.0 ... -0.143175 sp2507 sp
44 2025-05-22 SS 13237.5 ... -0.027007 ss2507 ss
45 2025-05-22 BR 12500.0 ... -0.0308 br2507 br
46 2025-05-22 SI 9210.0 ... -0.135722 SI2509 si
47 2025-05-22 LC 63133.33 ... -0.018268 LC2507 lc
[48 rows x 15 columns]
2025-05-27 18:25:55,854 - future_1d - INFO - save future_spot 2025-05-22 completed
2025-05-27 18:25:59,865 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-23, end_day=2025-05-23) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-23 C 2295.71 ... 0.01363 c2507 c
1 2025-05-23 A 4255.0 ... -0.014101 a2507 a
2 2025-05-23 M 3024.0 ... -0.024471 m2509 m
3 2025-05-23 Y 8034.0 ... -0.03062 y2509 y
4 2025-05-23 P 8510.0 ... -0.056169 p2509 p
5 2025-05-23 JD 3075.0 ... -0.033171 jd2507 jd
6 2025-05-23 L 7558.33 ... -0.057993 l2509 l
7 2025-05-23 V 4681.0 ... 0.044435 v2509 v
8 2025-05-23 PP 7426.67 ... -0.060548 pp2509 pp
9 2025-05-23 I 777.56 ... -0.070811 i2509 i
10 2025-05-23 EG 4543.33 ... -0.027145 eg2509 eg
11 2025-05-23 EB 8130.0 ... -0.101476 eb2507 eb
12 2025-05-23 PG 4742.5 ... -0.138429 pg2507 pg
13 2025-05-23 LH 14530.0 ... -0.068135 lh2509 lh
14 2025-05-23 CF 14604.0 ... -0.080731 CF509 CF
15 2025-05-23 SR 6145.0 ... -0.050122 SR509 SR
16 2025-05-23 TA 4915.0 ... -0.038454 TA509 TA
17 2025-05-23 OI 9513.33 ... -0.010651 OI509 OI
18 2025-05-23 MA 2300.0 ... -0.025652 MA509 MA
19 2025-05-23 FG 1152.0 ... -0.125868 FG509 FG
20 2025-05-23 RM 2521.67 ... 0.017183 RM509 RM
21 2025-05-23 SF 5387.14 ... 0.033201 SF507 SF
22 2025-05-23 SM 5642.0 ... 0.03793 SM509 SM
23 2025-05-23 CY 23775.0 ... -0.171399 CY507 CY
24 2025-05-23 UR 1912.0 ... -0.039226 UR509 UR
25 2025-05-23 SA 1462.5 ... -0.13094 SA509 SA
26 2025-05-23 PF 6597.08 ... -0.016535 PF507 PF
27 2025-05-23 PX 6850.0 ... -0.026277 PX509 PX
28 2025-05-23 SH 871.0 ... 1.871412 SH509 SH
29 2025-05-23 CU 78110.0 ... -0.003585 cu2506 cu
30 2025-05-23 AL 20390.0 ... -0.011035 al2507 al
31 2025-05-23 ZN 22692.0 ... -0.017275 zn2507 zn
32 2025-05-23 PB 16743.75 ... 0.001866 pb2507 pb
33 2025-05-23 NI 124358.33 ... -0.010681 ni2507 ni
34 2025-05-23 SN 265337.5 ... -0.00244 sn2506 sn
35 2025-05-23 AU 772.67 ... 0.003067 au2508 au
36 2025-05-23 AG 8216.67 ... 0.002839 ag2508 ag
37 2025-05-23 RB 3138.56 ... -0.026624 rb2510 rb
38 2025-05-23 WR 3327.5 ... 0.003456 wr2510 wr
39 2025-05-23 HC 3266.67 ... -0.019491 hc2510 hc
40 2025-05-23 FU 5337.5 ... -0.43719 fu2507 fu
41 2025-05-23 BU 3570.0 ... -0.012885 bu2507 bu
42 2025-05-23 RU 14308.33 ... 0.02947 ru2509 ru
43 2025-05-23 SP 6300.0 ... -0.13619 sp2507 sp
44 2025-05-23 SS 13225.0 ... -0.026087 ss2507 ss
45 2025-05-23 BR 12460.0 ... -0.04374 br2507 br
46 2025-05-23 SI 9180.0 ... -0.132898 SI2509 si
47 2025-05-23 LC 62933.33 ... -0.022458 LC2507 lc
[48 rows x 15 columns]
2025-05-27 18:26:00,020 - future_1d - INFO - save future_spot 2025-05-23 completed
2025-05-27 18:26:06,242 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-26, end_day=2025-05-26) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-26 C 2295.71 ... 0.011887 c2507 c
1 2025-05-26 A 4255.0 ... -0.022562 a2507 a
2 2025-05-26 M 2982.0 ... -0.011737 m2509 m
3 2025-05-26 Y 7964.0 ... -0.030136 y2509 y
4 2025-05-26 P 8468.0 ... -0.057629 p2509 p
5 2025-05-26 JD 3050.0 ... -0.027869 jd2507 jd
6 2025-05-26 L 7496.67 ... -0.055581 l2509 l
7 2025-05-26 V 4673.0 ... 0.042157 v2509 v
8 2025-05-26 PP 7426.67 ... -0.065126 pp2509 pp
9 2025-05-26 I 769.67 ... -0.076227 i2509 i
10 2025-05-26 EG 4548.33 ... -0.030633 eg2509 eg
11 2025-05-26 EB 8110.0 ... -0.106165 eb2507 eb
12 2025-05-26 PG 4730.0 ... -0.140803 pg2507 pg
13 2025-05-26 LH 14520.0 ... -0.063361 lh2509 lh
14 2025-05-26 CF 14605.0 ... -0.083875 CF509 CF
15 2025-05-26 SR 6145.0 ... -0.052075 SR509 SR
16 2025-05-26 TA 4917.5 ... -0.034469 TA509 TA
17 2025-05-26 OI 9493.33 ... -0.010884 OI509 OI
18 2025-05-26 MA 2300.0 ... -0.03 MA509 MA
19 2025-05-26 FG 1152.0 ... -0.115451 FG509 FG
20 2025-05-26 RM 2515.0 ... 0.017893 RM509 RM
21 2025-05-26 SF 5380.0 ... 0.031227 SF507 SF
22 2025-05-26 SM 5614.0 ... 0.012825 SM509 SM
23 2025-05-26 CY 23775.0 ... -0.176025 CY507 CY
24 2025-05-26 UR 1900.0 ... -0.043684 UR509 UR
25 2025-05-26 SA 1462.5 ... -0.138462 SA509 SA
26 2025-05-26 PF 6572.5 ... -0.014682 PF507 PF
27 2025-05-26 PX 6850.0 ... -0.021606 PX509 PX
28 2025-05-26 SH 871.0 ... 1.845006 SH509 SH
29 2025-05-26 CU 78588.33 ... -0.008631 cu2507 cu
30 2025-05-26 AL 20366.67 ... -0.010393 al2507 al
31 2025-05-26 ZN 22556.0 ... -0.016005 zn2507 zn
32 2025-05-26 PB 16768.75 ... 0.004249 pb2507 pb
33 2025-05-26 NI 124200.0 ... -0.009501 ni2507 ni
34 2025-05-26 SN 264400.0 ... 0.000908 sn2507 sn
35 2025-05-26 AU 775.76 ... 0.007451 au2508 au
36 2025-05-26 AG 8242.33 ... 0.003357 ag2508 ag
37 2025-05-26 RB 3115.67 ... -0.031669 rb2510 rb
38 2025-05-26 WR 3295.0 ... -0.016388 wr2510 wr
39 2025-05-26 HC 3256.67 ... -0.031833 hc2510 hc
40 2025-05-26 FU 5325.0 ... -0.436995 fu2507 fu
41 2025-05-26 BU 3570.0 ... -0.015406 bu2507 bu
42 2025-05-26 RU 14158.33 ... 0.01495 ru2509 ru
43 2025-05-26 SP 6300.0 ... -0.139048 sp2507 sp
44 2025-05-26 SS 13225.0 ... -0.026087 ss2507 ss
45 2025-05-26 BR 12230.0 ... -0.053557 br2507 br
46 2025-05-26 SI 9180.0 ... -0.152505 SI2509 si
47 2025-05-26 LC 62533.33 ... -0.034115 LC2507 lc
[48 rows x 15 columns]
2025-05-27 18:26:06,403 - future_1d - INFO - save future_spot 2025-05-26 completed
2025-05-27 18:26:15,864 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-27, end_day=2025-05-27) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-27 C 2294.29 ... 0.01077 c2507 c
1 2025-05-27 A 4255.0 ... -0.028672 a2507 a
2 2025-05-27 M 2962.0 ... -0.00135 m2509 m
3 2025-05-27 Y 7994.0 ... -0.034276 y2509 y
4 2025-05-27 P 8488.0 ... -0.057493 p2509 p
5 2025-05-27 JD 3040.0 ... -0.046382 jd2507 jd
6 2025-05-27 L 7451.67 ... -0.056453 l2509 l
7 2025-05-27 V 4580.0 ... 0.049563 v2509 v
8 2025-05-27 PP 7426.67 ... -0.071859 pp2509 pp
9 2025-05-27 I 757.33 ... -0.07636 i2509 i
10 2025-05-27 EG 4548.33 ... -0.040087 eg2509 eg
11 2025-05-27 EB 8110.0 ... -0.119112 eb2507 eb
12 2025-05-27 PG 4730.0 ... -0.137632 pg2507 pg
13 2025-05-27 LH 14500.0 ... -0.065862 lh2509 lh
14 2025-05-27 CF 14597.17 ... -0.088179 CF509 CF
15 2025-05-27 SR 6145.0 ... -0.051912 SR509 SR
16 2025-05-27 TA 4938.75 ... -0.048342 TA509 TA
17 2025-05-27 OI 9545.0 ... -0.014982 OI509 OI
18 2025-05-27 MA 2253.75 ... -0.024293 MA509 MA
19 2025-05-27 FG 1152.0 ... -0.109375 FG509 FG
20 2025-05-27 RM 2543.33 ... 0.015991 RM509 RM
21 2025-05-27 SF 5380.0 ... 0.016357 SF507 SF
22 2025-05-27 SM 5586.0 ... 0.006087 SM509 SM
23 2025-05-27 CY 23800.0 ... -0.180252 CY507 CY
24 2025-05-27 UR 1886.0 ... -0.033934 UR509 UR
25 2025-05-27 SA 1450.0 ... -0.144828 SA509 SA
26 2025-05-27 PF 6545.21 ... -0.021575 PF507 PF
27 2025-05-27 PX 6850.0 ... -0.031533 PX509 PX
28 2025-05-27 SH 881.0 ... 1.800227 SH509 SH
29 2025-05-27 CU 78556.67 ... -0.007214 cu2507 cu
30 2025-05-27 AL 20213.33 ... -0.007586 al2507 al
31 2025-05-27 ZN 22736.0 ... -0.014338 zn2507 zn
32 2025-05-27 PB 16718.75 ... 0.004262 pb2507 pb
33 2025-05-27 NI 123400.0 ... -0.007131 ni2507 ni
34 2025-05-27 SN 264975.0 ... 0.001453 sn2507 sn
35 2025-05-27 AU 773.68 ... 0.00411 au2508 au
36 2025-05-27 AG 8239.33 ... 0.001902 ag2508 ag
37 2025-05-27 RB 3077.11 ... -0.029284 rb2510 rb
38 2025-05-27 WR 3277.5 ... -0.03341 wr2510 wr
39 2025-05-27 HC 3243.33 ... -0.038951 hc2510 hc
40 2025-05-27 FU 5325.0 ... -0.44 fu2507 fu
41 2025-05-27 BU 3583.33 ... -0.03386 bu2509 bu
42 2025-05-27 RU 14258.33 ... 0.012391 ru2509 ru
43 2025-05-27 SP 6266.67 ... -0.153298 sp2507 sp
44 2025-05-27 SS 13225.0 ... -0.028355 ss2507 ss
45 2025-05-27 BR 12230.0 ... -0.052739 br2507 br
46 2025-05-27 SI 9000.0 ... -0.163333 SI2507 si
47 2025-05-27 LC 62200.0 ... -0.023473 LC2507 lc
[48 rows x 15 columns]
2025-05-27 18:26:16,046 - future_1d - INFO - save future_spot 2025-05-27 add
2025-05-27 18:26:16,054 - future_1d - INFO - 3 ... 30
date 2025-05-27 ... 2025-05-27
variety Y ... AL
spot_price 7994.0 ... 20213.33
near_contract y2507 ... al2506
near_contract_price 7758.0 ... 20135.0
dominant_contract y2509 ... al2507
dominant_contract_price 7720.0 ... 20060.0
near_month 2507 ... 2506
dominant_month 2509 ... 2507
near_basis -236.0 ... -78.33
dom_basis -274.0 ... -153.33
near_basis_rate -0.0295 ... -0.0039
dom_basis_rate -0.0343 ... -0.0076
symbol y2509 ... al2507
comd y ... al
created_at 2025-05-27 18:26:16.001942 ... 2025-05-27 18:26:16.001942
updated_at 2025-05-27 18:26:16.002318 ... 2025-05-27 18:26:16.002318
[17 rows x 5 columns]