PREVIEW / futures_daily / 2021-11-24
file: by_date/futures_daily/2021/2021-11-24.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-11-24 | ES | Futures | 5271.52 | 5289.52 | 5237.78 | 5285.87 | 1408571.0 |
| 2021-11-24 | NQ | Futures | 18796.56 | 18875.26 | 18567.95 | 18872.38 | 656267.0 |
| 2021-11-24 | YM | Futures | 38910.2 | 38940.7 | 38660.0 | 38896.1 | 149804.0 |
| 2021-11-24 | CL | Futures | 59.03 | 59.59 | 58.65 | 58.96 | 328848.0 |
| 2021-11-24 | GC | Futures | 2088.1 | 2095.5 | 2073.6 | 2081.7 | 203236.0 |
| 2021-11-24 | ZN | Futures | 131.969913 | 132.319502 | 131.699776 | 132.033475 | 3184097.0 |
| 2021-11-24 | A6 | Futures | 0.74091 | 0.74101 | 0.73645 | 0.73727 | 79680.0 |
| 2021-11-24 | AD | Futures | 0.80105 | 0.80247 | 0.79867 | 0.80115 | 65919.0 |
| 2021-11-24 | ALI | Futures | 3020.28 | 3020.28 | 3014.69 | 3018.6 | 542.0 |
| 2021-11-24 | B | Futures | 55.97 | 56.74 | 55.88 | 56.23 | 231071.0 |
| 2021-11-24 | B6 | Futures | 1.358 | 1.3592 | 1.3517 | 1.3523 | 79409.0 |
| 2021-11-24 | BR | Futures | 0.14451 | 0.14468 | 0.14451 | 0.14468 | 3093.0 |
| 2021-11-24 | BTC | Futures | 76214.6 | 76358.7 | 73757.5 | 75762.5 | 7005.0 |
| 2021-11-24 | BZ | Futures | 54.87 | 55.41 | 54.5 | 54.91 | 30734.0 |
| 2021-11-24 | C | Futures | 1471.0 | 1477.0 | 1451.0 | 1454.0 | 1676.0 |
| 2021-11-24 | CB | Futures | 157.934 | 157.934 | 157.778 | 157.778 | 14.0 |
| 2021-11-24 | CC | Futures | 1616.0 | 1618.0 | 1570.0 | 1580.0 | 20451.0 |
| 2021-11-24 | CNH | Futures | 6.1295 | 6.1351 | 6.125 | 6.1335 | 362.0 |
| 2021-11-24 | CT | Futures | 112.34 | 112.9 | 111.84 | 112.45 | 8143.0 |
| 2021-11-24 | DC | Futures | 23.64 | 23.64 | 23.64 | 23.64 | 10.0 |
| 2021-11-24 | DX | Futures | 93.274 | 93.665 | 93.182 | 93.6 | 14110.0 |
| 2021-11-24 | E1 | Futures | 1.20063 | 1.20119 | 1.19536 | 1.1994 | 26978.0 |
| 2021-11-24 | E6 | Futures | 1.19555 | 1.19624 | 1.18891 | 1.19018 | 205974.0 |
| 2021-11-24 | E7 | Futures | 1.1891 | 1.1897 | 1.1825 | 1.1837 | 6837.0 |
| 2021-11-24 | EBM | Futures | 459.61 | 460.72 | 448.22 | 450.06 | 20082.0 |
| 2021-11-24 | ED | Futures | 96.4981 | 96.5054 | 96.4957 | 96.503 | 211133.0 |
| 2021-11-24 | ER | Futures | 98.504 | 98.514 | 98.499 | 98.514 | 86392.0 |
| 2021-11-24 | ESG | Futures | 442.45 | 444.21 | 440.32 | 444.12 | 321.0 |
| 2021-11-24 | EW | Futures | 3089.5 | 3091.6 | 3058.6 | 3085.9 | 11053.0 |
| 2021-11-24 | FBON | Futures | 148.54 | 148.8 | 147.9 | 148.15 | 299.0 |
| 2021-11-24 | FBTP | Futures | 137.36 | 137.64 | 136.26 | 136.72 | 149013.0 |
| 2021-11-24 | FBTS | Futures | 110.361 | 110.409 | 110.303 | 110.342 | 51015.0 |
| 2021-11-24 | FCE | Futures | 7155.6 | 7167.2 | 7059.4 | 7119.7 | 62555.0 |
| 2021-11-24 | FDAX | Futures | 17096.2 | 17127.2 | 16818.3 | 16989.3 | 92993.0 |
| 2021-11-24 | FDIV | Futures | 185.98 | 185.98 | 183.82 | 185.1 | 230.0 |
| 2021-11-24 | FDXM | Futures | 17142.7 | 17177.0 | 16866.1 | 17037.6 | 51319.0 |
| 2021-11-24 | FDXS | Futures | 16998.4 | 17017.5 | 16711.7 | 16879.5 | 32653.0 |
| 2021-11-24 | FESX | Futures | 4120.2 | 4122.1 | 4057.0 | 4095.8 | 727099.0 |
| 2021-11-24 | FGBL | Futures | 168.22 | 168.65 | 167.79 | 168.02 | 793129.0 |
| 2021-11-24 | FGBM | Futures | 134.8 | 135.0 | 134.73 | 134.76 | 429693.0 |
| 2021-11-24 | FGBS | Futures | 112.845 | 112.9 | 112.835 | 112.845 | 301377.0 |
| 2021-11-24 | FGBX | Futures | 228.27 | 229.26 | 226.39 | 227.36 | 105999.0 |
| 2021-11-24 | FMWO | Futures | 11369.9 | 11387.6 | 11283.8 | 11361.6 | 4347.0 |
| 2021-11-24 | FOAT | Futures | 155.41 | 155.81 | 154.94 | 155.2 | 169851.0 |
| 2021-11-24 | FTDX | Futures | 3950.3 | 3952.4 | 3875.4 | 3927.7 | 313.0 |
| 2021-11-24 | FTI | Futures | 770.55 | 771.26 | 758.62 | 765.96 | 21739.0 |
| 2021-11-24 | FTUK | Futures | 7190.5 | 7208.7 | 7145.5 | 7193.4 | 79870.0 |
| 2021-11-24 | FVSA | Futures | 66.8 | 68.54 | 64.27 | 65.69 | 36022.0 |
| 2021-11-24 | FXXP | Futures | 455.9 | 459.3 | 454.2 | 457.6 | 83837.0 |
| 2021-11-24 | G | Futures | 121.09 | 121.13 | 120.43 | 120.66 | 525371.0 |
> showing 50 of 123 rows — these rows as CSV