=========================================================================
2025-06-12 22:40:12 Thu START TASK.01 future_1d future_spot
=========================================================================
2025-06-12 22:40:14,064 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-12 22:40:14,398 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-06, end_day=2025-06-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-06 C 2294.29 ... 0.01818 c2507 c
1 2025-06-06 A 4270.0 ... -0.040281 a2509 a
2 2025-06-06 M 2940.0 ... 0.017347 m2509 m
3 2025-06-06 Y 7994.0 ... -0.035026 y2509 y
4 2025-06-06 P 8520.0 ... -0.046479 p2509 p
5 2025-06-06 JD 2940.0 ... 0.211905 jd2508 jd
6 2025-06-06 L 7346.67 ... -0.037387 l2509 l
7 2025-06-06 V 4604.0 ... 0.039096 v2509 v
8 2025-06-06 PP 7380.0 ... -0.061518 pp2509 pp
9 2025-06-06 I 751.44 ... -0.057809 i2509 i
10 2025-06-06 EG 4498.33 ... -0.048091 eg2509 eg
11 2025-06-06 EB 7970.0 ... -0.109159 eb2507 eb
12 2025-06-06 PG 4770.0 ... -0.140252 pg2507 pg
13 2025-06-06 LH 14300.0 ... -0.055944 lh2509 lh
14 2025-06-06 CF 14569.33 ... -0.083692 CF509 CF
15 2025-06-06 SR 6095.0 ... -0.062182 SR509 SR
16 2025-06-06 TA 4903.25 ... -0.047163 TA509 TA
17 2025-06-06 OI 9296.67 ... -0.013733 OI509 OI
18 2025-06-06 MA 2313.0 ... -0.02032 MA509 MA
19 2025-06-06 FG 1120.0 ... -0.113393 FG509 FG
20 2025-06-06 RM 2535.0 ... 0.024063 RM509 RM
21 2025-06-06 SF 5090.0 ... 0.010609 SF509 SF
22 2025-06-06 SM 5536.0 ... 0.002529 SM509 SM
23 2025-06-06 CY 23725.0 ... -0.173656 CY509 CY
24 2025-06-06 UR 1850.0 ... -0.065946 UR509 UR
25 2025-06-06 SA 1375.0 ... -0.117818 SA509 SA
26 2025-06-06 PF 6507.5 ... -0.02574 PF508 PF
27 2025-06-06 PX 7000.0 ... -0.059143 PX509 PX
28 2025-06-06 SH 885.0 ... 1.650847 SH509 SH
29 2025-06-06 CU 78913.33 ... -0.001309 cu2507 cu
30 2025-06-06 AL 20246.67 ... -0.008973 al2507 al
31 2025-06-06 ZN 22680.0 ... -0.016314 zn2507 zn
32 2025-06-06 PB 16568.75 ... 0.007016 pb2507 pb
33 2025-06-06 NI 123450.0 ... -0.010612 ni2507 ni
34 2025-06-06 SN 264462.5 ... -0.005833 sn2507 sn
35 2025-06-06 AU 779.86 ... 0.003616 au2508 au
36 2025-06-06 AG 8746.0 ... 0.000915 ag2508 ag
37 2025-06-06 RB 3080.33 ... -0.031922 rb2510 rb
38 2025-06-06 WR 3262.5 ... 0.018544 wr2601 wr
39 2025-06-06 HC 3170.0 ... -0.023028 hc2510 hc
40 2025-06-06 FU 5312.5 ... -0.460518 fu2509 fu
41 2025-06-06 BU 3610.0 ... -0.036565 bu2509 bu
42 2025-06-06 RU 13508.33 ... 0.013819 ru2509 ru
43 2025-06-06 SP 6216.67 ... -0.159357 sp2509 sp
44 2025-06-06 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-06 BR 11630.0 ... -0.044282 br2508 br
46 2025-06-06 SI 8640.0 ... -0.155093 SI2509 si
47 2025-06-06 LC 60166.67 ... 0.010526 LC2507 lc
[48 rows x 15 columns]
2025-06-12 22:40:14,591 - future_1d - INFO - save future_spot 2025-06-06 completed
2025-06-12 22:40:19,426 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-09, end_day=2025-06-09) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-09 C 2300.0 ... 0.022174 c2507 c
1 2025-06-09 A 4295.0 ... -0.044237 a2509 a
2 2025-06-09 M 2944.0 ... 0.022758 m2509 m
3 2025-06-09 Y 8024.0 ... -0.032652 y2509 y
4 2025-06-09 P 8644.0 ... -0.056687 p2509 p
5 2025-06-09 JD 2915.0 ... 0.204117 jd2508 jd
6 2025-06-09 L 7346.67 ... -0.036434 l2509 l
7 2025-06-09 V 4602.0 ... 0.044111 v2509 v
8 2025-06-09 PP 7380.0 ... -0.060298 pp2509 pp
9 2025-06-09 I 746.11 ... -0.055769 i2509 i
10 2025-06-09 EG 4498.33 ... -0.051426 eg2509 eg
11 2025-06-09 EB 7870.0 ... -0.090216 eb2507 eb
12 2025-06-09 PG 4782.5 ... -0.141662 pg2507 pg
13 2025-06-09 LH 14270.0 ... -0.057463 lh2509 lh
14 2025-06-09 CF 14623.0 ... -0.07919 CF509 CF
15 2025-06-09 SR 6095.0 ... -0.059721 SR509 SR
16 2025-06-09 TA 4884.5 ... -0.050466 TA509 TA
17 2025-06-09 OI 9331.67 ... -0.019361 OI509 OI
18 2025-06-09 MA 2331.0 ... -0.026169 MA509 MA
19 2025-06-09 FG 1120.0 ... -0.105357 FG509 FG
20 2025-06-09 RM 2543.33 ... 0.022675 RM509 RM
21 2025-06-09 SF 5088.57 ... 0.014037 SF509 SF
22 2025-06-09 SM 5530.0 ... 0.003978 SM509 SM
23 2025-06-09 CY 23725.0 ... -0.168809 CY509 CY
24 2025-06-09 UR 1821.67 ... -0.067339 UR509 UR
25 2025-06-09 SA 1370.0 ... -0.114599 SA509 SA
26 2025-06-09 PF 6518.12 ... -0.027634 PF508 PF
27 2025-06-09 PX 7000.0 ... -0.065714 PX509 PX
28 2025-06-09 SH 885.0 ... 1.625989 SH509 SH
29 2025-06-09 CU 78891.67 ... -0.00281 cu2507 cu
30 2025-06-09 AL 20246.67 ... -0.011936 al2507 al
31 2025-06-09 ZN 22582.0 ... -0.020237 zn2507 zn
32 2025-06-09 PB 16593.75 ... 0.008211 pb2507 pb
33 2025-06-09 NI 124133.33 ... -0.011627 ni2507 ni
34 2025-06-09 SN 263900.0 ... -0.003941 sn2507 sn
35 2025-06-09 AU 768.07 ... 0.009361 au2508 au
36 2025-06-09 AG 8792.0 ... 0.00455 ag2508 ag
37 2025-06-09 RB 3069.0 ... -0.030303 rb2510 rb
38 2025-06-09 WR 3260.0 ... 0.011963 wr2510 wr
39 2025-06-09 HC 3170.0 ... -0.025552 hc2510 hc
40 2025-06-09 FU 5275.0 ... -0.453839 fu2509 fu
41 2025-06-09 BU 3630.0 ... -0.032782 bu2509 bu
42 2025-06-09 RU 13573.33 ... 0.004912 ru2509 ru
43 2025-06-09 SP 6216.67 ... -0.154531 sp2509 sp
44 2025-06-09 SS 13100.0 ... -0.034733 ss2508 ss
45 2025-06-09 BR 11760.0 ... -0.058673 br2508 br
46 2025-06-09 SI 8620.0 ... -0.147912 SI2509 si
47 2025-06-09 LC 60166.67 ... 0.008199 LC2507 lc
[48 rows x 15 columns]
2025-06-12 22:40:19,582 - future_1d - INFO - save future_spot 2025-06-09 completed
2025-06-12 22:40:26,480 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-10, end_day=2025-06-10) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-10 C 2308.57 ... 0.027476 c2507 c
1 2025-06-10 A 4295.0 ... -0.033527 a2509 a
2 2025-06-10 M 2952.0 ... 0.022696 m2509 m
3 2025-06-10 Y 8024.0 ... -0.032154 y2509 y
4 2025-06-10 P 8630.0 ... -0.054461 p2509 p
5 2025-06-10 JD 2915.0 ... 0.204117 jd2508 jd
6 2025-06-10 L 7361.67 ... -0.035681 l2509 l
7 2025-06-10 V 4608.0 ... 0.042752 v2509 v
8 2025-06-10 PP 7380.0 ... -0.059485 pp2509 pp
9 2025-06-10 I 740.0 ... -0.054054 i2509 i
10 2025-06-10 EG 4490.0 ... -0.049443 eg2509 eg
11 2025-06-10 EB 7886.0 ... -0.071519 eb2507 eb
12 2025-06-10 PG 4772.5 ... -0.139026 pg2507 pg
13 2025-06-10 LH 14250.0 ... -0.04807 lh2509 lh
14 2025-06-10 CF 14623.0 ... -0.077139 CF509 CF
15 2025-06-10 SR 6085.0 ... -0.059326 SR509 SR
16 2025-06-10 TA 4880.5 ... -0.049278 TA509 TA
17 2025-06-10 OI 9345.0 ... -0.017014 OI509 OI
18 2025-06-10 MA 2378.0 ... -0.042052 MA509 MA
19 2025-06-10 FG 1104.0 ... -0.097826 FG509 FG
20 2025-06-10 RM 2550.0 ... 0.025882 RM509 RM
21 2025-06-10 SF 5088.57 ... 0.015216 SF509 SF
22 2025-06-10 SM 5536.0 ... 0.003251 SM509 SM
23 2025-06-10 CY 23725.0 ... -0.168599 CY509 CY
24 2025-06-10 UR 1821.67 ... -0.071182 UR509 UR
25 2025-06-10 SA 1370.0 ... -0.121898 SA509 SA
26 2025-06-10 PF 6522.5 ... -0.028593 PF508 PF
27 2025-06-10 PX 7000.0 ... -0.064 PX509 PX
28 2025-06-10 SH 885.0 ... 1.629379 SH509 SH
29 2025-06-10 CU 79293.33 ... -0.00206 cu2507 cu
30 2025-06-10 AL 20193.33 ... -0.009574 al2507 al
31 2025-06-10 ZN 22146.0 ... -0.012463 zn2507 zn
32 2025-06-10 PB 16706.25 ... 0.008904 pb2507 pb
33 2025-06-10 NI 123000.0 ... -0.010894 ni2507 ni
34 2025-06-10 SN 264850.0 ... -0.004304 sn2507 sn
35 2025-06-10 AU 768.76 ... 0.005802 au2508 au
36 2025-06-10 AG 8792.0 ... 0.015355 ag2508 ag
37 2025-06-10 RB 3090.22 ... -0.03858 rb2510 rb
38 2025-06-10 WR 3267.5 ... 0.007804 wr2510 wr
39 2025-06-10 HC 3173.33 ... -0.02815 hc2510 hc
40 2025-06-10 FU 5275.0 ... -0.447583 fu2509 fu
41 2025-06-10 BU 3623.33 ... -0.03459 bu2509 bu
42 2025-06-10 RU 13670.83 ... 0.00762 ru2509 ru
43 2025-06-10 SP 6216.67 ... -0.150671 sp2509 sp
44 2025-06-10 SS 13100.0 ... -0.042748 ss2508 ss
45 2025-06-10 BR 11760.0 ... -0.056973 br2508 br
46 2025-06-10 SI 8620.0 ... -0.141531 SI2509 si
47 2025-06-10 LC 60066.67 ... 0.01354 LC2509 lc
[48 rows x 15 columns]
2025-06-12 22:40:26,635 - future_1d - INFO - save future_spot 2025-06-10 completed
2025-06-12 22:40:35,641 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-11, end_day=2025-06-11) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-11 C 2318.57 ... 0.025632 c2507 c
1 2025-06-11 A 4295.0 ... -0.028172 a2509 a
2 2025-06-11 M 2978.0 ... 0.020819 m2509 m
3 2025-06-11 Y 7964.0 ... -0.030387 y2509 y
4 2025-06-11 P 8452.0 ... -0.050166 p2509 p
5 2025-06-11 JD 2860.0 ... 0.226573 jd2508 jd
6 2025-06-11 L 7366.67 ... -0.035521 l2509 l
7 2025-06-11 V 4613.0 ... 0.046174 v2509 v
8 2025-06-11 PP 7378.33 ... -0.05751 pp2509 pp
9 2025-06-11 I 744.22 ... -0.052028 i2509 i
10 2025-06-11 EG 4488.33 ... -0.046639 eg2509 eg
11 2025-06-11 EB 7886.0 ... -0.070251 eb2507 eb
12 2025-06-11 PG 4797.5 ... -0.141428 pg2507 pg
13 2025-06-11 LH 14150.0 ... -0.037809 lh2509 lh
14 2025-06-11 CF 14783.0 ... -0.083068 CF509 CF
15 2025-06-11 SR 6080.0 ... -0.063816 SR509 SR
16 2025-06-11 TA 4871.75 ... -0.054549 TA509 TA
17 2025-06-11 OI 9303.33 ... -0.014331 OI509 OI
18 2025-06-11 MA 2363.0 ... -0.035125 MA509 MA
19 2025-06-11 FG 1104.0 ... -0.097826 FG509 FG
20 2025-06-11 RM 2568.33 ... 0.027127 RM509 RM
21 2025-06-11 SF 5048.57 ... 0.031183 SF509 SF
22 2025-06-11 SM 5526.0 ... -0.001086 SM509 SM
23 2025-06-11 CY 23725.0 ... -0.16628 CY509 CY
24 2025-06-11 UR 1820.0 ... -0.08022 UR509 UR
25 2025-06-11 SA 1370.0 ... -0.121898 SA509 SA
26 2025-06-11 PF 6510.62 ... -0.03235 PF508 PF
27 2025-06-11 PX 7000.0 ... -0.070571 PX509 PX
28 2025-06-11 SH 883.0 ... 1.638732 SH509 SH
29 2025-06-11 CU 79341.67 ... -0.002038 cu2507 cu
30 2025-06-11 AL 20420.0 ... -0.012243 al2507 al
31 2025-06-11 ZN 22294.0 ... -0.01229 zn2507 zn
32 2025-06-11 PB 16712.5 ... 0.007629 pb2507 pb
33 2025-06-11 NI 122883.33 ... -0.011176 ni2507 ni
34 2025-06-11 SN 265850.0 ... -0.002445 sn2507 sn
35 2025-06-11 AU 774.63 ... 0.003137 au2508 au
36 2025-06-11 AG 8886.67 ... 0.001162 ag2508 ag
37 2025-06-11 RB 3098.22 ... -0.035252 rb2510 rb
38 2025-06-11 WR 3267.5 ... 0.013619 wr2510 wr
39 2025-06-11 HC 3173.33 ... -0.020902 hc2510 hc
40 2025-06-11 FU 5262.5 ... -0.445701 fu2509 fu
41 2025-06-11 BU 3630.0 ... -0.042424 bu2509 bu
42 2025-06-11 RU 13758.33 ... 0.005573 ru2509 ru
43 2025-06-11 SP 6216.67 ... -0.152923 sp2509 sp
44 2025-06-11 SS 13012.5 ... -0.037464 ss2508 ss
45 2025-06-11 BR 11650.0 ... -0.057082 br2508 br
46 2025-06-11 SI 8620.0 ... -0.134571 SI2509 si
47 2025-06-11 LC 60233.33 ... 0.021361 LC2509 lc
[48 rows x 15 columns]
2025-06-12 22:40:35,814 - future_1d - INFO - save future_spot 2025-06-11 add
2025-06-12 22:40:35,822 - future_1d - INFO - 0 ... 4
date 2025-06-11 ... 2025-06-11
variety C ... P
spot_price 2318.57 ... 8452.0
near_contract c2507 ... p2506
near_contract_price 2378.0 ... 8600.0
dominant_contract c2507 ... p2509
dominant_contract_price 2378.0 ... 8028.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 59.43 ... 148.0
dom_basis 59.43 ... -424.0
near_basis_rate 0.0256 ... 0.0175
dom_basis_rate 0.0256 ... -0.0502
symbol c2507 ... p2509
comd c ... p
created_at 2025-06-12 22:40:35.774839 ... 2025-06-12 22:40:35.774839
updated_at 2025-06-12 22:40:35.775215 ... 2025-06-12 22:40:35.775215
[17 rows x 5 columns]
2025-06-12 22:40:44,494 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-12, end_day=2025-06-12) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-12 C 2330.0 ... 0.018884 c2507 c
1 2025-06-12 A 4295.0 ... -0.02468 a2509 a
2 2025-06-12 M 2982.0 ... 0.021462 m2509 m
3 2025-06-12 Y 7954.0 ... -0.031682 y2509 y
4 2025-06-12 P 8424.0 ... -0.049383 p2509 p
5 2025-06-12 JD 2810.0 ... 0.23879 jd2508 jd
6 2025-06-12 L 7388.33 ... -0.035777 l2509 l
7 2025-06-12 V 4617.0 ... 0.046134 v2509 v
8 2025-06-12 PP 7378.33 ... -0.053986 pp2509 pp
9 2025-06-12 I 742.11 ... -0.051354 i2509 i
10 2025-06-12 EG 4488.33 ... -0.049758 eg2509 eg
11 2025-06-12 EB 8002.0 ... -0.076856 eb2507 eb
12 2025-06-12 PG 4797.5 ... -0.159354 pg2508 pg
13 2025-06-12 LH 14120.0 ... -0.032932 lh2509 lh
14 2025-06-12 CF 14848.67 ... -0.090491 CF509 CF
15 2025-06-12 SR 6060.0 ... -0.065677 SR509 SR
16 2025-06-12 TA 4880.75 ... -0.050146 TA509 TA
17 2025-06-12 OI 9333.33 ... -0.017071 OI509 OI
18 2025-06-12 MA 2362.0 ... -0.028789 MA509 MA
19 2025-06-12 FG 1104.0 ... -0.105978 FG509 FG
20 2025-06-12 RM 2576.67 ... 0.0304 RM509 RM
21 2025-06-12 SF 5048.57 ... 0.024845 SF509 SF
22 2025-06-12 SM 5470.0 ... -0.004022 SM509 SM
23 2025-06-12 CY 23725.0 ... -0.167966 CY509 CY
24 2025-06-12 UR 1816.67 ... -0.089543 UR509 UR
25 2025-06-12 SA 1370.0 ... -0.133577 SA509 SA
26 2025-06-12 PF 6535.21 ... -0.032013 PF508 PF
27 2025-06-12 PX 7000.0 ... -0.064 PX509 PX
28 2025-06-12 SH 883.0 ... 1.619479 SH509 SH
29 2025-06-12 CU 79101.67 ... -0.005331 cu2507 cu
30 2025-06-12 AL 20420.0 ... -0.003918 al2507 al
31 2025-06-12 ZN 22304.0 ... -0.011164 zn2507 zn
32 2025-06-12 PB 16768.75 ... 0.007827 pb2507 pb
33 2025-06-12 NI 122066.67 ... -0.01308 ni2507 ni
34 2025-06-12 SN 265225.0 ... -0.002168 sn2507 sn
35 2025-06-12 AU 774.63 ... 0.008172 au2508 au
36 2025-06-12 AG 8886.67 ... -0.005927 ag2508 ag
37 2025-06-12 RB 3095.89 ... -0.039049 rb2510 rb
38 2025-06-12 WR 3257.5 ... 0.030852 wr2601 wr
39 2025-06-12 HC 3176.67 ... -0.027283 hc2510 hc
40 2025-06-12 FU 5287.5 ... -0.436028 fu2509 fu
41 2025-06-12 BU 3620.0 ... -0.030939 bu2509 bu
42 2025-06-12 RU 13458.33 ... 0.023158 ru2509 ru
43 2025-06-12 SP 6216.67 ... -0.157427 sp2509 sp
44 2025-06-12 SS 13012.5 ... -0.033237 ss2508 ss
45 2025-06-12 BR 11650.0 ... -0.053648 br2508 br
46 2025-06-12 SI 8620.0 ... -0.138051 SI2509 si
47 2025-06-12 LC 60633.33 ... 0.003738 LC2509 lc
[48 rows x 15 columns]
2025-06-12 22:40:44,667 - future_1d - INFO - save future_spot 2025-06-12 add
2025-06-12 22:40:44,675 - future_1d - INFO - 0 ... 4
date 2025-06-12 ... 2025-06-12
variety C ... P
spot_price 2330.0 ... 8424.0
near_contract c2507 ... p2506
near_contract_price 2374.0 ... 8600.0
dominant_contract c2507 ... p2509
dominant_contract_price 2374.0 ... 8008.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 44.0 ... 176.0
dom_basis 44.0 ... -416.0
near_basis_rate 0.0189 ... 0.0209
dom_basis_rate 0.0189 ... -0.0494
symbol c2507 ... p2509
comd c ... p
created_at 2025-06-12 22:40:44.627513 ... 2025-06-12 22:40:44.627513
updated_at 2025-06-12 22:40:44.627926 ... 2025-06-12 22:40:44.627926
[17 rows x 5 columns]