PREVIEW / futures_daily / 2021-10-29
file: by_date/futures_daily/2021/2021-10-29.parquet size: 10 KB rows: 123
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-29 | ES | Futures | 5148.63 | 5178.44 | 5128.66 | 5171.13 | 1418280.0 |
| 2021-10-29 | NQ | Futures | 18081.03 | 18294.36 | 17983.88 | 18264.09 | 484693.0 |
| 2021-10-29 | YM | Futures | 38773.1 | 38892.8 | 38609.9 | 38847.1 | 156108.0 |
| 2021-10-29 | CL | Futures | 61.57 | 62.05 | 60.32 | 61.92 | 507309.0 |
| 2021-10-29 | GC | Futures | 2101.7 | 2103.4 | 2067.8 | 2081.2 | 254513.0 |
| 2021-10-29 | ZN | Futures | 132.907448 | 133.098133 | 132.446626 | 132.923338 | 2686126.0 |
| 2021-10-29 | A6 | Futures | 0.77356 | 0.77469 | 0.769 | 0.77156 | 105192.0 |
| 2021-10-29 | AD | Futures | 0.82242 | 0.82349 | 0.81816 | 0.82034 | 91713.0 |
| 2021-10-29 | ALI | Futures | 3073.68 | 3073.68 | 2985.56 | 3039.21 | 1009.0 |
| 2021-10-29 | B | Futures | 57.2 | 57.6 | 56.44 | 57.23 | 358922.0 |
| 2021-10-29 | B6 | Futures | 1.4002 | 1.4011 | 1.3875 | 1.3895 | 111542.0 |
| 2021-10-29 | BR | Futures | 0.14305 | 0.14419 | 0.14208 | 0.14374 | 6275.0 |
| 2021-10-29 | BTC | Futures | 81141.4 | 83749.7 | 79896.5 | 83005.5 | 6361.0 |
| 2021-10-29 | BZ | Futures | 56.02 | 56.24 | 55.11 | 55.89 | 35155.0 |
| 2021-10-29 | C | Futures | 1488.0 | 1490.0 | 1461.0 | 1466.0 | 5276.0 |
| 2021-10-29 | CB | Futures | 148.99 | 150.113 | 148.99 | 149.916 | 22.0 |
| 2021-10-29 | CC | Futures | 1646.0 | 1649.0 | 1621.0 | 1634.0 | 16693.0 |
| 2021-10-29 | CNH | Futures | 6.1378 | 6.1588 | 6.1327 | 6.1564 | 294.0 |
| 2021-10-29 | CSC | Futures | 2.519 | 2.519 | 2.492 | 2.509 | 63.0 |
| 2021-10-29 | CT | Futures | 106.17 | 107.47 | 104.67 | 107.19 | 22844.0 |
| 2021-10-29 | DC | Futures | 23.89 | 23.92 | 23.65 | 23.8 | 358.0 |
| 2021-10-29 | DX | Futures | 90.187 | 91.115 | 90.158 | 90.942 | 34702.0 |
| 2021-10-29 | E1 | Futures | 1.22986 | 1.23187 | 1.22191 | 1.22482 | 38124.0 |
| 2021-10-29 | E6 | Futures | 1.24224 | 1.24309 | 1.22657 | 1.22912 | 290589.0 |
| 2021-10-29 | E7 | Futures | 1.2354 | 1.2362 | 1.2199 | 1.2224 | 7011.0 |
| 2021-10-29 | EBM | Futures | 415.89 | 418.1 | 413.32 | 416.26 | 12902.0 |
| 2021-10-29 | ED | Futures | 96.5199 | 96.5296 | 96.515 | 96.5247 | 155406.0 |
| 2021-10-29 | ER | Futures | 98.47 | 98.48 | 98.465 | 98.475 | 61997.0 |
| 2021-10-29 | ESG | Futures | 428.5 | 432.02 | 427.59 | 431.86 | 1824.0 |
| 2021-10-29 | EW | Futures | 3001.9 | 3015.7 | 2989.3 | 3001.9 | 12393.0 |
| 2021-10-29 | FBON | Futures | 147.38 | 147.5 | 146.41 | 146.75 | 2122.0 |
| 2021-10-29 | FBTP | Futures | 136.27 | 136.35 | 134.65 | 135.05 | 361642.0 |
| 2021-10-29 | FBTS | Futures | 109.837 | 109.876 | 109.653 | 109.701 | 103557.0 |
| 2021-10-29 | FCE | Futures | 6854.1 | 6936.6 | 6821.8 | 6905.2 | 63493.0 |
| 2021-10-29 | FDAX | Futures | 16722.1 | 16796.9 | 16548.9 | 16742.4 | 89030.0 |
| 2021-10-29 | FDXM | Futures | 16770.7 | 16844.7 | 16595.0 | 16790.0 | 63307.0 |
| 2021-10-29 | FDXS | Futures | 16609.7 | 16689.4 | 16440.9 | 16634.1 | 22536.0 |
| 2021-10-29 | FESX | Futures | 4036.9 | 4076.7 | 4001.0 | 4057.5 | 986817.0 |
| 2021-10-29 | FGBL | Futures | 166.45 | 166.48 | 165.23 | 165.64 | 1345061.0 |
| 2021-10-29 | FGBM | Futures | 133.89 | 133.89 | 133.4 | 133.47 | 743579.0 |
| 2021-10-29 | FGBS | Futures | 112.438 | 112.473 | 112.373 | 112.383 | 511623.0 |
| 2021-10-29 | FGBX | Futures | 226.5 | 226.99 | 223.99 | 225.46 | 154794.0 |
| 2021-10-29 | FMWO | Futures | 11230.8 | 11300.3 | 11215.4 | 11265.0 | 4283.0 |
| 2021-10-29 | FOAT | Futures | 154.06 | 154.06 | 152.72 | 153.02 | 292670.0 |
| 2021-10-29 | FTDX | Futures | 3915.4 | 3921.6 | 3884.6 | 3921.6 | 177.0 |
| 2021-10-29 | FTI | Futures | 771.69 | 776.52 | 763.94 | 773.38 | 20023.0 |
| 2021-10-29 | FTUK | Futures | 7132.7 | 7148.0 | 7079.8 | 7135.1 | 94918.0 |
| 2021-10-29 | FVSA | Futures | 67.21 | 69.45 | 66.18 | 66.18 | 28601.0 |
| 2021-10-29 | FXXP | Futures | 453.5 | 454.1 | 448.3 | 452.5 | 89952.0 |
| 2021-10-29 | G | Futures | 120.32 | 120.54 | 119.97 | 120.2 | 365069.0 |
> showing 50 of 123 rows — these rows as CSV