=========================================================================
2025-06-06 16:25:15 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-06-06 16:25:16,947 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-06 16:25:17,276 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-30, end_day=2025-05-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-30 C 2294.29 ... 0.019488 c2507 c
1 2025-05-30 A 4255.0 ... -0.031962 a2507 a
2 2025-05-30 M 2956.0 ... 0.003383 m2509 m
3 2025-05-30 Y 7904.0 ... -0.030617 y2509 y
4 2025-05-30 P 8652.0 ... -0.064263 p2509 p
5 2025-05-30 JD 3015.0 ... 0.198673 jd2508 jd
6 2025-05-30 L 7368.33 ... -0.053517 l2509 l
7 2025-05-30 V 4597.0 ... 0.035675 v2509 v
8 2025-05-30 PP 7393.33 ... -0.069161 pp2509 pp
9 2025-05-30 I 750.33 ... -0.062413 i2509 i
10 2025-05-30 EG 4521.67 ... -0.040178 eg2509 eg
11 2025-05-30 EB 8104.0 ... -0.121422 eb2507 eb
12 2025-05-30 PG 4750.0 ... -0.150316 pg2507 pg
13 2025-05-30 LH 14530.0 ... -0.062629 lh2509 lh
14 2025-05-30 CF 14580.33 ... -0.08987 CF509 CF
15 2025-05-30 SR 6130.0 ... -0.058891 SR509 SR
16 2025-05-30 TA 4965.62 ... -0.048659 TA509 TA
17 2025-05-30 OI 9456.67 ... -0.008425 OI509 OI
18 2025-05-30 MA 2245.0 ... -0.016036 MA509 MA
19 2025-05-30 FG 1150.4 ... -0.144645 FG509 FG
20 2025-05-30 RM 2565.0 ... 0.025731 RM509 RM
21 2025-05-30 SF 5298.57 ... -0.022755 SF509 SF
22 2025-05-30 SM 5520.0 ... -0.006884 SM509 SM
23 2025-05-30 CY 23800.0 ... -0.180042 CY507 CY
24 2025-05-30 UR 1892.0 ... -0.060254 UR509 UR
25 2025-05-30 SA 1450.0 ... -0.175172 SA509 SA
26 2025-05-30 PF 6511.46 ... -0.015889 PF507 PF
27 2025-05-30 PX 6850.0 ... -0.029489 PX509 PX
28 2025-05-30 SH 885.0 ... 1.760452 SH509 SH
29 2025-05-30 CU 78286.67 ... -0.006855 cu2507 cu
30 2025-05-30 AL 20303.33 ... -0.010753 al2507 al
31 2025-05-30 ZN 22738.0 ... -0.019923 zn2507 zn
32 2025-05-30 PB 16487.5 ... 0.008036 pb2507 pb
33 2025-05-30 NI 122425.0 ... -0.010986 ni2507 ni
34 2025-05-30 SN 251325.0 ... 0.006307 sn2507 sn
35 2025-05-30 AU 765.29 ... 0.009108 au2508 au
36 2025-05-30 AG 8182.33 ... 0.004848 ag2508 ag
37 2025-05-30 RB 3062.22 ... -0.032401 rb2510 rb
38 2025-05-30 WR 3260.0 ... 0.000613 wr2510 wr
39 2025-05-30 HC 3196.67 ... -0.035246 hc2510 hc
40 2025-05-30 FU 5337.5 ... -0.476721 fu2509 fu
41 2025-05-30 BU 3611.67 ... -0.0539 bu2509 bu
42 2025-05-30 RU 13308.33 ... 0.023043 ru2509 ru
43 2025-05-30 SP 6216.67 ... -0.148097 sp2509 sp
44 2025-05-30 SS 13175.0 ... -0.033397 ss2508 ss
45 2025-05-30 BR 11910.0 ... -0.071369 br2508 br
46 2025-05-30 SI 8780.0 ... -0.178246 SI2509 si
47 2025-05-30 LC 60200.0 ... -0.007641 LC2507 lc
[48 rows x 15 columns]
2025-06-06 16:25:17,456 - future_1d - INFO - save future_spot 2025-05-30 completed
2025-06-06 16:25:23,796 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-03, end_day=2025-06-03) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-03 C 2297.14 ... 0.012563 c2507 c
1 2025-06-03 A 4255.0 ... -0.029377 a2507 a
2 2025-06-03 M 2900.0 ... 0.013448 m2509 m
3 2025-06-03 Y 7954.0 ... -0.0347 y2509 y
4 2025-06-03 P 8636.0 ... -0.051644 p2509 p
5 2025-06-03 JD 2975.0 ... 0.204034 jd2508 jd
6 2025-06-03 L 7356.67 ... -0.052153 l2509 l
7 2025-06-03 V 4582.0 ... 0.034701 v2509 v
8 2025-06-03 PP 7393.33 ... -0.068214 pp2509 pp
9 2025-06-03 I 750.33 ... -0.073741 i2509 i
10 2025-06-03 EG 4518.33 ... -0.042124 eg2509 eg
11 2025-06-03 EB 8040.0 ... -0.114677 eb2507 eb
12 2025-06-03 PG 4757.5 ... -0.143668 pg2507 pg
13 2025-06-03 LH 14450.0 ... -0.061592 lh2509 lh
14 2025-06-03 CF 14558.33 ... -0.088838 CF509 CF
15 2025-06-03 SR 6130.0 ... -0.063295 SR509 SR
16 2025-06-03 TA 4948.75 ... -0.048649 TA509 TA
17 2025-06-03 OI 9408.33 ... -0.007263 OI509 OI
18 2025-06-03 MA 2293.0 ... -0.033144 MA509 MA
19 2025-06-03 FG 1136.0 ... -0.15493 FG509 FG
20 2025-06-03 RM 2548.33 ... 0.017137 RM509 RM
21 2025-06-03 SF 5298.57 ... -0.042383 SF509 SF
22 2025-06-03 SM 5476.0 ... -0.01607 SM509 SM
23 2025-06-03 CY 23800.0 ... -0.180042 CY507 CY
24 2025-06-03 UR 1896.0 ... -0.064346 UR509 UR
25 2025-06-03 SA 1430.0 ... -0.172727 SA509 SA
26 2025-06-03 PF 6513.75 ... -0.016849 PF507 PF
27 2025-06-03 PX 7000.0 ... -0.052 PX509 PX
28 2025-06-03 SH 885.0 ... 1.727684 SH509 SH
29 2025-06-03 CU 78483.33 ... -0.008834 cu2507 cu
30 2025-06-03 AL 20136.67 ... -0.009767 al2507 al
31 2025-06-03 ZN 22714.0 ... -0.020868 zn2507 zn
32 2025-06-03 PB 16462.5 ... 0.006834 pb2507 pb
33 2025-06-03 NI 122950.0 ... -0.011305 ni2507 ni
34 2025-06-03 SN 250337.5 ... -0.000989 sn2507 sn
35 2025-06-03 AU 781.49 ... 0.005362 au2508 au
36 2025-06-03 AG 8422.33 ... 0.004354 ag2508 ag
37 2025-06-03 RB 3050.89 ... -0.04028 rb2510 rb
38 2025-06-03 WR 3260.0 ... -0.000307 wr2510 wr
39 2025-06-03 HC 3183.33 ... -0.042512 hc2510 hc
40 2025-06-03 FU 5337.5 ... -0.468852 fu2509 fu
41 2025-06-03 BU 3623.33 ... -0.038454 bu2509 bu
42 2025-06-03 RU 13308.33 ... 0.011772 ru2509 ru
43 2025-06-03 SP 6216.67 ... -0.151958 sp2509 sp
44 2025-06-03 SS 13125.0 ... -0.033905 ss2508 ss
45 2025-06-03 BR 11910.0 ... -0.096138 br2508 br
46 2025-06-03 SI 8700.0 ... -0.183333 SI2509 si
47 2025-06-03 LC 59900.0 ... -0.005676 LC2507 lc
[48 rows x 15 columns]
2025-06-06 16:25:23,951 - future_1d - INFO - save future_spot 2025-06-03 completed
2025-06-06 16:25:33,715 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-04, end_day=2025-06-04) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-04 C 2297.14 ... 0.012999 c2507 c
1 2025-06-04 A 4255.0 ... -0.032432 a2507 a
2 2025-06-04 M 2892.0 ... 0.015906 m2509 m
3 2025-06-04 Y 7954.0 ... -0.033191 y2509 y
4 2025-06-04 P 8540.0 ... -0.044965 p2509 p
5 2025-06-04 JD 2975.0 ... 0.199664 jd2508 jd
6 2025-06-04 L 7346.67 ... -0.04569 l2509 l
7 2025-06-04 V 4589.0 ... 0.041839 v2509 v
8 2025-06-04 PP 7393.33 ... -0.065239 pp2509 pp
9 2025-06-04 I 752.11 ... -0.066626 i2509 i
10 2025-06-04 EG 4495.0 ... -0.046051 eg2509 eg
11 2025-06-04 EB 8040.0 ... -0.120149 eb2507 eb
12 2025-06-04 PG 4765.0 ... -0.145855 pg2507 pg
13 2025-06-04 LH 14470.0 ... -0.070145 lh2509 lh
14 2025-06-04 CF 14553.0 ... -0.089878 CF509 CF
15 2025-06-04 SR 6095.0 ... -0.059557 SR509 SR
16 2025-06-04 TA 4896.5 ... -0.046258 TA509 TA
17 2025-06-04 OI 9238.33 ... -0.007396 OI509 OI
18 2025-06-04 MA 2293.0 ... -0.019625 MA509 MA
19 2025-06-04 FG 1136.0 ... -0.144366 FG509 FG
20 2025-06-04 RM 2495.0 ... 0.02004 RM509 RM
21 2025-06-04 SF 5152.86 ... -0.007541 SF509 SF
22 2025-06-04 SM 5510.0 ... -0.0098 SM509 SM
23 2025-06-04 CY 23800.0 ... -0.182563 CY509 CY
24 2025-06-04 UR 1898.0 ... -0.065859 UR509 UR
25 2025-06-04 SA 1375.0 ... -0.120727 SA509 SA
26 2025-06-04 PF 6519.17 ... -0.0192 PF507 PF
27 2025-06-04 PX 7000.0 ... -0.061714 PX509 PX
28 2025-06-04 SH 885.0 ... 1.657627 SH509 SH
29 2025-06-04 CU 78535.0 ... -0.004266 cu2507 cu
30 2025-06-04 AL 20293.33 ... -0.013715 al2507 al
31 2025-06-04 ZN 22886.0 ... -0.02211 zn2507 zn
32 2025-06-04 PB 16525.0 ... 0.006657 pb2507 pb
33 2025-06-04 NI 123641.67 ... -0.01255 ni2507 ni
34 2025-06-04 SN 255450.0 ... -0.001174 sn2507 sn
35 2025-06-04 AU 780.92 ... 0.001332 au2508 au
36 2025-06-04 AG 8455.67 ... 0.002168 ag2508 ag
37 2025-06-04 RB 3057.33 ... -0.03347 rb2510 rb
38 2025-06-04 WR 3237.5 ... 0.026409 wr2601 wr
39 2025-06-04 HC 3183.33 ... -0.031517 hc2510 hc
40 2025-06-04 FU 5337.5 ... -0.466604 fu2509 fu
41 2025-06-04 BU 3630.0 ... -0.041322 bu2509 bu
42 2025-06-04 RU 13558.33 ... -0.006515 ru2509 ru
43 2025-06-04 SP 6216.67 ... -0.160644 sp2509 sp
44 2025-06-04 SS 13125.0 ... -0.032762 ss2508 ss
45 2025-06-04 BR 11600.0 ... -0.06681 br2508 br
46 2025-06-04 SI 8640.0 ... -0.168403 SI2509 si
47 2025-06-04 LC 59900.0 ... 0.007679 LC2507 lc
[48 rows x 15 columns]
2025-06-06 16:25:33,869 - future_1d - INFO - save future_spot 2025-06-04 completed
2025-06-06 16:25:39,952 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-05, end_day=2025-06-05) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-05 C 2294.29 ... 0.016436 c2507 c
1 2025-06-05 A 4255.0 ... -0.039483 a2509 a
2 2025-06-05 M 2900.0 ... 0.018621 m2509 m
3 2025-06-05 Y 7934.0 ... -0.033527 y2509 y
4 2025-06-05 P 8542.0 ... -0.051042 p2509 p
5 2025-06-05 JD 2975.0 ... 0.200336 jd2508 jd
6 2025-06-05 L 7346.67 ... -0.041334 l2509 l
7 2025-06-05 V 4565.0 ... 0.043154 v2509 v
8 2025-06-05 PP 7388.33 ... -0.063523 pp2509 pp
9 2025-06-05 I 750.0 ... -0.064667 i2509 i
10 2025-06-05 EG 4498.33 ... -0.045868 eg2509 eg
11 2025-06-05 EB 7970.0 ... -0.115182 eb2507 eb
12 2025-06-05 PG 4770.0 ... -0.141509 pg2507 pg
13 2025-06-05 LH 14420.0 ... -0.065187 lh2509 lh
14 2025-06-05 CF 14555.5 ... -0.089004 CF509 CF
15 2025-06-05 SR 6095.0 ... -0.059065 SR509 SR
16 2025-06-05 TA 4880.66 ... -0.051768 TA509 TA
17 2025-06-05 OI 9296.67 ... -0.018035 OI509 OI
18 2025-06-05 MA 2302.0 ... -0.019548 MA509 MA
19 2025-06-05 FG 1120.0 ... -0.135714 FG509 FG
20 2025-06-05 RM 2498.33 ... 0.022283 RM509 RM
21 2025-06-05 SF 5152.86 ... -0.010258 SF509 SF
22 2025-06-05 SM 5500.0 ... -0.004727 SM509 SM
23 2025-06-05 CY 23725.0 ... -0.177871 CY509 CY
24 2025-06-05 UR 1868.33 ... -0.069222 UR509 UR
25 2025-06-05 SA 1375.0 ... -0.125818 SA509 SA
26 2025-06-05 PF 6495.83 ... -0.019679 PF507 PF
27 2025-06-05 PX 7000.0 ... -0.069143 PX509 PX
28 2025-06-05 SH 885.0 ... 1.633898 SH509 SH
29 2025-06-05 CU 78410.0 ... -0.003699 cu2507 cu
30 2025-06-05 AL 20266.67 ... -0.010444 al2507 al
31 2025-06-05 ZN 22870.0 ... -0.022956 zn2507 zn
32 2025-06-05 PB 16593.75 ... 0.007006 pb2507 pb
33 2025-06-05 NI 123133.33 ... -0.011478 ni2507 ni
34 2025-06-05 SN 259812.5 ... -0.003243 sn2507 sn
35 2025-06-05 AU 781.27 ... 0.003981 au2508 au
36 2025-06-05 AG 8443.0 ... 0.003198 ag2508 ag
37 2025-06-05 RB 3063.0 ... -0.03428 rb2510 rb
38 2025-06-05 WR 3240.0 ... 0.025617 wr2601 wr
39 2025-06-05 HC 3176.67 ... -0.032005 hc2510 hc
40 2025-06-05 FU 5312.5 ... -0.463153 fu2509 fu
41 2025-06-05 BU 3610.0 ... -0.041274 bu2509 bu
42 2025-06-05 RU 13458.33 ... 0.007183 ru2509 ru
43 2025-06-05 SP 6216.67 ... -0.159679 sp2509 sp
44 2025-06-05 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-05 BR 11600.0 ... -0.063362 br2508 br
46 2025-06-05 SI 8640.0 ... -0.170718 SI2509 si
47 2025-06-05 LC 60166.67 ... 0.002216 LC2507 lc
[48 rows x 15 columns]
2025-06-06 16:25:40,106 - future_1d - INFO - save future_spot 2025-06-05 completed
2025-06-06 16:25:49,535 - 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 4255.0 ... -0.036898 a2509 a
2 2025-06-06 M 2940.0 ... 0.017347 m2509 m
3 2025-06-06 Y 7934.0 ... -0.027729 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 14555.5 ... -0.082821 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 5152.86 ... -0.001719 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 123133.33 ... -0.008067 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-06 16:25:49,708 - future_1d - INFO - save future_spot 2025-06-06 add
2025-06-06 16:25:49,715 - future_1d - INFO - 0 ... 4
date 2025-06-06 ... 2025-06-06
variety C ... P
spot_price 2294.29 ... 8520.0
near_contract c2507 ... p2506
near_contract_price 2336.0 ... 8600.0
dominant_contract c2507 ... p2509
dominant_contract_price 2336.0 ... 8124.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 41.71 ... 80.0
dom_basis 41.71 ... -396.0
near_basis_rate 0.0182 ... 0.0094
dom_basis_rate 0.0182 ... -0.0465
symbol c2507 ... p2509
comd c ... p
created_at 2025-06-06 16:25:49.667621 ... 2025-06-06 16:25:49.667621
updated_at 2025-06-06 16:25:49.668023 ... 2025-06-06 16:25:49.668023
[17 rows x 5 columns]
=========================================================================
2025-06-06 18:25:35 Fri START TASK.01 future_1d future_spot
=========================================================================
2025-06-06 18:25:36,998 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-06 18:25:37,316 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-30, end_day=2025-05-30) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-30 C 2294.29 ... 0.019488 c2507 c
1 2025-05-30 A 4255.0 ... -0.031962 a2507 a
2 2025-05-30 M 2956.0 ... 0.003383 m2509 m
3 2025-05-30 Y 7904.0 ... -0.030617 y2509 y
4 2025-05-30 P 8652.0 ... -0.064263 p2509 p
5 2025-05-30 JD 3015.0 ... 0.198673 jd2508 jd
6 2025-05-30 L 7368.33 ... -0.053517 l2509 l
7 2025-05-30 V 4597.0 ... 0.035675 v2509 v
8 2025-05-30 PP 7393.33 ... -0.069161 pp2509 pp
9 2025-05-30 I 750.33 ... -0.062413 i2509 i
10 2025-05-30 EG 4521.67 ... -0.040178 eg2509 eg
11 2025-05-30 EB 8104.0 ... -0.121422 eb2507 eb
12 2025-05-30 PG 4750.0 ... -0.150316 pg2507 pg
13 2025-05-30 LH 14530.0 ... -0.062629 lh2509 lh
14 2025-05-30 CF 14580.33 ... -0.08987 CF509 CF
15 2025-05-30 SR 6130.0 ... -0.058891 SR509 SR
16 2025-05-30 TA 4965.62 ... -0.048659 TA509 TA
17 2025-05-30 OI 9456.67 ... -0.008425 OI509 OI
18 2025-05-30 MA 2245.0 ... -0.016036 MA509 MA
19 2025-05-30 FG 1150.4 ... -0.144645 FG509 FG
20 2025-05-30 RM 2565.0 ... 0.025731 RM509 RM
21 2025-05-30 SF 5298.57 ... -0.022755 SF509 SF
22 2025-05-30 SM 5520.0 ... -0.006884 SM509 SM
23 2025-05-30 CY 23800.0 ... -0.180042 CY507 CY
24 2025-05-30 UR 1892.0 ... -0.060254 UR509 UR
25 2025-05-30 SA 1450.0 ... -0.175172 SA509 SA
26 2025-05-30 PF 6511.46 ... -0.015889 PF507 PF
27 2025-05-30 PX 6850.0 ... -0.029489 PX509 PX
28 2025-05-30 SH 885.0 ... 1.760452 SH509 SH
29 2025-05-30 CU 78286.67 ... -0.006855 cu2507 cu
30 2025-05-30 AL 20303.33 ... -0.010753 al2507 al
31 2025-05-30 ZN 22738.0 ... -0.019923 zn2507 zn
32 2025-05-30 PB 16487.5 ... 0.008036 pb2507 pb
33 2025-05-30 NI 122425.0 ... -0.010986 ni2507 ni
34 2025-05-30 SN 251325.0 ... 0.006307 sn2507 sn
35 2025-05-30 AU 765.29 ... 0.009108 au2508 au
36 2025-05-30 AG 8182.33 ... 0.004848 ag2508 ag
37 2025-05-30 RB 3062.22 ... -0.032401 rb2510 rb
38 2025-05-30 WR 3260.0 ... 0.000613 wr2510 wr
39 2025-05-30 HC 3196.67 ... -0.035246 hc2510 hc
40 2025-05-30 FU 5337.5 ... -0.476721 fu2509 fu
41 2025-05-30 BU 3611.67 ... -0.0539 bu2509 bu
42 2025-05-30 RU 13308.33 ... 0.023043 ru2509 ru
43 2025-05-30 SP 6216.67 ... -0.148097 sp2509 sp
44 2025-05-30 SS 13175.0 ... -0.033397 ss2508 ss
45 2025-05-30 BR 11910.0 ... -0.071369 br2508 br
46 2025-05-30 SI 8780.0 ... -0.178246 SI2509 si
47 2025-05-30 LC 60200.0 ... -0.007641 LC2507 lc
[48 rows x 15 columns]
2025-06-06 18:25:37,497 - future_1d - INFO - save future_spot 2025-05-30 completed
2025-06-06 18:25:41,138 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-03, end_day=2025-06-03) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-03 C 2297.14 ... 0.012563 c2507 c
1 2025-06-03 A 4255.0 ... -0.029377 a2507 a
2 2025-06-03 M 2900.0 ... 0.013448 m2509 m
3 2025-06-03 Y 7954.0 ... -0.0347 y2509 y
4 2025-06-03 P 8636.0 ... -0.051644 p2509 p
5 2025-06-03 JD 2975.0 ... 0.204034 jd2508 jd
6 2025-06-03 L 7356.67 ... -0.052153 l2509 l
7 2025-06-03 V 4582.0 ... 0.034701 v2509 v
8 2025-06-03 PP 7393.33 ... -0.068214 pp2509 pp
9 2025-06-03 I 750.33 ... -0.073741 i2509 i
10 2025-06-03 EG 4518.33 ... -0.042124 eg2509 eg
11 2025-06-03 EB 8040.0 ... -0.114677 eb2507 eb
12 2025-06-03 PG 4757.5 ... -0.143668 pg2507 pg
13 2025-06-03 LH 14450.0 ... -0.061592 lh2509 lh
14 2025-06-03 CF 14558.33 ... -0.088838 CF509 CF
15 2025-06-03 SR 6130.0 ... -0.063295 SR509 SR
16 2025-06-03 TA 4948.75 ... -0.048649 TA509 TA
17 2025-06-03 OI 9408.33 ... -0.007263 OI509 OI
18 2025-06-03 MA 2293.0 ... -0.033144 MA509 MA
19 2025-06-03 FG 1136.0 ... -0.15493 FG509 FG
20 2025-06-03 RM 2548.33 ... 0.017137 RM509 RM
21 2025-06-03 SF 5298.57 ... -0.042383 SF509 SF
22 2025-06-03 SM 5476.0 ... -0.01607 SM509 SM
23 2025-06-03 CY 23800.0 ... -0.180042 CY507 CY
24 2025-06-03 UR 1896.0 ... -0.064346 UR509 UR
25 2025-06-03 SA 1430.0 ... -0.172727 SA509 SA
26 2025-06-03 PF 6513.75 ... -0.016849 PF507 PF
27 2025-06-03 PX 7000.0 ... -0.052 PX509 PX
28 2025-06-03 SH 885.0 ... 1.727684 SH509 SH
29 2025-06-03 CU 78483.33 ... -0.008834 cu2507 cu
30 2025-06-03 AL 20136.67 ... -0.009767 al2507 al
31 2025-06-03 ZN 22714.0 ... -0.020868 zn2507 zn
32 2025-06-03 PB 16462.5 ... 0.006834 pb2507 pb
33 2025-06-03 NI 122950.0 ... -0.011305 ni2507 ni
34 2025-06-03 SN 250337.5 ... -0.000989 sn2507 sn
35 2025-06-03 AU 781.49 ... 0.005362 au2508 au
36 2025-06-03 AG 8422.33 ... 0.004354 ag2508 ag
37 2025-06-03 RB 3050.89 ... -0.04028 rb2510 rb
38 2025-06-03 WR 3260.0 ... -0.000307 wr2510 wr
39 2025-06-03 HC 3183.33 ... -0.042512 hc2510 hc
40 2025-06-03 FU 5337.5 ... -0.468852 fu2509 fu
41 2025-06-03 BU 3623.33 ... -0.038454 bu2509 bu
42 2025-06-03 RU 13308.33 ... 0.011772 ru2509 ru
43 2025-06-03 SP 6216.67 ... -0.151958 sp2509 sp
44 2025-06-03 SS 13125.0 ... -0.033905 ss2508 ss
45 2025-06-03 BR 11910.0 ... -0.096138 br2508 br
46 2025-06-03 SI 8700.0 ... -0.183333 SI2509 si
47 2025-06-03 LC 59900.0 ... -0.005676 LC2507 lc
[48 rows x 15 columns]
2025-06-06 18:25:41,295 - future_1d - INFO - save future_spot 2025-06-03 completed
2025-06-06 18:25:48,536 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-04, end_day=2025-06-04) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-04 C 2297.14 ... 0.012999 c2507 c
1 2025-06-04 A 4255.0 ... -0.032432 a2507 a
2 2025-06-04 M 2892.0 ... 0.015906 m2509 m
3 2025-06-04 Y 7954.0 ... -0.033191 y2509 y
4 2025-06-04 P 8540.0 ... -0.044965 p2509 p
5 2025-06-04 JD 2975.0 ... 0.199664 jd2508 jd
6 2025-06-04 L 7346.67 ... -0.04569 l2509 l
7 2025-06-04 V 4589.0 ... 0.041839 v2509 v
8 2025-06-04 PP 7393.33 ... -0.065239 pp2509 pp
9 2025-06-04 I 752.11 ... -0.066626 i2509 i
10 2025-06-04 EG 4495.0 ... -0.046051 eg2509 eg
11 2025-06-04 EB 8040.0 ... -0.120149 eb2507 eb
12 2025-06-04 PG 4765.0 ... -0.145855 pg2507 pg
13 2025-06-04 LH 14470.0 ... -0.070145 lh2509 lh
14 2025-06-04 CF 14553.0 ... -0.089878 CF509 CF
15 2025-06-04 SR 6095.0 ... -0.059557 SR509 SR
16 2025-06-04 TA 4896.5 ... -0.046258 TA509 TA
17 2025-06-04 OI 9238.33 ... -0.007396 OI509 OI
18 2025-06-04 MA 2293.0 ... -0.019625 MA509 MA
19 2025-06-04 FG 1136.0 ... -0.144366 FG509 FG
20 2025-06-04 RM 2495.0 ... 0.02004 RM509 RM
21 2025-06-04 SF 5152.86 ... -0.007541 SF509 SF
22 2025-06-04 SM 5510.0 ... -0.0098 SM509 SM
23 2025-06-04 CY 23800.0 ... -0.182563 CY509 CY
24 2025-06-04 UR 1898.0 ... -0.065859 UR509 UR
25 2025-06-04 SA 1375.0 ... -0.120727 SA509 SA
26 2025-06-04 PF 6519.17 ... -0.0192 PF507 PF
27 2025-06-04 PX 7000.0 ... -0.061714 PX509 PX
28 2025-06-04 SH 885.0 ... 1.657627 SH509 SH
29 2025-06-04 CU 78535.0 ... -0.004266 cu2507 cu
30 2025-06-04 AL 20293.33 ... -0.013715 al2507 al
31 2025-06-04 ZN 22886.0 ... -0.02211 zn2507 zn
32 2025-06-04 PB 16525.0 ... 0.006657 pb2507 pb
33 2025-06-04 NI 123641.67 ... -0.01255 ni2507 ni
34 2025-06-04 SN 255450.0 ... -0.001174 sn2507 sn
35 2025-06-04 AU 780.92 ... 0.001332 au2508 au
36 2025-06-04 AG 8455.67 ... 0.002168 ag2508 ag
37 2025-06-04 RB 3057.33 ... -0.03347 rb2510 rb
38 2025-06-04 WR 3237.5 ... 0.026409 wr2601 wr
39 2025-06-04 HC 3183.33 ... -0.031517 hc2510 hc
40 2025-06-04 FU 5337.5 ... -0.466604 fu2509 fu
41 2025-06-04 BU 3630.0 ... -0.041322 bu2509 bu
42 2025-06-04 RU 13558.33 ... -0.006515 ru2509 ru
43 2025-06-04 SP 6216.67 ... -0.160644 sp2509 sp
44 2025-06-04 SS 13125.0 ... -0.032762 ss2508 ss
45 2025-06-04 BR 11600.0 ... -0.06681 br2508 br
46 2025-06-04 SI 8640.0 ... -0.168403 SI2509 si
47 2025-06-04 LC 59900.0 ... 0.007679 LC2507 lc
[48 rows x 15 columns]
2025-06-06 18:25:48,695 - future_1d - INFO - save future_spot 2025-06-04 completed
2025-06-06 18:25:55,996 - future_1d - INFO - futures_spot_price_daily(start_day=2025-06-05, end_day=2025-06-05) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-06-05 C 2294.29 ... 0.016436 c2507 c
1 2025-06-05 A 4255.0 ... -0.039483 a2509 a
2 2025-06-05 M 2900.0 ... 0.018621 m2509 m
3 2025-06-05 Y 7934.0 ... -0.033527 y2509 y
4 2025-06-05 P 8542.0 ... -0.051042 p2509 p
5 2025-06-05 JD 2975.0 ... 0.200336 jd2508 jd
6 2025-06-05 L 7346.67 ... -0.041334 l2509 l
7 2025-06-05 V 4565.0 ... 0.043154 v2509 v
8 2025-06-05 PP 7388.33 ... -0.063523 pp2509 pp
9 2025-06-05 I 750.0 ... -0.064667 i2509 i
10 2025-06-05 EG 4498.33 ... -0.045868 eg2509 eg
11 2025-06-05 EB 7970.0 ... -0.115182 eb2507 eb
12 2025-06-05 PG 4770.0 ... -0.141509 pg2507 pg
13 2025-06-05 LH 14420.0 ... -0.065187 lh2509 lh
14 2025-06-05 CF 14555.5 ... -0.089004 CF509 CF
15 2025-06-05 SR 6095.0 ... -0.059065 SR509 SR
16 2025-06-05 TA 4880.66 ... -0.051768 TA509 TA
17 2025-06-05 OI 9296.67 ... -0.018035 OI509 OI
18 2025-06-05 MA 2302.0 ... -0.019548 MA509 MA
19 2025-06-05 FG 1120.0 ... -0.135714 FG509 FG
20 2025-06-05 RM 2498.33 ... 0.022283 RM509 RM
21 2025-06-05 SF 5152.86 ... -0.010258 SF509 SF
22 2025-06-05 SM 5500.0 ... -0.004727 SM509 SM
23 2025-06-05 CY 23725.0 ... -0.177871 CY509 CY
24 2025-06-05 UR 1868.33 ... -0.069222 UR509 UR
25 2025-06-05 SA 1375.0 ... -0.125818 SA509 SA
26 2025-06-05 PF 6495.83 ... -0.019679 PF507 PF
27 2025-06-05 PX 7000.0 ... -0.069143 PX509 PX
28 2025-06-05 SH 885.0 ... 1.633898 SH509 SH
29 2025-06-05 CU 78410.0 ... -0.003699 cu2507 cu
30 2025-06-05 AL 20266.67 ... -0.010444 al2507 al
31 2025-06-05 ZN 22870.0 ... -0.022956 zn2507 zn
32 2025-06-05 PB 16593.75 ... 0.007006 pb2507 pb
33 2025-06-05 NI 123133.33 ... -0.011478 ni2507 ni
34 2025-06-05 SN 259812.5 ... -0.003243 sn2507 sn
35 2025-06-05 AU 781.27 ... 0.003981 au2508 au
36 2025-06-05 AG 8443.0 ... 0.003198 ag2508 ag
37 2025-06-05 RB 3063.0 ... -0.03428 rb2510 rb
38 2025-06-05 WR 3240.0 ... 0.025617 wr2601 wr
39 2025-06-05 HC 3176.67 ... -0.032005 hc2510 hc
40 2025-06-05 FU 5312.5 ... -0.463153 fu2509 fu
41 2025-06-05 BU 3610.0 ... -0.041274 bu2509 bu
42 2025-06-05 RU 13458.33 ... 0.007183 ru2509 ru
43 2025-06-05 SP 6216.67 ... -0.159679 sp2509 sp
44 2025-06-05 SS 13175.0 ... -0.034915 ss2508 ss
45 2025-06-05 BR 11600.0 ... -0.063362 br2508 br
46 2025-06-05 SI 8640.0 ... -0.170718 SI2509 si
47 2025-06-05 LC 60166.67 ... 0.002216 LC2507 lc
[48 rows x 15 columns]
2025-06-06 18:25:56,152 - future_1d - INFO - save future_spot 2025-06-05 completed
2025-06-06 18:26:04,927 - 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-06 18:26:05,102 - future_1d - INFO - save future_spot 2025-06-06 add
2025-06-06 18:26:05,110 - future_1d - INFO - 1 ... 33
date 2025-06-06 ... 2025-06-06
variety A ... NI
spot_price 4270.0 ... 123450.0
near_contract a2507 ... ni2506
near_contract_price 4142.0 ... 122000.0
dominant_contract a2509 ... ni2507
dominant_contract_price 4098.0 ... 122140.0
near_month 2507 ... 2506
dominant_month 2509 ... 2507
near_basis -128.0 ... -1450.0
dom_basis -172.0 ... -1310.0
near_basis_rate -0.03 ... -0.0117
dom_basis_rate -0.0403 ... -0.0106
symbol a2509 ... ni2507
comd a ... ni
created_at 2025-06-06 18:26:05.066905 ... 2025-06-06 18:26:05.066905
updated_at 2025-06-06 18:26:05.067283 ... 2025-06-06 18:26:05.067283
[17 rows x 5 columns]