=========================================================================
2025-06-17 23:48:06 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-06-17 23:48:08,448 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-17 23:48:08,882 - 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 JM 1253.75 ... -0.371087 jm2509 jm
10 2025-06-11 I 744.22 ... -0.052028 i2509 i
11 2025-06-11 EG 4488.33 ... -0.046639 eg2509 eg
12 2025-06-11 EB 7886.0 ... -0.070251 eb2507 eb
13 2025-06-11 PG 4797.5 ... -0.141428 pg2507 pg
14 2025-06-11 LH 14150.0 ... -0.037809 lh2509 lh
15 2025-06-11 CF 14783.0 ... -0.083068 CF509 CF
16 2025-06-11 SR 6080.0 ... -0.063816 SR509 SR
17 2025-06-11 TA 4871.75 ... -0.054549 TA509 TA
18 2025-06-11 OI 9303.33 ... -0.014331 OI509 OI
19 2025-06-11 MA 2363.0 ... -0.035125 MA509 MA
20 2025-06-11 FG 1104.0 ... -0.097826 FG509 FG
21 2025-06-11 RM 2568.33 ... 0.027127 RM509 RM
22 2025-06-11 SF 5048.57 ... 0.031183 SF509 SF
23 2025-06-11 SM 5526.0 ... -0.001086 SM509 SM
24 2025-06-11 CY 23725.0 ... -0.16628 CY509 CY
25 2025-06-11 UR 1820.0 ... -0.08022 UR509 UR
26 2025-06-11 SA 1370.0 ... -0.121898 SA509 SA
27 2025-06-11 PF 6510.62 ... -0.03235 PF508 PF
28 2025-06-11 PX 7000.0 ... -0.070571 PX509 PX
29 2025-06-11 SH 883.0 ... 1.638732 SH509 SH
30 2025-06-11 CU 79341.67 ... -0.002038 cu2507 cu
31 2025-06-11 AL 20420.0 ... -0.012243 al2507 al
32 2025-06-11 ZN 22294.0 ... -0.01229 zn2507 zn
33 2025-06-11 PB 16712.5 ... 0.007629 pb2507 pb
34 2025-06-11 NI 122883.33 ... -0.011176 ni2507 ni
35 2025-06-11 SN 265850.0 ... -0.002445 sn2507 sn
36 2025-06-11 AU 774.63 ... 0.003137 au2508 au
37 2025-06-11 AG 8886.67 ... 0.001162 ag2508 ag
38 2025-06-11 RB 3098.22 ... -0.035252 rb2510 rb
39 2025-06-11 WR 3267.5 ... 0.013619 wr2510 wr
40 2025-06-11 HC 3173.33 ... -0.020902 hc2510 hc
41 2025-06-11 FU 5262.5 ... -0.445701 fu2509 fu
42 2025-06-11 BU 3630.0 ... -0.042424 bu2509 bu
43 2025-06-11 RU 13758.33 ... 0.005573 ru2509 ru
44 2025-06-11 SP 6216.67 ... -0.152923 sp2509 sp
45 2025-06-11 SS 13012.5 ... -0.037464 ss2508 ss
46 2025-06-11 BR 11650.0 ... -0.057082 br2508 br
47 2025-06-11 SI 8620.0 ... -0.134571 SI2509 si
48 2025-06-11 LC 60233.33 ... 0.021361 LC2509 lc
[49 rows x 15 columns]
2025-06-17 23:48:09,544 - future_1d - INFO - save future_spot 2025-06-11 add
2025-06-17 23:48:09,548 - future_1d - INFO - 9
date 2025-06-11
variety JM
spot_price 1253.75
near_contract jm2506
near_contract_price 640.5
dominant_contract jm2509
dominant_contract_price 788.5
near_month 2506
dominant_month 2509
near_basis -613.25
dom_basis -465.25
near_basis_rate -0.4891
dom_basis_rate -0.3711
symbol jm2509
comd jm
created_at 2025-06-17 23:48:09.443110
updated_at 2025-06-17 23:48:09.443488
2025-06-17 23:48:13,421 - 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 JM 1253.75 ... -0.382652 jm2509 jm
10 2025-06-12 I 742.11 ... -0.051354 i2509 i
11 2025-06-12 EG 4488.33 ... -0.049758 eg2509 eg
12 2025-06-12 EB 8002.0 ... -0.076856 eb2507 eb
13 2025-06-12 PG 4797.5 ... -0.159354 pg2508 pg
14 2025-06-12 LH 14120.0 ... -0.032932 lh2509 lh
15 2025-06-12 CF 14848.67 ... -0.090491 CF509 CF
16 2025-06-12 SR 6060.0 ... -0.065677 SR509 SR
17 2025-06-12 TA 4880.75 ... -0.050146 TA509 TA
18 2025-06-12 OI 9333.33 ... -0.017071 OI509 OI
19 2025-06-12 MA 2362.0 ... -0.028789 MA509 MA
20 2025-06-12 FG 1104.0 ... -0.105978 FG509 FG
21 2025-06-12 RM 2576.67 ... 0.0304 RM509 RM
22 2025-06-12 SF 5048.57 ... 0.024845 SF509 SF
23 2025-06-12 SM 5470.0 ... -0.004022 SM509 SM
24 2025-06-12 CY 23725.0 ... -0.167966 CY509 CY
25 2025-06-12 UR 1816.67 ... -0.089543 UR509 UR
26 2025-06-12 SA 1370.0 ... -0.133577 SA509 SA
27 2025-06-12 PF 6535.21 ... -0.032013 PF508 PF
28 2025-06-12 PX 7000.0 ... -0.064 PX509 PX
29 2025-06-12 SH 883.0 ... 1.619479 SH509 SH
30 2025-06-12 CU 79101.67 ... -0.005331 cu2507 cu
31 2025-06-12 AL 20420.0 ... -0.003918 al2507 al
32 2025-06-12 ZN 22304.0 ... -0.011164 zn2507 zn
33 2025-06-12 PB 16768.75 ... 0.007827 pb2507 pb
34 2025-06-12 NI 122066.67 ... -0.01308 ni2507 ni
35 2025-06-12 SN 265225.0 ... -0.002168 sn2507 sn
36 2025-06-12 AU 774.63 ... 0.008172 au2508 au
37 2025-06-12 AG 8886.67 ... -0.005927 ag2508 ag
38 2025-06-12 RB 3095.89 ... -0.039049 rb2510 rb
39 2025-06-12 WR 3257.5 ... 0.030852 wr2601 wr
40 2025-06-12 HC 3176.67 ... -0.027283 hc2510 hc
41 2025-06-12 FU 5287.5 ... -0.436028 fu2509 fu
42 2025-06-12 BU 3620.0 ... -0.030939 bu2509 bu
43 2025-06-12 RU 13458.33 ... 0.023158 ru2509 ru
44 2025-06-12 SP 6216.67 ... -0.157427 sp2509 sp
45 2025-06-12 SS 13012.5 ... -0.033237 ss2508 ss
46 2025-06-12 BR 11650.0 ... -0.053648 br2508 br
47 2025-06-12 SI 8620.0 ... -0.138051 SI2509 si
48 2025-06-12 LC 60633.33 ... 0.003738 LC2509 lc
[49 rows x 15 columns]
2025-06-17 23:48:13,616 - future_1d - INFO - save future_spot 2025-06-12 add
2025-06-17 23:48:13,620 - future_1d - INFO - 9
date 2025-06-12
variety JM
spot_price 1253.75
near_contract jm2506
near_contract_price 680.0
dominant_contract jm2509
dominant_contract_price 774.0
near_month 2506
dominant_month 2509
near_basis -573.75
dom_basis -479.75
near_basis_rate -0.4576
dom_basis_rate -0.3827
symbol jm2509
comd jm
created_at 2025-06-17 23:48:13.574721
updated_at 2025-06-17 23:48:13.575268
2025-06-17 23:48:17,330 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-13, end_day=2025-06-13) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-13 C 2334.29 ... 0.015298 c2507 c
1 2025-06-13 A 4295.0 ... -0.017928 a2509 a
2 2025-06-13 M 2994.0 ... 0.018036 m2509 m
3 2025-06-13 Y 8064.0 ... -0.036458 y2509 y
4 2025-06-13 P 8528.0 ... -0.04667 p2509 p
5 2025-06-13 JD 2790.0 ... 0.266308 jd2508 jd
6 2025-06-13 L 7396.67 ... -0.025102 l2509 l
7 2025-06-13 V 4656.0 ... 0.040163 v2509 v
8 2025-06-13 PP 7403.33 ... -0.047456 pp2509 pp
9 2025-06-13 JM 1228.75 ... -0.370498 jm2509 jm
10 2025-06-13 I 737.0 ... -0.046133 i2509 i
11 2025-06-13 EG 4535.0 ... -0.043881 eg2509 eg
12 2025-06-13 EB 8068.0 ... -0.056396 eb2507 eb
13 2025-06-13 PG 4822.5 ... -0.131156 pg2508 pg
14 2025-06-13 LH 14120.0 ... -0.024079 lh2509 lh
15 2025-06-13 CF 14831.17 ... -0.092115 CF509 CF
16 2025-06-13 SR 6050.0 ... -0.067438 SR509 SR
17 2025-06-13 TA 4932.75 ... -0.02975 TA509 TA
18 2025-06-13 OI 9473.33 ... -0.01798 OI509 OI
19 2025-06-13 MA 2484.0 ... -0.042673 MA509 MA
20 2025-06-13 FG 1104.0 ... -0.113225 FG509 FG
21 2025-06-13 RM 2606.67 ... 0.025446 RM509 RM
22 2025-06-13 SF 5048.57 ... 0.027222 SF509 SF
23 2025-06-13 SM 5476.0 ... -0.003652 SM509 SM
24 2025-06-13 CY 23725.0 ... -0.168599 CY509 CY
25 2025-06-13 UR 1796.0 ... -0.07294 UR509 UR
26 2025-06-13 SA 1370.0 ... -0.150365 SA509 SA
27 2025-06-13 PF 6640.21 ... -0.023826 PF508 PF
28 2025-06-13 PX 7000.0 ... -0.032571 PX509 PX
29 2025-06-13 SH 883.0 ... 1.586636 SH509 SH
30 2025-06-13 CU 78933.33 ... -0.006757 cu2507 cu
31 2025-06-13 AL 20740.0 ... -0.015188 al2507 al
32 2025-06-13 ZN 22246.0 ... -0.013306 zn2507 zn
33 2025-06-13 PB 16850.0 ... 0.005935 pb2507 pb
34 2025-06-13 NI 121800.0 ... -0.014532 ni2507 ni
35 2025-06-13 SN 265562.5 ... -0.00498 sn2507 sn
36 2025-06-13 AU 793.04 ... -0.000101 au2508 au
37 2025-06-13 AG 8833.33 ... -0.001735 ag2508 ag
38 2025-06-13 RB 3055.0 ... -0.030769 rb2510 rb
39 2025-06-13 WR 3237.5 ... 0.03722 wr2601 wr
40 2025-06-13 HC 3166.67 ... -0.030212 hc2510 hc
41 2025-06-13 FU 5350.0 ... -0.407664 fu2509 fu
42 2025-06-13 BU 3696.67 ... -0.015601 bu2509 bu
43 2025-06-13 RU 13758.33 ... 0.004119 ru2509 ru
44 2025-06-13 SP 6183.33 ... -0.158382 sp2509 sp
45 2025-06-13 SS 12962.5 ... -0.031051 ss2508 ss
46 2025-06-13 BR 11750.0 ... -0.051489 br2508 br
47 2025-06-13 SI 8620.0 ... -0.148492 SI2509 si
48 2025-06-13 LC 60700.0 ... -0.008237 LC2509 lc
[49 rows x 15 columns]
2025-06-17 23:48:17,516 - future_1d - INFO - save future_spot 2025-06-13 add
2025-06-17 23:48:17,520 - future_1d - INFO - 9
date 2025-06-13
variety JM
spot_price 1228.75
near_contract jm2506
near_contract_price 680.0
dominant_contract jm2509
dominant_contract_price 773.5
near_month 2506
dominant_month 2509
near_basis -548.75
dom_basis -455.25
near_basis_rate -0.4466
dom_basis_rate -0.3705
symbol jm2509
comd jm
created_at 2025-06-17 23:48:17.477042
updated_at 2025-06-17 23:48:17.477414
2025-06-17 23:48:23,472 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-16, end_day=2025-06-16) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-16 C 2335.71 ... 0.02624 c2509 c
1 2025-06-16 A 4295.0 ... -0.011409 a2509 a
2 2025-06-16 M 3002.0 ... 0.012325 m2509 m
3 2025-06-16 Y 8224.0 ... -0.036235 y2509 y
4 2025-06-16 P 8804.0 ... -0.050659 p2509 p
5 2025-06-16 JD 2775.0 ... 0.290811 jd2508 jd
6 2025-06-16 L 7438.33 ... -0.021286 l2509 l
7 2025-06-16 V 4620.0 ... 0.044805 v2509 v
8 2025-06-16 PP 7403.33 ... -0.040027 pp2509 pp
9 2025-06-16 JM 1228.75 ... -0.361953 jm2509 jm
10 2025-06-16 I 736.56 ... -0.050315 i2509 i
11 2025-06-16 EG 4530.0 ... -0.043488 eg2509 eg
12 2025-06-16 EB 8230.0 ... -0.076185 eb2507 eb
13 2025-06-16 PG 4885.0 ... -0.125281 pg2508 pg
14 2025-06-16 LH 14130.0 ... -0.023355 lh2509 lh
15 2025-06-16 CF 14810.0 ... -0.087441 CF509 CF
16 2025-06-16 SR 6050.0 ... -0.065785 SR509 SR
17 2025-06-16 TA 5008.25 ... -0.046373 TA509 TA
18 2025-06-16 OI 9656.67 ... -0.022437 OI509 OI
19 2025-06-16 MA 2597.0 ... -0.058144 MA509 MA
20 2025-06-16 FG 1104.0 ... -0.115942 FG509 FG
21 2025-06-16 RM 2591.67 ... 0.026751 RM509 RM
22 2025-06-16 SF 5054.29 ... 0.03239 SF509 SF
23 2025-06-16 SM 5480.0 ... 0.007664 SM509 SM
24 2025-06-16 CY 23725.0 ... -0.166913 CY509 CY
25 2025-06-16 UR 1804.0 ... -0.054324 UR509 UR
26 2025-06-16 SA 1370.0 ... -0.151095 SA509 SA
27 2025-06-16 PF 6646.04 ... -0.022275 PF508 PF
28 2025-06-16 PX 7000.0 ... -0.032571 PX509 PX
29 2025-06-16 SH 877.0 ... 1.574686 SH509 SH
30 2025-06-16 CU 78610.0 ... -0.003944 cu2507 cu
31 2025-06-16 AL 20636.67 ... -0.011953 al2507 al
32 2025-06-16 ZN 22002.0 ... -0.009181 zn2507 zn
33 2025-06-16 PB 16812.5 ... 0.006394 pb2507 pb
34 2025-06-16 NI 120875.0 ... -0.009969 ni2507 ni
35 2025-06-16 SN 265350.0 ... -0.00309 sn2507 sn
36 2025-06-16 AU 793.47 ... 0.004096 au2508 au
37 2025-06-16 AG 8792.33 ... 0.003602 ag2508 ag
38 2025-06-16 RB 3070.0 ... -0.030619 rb2510 rb
39 2025-06-16 WR 3237.5 ... 0.020541 wr2510 wr
40 2025-06-16 HC 3170.0 ... -0.025552 hc2510 hc
41 2025-06-16 FU 5350.0 ... -0.393271 fu2509 fu
42 2025-06-16 BU 3716.67 ... -0.019283 bu2509 bu
43 2025-06-16 RU 13768.33 ... 0.004479 ru2509 ru
44 2025-06-16 SP 6183.33 ... -0.157412 sp2509 sp
45 2025-06-16 SS 12912.5 ... -0.028848 ss2508 ss
46 2025-06-16 BR 11810.0 ... -0.045301 br2508 br
47 2025-06-16 SI 8620.0 ... -0.155452 SI2509 si
48 2025-06-16 LC 60700.0 ... -0.021087 LC2509 lc
[49 rows x 15 columns]
2025-06-17 23:48:23,724 - future_1d - INFO - save future_spot 2025-06-16 add
2025-06-17 23:48:23,732 - future_1d - INFO - 0 ... 4
date 2025-06-16 ... 2025-06-16
variety C ... P
spot_price 2335.71 ... 8804.0
near_contract c2507 ... p2506
near_contract_price 2369.0 ... 8606.0
dominant_contract c2509 ... p2509
dominant_contract_price 2397.0 ... 8358.0
near_month 2507 ... 2506
dominant_month 2509 ... 2509
near_basis 33.29 ... -198.0
dom_basis 61.29 ... -446.0
near_basis_rate 0.0143 ... -0.0225
dom_basis_rate 0.0262 ... -0.0507
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-17 23:48:23.606447 ... 2025-06-17 23:48:23.606447
updated_at 2025-06-17 23:48:23.606844 ... 2025-06-17 23:48:23.606844
[17 rows x 5 columns]
2025-06-17 23:48:28,432 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-17, end_day=2025-06-17) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-17 C 2335.71 ... 0.024528 c2509 c
1 2025-06-17 A 4295.0 ... -0.013737 a2509 a
2 2025-06-17 M 2998.0 ... 0.021014 m2509 m
3 2025-06-17 Y 8234.0 ... -0.032305 y2509 y
4 2025-06-17 P 8848.0 ... -0.044304 p2509 p
5 2025-06-17 JD 2800.0 ... 0.268929 jd2508 jd
6 2025-06-17 L 7471.67 ... -0.023779 l2509 l
7 2025-06-17 V 4649.0 ... 0.040654 v2509 v
8 2025-06-17 PP 7461.67 ... -0.047532 pp2509 pp
9 2025-06-17 JM 1221.25 ... -0.349028 jm2509 jm
10 2025-06-17 I 734.22 ... -0.047969 i2509 i
11 2025-06-17 EG 4526.67 ... -0.03461 eg2509 eg
12 2025-06-17 EB 8230.0 ... -0.09271 eb2507 eb
13 2025-06-17 PG 4885.0 ... -0.121801 pg2508 pg
14 2025-06-17 LH 14180.0 ... -0.02574 lh2509 lh
15 2025-06-17 CF 14846.5 ... -0.090695 CF509 CF
16 2025-06-17 SR 6060.0 ... -0.063861 SR509 SR
17 2025-06-17 TA 5045.0 ... -0.058474 TA509 TA
18 2025-06-17 OI 9735.0 ... -0.017874 OI509 OI
19 2025-06-17 MA 2646.0 ... -0.078609 MA509 MA
20 2025-06-17 FG 1104.0 ... -0.115942 FG509 FG
21 2025-06-17 RM 2611.67 ... 0.022334 RM509 RM
22 2025-06-17 SF 5054.29 ... 0.043074 SF509 SF
23 2025-06-17 SM 5502.0 ... 0.008361 SM509 SM
24 2025-06-17 CY 23575.0 ... -0.162248 CY509 CY
25 2025-06-17 UR 1820.0 ... -0.032967 UR509 UR
26 2025-06-17 SA 1370.0 ... -0.149635 SA509 SA
27 2025-06-17 PF 6666.25 ... -0.026739 PF508 PF
28 2025-06-17 PX 7000.0 ... -0.038571 PX509 PX
29 2025-06-17 SH 871.0 ... 1.615385 SH509 SH
30 2025-06-17 CU 78740.0 ... -0.002667 cu2507 cu
31 2025-06-17 AL 20633.33 ... -0.011066 al2507 al
32 2025-06-17 ZN 22008.0 ... -0.006043 zn2507 zn
33 2025-06-17 PB 16800.0 ... 0.00744 pb2507 pb
34 2025-06-17 NI 120008.33 ... -0.008569 ni2507 ni
35 2025-06-17 SN 264275.0 ... -0.000057 sn2507 sn
36 2025-06-17 AU 782.36 ... 0.005982 au2508 au
37 2025-06-17 AG 8805.67 ... 0.003558 ag2508 ag
38 2025-06-17 RB 3062.33 ... -0.026232 rb2510 rb
39 2025-06-17 WR 3252.5 ... 0.02844 wr2601 wr
40 2025-06-17 HC 3173.33 ... -0.025629 hc2510 hc
41 2025-06-17 FU 5425.0 ... -0.402212 fu2509 fu
42 2025-06-17 BU 3710.0 ... -0.022372 bu2509 bu
43 2025-06-17 RU 13718.33 ... 0.009963 ru2509 ru
44 2025-06-17 SP 6140.0 ... -0.151466 sp2509 sp
45 2025-06-17 SS 12912.5 ... -0.031171 ss2508 ss
46 2025-06-17 BR 11870.0 ... -0.046335 br2508 br
47 2025-06-17 SI 8620.0 ... -0.147912 SI2509 si
48 2025-06-17 LC 60366.67 ... -0.009056 LC2509 lc
[49 rows x 15 columns]
2025-06-17 23:48:28,615 - future_1d - INFO - save future_spot 2025-06-17 add
2025-06-17 23:48:28,622 - future_1d - INFO - 0 ... 4
date 2025-06-17 ... 2025-06-17
variety C ... P
spot_price 2335.71 ... 8848.0
near_contract c2507 ... p2507
near_contract_price 2359.0 ... 8574.0
dominant_contract c2509 ... p2509
dominant_contract_price 2393.0 ... 8456.0
near_month 2507 ... 2507
dominant_month 2509 ... 2509
near_basis 23.29 ... -274.0
dom_basis 57.29 ... -392.0
near_basis_rate 0.01 ... -0.031
dom_basis_rate 0.0245 ... -0.0443
symbol c2509 ... p2509
comd c ... p
created_at 2025-06-17 23:48:28.566703 ... 2025-06-17 23:48:28.566703
updated_at 2025-06-17 23:48:28.567146 ... 2025-06-17 23:48:28.567146
[17 rows x 5 columns]