PREVIEW / futures_daily / 2021-11-15
file: by_date/futures_daily/2021/2021-11-15.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-15 | ES | Futures | 5269.84 | 5284.18 | 5249.87 | 5263.37 | 1047123.0 |
| 2021-11-15 | NQ | Futures | 18695.08 | 18769.17 | 18545.17 | 18666.83 | 483873.0 |
| 2021-11-15 | YM | Futures | 39233.4 | 39362.8 | 39114.8 | 39179.0 | 124976.0 |
| 2021-11-15 | CL | Futures | 59.86 | 60.2 | 58.88 | 59.98 | 185737.0 |
| 2021-11-15 | GC | Futures | 2184.7 | 2185.1 | 2168.2 | 2177.7 | 221208.0 |
| 2021-11-15 | ZN | Futures | 132.843886 | 133.082242 | 132.446626 | 132.510187 | 1183106.0 |
| 2021-11-15 | A6 | Futures | 0.75152 | 0.75567 | 0.75075 | 0.75362 | 64724.0 |
| 2021-11-15 | AD | Futures | 0.80877 | 0.81207 | 0.80851 | 0.81141 | 54460.0 |
| 2021-11-15 | ALI | Futures | 2973.61 | 2973.61 | 2954.89 | 2956.29 | 67.0 |
| 2021-11-15 | B | Futures | 56.0 | 56.39 | 55.15 | 56.09 | 273717.0 |
| 2021-11-15 | B6 | Futures | 1.362 | 1.3653 | 1.3605 | 1.3631 | 69416.0 |
| 2021-11-15 | BR | Futures | 0.14877 | 0.14898 | 0.14731 | 0.14865 | 9784.0 |
| 2021-11-15 | BTC | Futures | 85133.0 | 87675.4 | 83539.0 | 84191.1 | 5438.0 |
| 2021-11-15 | BZ | Futures | 54.69 | 55.07 | 53.86 | 54.77 | 32804.0 |
| 2021-11-15 | C | Futures | 1447.0 | 1463.0 | 1447.0 | 1453.0 | 2301.0 |
| 2021-11-15 | CB | Futures | 152.28 | 153.068 | 152.28 | 153.068 | 8.0 |
| 2021-11-15 | CC | Futures | 1592.0 | 1609.0 | 1586.0 | 1593.0 | 17178.0 |
| 2021-11-15 | CNH | Futures | 6.1169 | 6.1239 | 6.1156 | 6.1239 | 528.0 |
| 2021-11-15 | CSC | Futures | 2.354 | 2.372 | 2.354 | 2.358 | 189.0 |
| 2021-11-15 | CT | Futures | 109.81 | 110.31 | 108.73 | 109.78 | 9018.0 |
| 2021-11-15 | DC | Futures | 22.57 | 22.78 | 22.45 | 22.55 | 603.0 |
| 2021-11-15 | DX | Futures | 91.888 | 92.366 | 91.757 | 92.182 | 17867.0 |
| 2021-11-15 | E1 | Futures | 1.21664 | 1.21989 | 1.21071 | 1.21216 | 21505.0 |
| 2021-11-15 | E6 | Futures | 1.21653 | 1.2186 | 1.20718 | 1.21026 | 165611.0 |
| 2021-11-15 | E7 | Futures | 1.21 | 1.2119 | 1.2005 | 1.2036 | 4245.0 |
| 2021-11-15 | EBM | Futures | 436.47 | 436.47 | 430.59 | 433.16 | 32295.0 |
| 2021-11-15 | ED | Futures | 96.5223 | 96.5247 | 96.5199 | 96.5223 | 196772.0 |
| 2021-11-15 | ER | Futures | 98.494 | 98.499 | 98.494 | 98.494 | 38885.0 |
| 2021-11-15 | ESG | Futures | 440.78 | 442.12 | 438.78 | 439.93 | 771.0 |
| 2021-11-15 | EW | Futures | 3125.2 | 3136.3 | 3118.2 | 3125.9 | 9978.0 |
| 2021-11-15 | FBON | Futures | 149.03 | 149.66 | 148.59 | 148.87 | 718.0 |
| 2021-11-15 | FBTP | Futures | 138.24 | 138.76 | 137.54 | 137.85 | 119431.0 |
| 2021-11-15 | FBTS | Futures | 110.332 | 110.4 | 110.244 | 110.303 | 50820.0 |
| 2021-11-15 | FCE | Futures | 7158.6 | 7210.2 | 7158.1 | 7202.1 | 15510.0 |
| 2021-11-15 | FDAX | Futures | 17208.4 | 17257.6 | 17168.9 | 17242.6 | 45763.0 |
| 2021-11-15 | FDXM | Futures | 17256.3 | 17308.8 | 17218.8 | 17291.7 | 30351.0 |
| 2021-11-15 | FDXS | Futures | 17100.3 | 17144.9 | 17058.9 | 17131.1 | 12662.0 |
| 2021-11-15 | FESX | Futures | 4183.4 | 4194.0 | 4172.9 | 4187.7 | 429399.0 |
| 2021-11-15 | FGBL | Futures | 168.48 | 168.87 | 167.9 | 168.23 | 628905.0 |
| 2021-11-15 | FGBM | Futures | 134.86 | 135.03 | 134.49 | 134.69 | 427527.0 |
| 2021-11-15 | FGBS | Futures | 112.805 | 112.835 | 112.689 | 112.759 | 365363.0 |
| 2021-11-15 | FGBX | Futures | 230.08 | 231.55 | 228.33 | 229.19 | 77251.0 |
| 2021-11-15 | FMWO | Futures | 11473.7 | 11509.0 | 11445.4 | 11478.4 | 5920.0 |
| 2021-11-15 | FOAT | Futures | 155.89 | 156.22 | 155.36 | 155.63 | 127924.0 |
| 2021-11-15 | FTDX | Futures | 3996.5 | 3996.5 | 3980.1 | 3994.4 | 5.0 |
| 2021-11-15 | FTI | Futures | 781.0 | 786.43 | 779.85 | 785.02 | 4967.0 |
| 2021-11-15 | FTUK | Futures | 7246.8 | 7261.6 | 7227.5 | 7240.8 | 70199.0 |
| 2021-11-15 | FVSA | Futures | 60.63 | 61.9 | 59.68 | 61.26 | 28400.0 |
| 2021-11-15 | FXXP | Futures | 463.6 | 465.6 | 462.8 | 465.0 | 43311.0 |
| 2021-11-15 | G | Futures | 121.88 | 122.03 | 121.07 | 121.27 | 188740.0 |
> showing 50 of 123 rows — these rows as CSV