PREVIEW / futures_daily / 2023-10-17
file: by_date/futures_daily/2023/2023-10-17.parquet size: 10 KB rows: 129
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-10-17 | ES | Futures | 4716.34 | 4734.54 | 4672.99 | 4711.53 | 1879736.0 |
| 2023-10-17 | NQ | Futures | 16518.27 | 16522.05 | 16242.53 | 16448.12 | 781599.0 |
| 2023-10-17 | YM | Futures | 35962.3 | 36101.2 | 35744.4 | 35931.8 | 199591.0 |
| 2023-10-17 | CL | Futures | 76.71 | 77.38 | 75.54 | 76.48 | 229524.0 |
| 2023-10-17 | GC | Futures | 2081.6 | 2093.6 | 2072.2 | 2084.1 | 165063.0 |
| 2023-10-17 | ZN | Futures | 108.678171 | 108.74154 | 107.585052 | 107.695949 | 2149715.0 |
| 2023-10-17 | A6 | Futures | 0.64075 | 0.64453 | 0.64004 | 0.64236 | 104920.0 |
| 2023-10-17 | AD | Futures | 0.74142 | 0.74147 | 0.73628 | 0.7393 | 100068.0 |
| 2023-10-17 | ALI | Futures | 2387.6 | 2395.55 | 2369.8 | 2389.25 | 2011.0 |
| 2023-10-17 | B | Futures | 80.9 | 81.88 | 79.97 | 80.89 | 252831.0 |
| 2023-10-17 | B6 | Futures | 1.2224 | 1.2226 | 1.2142 | 1.2184 | 98474.0 |
| 2023-10-17 | BR | Futures | 0.18521 | 0.18672 | 0.18512 | 0.18578 | 82.0 |
| 2023-10-17 | BTC | Futures | 38159.2 | 38466.4 | 37718.6 | 38219.3 | 6603.0 |
| 2023-10-17 | BZ | Futures | 80.86 | 81.63 | 79.79 | 80.72 | 27054.0 |
| 2023-10-17 | C | Futures | 2631.0 | 2665.0 | 2620.0 | 2648.0 | 6025.0 |
| 2023-10-17 | CB | Futures | 265.472 | 269.434 | 265.472 | 266.462 | 50.0 |
| 2023-10-17 | CC | Futures | 2091.0 | 2125.0 | 2083.0 | 2121.0 | 20606.0 |
| 2023-10-17 | CNH | Futures | 7.0682 | 7.0832 | 7.0677 | 7.0813 | 947.0 |
| 2023-10-17 | CSC | Futures | 1.978 | 2.003 | 1.967 | 1.994 | 164.0 |
| 2023-10-17 | CT | Futures | 103.82 | 103.82 | 101.16 | 101.48 | 32468.0 |
| 2023-10-17 | DC | Futures | 18.82 | 19.32 | 18.72 | 19.19 | 364.0 |
| 2023-10-17 | DX | Futures | 104.604 | 104.875 | 104.377 | 104.61 | 16445.0 |
| 2023-10-17 | E1 | Futures | 1.17334 | 1.17487 | 1.1693 | 1.17282 | 21968.0 |
| 2023-10-17 | E6 | Futures | 1.07729 | 1.08075 | 1.07439 | 1.07806 | 224402.0 |
| 2023-10-17 | E7 | Futures | 1.0774 | 1.0809 | 1.0747 | 1.0782 | 4582.0 |
| 2023-10-17 | EBM | Futures | 324.19 | 324.88 | 320.42 | 323.85 | 23823.0 |
| 2023-10-17 | ER | Futures | 97.771 | 97.771 | 97.741 | 97.746 | 144585.0 |
| 2023-10-17 | ESG | Futures | 408.25 | 409.55 | 404.39 | 408.06 | 516.0 |
| 2023-10-17 | EW | Futures | 2615.7 | 2663.0 | 2598.4 | 2645.0 | 11734.0 |
| 2023-10-17 | FBON | Futures | 117.97 | 118.12 | 117.15 | 117.27 | 70.0 |
| 2023-10-17 | FBTP | Futures | 108.13 | 108.3 | 107.21 | 107.49 | 208973.0 |
| 2023-10-17 | FBTS | Futures | 105.289 | 105.309 | 105.137 | 105.167 | 114936.0 |
| 2023-10-17 | FCE | Futures | 7519.2 | 7552.8 | 7457.8 | 7524.5 | 34438.0 |
| 2023-10-17 | FDAX | Futures | 16181.1 | 16229.6 | 16030.5 | 16163.2 | 63386.0 |
| 2023-10-17 | FDIV | Futures | 173.26 | 173.26 | 173.26 | 173.26 | 0.0 |
| 2023-10-17 | FDXM | Futures | 16175.8 | 16223.2 | 16024.2 | 16156.8 | 37559.0 |
| 2023-10-17 | FDXS | Futures | 16076.4 | 16118.3 | 15919.5 | 16051.3 | 23898.0 |
| 2023-10-17 | FESX | Futures | 4202.6 | 4216.7 | 4157.3 | 4198.5 | 699849.0 |
| 2023-10-17 | FEU3 | Futures | 97.746 | 97.746 | 97.746 | 97.746 | 0.0 |
| 2023-10-17 | FGBL | Futures | 131.2 | 131.29 | 130.09 | 130.22 | 1034704.0 |
| 2023-10-17 | FGBM | Futures | 117.31 | 117.32 | 116.7 | 116.8 | 649788.0 |
| 2023-10-17 | FGBS | Futures | 107.086 | 107.086 | 106.897 | 106.928 | 713833.0 |
| 2023-10-17 | FGBX | Futures | 125.73 | 126.06 | 123.39 | 123.98 | 116557.0 |
| 2023-10-17 | FMWO | Futures | 9988.4 | 10056.9 | 9928.8 | 10009.4 | 2574.0 |
| 2023-10-17 | FOAT | Futures | 122.09 | 122.18 | 120.97 | 121.14 | 197820.0 |
| 2023-10-17 | FSMX | Futures | 25863.3 | 25902.3 | 25534.6 | 25822.2 | 35.0 |
| 2023-10-17 | FTDX | Futures | 3080.4 | 3084.6 | 3041.5 | 3076.3 | 24.0 |
| 2023-10-17 | FTI | Futures | 757.62 | 760.61 | 752.27 | 758.82 | 7235.0 |
| 2023-10-17 | FTUK | Futures | 7731.2 | 7792.1 | 7707.5 | 7769.9 | 90878.0 |
| 2023-10-17 | FVSA | Futures | 25.94 | 26.97 | 25.53 | 25.94 | 33505.0 |
> showing 50 of 129 rows — these rows as CSV