PREVIEW / futures_daily / 2024-12-31
file: by_date/futures_daily/2024/2024-12-31.parquet size: 9 KB rows: 108
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-12-31 | ES | Futures | 6022.6 | 6051.17 | 5984.42 | 6003.13 | 1382187.0 |
| 2024-12-31 | NQ | Futures | 21675.56 | 21811.85 | 21464.53 | 21509.63 | 477280.0 |
| 2024-12-31 | YM | Futures | 42915.0 | 43100.0 | 42723.0 | 42873.0 | 97500.0 |
| 2024-12-31 | CL | Futures | 69.45 | 70.3 | 69.17 | 70.0 | 151155.0 |
| 2024-12-31 | GC | Futures | 2645.1 | 2667.3 | 2639.3 | 2666.3 | 86292.0 |
| 2024-12-31 | ZN | Futures | 109.03125 | 109.1875 | 108.703125 | 108.75 | 1185966.0 |
| 2024-12-31 | A6 | Futures | 0.622 | 0.6232 | 0.618 | 0.619 | 66809.0 |
| 2024-12-31 | AD | Futures | 0.69865 | 0.6994 | 0.69595 | 0.69725 | 77815.0 |
| 2024-12-31 | ALI | Futures | 2555.04 | 2580.71 | 2538.68 | 2563.34 | 215.0 |
| 2024-12-31 | B | Futures | 74.25 | 74.89 | 73.84 | 74.64 | 190978.0 |
| 2024-12-31 | B6 | Futures | 1.2544 | 1.256 | 1.2496 | 1.2501 | 64721.0 |
| 2024-12-31 | BFX | Futures | 4228.9 | 4228.9 | 4228.9 | 4228.9 | 0.0 |
| 2024-12-31 | BR | Futures | 0.15637 | 0.15716 | 0.15474 | 0.15632 | 249.0 |
| 2024-12-31 | BTC | Futures | 98224.1 | 102151.8 | 97523.9 | 99108.6 | 5745.0 |
| 2024-12-31 | BZ | Futures | 72.73 | 73.5 | 72.48 | 73.26 | 20588.0 |
| 2024-12-31 | C | Futures | 8999.0 | 9272.0 | 8884.0 | 9143.0 | 6172.0 |
| 2024-12-31 | CB | Futures | 270.6 | 270.6 | 268.0 | 268.225 | 20.0 |
| 2024-12-31 | CC | Futures | 9743.0 | 10265.0 | 9686.0 | 10139.0 | 11327.0 |
| 2024-12-31 | CNH | Futures | 7.297 | 7.3605 | 7.2905 | 7.325 | 479.0 |
| 2024-12-31 | CSC | Futures | 1.959 | 1.973 | 1.929 | 1.929 | 84.0 |
| 2024-12-31 | CT | Futures | 76.03 | 76.46 | 75.77 | 75.92 | 9668.0 |
| 2024-12-31 | DC | Futures | 19.76 | 19.8 | 19.31 | 19.42 | 363.0 |
| 2024-12-31 | DX | Futures | 107.85 | 108.38 | 107.665 | 108.296 | 14744.0 |
| 2024-12-31 | E1 | Futures | 1.116 | 1.1172 | 1.1101 | 1.1103 | 18571.0 |
| 2024-12-31 | E6 | Futures | 1.0441 | 1.04585 | 1.0378 | 1.03885 | 128147.0 |
| 2024-12-31 | E7 | Futures | 1.0439 | 1.0458 | 1.0379 | 1.0389 | 3821.0 |
| 2024-12-31 | EBM | Futures | 242.92 | 246.29 | 242.66 | 246.03 | 15197.0 |
| 2024-12-31 | ER | Futures | 97.735 | 97.745 | 97.73 | 97.73 | 27862.0 |
| 2024-12-31 | ESG | Futures | 523.44 | 525.46 | 519.94 | 521.46 | 312.0 |
| 2024-12-31 | EW | Futures | 3138.2 | 3166.3 | 3135.0 | 3146.7 | 10289.0 |
| 2024-12-31 | FCE | Futures | 7331.8 | 7415.9 | 7304.3 | 7396.9 | 15199.0 |
| 2024-12-31 | FTI | Futures | 874.13 | 881.28 | 872.13 | 880.72 | 2280.0 |
| 2024-12-31 | FTUK | Futures | 8136.0 | 8194.0 | 8104.5 | 8180.5 | 24780.0 |
| 2024-12-31 | G | Futures | 92.51 | 92.97 | 92.39 | 92.74 | 65060.0 |
| 2024-12-31 | GF | Futures | 261.866 | 263.668 | 261.541 | 263.318 | 2451.0 |
| 2024-12-31 | GSCI | Futures | 575.01 | 577.16 | 575.01 | 576.58 | 54.0 |
| 2024-12-31 | HE | Futures | 82.0 | 82.0 | 80.0 | 81.3 | 29050.0 |
| 2024-12-31 | HG | Futures | 4.245 | 4.2533 | 4.1594 | 4.1791 | 42752.0 |
| 2024-12-31 | HH | Futures | 3.037 | 3.125 | 2.802 | 2.848 | 11044.0 |
| 2024-12-31 | HO | Futures | 2.1422 | 2.1669 | 2.1289 | 2.1525 | 32240.0 |
| 2024-12-31 | HRC | Futures | 823.2 | 823.2 | 806.0 | 810.6 | 105.0 |
| 2024-12-31 | J1 | Futures | 0.0064285 | 0.0064635 | 0.0064 | 0.00641 | 80928.0 |
| 2024-12-31 | J7 | Futures | 0.006429 | 0.006463 | 0.0064 | 0.00641 | 524.0 |
| 2024-12-31 | JB | Futures | 139.02 | 139.18 | 138.96 | 139.14 | 233.0 |
| 2024-12-31 | KC | Futures | 287.41 | 289.62 | 281.37 | 288.22 | 14691.0 |
| 2024-12-31 | KE | Futures | 597.86 | 604.86 | 597.32 | 602.44 | 16110.0 |
| 2024-12-31 | KRW | Futures | 0.0006785 | 0.0006785 | 0.0006751 | 0.0006757 | 26.0 |
| 2024-12-31 | LBS | Futures | 583.0 | 587.0 | 579.5 | 580.5 | 559.0 |
| 2024-12-31 | LE | Futures | 191.561 | 192.793 | 191.485 | 192.692 | 17735.0 |
| 2024-12-31 | M2K | Futures | 2246.8 | 2273.4 | 2241.0 | 2249.8 | 71542.0 |
> showing 50 of 108 rows — these rows as CSV