PREVIEW / futures_daily / 2023-07-07
file: by_date/futures_daily/2023/2023-07-07.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-07-07 | ES | Futures | 4809.65 | 4847.29 | 4799.1 | 4801.8 | 1691644.0 |
| 2023-07-07 | NQ | Futures | 16644.27 | 16806.21 | 16601.05 | 16611.45 | 555119.0 |
| 2023-07-07 | YM | Futures | 36247.5 | 36393.1 | 36046.7 | 36066.9 | 137648.0 |
| 2023-07-07 | CL | Futures | 62.39 | 64.15 | 61.78 | 64.1 | 362632.0 |
| 2023-07-07 | GC | Futures | 2107.0 | 2133.9 | 2105.7 | 2124.5 | 214272.0 |
| 2023-07-07 | ZN | Futures | 112.706505 | 112.976861 | 112.261214 | 112.642892 | 1716116.0 |
| 2023-07-07 | A6 | Futures | 0.67268 | 0.68033 | 0.67208 | 0.67967 | 92729.0 |
| 2023-07-07 | AD | Futures | 0.75678 | 0.76254 | 0.75562 | 0.76214 | 75115.0 |
| 2023-07-07 | ALI | Futures | 2364.47 | 2373.34 | 2330.64 | 2368.07 | 2246.0 |
| 2023-07-07 | B | Futures | 67.04 | 68.81 | 66.61 | 68.75 | 331526.0 |
| 2023-07-07 | B6 | Futures | 1.2762 | 1.2876 | 1.2751 | 1.2866 | 110278.0 |
| 2023-07-07 | BFX | Futures | 3873.6 | 3873.6 | 3873.6 | 3873.6 | 0.0 |
| 2023-07-07 | BR | Futures | 0.18765 | 0.19021 | 0.18728 | 0.19007 | 88.0 |
| 2023-07-07 | BTC | Futures | 40734.0 | 41156.5 | 40070.0 | 40734.0 | 6541.0 |
| 2023-07-07 | BZ | Futures | 66.89 | 68.68 | 66.48 | 68.63 | 26656.0 |
| 2023-07-07 | C | Futures | 2159.0 | 2175.0 | 2150.0 | 2159.0 | 763.0 |
| 2023-07-07 | CB | Futures | 231.64 | 231.926 | 231.64 | 231.926 | 11.0 |
| 2023-07-07 | CC | Futures | 1918.0 | 1938.0 | 1908.0 | 1919.0 | 14142.0 |
| 2023-07-07 | CNH | Futures | 6.9431 | 6.946 | 6.9163 | 6.9204 | 475.0 |
| 2023-07-07 | CSC | Futures | 1.788 | 1.788 | 1.768 | 1.788 | 132.0 |
| 2023-07-07 | CT | Futures | 103.57 | 104.84 | 101.19 | 101.34 | 101.0 |
| 2023-07-07 | DC | Futures | 16.24 | 16.28 | 16.02 | 16.26 | 308.0 |
| 2023-07-07 | DX | Futures | 100.837 | 100.925 | 99.979 | 100.018 | 19418.0 |
| 2023-07-07 | E1 | Futures | 1.19376 | 1.20421 | 1.19143 | 1.20288 | 24023.0 |
| 2023-07-07 | E6 | Futures | 1.11843 | 1.12697 | 1.11608 | 1.12641 | 204480.0 |
| 2023-07-07 | E7 | Futures | 1.1184 | 1.127 | 1.1161 | 1.1265 | 4593.0 |
| 2023-07-07 | EBM | Futures | 337.56 | 341.95 | 336.46 | 339.75 | 16699.0 |
| 2023-07-07 | ER | Futures | 97.792 | 97.802 | 97.782 | 97.797 | 89280.0 |
| 2023-07-07 | ESG | Futures | 416.71 | 420.38 | 416.33 | 416.5 | 360.0 |
| 2023-07-07 | EW | Futures | 2744.3 | 2795.7 | 2736.9 | 2771.7 | 8809.0 |
| 2023-07-07 | FBON | Futures | 119.94 | 120.36 | 119.61 | 120.06 | 292.0 |
| 2023-07-07 | FBTP | Futures | 111.59 | 112.03 | 111.16 | 111.77 | 156882.0 |
| 2023-07-07 | FBTS | Futures | 105.411 | 105.684 | 105.371 | 105.644 | 107294.0 |
| 2023-07-07 | FCE | Futures | 7738.3 | 7794.9 | 7686.0 | 7750.8 | 68528.0 |
| 2023-07-07 | FDAX | Futures | 16537.5 | 16730.2 | 16469.8 | 16624.3 | 71231.0 |
| 2023-07-07 | FDIV | Futures | 182.6 | 182.6 | 182.6 | 182.6 | 0.0 |
| 2023-07-07 | FDXM | Futures | 16621.2 | 16798.7 | 16534.0 | 16692.4 | 40955.0 |
| 2023-07-07 | FDXS | Futures | 16533.7 | 16691.1 | 16430.2 | 16585.5 | 26341.0 |
| 2023-07-07 | FESX | Futures | 4300.3 | 4338.8 | 4275.0 | 4314.5 | 950829.0 |
| 2023-07-07 | FEU3 | Futures | 97.787 | 97.787 | 97.787 | 97.787 | 0.0 |
| 2023-07-07 | FGBL | Futures | 132.97 | 133.16 | 132.25 | 132.76 | 771758.0 |
| 2023-07-07 | FGBM | Futures | 117.42 | 117.65 | 117.21 | 117.49 | 641376.0 |
| 2023-07-07 | FGBS | Futures | 107.11 | 107.218 | 107.069 | 107.177 | 530083.0 |
| 2023-07-07 | FGBX | Futures | 137.6 | 137.66 | 135.45 | 135.94 | 92336.0 |
| 2023-07-07 | FMWO | Futures | 10243.7 | 10324.2 | 10201.2 | 10262.7 | 7241.0 |
| 2023-07-07 | FOAT | Futures | 124.08 | 124.45 | 123.56 | 124.05 | 199694.0 |
| 2023-07-07 | FSMX | Futures | 27956.0 | 28331.5 | 27835.3 | 28278.4 | 158.0 |
| 2023-07-07 | FTDX | Futures | 3245.4 | 3287.0 | 3243.9 | 3282.8 | 51.0 |
| 2023-07-07 | FTI | Futures | 793.73 | 795.88 | 786.06 | 792.33 | 19250.0 |
| 2023-07-07 | FTUK | Futures | 7398.9 | 7404.5 | 7340.5 | 7366.4 | 110259.0 |
> showing 50 of 130 rows — these rows as CSV