PREVIEW / futures_daily / 2023-09-21
file: by_date/futures_daily/2023/2023-09-21.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-09-21 | ES | Futures | 4757.82 | 4759.96 | 4673.8 | 4679.68 | 1998638.0 |
| 2023-09-21 | NQ | Futures | 16332.11 | 16349.11 | 16016.71 | 16040.18 | 702742.0 |
| 2023-09-21 | YM | Futures | 36550.6 | 36565.3 | 36097.0 | 36134.9 | 213067.0 |
| 2023-09-21 | CL | Futures | 78.73 | 80.22 | 77.91 | 79.03 | 351032.0 |
| 2023-09-21 | GC | Futures | 2101.7 | 2101.9 | 2081.3 | 2088.3 | 225908.0 |
| 2023-09-21 | ZN | Futures | 110.309928 | 110.309928 | 109.755447 | 109.929713 | 2142465.0 |
| 2023-09-21 | A6 | Futures | 0.65199 | 0.65239 | 0.64554 | 0.64896 | 129689.0 |
| 2023-09-21 | AD | Futures | 0.74989 | 0.74994 | 0.7454 | 0.74929 | 102310.0 |
| 2023-09-21 | ALI | Futures | 2470.05 | 2473.63 | 2435.92 | 2443.07 | 2950.0 |
| 2023-09-21 | B | Futures | 82.96 | 84.32 | 82.18 | 83.16 | 314693.0 |
| 2023-09-21 | B6 | Futures | 1.2348 | 1.2352 | 1.2238 | 1.2298 | 167592.0 |
| 2023-09-21 | BFX | Futures | 3961.6 | 3961.6 | 3961.6 | 3961.6 | 0.0 |
| 2023-09-21 | BR | Futures | 0.19082 | 0.19082 | 0.18907 | 0.18936 | 27.0 |
| 2023-09-21 | BTC | Futures | 36214.8 | 36301.5 | 35168.3 | 35508.2 | 6747.0 |
| 2023-09-21 | BZ | Futures | 82.89 | 84.12 | 81.98 | 82.96 | 38711.0 |
| 2023-09-21 | C | Futures | 2483.0 | 2510.0 | 2477.0 | 2492.0 | 5441.0 |
| 2023-09-21 | CB | Futures | 262.005 | 266.957 | 262.005 | 266.957 | 22.0 |
| 2023-09-21 | CC | Futures | 2086.0 | 2106.0 | 2073.0 | 2097.0 | 21421.0 |
| 2023-09-21 | CNH | Futures | 7.0576 | 7.0739 | 7.0555 | 7.0639 | 1482.0 |
| 2023-09-21 | CSC | Futures | 2.041 | 2.042 | 2.035 | 2.038 | 57.0 |
| 2023-09-21 | CT | Futures | 105.94 | 105.97 | 105.57 | 105.78 | 12.0 |
| 2023-09-21 | DC | Futures | 19.03 | 19.21 | 18.93 | 19.09 | 401.0 |
| 2023-09-21 | DX | Futures | 103.706 | 104.012 | 103.539 | 103.621 | 16093.0 |
| 2023-09-21 | E1 | Futures | 1.17838 | 1.17838 | 1.16637 | 1.17156 | 40869.0 |
| 2023-09-21 | E6 | Futures | 1.08879 | 1.08996 | 1.08416 | 1.08874 | 237984.0 |
| 2023-09-21 | E7 | Futures | 1.0892 | 1.0902 | 1.0845 | 1.0889 | 5753.0 |
| 2023-09-21 | EBM | Futures | 327.28 | 329.0 | 323.85 | 324.19 | 35548.0 |
| 2023-09-21 | ER | Futures | 97.741 | 97.756 | 97.731 | 97.756 | 127966.0 |
| 2023-09-21 | ESG | Futures | 410.21 | 410.21 | 403.79 | 404.04 | 1165.0 |
| 2023-09-21 | EW | Futures | 2688.0 | 2688.8 | 2635.8 | 2638.7 | 10247.0 |
| 2023-09-21 | FBON | Futures | 118.86 | 119.26 | 118.69 | 119.26 | 93.0 |
| 2023-09-21 | FBTP | Futures | 110.7 | 110.93 | 109.99 | 110.57 | 195466.0 |
| 2023-09-21 | FBTS | Futures | 105.511 | 105.572 | 105.41 | 105.552 | 132196.0 |
| 2023-09-21 | FCE | Futures | 7846.6 | 7853.6 | 7727.1 | 7791.7 | 69251.0 |
| 2023-09-21 | FDAX | Futures | 16675.2 | 16695.2 | 16466.6 | 16561.4 | 74370.0 |
| 2023-09-21 | FDIV | Futures | 182.42 | 182.42 | 181.13 | 181.13 | 3.0 |
| 2023-09-21 | FDXM | Futures | 16685.5 | 16687.6 | 16459.1 | 16554.9 | 55944.0 |
| 2023-09-21 | FDXS | Futures | 16580.7 | 16580.7 | 16351.6 | 16446.8 | 22361.0 |
| 2023-09-21 | FESX | Futures | 4308.3 | 4311.3 | 4241.8 | 4271.1 | 889125.0 |
| 2023-09-21 | FEU3 | Futures | 97.751 | 97.751 | 97.751 | 97.751 | 0.0 |
| 2023-09-21 | FGBL | Futures | 131.6 | 131.89 | 131.26 | 131.75 | 868100.0 |
| 2023-09-21 | FGBM | Futures | 117.0 | 117.23 | 116.86 | 117.19 | 661791.0 |
| 2023-09-21 | FGBS | Futures | 106.846 | 106.953 | 106.805 | 106.943 | 542821.0 |
| 2023-09-21 | FGBX | Futures | 129.22 | 129.93 | 128.52 | 129.52 | 95802.0 |
| 2023-09-21 | FMWO | Futures | 10149.6 | 10151.8 | 10000.6 | 10059.1 | 6108.0 |
| 2023-09-21 | FOAT | Futures | 122.95 | 123.22 | 122.56 | 123.04 | 192539.0 |
| 2023-09-21 | FSMX | Futures | 27943.2 | 27943.2 | 27509.8 | 27569.3 | 116.0 |
| 2023-09-21 | FTDX | Futures | 3190.0 | 3194.2 | 3156.3 | 3156.3 | 24.0 |
| 2023-09-21 | FTI | Futures | 763.2 | 764.55 | 756.87 | 761.65 | 18365.0 |
| 2023-09-21 | FTUK | Futures | 7801.2 | 7856.6 | 7748.3 | 7788.6 | 111852.0 |
> showing 50 of 130 rows — these rows as CSV