PREVIEW / futures_daily / 2023-08-28
file: by_date/futures_daily/2023/2023-08-28.parquet size: 10 KB rows: 128
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-28 | ES | Futures | 4784.48 | 4818.59 | 4780.69 | 4810.74 | 1266414.0 |
| 2023-08-28 | NQ | Futures | 16402.73 | 16550.99 | 16383.58 | 16513.79 | 586342.0 |
| 2023-08-28 | YM | Futures | 36583.4 | 36869.2 | 36558.9 | 36765.1 | 142335.0 |
| 2023-08-28 | CL | Futures | 70.05 | 70.68 | 69.58 | 70.01 | 246584.0 |
| 2023-08-28 | GC | Futures | 2093.1 | 2104.1 | 2088.9 | 2096.1 | 115553.0 |
| 2023-08-28 | ZN | Futures | 111.402437 | 111.688696 | 111.259307 | 111.593276 | 3135447.0 |
| 2023-08-28 | A6 | Futures | 0.64938 | 0.65288 | 0.64903 | 0.65121 | 69865.0 |
| 2023-08-28 | AD | Futures | 0.74304 | 0.74481 | 0.74253 | 0.74294 | 49400.0 |
| 2023-08-28 | ALI | Futures | 2390.97 | 2409.44 | 2390.97 | 2404.47 | 337.0 |
| 2023-08-28 | B | Futures | 75.08 | 75.48 | 74.48 | 74.75 | 216235.0 |
| 2023-08-28 | B6 | Futures | 1.2605 | 1.2635 | 1.259 | 1.2626 | 45706.0 |
| 2023-08-28 | BFX | Futures | 4011.5 | 4011.5 | 4011.5 | 4011.5 | 0.0 |
| 2023-08-28 | BR | Futures | 0.19077 | 0.19077 | 0.19058 | 0.19058 | 912.0 |
| 2023-08-28 | BTC | Futures | 34941.7 | 35141.6 | 34568.4 | 34781.7 | 3315.0 |
| 2023-08-28 | BZ | Futures | 74.91 | 75.3 | 74.29 | 74.58 | 15094.0 |
| 2023-08-28 | CB | Futures | 254.575 | 254.575 | 254.575 | 254.575 | 5.0 |
| 2023-08-28 | CC | Futures | 2016.0 | 2037.0 | 2016.0 | 2027.0 | 14481.0 |
| 2023-08-28 | CNH | Futures | 7.0104 | 7.0303 | 6.9933 | 7.0186 | 487.0 |
| 2023-08-28 | CSC | Futures | 2.121 | 2.121 | 2.105 | 2.105 | 73.0 |
| 2023-08-28 | CT | Futures | 108.51 | 108.56 | 108.51 | 108.52 | 2.0 |
| 2023-08-28 | DC | Futures | 19.9 | 19.99 | 19.6 | 19.6 | 149.0 |
| 2023-08-28 | DX | Futures | 102.181 | 102.181 | 101.956 | 102.021 | 9950.0 |
| 2023-08-28 | E1 | Futures | 1.20188 | 1.20553 | 1.20076 | 1.20288 | 11548.0 |
| 2023-08-28 | E6 | Futures | 1.1061 | 1.10855 | 1.10564 | 1.10748 | 112616.0 |
| 2023-08-28 | E7 | Futures | 1.1063 | 1.1085 | 1.1057 | 1.1075 | 2319.0 |
| 2023-08-28 | EBM | Futures | 339.02 | 339.02 | 334.26 | 334.99 | 6752.0 |
| 2023-08-28 | ER | Futures | 97.863 | 97.863 | 97.843 | 97.848 | 66897.0 |
| 2023-08-28 | ESG | Futures | 416.04 | 418.3 | 415.32 | 417.73 | 236.0 |
| 2023-08-28 | EW | Futures | 2731.4 | 2770.2 | 2729.7 | 2755.2 | 10246.0 |
| 2023-08-28 | FBON | Futures | 121.17 | 121.41 | 121.08 | 121.12 | 23.0 |
| 2023-08-28 | FBTP | Futures | 112.83 | 113.18 | 112.54 | 112.85 | 74046.0 |
| 2023-08-28 | FBTS | Futures | 106.078 | 106.108 | 105.997 | 106.037 | 79462.0 |
| 2023-08-28 | FCE | Futures | 7899.7 | 7963.0 | 7870.0 | 7939.8 | 40352.0 |
| 2023-08-28 | FDAX | Futures | 16648.7 | 16786.3 | 16623.3 | 16757.7 | 43591.0 |
| 2023-08-28 | FDIV | Futures | 181.73 | 182.75 | 181.73 | 182.75 | 3.0 |
| 2023-08-28 | FDXM | Futures | 16719.0 | 16855.0 | 16691.3 | 16826.3 | 37478.0 |
| 2023-08-28 | FDXS | Futures | 16588.6 | 16748.1 | 16584.4 | 16718.5 | 16783.0 |
| 2023-08-28 | FESX | Futures | 4321.6 | 4370.2 | 4319.5 | 4362.1 | 520441.0 |
| 2023-08-28 | FEU3 | Futures | 97.838 | 97.838 | 97.838 | 97.838 | 0.0 |
| 2023-08-28 | FGBL | Futures | 133.67 | 133.99 | 133.35 | 133.56 | 330284.0 |
| 2023-08-28 | FGBM | Futures | 118.21 | 118.29 | 118.01 | 118.12 | 275353.0 |
| 2023-08-28 | FGBS | Futures | 107.412 | 107.422 | 107.34 | 107.366 | 226893.0 |
| 2023-08-28 | FGBX | Futures | 135.06 | 136.0 | 134.32 | 134.61 | 45144.0 |
| 2023-08-28 | FMWO | Futures | 10194.5 | 10252.6 | 10171.0 | 10210.1 | 2703.0 |
| 2023-08-28 | FOAT | Futures | 124.97 | 125.24 | 124.62 | 124.87 | 75710.0 |
| 2023-08-28 | FSMX | Futures | 28429.3 | 28496.9 | 28285.7 | 28496.9 | 70.0 |
| 2023-08-28 | FTDX | Futures | 3275.5 | 3304.4 | 3268.6 | 3304.4 | 26.0 |
| 2023-08-28 | FTI | Futures | 771.65 | 776.29 | 770.08 | 774.64 | 11349.0 |
| 2023-08-28 | FTUK | Futures | 7473.6 | 7473.6 | 7473.6 | 7473.6 | 0.0 |
| 2023-08-28 | FVSA | Futures | 26.53 | 26.6 | 25.14 | 25.5 | 13983.0 |
> showing 50 of 128 rows — these rows as CSV