PREVIEW / futures_daily / 2024-06-28
file: by_date/futures_daily/2024/2024-06-28.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-06-28 | ES | Futures | 5730.8 | 5768.76 | 5692.06 | 5703.17 | 1855777.0 |
| 2024-06-28 | NQ | Futures | 20792.86 | 21010.49 | 20630.15 | 20651.91 | 750324.0 |
| 2024-06-28 | YM | Futures | 40282.2 | 40605.5 | 40059.9 | 40248.6 | 163770.0 |
| 2024-06-28 | CL | Futures | 74.78 | 75.56 | 73.96 | 74.49 | 260252.0 |
| 2024-06-28 | GC | Futures | 2445.0 | 2457.6 | 2435.7 | 2446.1 | 135383.0 |
| 2024-06-28 | ZN | Futures | 110.810354 | 111.077367 | 110.182088 | 110.559048 | 3146809.0 |
| 2024-06-28 | A6 | Futures | 0.66704 | 0.67079 | 0.66429 | 0.66924 | 147708.0 |
| 2024-06-28 | AD | Futures | 0.73494 | 0.7373 | 0.73298 | 0.7356 | 137793.0 |
| 2024-06-28 | ALI | Futures | 2556.31 | 2612.77 | 2526.91 | 2595.08 | 658.0 |
| 2024-06-28 | B | Futures | 82.19 | 82.97 | 81.37 | 81.83 | 397031.0 |
| 2024-06-28 | B6 | Futures | 1.2645 | 1.2703 | 1.2623 | 1.2645 | 104262.0 |
| 2024-06-28 | BFX | Futures | 3925.0 | 3925.0 | 3925.0 | 3925.0 | 0.0 |
| 2024-06-28 | BR | Futures | 0.17253 | 0.17465 | 0.17118 | 0.17161 | 14.0 |
| 2024-06-28 | BTC | Futures | 70577.0 | 71386.2 | 68599.6 | 68753.4 | 8336.0 |
| 2024-06-28 | BZ | Futures | 80.5 | 81.29 | 79.73 | 80.18 | 38920.0 |
| 2024-06-28 | C | Futures | 6310.0 | 6757.0 | 6103.0 | 6735.0 | 6886.0 |
| 2024-06-28 | CB | Futures | 306.389 | 307.603 | 305.903 | 305.903 | 32.0 |
| 2024-06-28 | CC | Futures | 4989.0 | 5447.0 | 4943.0 | 5416.0 | 9788.0 |
| 2024-06-28 | CNH | Futures | 7.1725 | 7.1735 | 7.1587 | 7.1661 | 679.0 |
| 2024-06-28 | CSC | Futures | 1.978 | 1.978 | 1.939 | 1.945 | 54.0 |
| 2024-06-28 | CT | Futures | 83.38 | 83.86 | 79.99 | 80.86 | 46.0 |
| 2024-06-28 | DC | Futures | 18.72 | 19.05 | 18.66 | 18.69 | 76.0 |
| 2024-06-28 | DX | Futures | 105.025 | 105.258 | 104.875 | 105.005 | 11986.0 |
| 2024-06-28 | E1 | Futures | 1.14403 | 1.14505 | 1.14123 | 1.14428 | 33580.0 |
| 2024-06-28 | E6 | Futures | 1.08254 | 1.08466 | 1.08058 | 1.08335 | 226615.0 |
| 2024-06-28 | E7 | Futures | 1.0822 | 1.0842 | 1.0803 | 1.083 | 2665.0 |
| 2024-06-28 | EBM | Futures | 266.34 | 269.26 | 261.67 | 262.55 | 36058.0 |
| 2024-06-28 | ER | Futures | 97.533 | 97.543 | 97.528 | 97.533 | 147215.0 |
| 2024-06-28 | ESG | Futures | 494.64 | 496.0 | 490.16 | 490.6 | 407.0 |
| 2024-06-28 | EW | Futures | 3006.2 | 3035.3 | 2992.3 | 3009.5 | 14086.0 |
| 2024-06-28 | FBON | Futures | 121.82 | 122.3 | 121.58 | 121.66 | 131.0 |
| 2024-06-28 | FBTP | Futures | 115.15 | 115.48 | 114.74 | 114.91 | 305465.0 |
| 2024-06-28 | FBTS | Futures | 105.85 | 105.93 | 105.789 | 105.85 | 140680.0 |
| 2024-06-28 | FCE | Futures | 7779.6 | 7810.5 | 7690.6 | 7715.8 | 69360.0 |
| 2024-06-28 | FDAX | Futures | 18839.9 | 18946.3 | 18777.6 | 18821.5 | 44241.0 |
| 2024-06-28 | FDIV | Futures | 186.31 | 186.31 | 185.86 | 185.86 | 9.0 |
| 2024-06-28 | FDXM | Futures | 18748.2 | 18859.1 | 18690.2 | 18733.9 | 28562.0 |
| 2024-06-28 | FDXS | Futures | 18691.1 | 18808.8 | 18641.3 | 18685.0 | 33312.0 |
| 2024-06-28 | FESX | Futures | 4994.1 | 5008.2 | 4955.8 | 4966.9 | 846626.0 |
| 2024-06-28 | FEU3 | Futures | 97.538 | 97.543 | 97.533 | 97.538 | 5602.0 |
| 2024-06-28 | FGBL | Futures | 133.41 | 133.61 | 132.82 | 132.99 | 1187945.0 |
| 2024-06-28 | FGBM | Futures | 117.36 | 117.46 | 117.12 | 117.21 | 692970.0 |
| 2024-06-28 | FGBS | Futures | 106.505 | 106.56 | 106.444 | 106.48 | 536047.0 |
| 2024-06-28 | FGBX | Futures | 132.32 | 132.75 | 130.63 | 131.02 | 122874.0 |
| 2024-06-28 | FMWO | Futures | 11795.4 | 11838.4 | 11712.7 | 11791.2 | 4850.0 |
| 2024-06-28 | FOAT | Futures | 123.03 | 123.14 | 122.45 | 122.71 | 382350.0 |
| 2024-06-28 | FSMX | Futures | 25824.5 | 25824.5 | 25530.1 | 25636.0 | 145.0 |
| 2024-06-28 | FTDX | Futures | 3428.5 | 3445.3 | 3424.9 | 3424.9 | 4.0 |
| 2024-06-28 | FTI | Futures | 941.65 | 946.21 | 935.77 | 939.14 | 12322.0 |
| 2024-06-28 | FTUK | Futures | 8257.7 | 8298.3 | 8205.1 | 8234.2 | 111027.0 |
> showing 50 of 130 rows — these rows as CSV