PREVIEW / futures_daily / 2024-07-19
file: by_date/futures_daily/2024/2024-07-19.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-07-19 | ES | Futures | 5786.83 | 5792.0 | 5724.34 | 5736.48 | 2106581.0 |
| 2024-07-19 | NQ | Futures | 20680.67 | 20706.32 | 20368.72 | 20429.87 | 774109.0 |
| 2024-07-19 | YM | Futures | 41772.1 | 41815.9 | 41265.3 | 41363.2 | 189677.0 |
| 2024-07-19 | CL | Futures | 75.02 | 75.45 | 72.9 | 72.95 | 427059.0 |
| 2024-07-19 | GC | Futures | 2559.4 | 2559.8 | 2504.7 | 2508.3 | 254408.0 |
| 2024-07-19 | ZN | Futures | 111.705633 | 111.815579 | 111.360086 | 111.407206 | 1573847.0 |
| 2024-07-19 | A6 | Futures | 0.67265 | 0.67285 | 0.66994 | 0.67024 | 81570.0 |
| 2024-07-19 | AD | Futures | 0.73439 | 0.73454 | 0.73208 | 0.73298 | 74941.0 |
| 2024-07-19 | ALI | Futures | 2394.76 | 2410.75 | 2384.45 | 2385.48 | 1398.0 |
| 2024-07-19 | B | Futures | 81.56 | 82.17 | 79.48 | 79.55 | 362336.0 |
| 2024-07-19 | B6 | Futures | 1.2948 | 1.2953 | 1.2903 | 1.2911 | 76096.0 |
| 2024-07-19 | BFX | Futures | 3971.0 | 3971.0 | 3971.0 | 3971.0 | 0.0 |
| 2024-07-19 | BR | Futures | 0.17316 | 0.17388 | 0.17137 | 0.17152 | 455.0 |
| 2024-07-19 | BTC | Futures | 72993.2 | 77204.4 | 72292.3 | 76908.1 | 17385.0 |
| 2024-07-19 | BZ | Futures | 80.0 | 80.51 | 77.89 | 77.95 | 45739.0 |
| 2024-07-19 | C | Futures | 6579.0 | 6752.0 | 6218.0 | 6266.0 | 4020.0 |
| 2024-07-19 | CB | Futures | 302.019 | 302.019 | 299.105 | 301.047 | 21.0 |
| 2024-07-19 | CC | Futures | 5734.0 | 5829.0 | 5337.0 | 5386.0 | 9291.0 |
| 2024-07-19 | CNH | Futures | 7.1601 | 7.1666 | 7.1557 | 7.1661 | 860.0 |
| 2024-07-19 | CSC | Futures | 1.966 | 1.986 | 1.958 | 1.958 | 136.0 |
| 2024-07-19 | CT | Futures | 78.98 | 79.8 | 78.55 | 78.61 | 7.0 |
| 2024-07-19 | DC | Futures | 19.09 | 19.23 | 18.97 | 19.03 | 358.0 |
| 2024-07-19 | DX | Futures | 103.348 | 103.602 | 103.323 | 103.579 | 8810.0 |
| 2024-07-19 | E1 | Futures | 1.15564 | 1.15595 | 1.15233 | 1.15345 | 26023.0 |
| 2024-07-19 | E6 | Futures | 1.10083 | 1.10133 | 1.09876 | 1.09907 | 179356.0 |
| 2024-07-19 | E7 | Futures | 1.1006 | 1.1009 | 1.0984 | 1.0987 | 2808.0 |
| 2024-07-19 | EBM | Futures | 251.45 | 262.55 | 251.16 | 261.38 | 47567.0 |
| 2024-07-19 | ER | Futures | 97.548 | 97.558 | 97.543 | 97.548 | 92906.0 |
| 2024-07-19 | ESG | Futures | 499.48 | 500.63 | 495.02 | 495.56 | 794.0 |
| 2024-07-19 | EW | Futures | 3119.3 | 3122.2 | 3081.3 | 3091.1 | 10334.0 |
| 2024-07-19 | FBON | Futures | 123.77 | 123.83 | 123.05 | 123.43 | 88.0 |
| 2024-07-19 | FBTP | Futures | 117.85 | 117.98 | 117.41 | 117.57 | 159220.0 |
| 2024-07-19 | FBTS | Futures | 106.495 | 106.565 | 106.414 | 106.475 | 78914.0 |
| 2024-07-19 | FCE | Futures | 7803.6 | 7808.8 | 7719.7 | 7740.1 | 57703.0 |
| 2024-07-19 | FDAX | Futures | 18895.2 | 18909.5 | 18689.6 | 18701.9 | 43870.0 |
| 2024-07-19 | FDIV | Futures | 186.31 | 186.31 | 186.31 | 186.31 | 0.0 |
| 2024-07-19 | FDXM | Futures | 18805.2 | 18820.5 | 18603.6 | 18614.8 | 28313.0 |
| 2024-07-19 | FDXS | Futures | 18749.9 | 18772.3 | 18554.0 | 18566.2 | 29241.0 |
| 2024-07-19 | FESX | Futures | 4946.7 | 4955.8 | 4888.3 | 4890.3 | 829239.0 |
| 2024-07-19 | FEU3 | Futures | 97.558 | 97.558 | 97.548 | 97.553 | 419.0 |
| 2024-07-19 | FGBL | Futures | 133.7 | 133.92 | 133.3 | 133.47 | 523025.0 |
| 2024-07-19 | FGBM | Futures | 117.46 | 117.6 | 117.3 | 117.4 | 381471.0 |
| 2024-07-19 | FGBS | Futures | 106.55 | 106.6 | 106.5 | 106.535 | 286458.0 |
| 2024-07-19 | FGBX | Futures | 132.42 | 132.85 | 131.36 | 131.7 | 67634.0 |
| 2024-07-19 | FMWO | Futures | 11886.6 | 11913.8 | 11812.2 | 11836.3 | 3405.0 |
| 2024-07-19 | FOAT | Futures | 124.65 | 124.82 | 124.23 | 124.38 | 139431.0 |
| 2024-07-19 | FSMX | Futures | 25801.3 | 25881.0 | 25661.2 | 25707.6 | 402.0 |
| 2024-07-19 | FTDX | Futures | 3386.2 | 3395.3 | 3368.8 | 3371.9 | 81.0 |
| 2024-07-19 | FTI | Futures | 928.77 | 933.09 | 918.76 | 920.24 | 15374.0 |
| 2024-07-19 | FTUK | Futures | 8229.1 | 8232.7 | 8162.5 | 8176.0 | 80475.0 |
> showing 50 of 130 rows — these rows as CSV