PREVIEW / futures_daily / 2023-10-20
file: by_date/futures_daily/2023/2023-10-20.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-20 | ES | Futures | 4597.26 | 4607.16 | 4542.14 | 4547.49 | 2328806.0 |
| 2023-10-20 | NQ | Futures | 16026.42 | 16066.89 | 15805.18 | 15825.68 | 846675.0 |
| 2023-10-20 | YM | Futures | 35285.6 | 35316.1 | 34959.4 | 34999.4 | 196250.0 |
| 2023-10-20 | CL | Futures | 79.75 | 80.43 | 78.35 | 78.85 | 311917.0 |
| 2023-10-20 | GC | Futures | 2140.5 | 2163.3 | 2135.8 | 2147.3 | 289109.0 |
| 2023-10-20 | ZN | Futures | 106.919676 | 107.664264 | 106.887991 | 107.474156 | 1968824.0 |
| 2023-10-20 | A6 | Futures | 0.63913 | 0.63934 | 0.63606 | 0.63777 | 68612.0 |
| 2023-10-20 | AD | Futures | 0.73542 | 0.73804 | 0.73457 | 0.73628 | 82844.0 |
| 2023-10-20 | ALI | Futures | 2400.48 | 2401.57 | 2385.68 | 2395.0 | 2836.0 |
| 2023-10-20 | B | Futures | 83.89 | 84.39 | 82.47 | 82.92 | 272722.0 |
| 2023-10-20 | B6 | Futures | 1.215 | 1.2178 | 1.2102 | 1.2165 | 80779.0 |
| 2023-10-20 | BR | Futures | 0.18502 | 0.18625 | 0.1838 | 0.1862 | 1271.0 |
| 2023-10-20 | BTC | Futures | 38386.3 | 40683.2 | 38326.2 | 39641.5 | 10080.0 |
| 2023-10-20 | BZ | Futures | 83.36 | 84.21 | 82.31 | 82.75 | 30081.0 |
| 2023-10-20 | C | Futures | 2661.0 | 2720.0 | 2644.0 | 2715.0 | 5945.0 |
| 2023-10-20 | CB | Futures | 277.21 | 277.21 | 275.377 | 277.21 | 15.0 |
| 2023-10-20 | CC | Futures | 2110.0 | 2164.0 | 2102.0 | 2155.0 | 20399.0 |
| 2023-10-20 | CNH | Futures | 7.0978 | 7.1002 | 7.0808 | 7.0861 | 779.0 |
| 2023-10-20 | CSC | Futures | 2.056 | 2.077 | 2.02 | 2.02 | 185.0 |
| 2023-10-20 | CT | Futures | 102.55 | 102.57 | 99.38 | 100.47 | 31366.0 |
| 2023-10-20 | DC | Futures | 19.86 | 20.09 | 19.37 | 19.46 | 633.0 |
| 2023-10-20 | DX | Futures | 104.594 | 104.791 | 104.451 | 104.553 | 10754.0 |
| 2023-10-20 | E1 | Futures | 1.18457 | 1.18594 | 1.18137 | 1.18342 | 25993.0 |
| 2023-10-20 | E6 | Futures | 1.07892 | 1.08136 | 1.07739 | 1.08019 | 171906.0 |
| 2023-10-20 | E7 | Futures | 1.0793 | 1.0815 | 1.0776 | 1.0804 | 3950.0 |
| 2023-10-20 | EBM | Futures | 329.34 | 330.03 | 326.25 | 329.34 | 30603.0 |
| 2023-10-20 | ER | Futures | 97.751 | 97.761 | 97.746 | 97.761 | 100168.0 |
| 2023-10-20 | ESG | Futures | 397.47 | 398.8 | 393.54 | 394.0 | 515.0 |
| 2023-10-20 | EW | Futures | 2546.6 | 2551.8 | 2514.0 | 2516.9 | 13854.0 |
| 2023-10-20 | FBON | Futures | 117.13 | 117.52 | 116.89 | 117.31 | 62.0 |
| 2023-10-20 | FBTP | Futures | 107.15 | 107.57 | 106.85 | 107.35 | 197029.0 |
| 2023-10-20 | FBTS | Futures | 105.197 | 105.319 | 105.117 | 105.278 | 117731.0 |
| 2023-10-20 | FCE | Futures | 7342.6 | 7360.2 | 7284.5 | 7290.3 | 80391.0 |
| 2023-10-20 | FDAX | Futures | 15824.0 | 15879.8 | 15662.8 | 15700.7 | 75416.0 |
| 2023-10-20 | FDIV | Futures | 167.69 | 167.69 | 166.64 | 166.64 | 11.0 |
| 2023-10-20 | FDXM | Futures | 15833.5 | 15872.5 | 15654.5 | 15694.5 | 56803.0 |
| 2023-10-20 | FDXS | Futures | 15730.1 | 15770.9 | 15553.3 | 15592.0 | 30311.0 |
| 2023-10-20 | FESX | Futures | 4098.8 | 4111.9 | 4064.6 | 4072.7 | 1188575.0 |
| 2023-10-20 | FEU3 | Futures | 97.756 | 97.756 | 97.756 | 97.756 | 0.0 |
| 2023-10-20 | FGBL | Futures | 129.64 | 130.26 | 129.6 | 130.22 | 802793.0 |
| 2023-10-20 | FGBM | Futures | 116.67 | 116.98 | 116.64 | 116.97 | 586837.0 |
| 2023-10-20 | FGBS | Futures | 106.938 | 107.05 | 106.923 | 107.045 | 539673.0 |
| 2023-10-20 | FGBX | Futures | 121.93 | 123.39 | 121.87 | 123.06 | 85712.0 |
| 2023-10-20 | FMWO | Futures | 9751.1 | 9771.0 | 9643.0 | 9673.9 | 6501.0 |
| 2023-10-20 | FOAT | Futures | 120.55 | 121.18 | 120.55 | 121.11 | 183577.0 |
| 2023-10-20 | FSMX | Futures | 24861.8 | 25022.0 | 24825.9 | 24902.9 | 342.0 |
| 2023-10-20 | FTDX | Futures | 2978.1 | 2981.7 | 2977.1 | 2977.1 | 5.0 |
| 2023-10-20 | FTI | Futures | 744.03 | 745.78 | 735.89 | 737.09 | 24588.0 |
| 2023-10-20 | FTUK | Futures | 7554.3 | 7572.5 | 7464.7 | 7481.3 | 117372.0 |
| 2023-10-20 | FVSA | Futures | 29.85 | 30.33 | 29.03 | 30.26 | 30543.0 |
> showing 50 of 129 rows — these rows as CSV