=========================================================================
2025-06-03 16:25:38 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-06-03 16:25:40,413 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-03 16:25:40,725 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-27, end_day=2025-05-27) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-27 C 2294.29 ... 0.01077 c2507 c
1 2025-05-27 A 4255.0 ... -0.028672 a2507 a
2 2025-05-27 M 2962.0 ... -0.00135 m2509 m
3 2025-05-27 Y 7994.0 ... -0.034276 y2509 y
4 2025-05-27 P 8488.0 ... -0.057493 p2509 p
5 2025-05-27 JD 3040.0 ... -0.046382 jd2507 jd
6 2025-05-27 L 7451.67 ... -0.056453 l2509 l
7 2025-05-27 V 4580.0 ... 0.049563 v2509 v
8 2025-05-27 PP 7426.67 ... -0.071859 pp2509 pp
9 2025-05-27 I 757.33 ... -0.07636 i2509 i
10 2025-05-27 EG 4548.33 ... -0.040087 eg2509 eg
11 2025-05-27 EB 8110.0 ... -0.119112 eb2507 eb
12 2025-05-27 PG 4730.0 ... -0.137632 pg2507 pg
13 2025-05-27 LH 14500.0 ... -0.065862 lh2509 lh
14 2025-05-27 CF 14597.17 ... -0.088179 CF509 CF
15 2025-05-27 SR 6145.0 ... -0.051912 SR509 SR
16 2025-05-27 TA 4938.75 ... -0.048342 TA509 TA
17 2025-05-27 OI 9545.0 ... -0.014982 OI509 OI
18 2025-05-27 MA 2253.75 ... -0.024293 MA509 MA
19 2025-05-27 FG 1152.0 ... -0.109375 FG509 FG
20 2025-05-27 RM 2543.33 ... 0.015991 RM509 RM
21 2025-05-27 SF 5380.0 ... 0.016357 SF507 SF
22 2025-05-27 SM 5586.0 ... 0.006087 SM509 SM
23 2025-05-27 CY 23800.0 ... -0.180252 CY507 CY
24 2025-05-27 UR 1886.0 ... -0.033934 UR509 UR
25 2025-05-27 SA 1450.0 ... -0.144828 SA509 SA
26 2025-05-27 PF 6545.21 ... -0.021575 PF507 PF
27 2025-05-27 PX 6850.0 ... -0.031533 PX509 PX
28 2025-05-27 SH 881.0 ... 1.800227 SH509 SH
29 2025-05-27 CU 78556.67 ... -0.007214 cu2507 cu
30 2025-05-27 AL 20213.33 ... -0.007586 al2507 al
31 2025-05-27 ZN 22736.0 ... -0.014338 zn2507 zn
32 2025-05-27 PB 16718.75 ... 0.004262 pb2507 pb
33 2025-05-27 NI 123400.0 ... -0.007131 ni2507 ni
34 2025-05-27 SN 264975.0 ... 0.001453 sn2507 sn
35 2025-05-27 AU 773.68 ... 0.00411 au2508 au
36 2025-05-27 AG 8239.33 ... 0.001902 ag2508 ag
37 2025-05-27 RB 3077.11 ... -0.029284 rb2510 rb
38 2025-05-27 WR 3277.5 ... -0.03341 wr2510 wr
39 2025-05-27 HC 3243.33 ... -0.038951 hc2510 hc
40 2025-05-27 FU 5325.0 ... -0.44 fu2507 fu
41 2025-05-27 BU 3583.33 ... -0.03386 bu2509 bu
42 2025-05-27 RU 14258.33 ... 0.012391 ru2509 ru
43 2025-05-27 SP 6266.67 ... -0.153298 sp2507 sp
44 2025-05-27 SS 13225.0 ... -0.028355 ss2507 ss
45 2025-05-27 BR 12230.0 ... -0.052739 br2507 br
46 2025-05-27 SI 9000.0 ... -0.163333 SI2507 si
47 2025-05-27 LC 62200.0 ... -0.023473 LC2507 lc
[48 rows x 15 columns]
2025-06-03 16:25:40,900 - future_1d - INFO - save future_spot 2025-05-27 completed
2025-06-03 16:25:50,520 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-28, end_day=2025-05-28) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-28 C 2294.29 ... 0.012078 c2507 c
1 2025-05-28 A 4255.0 ... -0.029142 a2507 a
2 2025-05-28 M 2966.0 ... -0.001011 m2509 m
3 2025-05-28 Y 7974.0 ... -0.030098 y2509 y
4 2025-05-28 P 8572.0 ... -0.058329 p2509 p
5 2025-05-28 JD 3040.0 ... -0.050329 jd2507 jd
6 2025-05-28 L 7431.67 ... -0.059565 l2509 l
7 2025-05-28 V 4577.0 ... 0.042604 v2509 v
8 2025-05-28 PP 7426.67 ... -0.072532 pp2509 pp
9 2025-05-28 I 751.44 ... -0.071117 i2509 i
10 2025-05-28 EG 4521.67 ... -0.038408 eg2509 eg
11 2025-05-28 EB 8110.0 ... -0.120345 eb2507 eb
12 2025-05-28 PG 4730.0 ... -0.135307 pg2507 pg
13 2025-05-28 LH 14550.0 ... -0.068041 lh2509 lh
14 2025-05-28 CF 14580.67 ... -0.085776 CF509 CF
15 2025-05-28 SR 6145.0 ... -0.054679 SR509 SR
16 2025-05-28 TA 4893.75 ... -0.040817 TA509 TA
17 2025-05-28 OI 9525.0 ... -0.010289 OI509 OI
18 2025-05-28 MA 2246.25 ... -0.016583 MA509 MA
19 2025-05-28 FG 1152.0 ... -0.117188 FG509 FG
20 2025-05-28 RM 2550.0 ... 0.024314 RM509 RM
21 2025-05-28 SF 5380.0 ... -0.006691 SF509 SF
22 2025-05-28 SM 5586.0 ... 0.005013 SM509 SM
23 2025-05-28 CY 23800.0 ... -0.176891 CY507 CY
24 2025-05-28 UR 1896.0 ... -0.054325 UR509 UR
25 2025-05-28 SA 1450.0 ... -0.157241 SA509 SA
26 2025-05-28 PF 6535.21 ... -0.018241 PF507 PF
27 2025-05-28 PX 6850.0 ... -0.032409 PX509 PX
28 2025-05-28 SH 881.0 ... 1.779796 SH509 SH
29 2025-05-28 CU 78561.67 ... -0.006513 cu2507 cu
30 2025-05-28 AL 20376.67 ... -0.011124 al2507 al
31 2025-05-28 ZN 22828.0 ... -0.020501 zn2507 zn
32 2025-05-28 PB 16681.25 ... 0.003822 pb2507 pb
33 2025-05-28 NI 123283.33 ... -0.016574 ni2507 ni
34 2025-05-28 SN 265025.0 ... -0.012357 sn2507 sn
35 2025-05-28 AU 767.97 ... 0.003399 au2508 au
36 2025-05-28 AG 8216.67 ... 0.000892 ag2508 ag
37 2025-05-28 RB 3061.67 ... -0.031901 rb2510 rb
38 2025-05-28 WR 3255.0 ... -0.007988 wr2510 wr
39 2025-05-28 HC 3226.67 ... -0.039257 hc2510 hc
40 2025-05-28 FU 5350.0 ... -0.472336 fu2509 fu
41 2025-05-28 BU 3620.0 ... -0.045856 bu2509 bu
42 2025-05-28 RU 13658.33 ... 0.030141 ru2509 ru
43 2025-05-28 SP 6266.67 ... -0.154575 sp2507 sp
44 2025-05-28 SS 13175.0 ... -0.033017 ss2507 ss
45 2025-05-28 BR 12030.0 ... -0.058188 br2507 br
46 2025-05-28 SI 8990.0 ... -0.182425 SI2507 si
47 2025-05-28 LC 61200.0 ... -0.01634 LC2507 lc
[48 rows x 15 columns]
2025-06-03 16:25:50,675 - future_1d - INFO - save future_spot 2025-05-28 completed
2025-06-03 16:25:58,081 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-29, end_day=2025-05-29) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-29 C 2294.29 ... 0.014693 c2507 c
1 2025-05-29 A 4255.0 ... -0.033843 a2507 a
2 2025-05-29 M 2952.0 ... 0.000339 m2509 m
3 2025-05-29 Y 7984.0 ... -0.03507 y2509 y
4 2025-05-29 P 8652.0 ... -0.060102 p2509 p
5 2025-05-29 JD 3040.0 ... -0.041447 jd2507 jd
6 2025-05-29 L 7378.33 ... -0.052496 l2509 l
7 2025-05-29 V 4591.0 ... 0.031366 v2509 v
8 2025-05-29 PP 7418.33 ... -0.070141 pp2509 pp
9 2025-05-29 I 753.67 ... -0.064577 i2509 i
10 2025-05-29 EG 4521.67 ... -0.041062 eg2509 eg
11 2025-05-29 EB 8110.0 ... -0.116523 eb2507 eb
12 2025-05-29 PG 4747.5 ... -0.135334 pg2507 pg
13 2025-05-29 LH 14570.0 ... -0.072066 lh2509 lh
14 2025-05-29 CF 14581.67 ... -0.087553 CF509 CF
15 2025-05-29 SR 6130.0 ... -0.056607 SR509 SR
16 2025-05-29 TA 4972.5 ... -0.044344 TA509 TA
17 2025-05-29 OI 9530.0 ... -0.015005 OI509 OI
18 2025-05-29 MA 2247.0 ... -0.020472 MA509 MA
19 2025-05-29 FG 1150.4 ... -0.13943 FG509 FG
20 2025-05-29 RM 2543.33 ... 0.024248 RM509 RM
21 2025-05-29 SF 5298.57 ... -0.004637 SF509 SF
22 2025-05-29 SM 5570.0 ... -0.002513 SM509 SM
23 2025-05-29 CY 23800.0 ... -0.177311 CY507 CY
24 2025-05-29 UR 1896.0 ... -0.05538 UR509 UR
25 2025-05-29 SA 1450.0 ... -0.168966 SA509 SA
26 2025-05-29 PF 6522.08 ... -0.010745 PF507 PF
27 2025-05-29 PX 6850.0 ... -0.021022 PX509 PX
28 2025-05-29 SH 885.0 ... 1.788701 SH509 SH
29 2025-05-29 CU 78550.0 ... -0.007129 cu2507 cu
30 2025-05-29 AL 20396.67 ... -0.012584 al2507 al
31 2025-05-29 ZN 22826.0 ... -0.020415 zn2507 zn
32 2025-05-29 PB 16687.5 ... 0.004045 pb2507 pb
33 2025-05-29 NI 121758.33 ... -0.016577 ni2507 ni
34 2025-05-29 SN 260550.0 ... -0.010977 sn2507 sn
35 2025-05-29 AU 760.78 ... 0.007466 au2508 au
36 2025-05-29 AG 8178.0 ... 0.004157 ag2508 ag
37 2025-05-29 RB 3069.0 ... -0.031932 rb2510 rb
38 2025-05-29 WR 3252.5 ... -0.002306 wr2510 wr
39 2025-05-29 HC 3226.67 ... -0.038947 hc2510 hc
40 2025-05-29 FU 5350.0 ... -0.460935 fu2509 fu
41 2025-05-29 BU 3611.67 ... -0.035626 bu2509 bu
42 2025-05-29 RU 13708.33 ... 0.009605 ru2509 ru
43 2025-05-29 SP 6250.0 ... -0.13696 sp2507 sp
44 2025-05-29 SS 13175.0 ... -0.03833 ss2507 ss
45 2025-05-29 BR 11910.0 ... -0.061713 br2508 br
46 2025-05-29 SI 8920.0 ... -0.177691 SI2509 si
47 2025-05-29 LC 60200.0 ... -0.018605 LC2507 lc
[48 rows x 15 columns]
2025-06-03 16:25:58,251 - future_1d - INFO - save future_spot 2025-05-29 completed
2025-06-03 16:26:07,209 - 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-03 16:26:07,363 - future_1d - INFO - save future_spot 2025-05-30 completed
2025-06-03 16:26:15,205 - 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 7904.0 ... -0.028593 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 9456.67 ... -0.012337 OI509 OI
18 2025-06-03 MA 2293.0 ... -0.033144 MA509 MA
19 2025-06-03 FG 1150.4 ... -0.165508 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 1888.0 ... -0.060381 UR509 UR
25 2025-06-03 SA 1450.0 ... -0.184138 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 20303.33 ... -0.017895 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 765.29 ... 0.026643 au2508 au
36 2025-06-03 AG 8182.33 ... 0.033813 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 8780.0 ... -0.190774 SI2509 si
47 2025-06-03 LC 59900.0 ... -0.005676 LC2507 lc
[48 rows x 15 columns]
2025-06-03 16:26:15,380 - future_1d - INFO - save future_spot 2025-06-03 add
2025-06-03 16:26:15,387 - future_1d - INFO - 0 ... 4
date 2025-06-03 ... 2025-06-03
variety C ... P
spot_price 2297.14 ... 8636.0
near_contract c2507 ... p2506
near_contract_price 2326.0 ... 8630.0
dominant_contract c2507 ... p2509
dominant_contract_price 2326.0 ... 8190.0
near_month 2507 ... 2506
dominant_month 2507 ... 2509
near_basis 28.86 ... -6.0
dom_basis 28.86 ... -446.0
near_basis_rate 0.0126 ... -0.0007
dom_basis_rate 0.0126 ... -0.0516
symbol c2507 ... p2509
comd c ... p
created_at 2025-06-03 16:26:15.336449 ... 2025-06-03 16:26:15.336449
updated_at 2025-06-03 16:26:15.336845 ... 2025-06-03 16:26:15.336845
[17 rows x 5 columns]
=========================================================================
2025-06-03 18:25:34 Tue START TASK.01 future_1d future_spot
=========================================================================
2025-06-03 18:25:36,423 - future_1d - INFO - future_spot check=True check_last=5 start...
2025-06-03 18:25:36,877 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-27, end_day=2025-05-27) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-27 C 2294.29 ... 0.01077 c2507 c
1 2025-05-27 A 4255.0 ... -0.028672 a2507 a
2 2025-05-27 M 2962.0 ... -0.00135 m2509 m
3 2025-05-27 Y 7994.0 ... -0.034276 y2509 y
4 2025-05-27 P 8488.0 ... -0.057493 p2509 p
5 2025-05-27 JD 3040.0 ... -0.046382 jd2507 jd
6 2025-05-27 L 7451.67 ... -0.056453 l2509 l
7 2025-05-27 V 4580.0 ... 0.049563 v2509 v
8 2025-05-27 PP 7426.67 ... -0.071859 pp2509 pp
9 2025-05-27 I 757.33 ... -0.07636 i2509 i
10 2025-05-27 EG 4548.33 ... -0.040087 eg2509 eg
11 2025-05-27 EB 8110.0 ... -0.119112 eb2507 eb
12 2025-05-27 PG 4730.0 ... -0.137632 pg2507 pg
13 2025-05-27 LH 14500.0 ... -0.065862 lh2509 lh
14 2025-05-27 CF 14597.17 ... -0.088179 CF509 CF
15 2025-05-27 SR 6145.0 ... -0.051912 SR509 SR
16 2025-05-27 TA 4938.75 ... -0.048342 TA509 TA
17 2025-05-27 OI 9545.0 ... -0.014982 OI509 OI
18 2025-05-27 MA 2253.75 ... -0.024293 MA509 MA
19 2025-05-27 FG 1152.0 ... -0.109375 FG509 FG
20 2025-05-27 RM 2543.33 ... 0.015991 RM509 RM
21 2025-05-27 SF 5380.0 ... 0.016357 SF507 SF
22 2025-05-27 SM 5586.0 ... 0.006087 SM509 SM
23 2025-05-27 CY 23800.0 ... -0.180252 CY507 CY
24 2025-05-27 UR 1886.0 ... -0.033934 UR509 UR
25 2025-05-27 SA 1450.0 ... -0.144828 SA509 SA
26 2025-05-27 PF 6545.21 ... -0.021575 PF507 PF
27 2025-05-27 PX 6850.0 ... -0.031533 PX509 PX
28 2025-05-27 SH 881.0 ... 1.800227 SH509 SH
29 2025-05-27 CU 78556.67 ... -0.007214 cu2507 cu
30 2025-05-27 AL 20213.33 ... -0.007586 al2507 al
31 2025-05-27 ZN 22736.0 ... -0.014338 zn2507 zn
32 2025-05-27 PB 16718.75 ... 0.004262 pb2507 pb
33 2025-05-27 NI 123400.0 ... -0.007131 ni2507 ni
34 2025-05-27 SN 264975.0 ... 0.001453 sn2507 sn
35 2025-05-27 AU 773.68 ... 0.00411 au2508 au
36 2025-05-27 AG 8239.33 ... 0.001902 ag2508 ag
37 2025-05-27 RB 3077.11 ... -0.029284 rb2510 rb
38 2025-05-27 WR 3277.5 ... -0.03341 wr2510 wr
39 2025-05-27 HC 3243.33 ... -0.038951 hc2510 hc
40 2025-05-27 FU 5325.0 ... -0.44 fu2507 fu
41 2025-05-27 BU 3583.33 ... -0.03386 bu2509 bu
42 2025-05-27 RU 14258.33 ... 0.012391 ru2509 ru
43 2025-05-27 SP 6266.67 ... -0.153298 sp2507 sp
44 2025-05-27 SS 13225.0 ... -0.028355 ss2507 ss
45 2025-05-27 BR 12230.0 ... -0.052739 br2507 br
46 2025-05-27 SI 9000.0 ... -0.163333 SI2507 si
47 2025-05-27 LC 62200.0 ... -0.023473 LC2507 lc
[48 rows x 15 columns]
2025-06-03 18:25:37,047 - future_1d - INFO - save future_spot 2025-05-27 completed
2025-06-03 18:25:42,001 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-28, end_day=2025-05-28) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-28 C 2294.29 ... 0.012078 c2507 c
1 2025-05-28 A 4255.0 ... -0.029142 a2507 a
2 2025-05-28 M 2966.0 ... -0.001011 m2509 m
3 2025-05-28 Y 7974.0 ... -0.030098 y2509 y
4 2025-05-28 P 8572.0 ... -0.058329 p2509 p
5 2025-05-28 JD 3040.0 ... -0.050329 jd2507 jd
6 2025-05-28 L 7431.67 ... -0.059565 l2509 l
7 2025-05-28 V 4577.0 ... 0.042604 v2509 v
8 2025-05-28 PP 7426.67 ... -0.072532 pp2509 pp
9 2025-05-28 I 751.44 ... -0.071117 i2509 i
10 2025-05-28 EG 4521.67 ... -0.038408 eg2509 eg
11 2025-05-28 EB 8110.0 ... -0.120345 eb2507 eb
12 2025-05-28 PG 4730.0 ... -0.135307 pg2507 pg
13 2025-05-28 LH 14550.0 ... -0.068041 lh2509 lh
14 2025-05-28 CF 14580.67 ... -0.085776 CF509 CF
15 2025-05-28 SR 6145.0 ... -0.054679 SR509 SR
16 2025-05-28 TA 4893.75 ... -0.040817 TA509 TA
17 2025-05-28 OI 9525.0 ... -0.010289 OI509 OI
18 2025-05-28 MA 2246.25 ... -0.016583 MA509 MA
19 2025-05-28 FG 1152.0 ... -0.117188 FG509 FG
20 2025-05-28 RM 2550.0 ... 0.024314 RM509 RM
21 2025-05-28 SF 5380.0 ... -0.006691 SF509 SF
22 2025-05-28 SM 5586.0 ... 0.005013 SM509 SM
23 2025-05-28 CY 23800.0 ... -0.176891 CY507 CY
24 2025-05-28 UR 1896.0 ... -0.054325 UR509 UR
25 2025-05-28 SA 1450.0 ... -0.157241 SA509 SA
26 2025-05-28 PF 6535.21 ... -0.018241 PF507 PF
27 2025-05-28 PX 6850.0 ... -0.032409 PX509 PX
28 2025-05-28 SH 881.0 ... 1.779796 SH509 SH
29 2025-05-28 CU 78561.67 ... -0.006513 cu2507 cu
30 2025-05-28 AL 20376.67 ... -0.011124 al2507 al
31 2025-05-28 ZN 22828.0 ... -0.020501 zn2507 zn
32 2025-05-28 PB 16681.25 ... 0.003822 pb2507 pb
33 2025-05-28 NI 123283.33 ... -0.016574 ni2507 ni
34 2025-05-28 SN 265025.0 ... -0.012357 sn2507 sn
35 2025-05-28 AU 767.97 ... 0.003399 au2508 au
36 2025-05-28 AG 8216.67 ... 0.000892 ag2508 ag
37 2025-05-28 RB 3061.67 ... -0.031901 rb2510 rb
38 2025-05-28 WR 3255.0 ... -0.007988 wr2510 wr
39 2025-05-28 HC 3226.67 ... -0.039257 hc2510 hc
40 2025-05-28 FU 5350.0 ... -0.472336 fu2509 fu
41 2025-05-28 BU 3620.0 ... -0.045856 bu2509 bu
42 2025-05-28 RU 13658.33 ... 0.030141 ru2509 ru
43 2025-05-28 SP 6266.67 ... -0.154575 sp2507 sp
44 2025-05-28 SS 13175.0 ... -0.033017 ss2507 ss
45 2025-05-28 BR 12030.0 ... -0.058188 br2507 br
46 2025-05-28 SI 8990.0 ... -0.182425 SI2507 si
47 2025-05-28 LC 61200.0 ... -0.01634 LC2507 lc
[48 rows x 15 columns]
2025-06-03 18:25:42,154 - future_1d - INFO - save future_spot 2025-05-28 completed
2025-06-03 18:25:48,846 - future_1d - INFO - futures_spot_price_daily(start_day=2025-05-29, end_day=2025-05-29) done
date variety spot_price ... dom_basis_rate symbol comd
0 2025-05-29 C 2294.29 ... 0.014693 c2507 c
1 2025-05-29 A 4255.0 ... -0.033843 a2507 a
2 2025-05-29 M 2952.0 ... 0.000339 m2509 m
3 2025-05-29 Y 7984.0 ... -0.03507 y2509 y
4 2025-05-29 P 8652.0 ... -0.060102 p2509 p
5 2025-05-29 JD 3040.0 ... -0.041447 jd2507 jd
6 2025-05-29 L 7378.33 ... -0.052496 l2509 l
7 2025-05-29 V 4591.0 ... 0.031366 v2509 v
8 2025-05-29 PP 7418.33 ... -0.070141 pp2509 pp
9 2025-05-29 I 753.67 ... -0.064577 i2509 i
10 2025-05-29 EG 4521.67 ... -0.041062 eg2509 eg
11 2025-05-29 EB 8110.0 ... -0.116523 eb2507 eb
12 2025-05-29 PG 4747.5 ... -0.135334 pg2507 pg
13 2025-05-29 LH 14570.0 ... -0.072066 lh2509 lh
14 2025-05-29 CF 14581.67 ... -0.087553 CF509 CF
15 2025-05-29 SR 6130.0 ... -0.056607 SR509 SR
16 2025-05-29 TA 4972.5 ... -0.044344 TA509 TA
17 2025-05-29 OI 9530.0 ... -0.015005 OI509 OI
18 2025-05-29 MA 2247.0 ... -0.020472 MA509 MA
19 2025-05-29 FG 1150.4 ... -0.13943 FG509 FG
20 2025-05-29 RM 2543.33 ... 0.024248 RM509 RM
21 2025-05-29 SF 5298.57 ... -0.004637 SF509 SF
22 2025-05-29 SM 5570.0 ... -0.002513 SM509 SM
23 2025-05-29 CY 23800.0 ... -0.177311 CY507 CY
24 2025-05-29 UR 1896.0 ... -0.05538 UR509 UR
25 2025-05-29 SA 1450.0 ... -0.168966 SA509 SA
26 2025-05-29 PF 6522.08 ... -0.010745 PF507 PF
27 2025-05-29 PX 6850.0 ... -0.021022 PX509 PX
28 2025-05-29 SH 885.0 ... 1.788701 SH509 SH
29 2025-05-29 CU 78550.0 ... -0.007129 cu2507 cu
30 2025-05-29 AL 20396.67 ... -0.012584 al2507 al
31 2025-05-29 ZN 22826.0 ... -0.020415 zn2507 zn
32 2025-05-29 PB 16687.5 ... 0.004045 pb2507 pb
33 2025-05-29 NI 121758.33 ... -0.016577 ni2507 ni
34 2025-05-29 SN 260550.0 ... -0.010977 sn2507 sn
35 2025-05-29 AU 760.78 ... 0.007466 au2508 au
36 2025-05-29 AG 8178.0 ... 0.004157 ag2508 ag
37 2025-05-29 RB 3069.0 ... -0.031932 rb2510 rb
38 2025-05-29 WR 3252.5 ... -0.002306 wr2510 wr
39 2025-05-29 HC 3226.67 ... -0.038947 hc2510 hc
40 2025-05-29 FU 5350.0 ... -0.460935 fu2509 fu
41 2025-05-29 BU 3611.67 ... -0.035626 bu2509 bu
42 2025-05-29 RU 13708.33 ... 0.009605 ru2509 ru
43 2025-05-29 SP 6250.0 ... -0.13696 sp2507 sp
44 2025-05-29 SS 13175.0 ... -0.03833 ss2507 ss
45 2025-05-29 BR 11910.0 ... -0.061713 br2508 br
46 2025-05-29 SI 8920.0 ... -0.177691 SI2509 si
47 2025-05-29 LC 60200.0 ... -0.018605 LC2507 lc
[48 rows x 15 columns]
2025-06-03 18:25:49,000 - future_1d - INFO - save future_spot 2025-05-29 completed
2025-06-03 18:25:58,014 - 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-03 18:25:58,170 - future_1d - INFO - save future_spot 2025-05-30 completed
2025-06-03 18:26:06,211 - 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-03 18:26:06,386 - future_1d - INFO - save future_spot 2025-06-03 add
2025-06-03 18:26:06,394 - future_1d - INFO - 3 ... 25
date 2025-06-03 ... 2025-06-03
variety Y ... SA
spot_price 7954.0 ... 1430.0
near_contract y2507 ... SA506
near_contract_price 7730.0 ... 1218.0
dominant_contract y2509 ... SA509
dominant_contract_price 7678.0 ... 1183.0
near_month 2507 ... 2506
dominant_month 2509 ... 2509
near_basis -224.0 ... -212.0
dom_basis -276.0 ... -247.0
near_basis_rate -0.0282 ... -0.1483
dom_basis_rate -0.0347 ... -0.1727
symbol y2509 ... SA509
comd y ... SA
created_at 2025-06-03 18:26:06.349825 ... 2025-06-03 18:26:06.349825
updated_at 2025-06-03 18:26:06.350191 ... 2025-06-03 18:26:06.350191
[17 rows x 5 columns]