PREVIEW / futures_daily / 2024-07-24
file: by_date/futures_daily/2024/2024-07-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-07-24 | ES | Futures | 5768.76 | 5768.76 | 5641.71 | 5652.04 | 2178690.0 |
| 2024-07-24 | NQ | Futures | 20606.05 | 20606.05 | 19865.83 | 19901.58 | 846812.0 |
| 2024-07-24 | YM | Futures | 41376.4 | 41384.6 | 40844.1 | 40902.2 | 152717.0 |
| 2024-07-24 | CL | Futures | 71.84 | 72.53 | 71.41 | 71.97 | 355971.0 |
| 2024-07-24 | GC | Futures | 2520.4 | 2543.7 | 2506.1 | 2525.6 | 245884.0 |
| 2024-07-24 | ZN | Futures | 111.328673 | 111.721339 | 111.187313 | 111.25014 | 2637572.0 |
| 2024-07-24 | A6 | Futures | 0.66328 | 0.66338 | 0.65953 | 0.65973 | 124314.0 |
| 2024-07-24 | AD | Futures | 0.73012 | 0.73042 | 0.72846 | 0.72861 | 105082.0 |
| 2024-07-24 | ALI | Futures | 2338.03 | 2360.21 | 2322.81 | 2339.83 | 11557.0 |
| 2024-07-24 | B | Futures | 78.42 | 79.17 | 77.91 | 78.66 | 298195.0 |
| 2024-07-24 | B6 | Futures | 1.291 | 1.2939 | 1.2879 | 1.2905 | 86526.0 |
| 2024-07-24 | BFX | Futures | 4031.7 | 4031.7 | 4031.7 | 4031.7 | 0.0 |
| 2024-07-24 | BR | Futures | 0.17171 | 0.1721 | 0.16964 | 0.16978 | 28358.0 |
| 2024-07-24 | BTC | Futures | 74725.6 | 76250.8 | 74305.0 | 74518.1 | 8317.0 |
| 2024-07-24 | BZ | Futures | 76.87 | 77.56 | 76.35 | 77.08 | 47261.0 |
| 2024-07-24 | C | Futures | 6745.0 | 6792.0 | 6574.0 | 6601.0 | 5444.0 |
| 2024-07-24 | CB | Futures | 302.261 | 305.903 | 302.261 | 303.961 | 63.0 |
| 2024-07-24 | CC | Futures | 5762.0 | 5944.0 | 5690.0 | 5763.0 | 10226.0 |
| 2024-07-24 | CNH | Futures | 7.1744 | 7.1764 | 7.1483 | 7.1547 | 710.0 |
| 2024-07-24 | CSC | Futures | 2.018 | 2.018 | 2.0 | 2.007 | 227.0 |
| 2024-07-24 | CT | Futures | 76.4 | 76.4 | 74.03 | 75.27 | 84.0 |
| 2024-07-24 | DC | Futures | 19.47 | 19.74 | 19.46 | 19.72 | 780.0 |
| 2024-07-24 | DX | Futures | 103.686 | 103.751 | 103.313 | 103.589 | 14872.0 |
| 2024-07-24 | E1 | Futures | 1.15035 | 1.16124 | 1.14922 | 1.15753 | 45484.0 |
| 2024-07-24 | E6 | Futures | 1.0964 | 1.09766 | 1.09342 | 1.09473 | 201964.0 |
| 2024-07-24 | E7 | Futures | 1.096 | 1.0972 | 1.0931 | 1.0944 | 3819.0 |
| 2024-07-24 | EBM | Futures | 260.21 | 262.55 | 258.46 | 259.92 | 39517.0 |
| 2024-07-24 | ER | Futures | 97.543 | 97.558 | 97.543 | 97.558 | 171381.0 |
| 2024-07-24 | ESG | Futures | 493.26 | 493.72 | 486.82 | 487.66 | 916.0 |
| 2024-07-24 | EW | Futures | 3132.9 | 3139.2 | 3070.5 | 3072.8 | 11137.0 |
| 2024-07-24 | FBON | Futures | 123.27 | 123.5 | 123.12 | 123.2 | 132.0 |
| 2024-07-24 | FBTP | Futures | 117.64 | 117.69 | 117.22 | 117.31 | 248586.0 |
| 2024-07-24 | FBTS | Futures | 106.485 | 106.525 | 106.454 | 106.505 | 147950.0 |
| 2024-07-24 | FCE | Futures | 7749.9 | 7755.0 | 7662.3 | 7715.6 | 59095.0 |
| 2024-07-24 | FDAX | Futures | 19056.8 | 19068.0 | 18860.4 | 18914.6 | 45756.0 |
| 2024-07-24 | FDIV | Futures | 186.56 | 186.56 | 185.56 | 186.11 | 15.0 |
| 2024-07-24 | FDXM | Futures | 18972.1 | 18978.3 | 18771.6 | 18826.6 | 26893.0 |
| 2024-07-24 | FDXS | Futures | 18930.7 | 18930.7 | 18723.5 | 18777.4 | 27875.0 |
| 2024-07-24 | FESX | Futures | 4965.9 | 4967.9 | 4899.3 | 4927.6 | 665715.0 |
| 2024-07-24 | FEU3 | Futures | 97.553 | 97.563 | 97.553 | 97.563 | 683.0 |
| 2024-07-24 | FGBL | Futures | 133.5 | 134.04 | 133.28 | 133.72 | 963911.0 |
| 2024-07-24 | FGBM | Futures | 117.39 | 117.71 | 117.38 | 117.59 | 709353.0 |
| 2024-07-24 | FGBS | Futures | 106.53 | 106.661 | 106.525 | 106.631 | 569118.0 |
| 2024-07-24 | FGBX | Futures | 131.98 | 132.81 | 130.55 | 131.66 | 106922.0 |
| 2024-07-24 | FMWO | Futures | 11853.1 | 11854.1 | 11660.3 | 11753.5 | 6058.0 |
| 2024-07-24 | FOAT | Futures | 124.1 | 124.43 | 123.72 | 124.11 | 218679.0 |
| 2024-07-24 | FSMX | Futures | 25531.1 | 25646.1 | 25370.8 | 25421.2 | 313.0 |
| 2024-07-24 | FTDX | Futures | 3407.1 | 3410.6 | 3404.5 | 3404.5 | 7.0 |
| 2024-07-24 | FTI | Futures | 925.06 | 925.27 | 907.17 | 915.92 | 10760.0 |
| 2024-07-24 | FTUK | Futures | 8179.5 | 8200.1 | 8136.9 | 8180.0 | 68081.0 |
> showing 50 of 130 rows — these rows as CSV