=========================================================================
2025-07-14 20:55:56 Mon START TASK.01 future_1d future_spot
=========================================================================
2025-07-14 20:55:58,737 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-07-14 20:55:59,199 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-08, end_day=2025-07-08) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-08 C 2360.0 ... -0.016949 c2509 c
1 2025-07-08 A 4295.0 ... -0.04773 a2509 a
2 2025-07-08 M 2880.0 ... 0.020139 m2509 m
3 2025-07-08 Y 8194.0 ... -0.034904 y2509 y
4 2025-07-08 P 8828.0 ... -0.031038 p2509 p
5 2025-07-08 JD 2750.0 ... 0.300727 jd2509 jd
6 2025-07-08 L 7416.67 ... -0.022472 l2509 l
7 2025-07-08 V 4648.0 ... 0.051205 v2509 v
8 2025-07-08 PP 7376.67 ... -0.043742 pp2509 pp
9 2025-07-08 JM 1236.25 ... -0.32093 jm2509 jm
10 2025-07-08 I 734.67 ... -0.004315 i2509 i
11 2025-07-08 EG 4395.0 ... -0.027759 eg2509 eg
12 2025-07-08 EB 7914.0 ... -0.073288 eb2508 eb
13 2025-07-08 PG 4885.0 ... -0.143501 pg2508 pg
14 2025-07-08 LH 14980.0 ... -0.047397 lh2509 lh
15 2025-07-08 BZ 5808.67 ... 0.01951 bz2603 bz
16 2025-07-08 CF 15202.17 ... -0.094866 CF509 CF
17 2025-07-08 SR 6040.0 ... -0.049007 SR509 SR
18 2025-07-08 TA 4930.84 ... -0.044788 TA509 TA
19 2025-07-08 FG 1122.4 ... -0.087669 FG509 FG
20 2025-07-08 RM 2505.0 ... 0.030339 RM509 RM
21 2025-07-08 SF 5138.57 ... 0.041535 SF509 SF
22 2025-07-08 SM 5536.0 ... 0.01987 SM509 SM
23 2025-07-08 CY 23200.0 ... -0.140086 CY509 CY
24 2025-07-08 UR 1831.0 ... -0.041507 UR509 UR
25 2025-07-08 SA 1252.5 ... -0.060279 SA509 SA
26 2025-07-08 PF 6704.58 ... -0.045727 PF509 PF
27 2025-07-08 PX 7250.0 ... -0.076414 PX509 PX
28 2025-07-08 SH 831.0 ... 1.909747 SH509 SH
29 2025-07-08 CU 79826.67 ... -0.004343 cu2508 cu
30 2025-07-08 AL 20613.33 ... -0.00574 al2508 al
31 2025-07-08 ZN 22010.0 ... -0.000227 zn2508 zn
32 2025-07-08 PB 16968.75 ... 0.008619 pb2508 pb
33 2025-07-08 NI 121450.0 ... -0.007081 ni2508 ni
34 2025-07-08 SN 264862.5 ... -0.00235 sn2508 sn
35 2025-07-08 AU 772.12 ... 0.003134 au2510 au
36 2025-07-08 AG 8896.67 ... 0.002285 ag2510 ag
37 2025-07-08 RB 3106.5 ... -0.014647 rb2510 rb
38 2025-07-08 WR 3302.5 ... 0.00106 wr2510 wr
39 2025-07-08 HC 3276.67 ... -0.027366 hc2510 hc
40 2025-07-08 FU 5425.0 ... -0.453088 fu2509 fu
41 2025-07-08 BU 3690.0 ... -0.026558 bu2509 bu
42 2025-07-08 RU 13858.33 ... 0.009501 ru2509 ru
43 2025-07-08 SP 5916.67 ... -0.142761 sp2509 sp
44 2025-07-08 SS 12887.5 ... -0.012609 ss2508 ss
45 2025-07-08 BR 11690.0 ... -0.047904 br2509 br
46 2025-07-08 SI 8910.0 ... -0.080247 SI2509 si
47 2025-07-08 LC 62600.0 ... 0.027157 LC2509 lc
[48 rows x 15 columns]
2025-07-14 20:55:59,530 - future_1d - INFO - save future_spot 2025-07-08 completed
2025-07-14 20:56:09,139 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-09, end_day=2025-07-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-09 C 2357.14 ... -0.014908 c2509 c
1 2025-07-09 A 4295.0 ... -0.042608 a2509 a
2 2025-07-09 M 2882.0 ... 0.020125 m2509 m
3 2025-07-09 Y 8182.0 ... -0.031777 y2509 y
4 2025-07-09 P 8874.0 ... -0.024566 p2509 p
5 2025-07-09 JD 2750.0 ... 0.303636 jd2509 jd
6 2025-07-09 L 7411.67 ... -0.020868 l2509 l
7 2025-07-09 V 4688.0 ... 0.051408 v2509 v
8 2025-07-09 PP 7376.67 ... -0.043471 pp2509 pp
9 2025-07-09 JM 1236.25 ... -0.303943 jm2509 jm
10 2025-07-09 I 739.0 ... -0.003383 i2509 i
11 2025-07-09 EG 4393.33 ... -0.026934 eg2509 eg
12 2025-07-09 EB 7908.0 ... -0.074355 eb2508 eb
13 2025-07-09 PG 4870.0 ... -0.142094 pg2508 pg
14 2025-07-09 LH 14900.0 ... -0.045638 lh2509 lh
15 2025-07-09 BZ 5818.67 ... 0.033741 bz2603 bz
16 2025-07-09 CF 15188.83 ... -0.093413 CF509 CF
17 2025-07-09 SR 6050.0 ... -0.047438 SR509 SR
18 2025-07-09 TA 4852.5 ... -0.028542 TA509 TA
19 2025-07-09 FG 1122.4 ... -0.083215 FG509 FG
20 2025-07-09 RM 2505.0 ... 0.027146 RM509 RM
21 2025-07-09 SF 5138.57 ... 0.046984 SF509 SF
22 2025-07-09 SM 5546.0 ... 0.024522 SM509 SM
23 2025-07-09 CY 23200.0 ... -0.141595 CY509 CY
24 2025-07-09 UR 1843.0 ... -0.039067 UR509 UR
25 2025-07-09 SA 1247.5 ... -0.048497 SA509 SA
26 2025-07-09 PF 6702.71 ... -0.043372 PF509 PF
27 2025-07-09 PX 7250.0 ... -0.073655 PX509 PX
28 2025-07-09 SH 841.0 ... 1.876338 SH509 SH
29 2025-07-09 CU 79245.0 ... -0.004227 cu2508 cu
30 2025-07-09 AL 20680.0 ... -0.007979 al2508 al
31 2025-07-09 ZN 22144.0 ... -0.00289 zn2508 zn
32 2025-07-09 PB 17087.5 ... 0.006584 pb2508 pb
33 2025-07-09 NI 120516.67 ... -0.008768 ni2508 ni
34 2025-07-09 SN 265262.5 ... -0.00638 sn2508 sn
35 2025-07-09 AU 767.05 ... 0.00322 au2510 au
36 2025-07-09 AG 8873.67 ... 0.002855 ag2510 ag
37 2025-07-09 RB 3112.5 ... -0.015261 rb2510 rb
38 2025-07-09 WR 3300.0 ... 0.01 wr2601 wr
39 2025-07-09 HC 3276.67 ... -0.025535 hc2510 hc
40 2025-07-09 FU 5412.5 ... -0.449053 fu2509 fu
41 2025-07-09 BU 3696.67 ... -0.021011 bu2509 bu
42 2025-07-09 RU 13908.33 ... 0.006951 ru2509 ru
43 2025-07-09 SP 5900.0 ... -0.13661 sp2509 sp
44 2025-07-09 SS 12887.5 ... -0.012221 ss2508 ss
45 2025-07-09 BR 11690.0 ... -0.038067 br2509 br
46 2025-07-09 SI 8910.0 ... -0.083614 SI2509 si
47 2025-07-09 LC 62600.0 ... 0.029712 LC2509 lc
[48 rows x 15 columns]
2025-07-14 20:56:09,295 - future_1d - INFO - save future_spot 2025-07-09 completed
2025-07-14 20:56:15,480 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-10, end_day=2025-07-10) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-10 C 2354.29 ... -0.015414 c2509 c
1 2025-07-10 A 4295.0 ... -0.043073 a2509 a
2 2025-07-10 M 2888.0 ... 0.019044 m2509 m
3 2025-07-10 Y 8214.0 ... -0.034819 y2509 y
4 2025-07-10 P 8836.0 ... -0.02354 p2509 p
5 2025-07-10 JD 2750.0 ... 0.298909 jd2509 jd
6 2025-07-10 L 7415.0 ... -0.014295 l2509 l
7 2025-07-10 V 4768.0 ... 0.049706 v2509 v
8 2025-07-10 PP 7360.0 ... -0.03519 pp2509 pp
9 2025-07-10 JM 1241.25 ... -0.288218 jm2509 jm
10 2025-07-10 I 748.44 ... 0.002752 i2509 i
11 2025-07-10 EG 4393.33 ... -0.01965 eg2509 eg
12 2025-07-10 EB 7908.0 ... -0.059686 eb2508 eb
13 2025-07-10 PG 4882.5 ... -0.13999 pg2508 pg
14 2025-07-10 LH 14830.0 ... -0.033715 lh2509 lh
15 2025-07-10 BZ 5835.33 ... 0.065064 bz2603 bz
16 2025-07-10 CF 15201.0 ... -0.087889 CF509 CF
17 2025-07-10 SR 6046.67 ... -0.040794 SR509 SR
18 2025-07-10 TA 4852.5 ... -0.025657 TA509 TA
19 2025-07-10 FG 1122.4 ... -0.052922 FG509 FG
20 2025-07-10 RM 2523.33 ... 0.028403 RM509 RM
21 2025-07-10 SF 5178.57 ... 0.068249 SF509 SF
22 2025-07-10 SM 5622.0 ... 0.030238 SM509 SM
23 2025-07-10 CY 23200.0 ... -0.137716 CY509 CY
24 2025-07-10 UR 1845.0 ... -0.036856 UR509 UR
25 2025-07-10 SA 1247.5 ... -0.027655 SA509 SA
26 2025-07-10 PF 6700.5 ... -0.039773 PF509 PF
27 2025-07-10 PX 7250.0 ... -0.068966 PX509 PX
28 2025-07-10 SH 847.0 ... 1.945691 SH509 SH
29 2025-07-10 CU 78678.33 ... -0.003665 cu2508 cu
30 2025-07-10 AL 20680.0 ... -0.000484 al2508 al
31 2025-07-10 ZN 22376.0 ... -0.004067 zn2508 zn
32 2025-07-10 PB 17093.75 ... 0.007093 pb2508 pb
33 2025-07-10 NI 120916.67 ... -0.008325 ni2508 ni
34 2025-07-10 SN 265075.0 ... -0.000283 sn2508 sn
35 2025-07-10 AU 767.05 ... 0.005358 au2510 au
36 2025-07-10 AG 8873.67 ... 0.001277 ag2510 ag
37 2025-07-10 RB 3138.5 ... -0.012586 rb2510 rb
38 2025-07-10 WR 3315.0 ... 0.004223 wr2601 wr
39 2025-07-10 HC 3290.0 ... -0.017325 hc2510 hc
40 2025-07-10 FU 5400.0 ... -0.451481 fu2509 fu
41 2025-07-10 BU 3690.0 ... -0.017615 bu2509 bu
42 2025-07-10 RU 14466.67 ... -0.015668 ru2509 ru
43 2025-07-10 SP 5933.33 ... -0.129325 sp2509 sp
44 2025-07-10 SS 12887.5 ... -0.005626 ss2508 ss
45 2025-07-10 BR 11810.0 ... -0.033023 br2509 br
46 2025-07-10 SI 8920.0 ... -0.061099 SI2509 si
47 2025-07-10 LC 62766.67 ... 0.026978 LC2509 lc
[48 rows x 15 columns]
2025-07-14 20:56:15,653 - future_1d - INFO - save future_spot 2025-07-10 completed
2025-07-14 20:56:23,379 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-11, end_day=2025-07-11) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-11 C 2351.43 ... -0.016769 c2509 c
1 2025-07-11 A 4295.0 ... -0.045867 a2509 a
2 2025-07-11 M 2924.0 ... 0.016074 m2509 m
3 2025-07-11 Y 8254.0 ... -0.034408 y2509 y
4 2025-07-11 P 8944.0 ... -0.028846 p2509 p
5 2025-07-11 JD 2775.0 ... 0.290811 jd2509 jd
6 2025-07-11 L 7416.67 ... -0.015461 l2509 l
7 2025-07-11 V 4733.0 ... 0.059159 v2509 v
8 2025-07-11 PP 7355.0 ... -0.037933 pp2509 pp
9 2025-07-11 JM 1241.25 ... -0.267271 jm2509 jm
10 2025-07-11 I 762.56 ... 0.002544 i2509 i
11 2025-07-11 EG 4405.0 ... -0.019977 eg2509 eg
12 2025-07-11 EB 7908.0 ... -0.055893 eb2508 eb
13 2025-07-11 PG 4875.0 ... -0.145846 pg2508 pg
14 2025-07-11 LH 14820.0 ... -0.031714 lh2509 lh
15 2025-07-11 BZ 5878.67 ... 0.061124 bz2603 bz
16 2025-07-11 CF 15282.0 ... -0.090106 CF509 CF
17 2025-07-11 SR 6046.67 ... -0.039471 SR509 SR
18 2025-07-11 TA 4852.5 ... -0.029366 TA509 TA
19 2025-07-11 FG 1128.0 ... -0.033688 FG509 FG
20 2025-07-11 RM 2551.67 ... 0.030698 RM509 RM
21 2025-07-11 SF 5217.14 ... 0.058434 SF509 SF
22 2025-07-11 SM 5630.0 ... 0.025577 SM509 SM
23 2025-07-11 CY 23200.0 ... -0.134914 CY509 CY
24 2025-07-11 UR 1861.25 ... -0.045803 UR509 UR
25 2025-07-11 SA 1247.5 ... -0.018036 SA509 SA
26 2025-07-11 PF 6668.46 ... -0.040258 PF509 PF
27 2025-07-11 PX 7250.0 ... -0.073103 PX509 PX
28 2025-07-11 SH 851.0 ... 1.944771 SH509 SH
29 2025-07-11 CU 78733.33 ... -0.002583 cu2508 cu
30 2025-07-11 AL 20806.67 ... -0.004406 al2508 al
31 2025-07-11 ZN 22404.0 ... -0.000179 zn2508 zn
32 2025-07-11 PB 16993.75 ... 0.006547 pb2508 pb
33 2025-07-11 NI 122500.0 ... -0.010694 ni2508 ni
34 2025-07-11 SN 266737.5 ... -0.004152 sn2508 sn
35 2025-07-11 AU 770.24 ... 0.003817 au2510 au
36 2025-07-11 AG 9005.0 ... 0.001333 ag2510 ag
37 2025-07-11 RB 3164.5 ... -0.009954 rb2510 rb
38 2025-07-11 WR 3355.0 ... 0.002385 wr2510 wr
39 2025-07-11 HC 3326.67 ... -0.016133 hc2510 hc
40 2025-07-11 FU 5362.5 ... -0.457716 fu2509 fu
41 2025-07-11 BU 3700.0 ... -0.025135 bu2509 bu
42 2025-07-11 RU 14416.67 ... -0.002197 ru2509 ru
43 2025-07-11 SP 5950.0 ... -0.121345 sp2509 sp
44 2025-07-11 SS 12887.5 ... -0.012997 ss2509 ss
45 2025-07-11 BR 11850.0 ... -0.022363 br2509 br
46 2025-07-11 SI 8940.0 ... -0.058166 SI2509 si
47 2025-07-11 LC 62966.67 ... 0.017999 LC2509 lc
[48 rows x 15 columns]
2025-07-14 20:56:23,576 - future_1d - INFO - save future_spot 2025-07-11 add
2025-07-14 20:56:23,581 - future_1d - INFO - 19
date 2025-07-11
variety FG
spot_price 1128.0
near_contract FG507
near_contract_price 989.0
dominant_contract FG509
dominant_contract_price 1090.0
near_month 2507
dominant_month 2509
near_basis -139.0
dom_basis -38.0
near_basis_rate -0.1232
dom_basis_rate -0.0337
symbol FG509
comd FG
created_at 2025-07-14 20:56:23.536462
updated_at 2025-07-14 20:56:23.537030
2025-07-14 20:56:32,464 - future_1d - INFO - futures_spot_price_daily(start_day=2025-07-14, end_day=2025-07-14) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-07-14 C 2340.0 ... -0.020085 c2509 c
1 2025-07-14 A 4295.0 ... -0.041676 a2509 a
2 2025-07-14 M 2912.0 ... 0.022321 m2509 m
3 2025-07-14 Y 8254.0 ... -0.032227 y2509 y
4 2025-07-14 P 8890.0 ... -0.021147 p2509 p
5 2025-07-14 JD 2875.0 ... 0.25113 jd2509 jd
6 2025-07-14 L 7411.67 ... -0.017226 l2509 l
7 2025-07-14 V 4720.0 ... 0.056144 v2509 v
8 2025-07-14 PP 7355.0 ... -0.039429 pp2509 pp
9 2025-07-14 JM 1248.75 ... -0.267267 jm2509 jm
10 2025-07-14 I 764.0 ... 0.002618 i2509 i
11 2025-07-14 EG 4410.0 ... -0.017914 eg2509 eg
12 2025-07-14 EB 7936.0 ... -0.059098 eb2508 eb
13 2025-07-14 PG 4817.5 ... -0.131915 pg2508 pg
14 2025-07-14 LH 14730.0 ... -0.032926 lh2509 lh
15 2025-07-14 BZ 5908.67 ... 0.050829 bz2603 bz
16 2025-07-14 CF 15312.67 ... -0.092255 CF509 CF
17 2025-07-14 SR 6050.0 ... -0.03719 SR509 SR
18 2025-07-14 TA 4789.84 ... -0.013328 TA509 TA
19 2025-07-14 FG 1128.0 ... -0.036348 FG509 FG
20 2025-07-14 RM 2566.67 ... 0.027401 RM509 RM
21 2025-07-14 SF 5202.86 ... 0.052498 SF509 SF
22 2025-07-14 SM 5630.0 ... 0.023801 SM509 SM
23 2025-07-14 CY 23200.0 ... -0.132543 CY509 CY
24 2025-07-14 UR 1838.75 ... -0.042284 UR509 UR
25 2025-07-14 SA 1247.5 ... -0.020441 SA509 SA
26 2025-07-14 PF 6667.08 ... -0.03826 PF509 PF
27 2025-07-14 PX 7250.0 ... -0.069241 PX509 PX
28 2025-07-14 SH 861.0 ... 1.934959 SH509 SH
29 2025-07-14 CU 78513.33 ... -0.002844 cu2508 cu
30 2025-07-14 AL 20806.67 ... -0.020506 al2509 al
31 2025-07-14 ZN 22154.0 ... 0.001399 zn2509 zn
32 2025-07-14 PB 16937.5 ... 0.007232 pb2508 pb
33 2025-07-14 NI 122100.0 ... -0.009746 ni2509 ni
34 2025-07-14 SN 266512.5 ... -0.001098 sn2508 sn
35 2025-07-14 AU 770.24 ... 0.010646 au2510 au
36 2025-07-14 AG 9005.0 ... 0.0191 ag2510 ag
37 2025-07-14 RB 3180.0 ... -0.015409 rb2510 rb
38 2025-07-14 WR 3345.0 ... 0.02272 wr2510 wr
39 2025-07-14 HC 3333.33 ... -0.019299 hc2510 hc
40 2025-07-14 FU 5387.5 ... -0.45819 fu2509 fu
41 2025-07-14 BU 3720.0 ... -0.023925 bu2509 bu
42 2025-07-14 RU 14386.67 ... -0.005677 ru2509 ru
43 2025-07-14 SP 5950.0 ... -0.120672 sp2509 sp
44 2025-07-14 SS 12900.0 ... -0.015504 ss2509 ss
45 2025-07-14 BR 11850.0 ... -0.025738 br2509 br
46 2025-07-14 SI 9140.0 ... -0.065098 SI2509 si
47 2025-07-14 LC 63000.0 ... 0.055873 LC2509 lc
[48 rows x 15 columns]
2025-07-14 20:56:32,641 - future_1d - INFO - save future_spot 2025-07-14 add
2025-07-14 20:56:32,649 - future_1d - INFO - 0 ... 4
date 2025-07-14 ... 2025-07-14
variety C ... P
spot_price 2340.0 ... 8890.0
near_contract c2507 ... p2507
near_contract_price 2353.0 ... 8446.0
dominant_contract c2509 ... p2509
dominant_contract_price 2293.0 ... 8702.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 13.0 ... -444.0
dom_basis -47.0 ... -188.0
near_basis_rate 0.0056 ... -0.0499
dom_basis_rate -0.0201 ... -0.0211
symbol c2509 ... p2509
comd c ... p
created_at 2025-07-14 20:56:32.602552 ... 2025-07-14 20:56:32.602552
updated_at 2025-07-14 20:56:32.603002 ... 2025-07-14 20:56:32.603002
[17 rows x 5 columns]