PREVIEW / futures_daily / 2021-07-29
file: by_date/futures_daily/2021/2021-07-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-07-29 | ES | Futures | 4938.9 | 4971.22 | 4924.0 | 4959.13 | 1009496.0 |
| 2021-07-29 | NQ | Futures | 17287.71 | 17402.22 | 17195.71 | 17348.86 | 412593.0 |
| 2021-07-29 | YM | Futures | 37807.0 | 38017.3 | 37706.1 | 37923.0 | 113206.0 |
| 2021-07-29 | CL | Futures | 52.4 | 53.33 | 52.3 | 53.28 | 294462.0 |
| 2021-07-29 | GC | Futures | 2113.4 | 2143.7 | 2112.7 | 2141.7 | 212065.0 |
| 2021-07-29 | ZN | Futures | 136.081494 | 136.128936 | 135.717766 | 135.84428 | 1386720.0 |
| 2021-07-29 | A6 | Futures | 0.75644 | 0.76044 | 0.75485 | 0.75916 | 69538.0 |
| 2021-07-29 | AD | Futures | 0.80937 | 0.8155 | 0.80906 | 0.81509 | 69312.0 |
| 2021-07-29 | ALI | Futures | 2934.45 | 3003.86 | 2934.45 | 2996.43 | 134.0 |
| 2021-07-29 | B | Futures | 49.21 | 50.05 | 49.08 | 50.02 | 247939.0 |
| 2021-07-29 | B6 | Futures | 1.412 | 1.4199 | 1.4113 | 1.4187 | 79326.0 |
| 2021-07-29 | BFX | Futures | 4301.4 | 4307.6 | 4294.3 | 4307.6 | 4.0 |
| 2021-07-29 | BR | Futures | 0.15583 | 0.15807 | 0.15575 | 0.15743 | 8159.0 |
| 2021-07-29 | BTC | Futures | 53963.8 | 54701.3 | 52897.8 | 53313.5 | 3947.0 |
| 2021-07-29 | BZ | Futures | 48.04 | 48.84 | 47.92 | 48.82 | 35603.0 |
| 2021-07-29 | C | Futures | 1449.0 | 1461.0 | 1442.0 | 1447.0 | 5520.0 |
| 2021-07-29 | CB | Futures | 129.975 | 130.376 | 129.954 | 129.954 | 80.0 |
| 2021-07-29 | CC | Futures | 1596.0 | 1610.0 | 1578.0 | 1597.0 | 19378.0 |
| 2021-07-29 | CNH | Futures | 6.2831 | 6.2846 | 6.248 | 6.2492 | 628.0 |
| 2021-07-29 | CSC | Futures | 2.409 | 2.409 | 2.388 | 2.388 | 77.0 |
| 2021-07-29 | CT | Futures | 84.44 | 84.56 | 83.61 | 83.94 | 30.0 |
| 2021-07-29 | DC | Futures | 21.52 | 21.52 | 21.13 | 21.21 | 442.0 |
| 2021-07-29 | DX | Futures | 89.172 | 89.206 | 88.781 | 88.801 | 23570.0 |
| 2021-07-29 | E1 | Futures | 1.23549 | 1.24166 | 1.23526 | 1.24144 | 22927.0 |
| 2021-07-29 | E6 | Futures | 1.26094 | 1.2661 | 1.26057 | 1.26589 | 150212.0 |
| 2021-07-29 | E7 | Futures | 1.2546 | 1.2598 | 1.2544 | 1.2595 | 4833.0 |
| 2021-07-29 | EBM | Futures | 320.7 | 325.85 | 319.23 | 324.74 | 28109.0 |
| 2021-07-29 | ED | Futures | 96.5345 | 96.5442 | 96.5345 | 96.5442 | 63353.0 |
| 2021-07-29 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.465 | 26365.0 |
| 2021-07-29 | ESG | Futures | 408.45 | 411.03 | 408.45 | 410.1 | 211.0 |
| 2021-07-29 | EW | Futures | 2876.8 | 2920.4 | 2870.1 | 2903.1 | 7531.0 |
| 2021-07-29 | FBON | Futures | 150.85 | 150.98 | 150.66 | 150.9 | 256.0 |
| 2021-07-29 | FBTP | Futures | 141.04 | 141.2 | 140.79 | 141.09 | 114913.0 |
| 2021-07-29 | FBTS | Futures | 110.38 | 110.399 | 110.331 | 110.38 | 56014.0 |
| 2021-07-29 | FCE | Futures | 6592.6 | 6654.5 | 6588.2 | 6617.6 | 51767.0 |
| 2021-07-29 | FDAX | Futures | 16640.5 | 16764.8 | 16599.8 | 16737.0 | 53240.0 |
| 2021-07-29 | FDXM | Futures | 16559.1 | 16681.6 | 16516.4 | 16653.9 | 39568.0 |
| 2021-07-29 | FDXS | Futures | 16428.4 | 16574.6 | 16416.8 | 16548.1 | 7065.0 |
| 2021-07-29 | FESX | Futures | 3877.3 | 3909.1 | 3867.9 | 3898.7 | 519470.0 |
| 2021-07-29 | FGBL | Futures | 171.04 | 171.14 | 170.52 | 170.92 | 594916.0 |
| 2021-07-29 | FGBM | Futures | 135.84 | 135.88 | 135.69 | 135.79 | 363819.0 |
| 2021-07-29 | FGBS | Futures | 112.785 | 112.79 | 112.754 | 112.775 | 299034.0 |
| 2021-07-29 | FGBX | Futures | 229.63 | 229.71 | 227.83 | 229.16 | 63182.0 |
| 2021-07-29 | FMWO | Futures | 10823.3 | 10926.7 | 10823.3 | 10914.9 | 2998.0 |
| 2021-07-29 | FOAT | Futures | 157.88 | 158.03 | 157.63 | 158.0 | 141045.0 |
| 2021-07-29 | FTDX | Futures | 3767.6 | 3773.3 | 3759.4 | 3772.3 | 54.0 |
| 2021-07-29 | FTI | Futures | 713.0 | 723.2 | 712.86 | 722.72 | 18440.0 |
| 2021-07-29 | FTUK | Futures | 6841.5 | 6914.4 | 6823.8 | 6900.1 | 85937.0 |
| 2021-07-29 | FVSA | Futures | 88.52 | 89.37 | 84.93 | 85.99 | 19572.0 |
| 2021-07-29 | FXXP | Futures | 437.2 | 440.6 | 436.1 | 440.1 | 56681.0 |
> showing 50 of 123 rows — these rows as CSV