PREVIEW / futures_daily / 2022-10-27
file: by_date/futures_daily/2022/2022-10-27.parquet size: 10 KB rows: 127
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-27 | ES | Futures | 4284.72 | 4314.25 | 4188.03 | 4257.13 | 2211786.0 |
| 2022-10-27 | NQ | Futures | 12939.16 | 13074.87 | 12376.79 | 12732.35 | 769071.0 |
| 2022-10-27 | YM | Futures | 34767.6 | 35279.0 | 34680.5 | 34901.4 | 229318.0 |
| 2022-10-27 | CL | Futures | 76.27 | 77.59 | 75.46 | 76.97 | 292556.0 |
| 2022-10-27 | GC | Futures | 1909.8 | 1916.6 | 1898.0 | 1906.1 | 189287.0 |
| 2022-10-27 | ZN | Futures | 114.322917 | 115.190948 | 113.744229 | 114.901604 | 2359431.0 |
| 2022-10-27 | A6 | Futures | 0.66512 | 0.66793 | 0.65811 | 0.66164 | 118596.0 |
| 2022-10-27 | AD | Futures | 0.74844 | 0.75174 | 0.74454 | 0.74794 | 98508.0 |
| 2022-10-27 | ALI | Futures | 2660.43 | 2679.09 | 2605.03 | 2619.45 | 920.0 |
| 2022-10-27 | B | Futures | 82.38 | 83.39 | 81.53 | 83.16 | 247955.0 |
| 2022-10-27 | B6 | Futures | 1.1752 | 1.1772 | 1.1675 | 1.1686 | 130005.0 |
| 2022-10-27 | BR | Futures | 0.1623 | 0.16666 | 0.16028 | 0.16455 | 9876.0 |
| 2022-10-27 | BTC | Futures | 28425.9 | 28741.3 | 27884.2 | 28412.2 | 8249.0 |
| 2022-10-27 | BZ | Futures | 80.79 | 81.75 | 79.95 | 81.53 | 27339.0 |
| 2022-10-27 | C | Futures | 1359.0 | 1374.0 | 1349.0 | 1369.0 | 8342.0 |
| 2022-10-27 | CB | Futures | 236.773 | 237.913 | 236.59 | 236.773 | 55.0 |
| 2022-10-27 | CC | Futures | 1337.0 | 1361.0 | 1334.0 | 1355.0 | 22134.0 |
| 2022-10-27 | CNH | Futures | 6.7799 | 6.8482 | 6.7539 | 6.8307 | 1954.0 |
| 2022-10-27 | CSC | Futures | 2.398 | 2.398 | 2.36 | 2.364 | 145.0 |
| 2022-10-27 | CT | Futures | 100.77 | 101.14 | 96.9 | 97.27 | 18100.0 |
| 2022-10-27 | DC | Futures | 23.06 | 23.35 | 22.71 | 22.73 | 671.0 |
| 2022-10-27 | DX | Futures | 106.197 | 107.197 | 106.115 | 107.171 | 50399.0 |
| 2022-10-27 | E1 | Futures | 1.11765 | 1.11957 | 1.10981 | 1.1108 | 22796.0 |
| 2022-10-27 | E6 | Futures | 1.05325 | 1.05434 | 1.04008 | 1.0406 | 291972.0 |
| 2022-10-27 | E7 | Futures | 1.0513 | 1.0526 | 1.0384 | 1.0389 | 10241.0 |
| 2022-10-27 | EBM | Futures | 477.35 | 482.31 | 476.28 | 477.35 | 19221.0 |
| 2022-10-27 | ED | Futures | 94.102 | 94.1515 | 94.0673 | 94.1218 | 258541.0 |
| 2022-10-27 | ER | Futures | 97.746 | 97.826 | 97.731 | 97.786 | 283669.0 |
| 2022-10-27 | ESG | Futures | 369.26 | 371.12 | 362.7 | 366.28 | 1322.0 |
| 2022-10-27 | EW | Futures | 2596.3 | 2628.2 | 2573.0 | 2593.6 | 13940.0 |
| 2022-10-27 | FBON | Futures | 122.26 | 125.05 | 121.82 | 124.72 | 231.0 |
| 2022-10-27 | FBTP | Futures | 107.93 | 111.37 | 106.8 | 110.61 | 217972.0 |
| 2022-10-27 | FBTS | Futures | 105.699 | 106.507 | 105.479 | 106.398 | 149345.0 |
| 2022-10-27 | FCE | Futures | 6844.2 | 6855.7 | 6759.2 | 6814.8 | 63420.0 |
| 2022-10-27 | FDAX | Futures | 14412.8 | 14496.9 | 14256.7 | 14457.6 | 65356.0 |
| 2022-10-27 | FDIV | Futures | 156.49 | 157.49 | 156.49 | 157.49 | 21.0 |
| 2022-10-27 | FDXM | Futures | 14202.9 | 14281.4 | 14056.6 | 14242.7 | 48736.0 |
| 2022-10-27 | FDXS | Futures | 14117.3 | 14210.4 | 13983.5 | 14171.8 | 20406.0 |
| 2022-10-27 | FESX | Futures | 3560.7 | 3579.5 | 3525.0 | 3568.6 | 979974.0 |
| 2022-10-27 | FGBL | Futures | 138.71 | 140.62 | 137.36 | 140.05 | 924236.0 |
| 2022-10-27 | FGBM | Futures | 121.5 | 122.78 | 120.87 | 122.4 | 731393.0 |
| 2022-10-27 | FGBS | Futures | 109.157 | 109.637 | 108.978 | 109.489 | 926040.0 |
| 2022-10-27 | FGBX | Futures | 148.81 | 152.45 | 146.74 | 150.95 | 75207.0 |
| 2022-10-27 | FMWO | Futures | 9094.6 | 9119.0 | 8991.2 | 9064.4 | 5552.0 |
| 2022-10-27 | FOAT | Futures | 128.51 | 130.83 | 127.36 | 130.22 | 169818.0 |
| 2022-10-27 | FSMX | Futures | 25528.8 | 25620.7 | 25001.1 | 25375.4 | 960.0 |
| 2022-10-27 | FTDX | Futures | 3056.2 | 3058.8 | 3014.1 | 3037.5 | 82.0 |
| 2022-10-27 | FTI | Futures | 673.29 | 681.64 | 671.72 | 679.46 | 21996.0 |
| 2022-10-27 | FTUK | Futures | 7102.9 | 7158.9 | 7088.7 | 7137.2 | 87147.0 |
| 2022-10-27 | FVSA | Futures | 62.27 | 62.85 | 59.95 | 60.42 | 27036.0 |
> showing 50 of 127 rows — these rows as CSV