=========================================================================
2025-05-06 16:40:48 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-05-06 16:40:49,999 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-06 16:40:50,349 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-25, end_day=2025-04-25) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-25 C 2220.0 ... 0.050901 c2507 c
1 2025-04-25 A 4245.0 ... 0.005418 a2507 a
2 2025-04-25 M 3580.0 ... -0.150559 m2509 m
3 2025-04-25 Y 8236.0 ... -0.036425 y2509 y
4 2025-04-25 P 9176.0 ... -0.089582 p2509 p
5 2025-04-25 JD 3490.0 ... -0.139542 jd2506 jd
6 2025-04-25 L 7566.67 ... -0.055331 l2509 l
7 2025-04-25 V 4714.0 ... 0.055367 v2509 v
8 2025-04-25 PP 7465.0 ... -0.048627 pp2509 pp
9 2025-04-25 I 783.22 ... -0.088379 i2509 i
10 2025-04-25 EG 4350.0 ... -0.042069 eg2509 eg
11 2025-04-25 EB 7838.0 ... -0.080505 eb2506 eb
12 2025-04-25 PG 4977.5 ... -0.114817 pg2506 pg
13 2025-04-25 LH 14880.0 ... -0.050067 lh2509 lh
14 2025-04-25 CF 14241.0 ... -0.086441 CF509 CF
15 2025-04-25 SR 6167.5 ... -0.032023 SR509 SR
16 2025-04-25 TA 4493.75 ... -0.021752 TA509 TA
17 2025-04-25 OI 9600.0 ... -0.01375 OI509 OI
18 2025-04-25 MA 2417.5 ... -0.053568 MA509 MA
19 2025-04-25 FG 1246.4 ... -0.094994 FG509 FG
20 2025-04-25 RM 2666.67 ... 0.013624 RM509 RM
21 2025-04-25 SF 5594.29 ... 0.013533 SF506 SF
22 2025-04-25 SM 5690.0 ... 0.026011 SM509 SM
23 2025-04-25 CY 23825.0 ... -0.203778 CY507 CY
24 2025-04-25 UR 1876.67 ... -0.061103 UR509 UR
25 2025-04-25 SA 1502.5 ... -0.088852 SA509 SA
26 2025-04-25 PF 6294.17 ... -0.038793 PF506 PF
27 2025-04-25 PX 6800.0 ... -0.086765 PX509 PX
28 2025-04-25 SH 822.0 ... 1.993917 SH509 SH
29 2025-04-25 CU 78158.33 ... -0.006632 cu2506 cu
30 2025-04-25 AL 20083.33 ... -0.00639 al2506 al
31 2025-04-25 ZN 23186.0 ... -0.01902 zn2506 zn
32 2025-04-25 PB 16981.25 ... 0.001987 pb2506 pb
33 2025-04-25 NI 126908.33 ... -0.009285 ni2506 ni
34 2025-04-25 SN 263012.5 ... -0.002899 sn2506 sn
35 2025-04-25 AU 792.98 ... -0.001967 au2506 au
36 2025-04-25 AG 8306.0 ... -0.001445 ag2506 ag
37 2025-04-25 RB 3151.67 ... -0.013222 rb2510 rb
38 2025-04-25 WR 3330.0 ... -0.004805 wr2505 wr
39 2025-04-25 HC 3270.0 ... -0.018349 hc2510 hc
40 2025-04-25 FU 5487.5 ... -0.451116 fu2507 fu
41 2025-04-25 BU 3560.0 ... -0.042978 bu2506 bu
42 2025-04-25 RU 14468.33 ... 0.02085 ru2509 ru
43 2025-04-25 SP 6366.67 ... -0.152775 sp2507 sp
44 2025-04-25 SS 13155.0 ... -0.032687 ss2506 ss
45 2025-04-25 BR 11840.0 ... -0.04223 br2506 br
46 2025-04-25 SI 10040.0 ... -0.117032 SI2506 si
47 2025-04-25 LC 69200.0 ... -0.011561 LC2507 lc
[48 rows x 15 columns]
2025-05-06 16:40:50,517 - future_1d - INFO - save future_spot 2025-04-25 completed
2025-05-06 16:40:55,558 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-28, end_day=2025-04-28) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-28 C 2232.86 ... 0.053805 c2507 c
1 2025-04-28 A 4245.0 ... -0.005654 a2507 a
2 2025-04-28 M 3523.33 ... -0.1491 m2509 m
3 2025-04-28 Y 8106.0 ... -0.032075 y2509 y
4 2025-04-28 P 8920.0 ... -0.073767 p2509 p
5 2025-04-28 JD 3400.0 ... -0.121176 jd2506 jd
6 2025-04-28 L 7571.67 ... -0.053709 l2509 l
7 2025-04-28 V 4695.0 ... 0.063898 v2509 v
8 2025-04-28 PP 7481.67 ... -0.049544 pp2509 pp
9 2025-04-28 I 778.56 ... -0.091913 i2509 i
10 2025-04-28 EG 4343.33 ... -0.035993 eg2509 eg
11 2025-04-28 EB 7748.0 ... -0.080924 eb2506 eb
12 2025-04-28 PG 4967.5 ... -0.115249 pg2506 pg
13 2025-04-28 LH 14870.0 ... -0.047747 lh2509 lh
14 2025-04-28 CF 14273.33 ... -0.091312 CF509 CF
15 2025-04-28 SR 6170.0 ... -0.031605 SR509 SR
16 2025-04-28 TA 4567.5 ... -0.022222 TA509 TA
17 2025-04-28 OI 9411.67 ... -0.001452 OI509 OI
18 2025-04-28 MA 2451.25 ... -0.061703 MA509 MA
19 2025-04-28 FG 1246.4 ... -0.098203 FG509 FG
20 2025-04-28 RM 2615.0 ... 0.011472 RM509 RM
21 2025-04-28 SF 5548.57 ... 0.013594 SF506 SF
22 2025-04-28 SM 5652.0 ... 0.025832 SM509 SM
23 2025-04-28 CY 23825.0 ... -0.204197 CY507 CY
24 2025-04-28 UR 1860.0 ... -0.047312 UR509 UR
25 2025-04-28 SA 1502.5 ... -0.08619 SA509 SA
26 2025-04-28 PF 6352.92 ... -0.03383 PF506 PF
27 2025-04-28 PX 6800.0 ... -0.075294 PX509 PX
28 2025-04-28 SH 809.0 ... 2.019778 SH509 SH
29 2025-04-28 CU 77535.0 ... -0.002128 cu2506 cu
30 2025-04-28 AL 19966.67 ... -0.002087 al2506 al
31 2025-04-28 ZN 22874.0 ... -0.015695 zn2506 zn
32 2025-04-28 PB 16875.0 ... 0.002963 pb2506 pb
33 2025-04-28 NI 125033.33 ... -0.005385 ni2506 ni
34 2025-04-28 SN 260175.0 ... 0.005131 sn2506 sn
35 2025-04-28 AU 778.93 ... 0.003222 au2506 au
36 2025-04-28 AG 8168.33 ... 0.004489 ag2506 ag
37 2025-04-28 RB 3204.56 ... -0.02077 rb2510 rb
38 2025-04-28 WR 3397.5 ... -0.032524 wr2505 wr
39 2025-04-28 HC 3310.0 ... -0.017825 hc2510 hc
40 2025-04-28 FU 5475.0 ... -0.450776 fu2507 fu
41 2025-04-28 BU 3615.0 ... -0.056155 bu2506 bu
42 2025-04-28 RU 14488.33 ... 0.018061 ru2509 ru
43 2025-04-28 SP 6366.67 ... -0.157487 sp2507 sp
44 2025-04-28 SS 13125.0 ... -0.032381 ss2506 ss
45 2025-04-28 BR 11950.0 ... -0.045188 br2506 br
46 2025-04-28 SI 10040.0 ... -0.125996 SI2506 si
47 2025-04-28 LC 69100.0 ... -0.025181 LC2507 lc
[48 rows x 15 columns]
2025-05-06 16:40:55,711 - future_1d - INFO - save future_spot 2025-04-28 completed
2025-05-06 16:41:00,701 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-29, end_day=2025-04-29) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-29 C 2244.29 ... 0.051558 c2507 c
1 2025-04-29 A 4245.0 ... -0.015312 a2507 a
2 2025-04-29 M 3485.0 ... -0.145768 m2509 m
3 2025-04-29 Y 8086.0 ... -0.033144 y2509 y
4 2025-04-29 P 8800.0 ... -0.0725 p2509 p
5 2025-04-29 JD 3400.0 ... -0.121765 jd2506 jd
6 2025-04-29 L 7553.33 ... -0.056178 l2509 l
7 2025-04-29 V 4692.0 ... 0.056692 v2509 v
8 2025-04-29 PP 7481.67 ... -0.052618 pp2509 pp
9 2025-04-29 I 779.44 ... -0.090373 i2509 i
10 2025-04-29 EG 4328.33 ... -0.033345 eg2509 eg
11 2025-04-29 EB 7660.0 ... -0.075849 eb2506 eb
12 2025-04-29 PG 4967.5 ... -0.117665 pg2506 pg
13 2025-04-29 LH 14830.0 ... -0.057316 lh2509 lh
14 2025-04-29 CF 14261.83 ... -0.097591 CF509 CF
15 2025-04-29 SR 6170.0 ... -0.040681 SR509 SR
16 2025-04-29 TA 4565.0 ... -0.026068 TA509 TA
17 2025-04-29 OI 9401.67 ... -0.00741 OI509 OI
18 2025-04-29 MA 2437.5 ... -0.062154 MA509 MA
19 2025-04-29 FG 1246.4 ... -0.105424 FG509 FG
20 2025-04-29 RM 2595.0 ... 0.004624 RM509 RM
21 2025-04-29 SF 5548.57 ... 0.015036 SF506 SF
22 2025-04-29 SM 5652.0 ... 0.024062 SM509 SM
23 2025-04-29 CY 23775.0 ... -0.206519 CY507 CY
24 2025-04-29 UR 1861.67 ... -0.061058 UR509 UR
25 2025-04-29 SA 1502.5 ... -0.087521 SA509 SA
26 2025-04-29 PF 6359.17 ... -0.028804 PF506 PF
27 2025-04-29 PX 6800.0 ... -0.082941 PX509 PX
28 2025-04-29 SH 807.0 ... 2.007435 SH509 SH
29 2025-04-29 CU 78101.67 ... -0.006551 cu2506 cu
30 2025-04-29 AL 20033.33 ... -0.005657 al2506 al
31 2025-04-29 ZN 22970.0 ... -0.018938 zn2506 zn
32 2025-04-29 PB 16887.5 ... 0.003109 pb2506 pb
33 2025-04-29 NI 125616.67 ... -0.009049 ni2506 ni
34 2025-04-29 SN 262175.0 ... -0.003681 sn2506 sn
35 2025-04-29 AU 784.17 ... 0.005904 au2508 au
36 2025-04-29 AG 8225.33 ... -0.001134 ag2506 ag
37 2025-04-29 RB 3186.89 ... -0.024441 rb2510 rb
38 2025-04-29 WR 3387.5 ... -0.029963 wr2505 wr
39 2025-04-29 HC 3273.33 ... -0.016903 hc2510 hc
40 2025-04-29 FU 5462.5 ... -0.454279 fu2507 fu
41 2025-04-29 BU 3650.0 ... -0.05726 bu2506 bu
42 2025-04-29 RU 14408.33 ... 0.020243 ru2509 ru
43 2025-04-29 SP 6366.67 ... -0.175079 sp2507 sp
44 2025-04-29 SS 13050.0 ... -0.02682 ss2506 ss
45 2025-04-29 BR 11950.0 ... -0.046444 br2507 br
46 2025-04-29 SI 9960.0 ... -0.132028 SI2506 si
47 2025-04-29 LC 68966.67 ... -0.036056 LC2507 lc
[48 rows x 15 columns]
2025-05-06 16:41:00,854 - future_1d - INFO - save future_spot 2025-04-29 completed
2025-05-06 16:41:10,131 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-30, end_day=2025-04-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-30 C 2252.86 ... 0.049777 c2507 c
1 2025-04-30 A 4245.0 ... -0.014841 a2507 a
2 2025-04-30 M 3476.67 ... -0.152925 m2509 m
3 2025-04-30 Y 8126.0 ... -0.040364 y2509 y
4 2025-04-30 P 8760.0 ... -0.074658 p2509 p
5 2025-04-30 JD 3375.0 ... -0.125333 jd2506 jd
6 2025-04-30 L 7553.33 ... -0.059885 l2509 l
7 2025-04-30 V 4679.0 ... 0.053644 v2509 v
8 2025-04-30 PP 7481.67 ... -0.056093 pp2509 pp
9 2025-04-30 I 778.11 ... -0.094601 i2509 i
10 2025-04-30 EG 4331.67 ... -0.035707 eg2509 eg
11 2025-04-30 EB 7680.0 ... -0.082292 eb2506 eb
12 2025-04-30 PG 4980.0 ... -0.117871 pg2506 pg
13 2025-04-30 LH 14830.0 ... -0.061699 lh2509 lh
14 2025-04-30 CF 14208.83 ... -0.100911 CF509 CF
15 2025-04-30 SR 6160.0 ... -0.043994 SR509 SR
16 2025-04-30 TA 4584.38 ... -0.034111 TA509 TA
17 2025-04-30 OI 9378.33 ... -0.011338 OI509 OI
18 2025-04-30 MA 2440.0 ... -0.070902 MA509 MA
19 2025-04-30 FG 1246.4 ... -0.126284 FG509 FG
20 2025-04-30 RM 2531.67 ... 0.012375 RM509 RM
21 2025-04-30 SF 5548.57 ... 0.024048 SF507 SF
22 2025-04-30 SM 5640.0 ... 0.01383 SM509 SM
23 2025-04-30 CY 23775.0 ... -0.209674 CY507 CY
24 2025-04-30 UR 1875.0 ... -0.016 UR509 UR
25 2025-04-30 SA 1502.5 ... -0.097504 SA509 SA
26 2025-04-30 PF 6351.46 ... -0.037072 PF507 PF
27 2025-04-30 PX 6800.0 ... -0.087647 PX509 PX
28 2025-04-30 SH 807.0 ... 2.042131 SH509 SH
29 2025-04-30 CU 77996.67 ... -0.026753 cu2503 cu
30 2025-04-30 AL 20073.33 ... 0.008054 al2503 al
31 2025-04-30 ZN 22904.0 ... 0.019473 zn2503 zn
32 2025-04-30 PB 16812.5 ... 0.016506 pb2503 pb
33 2025-04-30 NI 125175.0 ... 0.001318 ni2503 ni
34 2025-04-30 SN 261175.0 ... -0.014875 sn2503 sn
35 2025-04-30 AU 780.65 ... -0.139435 au2504 au
36 2025-04-30 AG 8204.33 ... -0.014301 ag2504 ag
37 2025-04-30 RB 3183.22 ... 0.049252 rb2505 rb
38 2025-04-30 WR 3377.5 ... 0.057291 wr2505 wr
39 2025-04-30 HC 3276.67 ... 0.048015 hc2505 hc
40 2025-04-30 FU 5462.5 ... -0.371167 fu2505 fu
41 2025-04-30 BU 3647.5 ... 0.033859 bu2503 bu
42 2025-04-30 RU 14308.33 ... 0.200699 ru2505 ru
43 2025-04-30 SP 6250.0 ... -0.01312 sp2503 sp
44 2025-04-30 SS 13050.0 ... 0.027203 ss2503 ss
45 2025-04-30 BR 11950.0 ... 0.2 br2504 br
46 2025-04-30 SI 9880.0 ... -0.135121 SI2506 si
47 2025-04-30 LC 68933.33 ... -0.038781 LC2507 lc
[48 rows x 15 columns]
2025-05-06 16:41:10,285 - future_1d - INFO - save future_spot 2025-04-30 completed
2025-05-06 16:41:20,197 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-06, end_day=2025-05-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-06 C 2272.86 ... 0.039659 c2507 c
1 2025-05-06 A 4245.0 ... -0.01649 a2507 a
2 2025-05-06 M 3270.0 ... -0.106728 m2509 m
3 2025-05-06 Y 8056.0 ... -0.037736 y2509 y
4 2025-05-06 P 8760.0 ... -0.088584 p2509 p
5 2025-05-06 JD 3375.0 ... -0.141037 jd2506 jd
6 2025-05-06 L 7516.67 ... -0.067406 l2509 l
7 2025-05-06 V 4653.0 ... 0.05072 v2509 v
8 2025-05-06 PP 7481.67 ... -0.063712 pp2509 pp
9 2025-05-06 I 781.44 ... -0.09718 i2509 i
10 2025-05-06 EG 4331.67 ... -0.045403 eg2509 eg
11 2025-05-06 EB 7650.0 ... -0.089542 eb2506 eb
12 2025-05-06 PG 4967.5 ... -0.114444 pg2506 pg
13 2025-05-06 LH 14820.0 ... -0.060729 lh2509 lh
14 2025-05-06 CF 14138.67 ... -0.095742 CF509 CF
15 2025-05-06 SR 6156.67 ... -0.043152 SR509 SR
16 2025-05-06 TA 4529.17 ... -0.037793 TA509 TA
17 2025-05-06 OI 9330.0 ... -0.009432 OI509 OI
18 2025-05-06 MA 2428.75 ... -0.07895 MA509 MA
19 2025-05-06 FG 1246.4 ... -0.139121 FG509 FG
20 2025-05-06 RM 2511.67 ... 0.017251 RM509 RM
21 2025-05-06 SF 5548.57 ... -0.000463 SF507 SF
22 2025-05-06 SM 5610.0 ... 0.001783 SM509 SM
23 2025-05-06 CY 23775.0 ... -0.209674 CY507 CY
24 2025-05-06 UR 1893.33 ... -0.013379 UR509 UR
25 2025-05-06 SA 1502.5 ... -0.111481 SA509 SA
26 2025-05-06 PF 6313.75 ... -0.043358 PF507 PF
27 2025-05-06 PX 6600.0 ... -0.073333 PX509 PX
28 2025-05-06 SH 807.0 ... 2.090458 SH509 SH
29 2025-05-06 CU 78233.33 ... -0.007201 cu2506 cu
30 2025-05-06 AL 20073.33 ... -0.010129 al2506 al
31 2025-05-06 ZN 22864.0 ... -0.019419 zn2506 zn
32 2025-05-06 PB 16706.25 ... -0.000973 pb2506 pb
33 2025-05-06 NI 125641.67 ... -0.008689 ni2506 ni
34 2025-05-06 SN 260362.5 ... -0.000163 sn2506 sn
35 2025-05-06 AU 780.65 ... 0.020329 au2508 au
36 2025-05-06 AG 8204.33 ... 0.004104 ag2506 ag
37 2025-05-06 RB 3176.33 ... -0.02655 rb2510 rb
38 2025-05-06 WR 3377.5 ... 0.02117 wr2510 wr
39 2025-05-06 HC 3263.33 ... -0.017568 hc2510 hc
40 2025-05-06 FU 5425.0 ... -0.478341 fu2507 fu
41 2025-05-06 BU 3590.0 ... -0.068802 bu2506 bu
42 2025-05-06 RU 14593.33 ... 0.014847 ru2509 ru
43 2025-05-06 SP 6250.0 ... -0.18816 sp2507 sp
44 2025-05-06 SS 13062.5 ... -0.027751 ss2506 ss
45 2025-05-06 BR 11950.0 ... -0.053556 br2507 br
46 2025-05-06 SI 9780.0 ... -0.144172 SI2506 si
47 2025-05-06 LC 68733.33 ... -0.047624 LC2507 lc
[48 rows x 15 columns]
2025-05-06 16:41:20,368 - future_1d - INFO - save future_spot 2025-05-06 add
2025-05-06 16:41:20,375 - future_1d - INFO - 0 ... 4
date 2025-05-06 ... 2025-05-06
variety C ... P
spot_price 2272.86 ... 8760.0
near_contract c2505 ... p2505
near_contract_price 2320.0 ... 8392.0
dominant_contract c2507 ... p2509
dominant_contract_price 2363.0 ... 7984.0
near_month 2505 ... 2505
dominant_month 2507 ... 2509
near_basis 47.14 ... -368.0
dom_basis 90.14 ... -776.0
near_basis_rate 0.0207 ... -0.042
dom_basis_rate 0.0397 ... -0.0886
symbol c2507 ... p2509
comd c ... p
created_at 2025-05-06 16:41:20.327538 ... 2025-05-06 16:41:20.327538
updated_at 2025-05-06 16:41:20.327960 ... 2025-05-06 16:41:20.327960
[17 rows x 5 columns]
=========================================================================
2025-05-06 18:40:32 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-05-06 18:40:34,508 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-05-06 18:40:34,958 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-25, end_day=2025-04-25) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-25 C 2220.0 ... 0.050901 c2507 c
1 2025-04-25 A 4245.0 ... 0.005418 a2507 a
2 2025-04-25 M 3580.0 ... -0.150559 m2509 m
3 2025-04-25 Y 8236.0 ... -0.036425 y2509 y
4 2025-04-25 P 9176.0 ... -0.089582 p2509 p
5 2025-04-25 JD 3490.0 ... -0.139542 jd2506 jd
6 2025-04-25 L 7566.67 ... -0.055331 l2509 l
7 2025-04-25 V 4714.0 ... 0.055367 v2509 v
8 2025-04-25 PP 7465.0 ... -0.048627 pp2509 pp
9 2025-04-25 I 783.22 ... -0.088379 i2509 i
10 2025-04-25 EG 4350.0 ... -0.042069 eg2509 eg
11 2025-04-25 EB 7838.0 ... -0.080505 eb2506 eb
12 2025-04-25 PG 4977.5 ... -0.114817 pg2506 pg
13 2025-04-25 LH 14880.0 ... -0.050067 lh2509 lh
14 2025-04-25 CF 14241.0 ... -0.086441 CF509 CF
15 2025-04-25 SR 6167.5 ... -0.032023 SR509 SR
16 2025-04-25 TA 4493.75 ... -0.021752 TA509 TA
17 2025-04-25 OI 9600.0 ... -0.01375 OI509 OI
18 2025-04-25 MA 2417.5 ... -0.053568 MA509 MA
19 2025-04-25 FG 1246.4 ... -0.094994 FG509 FG
20 2025-04-25 RM 2666.67 ... 0.013624 RM509 RM
21 2025-04-25 SF 5594.29 ... 0.013533 SF506 SF
22 2025-04-25 SM 5690.0 ... 0.026011 SM509 SM
23 2025-04-25 CY 23825.0 ... -0.203778 CY507 CY
24 2025-04-25 UR 1876.67 ... -0.061103 UR509 UR
25 2025-04-25 SA 1502.5 ... -0.088852 SA509 SA
26 2025-04-25 PF 6294.17 ... -0.038793 PF506 PF
27 2025-04-25 PX 6800.0 ... -0.086765 PX509 PX
28 2025-04-25 SH 822.0 ... 1.993917 SH509 SH
29 2025-04-25 CU 78158.33 ... -0.006632 cu2506 cu
30 2025-04-25 AL 20083.33 ... -0.00639 al2506 al
31 2025-04-25 ZN 23186.0 ... -0.01902 zn2506 zn
32 2025-04-25 PB 16981.25 ... 0.001987 pb2506 pb
33 2025-04-25 NI 126908.33 ... -0.009285 ni2506 ni
34 2025-04-25 SN 263012.5 ... -0.002899 sn2506 sn
35 2025-04-25 AU 792.98 ... -0.001967 au2506 au
36 2025-04-25 AG 8306.0 ... -0.001445 ag2506 ag
37 2025-04-25 RB 3151.67 ... -0.013222 rb2510 rb
38 2025-04-25 WR 3330.0 ... -0.004805 wr2505 wr
39 2025-04-25 HC 3270.0 ... -0.018349 hc2510 hc
40 2025-04-25 FU 5487.5 ... -0.451116 fu2507 fu
41 2025-04-25 BU 3560.0 ... -0.042978 bu2506 bu
42 2025-04-25 RU 14468.33 ... 0.02085 ru2509 ru
43 2025-04-25 SP 6366.67 ... -0.152775 sp2507 sp
44 2025-04-25 SS 13155.0 ... -0.032687 ss2506 ss
45 2025-04-25 BR 11840.0 ... -0.04223 br2506 br
46 2025-04-25 SI 10040.0 ... -0.117032 SI2506 si
47 2025-04-25 LC 69200.0 ... -0.011561 LC2507 lc
[48 rows x 15 columns]
2025-05-06 18:40:35,133 - future_1d - INFO - save future_spot 2025-04-25 completed
2025-05-06 18:40:42,221 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-28, end_day=2025-04-28) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-28 C 2232.86 ... 0.053805 c2507 c
1 2025-04-28 A 4245.0 ... -0.005654 a2507 a
2 2025-04-28 M 3523.33 ... -0.1491 m2509 m
3 2025-04-28 Y 8106.0 ... -0.032075 y2509 y
4 2025-04-28 P 8920.0 ... -0.073767 p2509 p
5 2025-04-28 JD 3400.0 ... -0.121176 jd2506 jd
6 2025-04-28 L 7571.67 ... -0.053709 l2509 l
7 2025-04-28 V 4695.0 ... 0.063898 v2509 v
8 2025-04-28 PP 7481.67 ... -0.049544 pp2509 pp
9 2025-04-28 I 778.56 ... -0.091913 i2509 i
10 2025-04-28 EG 4343.33 ... -0.035993 eg2509 eg
11 2025-04-28 EB 7748.0 ... -0.080924 eb2506 eb
12 2025-04-28 PG 4967.5 ... -0.115249 pg2506 pg
13 2025-04-28 LH 14870.0 ... -0.047747 lh2509 lh
14 2025-04-28 CF 14273.33 ... -0.091312 CF509 CF
15 2025-04-28 SR 6170.0 ... -0.031605 SR509 SR
16 2025-04-28 TA 4567.5 ... -0.022222 TA509 TA
17 2025-04-28 OI 9411.67 ... -0.001452 OI509 OI
18 2025-04-28 MA 2451.25 ... -0.061703 MA509 MA
19 2025-04-28 FG 1246.4 ... -0.098203 FG509 FG
20 2025-04-28 RM 2615.0 ... 0.011472 RM509 RM
21 2025-04-28 SF 5548.57 ... 0.013594 SF506 SF
22 2025-04-28 SM 5652.0 ... 0.025832 SM509 SM
23 2025-04-28 CY 23825.0 ... -0.204197 CY507 CY
24 2025-04-28 UR 1860.0 ... -0.047312 UR509 UR
25 2025-04-28 SA 1502.5 ... -0.08619 SA509 SA
26 2025-04-28 PF 6352.92 ... -0.03383 PF506 PF
27 2025-04-28 PX 6800.0 ... -0.075294 PX509 PX
28 2025-04-28 SH 809.0 ... 2.019778 SH509 SH
29 2025-04-28 CU 77535.0 ... -0.002128 cu2506 cu
30 2025-04-28 AL 19966.67 ... -0.002087 al2506 al
31 2025-04-28 ZN 22874.0 ... -0.015695 zn2506 zn
32 2025-04-28 PB 16875.0 ... 0.002963 pb2506 pb
33 2025-04-28 NI 125033.33 ... -0.005385 ni2506 ni
34 2025-04-28 SN 260175.0 ... 0.005131 sn2506 sn
35 2025-04-28 AU 778.93 ... 0.003222 au2506 au
36 2025-04-28 AG 8168.33 ... 0.004489 ag2506 ag
37 2025-04-28 RB 3204.56 ... -0.02077 rb2510 rb
38 2025-04-28 WR 3397.5 ... -0.032524 wr2505 wr
39 2025-04-28 HC 3310.0 ... -0.017825 hc2510 hc
40 2025-04-28 FU 5475.0 ... -0.450776 fu2507 fu
41 2025-04-28 BU 3615.0 ... -0.056155 bu2506 bu
42 2025-04-28 RU 14488.33 ... 0.018061 ru2509 ru
43 2025-04-28 SP 6366.67 ... -0.157487 sp2507 sp
44 2025-04-28 SS 13125.0 ... -0.032381 ss2506 ss
45 2025-04-28 BR 11950.0 ... -0.045188 br2506 br
46 2025-04-28 SI 10040.0 ... -0.125996 SI2506 si
47 2025-04-28 LC 69100.0 ... -0.025181 LC2507 lc
[48 rows x 15 columns]
2025-05-06 18:40:42,374 - future_1d - INFO - save future_spot 2025-04-28 completed
2025-05-06 18:40:52,369 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-29, end_day=2025-04-29) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-29 C 2244.29 ... 0.051558 c2507 c
1 2025-04-29 A 4245.0 ... -0.015312 a2507 a
2 2025-04-29 M 3485.0 ... -0.145768 m2509 m
3 2025-04-29 Y 8086.0 ... -0.033144 y2509 y
4 2025-04-29 P 8800.0 ... -0.0725 p2509 p
5 2025-04-29 JD 3400.0 ... -0.121765 jd2506 jd
6 2025-04-29 L 7553.33 ... -0.056178 l2509 l
7 2025-04-29 V 4692.0 ... 0.056692 v2509 v
8 2025-04-29 PP 7481.67 ... -0.052618 pp2509 pp
9 2025-04-29 I 779.44 ... -0.090373 i2509 i
10 2025-04-29 EG 4328.33 ... -0.033345 eg2509 eg
11 2025-04-29 EB 7660.0 ... -0.075849 eb2506 eb
12 2025-04-29 PG 4967.5 ... -0.117665 pg2506 pg
13 2025-04-29 LH 14830.0 ... -0.057316 lh2509 lh
14 2025-04-29 CF 14261.83 ... -0.097591 CF509 CF
15 2025-04-29 SR 6170.0 ... -0.040681 SR509 SR
16 2025-04-29 TA 4565.0 ... -0.026068 TA509 TA
17 2025-04-29 OI 9401.67 ... -0.00741 OI509 OI
18 2025-04-29 MA 2437.5 ... -0.062154 MA509 MA
19 2025-04-29 FG 1246.4 ... -0.105424 FG509 FG
20 2025-04-29 RM 2595.0 ... 0.004624 RM509 RM
21 2025-04-29 SF 5548.57 ... 0.015036 SF506 SF
22 2025-04-29 SM 5652.0 ... 0.024062 SM509 SM
23 2025-04-29 CY 23775.0 ... -0.206519 CY507 CY
24 2025-04-29 UR 1861.67 ... -0.061058 UR509 UR
25 2025-04-29 SA 1502.5 ... -0.087521 SA509 SA
26 2025-04-29 PF 6359.17 ... -0.028804 PF506 PF
27 2025-04-29 PX 6800.0 ... -0.082941 PX509 PX
28 2025-04-29 SH 807.0 ... 2.007435 SH509 SH
29 2025-04-29 CU 78101.67 ... -0.006551 cu2506 cu
30 2025-04-29 AL 20033.33 ... -0.005657 al2506 al
31 2025-04-29 ZN 22970.0 ... -0.018938 zn2506 zn
32 2025-04-29 PB 16887.5 ... 0.003109 pb2506 pb
33 2025-04-29 NI 125616.67 ... -0.009049 ni2506 ni
34 2025-04-29 SN 262175.0 ... -0.003681 sn2506 sn
35 2025-04-29 AU 784.17 ... 0.005904 au2508 au
36 2025-04-29 AG 8225.33 ... -0.001134 ag2506 ag
37 2025-04-29 RB 3186.89 ... -0.024441 rb2510 rb
38 2025-04-29 WR 3387.5 ... -0.029963 wr2505 wr
39 2025-04-29 HC 3273.33 ... -0.016903 hc2510 hc
40 2025-04-29 FU 5462.5 ... -0.454279 fu2507 fu
41 2025-04-29 BU 3650.0 ... -0.05726 bu2506 bu
42 2025-04-29 RU 14408.33 ... 0.020243 ru2509 ru
43 2025-04-29 SP 6366.67 ... -0.175079 sp2507 sp
44 2025-04-29 SS 13050.0 ... -0.02682 ss2506 ss
45 2025-04-29 BR 11950.0 ... -0.046444 br2507 br
46 2025-04-29 SI 9960.0 ... -0.132028 SI2506 si
47 2025-04-29 LC 68966.67 ... -0.036056 LC2507 lc
[48 rows x 15 columns]
2025-05-06 18:40:52,523 - future_1d - INFO - save future_spot 2025-04-29 completed
2025-05-06 18:41:02,308 - future_1d - INFO - futures_spot_price_daily(start_day=2025-04-30, end_day=2025-04-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-04-30 C 2252.86 ... 0.049777 c2507 c
1 2025-04-30 A 4245.0 ... -0.014841 a2507 a
2 2025-04-30 M 3476.67 ... -0.152925 m2509 m
3 2025-04-30 Y 8126.0 ... -0.040364 y2509 y
4 2025-04-30 P 8760.0 ... -0.074658 p2509 p
5 2025-04-30 JD 3375.0 ... -0.125333 jd2506 jd
6 2025-04-30 L 7553.33 ... -0.059885 l2509 l
7 2025-04-30 V 4679.0 ... 0.053644 v2509 v
8 2025-04-30 PP 7481.67 ... -0.056093 pp2509 pp
9 2025-04-30 I 778.11 ... -0.094601 i2509 i
10 2025-04-30 EG 4331.67 ... -0.035707 eg2509 eg
11 2025-04-30 EB 7680.0 ... -0.082292 eb2506 eb
12 2025-04-30 PG 4980.0 ... -0.117871 pg2506 pg
13 2025-04-30 LH 14830.0 ... -0.061699 lh2509 lh
14 2025-04-30 CF 14208.83 ... -0.100911 CF509 CF
15 2025-04-30 SR 6160.0 ... -0.043994 SR509 SR
16 2025-04-30 TA 4584.38 ... -0.034111 TA509 TA
17 2025-04-30 OI 9378.33 ... -0.011338 OI509 OI
18 2025-04-30 MA 2440.0 ... -0.070902 MA509 MA
19 2025-04-30 FG 1246.4 ... -0.126284 FG509 FG
20 2025-04-30 RM 2531.67 ... 0.012375 RM509 RM
21 2025-04-30 SF 5548.57 ... 0.024048 SF507 SF
22 2025-04-30 SM 5640.0 ... 0.01383 SM509 SM
23 2025-04-30 CY 23775.0 ... -0.209674 CY507 CY
24 2025-04-30 UR 1875.0 ... -0.016 UR509 UR
25 2025-04-30 SA 1502.5 ... -0.097504 SA509 SA
26 2025-04-30 PF 6351.46 ... -0.037072 PF507 PF
27 2025-04-30 PX 6800.0 ... -0.087647 PX509 PX
28 2025-04-30 SH 807.0 ... 2.042131 SH509 SH
29 2025-04-30 CU 77996.67 ... -0.026753 cu2503 cu
30 2025-04-30 AL 20073.33 ... 0.008054 al2503 al
31 2025-04-30 ZN 22904.0 ... 0.019473 zn2503 zn
32 2025-04-30 PB 16812.5 ... 0.016506 pb2503 pb
33 2025-04-30 NI 125175.0 ... 0.001318 ni2503 ni
34 2025-04-30 SN 261175.0 ... -0.014875 sn2503 sn
35 2025-04-30 AU 780.65 ... -0.139435 au2504 au
36 2025-04-30 AG 8204.33 ... -0.014301 ag2504 ag
37 2025-04-30 RB 3183.22 ... 0.049252 rb2505 rb
38 2025-04-30 WR 3377.5 ... 0.057291 wr2505 wr
39 2025-04-30 HC 3276.67 ... 0.048015 hc2505 hc
40 2025-04-30 FU 5462.5 ... -0.371167 fu2505 fu
41 2025-04-30 BU 3647.5 ... 0.033859 bu2503 bu
42 2025-04-30 RU 14308.33 ... 0.200699 ru2505 ru
43 2025-04-30 SP 6250.0 ... -0.01312 sp2503 sp
44 2025-04-30 SS 13050.0 ... 0.027203 ss2503 ss
45 2025-04-30 BR 11950.0 ... 0.2 br2504 br
46 2025-04-30 SI 9880.0 ... -0.135121 SI2506 si
47 2025-04-30 LC 68933.33 ... -0.038781 LC2507 lc
[48 rows x 15 columns]
2025-05-06 18:41:02,462 - future_1d - INFO - save future_spot 2025-04-30 completed
2025-05-06 18:41:05,789 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-06, end_day=2025-05-06) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-06 C 2272.86 ... 0.039659 c2507 c
1 2025-05-06 A 4230.0 ... -0.013002 a2507 a
2 2025-05-06 M 3270.0 ... -0.106728 m2509 m
3 2025-05-06 Y 8056.0 ... -0.037736 y2509 y
4 2025-05-06 P 8678.0 ... -0.079972 p2509 p
5 2025-05-06 JD 3375.0 ... -0.141037 jd2506 jd
6 2025-05-06 L 7500.0 ... -0.065333 l2509 l
7 2025-05-06 V 4653.0 ... 0.05072 v2509 v
8 2025-05-06 PP 7481.67 ... -0.063712 pp2509 pp
9 2025-05-06 I 781.44 ... -0.09718 i2509 i
10 2025-05-06 EG 4331.67 ... -0.045403 eg2509 eg
11 2025-05-06 EB 7650.0 ... -0.089542 eb2506 eb
12 2025-05-06 PG 4967.5 ... -0.114444 pg2506 pg
13 2025-05-06 LH 14820.0 ... -0.060729 lh2509 lh
14 2025-05-06 CF 14138.67 ... -0.095742 CF509 CF
15 2025-05-06 SR 6156.67 ... -0.043152 SR509 SR
16 2025-05-06 TA 4529.17 ... -0.037793 TA509 TA
17 2025-05-06 OI 9330.0 ... -0.009432 OI509 OI
18 2025-05-06 MA 2428.75 ... -0.07895 MA509 MA
19 2025-05-06 FG 1214.4 ... -0.116436 FG509 FG
20 2025-05-06 RM 2511.67 ... 0.017251 RM509 RM
21 2025-05-06 SF 5548.57 ... -0.000463 SF507 SF
22 2025-05-06 SM 5610.0 ... 0.001783 SM509 SM
23 2025-05-06 CY 23775.0 ... -0.209674 CY507 CY
24 2025-05-06 UR 1893.33 ... -0.013379 UR509 UR
25 2025-05-06 SA 1502.5 ... -0.111481 SA509 SA
26 2025-05-06 PF 6313.75 ... -0.043358 PF507 PF
27 2025-05-06 PX 6600.0 ... -0.073333 PX509 PX
28 2025-05-06 SH 807.0 ... 2.090458 SH509 SH
29 2025-05-06 CU 78233.33 ... -0.007201 cu2506 cu
30 2025-05-06 AL 20073.33 ... -0.010129 al2506 al
31 2025-05-06 ZN 22864.0 ... -0.019419 zn2506 zn
32 2025-05-06 PB 16706.25 ... -0.000973 pb2506 pb
33 2025-05-06 NI 125775.0 ... -0.00974 ni2506 ni
34 2025-05-06 SN 260362.5 ... -0.000163 sn2506 sn
35 2025-05-06 AU 780.65 ... 0.020329 au2508 au
36 2025-05-06 AG 8204.33 ... 0.004104 ag2506 ag
37 2025-05-06 RB 3176.33 ... -0.02655 rb2510 rb
38 2025-05-06 WR 3377.5 ... 0.02117 wr2510 wr
39 2025-05-06 HC 3263.33 ... -0.017568 hc2510 hc
40 2025-05-06 FU 5425.0 ... -0.478341 fu2507 fu
41 2025-05-06 BU 3590.0 ... -0.068802 bu2506 bu
42 2025-05-06 RU 14593.33 ... 0.014847 ru2509 ru
43 2025-05-06 SP 6250.0 ... -0.18816 sp2507 sp
44 2025-05-06 SS 13062.5 ... -0.027751 ss2506 ss
45 2025-05-06 BR 11950.0 ... -0.053556 br2507 br
46 2025-05-06 SI 9780.0 ... -0.144172 SI2506 si
47 2025-05-06 LC 68733.33 ... -0.047624 LC2507 lc
[48 rows x 15 columns]
2025-05-06 18:41:05,963 - future_1d - INFO - save future_spot 2025-05-06 add
2025-05-06 18:41:05,970 - future_1d - INFO - 1 ... 33
date 2025-05-06 ... 2025-05-06
variety A ... NI
spot_price 4230.0 ... 125775.0
near_contract a2505 ... ni2505
near_contract_price 4136.0 ... 124330.0
dominant_contract a2507 ... ni2506
dominant_contract_price 4175.0 ... 124550.0
near_month 2505 ... 2505
dominant_month 2507 ... 2506
near_basis -94.0 ... -1445.0
dom_basis -55.0 ... -1225.0
near_basis_rate -0.0222 ... -0.0115
dom_basis_rate -0.013 ... -0.0097
symbol a2507 ... ni2506
comd a ... ni
created_at 2025-05-06 18:41:05.927925 ... 2025-05-06 18:41:05.927925
updated_at 2025-05-06 18:41:05.928289 ... 2025-05-06 18:41:05.928289
[17 rows x 5 columns]