PREVIEW / futures_daily / 2023-08-02
file: by_date/futures_daily/2023/2023-08-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 |
|---|---|---|---|---|---|---|---|
| 2023-08-02 | ES | Futures | 4959.91 | 4974.53 | 4903.33 | 4913.62 | 1917865.0 |
| 2023-08-02 | NQ | Futures | 17240.87 | 17276.7 | 16865.57 | 16930.12 | 773499.0 |
| 2023-08-02 | YM | Futures | 37887.4 | 37970.3 | 37550.5 | 37624.9 | 167190.0 |
| 2023-08-02 | CL | Futures | 71.09 | 71.42 | 68.49 | 68.87 | 414825.0 |
| 2023-08-02 | GC | Futures | 2141.4 | 2145.0 | 2120.1 | 2126.5 | 169658.0 |
| 2023-08-02 | ZN | Futures | 112.976861 | 113.21541 | 112.43615 | 112.770118 | 1860148.0 |
| 2023-08-02 | A6 | Futures | 0.67177 | 0.67268 | 0.6623 | 0.66407 | 107398.0 |
| 2023-08-02 | AD | Futures | 0.76178 | 0.76229 | 0.75709 | 0.75759 | 71819.0 |
| 2023-08-02 | ALI | Futures | 2487.66 | 2492.13 | 2447.14 | 2451.89 | 3094.0 |
| 2023-08-02 | B | Futures | 75.98 | 76.1 | 73.22 | 73.63 | 399189.0 |
| 2023-08-02 | B6 | Futures | 1.2807 | 1.2831 | 1.2705 | 1.2744 | 100145.0 |
| 2023-08-02 | BFX | Futures | 4104.7 | 4104.7 | 4104.7 | 4104.7 | 0.0 |
| 2023-08-02 | BR | Futures | 0.19362 | 0.19469 | 0.19236 | 0.19287 | 8522.0 |
| 2023-08-02 | BTC | Futures | 38924.4 | 40063.6 | 38387.9 | 38785.3 | 10812.0 |
| 2023-08-02 | BZ | Futures | 75.63 | 75.86 | 73.01 | 73.4 | 32246.0 |
| 2023-08-02 | C | Futures | 2269.0 | 2274.0 | 2234.0 | 2261.0 | 9680.0 |
| 2023-08-02 | CB | Futures | 251.451 | 251.451 | 247.165 | 248.594 | 79.0 |
| 2023-08-02 | CC | Futures | 2051.0 | 2077.0 | 2047.0 | 2065.0 | 28982.0 |
| 2023-08-02 | CNH | Futures | 6.8856 | 6.9156 | 6.8803 | 6.9104 | 171.0 |
| 2023-08-02 | CSC | Futures | 1.965 | 2.002 | 1.965 | 1.982 | 107.0 |
| 2023-08-02 | CT | Futures | 106.98 | 107.03 | 105.69 | 106.04 | 8.0 |
| 2023-08-02 | DC | Futures | 18.1 | 18.49 | 18.07 | 18.25 | 453.0 |
| 2023-08-02 | DX | Futures | 99.886 | 100.636 | 99.856 | 100.449 | 12795.0 |
| 2023-08-02 | E1 | Futures | 1.22176 | 1.22235 | 1.21068 | 1.21508 | 23228.0 |
| 2023-08-02 | E6 | Futures | 1.12974 | 1.1301 | 1.11981 | 1.12237 | 197586.0 |
| 2023-08-02 | E7 | Futures | 1.129 | 1.1303 | 1.1198 | 1.1225 | 6144.0 |
| 2023-08-02 | EBM | Futures | 351.47 | 352.93 | 340.12 | 342.32 | 33619.0 |
| 2023-08-02 | ER | Futures | 97.883 | 97.899 | 97.878 | 97.899 | 81470.0 |
| 2023-08-02 | ESG | Futures | 429.9 | 430.58 | 425.62 | 426.19 | 307.0 |
| 2023-08-02 | EW | Futures | 2871.8 | 2882.8 | 2847.3 | 2858.2 | 10947.0 |
| 2023-08-02 | FBON | Futures | 121.54 | 121.75 | 121.18 | 121.27 | 41.0 |
| 2023-08-02 | FBTP | Futures | 113.48 | 113.88 | 113.25 | 113.35 | 146808.0 |
| 2023-08-02 | FBTS | Futures | 106.249 | 106.36 | 106.239 | 106.31 | 109663.0 |
| 2023-08-02 | FCE | Futures | 7974.4 | 7997.1 | 7897.0 | 7926.8 | 63404.0 |
| 2023-08-02 | FDAX | Futures | 17226.7 | 17259.5 | 16967.3 | 17027.6 | 74223.0 |
| 2023-08-02 | FDIV | Futures | 186.07 | 186.07 | 185.05 | 185.31 | 62.0 |
| 2023-08-02 | FDXM | Futures | 17313.1 | 17330.1 | 17037.8 | 17097.4 | 53038.0 |
| 2023-08-02 | FDXS | Futures | 17196.9 | 17219.1 | 16926.6 | 16987.8 | 32121.0 |
| 2023-08-02 | FESX | Futures | 4475.5 | 4481.6 | 4396.5 | 4406.6 | 1118347.0 |
| 2023-08-02 | FEU3 | Futures | 97.888 | 97.888 | 97.888 | 97.888 | 0.0 |
| 2023-08-02 | FGBL | Futures | 134.0 | 134.54 | 133.87 | 134.11 | 678714.0 |
| 2023-08-02 | FGBM | Futures | 118.34 | 118.62 | 118.26 | 118.46 | 515026.0 |
| 2023-08-02 | FGBS | Futures | 107.432 | 107.545 | 107.417 | 107.519 | 430169.0 |
| 2023-08-02 | FGBX | Futures | 136.15 | 137.11 | 135.78 | 136.07 | 82031.0 |
| 2023-08-02 | FMWO | Futures | 10601.5 | 10601.5 | 10457.3 | 10481.9 | 6357.0 |
| 2023-08-02 | FOAT | Futures | 125.16 | 125.63 | 124.99 | 125.19 | 141074.0 |
| 2023-08-02 | FSMX | Futures | 29867.8 | 29867.8 | 29226.1 | 29298.9 | 352.0 |
| 2023-08-02 | FTDX | Futures | 3431.9 | 3431.9 | 3418.7 | 3424.5 | 28.0 |
| 2023-08-02 | FTI | Futures | 820.31 | 820.31 | 810.21 | 812.38 | 18025.0 |
| 2023-08-02 | FTUK | Futures | 7765.3 | 7767.8 | 7624.0 | 7654.5 | 139100.0 |
> showing 50 of 130 rows — these rows as CSV