PREVIEW / futures_daily / 2024-07-18
file: by_date/futures_daily/2024/2024-07-18.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-18 | ES | Futures | 5829.7 | 5850.35 | 5753.52 | 5778.57 | 2528379.0 |
| 2024-07-18 | NQ | Futures | 20752.44 | 20895.72 | 20477.28 | 20622.89 | 964287.0 |
| 2024-07-18 | YM | Futures | 42358.4 | 42495.1 | 41693.6 | 41767.0 | 205758.0 |
| 2024-07-18 | CL | Futures | 75.77 | 76.31 | 74.77 | 75.41 | 398369.0 |
| 2024-07-18 | GC | Futures | 2574.6 | 2591.3 | 2554.1 | 2568.2 | 192770.0 |
| 2024-07-18 | ZN | Futures | 111.972645 | 112.004059 | 111.674219 | 111.799872 | 1862237.0 |
| 2024-07-18 | A6 | Futures | 0.6749 | 0.6763 | 0.6717 | 0.67245 | 96783.0 |
| 2024-07-18 | AD | Futures | 0.73549 | 0.7363 | 0.73364 | 0.73409 | 82452.0 |
| 2024-07-18 | ALI | Futures | 2432.93 | 2459.49 | 2403.53 | 2415.65 | 18266.0 |
| 2024-07-18 | B | Futures | 82.05 | 82.61 | 81.08 | 81.94 | 368318.0 |
| 2024-07-18 | B6 | Futures | 1.3011 | 1.3014 | 1.2942 | 1.295 | 79892.0 |
| 2024-07-18 | BFX | Futures | 3990.9 | 3990.9 | 3990.9 | 3990.9 | 0.0 |
| 2024-07-18 | BR | Futures | 0.17465 | 0.17465 | 0.17195 | 0.17224 | 198.0 |
| 2024-07-18 | BTC | Futures | 73557.3 | 74526.1 | 72189.7 | 72543.0 | 7890.0 |
| 2024-07-18 | BZ | Futures | 80.37 | 80.96 | 79.45 | 80.29 | 45867.0 |
| 2024-07-18 | C | Futures | 6251.0 | 6619.0 | 6229.0 | 6548.0 | 2819.0 |
| 2024-07-18 | CB | Futures | 306.874 | 307.53 | 301.047 | 302.99 | 12.0 |
| 2024-07-18 | CC | Futures | 5468.0 | 5724.0 | 5387.0 | 5652.0 | 9181.0 |
| 2024-07-18 | CNH | Futures | 7.1478 | 7.1591 | 7.1414 | 7.1587 | 956.0 |
| 2024-07-18 | CSC | Futures | 1.956 | 1.981 | 1.948 | 1.981 | 185.0 |
| 2024-07-18 | CT | Futures | 79.77 | 80.43 | 79.77 | 80.17 | 19.0 |
| 2024-07-18 | DC | Futures | 18.92 | 19.22 | 18.83 | 19.21 | 640.0 |
| 2024-07-18 | DX | Futures | 102.851 | 103.403 | 102.846 | 103.353 | 14858.0 |
| 2024-07-18 | E1 | Futures | 1.16155 | 1.16298 | 1.15523 | 1.15615 | 34132.0 |
| 2024-07-18 | E6 | Futures | 1.10526 | 1.10541 | 1.10063 | 1.10118 | 198000.0 |
| 2024-07-18 | E7 | Futures | 1.1049 | 1.1054 | 1.1003 | 1.1008 | 3096.0 |
| 2024-07-18 | EBM | Futures | 251.45 | 253.2 | 249.99 | 251.16 | 29087.0 |
| 2024-07-18 | ER | Futures | 97.553 | 97.558 | 97.538 | 97.553 | 296753.0 |
| 2024-07-18 | ESG | Futures | 505.87 | 505.95 | 498.04 | 499.64 | 1084.0 |
| 2024-07-18 | EW | Futures | 3159.0 | 3185.0 | 3106.0 | 3114.5 | 11280.0 |
| 2024-07-18 | FBON | Futures | 123.83 | 123.97 | 123.57 | 123.94 | 83.0 |
| 2024-07-18 | FBTP | Futures | 118.04 | 118.26 | 117.77 | 118.12 | 198782.0 |
| 2024-07-18 | FBTS | Futures | 106.495 | 106.575 | 106.454 | 106.555 | 117387.0 |
| 2024-07-18 | FCE | Futures | 7797.0 | 7863.0 | 7764.2 | 7793.9 | 62920.0 |
| 2024-07-18 | FDAX | Futures | 19033.2 | 19093.6 | 18839.9 | 18912.6 | 41684.0 |
| 2024-07-18 | FDIV | Futures | 189.45 | 189.65 | 189.45 | 189.5 | 16.0 |
| 2024-07-18 | FDXM | Futures | 18951.8 | 19003.7 | 18753.3 | 18824.5 | 27299.0 |
| 2024-07-18 | FDXS | Futures | 18884.0 | 18954.0 | 18703.2 | 18775.3 | 29391.0 |
| 2024-07-18 | FESX | Futures | 4967.9 | 4995.1 | 4923.5 | 4946.7 | 766203.0 |
| 2024-07-18 | FEU3 | Futures | 97.558 | 97.563 | 97.548 | 97.558 | 605.0 |
| 2024-07-18 | FGBL | Futures | 133.88 | 134.11 | 133.52 | 134.01 | 831279.0 |
| 2024-07-18 | FGBM | Futures | 117.47 | 117.66 | 117.33 | 117.63 | 671322.0 |
| 2024-07-18 | FGBS | Futures | 106.54 | 106.616 | 106.48 | 106.595 | 538255.0 |
| 2024-07-18 | FGBX | Futures | 133.23 | 133.45 | 132.1 | 133.05 | 91490.0 |
| 2024-07-18 | FMWO | Futures | 12052.1 | 12054.2 | 11891.8 | 11940.0 | 10560.0 |
| 2024-07-18 | FOAT | Futures | 124.8 | 125.02 | 124.53 | 124.9 | 285353.0 |
| 2024-07-18 | FSMX | Futures | 25962.7 | 26148.2 | 25913.3 | 25989.9 | 501.0 |
| 2024-07-18 | FTDX | Futures | 3448.4 | 3467.8 | 3441.7 | 3441.7 | 6.0 |
| 2024-07-18 | FTI | Futures | 928.93 | 939.9 | 925.21 | 929.25 | 11722.0 |
| 2024-07-18 | FTUK | Futures | 8253.7 | 8305.4 | 8194.6 | 8244.7 | 79817.0 |
> showing 50 of 130 rows — these rows as CSV