PREVIEW / futures_daily / 2024-09-24
file: by_date/futures_daily/2024/2024-09-24.parquet size: 10 KB rows: 130
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-09-24 | ES | Futures | 5907.05 | 5927.77 | 5887.36 | 5925.47 | 1181221.0 |
| 2024-09-24 | NQ | Futures | 20579.22 | 20734.61 | 20466.13 | 20686.4 | 457126.0 |
| 2024-09-24 | YM | Futures | 42931.5 | 43104.3 | 42854.7 | 43044.7 | 113321.0 |
| 2024-09-24 | CL | Futures | 67.31 | 68.87 | 67.0 | 68.07 | 318516.0 |
| 2024-09-24 | GC | Futures | 2709.1 | 2746.0 | 2702.8 | 2733.3 | 216553.0 |
| 2024-09-24 | ZN | Futures | 114.832368 | 115.051395 | 114.44125 | 114.988816 | 2043257.0 |
| 2024-09-24 | A6 | Futures | 0.68403 | 0.68958 | 0.68168 | 0.68878 | 126407.0 |
| 2024-09-24 | AD | Futures | 0.74182 | 0.74769 | 0.74172 | 0.74704 | 80955.0 |
| 2024-09-24 | ALI | Futures | 2477.93 | 2588.0 | 2477.93 | 2575.14 | 12796.0 |
| 2024-09-24 | B | Futures | 72.76 | 74.47 | 72.59 | 73.78 | 238473.0 |
| 2024-09-24 | B6 | Futures | 1.3337 | 1.3408 | 1.3324 | 1.3393 | 86576.0 |
| 2024-09-24 | BFX | Futures | 4272.0 | 4272.0 | 4272.0 | 4272.0 | 0.0 |
| 2024-09-24 | BR | Futures | 0.17552 | 0.17942 | 0.17552 | 0.17761 | 5.0 |
| 2024-09-24 | BTC | Futures | 69762.8 | 71161.7 | 69030.6 | 70883.0 | 7799.0 |
| 2024-09-24 | BZ | Futures | 71.36 | 72.89 | 71.06 | 72.21 | 31341.0 |
| 2024-09-24 | C | Futures | 5165.0 | 5193.0 | 5034.0 | 5086.0 | 7117.0 |
| 2024-09-24 | CB | Futures | 297.705 | 298.276 | 294.126 | 297.005 | 21.0 |
| 2024-09-24 | CC | Futures | 6375.0 | 6493.0 | 6297.0 | 6442.0 | 8515.0 |
| 2024-09-24 | CNH | Futures | 6.9756 | 6.986 | 6.9278 | 6.9537 | 1489.0 |
| 2024-09-24 | CSC | Futures | 2.242 | 2.242 | 2.205 | 2.206 | 80.0 |
| 2024-09-24 | CT | Futures | 80.54 | 81.73 | 80.25 | 81.22 | 25367.0 |
| 2024-09-24 | DC | Futures | 21.73 | 21.76 | 21.17 | 21.36 | 240.0 |
| 2024-09-24 | DX | Futures | 100.375 | 100.495 | 99.762 | 99.885 | 25822.0 |
| 2024-09-24 | E1 | Futures | 1.2028 | 1.2084 | 1.19997 | 1.20689 | 18852.0 |
| 2024-09-24 | E6 | Futures | 1.1193 | 1.12638 | 1.11849 | 1.12492 | 168674.0 |
| 2024-09-24 | E7 | Futures | 1.1191 | 1.126 | 1.1181 | 1.1246 | 3364.0 |
| 2024-09-24 | EBM | Futures | 239.88 | 242.34 | 238.51 | 239.06 | 37851.0 |
| 2024-09-24 | ER | Futures | 97.72 | 97.74 | 97.684 | 97.72 | 465510.0 |
| 2024-09-24 | ESG | Futures | 508.18 | 509.73 | 506.54 | 509.59 | 166.0 |
| 2024-09-24 | EW | Futures | 3180.1 | 3196.2 | 3174.0 | 3180.3 | 7453.0 |
| 2024-09-24 | FBON | Futures | 125.81 | 126.18 | 125.53 | 126.18 | 256.0 |
| 2024-09-24 | FBTP | Futures | 120.44 | 120.85 | 120.12 | 120.77 | 306805.0 |
| 2024-09-24 | FBTS | Futures | 107.57 | 107.77 | 107.55 | 107.76 | 187765.0 |
| 2024-09-24 | FCE | Futures | 7576.6 | 7661.8 | 7576.6 | 7631.3 | 39675.0 |
| 2024-09-24 | FDAX | Futures | 19219.4 | 19387.0 | 19200.2 | 19341.6 | 39129.0 |
| 2024-09-24 | FDIV | Futures | 193.57 | 193.57 | 193.57 | 193.57 | 0.0 |
| 2024-09-24 | FDXM | Futures | 19176.8 | 19344.0 | 19157.6 | 19299.7 | 21649.0 |
| 2024-09-24 | FDXS | Futures | 19137.9 | 19300.7 | 19114.7 | 19256.5 | 30645.0 |
| 2024-09-24 | FESX | Futures | 4928.9 | 4990.0 | 4922.9 | 4972.0 | 670850.0 |
| 2024-09-24 | FEU3 | Futures | 97.714 | 97.725 | 97.689 | 97.725 | 12052.0 |
| 2024-09-24 | FGBL | Futures | 136.51 | 136.77 | 135.98 | 136.71 | 1277306.0 |
| 2024-09-24 | FGBM | Futures | 119.27 | 119.48 | 119.04 | 119.46 | 941093.0 |
| 2024-09-24 | FGBS | Futures | 107.42 | 107.51 | 107.34 | 107.5 | 846724.0 |
| 2024-09-24 | FGBX | Futures | 136.23 | 136.55 | 134.54 | 136.35 | 115061.0 |
| 2024-09-24 | FMWO | Futures | 12240.1 | 12268.1 | 12190.3 | 12237.0 | 9435.0 |
| 2024-09-24 | FOAT | Futures | 126.23 | 126.47 | 125.66 | 126.42 | 243583.0 |
| 2024-09-24 | FSMX | Futures | 26498.7 | 26521.8 | 26278.7 | 26326.7 | 93.0 |
| 2024-09-24 | FTDX | Futures | 3386.3 | 3386.3 | 3364.0 | 3370.6 | 17.0 |
| 2024-09-24 | FTI | Futures | 916.92 | 920.35 | 913.04 | 916.95 | 7237.0 |
| 2024-09-24 | FTUK | Futures | 8335.9 | 8384.5 | 8317.4 | 8349.4 | 69808.0 |
> showing 50 of 130 rows — these rows as CSV