PREVIEW / futures_daily / 2021-12-14
file: by_date/futures_daily/2021/2021-12-14.parquet size: 10 KB rows: 124
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-12-14 | ES | Futures | 5251.84 | 5267.32 | 5176.66 | 5212.42 | 2297097.0 |
| 2021-12-14 | NQ | Futures | 18544.88 | 18596.47 | 18136.82 | 18353.82 | 689272.0 |
| 2021-12-14 | YM | Futures | 38814.2 | 38925.5 | 38544.8 | 38670.2 | 208243.0 |
| 2021-12-14 | CL | Futures | 53.62 | 54.29 | 52.42 | 53.32 | 177565.0 |
| 2021-12-14 | GC | Futures | 2085.5 | 2088.1 | 2060.4 | 2067.7 | 153249.0 |
| 2021-12-14 | ZN | Futures | 133.768151 | 133.800096 | 133.368843 | 133.544539 | 1006248.0 |
| 2021-12-14 | A6 | Futures | 0.73091 | 0.73143 | 0.72676 | 0.72835 | 68775.0 |
| 2021-12-14 | AD | Futures | 0.79217 | 0.79283 | 0.78862 | 0.78923 | 71157.0 |
| 2021-12-14 | ALI | Futures | 2929.18 | 2929.18 | 2920.24 | 2922.47 | 5.0 |
| 2021-12-14 | B | Futures | 51.62 | 52.13 | 50.34 | 51.12 | 277860.0 |
| 2021-12-14 | B6 | Futures | 1.3406 | 1.3446 | 1.3379 | 1.3408 | 77593.0 |
| 2021-12-14 | BR | Futures | 0.14282 | 0.14443 | 0.14261 | 0.14277 | 115.0 |
| 2021-12-14 | BTC | Futures | 61524.7 | 63817.9 | 60666.3 | 62730.3 | 5871.0 |
| 2021-12-14 | BZ | Futures | 49.6 | 50.17 | 48.45 | 49.2 | 31237.0 |
| 2021-12-14 | C | Futures | 1364.0 | 1375.0 | 1354.0 | 1364.0 | 6937.0 |
| 2021-12-14 | CB | Futures | 164.059 | 164.059 | 164.059 | 164.059 | 29.0 |
| 2021-12-14 | CC | Futures | 1596.0 | 1603.0 | 1569.0 | 1575.0 | 19014.0 |
| 2021-12-14 | CNH | Futures | 6.0955 | 6.0968 | 6.0734 | 6.0968 | 1178.0 |
| 2021-12-14 | CSC | Futures | 2.582 | 2.591 | 2.582 | 2.586 | 54.0 |
| 2021-12-14 | CT | Futures | 103.65 | 103.96 | 102.6 | 102.86 | 8779.0 |
| 2021-12-14 | DC | Futures | 24.74 | 24.85 | 24.65 | 24.72 | 175.0 |
| 2021-12-14 | DX | Futures | 93.126 | 93.31 | 92.841 | 93.293 | 13313.0 |
| 2021-12-14 | E1 | Futures | 1.21238 | 1.2183 | 1.21082 | 1.21105 | 16138.0 |
| 2021-12-14 | E6 | Futures | 1.19831 | 1.20276 | 1.19529 | 1.19561 | 133075.0 |
| 2021-12-14 | E7 | Futures | 1.1917 | 1.196 | 1.1885 | 1.189 | 5086.0 |
| 2021-12-14 | EBM | Futures | 406.95 | 408.73 | 401.22 | 406.95 | 25668.0 |
| 2021-12-14 | ED | Futures | 96.5446 | 96.5495 | 96.5301 | 96.5398 | 171987.0 |
| 2021-12-14 | ER | Futures | 98.514 | 98.519 | 98.509 | 98.514 | 30197.0 |
| 2021-12-14 | ESG | Futures | 438.82 | 438.82 | 431.25 | 434.51 | 2447.0 |
| 2021-12-14 | EW | Futures | 2969.5 | 2980.6 | 2937.0 | 2948.3 | 17336.0 |
| 2021-12-14 | FBON | Futures | 151.03 | 151.04 | 150.64 | 150.73 | 172.0 |
| 2021-12-14 | FBTP | Futures | 138.43 | 138.67 | 137.98 | 138.17 | 94002.0 |
| 2021-12-14 | FBTS | Futures | 110.536 | 110.546 | 110.371 | 110.41 | 74181.0 |
| 2021-12-14 | FCE | Futures | 7001.0 | 7043.8 | 6929.3 | 6944.0 | 41979.0 |
| 2021-12-14 | FDAX | Futures | 16701.8 | 16777.7 | 16488.0 | 16545.7 | 98805.0 |
| 2021-12-14 | FDIV | Futures | 184.36 | 184.36 | 183.52 | 183.52 | 114.0 |
| 2021-12-14 | FDXM | Futures | 16857.0 | 16900.1 | 16610.2 | 16667.3 | 6469.0 |
| 2021-12-14 | FDXS | Futures | 16608.7 | 16740.0 | 16460.2 | 16515.8 | 252.0 |
| 2021-12-14 | FESX | Futures | 4014.4 | 4031.7 | 3957.6 | 3974.0 | 1386400.0 |
| 2021-12-14 | FGBL | Futures | 170.16 | 170.27 | 169.71 | 169.98 | 394657.0 |
| 2021-12-14 | FGBM | Futures | 135.1 | 135.14 | 134.93 | 135.05 | 238587.0 |
| 2021-12-14 | FGBS | Futures | 112.8 | 112.815 | 112.744 | 112.769 | 207353.0 |
| 2021-12-14 | FGBX | Futures | 235.49 | 235.75 | 234.08 | 235.03 | 37044.0 |
| 2021-12-14 | FMWO | Futures | 11246.1 | 11287.4 | 11110.5 | 11144.7 | 23581.0 |
| 2021-12-14 | FOAT | Futures | 157.54 | 157.67 | 157.18 | 157.42 | 89765.0 |
| 2021-12-14 | FSMX | Futures | 36127.5 | 36127.5 | 35774.0 | 35838.0 | 588.0 |
| 2021-12-14 | FTDX | Futures | 3961.6 | 3961.6 | 3908.9 | 3908.9 | 1937.0 |
| 2021-12-14 | FTI | Futures | 754.98 | 755.8 | 742.22 | 743.98 | 13968.0 |
| 2021-12-14 | FTUK | Futures | 7159.3 | 7187.2 | 7109.0 | 7126.5 | 301953.0 |
| 2021-12-14 | FVSA | Futures | 73.1 | 78.56 | 72.63 | 77.0 | 25553.0 |
> showing 50 of 124 rows — these rows as CSV