PREVIEW / futures_daily / 2024-12-26
file: by_date/futures_daily/2024/2024-12-26.parquet size: 9 KB rows: 100
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-26 | ES | Futures | 6168.49 | 6176.83 | 6132.08 | 6164.45 | 911486.0 |
| 2024-12-26 | NQ | Futures | 22343.6 | 22406.18 | 22161.96 | 22301.55 | 407116.0 |
| 2024-12-26 | YM | Futures | 43645.0 | 43746.0 | 43430.0 | 43702.0 | 59571.0 |
| 2024-12-26 | CL | Futures | 68.52 | 69.06 | 67.67 | 67.95 | 144877.0 |
| 2024-12-26 | GC | Futures | 2663.3 | 2681.1 | 2659.3 | 2679.3 | 79265.0 |
| 2024-12-26 | ZN | Futures | 108.53125 | 108.6875 | 108.203125 | 108.65625 | 1018693.0 |
| 2024-12-26 | A6 | Futures | 0.62325 | 0.6255 | 0.6216 | 0.62225 | 27124.0 |
| 2024-12-26 | AD | Futures | 0.6982 | 0.6991 | 0.6956 | 0.6959 | 22033.0 |
| 2024-12-26 | ALI | Futures | 2570.14 | 2570.14 | 2527.1 | 2527.1 | 4.0 |
| 2024-12-26 | B | Futures | 73.37 | 73.75 | 72.57 | 72.85 | 155074.0 |
| 2024-12-26 | B6 | Futures | 1.2544 | 1.2544 | 1.2492 | 1.2517 | 25638.0 |
| 2024-12-26 | BR | Futures | 0.15879 | 0.15879 | 0.15879 | 0.15879 | 0.0 |
| 2024-12-26 | BTC | Futures | 105947.9 | 106811.3 | 101167.2 | 101620.0 | 11193.0 |
| 2024-12-26 | BZ | Futures | 71.99 | 72.37 | 71.22 | 71.5 | 17172.0 |
| 2024-12-26 | C | Futures | 9134.0 | 9134.0 | 9134.0 | 9134.0 | 0.0 |
| 2024-12-26 | CB | Futures | 275.525 | 275.525 | 274.0 | 274.0 | 14.0 |
| 2024-12-26 | CC | Futures | 10287.0 | 10422.0 | 9371.0 | 9577.0 | 7450.0 |
| 2024-12-26 | CNH | Futures | 7.2875 | 7.2955 | 7.2825 | 7.2895 | 1044.0 |
| 2024-12-26 | CSC | Futures | 1.912 | 1.912 | 1.905 | 1.905 | 45.0 |
| 2024-12-26 | CT | Futures | 76.34 | 76.77 | 76.03 | 76.31 | 7666.0 |
| 2024-12-26 | DC | Futures | 19.22 | 19.28 | 19.1 | 19.27 | 67.0 |
| 2024-12-26 | DX | Futures | 107.935 | 108.075 | 107.795 | 107.893 | 7276.0 |
| 2024-12-26 | E1 | Futures | 1.1228 | 1.1229 | 1.11985 | 1.12225 | 7394.0 |
| 2024-12-26 | E6 | Futures | 1.04365 | 1.04685 | 1.04285 | 1.04565 | 63172.0 |
| 2024-12-26 | E7 | Futures | 1.0436 | 1.0468 | 1.0428 | 1.0457 | 1744.0 |
| 2024-12-26 | ER | Futures | 97.735 | 97.735 | 97.735 | 97.735 | 0.0 |
| 2024-12-26 | ESG | Futures | 534.5 | 536.0 | 534.02 | 535.68 | 164.0 |
| 2024-12-26 | EW | Futures | 3184.3 | 3200.1 | 3166.2 | 3194.6 | 6476.0 |
| 2024-12-26 | FTUK | Futures | 8155.5 | 8155.5 | 8155.5 | 8155.5 | 0.0 |
| 2024-12-26 | G | Futures | 92.41 | 92.41 | 92.41 | 92.41 | 0.0 |
| 2024-12-26 | GF | Futures | 256.435 | 260.215 | 256.435 | 259.589 | 5007.0 |
| 2024-12-26 | GSCI | Futures | 567.56 | 567.56 | 567.09 | 567.09 | 1.0 |
| 2024-12-26 | HE | Futures | 84.35 | 84.7 | 83.7 | 84.2 | 11047.0 |
| 2024-12-26 | HG | Futures | 4.2709 | 4.3026 | 4.2268 | 4.2839 | 27355.0 |
| 2024-12-26 | HH | Futures | 2.697 | 2.7 | 2.559 | 2.602 | 6885.0 |
| 2024-12-26 | HO | Futures | 2.0777 | 2.1009 | 2.0548 | 2.063 | 16930.0 |
| 2024-12-26 | HRC | Futures | 823.2 | 846.0 | 823.2 | 823.2 | 60.0 |
| 2024-12-26 | J1 | Futures | 0.0064205 | 0.006428 | 0.006384 | 0.00639 | 65842.0 |
| 2024-12-26 | J7 | Futures | 0.006425 | 0.006427 | 0.006386 | 0.00639 | 335.0 |
| 2024-12-26 | JB | Futures | 139.14 | 139.31 | 138.79 | 138.91 | 550.0 |
| 2024-12-26 | KC | Futures | 297.46 | 298.81 | 290.56 | 292.64 | 7162.0 |
| 2024-12-26 | KE | Futures | 586.28 | 597.32 | 586.28 | 594.09 | 9931.0 |
| 2024-12-26 | KRW | Futures | 0.0006824 | 0.0006824 | 0.000679 | 0.0006797 | 30.0 |
| 2024-12-26 | LBS | Futures | 591.5 | 597.5 | 591.5 | 597.0 | 344.0 |
| 2024-12-26 | LE | Futures | 188.87 | 191.46 | 188.619 | 191.183 | 20376.0 |
| 2024-12-26 | M2K | Futures | 2279.1 | 2304.8 | 2257.7 | 2300.5 | 55215.0 |
| 2024-12-26 | MBT | Futures | 100000.0 | 101575.0 | 96050.0 | 96505.0 | 15089.0 |
| 2024-12-26 | MCL | Futures | 70.57 | 71.1 | 69.8 | 70.07 | 1800.0 |
| 2024-12-26 | MES | Futures | 6099.0 | 6107.5 | 6062.0 | 6095.25 | 590184.0 |
| 2024-12-26 | MET | Futures | 3523.5 | 3560.0 | 3337.0 | 3364.5 | 28274.0 |
> showing 50 of 100 rows — these rows as CSV