=========================================================================
2025-05-15 16:25:31 Thu START TASK.01 future_1d future_spot
=========================================================================
2025-05-15 16:25:33,551 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-15 16:25:33,867 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-09, end_day=2025-05-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-09 C 2292.86 ... 0.033644 c2507 c
1 2025-05-09 A 4245.0 ... -0.01649 a2507 a
2 2025-05-09 M 3300.0 ... -0.117273 m2509 m
3 2025-05-09 Y 8076.0 ... -0.032689 y2509 y
4 2025-05-09 P 8510.0 ... -0.06698 p2509 p
5 2025-05-09 JD 3225.0 ... -0.058915 jd2507 jd
6 2025-05-09 L 7458.33 ... -0.059575 l2509 l
7 2025-05-09 V 4629.0 ... 0.04191 v2509 v
8 2025-05-09 PP 7440.0 ... -0.059946 pp2509 pp
9 2025-05-09 I 770.89 ... -0.096499 i2509 i
10 2025-05-09 EG 4340.0 ... -0.02788 eg2509 eg
11 2025-05-09 EB 7680.0 ... -0.091276 eb2506 eb
12 2025-05-09 PG 4917.5 ... -0.108287 pg2506 pg
13 2025-05-09 LH 14780.0 ... -0.05954 lh2509 lh
14 2025-05-09 CF 14136.0 ... -0.085668 CF509 CF
15 2025-05-09 SR 6146.67 ... -0.049892 SR509 SR
16 2025-05-09 TA 4750.84 ... -0.038486 TA509 TA
17 2025-05-09 OI 9463.33 ... -0.00796 OI509 OI
18 2025-05-09 MA 2402.5 ... -0.0718 MA509 MA
19 2025-05-09 FG 1210.4 ... -0.134171 FG509 FG
20 2025-05-09 RM 2506.67 ... 0.020078 RM509 RM
21 2025-05-09 SF 5402.86 ... 0.027234 SF507 SF
22 2025-05-09 SM 5634.0 ... 0.022719 SM509 SM
23 2025-05-09 CY 23775.0 ... -0.187802 CY507 CY
24 2025-05-09 UR 1921.67 ... -0.010236 UR509 UR
25 2025-05-09 SA 1462.5 ... -0.100171 SA509 SA
26 2025-05-09 PF 6377.92 ... -0.019116 PF507 PF
27 2025-05-09 PX 6600.0 ... -0.023333 PX509 PX
28 2025-05-09 SH 821.0 ... 2.021924 SH509 SH
29 2025-05-09 CU 78258.33 ... -0.007646 cu2506 cu
30 2025-05-09 AL 19630.0 ... -0.006623 al2507 al
31 2025-05-09 ZN 22756.0 ... -0.022236 zn2506 zn
32 2025-05-09 PB 16718.75 ... 0.004262 pb2506 pb
33 2025-05-09 NI 124758.33 ... -0.008804 ni2506 ni
34 2025-05-09 SN 259500.0 ... 0.005318 sn2506 sn
35 2025-05-09 AU 795.94 ... -0.009775 au2508 au
36 2025-05-09 AG 8188.67 ... -0.002036 ag2508 ag
37 2025-05-09 RB 3141.44 ... -0.033564 rb2510 rb
38 2025-05-09 WR 3367.5 ... 0.004009 wr2510 wr
39 2025-05-09 HC 3273.33 ... -0.030956 hc2510 hc
40 2025-05-09 FU 5470.0 ... -0.465631 fu2507 fu
41 2025-05-09 BU 3585.0 ... -0.049372 bu2507 bu
42 2025-05-09 RU 14408.33 ... 0.02059 ru2509 ru
43 2025-05-09 SP 6200.0 ... -0.164194 sp2507 sp
44 2025-05-09 SS 13042.5 ... -0.021277 ss2507 ss
45 2025-05-09 BR 12010.0 ... -0.040799 br2507 br
46 2025-05-09 SI 9640.0 ... -0.139004 SI2506 si
47 2025-05-09 LC 67133.33 ... -0.051142 LC2507 lc
[48 rows x 15 columns]
2025-05-15 16:25:34,043 - future_1d - INFO - save future_spot 2025-05-09 completed
2025-05-15 16:25:38,402 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-12, end_day=2025-05-12) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-12 C 2298.57 ... 0.029771 c2507 c
1 2025-05-12 A 4255.0 ... -0.023267 a2507 a
2 2025-05-12 M 3138.0 ... -0.078075 m2509 m
3 2025-05-12 Y 8094.0 ... -0.038053 y2509 y
4 2025-05-12 P 8610.0 ... -0.075958 p2509 p
5 2025-05-12 JD 3310.0 ... -0.082779 jd2507 jd
6 2025-05-12 L 7428.33 ... -0.054565 l2509 l
7 2025-05-12 V 4604.0 ... 0.041703 v2509 v
8 2025-05-12 PP 7440.0 ... -0.06129 pp2509 pp
9 2025-05-12 I 777.22 ... -0.090348 i2509 i
10 2025-05-12 EG 4408.33 ... -0.03274 eg2509 eg
11 2025-05-12 EB 7676.0 ... -0.072043 eb2506 eb
12 2025-05-12 PG 4905.0 ... -0.110703 pg2506 pg
13 2025-05-12 LH 14750.0 ... -0.058644 lh2509 lh
14 2025-05-12 CF 14200.83 ... -0.07435 CF509 CF
15 2025-05-12 SR 6150.0 ... -0.045854 SR509 SR
16 2025-05-12 TA 4888.33 ... -0.05121 TA509 TA
17 2025-05-12 OI 9446.67 ... -0.013621 OI509 OI
18 2025-05-12 MA 2402.5 ... -0.065557 MA509 MA
19 2025-05-12 FG 1210.4 ... -0.144085 FG509 FG
20 2025-05-12 RM 2490.0 ... 0.018072 RM509 RM
21 2025-05-12 SF 5424.29 ... 0.044192 SF507 SF
22 2025-05-12 SM 5676.0 ... 0.029951 SM509 SM
23 2025-05-12 CY 23775.0 ... -0.182334 CY507 CY
24 2025-05-12 UR 1945.0 ... -0.027763 UR509 UR
25 2025-05-12 SA 1462.5 ... -0.109744 SA509 SA
26 2025-05-12 PF 6411.79 ... -0.015252 PF507 PF
27 2025-05-12 PX 6600.0 ... -0.011515 PX509 PX
28 2025-05-12 SH 829.0 ... 2.0 SH509 SH
29 2025-05-12 CU 78425.0 ... -0.005037 cu2506 cu
30 2025-05-12 AL 19830.0 ... -0.00706 al2507 al
31 2025-05-12 ZN 22730.0 ... -0.017818 zn2506 zn
32 2025-05-12 PB 16806.25 ... 0.007066 pb2506 pb
33 2025-05-12 NI 126525.0 ... -0.005967 ni2506 ni
34 2025-05-12 SN 262537.5 ... -0.005437 sn2506 sn
35 2025-05-12 AU 769.24 ... 0.014482 au2508 au
36 2025-05-12 AG 8139.33 ... 0.008191 ag2508 ag
37 2025-05-12 RB 3160.33 ... -0.034278 rb2510 rb
38 2025-05-12 WR 3342.5 ... 0.018699 wr2510 wr
39 2025-05-12 HC 3256.67 ... -0.020472 hc2510 hc
40 2025-05-12 FU 5470.0 ... -0.458684 fu2507 fu
41 2025-05-12 BU 3585.0 ... -0.038494 bu2507 bu
42 2025-05-12 RU 14738.33 ... 0.000792 ru2509 ru
43 2025-05-12 SP 6200.0 ... -0.15871 sp2507 sp
44 2025-05-12 SS 13130.0 ... -0.020183 ss2507 ss
45 2025-05-12 BR 12020.0 ... -0.027454 br2507 br
46 2025-05-12 SI 9610.0 ... -0.138398 SI2506 si
47 2025-05-12 LC 66633.33 ... -0.044622 LC2507 lc
[48 rows x 15 columns]
2025-05-15 16:25:38,560 - future_1d - INFO - save future_spot 2025-05-12 completed
2025-05-15 16:25:48,568 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-13, end_day=2025-05-13) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-13 C 2300.0 ... 0.02087 c2507 c
1 2025-05-13 A 4255.0 ... -0.022327 a2507 a
2 2025-05-13 M 3116.0 ... -0.068357 m2509 m
3 2025-05-13 Y 8076.0 ... -0.031204 y2509 y
4 2025-05-13 P 8564.0 ... -0.064689 p2509 p
5 2025-05-13 JD 3365.0 ... -0.098366 jd2507 jd
6 2025-05-13 L 7445.0 ... -0.039758 l2509 l
7 2025-05-13 V 4602.0 ... 0.051717 v2509 v
8 2025-05-13 PP 7440.0 ... -0.051478 pp2509 pp
9 2025-05-13 I 786.22 ... -0.084862 i2509 i
10 2025-05-13 EG 4408.33 ... -0.014139 eg2509 eg
11 2025-05-13 EB 7720.0 ... -0.039896 eb2506 eb
12 2025-05-13 PG 4882.5 ... -0.115617 pg2506 pg
13 2025-05-13 LH 14720.0 ... -0.057745 lh2509 lh
14 2025-05-13 CF 14388.83 ... -0.073934 CF509 CF
15 2025-05-13 SR 6145.0 ... -0.045077 SR509 SR
16 2025-05-13 TA 4913.34 ... -0.035687 TA509 TA
17 2025-05-13 OI 9468.33 ... -0.009223 OI509 OI
18 2025-05-13 MA 2453.75 ... -0.070402 MA509 MA
19 2025-05-13 FG 1196.0 ... -0.137124 FG509 FG
20 2025-05-13 RM 2476.67 ... 0.011439 RM509 RM
21 2025-05-13 SF 5424.29 ... 0.035712 SF507 SF
22 2025-05-13 SM 5686.0 ... 0.024974 SM509 SM
23 2025-05-13 CY 23775.0 ... -0.173081 CY507 CY
24 2025-05-13 UR 1945.0 ... -0.021594 UR509 UR
25 2025-05-13 SA 1462.5 ... -0.104274 SA509 SA
26 2025-05-13 PF 6535.29 ... -0.014275 PF507 PF
27 2025-05-13 PX 6700.0 ... -0.002687 PX509 PX
28 2025-05-13 SH 845.0 ... 1.985799 SH509 SH
29 2025-05-13 CU 78168.33 ... -0.003689 cu2506 cu
30 2025-05-13 AL 20033.33 ... -0.004409 al2507 al
31 2025-05-13 ZN 22662.0 ... -0.01465 zn2506 zn
32 2025-05-13 PB 16850.0 ... 0.005935 pb2506 pb
33 2025-05-13 NI 124916.67 ... -0.005497 ni2506 ni
34 2025-05-13 SN 262125.0 ... 0.004635 sn2506 sn
35 2025-05-13 AU 758.86 ... 0.004849 au2508 au
36 2025-05-13 AG 8133.67 ... 0.005942 ag2508 ag
37 2025-05-13 RB 3164.78 ... -0.023945 rb2510 rb
38 2025-05-13 WR 3370.0 ... 0.018694 wr2510 wr
39 2025-05-13 HC 3296.67 ... -0.021437 hc2510 hc
40 2025-05-13 FU 5482.5 ... -0.448609 fu2507 fu
41 2025-05-13 BU 3595.0 ... -0.03783 bu2507 bu
42 2025-05-13 RU 14748.33 ... 0.016725 ru2509 ru
43 2025-05-13 SP 6250.0 ... -0.14912 sp2507 sp
44 2025-05-13 SS 13130.0 ... -0.015232 ss2507 ss
45 2025-05-13 BR 12280.0 ... -0.012215 br2507 br
46 2025-05-13 SI 9610.0 ... -0.139958 SI2506 si
47 2025-05-13 LC 65633.33 ... -0.035551 LC2507 lc
[48 rows x 15 columns]
2025-05-15 16:25:48,728 - future_1d - INFO - save future_spot 2025-05-13 completed
2025-05-15 16:25:53,420 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-14, end_day=2025-05-14) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-14 C 2304.29 ... 0.019837 c2507 c
1 2025-05-14 A 4255.0 ... -0.021152 a2507 a
2 2025-05-14 M 3084.0 ... -0.060311 m2509 m
3 2025-05-14 Y 8174.0 ... -0.036457 y2509 y
4 2025-05-14 P 8680.0 ... -0.065899 p2509 p
5 2025-05-14 JD 3375.0 ... -0.105481 jd2507 jd
6 2025-05-14 L 7508.33 ... -0.031343 l2509 l
7 2025-05-14 V 4697.0 ... 0.046413 v2509 v
8 2025-05-14 PP 7440.0 ... -0.039247 pp2509 pp
9 2025-05-14 I 793.33 ... -0.082349 i2509 i
10 2025-05-14 EG 4536.67 ... -0.009846 eg2509 eg
11 2025-05-14 EB 7890.0 ... -0.026489 eb2506 eb
12 2025-05-14 PG 4882.5 ... -0.105376 pg2506 pg
13 2025-05-14 LH 14730.0 ... -0.051595 lh2509 lh
14 2025-05-14 CF 14482.83 ... -0.075457 CF509 CF
15 2025-05-14 SR 6145.0 ... -0.039056 SR509 SR
16 2025-05-14 TA 4913.34 ... -0.012484 TA509 TA
17 2025-05-14 OI 9543.33 ... -0.013342 OI509 OI
18 2025-05-14 MA 2521.25 ... -0.074665 MA509 MA
19 2025-05-14 FG 1188.0 ... -0.127104 FG509 FG
20 2025-05-14 RM 2460.0 ... 0.013008 RM509 RM
21 2025-05-14 SF 5424.29 ... 0.044929 SF507 SF
22 2025-05-14 SM 5692.0 ... 0.030569 SM509 SM
23 2025-05-14 CY 23775.0 ... -0.169926 CY507 CY
24 2025-05-14 UR 1945.0 ... -0.035476 UR509 UR
25 2025-05-14 SA 1462.5 ... -0.09812 SA509 SA
26 2025-05-14 PF 6618.33 ... -0.004885 PF507 PF
27 2025-05-14 PX 6700.0 ... 0.024179 PX509 PX
28 2025-05-14 SH 849.0 ... 1.949352 SH509 SH
29 2025-05-14 CU 78801.67 ... -0.003828 cu2506 cu
30 2025-05-14 AL 20226.67 ... -0.005274 al2507 al
31 2025-05-14 ZN 22850.0 ... -0.014442 zn2506 zn
32 2025-05-14 PB 16850.0 ... 0.004154 pb2506 pb
33 2025-05-14 NI 126308.33 ... -0.015109 ni2506 ni
34 2025-05-14 SN 265137.5 ... -0.001914 sn2506 sn
35 2025-05-14 AU 759.42 ... 0.0064 au2508 au
36 2025-05-14 AG 8169.33 ... 0.003754 ag2508 ag
37 2025-05-14 RB 3191.78 ... -0.026875 rb2510 rb
38 2025-05-14 WR 3370.0 ... 0.026706 wr2510 wr
39 2025-05-14 HC 3313.33 ... -0.020623 hc2510 hc
40 2025-05-14 FU 5470.0 ... -0.442779 fu2507 fu
41 2025-05-14 BU 3595.0 ... -0.028095 bu2507 bu
42 2025-05-14 RU 14983.33 ... 0.011457 ru2509 ru
43 2025-05-14 SP 6266.67 ... -0.149149 sp2507 sp
44 2025-05-14 SS 13255.0 ... -0.017352 ss2507 ss
45 2025-05-14 BR 12700.0 ... -0.016535 br2507 br
46 2025-05-14 SI 9610.0 ... -0.119147 SI2509 si
47 2025-05-14 LC 64966.67 ... -0.003489 LC2507 lc
[48 rows x 15 columns]
2025-05-15 16:25:53,577 - future_1d - INFO - save future_spot 2025-05-14 completed
2025-05-15 16:25:59,802 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-15, end_day=2025-05-15) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-15 C 2304.29 ... 0.017667 c2507 c
1 2025-05-15 A 4255.0 ... -0.017391 a2507 a
2 2025-05-15 M 3074.0 ... -0.055628 m2509 m
3 2025-05-15 Y 8054.0 ... -0.026571 y2509 y
4 2025-05-15 P 8680.0 ... -0.066359 p2509 p
5 2025-05-15 JD 3375.0 ... -0.107259 jd2507 jd
6 2025-05-15 L 7558.33 ... -0.031267 l2509 l
7 2025-05-15 V 4756.0 ... 0.055929 v2509 v
8 2025-05-15 PP 7440.0 ... -0.036694 pp2509 pp
9 2025-05-15 I 794.44 ... -0.07482 i2509 i
10 2025-05-15 EG 4536.67 ... -0.013594 eg2509 eg
11 2025-05-15 EB 8270.0 ... -0.060339 eb2506 eb
12 2025-05-15 PG 4847.5 ... -0.112739 pg2506 pg
13 2025-05-15 LH 14680.0 ... -0.056199 lh2509 lh
14 2025-05-15 CF 14512.33 ... -0.074925 CF509 CF
15 2025-05-15 SR 6145.0 ... -0.042636 SR509 SR
16 2025-05-15 TA 4991.66 ... -0.033588 TA509 TA
17 2025-05-15 OI 9395.0 ... -0.004577 OI509 OI
18 2025-05-15 MA 2426.25 ... -0.037197 MA509 MA
19 2025-05-15 FG 1188.0 ... -0.127104 FG509 FG
20 2025-05-15 RM 2476.67 ... 0.015476 RM509 RM
21 2025-05-15 SF 5424.29 ... 0.04198 SF507 SF
22 2025-05-15 SM 5706.0 ... 0.028391 SM509 SM
23 2025-05-15 CY 23775.0 ... -0.169295 CY507 CY
24 2025-05-15 UR 1945.0 ... -0.026221 UR509 UR
25 2025-05-15 SA 1462.5 ... -0.087179 SA509 SA
26 2025-05-15 PF 6688.96 ... -0.012104 PF507 PF
27 2025-05-15 PX 6700.0 ... 0.015821 PX509 PX
28 2025-05-15 SH 849.0 ... 2.002356 SH509 SH
29 2025-05-15 CU 78938.33 ... -0.006946 cu2506 cu
30 2025-05-15 AL 20226.67 ... 0.000412 al2507 al
31 2025-05-15 ZN 22868.0 ... -0.005597 zn2506 zn
32 2025-05-15 PB 16893.75 ... 0.006289 pb2506 pb
33 2025-05-15 NI 126308.33 ... -0.010121 ni2506 ni
34 2025-05-15 SN 265850.0 ... -0.001768 sn2506 sn
35 2025-05-15 AU 759.42 ... -0.018698 au2508 au
36 2025-05-15 AG 8169.33 ... -0.014362 ag2508 ag
37 2025-05-15 RB 3189.89 ... -0.022537 rb2510 rb
38 2025-05-15 WR 3377.5 ... 0.017617 wr2510 wr
39 2025-05-15 HC 3313.33 ... -0.017001 hc2510 hc
40 2025-05-15 FU 5445.0 ... -0.444261 fu2507 fu
41 2025-05-15 BU 3602.5 ... -0.039556 bu2507 bu
42 2025-05-15 RU 14838.33 ... 0.02033 ru2509 ru
43 2025-05-15 SP 6300.0 ... -0.145079 sp2507 sp
44 2025-05-15 SS 13255.0 ... -0.015466 ss2507 ss
45 2025-05-15 BR 12700.0 ... -0.020472 br2507 br
46 2025-05-15 SI 9520.0 ... -0.102941 SI2509 si
47 2025-05-15 LC 64733.33 ... -0.003604 LC2507 lc
[48 rows x 15 columns]
2025-05-15 16:25:59,980 - future_1d - INFO - save future_spot 2025-05-15 add
2025-05-15 16:25:59,987 - future_1d - INFO - 0 ... 4
date 2025-05-15 ... 2025-05-15
variety C ... P
spot_price 2304.29 ... 8680.0
near_contract c2505 ... p2505
near_contract_price 2311.0 ... 8340.0
dominant_contract c2507 ... p2509
dominant_contract_price 2345.0 ... 8104.0
near_month 2505 ... 2505
dominant_month 2507 ... 2509
near_basis 6.71 ... -340.0
dom_basis 40.71 ... -576.0
near_basis_rate 0.0029 ... -0.0392
dom_basis_rate 0.0177 ... -0.0664
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-15 16:25:59.934122 ... 2025-05-15 16:25:59.934122
updated_at 2025-05-15 16:25:59.934685 ... 2025-05-15 16:25:59.934685
[17 rows x 5 columns]
=========================================================================
2025-05-15 18:25:33 Thu START TASK.01 future_1d future_spot
=========================================================================
2025-05-15 18:25:34,831 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-15 18:25:35,160 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-09, end_day=2025-05-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-09 C 2292.86 ... 0.033644 c2507 c
1 2025-05-09 A 4245.0 ... -0.01649 a2507 a
2 2025-05-09 M 3300.0 ... -0.117273 m2509 m
3 2025-05-09 Y 8076.0 ... -0.032689 y2509 y
4 2025-05-09 P 8510.0 ... -0.06698 p2509 p
5 2025-05-09 JD 3225.0 ... -0.058915 jd2507 jd
6 2025-05-09 L 7458.33 ... -0.059575 l2509 l
7 2025-05-09 V 4629.0 ... 0.04191 v2509 v
8 2025-05-09 PP 7440.0 ... -0.059946 pp2509 pp
9 2025-05-09 I 770.89 ... -0.096499 i2509 i
10 2025-05-09 EG 4340.0 ... -0.02788 eg2509 eg
11 2025-05-09 EB 7680.0 ... -0.091276 eb2506 eb
12 2025-05-09 PG 4917.5 ... -0.108287 pg2506 pg
13 2025-05-09 LH 14780.0 ... -0.05954 lh2509 lh
14 2025-05-09 CF 14136.0 ... -0.085668 CF509 CF
15 2025-05-09 SR 6146.67 ... -0.049892 SR509 SR
16 2025-05-09 TA 4750.84 ... -0.038486 TA509 TA
17 2025-05-09 OI 9463.33 ... -0.00796 OI509 OI
18 2025-05-09 MA 2402.5 ... -0.0718 MA509 MA
19 2025-05-09 FG 1210.4 ... -0.134171 FG509 FG
20 2025-05-09 RM 2506.67 ... 0.020078 RM509 RM
21 2025-05-09 SF 5402.86 ... 0.027234 SF507 SF
22 2025-05-09 SM 5634.0 ... 0.022719 SM509 SM
23 2025-05-09 CY 23775.0 ... -0.187802 CY507 CY
24 2025-05-09 UR 1921.67 ... -0.010236 UR509 UR
25 2025-05-09 SA 1462.5 ... -0.100171 SA509 SA
26 2025-05-09 PF 6377.92 ... -0.019116 PF507 PF
27 2025-05-09 PX 6600.0 ... -0.023333 PX509 PX
28 2025-05-09 SH 821.0 ... 2.021924 SH509 SH
29 2025-05-09 CU 78258.33 ... -0.007646 cu2506 cu
30 2025-05-09 AL 19630.0 ... -0.006623 al2507 al
31 2025-05-09 ZN 22756.0 ... -0.022236 zn2506 zn
32 2025-05-09 PB 16718.75 ... 0.004262 pb2506 pb
33 2025-05-09 NI 124758.33 ... -0.008804 ni2506 ni
34 2025-05-09 SN 259500.0 ... 0.005318 sn2506 sn
35 2025-05-09 AU 795.94 ... -0.009775 au2508 au
36 2025-05-09 AG 8188.67 ... -0.002036 ag2508 ag
37 2025-05-09 RB 3141.44 ... -0.033564 rb2510 rb
38 2025-05-09 WR 3367.5 ... 0.004009 wr2510 wr
39 2025-05-09 HC 3273.33 ... -0.030956 hc2510 hc
40 2025-05-09 FU 5470.0 ... -0.465631 fu2507 fu
41 2025-05-09 BU 3585.0 ... -0.049372 bu2507 bu
42 2025-05-09 RU 14408.33 ... 0.02059 ru2509 ru
43 2025-05-09 SP 6200.0 ... -0.164194 sp2507 sp
44 2025-05-09 SS 13042.5 ... -0.021277 ss2507 ss
45 2025-05-09 BR 12010.0 ... -0.040799 br2507 br
46 2025-05-09 SI 9640.0 ... -0.139004 SI2506 si
47 2025-05-09 LC 67133.33 ... -0.051142 LC2507 lc
[48 rows x 15 columns]
2025-05-15 18:25:35,334 - future_1d - INFO - save future_spot 2025-05-09 completed
2025-05-15 18:25:44,006 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-12, end_day=2025-05-12) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-12 C 2298.57 ... 0.029771 c2507 c
1 2025-05-12 A 4255.0 ... -0.023267 a2507 a
2 2025-05-12 M 3138.0 ... -0.078075 m2509 m
3 2025-05-12 Y 8094.0 ... -0.038053 y2509 y
4 2025-05-12 P 8610.0 ... -0.075958 p2509 p
5 2025-05-12 JD 3310.0 ... -0.082779 jd2507 jd
6 2025-05-12 L 7428.33 ... -0.054565 l2509 l
7 2025-05-12 V 4604.0 ... 0.041703 v2509 v
8 2025-05-12 PP 7440.0 ... -0.06129 pp2509 pp
9 2025-05-12 I 777.22 ... -0.090348 i2509 i
10 2025-05-12 EG 4408.33 ... -0.03274 eg2509 eg
11 2025-05-12 EB 7676.0 ... -0.072043 eb2506 eb
12 2025-05-12 PG 4905.0 ... -0.110703 pg2506 pg
13 2025-05-12 LH 14750.0 ... -0.058644 lh2509 lh
14 2025-05-12 CF 14200.83 ... -0.07435 CF509 CF
15 2025-05-12 SR 6150.0 ... -0.045854 SR509 SR
16 2025-05-12 TA 4888.33 ... -0.05121 TA509 TA
17 2025-05-12 OI 9446.67 ... -0.013621 OI509 OI
18 2025-05-12 MA 2402.5 ... -0.065557 MA509 MA
19 2025-05-12 FG 1210.4 ... -0.144085 FG509 FG
20 2025-05-12 RM 2490.0 ... 0.018072 RM509 RM
21 2025-05-12 SF 5424.29 ... 0.044192 SF507 SF
22 2025-05-12 SM 5676.0 ... 0.029951 SM509 SM
23 2025-05-12 CY 23775.0 ... -0.182334 CY507 CY
24 2025-05-12 UR 1945.0 ... -0.027763 UR509 UR
25 2025-05-12 SA 1462.5 ... -0.109744 SA509 SA
26 2025-05-12 PF 6411.79 ... -0.015252 PF507 PF
27 2025-05-12 PX 6600.0 ... -0.011515 PX509 PX
28 2025-05-12 SH 829.0 ... 2.0 SH509 SH
29 2025-05-12 CU 78425.0 ... -0.005037 cu2506 cu
30 2025-05-12 AL 19830.0 ... -0.00706 al2507 al
31 2025-05-12 ZN 22730.0 ... -0.017818 zn2506 zn
32 2025-05-12 PB 16806.25 ... 0.007066 pb2506 pb
33 2025-05-12 NI 126525.0 ... -0.005967 ni2506 ni
34 2025-05-12 SN 262537.5 ... -0.005437 sn2506 sn
35 2025-05-12 AU 769.24 ... 0.014482 au2508 au
36 2025-05-12 AG 8139.33 ... 0.008191 ag2508 ag
37 2025-05-12 RB 3160.33 ... -0.034278 rb2510 rb
38 2025-05-12 WR 3342.5 ... 0.018699 wr2510 wr
39 2025-05-12 HC 3256.67 ... -0.020472 hc2510 hc
40 2025-05-12 FU 5470.0 ... -0.458684 fu2507 fu
41 2025-05-12 BU 3585.0 ... -0.038494 bu2507 bu
42 2025-05-12 RU 14738.33 ... 0.000792 ru2509 ru
43 2025-05-12 SP 6200.0 ... -0.15871 sp2507 sp
44 2025-05-12 SS 13130.0 ... -0.020183 ss2507 ss
45 2025-05-12 BR 12020.0 ... -0.027454 br2507 br
46 2025-05-12 SI 9610.0 ... -0.138398 SI2506 si
47 2025-05-12 LC 66633.33 ... -0.044622 LC2507 lc
[48 rows x 15 columns]
2025-05-15 18:25:44,156 - future_1d - INFO - save future_spot 2025-05-12 completed
2025-05-15 18:25:52,102 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-13, end_day=2025-05-13) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-13 C 2300.0 ... 0.02087 c2507 c
1 2025-05-13 A 4255.0 ... -0.022327 a2507 a
2 2025-05-13 M 3116.0 ... -0.068357 m2509 m
3 2025-05-13 Y 8076.0 ... -0.031204 y2509 y
4 2025-05-13 P 8564.0 ... -0.064689 p2509 p
5 2025-05-13 JD 3365.0 ... -0.098366 jd2507 jd
6 2025-05-13 L 7445.0 ... -0.039758 l2509 l
7 2025-05-13 V 4602.0 ... 0.051717 v2509 v
8 2025-05-13 PP 7440.0 ... -0.051478 pp2509 pp
9 2025-05-13 I 786.22 ... -0.084862 i2509 i
10 2025-05-13 EG 4408.33 ... -0.014139 eg2509 eg
11 2025-05-13 EB 7720.0 ... -0.039896 eb2506 eb
12 2025-05-13 PG 4882.5 ... -0.115617 pg2506 pg
13 2025-05-13 LH 14720.0 ... -0.057745 lh2509 lh
14 2025-05-13 CF 14388.83 ... -0.073934 CF509 CF
15 2025-05-13 SR 6145.0 ... -0.045077 SR509 SR
16 2025-05-13 TA 4913.34 ... -0.035687 TA509 TA
17 2025-05-13 OI 9468.33 ... -0.009223 OI509 OI
18 2025-05-13 MA 2453.75 ... -0.070402 MA509 MA
19 2025-05-13 FG 1196.0 ... -0.137124 FG509 FG
20 2025-05-13 RM 2476.67 ... 0.011439 RM509 RM
21 2025-05-13 SF 5424.29 ... 0.035712 SF507 SF
22 2025-05-13 SM 5686.0 ... 0.024974 SM509 SM
23 2025-05-13 CY 23775.0 ... -0.173081 CY507 CY
24 2025-05-13 UR 1945.0 ... -0.021594 UR509 UR
25 2025-05-13 SA 1462.5 ... -0.104274 SA509 SA
26 2025-05-13 PF 6535.29 ... -0.014275 PF507 PF
27 2025-05-13 PX 6700.0 ... -0.002687 PX509 PX
28 2025-05-13 SH 845.0 ... 1.985799 SH509 SH
29 2025-05-13 CU 78168.33 ... -0.003689 cu2506 cu
30 2025-05-13 AL 20033.33 ... -0.004409 al2507 al
31 2025-05-13 ZN 22662.0 ... -0.01465 zn2506 zn
32 2025-05-13 PB 16850.0 ... 0.005935 pb2506 pb
33 2025-05-13 NI 124916.67 ... -0.005497 ni2506 ni
34 2025-05-13 SN 262125.0 ... 0.004635 sn2506 sn
35 2025-05-13 AU 758.86 ... 0.004849 au2508 au
36 2025-05-13 AG 8133.67 ... 0.005942 ag2508 ag
37 2025-05-13 RB 3164.78 ... -0.023945 rb2510 rb
38 2025-05-13 WR 3370.0 ... 0.018694 wr2510 wr
39 2025-05-13 HC 3296.67 ... -0.021437 hc2510 hc
40 2025-05-13 FU 5482.5 ... -0.448609 fu2507 fu
41 2025-05-13 BU 3595.0 ... -0.03783 bu2507 bu
42 2025-05-13 RU 14748.33 ... 0.016725 ru2509 ru
43 2025-05-13 SP 6250.0 ... -0.14912 sp2507 sp
44 2025-05-13 SS 13130.0 ... -0.015232 ss2507 ss
45 2025-05-13 BR 12280.0 ... -0.012215 br2507 br
46 2025-05-13 SI 9610.0 ... -0.139958 SI2506 si
47 2025-05-13 LC 65633.33 ... -0.035551 LC2507 lc
[48 rows x 15 columns]
2025-05-15 18:25:52,260 - future_1d - INFO - save future_spot 2025-05-13 completed
2025-05-15 18:26:00,352 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-14, end_day=2025-05-14) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-14 C 2304.29 ... 0.019837 c2507 c
1 2025-05-14 A 4255.0 ... -0.021152 a2507 a
2 2025-05-14 M 3084.0 ... -0.060311 m2509 m
3 2025-05-14 Y 8174.0 ... -0.036457 y2509 y
4 2025-05-14 P 8680.0 ... -0.065899 p2509 p
5 2025-05-14 JD 3375.0 ... -0.105481 jd2507 jd
6 2025-05-14 L 7508.33 ... -0.031343 l2509 l
7 2025-05-14 V 4697.0 ... 0.046413 v2509 v
8 2025-05-14 PP 7440.0 ... -0.039247 pp2509 pp
9 2025-05-14 I 793.33 ... -0.082349 i2509 i
10 2025-05-14 EG 4536.67 ... -0.009846 eg2509 eg
11 2025-05-14 EB 7890.0 ... -0.026489 eb2506 eb
12 2025-05-14 PG 4882.5 ... -0.105376 pg2506 pg
13 2025-05-14 LH 14730.0 ... -0.051595 lh2509 lh
14 2025-05-14 CF 14482.83 ... -0.075457 CF509 CF
15 2025-05-14 SR 6145.0 ... -0.039056 SR509 SR
16 2025-05-14 TA 4913.34 ... -0.012484 TA509 TA
17 2025-05-14 OI 9543.33 ... -0.013342 OI509 OI
18 2025-05-14 MA 2521.25 ... -0.074665 MA509 MA
19 2025-05-14 FG 1188.0 ... -0.127104 FG509 FG
20 2025-05-14 RM 2460.0 ... 0.013008 RM509 RM
21 2025-05-14 SF 5424.29 ... 0.044929 SF507 SF
22 2025-05-14 SM 5692.0 ... 0.030569 SM509 SM
23 2025-05-14 CY 23775.0 ... -0.169926 CY507 CY
24 2025-05-14 UR 1945.0 ... -0.035476 UR509 UR
25 2025-05-14 SA 1462.5 ... -0.09812 SA509 SA
26 2025-05-14 PF 6618.33 ... -0.004885 PF507 PF
27 2025-05-14 PX 6700.0 ... 0.024179 PX509 PX
28 2025-05-14 SH 849.0 ... 1.949352 SH509 SH
29 2025-05-14 CU 78801.67 ... -0.003828 cu2506 cu
30 2025-05-14 AL 20226.67 ... -0.005274 al2507 al
31 2025-05-14 ZN 22850.0 ... -0.014442 zn2506 zn
32 2025-05-14 PB 16850.0 ... 0.004154 pb2506 pb
33 2025-05-14 NI 126308.33 ... -0.015109 ni2506 ni
34 2025-05-14 SN 265137.5 ... -0.001914 sn2506 sn
35 2025-05-14 AU 759.42 ... 0.0064 au2508 au
36 2025-05-14 AG 8169.33 ... 0.003754 ag2508 ag
37 2025-05-14 RB 3191.78 ... -0.026875 rb2510 rb
38 2025-05-14 WR 3370.0 ... 0.026706 wr2510 wr
39 2025-05-14 HC 3313.33 ... -0.020623 hc2510 hc
40 2025-05-14 FU 5470.0 ... -0.442779 fu2507 fu
41 2025-05-14 BU 3595.0 ... -0.028095 bu2507 bu
42 2025-05-14 RU 14983.33 ... 0.011457 ru2509 ru
43 2025-05-14 SP 6266.67 ... -0.149149 sp2507 sp
44 2025-05-14 SS 13255.0 ... -0.017352 ss2507 ss
45 2025-05-14 BR 12700.0 ... -0.016535 br2507 br
46 2025-05-14 SI 9610.0 ... -0.119147 SI2509 si
47 2025-05-14 LC 64966.67 ... -0.003489 LC2507 lc
[48 rows x 15 columns]
2025-05-15 18:26:00,503 - future_1d - INFO - save future_spot 2025-05-14 completed
2025-05-15 18:26:08,739 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-15, end_day=2025-05-15) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-15 C 2304.29 ... 0.017667 c2507 c
1 2025-05-15 A 4255.0 ... -0.017391 a2507 a
2 2025-05-15 M 3074.0 ... -0.055628 m2509 m
3 2025-05-15 Y 8054.0 ... -0.026571 y2509 y
4 2025-05-15 P 8680.0 ... -0.066359 p2509 p
5 2025-05-15 JD 3375.0 ... -0.107259 jd2507 jd
6 2025-05-15 L 7558.33 ... -0.031267 l2509 l
7 2025-05-15 V 4756.0 ... 0.055929 v2509 v
8 2025-05-15 PP 7440.0 ... -0.036694 pp2509 pp
9 2025-05-15 I 794.44 ... -0.07482 i2509 i
10 2025-05-15 EG 4503.33 ... -0.006291 eg2509 eg
11 2025-05-15 EB 8270.0 ... -0.060339 eb2506 eb
12 2025-05-15 PG 4847.5 ... -0.112739 pg2506 pg
13 2025-05-15 LH 14680.0 ... -0.056199 lh2509 lh
14 2025-05-15 CF 14512.33 ... -0.074925 CF509 CF
15 2025-05-15 SR 6145.0 ... -0.042636 SR509 SR
16 2025-05-15 TA 4991.66 ... -0.033588 TA509 TA
17 2025-05-15 OI 9395.0 ... -0.004577 OI509 OI
18 2025-05-15 MA 2426.25 ... -0.037197 MA509 MA
19 2025-05-15 FG 1184.0 ... -0.124155 FG509 FG
20 2025-05-15 RM 2476.67 ... 0.015476 RM509 RM
21 2025-05-15 SF 5424.29 ... 0.04198 SF507 SF
22 2025-05-15 SM 5706.0 ... 0.028391 SM509 SM
23 2025-05-15 CY 23775.0 ... -0.169295 CY507 CY
24 2025-05-15 UR 1946.67 ... -0.027056 UR509 UR
25 2025-05-15 SA 1462.5 ... -0.087179 SA509 SA
26 2025-05-15 PF 6688.96 ... -0.012104 PF507 PF
27 2025-05-15 PX 6700.0 ... 0.015821 PX509 PX
28 2025-05-15 SH 849.0 ... 2.002356 SH509 SH
29 2025-05-15 CU 78938.33 ... -0.006946 cu2506 cu
30 2025-05-15 AL 20366.67 ... -0.006465 al2507 al
31 2025-05-15 ZN 22880.0 ... -0.006119 zn2506 zn
32 2025-05-15 PB 16906.25 ... 0.005545 pb2506 pb
33 2025-05-15 NI 126525.0 ... -0.011816 ni2506 ni
34 2025-05-15 SN 266125.0 ... -0.002799 sn2506 sn
35 2025-05-15 AU 738.84 ... 0.008635 au2508 au
36 2025-05-15 AG 8037.67 ... 0.001783 ag2508 ag
37 2025-05-15 RB 3189.89 ... -0.022537 rb2510 rb
38 2025-05-15 WR 3377.5 ... 0.017617 wr2510 wr
39 2025-05-15 HC 3313.33 ... -0.017001 hc2510 hc
40 2025-05-15 FU 5445.0 ... -0.444261 fu2507 fu
41 2025-05-15 BU 3602.5 ... -0.039556 bu2507 bu
42 2025-05-15 RU 14838.33 ... 0.02033 ru2509 ru
43 2025-05-15 SP 6300.0 ... -0.145079 sp2507 sp
44 2025-05-15 SS 13255.0 ... -0.015466 ss2507 ss
45 2025-05-15 BR 12780.0 ... -0.026604 br2507 br
46 2025-05-15 SI 9520.0 ... -0.102941 SI2509 si
47 2025-05-15 LC 64733.33 ... -0.003604 LC2507 lc
[48 rows x 15 columns]
2025-05-15 18:26:08,908 - future_1d - INFO - save future_spot 2025-05-15 add
2025-05-15 18:26:08,916 - future_1d - INFO - 10 ... 31
date 2025-05-15 ... 2025-05-15
variety EG ... ZN
spot_price 4503.33 ... 22880.0
near_contract eg2505 ... zn2505
near_contract_price 4606.0 ... 22915.0
dominant_contract eg2509 ... zn2506
dominant_contract_price 4475.0 ... 22740.0
near_month 2505 ... 2505
dominant_month 2509 ... 2506
near_basis 102.67 ... 35.0
dom_basis -28.33 ... -140.0
near_basis_rate 0.0228 ... 0.0015
dom_basis_rate -0.0063 ... -0.0061
symbol eg2509 ... zn2506
comd eg ... zn
created_at 2025-05-15 18:26:08.875193 ... 2025-05-15 18:26:08.875193
updated_at 2025-05-15 18:26:08.875559 ... 2025-05-15 18:26:08.875559
[17 rows x 5 columns]