=========================================================================
2025-05-23 16:25:26 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-05-23 16:25:27,908 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-23 16:25:28,219 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-19, end_day=2025-05-19) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-19 C 2301.43 ... 0.013283 c2507 c
1 2025-05-19 A 4255.0 ... -0.016686 a2507 a
2 2025-05-19 M 2972.0 ... -0.026581 m2509 m
3 2025-05-19 Y 8044.0 ... -0.032571 y2509 y
4 2025-05-19 P 8542.0 ... -0.062749 p2509 p
5 2025-05-19 JD 3290.0 ... -0.104863 jd2507 jd
6 2025-05-19 L 7583.33 ... -0.044483 l2509 l
7 2025-05-19 V 4726.0 ... 0.052264 v2509 v
8 2025-05-19 PP 7440.0 ... -0.04664 pp2509 pp
9 2025-05-19 I 779.44 ... -0.072411 i2509 i
10 2025-05-19 EG 4560.0 ... -0.016886 eg2509 eg
11 2025-05-19 EB 8224.0 ... -0.080131 eb2507 eb
12 2025-05-19 PG 4740.0 ... -0.11308 pg2507 pg
13 2025-05-19 LH 14620.0 ... -0.065321 lh2509 lh
14 2025-05-19 CF 14551.17 ... -0.080486 CF509 CF
15 2025-05-19 SR 6145.0 ... -0.046867 SR509 SR
16 2025-05-19 TA 4993.75 ... -0.038798 TA509 TA
17 2025-05-19 OI 9475.0 ... -0.01467 OI509 OI
18 2025-05-19 MA 2362.5 ... -0.034497 MA509 MA
19 2025-05-19 FG 1164.0 ... -0.12543 FG509 FG
20 2025-05-19 RM 2471.67 ... 0.015912 RM509 RM
21 2025-05-19 SF 5435.71 ... 0.038687 SF507 SF
22 2025-05-19 SM 5664.0 ... 0.024364 SM509 SM
23 2025-05-19 CY 23775.0 ... -0.17245 CY507 CY
24 2025-05-19 UR 1936.67 ... -0.046301 UR509 UR
25 2025-05-19 SA 1462.5 ... -0.120684 SA509 SA
26 2025-05-19 PF 6701.04 ... -0.017167 PF507 PF
27 2025-05-19 PX 6850.0 ... -0.009051 PX509 PX
28 2025-05-19 SH 851.0 ... 2.028202 SH509 SH
29 2025-05-19 CU 78113.33 ... -0.004779 cu2506 cu
30 2025-05-19 AL 20243.33 ... -0.003869 al2507 al
31 2025-05-19 ZN 22590.0 ... -0.013723 zn2507 zn
32 2025-05-19 PB 16825.0 ... 0.005646 pb2507 pb
33 2025-05-19 NI 125083.33 ... -0.00946 ni2506 ni
34 2025-05-19 SN 265187.5 ... -0.004516 sn2506 sn
35 2025-05-19 AU 752.58 ... -0.002445 au2508 au
36 2025-05-19 AG 8096.33 ... -0.000658 ag2508 ag
37 2025-05-19 RB 3158.22 ... -0.026034 rb2510 rb
38 2025-05-19 WR 3347.5 ... 0.001942 wr2510 wr
39 2025-05-19 HC 3290.0 ... -0.0231 hc2510 hc
40 2025-05-19 FU 5462.5 ... -0.447872 fu2507 fu
41 2025-05-19 BU 3582.5 ... -0.024424 bu2507 bu
42 2025-05-19 RU 14758.33 ... 0.013326 ru2509 ru
43 2025-05-19 SP 6300.0 ... -0.142857 sp2507 sp
44 2025-05-19 SS 13287.5 ... -0.023895 ss2507 ss
45 2025-05-19 BR 12710.0 ... -0.029504 br2507 br
46 2025-05-19 SI 9390.0 ... -0.126731 SI2509 si
47 2025-05-19 LC 63600.0 ... -0.034591 LC2507 lc
[48 rows x 15 columns]
2025-05-23 16:25:28,405 - future_1d - INFO - save future_spot 2025-05-19 completed
2025-05-23 16:25:36,110 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-20, end_day=2025-05-20) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-20 C 2301.43 ... 0.008938 c2507 c
1 2025-05-20 A 4255.0 ... -0.017391 a2507 a
2 2025-05-20 M 2966.0 ... -0.029332 m2509 m
3 2025-05-20 Y 8074.0 ... -0.034432 y2509 y
4 2025-05-20 P 8636.0 ... -0.064845 p2509 p
5 2025-05-20 JD 3190.0 ... -0.074295 jd2507 jd
6 2025-05-20 L 7591.67 ... -0.04606 l2509 l
7 2025-05-20 V 4719.0 ... 0.049587 v2509 v
8 2025-05-20 PP 7440.0 ... -0.051613 pp2509 pp
9 2025-05-20 I 779.78 ... -0.072815 i2509 i
10 2025-05-20 EG 4540.0 ... -0.025551 eg2509 eg
11 2025-05-20 EB 8220.0 ... -0.091606 eb2507 eb
12 2025-05-20 PG 4702.5 ... -0.112174 pg2507 pg
13 2025-05-20 LH 14600.0 ... -0.062671 lh2509 lh
14 2025-05-20 CF 14539.17 ... -0.077664 CF509 CF
15 2025-05-20 SR 6145.0 ... -0.046542 SR509 SR
16 2025-05-20 TA 4958.34 ... -0.045245 TA509 TA
17 2025-05-20 OI 9520.0 ... -0.013761 OI509 OI
18 2025-05-20 MA 2327.5 ... -0.026853 MA509 MA
19 2025-05-20 FG 1148.0 ... -0.108014 FG509 FG
20 2025-05-20 RM 2475.0 ... 0.008889 RM509 RM
21 2025-05-20 SF 5435.71 ... 0.042734 SF507 SF
22 2025-05-20 SM 5656.0 ... 0.024399 SM509 SM
23 2025-05-20 CY 23775.0 ... -0.170347 CY507 CY
24 2025-05-20 UR 1930.0 ... -0.040933 UR509 UR
25 2025-05-20 SA 1462.5 ... -0.123419 SA509 SA
26 2025-05-20 PF 6687.71 ... -0.02747 PF507 PF
27 2025-05-20 PX 6850.0 ... -0.02365 PX509 PX
28 2025-05-20 SH 851.0 ... 2.009401 SH509 SH
29 2025-05-20 CU 78343.33 ... -0.006169 cu2506 cu
30 2025-05-20 AL 20226.67 ... -0.00824 al2507 al
31 2025-05-20 ZN 22574.0 ... -0.01546 zn2507 zn
32 2025-05-20 PB 16750.0 ... 0.004478 pb2507 pb
33 2025-05-20 NI 124775.0 ... -0.011501 ni2506 ni
34 2025-05-20 SN 265187.5 ... -0.001537 sn2506 sn
35 2025-05-20 AU 751.88 ... 0.005799 au2508 au
36 2025-05-20 AG 8078.0 ... 0.00359 ag2508 ag
37 2025-05-20 RB 3158.78 ... -0.030322 rb2510 rb
38 2025-05-20 WR 3335.0 ... 0.0003 wr2510 wr
39 2025-05-20 HC 3290.0 ... -0.025532 hc2510 hc
40 2025-05-20 FU 5462.5 ... -0.444394 fu2507 fu
41 2025-05-20 BU 3590.0 ... -0.020334 bu2507 bu
42 2025-05-20 RU 14708.33 ... 0.016771 ru2509 ru
43 2025-05-20 SP 6300.0 ... -0.144762 sp2507 sp
44 2025-05-20 SS 13287.5 ... -0.032173 ss2507 ss
45 2025-05-20 BR 12670.0 ... -0.037096 br2507 br
46 2025-05-20 SI 9290.0 ... -0.131324 SI2509 si
47 2025-05-20 LC 63466.67 ... -0.042962 LC2507 lc
[48 rows x 15 columns]
2025-05-23 16:25:36,267 - future_1d - INFO - save future_spot 2025-05-20 completed
2025-05-23 16:25:39,739 - 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-23 16:25:39,895 - future_1d - INFO - save future_spot 2025-05-21 completed
2025-05-23 16:25:47,481 - 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-23 16:25:47,635 - future_1d - INFO - save future_spot 2025-05-22 completed
2025-05-23 16:25:53,190 - 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 2998.0 ... -0.016011 m2509 m
3 2025-05-23 Y 8034.0 ... -0.03062 y2509 y
4 2025-05-23 P 8546.0 ... -0.060145 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 4912.91 ... -0.038045 TA509 TA
17 2025-05-23 OI 9521.67 ... -0.011518 OI509 OI
18 2025-05-23 MA 2303.75 ... -0.027238 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 SI 9210.0 ... -0.135722 SI2509 si
30 2025-05-23 LC 62933.33 ... -0.022458 LC2507 lc
[31 rows x 15 columns]
2025-05-23 16:25:53,356 - future_1d - INFO - save future_spot 2025-05-23 add
2025-05-23 16:25:53,363 - future_1d - INFO - 0 ... 4
date 2025-05-23 ... 2025-05-23
variety C ... P
spot_price 2295.71 ... 8546.0
near_contract c2507 ... p2506
near_contract_price 2327.0 ... 8302.0
dominant_contract c2507 ... p2509
dominant_contract_price 2327.0 ... 8032.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 31.29 ... -244.0
dom_basis 31.29 ... -514.0
near_basis_rate 0.0136 ... -0.0286
dom_basis_rate 0.0136 ... -0.0601
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-23 16:25:53.318317 ... 2025-05-23 16:25:53.318317
updated_at 2025-05-23 16:25:53.318793 ... 2025-05-23 16:25:53.318793
[17 rows x 5 columns]
=========================================================================
2025-05-23 18:25:41 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-05-23 18:25:43,464 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-23 18:25:43,782 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-19, end_day=2025-05-19) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-19 C 2301.43 ... 0.013283 c2507 c
1 2025-05-19 A 4255.0 ... -0.016686 a2507 a
2 2025-05-19 M 2972.0 ... -0.026581 m2509 m
3 2025-05-19 Y 8044.0 ... -0.032571 y2509 y
4 2025-05-19 P 8542.0 ... -0.062749 p2509 p
5 2025-05-19 JD 3290.0 ... -0.104863 jd2507 jd
6 2025-05-19 L 7583.33 ... -0.044483 l2509 l
7 2025-05-19 V 4726.0 ... 0.052264 v2509 v
8 2025-05-19 PP 7440.0 ... -0.04664 pp2509 pp
9 2025-05-19 I 779.44 ... -0.072411 i2509 i
10 2025-05-19 EG 4560.0 ... -0.016886 eg2509 eg
11 2025-05-19 EB 8224.0 ... -0.080131 eb2507 eb
12 2025-05-19 PG 4740.0 ... -0.11308 pg2507 pg
13 2025-05-19 LH 14620.0 ... -0.065321 lh2509 lh
14 2025-05-19 CF 14551.17 ... -0.080486 CF509 CF
15 2025-05-19 SR 6145.0 ... -0.046867 SR509 SR
16 2025-05-19 TA 4993.75 ... -0.038798 TA509 TA
17 2025-05-19 OI 9475.0 ... -0.01467 OI509 OI
18 2025-05-19 MA 2362.5 ... -0.034497 MA509 MA
19 2025-05-19 FG 1164.0 ... -0.12543 FG509 FG
20 2025-05-19 RM 2471.67 ... 0.015912 RM509 RM
21 2025-05-19 SF 5435.71 ... 0.038687 SF507 SF
22 2025-05-19 SM 5664.0 ... 0.024364 SM509 SM
23 2025-05-19 CY 23775.0 ... -0.17245 CY507 CY
24 2025-05-19 UR 1936.67 ... -0.046301 UR509 UR
25 2025-05-19 SA 1462.5 ... -0.120684 SA509 SA
26 2025-05-19 PF 6701.04 ... -0.017167 PF507 PF
27 2025-05-19 PX 6850.0 ... -0.009051 PX509 PX
28 2025-05-19 SH 851.0 ... 2.028202 SH509 SH
29 2025-05-19 CU 78113.33 ... -0.004779 cu2506 cu
30 2025-05-19 AL 20243.33 ... -0.003869 al2507 al
31 2025-05-19 ZN 22590.0 ... -0.013723 zn2507 zn
32 2025-05-19 PB 16825.0 ... 0.005646 pb2507 pb
33 2025-05-19 NI 125083.33 ... -0.00946 ni2506 ni
34 2025-05-19 SN 265187.5 ... -0.004516 sn2506 sn
35 2025-05-19 AU 752.58 ... -0.002445 au2508 au
36 2025-05-19 AG 8096.33 ... -0.000658 ag2508 ag
37 2025-05-19 RB 3158.22 ... -0.026034 rb2510 rb
38 2025-05-19 WR 3347.5 ... 0.001942 wr2510 wr
39 2025-05-19 HC 3290.0 ... -0.0231 hc2510 hc
40 2025-05-19 FU 5462.5 ... -0.447872 fu2507 fu
41 2025-05-19 BU 3582.5 ... -0.024424 bu2507 bu
42 2025-05-19 RU 14758.33 ... 0.013326 ru2509 ru
43 2025-05-19 SP 6300.0 ... -0.142857 sp2507 sp
44 2025-05-19 SS 13287.5 ... -0.023895 ss2507 ss
45 2025-05-19 BR 12710.0 ... -0.029504 br2507 br
46 2025-05-19 SI 9390.0 ... -0.126731 SI2509 si
47 2025-05-19 LC 63600.0 ... -0.034591 LC2507 lc
[48 rows x 15 columns]
2025-05-23 18:25:44,028 - future_1d - INFO - save future_spot 2025-05-19 completed
2025-05-23 18:25:48,066 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-20, end_day=2025-05-20) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-20 C 2301.43 ... 0.008938 c2507 c
1 2025-05-20 A 4255.0 ... -0.017391 a2507 a
2 2025-05-20 M 2966.0 ... -0.029332 m2509 m
3 2025-05-20 Y 8074.0 ... -0.034432 y2509 y
4 2025-05-20 P 8636.0 ... -0.064845 p2509 p
5 2025-05-20 JD 3190.0 ... -0.074295 jd2507 jd
6 2025-05-20 L 7591.67 ... -0.04606 l2509 l
7 2025-05-20 V 4719.0 ... 0.049587 v2509 v
8 2025-05-20 PP 7440.0 ... -0.051613 pp2509 pp
9 2025-05-20 I 779.78 ... -0.072815 i2509 i
10 2025-05-20 EG 4540.0 ... -0.025551 eg2509 eg
11 2025-05-20 EB 8220.0 ... -0.091606 eb2507 eb
12 2025-05-20 PG 4702.5 ... -0.112174 pg2507 pg
13 2025-05-20 LH 14600.0 ... -0.062671 lh2509 lh
14 2025-05-20 CF 14539.17 ... -0.077664 CF509 CF
15 2025-05-20 SR 6145.0 ... -0.046542 SR509 SR
16 2025-05-20 TA 4958.34 ... -0.045245 TA509 TA
17 2025-05-20 OI 9520.0 ... -0.013761 OI509 OI
18 2025-05-20 MA 2327.5 ... -0.026853 MA509 MA
19 2025-05-20 FG 1148.0 ... -0.108014 FG509 FG
20 2025-05-20 RM 2475.0 ... 0.008889 RM509 RM
21 2025-05-20 SF 5435.71 ... 0.042734 SF507 SF
22 2025-05-20 SM 5656.0 ... 0.024399 SM509 SM
23 2025-05-20 CY 23775.0 ... -0.170347 CY507 CY
24 2025-05-20 UR 1930.0 ... -0.040933 UR509 UR
25 2025-05-20 SA 1462.5 ... -0.123419 SA509 SA
26 2025-05-20 PF 6687.71 ... -0.02747 PF507 PF
27 2025-05-20 PX 6850.0 ... -0.02365 PX509 PX
28 2025-05-20 SH 851.0 ... 2.009401 SH509 SH
29 2025-05-20 CU 78343.33 ... -0.006169 cu2506 cu
30 2025-05-20 AL 20226.67 ... -0.00824 al2507 al
31 2025-05-20 ZN 22574.0 ... -0.01546 zn2507 zn
32 2025-05-20 PB 16750.0 ... 0.004478 pb2507 pb
33 2025-05-20 NI 124775.0 ... -0.011501 ni2506 ni
34 2025-05-20 SN 265187.5 ... -0.001537 sn2506 sn
35 2025-05-20 AU 751.88 ... 0.005799 au2508 au
36 2025-05-20 AG 8078.0 ... 0.00359 ag2508 ag
37 2025-05-20 RB 3158.78 ... -0.030322 rb2510 rb
38 2025-05-20 WR 3335.0 ... 0.0003 wr2510 wr
39 2025-05-20 HC 3290.0 ... -0.025532 hc2510 hc
40 2025-05-20 FU 5462.5 ... -0.444394 fu2507 fu
41 2025-05-20 BU 3590.0 ... -0.020334 bu2507 bu
42 2025-05-20 RU 14708.33 ... 0.016771 ru2509 ru
43 2025-05-20 SP 6300.0 ... -0.144762 sp2507 sp
44 2025-05-20 SS 13287.5 ... -0.032173 ss2507 ss
45 2025-05-20 BR 12670.0 ... -0.037096 br2507 br
46 2025-05-20 SI 9290.0 ... -0.131324 SI2509 si
47 2025-05-20 LC 63466.67 ... -0.042962 LC2507 lc
[48 rows x 15 columns]
2025-05-23 18:25:48,222 - future_1d - INFO - save future_spot 2025-05-20 completed
2025-05-23 18:25:53,606 - 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-23 18:25:53,764 - future_1d - INFO - save future_spot 2025-05-21 completed
2025-05-23 18:25:57,997 - 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-23 18:25:58,150 - future_1d - INFO - save future_spot 2025-05-22 completed
2025-05-23 18:26:01,742 - 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 SI 9180.0 ... -0.132898 SI2509 si
30 2025-05-23 LC 62933.33 ... -0.022458 LC2507 lc
[31 rows x 15 columns]
2025-05-23 18:26:01,920 - future_1d - INFO - save future_spot 2025-05-23 add
2025-05-23 18:26:01,928 - future_1d - INFO - 2 ... 18
date 2025-05-23 ... 2025-05-23
variety M ... MA
spot_price 3024.0 ... 2300.0
near_contract m2507 ... MA506
near_contract_price 2786.0 ... 2250.0
dominant_contract m2509 ... MA509
dominant_contract_price 2950.0 ... 2241.0
near_month 2507 ... 2506
dominant_month 2509 ... 2509
near_basis -238.0 ... -50.0
dom_basis -74.0 ... -59.0
near_basis_rate -0.0787 ... -0.0217
dom_basis_rate -0.0245 ... -0.0257
symbol m2509 ... MA509
comd m ... MA
created_at 2025-05-23 18:26:01.883130 ... 2025-05-23 18:26:01.883130
updated_at 2025-05-23 18:26:01.883495 ... 2025-05-23 18:26:01.883495
[17 rows x 5 columns]