PREVIEW / futures_daily / 2023-10-23
file: by_date/futures_daily/2023/2023-10-23.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-23 | ES | Futures | 4555.79 | 4582.01 | 4509.76 | 4540.27 | 1963670.0 |
| 2023-10-23 | NQ | Futures | 15842.95 | 16030.47 | 15664.07 | 15877.49 | 765733.0 |
| 2023-10-23 | YM | Futures | 35042.5 | 35113.0 | 34741.5 | 34798.4 | 201983.0 |
| 2023-10-23 | CL | Futures | 78.77 | 79.03 | 76.4 | 76.53 | 315517.0 |
| 2023-10-23 | GC | Futures | 2140.1 | 2147.2 | 2122.1 | 2140.2 | 212290.0 |
| 2023-10-23 | ZN | Futures | 107.252364 | 107.98111 | 106.856307 | 107.965268 | 2092633.0 |
| 2023-10-23 | A6 | Futures | 0.63772 | 0.6413 | 0.6352 | 0.6408 | 89799.0 |
| 2023-10-23 | AD | Futures | 0.73598 | 0.7382 | 0.73442 | 0.73749 | 81933.0 |
| 2023-10-23 | ALI | Futures | 2393.35 | 2393.35 | 2377.47 | 2388.15 | 3070.0 |
| 2023-10-23 | B | Futures | 82.88 | 83.18 | 80.64 | 80.83 | 282444.0 |
| 2023-10-23 | B6 | Futures | 1.2173 | 1.2267 | 1.2151 | 1.2264 | 96444.0 |
| 2023-10-23 | BR | Futures | 0.18564 | 0.18752 | 0.18564 | 0.187 | 1256.0 |
| 2023-10-23 | BTC | Futures | 39875.2 | 42652.9 | 39848.5 | 42045.3 | 15576.0 |
| 2023-10-23 | BZ | Futures | 82.72 | 82.99 | 80.46 | 80.65 | 36158.0 |
| 2023-10-23 | C | Futures | 2717.0 | 2778.0 | 2716.0 | 2758.0 | 6102.0 |
| 2023-10-23 | CB | Futures | 274.882 | 281.321 | 274.882 | 279.34 | 10.0 |
| 2023-10-23 | CC | Futures | 2174.0 | 2209.0 | 2167.0 | 2193.0 | 20738.0 |
| 2023-10-23 | CNH | Futures | 7.0861 | 7.0929 | 7.0687 | 7.0721 | 552.0 |
| 2023-10-23 | CSC | Futures | 2.041 | 2.057 | 2.0 | 2.005 | 114.0 |
| 2023-10-23 | CT | Futures | 100.33 | 103.51 | 99.59 | 102.09 | 33193.0 |
| 2023-10-23 | DC | Futures | 19.64 | 19.8 | 19.23 | 19.25 | 343.0 |
| 2023-10-23 | DX | Futures | 104.55 | 104.712 | 103.889 | 103.907 | 15883.0 |
| 2023-10-23 | E1 | Futures | 1.18274 | 1.1851 | 1.17833 | 1.18478 | 23477.0 |
| 2023-10-23 | E6 | Futures | 1.0804 | 1.08889 | 1.078 | 1.08853 | 226858.0 |
| 2023-10-23 | E7 | Futures | 1.0806 | 1.089 | 1.0782 | 1.0887 | 4964.0 |
| 2023-10-23 | EBM | Futures | 327.28 | 328.31 | 324.19 | 326.25 | 23331.0 |
| 2023-10-23 | ER | Futures | 97.751 | 97.761 | 97.751 | 97.756 | 93486.0 |
| 2023-10-23 | ESG | Futures | 394.48 | 396.78 | 390.41 | 393.36 | 715.0 |
| 2023-10-23 | EW | Futures | 2523.2 | 2525.9 | 2491.2 | 2493.6 | 11687.0 |
| 2023-10-23 | FBON | Futures | 117.15 | 117.68 | 116.8 | 117.65 | 64.0 |
| 2023-10-23 | FBTP | Futures | 107.32 | 108.08 | 106.74 | 107.87 | 202749.0 |
| 2023-10-23 | FBTS | Futures | 105.228 | 105.41 | 105.218 | 105.38 | 95862.0 |
| 2023-10-23 | FCE | Futures | 7311.7 | 7339.4 | 7243.9 | 7326.6 | 58490.0 |
| 2023-10-23 | FDAX | Futures | 15702.8 | 15740.7 | 15501.6 | 15677.5 | 74124.0 |
| 2023-10-23 | FDIV | Futures | 165.5 | 166.49 | 165.5 | 166.49 | 20.0 |
| 2023-10-23 | FDXM | Futures | 15703.0 | 15734.5 | 15495.5 | 15671.4 | 51082.0 |
| 2023-10-23 | FDXS | Futures | 15581.6 | 15631.8 | 15393.2 | 15569.0 | 29171.0 |
| 2023-10-23 | FESX | Futures | 4076.7 | 4093.8 | 4034.4 | 4084.7 | 959663.0 |
| 2023-10-23 | FEU3 | Futures | 97.751 | 97.751 | 97.751 | 97.751 | 0.0 |
| 2023-10-23 | FGBL | Futures | 129.88 | 130.49 | 129.29 | 130.29 | 848436.0 |
| 2023-10-23 | FGBM | Futures | 116.85 | 117.03 | 116.57 | 116.93 | 569049.0 |
| 2023-10-23 | FGBS | Futures | 106.984 | 107.035 | 106.948 | 107.009 | 467568.0 |
| 2023-10-23 | FGBX | Futures | 122.59 | 124.33 | 120.95 | 123.68 | 88823.0 |
| 2023-10-23 | FMWO | Futures | 9673.9 | 9718.0 | 9573.4 | 9677.2 | 5884.0 |
| 2023-10-23 | FOAT | Futures | 120.75 | 121.48 | 120.27 | 121.3 | 183591.0 |
| 2023-10-23 | FSMX | Futures | 24811.5 | 24892.6 | 24497.2 | 24892.6 | 322.0 |
| 2023-10-23 | FTDX | Futures | 2979.1 | 2979.1 | 2932.4 | 2971.3 | 49.0 |
| 2023-10-23 | FTI | Futures | 738.21 | 741.09 | 732.28 | 740.1 | 15777.0 |
| 2023-10-23 | FTUK | Futures | 7480.8 | 7488.9 | 7416.3 | 7454.6 | 107257.0 |
| 2023-10-23 | FVSA | Futures | 29.85 | 31.02 | 28.2 | 28.96 | 39517.0 |
> showing 50 of 129 rows — these rows as CSV