PREVIEW / futures_daily / 2023-10-24
file: by_date/futures_daily/2023/2023-10-24.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-24 | ES | Futures | 4549.36 | 4592.45 | 4540.53 | 4571.84 | 1807092.0 |
| 2023-10-24 | NQ | Futures | 15912.02 | 16132.99 | 15871.01 | 16022.64 | 703058.0 |
| 2023-10-24 | YM | Futures | 34864.7 | 35169.9 | 34785.7 | 35011.0 | 205763.0 |
| 2023-10-24 | CL | Futures | 77.12 | 77.25 | 74.24 | 74.96 | 370591.0 |
| 2023-10-24 | GC | Futures | 2136.3 | 2144.8 | 2115.3 | 2138.4 | 200943.0 |
| 2023-10-24 | ZN | Futures | 107.886056 | 108.171218 | 107.553368 | 107.838529 | 1839686.0 |
| 2023-10-24 | A6 | Futures | 0.63999 | 0.64428 | 0.63964 | 0.64206 | 90553.0 |
| 2023-10-24 | AD | Futures | 0.73683 | 0.7385 | 0.73341 | 0.73477 | 84150.0 |
| 2023-10-24 | ALI | Futures | 2388.97 | 2415.27 | 2382.4 | 2401.57 | 1440.0 |
| 2023-10-24 | B | Futures | 81.4 | 81.59 | 78.6 | 79.24 | 304124.0 |
| 2023-10-24 | B6 | Futures | 1.2257 | 1.2297 | 1.2162 | 1.217 | 98987.0 |
| 2023-10-24 | BR | Futures | 0.18761 | 0.1879 | 0.18653 | 0.18757 | 4163.0 |
| 2023-10-24 | BTC | Futures | 42045.3 | 46554.6 | 41979.7 | 44771.8 | 10369.0 |
| 2023-10-24 | BZ | Futures | 81.12 | 81.41 | 78.43 | 79.07 | 42436.0 |
| 2023-10-24 | C | Futures | 2756.0 | 2771.0 | 2703.0 | 2728.0 | 8995.0 |
| 2023-10-24 | CB | Futures | 279.34 | 281.816 | 279.34 | 280.33 | 28.0 |
| 2023-10-24 | CC | Futures | 2202.0 | 2204.0 | 2159.0 | 2176.0 | 23275.0 |
| 2023-10-24 | CNH | Futures | 7.0721 | 7.0803 | 7.0619 | 7.0697 | 750.0 |
| 2023-10-24 | CSC | Futures | 1.996 | 2.011 | 1.966 | 1.969 | 163.0 |
| 2023-10-24 | CT | Futures | 102.09 | 102.95 | 100.67 | 101.11 | 19572.0 |
| 2023-10-24 | DC | Futures | 19.13 | 19.41 | 18.86 | 18.89 | 794.0 |
| 2023-10-24 | DX | Futures | 103.968 | 104.698 | 103.731 | 104.643 | 19120.0 |
| 2023-10-24 | E1 | Futures | 1.18457 | 1.18735 | 1.17864 | 1.18121 | 19688.0 |
| 2023-10-24 | E6 | Futures | 1.08808 | 1.09082 | 1.07917 | 1.07973 | 243411.0 |
| 2023-10-24 | E7 | Futures | 1.0882 | 1.0909 | 1.0794 | 1.08 | 4874.0 |
| 2023-10-24 | EBM | Futures | 324.19 | 324.54 | 321.45 | 321.79 | 31441.0 |
| 2023-10-24 | ER | Futures | 97.756 | 97.771 | 97.751 | 97.766 | 121367.0 |
| 2023-10-24 | ESG | Futures | 395.13 | 398.61 | 394.11 | 396.53 | 1087.0 |
| 2023-10-24 | EW | Futures | 2500.1 | 2523.6 | 2494.6 | 2506.6 | 10639.0 |
| 2023-10-24 | FBON | Futures | 117.76 | 118.61 | 117.76 | 117.92 | 48.0 |
| 2023-10-24 | FBTP | Futures | 108.1 | 108.79 | 107.93 | 107.97 | 188380.0 |
| 2023-10-24 | FBTS | Futures | 105.39 | 105.521 | 105.369 | 105.38 | 110805.0 |
| 2023-10-24 | FCE | Futures | 7314.9 | 7389.0 | 7306.9 | 7372.0 | 55465.0 |
| 2023-10-24 | FDAX | Futures | 15653.3 | 15807.1 | 15595.3 | 15758.6 | 67884.0 |
| 2023-10-24 | FDIV | Futures | 166.44 | 166.44 | 166.44 | 166.44 | 0.0 |
| 2023-10-24 | FDXM | Futures | 15647.1 | 15798.8 | 15591.3 | 15752.5 | 46094.0 |
| 2023-10-24 | FDXS | Futures | 15543.9 | 15696.6 | 15489.5 | 15649.6 | 21858.0 |
| 2023-10-24 | FESX | Futures | 4074.7 | 4118.0 | 4061.6 | 4105.9 | 773701.0 |
| 2023-10-24 | FEU3 | Futures | 97.761 | 97.761 | 97.761 | 97.761 | 0.0 |
| 2023-10-24 | FGBL | Futures | 130.4 | 131.27 | 130.35 | 130.7 | 963527.0 |
| 2023-10-24 | FGBM | Futures | 116.96 | 117.35 | 116.95 | 117.18 | 761815.0 |
| 2023-10-24 | FGBS | Futures | 107.03 | 107.106 | 107.009 | 107.07 | 495239.0 |
| 2023-10-24 | FGBX | Futures | 123.86 | 126.18 | 123.84 | 124.11 | 98874.0 |
| 2023-10-24 | FMWO | Futures | 9635.3 | 9723.5 | 9635.3 | 9684.9 | 4356.0 |
| 2023-10-24 | FOAT | Futures | 121.34 | 122.23 | 121.29 | 121.59 | 193288.0 |
| 2023-10-24 | FSMX | Futures | 25151.5 | 25322.0 | 24949.1 | 25258.3 | 401.0 |
| 2023-10-24 | FTDX | Futures | 2962.5 | 3005.1 | 2962.5 | 2999.9 | 32.0 |
| 2023-10-24 | FTI | Futures | 738.57 | 745.42 | 736.35 | 742.66 | 14210.0 |
| 2023-10-24 | FTUK | Futures | 7441.5 | 7485.8 | 7400.7 | 7464.2 | 100039.0 |
| 2023-10-24 | FVSA | Futures | 28.96 | 28.96 | 27.38 | 27.93 | 18729.0 |
> showing 50 of 129 rows — these rows as CSV