PREVIEW / futures_daily / 2024-07-02
file: by_date/futures_daily/2024/2024-07-02.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-02 | ES | Futures | 5715.56 | 5753.0 | 5683.8 | 5751.97 | 1315097.0 |
| 2024-07-02 | NQ | Futures | 20774.72 | 20995.98 | 20634.03 | 20991.84 | 621477.0 |
| 2024-07-02 | YM | Futures | 40278.1 | 40478.0 | 40115.0 | 40471.9 | 112627.0 |
| 2024-07-02 | CL | Futures | 76.21 | 77.08 | 75.56 | 75.65 | 367787.0 |
| 2024-07-02 | GC | Futures | 2448.2 | 2452.9 | 2433.3 | 2439.6 | 153709.0 |
| 2024-07-02 | ZN | Futures | 109.820836 | 110.182088 | 109.789422 | 110.040729 | 1719084.0 |
| 2024-07-02 | A6 | Futures | 0.66824 | 0.66979 | 0.66554 | 0.66909 | 87565.0 |
| 2024-07-02 | AD | Futures | 0.73283 | 0.7366 | 0.73188 | 0.7362 | 110994.0 |
| 2024-07-02 | ALI | Futures | 2560.21 | 2598.98 | 2560.21 | 2582.33 | 8518.0 |
| 2024-07-02 | B | Futures | 83.48 | 84.2 | 82.95 | 83.03 | 429154.0 |
| 2024-07-02 | B6 | Futures | 1.2654 | 1.27 | 1.2618 | 1.2687 | 92428.0 |
| 2024-07-02 | BFX | Futures | 3960.3 | 3960.3 | 3960.3 | 3960.3 | 0.0 |
| 2024-07-02 | BR | Futures | 0.16906 | 0.17026 | 0.16824 | 0.16896 | 242.0 |
| 2024-07-02 | BTC | Futures | 72411.9 | 72520.2 | 70702.4 | 70873.3 | 6486.0 |
| 2024-07-02 | BZ | Futures | 81.78 | 82.5 | 81.29 | 81.35 | 52311.0 |
| 2024-07-02 | C | Futures | 6564.0 | 6911.0 | 6519.0 | 6896.0 | 6083.0 |
| 2024-07-02 | CB | Futures | 307.894 | 308.816 | 307.894 | 308.816 | 33.0 |
| 2024-07-02 | CC | Futures | 5108.0 | 5478.0 | 4986.0 | 5456.0 | 8210.0 |
| 2024-07-02 | CNH | Futures | 7.1744 | 7.1823 | 7.1744 | 7.1789 | 883.0 |
| 2024-07-02 | CSC | Futures | 1.94 | 1.945 | 1.924 | 1.924 | 38.0 |
| 2024-07-02 | CT | Futures | 81.78 | 82.09 | 80.13 | 80.32 | 42.0 |
| 2024-07-02 | DC | Futures | 18.8 | 18.8 | 18.54 | 18.55 | 151.0 |
| 2024-07-02 | DX | Futures | 104.995 | 105.199 | 104.821 | 104.867 | 11594.0 |
| 2024-07-02 | E1 | Futures | 1.13848 | 1.13853 | 1.13522 | 1.13664 | 25812.0 |
| 2024-07-02 | E6 | Futures | 1.08607 | 1.08667 | 1.08295 | 1.08617 | 174706.0 |
| 2024-07-02 | E7 | Futures | 1.0856 | 1.0863 | 1.0826 | 1.0858 | 2944.0 |
| 2024-07-02 | EBM | Futures | 269.85 | 270.43 | 264.59 | 265.18 | 32360.0 |
| 2024-07-02 | ER | Futures | 97.518 | 97.533 | 97.513 | 97.528 | 147175.0 |
| 2024-07-02 | ESG | Futures | 489.74 | 495.22 | 489.74 | 495.1 | 368.0 |
| 2024-07-02 | EW | Futures | 2982.6 | 2992.4 | 2964.8 | 2991.0 | 11890.0 |
| 2024-07-02 | FBON | Futures | 121.21 | 121.7 | 121.07 | 121.42 | 243.0 |
| 2024-07-02 | FBTP | Futures | 114.72 | 115.19 | 114.34 | 114.95 | 306114.0 |
| 2024-07-02 | FBTS | Futures | 105.84 | 105.96 | 105.779 | 105.92 | 137977.0 |
| 2024-07-02 | FCE | Futures | 7808.0 | 7808.0 | 7713.7 | 7777.1 | 54216.0 |
| 2024-07-02 | FDAX | Futures | 18906.4 | 18909.5 | 18604.7 | 18731.5 | 46292.0 |
| 2024-07-02 | FDIV | Futures | 184.56 | 185.16 | 184.16 | 184.96 | 7.0 |
| 2024-07-02 | FDXM | Futures | 18819.4 | 18819.4 | 18517.1 | 18644.4 | 33726.0 |
| 2024-07-02 | FDXS | Futures | 18777.4 | 18777.4 | 18468.7 | 18595.6 | 29822.0 |
| 2024-07-02 | FESX | Futures | 5018.3 | 5018.3 | 4943.7 | 4981.0 | 759617.0 |
| 2024-07-02 | FEU3 | Futures | 97.518 | 97.533 | 97.518 | 97.533 | 754.0 |
| 2024-07-02 | FGBL | Futures | 131.83 | 132.12 | 131.63 | 131.74 | 936226.0 |
| 2024-07-02 | FGBM | Futures | 116.66 | 116.81 | 116.59 | 116.64 | 671770.0 |
| 2024-07-02 | FGBS | Futures | 106.308 | 106.364 | 106.283 | 106.303 | 565527.0 |
| 2024-07-02 | FGBX | Futures | 128.38 | 128.84 | 127.6 | 127.9 | 101418.0 |
| 2024-07-02 | FMWO | Futures | 11721.0 | 11822.7 | 11687.5 | 11763.0 | 4412.0 |
| 2024-07-02 | FOAT | Futures | 122.27 | 122.75 | 121.93 | 122.39 | 258241.0 |
| 2024-07-02 | FSMX | Futures | 25604.7 | 25604.7 | 25412.1 | 25558.3 | 189.0 |
| 2024-07-02 | FTDX | Futures | 3404.0 | 3404.0 | 3366.3 | 3397.4 | 30.0 |
| 2024-07-02 | FTI | Futures | 938.56 | 942.21 | 930.5 | 939.55 | 11721.0 |
| 2024-07-02 | FTUK | Futures | 8215.1 | 8226.1 | 8157.5 | 8173.0 | 99688.0 |
> showing 50 of 130 rows — these rows as CSV