PREVIEW / futures_daily / 2024-12-24
file: by_date/futures_daily/2024/2024-12-24.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-24 | ES | Futures | 6106.29 | 6168.74 | 6098.45 | 6167.23 | 634201.0 |
| 2024-12-24 | NQ | Futures | 22033.27 | 22343.86 | 21998.56 | 22322.32 | 261201.0 |
| 2024-12-24 | YM | Futures | 43352.0 | 43664.0 | 43245.0 | 43645.0 | 45310.0 |
| 2024-12-24 | CL | Futures | 67.9 | 68.75 | 67.7 | 68.42 | 122602.0 |
| 2024-12-24 | GC | Futures | 2654.6 | 2661.0 | 2649.3 | 2660.7 | 53366.0 |
| 2024-12-24 | ZN | Futures | 108.546875 | 108.609375 | 108.296875 | 108.5625 | 672210.0 |
| 2024-12-24 | A6 | Futures | 0.62465 | 0.62495 | 0.62255 | 0.6229 | 33130.0 |
| 2024-12-24 | AD | Futures | 0.69795 | 0.6984 | 0.69565 | 0.69775 | 30186.0 |
| 2024-12-24 | ALI | Futures | 2538.43 | 2563.34 | 2516.53 | 2553.53 | 605.0 |
| 2024-12-24 | B | Futures | 72.75 | 73.6 | 72.58 | 73.37 | 93488.0 |
| 2024-12-24 | B6 | Futures | 1.2531 | 1.2565 | 1.2509 | 1.2511 | 31750.0 |
| 2024-12-24 | BFX | Futures | 4213.1 | 4213.1 | 4213.1 | 4213.1 | 0.0 |
| 2024-12-24 | BR | Futures | 0.15785 | 0.15785 | 0.15785 | 0.15785 | 0.0 |
| 2024-12-24 | BTC | Futures | 100877.7 | 106274.3 | 99440.3 | 105637.2 | 11227.0 |
| 2024-12-24 | BZ | Futures | 71.27 | 72.22 | 71.21 | 71.99 | 8922.0 |
| 2024-12-24 | C | Futures | 9334.0 | 9389.0 | 9101.0 | 9134.0 | 2120.0 |
| 2024-12-24 | CB | Futures | 272.025 | 272.025 | 272.025 | 272.025 | 2.0 |
| 2024-12-24 | CC | Futures | 10060.0 | 10398.0 | 9922.0 | 10293.0 | 3437.0 |
| 2024-12-24 | CNH | Futures | 7.289 | 7.2905 | 7.281 | 7.2875 | 984.0 |
| 2024-12-24 | CSC | Futures | 1.902 | 1.902 | 1.902 | 1.902 | 13.0 |
| 2024-12-24 | CT | Futures | 76.99 | 77.3 | 76.23 | 76.34 | 10175.0 |
| 2024-12-24 | DC | Futures | 18.98 | 19.26 | 18.94 | 19.26 | 65.0 |
| 2024-12-24 | DX | Futures | 107.91 | 108.06 | 107.815 | 108.023 | 7707.0 |
| 2024-12-24 | E1 | Futures | 1.12345 | 1.1235 | 1.11955 | 1.11995 | 8251.0 |
| 2024-12-24 | E6 | Futures | 1.0445 | 1.0448 | 1.0421 | 1.0427 | 66189.0 |
| 2024-12-24 | E7 | Futures | 1.0443 | 1.0447 | 1.0422 | 1.0427 | 2006.0 |
| 2024-12-24 | EBM | Futures | 240.32 | 241.62 | 238.77 | 239.8 | 11346.0 |
| 2024-12-24 | ER | Futures | 97.715 | 97.735 | 97.715 | 97.735 | 25840.0 |
| 2024-12-24 | ESG | Futures | 531.18 | 536.38 | 531.1 | 536.16 | 54.0 |
| 2024-12-24 | EW | Futures | 3165.7 | 3190.4 | 3154.3 | 3186.7 | 3571.0 |
| 2024-12-24 | FCE | Futures | 7323.8 | 7352.3 | 7302.8 | 7302.8 | 8540.0 |
| 2024-12-24 | FTI | Futures | 879.23 | 880.68 | 877.23 | 878.54 | 1753.0 |
| 2024-12-24 | FTUK | Futures | 8152.5 | 8170.5 | 8139.0 | 8155.5 | 18487.0 |
| 2024-12-24 | G | Futures | 92.79 | 92.79 | 92.29 | 92.41 | 28924.0 |
| 2024-12-24 | GF | Futures | 257.261 | 258.087 | 256.035 | 256.135 | 2180.0 |
| 2024-12-24 | GSCI | Futures | 568.24 | 568.24 | 568.03 | 568.03 | 1.0 |
| 2024-12-24 | HE | Futures | 84.25 | 84.775 | 83.5 | 84.375 | 11836.0 |
| 2024-12-24 | HG | Futures | 4.2497 | 4.2798 | 4.2398 | 4.2658 | 21852.0 |
| 2024-12-24 | HH | Futures | 2.905 | 3.097 | 2.883 | 3.093 | 13055.0 |
| 2024-12-24 | HO | Futures | 2.0867 | 2.1008 | 2.0722 | 2.0763 | 18912.0 |
| 2024-12-24 | HRC | Futures | 833.4 | 833.4 | 826.6 | 828.9 | 144.0 |
| 2024-12-24 | J1 | Futures | 0.006425 | 0.0064385 | 0.006417 | 0.006421 | 38934.0 |
| 2024-12-24 | J7 | Futures | 0.006434 | 0.006437 | 0.006418 | 0.006421 | 235.0 |
| 2024-12-24 | JB | Futures | 139.28 | 139.3 | 139.13 | 139.17 | 1378.0 |
| 2024-12-24 | KC | Futures | 294.8 | 297.05 | 290.29 | 296.2 | 7207.0 |
| 2024-12-24 | KE | Futures | 593.02 | 595.17 | 585.21 | 585.74 | 7852.0 |
| 2024-12-24 | KRW | Futures | 0.0006842 | 0.0006851 | 0.0006842 | 0.0006851 | 24.0 |
| 2024-12-24 | LBS | Futures | 594.0 | 596.5 | 591.5 | 593.0 | 272.0 |
| 2024-12-24 | LE | Futures | 188.619 | 189.147 | 188.116 | 188.443 | 9932.0 |
| 2024-12-24 | M2K | Futures | 2258.8 | 2281.0 | 2248.7 | 2278.9 | 28888.0 |
> showing 50 of 108 rows — these rows as CSV