=========================================================================
2025-05-20 16:25:55 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-05-20 16:25:57,237 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-20 16:25:57,556 - 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-20 16:25:57,726 - future_1d - INFO - save future_spot 2025-05-14 completed
2025-05-20 16:26:05,169 - 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-20 16:26:05,323 - future_1d - INFO - save future_spot 2025-05-15 completed
2025-05-20 16:26:14,320 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-16, end_day=2025-05-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-16 C 2304.29 ... 0.016799 c2507 c
1 2025-05-16 A 4255.0 ... -0.021152 a2507 a
2 2025-05-16 M 2988.0 ... -0.028782 m2509 m
3 2025-05-16 Y 8024.0 ... -0.033898 y2509 y
4 2025-05-16 P 8492.0 ... -0.05723 p2509 p
5 2025-05-16 JD 3375.0 ... -0.115852 jd2507 jd
6 2025-05-16 L 7566.67 ... -0.039868 l2509 l
7 2025-05-16 V 4782.0 ... 0.041196 v2509 v
8 2025-05-16 PP 7440.0 ... -0.042742 pp2509 pp
9 2025-05-16 I 787.33 ... -0.074086 i2509 i
10 2025-05-16 EG 4551.67 ... -0.013769 eg2509 eg
11 2025-05-16 EB 8270.0 ... -0.084281 eb2507 eb
12 2025-05-16 PG 4780.0 ... -0.121548 pg2507 pg
13 2025-05-16 LH 14650.0 ... -0.064846 lh2509 lh
14 2025-05-16 CF 14558.17 ... -0.078524 CF509 CF
15 2025-05-16 SR 6145.0 ... -0.046542 SR509 SR
16 2025-05-16 TA 5007.5 ... -0.041438 TA509 TA
17 2025-05-16 OI 9378.33 ... -0.011658 OI509 OI
18 2025-05-16 MA 2426.25 ... -0.04915 MA509 MA
19 2025-05-16 FG 1168.0 ... -0.130137 FG509 FG
20 2025-05-16 RM 2476.67 ... 0.019514 RM509 RM
21 2025-05-16 SF 5440.0 ... 0.050735 SF507 SF
22 2025-05-16 SM 5698.0 ... 0.02808 SM509 SM
23 2025-05-16 CY 23775.0 ... -0.17224 CY507 CY
24 2025-05-16 UR 1946.67 ... -0.035789 UR509 UR
25 2025-05-16 SA 1462.5 ... -0.104957 SA509 SA
26 2025-05-16 PF 6727.5 ... -0.02252 PF507 PF
27 2025-05-16 PX 6850.0 ... -0.011387 PX509 PX
28 2025-05-16 SH 849.0 ... 1.992933 SH509 SH
29 2025-05-16 CU 78818.33 ... -0.006449 cu2506 cu
30 2025-05-16 AL 20290.0 ... -0.0069 al2507 al
31 2025-05-16 ZN 22746.0 ... -0.009716 zn2506 zn
32 2025-05-16 PB 16847.5 ... 0.004897 pb2506 pb
33 2025-05-16 NI 126258.33 ... -0.012501 ni2506 ni
34 2025-05-16 SN 265487.5 ... -0.000141 sn2506 sn
35 2025-05-16 AU 748.62 ... 0.004301 au2508 au
36 2025-05-16 AG 8092.67 ... 0.001524 ag2508 ag
37 2025-05-16 RB 3184.22 ... -0.026449 rb2510 rb
38 2025-05-16 WR 3372.5 ... 0.011712 wr2510 wr
39 2025-05-16 HC 3310.0 ... -0.021148 hc2510 hc
40 2025-05-16 FU 5445.0 ... -0.448852 fu2507 fu
41 2025-05-16 BU 3600.0 ... -0.039444 bu2507 bu
42 2025-05-16 RU 14658.33 ... 0.025014 ru2509 ru
43 2025-05-16 SP 6300.0 ... -0.148889 sp2507 sp
44 2025-05-16 SS 13300.0 ... -0.02218 ss2507 ss
45 2025-05-16 BR 12780.0 ... -0.034038 br2507 br
46 2025-05-16 SI 9480.0 ... -0.119726 SI2509 si
47 2025-05-16 LC 63733.33 ... -0.017782 LC2507 lc
[48 rows x 15 columns]
2025-05-20 16:26:14,483 - future_1d - INFO - save future_spot 2025-05-16 completed
2025-05-20 16:26:21,293 - 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-20 16:26:21,446 - future_1d - INFO - save future_spot 2025-05-19 completed
2025-05-20 16:26:27,814 - 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 2968.0 ... -0.029987 m2509 m
3 2025-05-20 Y 8044.0 ... -0.03083 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 4724.0 ... 0.048476 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 8224.0 ... -0.092048 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 14551.17 ... -0.078425 CF509 CF
15 2025-05-20 SR 6145.0 ... -0.046542 SR509 SR
16 2025-05-20 TA 5001.25 ... -0.053437 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 1164.0 ... -0.120275 FG509 FG
20 2025-05-20 RM 2471.67 ... 0.010248 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 3347.5 ... -0.003435 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 12710.0 ... -0.040126 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-20 16:26:27,984 - future_1d - INFO - save future_spot 2025-05-20 add
2025-05-20 16:26:27,992 - future_1d - INFO - 0 ... 4
date 2025-05-20 ... 2025-05-20
variety C ... P
spot_price 2301.43 ... 8636.0
near_contract c2507 ... p2506
near_contract_price 2322.0 ... 8354.0
dominant_contract c2507 ... p2509
dominant_contract_price 2322.0 ... 8076.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 20.57 ... -282.0
dom_basis 20.57 ... -560.0
near_basis_rate 0.0089 ... -0.0327
dom_basis_rate 0.0089 ... -0.0648
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-20 16:26:27.944311 ... 2025-05-20 16:26:27.944311
updated_at 2025-05-20 16:26:27.944673 ... 2025-05-20 16:26:27.944673
[17 rows x 5 columns]
=========================================================================
2025-05-20 18:25:37 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-05-20 18:25:38,995 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-20 18:25:39,334 - 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-20 18:25:39,504 - future_1d - INFO - save future_spot 2025-05-14 completed
2025-05-20 18:25:47,604 - 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-20 18:25:47,763 - future_1d - INFO - save future_spot 2025-05-15 completed
2025-05-20 18:25:57,980 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-16, end_day=2025-05-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-16 C 2304.29 ... 0.016799 c2507 c
1 2025-05-16 A 4255.0 ... -0.021152 a2507 a
2 2025-05-16 M 2988.0 ... -0.028782 m2509 m
3 2025-05-16 Y 8024.0 ... -0.033898 y2509 y
4 2025-05-16 P 8492.0 ... -0.05723 p2509 p
5 2025-05-16 JD 3375.0 ... -0.115852 jd2507 jd
6 2025-05-16 L 7566.67 ... -0.039868 l2509 l
7 2025-05-16 V 4782.0 ... 0.041196 v2509 v
8 2025-05-16 PP 7440.0 ... -0.042742 pp2509 pp
9 2025-05-16 I 787.33 ... -0.074086 i2509 i
10 2025-05-16 EG 4551.67 ... -0.013769 eg2509 eg
11 2025-05-16 EB 8270.0 ... -0.084281 eb2507 eb
12 2025-05-16 PG 4780.0 ... -0.121548 pg2507 pg
13 2025-05-16 LH 14650.0 ... -0.064846 lh2509 lh
14 2025-05-16 CF 14558.17 ... -0.078524 CF509 CF
15 2025-05-16 SR 6145.0 ... -0.046542 SR509 SR
16 2025-05-16 TA 5007.5 ... -0.041438 TA509 TA
17 2025-05-16 OI 9378.33 ... -0.011658 OI509 OI
18 2025-05-16 MA 2426.25 ... -0.04915 MA509 MA
19 2025-05-16 FG 1168.0 ... -0.130137 FG509 FG
20 2025-05-16 RM 2476.67 ... 0.019514 RM509 RM
21 2025-05-16 SF 5440.0 ... 0.050735 SF507 SF
22 2025-05-16 SM 5698.0 ... 0.02808 SM509 SM
23 2025-05-16 CY 23775.0 ... -0.17224 CY507 CY
24 2025-05-16 UR 1946.67 ... -0.035789 UR509 UR
25 2025-05-16 SA 1462.5 ... -0.104957 SA509 SA
26 2025-05-16 PF 6727.5 ... -0.02252 PF507 PF
27 2025-05-16 PX 6850.0 ... -0.011387 PX509 PX
28 2025-05-16 SH 849.0 ... 1.992933 SH509 SH
29 2025-05-16 CU 78818.33 ... -0.006449 cu2506 cu
30 2025-05-16 AL 20290.0 ... -0.0069 al2507 al
31 2025-05-16 ZN 22746.0 ... -0.009716 zn2506 zn
32 2025-05-16 PB 16847.5 ... 0.004897 pb2506 pb
33 2025-05-16 NI 126258.33 ... -0.012501 ni2506 ni
34 2025-05-16 SN 265487.5 ... -0.000141 sn2506 sn
35 2025-05-16 AU 748.62 ... 0.004301 au2508 au
36 2025-05-16 AG 8092.67 ... 0.001524 ag2508 ag
37 2025-05-16 RB 3184.22 ... -0.026449 rb2510 rb
38 2025-05-16 WR 3372.5 ... 0.011712 wr2510 wr
39 2025-05-16 HC 3310.0 ... -0.021148 hc2510 hc
40 2025-05-16 FU 5445.0 ... -0.448852 fu2507 fu
41 2025-05-16 BU 3600.0 ... -0.039444 bu2507 bu
42 2025-05-16 RU 14658.33 ... 0.025014 ru2509 ru
43 2025-05-16 SP 6300.0 ... -0.148889 sp2507 sp
44 2025-05-16 SS 13300.0 ... -0.02218 ss2507 ss
45 2025-05-16 BR 12780.0 ... -0.034038 br2507 br
46 2025-05-16 SI 9480.0 ... -0.119726 SI2509 si
47 2025-05-16 LC 63733.33 ... -0.017782 LC2507 lc
[48 rows x 15 columns]
2025-05-20 18:25:58,134 - future_1d - INFO - save future_spot 2025-05-16 completed
2025-05-20 18:26:02,023 - 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-20 18:26:02,188 - future_1d - INFO - save future_spot 2025-05-19 completed
2025-05-20 18:26:06,795 - 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-20 18:26:06,969 - future_1d - INFO - save future_spot 2025-05-20 add
2025-05-20 18:26:06,976 - future_1d - INFO - 2 ... 14
date 2025-05-20 ... 2025-05-20
variety M ... CF
spot_price 2966.0 ... 14539.17
near_contract m2507 ... CF507
near_contract_price 2714.0 ... 13225.0
dominant_contract m2509 ... CF509
dominant_contract_price 2879.0 ... 13410.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis -252.0 ... -1314.17
dom_basis -87.0 ... -1129.17
near_basis_rate -0.085 ... -0.0904
dom_basis_rate -0.0293 ... -0.0777
symbol m2509 ... CF509
comd m ... CF
created_at 2025-05-20 18:26:06.931871 ... 2025-05-20 18:26:06.931871
updated_at 2025-05-20 18:26:06.932228 ... 2025-05-20 18:26:06.932228
[17 rows x 5 columns]