PREVIEW / futures_daily / 2024-10-28
file: by_date/futures_daily/2024/2024-10-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-10-28 | ES | Futures | 5991.96 | 6020.1 | 5991.96 | 5996.57 | 1017440.0 |
| 2024-10-28 | NQ | Futures | 21053.35 | 21208.24 | 21012.84 | 21024.12 | 430120.0 |
| 2024-10-28 | YM | Futures | 42805.2 | 43138.7 | 42805.2 | 43053.8 | 104638.0 |
| 2024-10-28 | CL | Futures | 66.76 | 66.78 | 64.77 | 65.21 | 419623.0 |
| 2024-10-28 | GC | Futures | 2807.0 | 2816.3 | 2794.5 | 2813.9 | 161907.0 |
| 2024-10-28 | ZN | Futures | 111.093276 | 111.202789 | 110.717803 | 110.842961 | 2056790.0 |
| 2024-10-28 | A6 | Futures | 0.66104 | 0.66139 | 0.65799 | 0.65819 | 85256.0 |
| 2024-10-28 | AD | Futures | 0.72243 | 0.72303 | 0.72168 | 0.72238 | 63407.0 |
| 2024-10-28 | ALI | Futures | 2708.71 | 2723.55 | 2675.71 | 2687.99 | 1753.0 |
| 2024-10-28 | B | Futures | 71.8 | 72.35 | 70.27 | 70.45 | 471145.0 |
| 2024-10-28 | B6 | Futures | 1.2956 | 1.2996 | 1.2933 | 1.2963 | 55440.0 |
| 2024-10-28 | BFX | Futures | 4315.2 | 4315.2 | 4315.2 | 4315.2 | 0.0 |
| 2024-10-28 | BR | Futures | 0.1703 | 0.17084 | 0.16991 | 0.17045 | 19096.0 |
| 2024-10-28 | BTC | Futures | 73716.9 | 76327.9 | 73592.6 | 76003.5 | 8448.0 |
| 2024-10-28 | BZ | Futures | 71.85 | 71.91 | 68.87 | 69.04 | 41657.0 |
| 2024-10-28 | C | Futures | 5135.0 | 5374.0 | 5099.0 | 5350.0 | 4624.0 |
| 2024-10-28 | CB | Futures | 283.518 | 283.518 | 277.137 | 280.12 | 41.0 |
| 2024-10-28 | CC | Futures | 5551.0 | 5712.0 | 5472.0 | 5664.0 | 8419.0 |
| 2024-10-28 | CNH | Futures | 7.0876 | 7.0926 | 7.0806 | 7.0906 | 800.0 |
| 2024-10-28 | CSC | Futures | 2.055 | 2.057 | 2.044 | 2.049 | 140.0 |
| 2024-10-28 | CT | Futures | 77.49 | 77.88 | 76.66 | 77.13 | 21182.0 |
| 2024-10-28 | DC | Futures | 20.18 | 20.33 | 20.01 | 20.06 | 600.0 |
| 2024-10-28 | DX | Futures | 103.995 | 104.16 | 103.706 | 103.898 | 17168.0 |
| 2024-10-28 | E1 | Futures | 1.17009 | 1.17378 | 1.16641 | 1.17297 | 22842.0 |
| 2024-10-28 | E6 | Futures | 1.08646 | 1.08952 | 1.085 | 1.08792 | 142651.0 |
| 2024-10-28 | E7 | Futures | 1.0851 | 1.0892 | 1.0847 | 1.0876 | 2083.0 |
| 2024-10-28 | EBM | Futures | 236.06 | 239.33 | 235.51 | 237.15 | 31909.0 |
| 2024-10-28 | ER | Futures | 97.855 | 97.886 | 97.845 | 97.865 | 231979.0 |
| 2024-10-28 | ESG | Futures | 520.06 | 520.18 | 518.32 | 518.44 | 249.0 |
| 2024-10-28 | EW | Futures | 3166.3 | 3196.8 | 3164.8 | 3188.8 | 8019.0 |
| 2024-10-28 | FBON | Futures | 124.94 | 125.78 | 124.85 | 125.48 | 191.0 |
| 2024-10-28 | FBTP | Futures | 119.89 | 120.86 | 119.87 | 120.61 | 249157.0 |
| 2024-10-28 | FBTS | Futures | 107.29 | 107.49 | 107.28 | 107.42 | 134060.0 |
| 2024-10-28 | FCE | Futures | 7524.2 | 7595.7 | 7505.2 | 7568.2 | 39410.0 |
| 2024-10-28 | FDAX | Futures | 19781.8 | 19876.7 | 19685.9 | 19821.2 | 41379.0 |
| 2024-10-28 | FDIV | Futures | 193.52 | 193.92 | 193.52 | 193.92 | 7.0 |
| 2024-10-28 | FDXM | Futures | 19726.9 | 19833.7 | 19643.3 | 19778.3 | 32518.0 |
| 2024-10-28 | FDXS | Futures | 19669.7 | 19790.3 | 19600.3 | 19734.0 | 29597.0 |
| 2024-10-28 | FESX | Futures | 4974.0 | 5006.0 | 4953.9 | 4995.0 | 525427.0 |
| 2024-10-28 | FEU3 | Futures | 97.85 | 97.881 | 97.85 | 97.87 | 10860.0 |
| 2024-10-28 | FGBL | Futures | 134.37 | 135.15 | 134.09 | 134.75 | 957110.0 |
| 2024-10-28 | FGBM | Futures | 118.16 | 118.6 | 118.01 | 118.41 | 625265.0 |
| 2024-10-28 | FGBS | Futures | 107.144 | 107.29 | 107.064 | 107.22 | 621417.0 |
| 2024-10-28 | FGBX | Futures | 131.76 | 133.46 | 131.08 | 132.54 | 90712.0 |
| 2024-10-28 | FMWO | Futures | 12286.7 | 12292.9 | 12249.4 | 12281.5 | 6799.0 |
| 2024-10-28 | FOAT | Futures | 124.52 | 125.51 | 124.32 | 125.22 | 156995.0 |
| 2024-10-28 | FSMX | Futures | 27605.2 | 27605.2 | 27411.1 | 27537.1 | 208.0 |
| 2024-10-28 | FTDX | Futures | 3476.5 | 3485.1 | 3476.5 | 3485.1 | 3.0 |
| 2024-10-28 | FTI | Futures | 906.42 | 907.68 | 897.9 | 903.58 | 7536.0 |
| 2024-10-28 | FTUK | Futures | 8294.8 | 8351.9 | 8249.2 | 8335.4 | 79587.0 |
> showing 50 of 130 rows — these rows as CSV