PREVIEW / futures_daily / 2020-12-07
file: by_date/futures_daily/2020/2020-12-07.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-07 | ES | Futures | 4150.98 | 4162.5 | 4125.7 | 4146.49 | 1078372.0 |
| 2020-12-07 | NQ | Futures | 14500.3 | 14601.32 | 14442.13 | 14582.5 | 323774.0 |
| 2020-12-07 | YM | Futures | 32484.7 | 32582.7 | 32247.9 | 32358.7 | 131544.0 |
| 2020-12-07 | CL | Futures | 32.83 | 33.1 | 32.26 | 32.55 | 348871.0 |
| 2020-12-07 | GC | Futures | 2165.5 | 2203.0 | 2146.3 | 2194.8 | 209042.0 |
| 2020-12-07 | ZN | Futures | 136.684007 | 137.040439 | 136.66851 | 137.009445 | 9950.0 |
| 2020-12-07 | A6 | Futures | 0.76284 | 0.7652 | 0.75689 | 0.76264 | 85212.0 |
| 2020-12-07 | AD | Futures | 0.79257 | 0.79313 | 0.78968 | 0.79191 | 85209.0 |
| 2020-12-07 | ALI | Futures | 2395.1 | 2395.1 | 2385.97 | 2389.8 | 96.0 |
| 2020-12-07 | B | Futures | 31.11 | 31.24 | 30.59 | 30.83 | 207513.0 |
| 2020-12-07 | B6 | Futures | 1.3609 | 1.3627 | 1.3408 | 1.3589 | 254412.0 |
| 2020-12-07 | BR | Futures | 0.15266 | 0.15371 | 0.15137 | 0.1534 | 9.0 |
| 2020-12-07 | BTC | Futures | 25019.2 | 25553.3 | 24778.2 | 24973.6 | 5213.0 |
| 2020-12-07 | BZ | Futures | 30.43 | 30.55 | 29.91 | 30.16 | 23896.0 |
| 2020-12-07 | C | Futures | 1524.0 | 1533.0 | 1515.0 | 1530.0 | 1248.0 |
| 2020-12-07 | CB | Futures | 155.222 | 157.344 | 155.222 | 155.983 | 13.0 |
| 2020-12-07 | CC | Futures | 1718.0 | 1738.0 | 1702.0 | 1733.0 | 14714.0 |
| 2020-12-07 | CNH | Futures | 6.3775 | 6.3995 | 6.3775 | 6.3829 | 1883.0 |
| 2020-12-07 | CSC | Futures | 3.014 | 3.07 | 3.014 | 3.056 | 88.0 |
| 2020-12-07 | CT | Futures | 69.23 | 70.07 | 68.94 | 69.93 | 15209.0 |
| 2020-12-07 | DC | Futures | 25.43 | 25.96 | 25.32 | 25.85 | 201.0 |
| 2020-12-07 | DX | Futures | 87.705 | 88.135 | 87.526 | 87.699 | 35138.0 |
| 2020-12-07 | E1 | Futures | 1.26991 | 1.27613 | 1.26583 | 1.27217 | 23998.0 |
| 2020-12-07 | E6 | Futures | 1.29958 | 1.30344 | 1.29401 | 1.29835 | 254159.0 |
| 2020-12-07 | E7 | Futures | 1.2927 | 1.2968 | 1.2875 | 1.2918 | 6264.0 |
| 2020-12-07 | EBM | Futures | 247.13 | 248.37 | 245.28 | 248.06 | 31054.0 |
| 2020-12-07 | ED | Futures | 96.4914 | 96.4963 | 96.489 | 96.4914 | 128125.0 |
| 2020-12-07 | ER | Futures | 98.465 | 98.475 | 98.465 | 98.475 | 51358.0 |
| 2020-12-07 | ESG | Futures | 340.46 | 341.67 | 340.02 | 341.28 | 567.0 |
| 2020-12-07 | EW | Futures | 2399.2 | 2408.0 | 2380.0 | 2390.0 | 11055.0 |
| 2020-12-07 | FBON | Futures | 150.23 | 150.59 | 150.23 | 150.5 | 458.0 |
| 2020-12-07 | FBTP | Futures | 138.43 | 138.68 | 138.3 | 138.46 | 111358.0 |
| 2020-12-07 | FBTS | Futures | 110.01 | 110.029 | 109.961 | 110.01 | 50979.0 |
| 2020-12-07 | FCE | Futures | 5446.6 | 5457.4 | 5394.9 | 5434.0 | 45135.0 |
| 2020-12-07 | FDAX | Futures | 14167.3 | 14179.0 | 14024.4 | 14143.8 | 64021.0 |
| 2020-12-07 | FDIV | Futures | 158.34 | 158.39 | 158.34 | 158.39 | 50.0 |
| 2020-12-07 | FDXM | Futures | 14090.5 | 14104.3 | 13954.8 | 14072.5 | 36954.0 |
| 2020-12-07 | FESX | Futures | 3267.2 | 3270.9 | 3231.1 | 3259.8 | 651893.0 |
| 2020-12-07 | FEU3 | Futures | 99.203 | 99.208 | 99.203 | 99.208 | 100.0 |
| 2020-12-07 | FGBL | Futures | 170.01 | 170.49 | 169.93 | 170.4 | 543160.0 |
| 2020-12-07 | FGBM | Futures | 135.3 | 135.46 | 135.3 | 135.42 | 343050.0 |
| 2020-12-07 | FGBS | Futures | 112.785 | 112.83 | 112.785 | 112.82 | 356569.0 |
| 2020-12-07 | FGBX | Futures | 234.0 | 235.73 | 233.64 | 235.08 | 65051.0 |
| 2020-12-07 | FMWO | Futures | 9287.1 | 9298.9 | 9227.9 | 9297.7 | 2787.0 |
| 2020-12-07 | FOAT | Futures | 158.6 | 158.95 | 158.55 | 158.8 | 167459.0 |
| 2020-12-07 | FTDX | Futures | 3211.4 | 3213.4 | 3189.2 | 3213.4 | 51.0 |
| 2020-12-07 | FTI | Futures | 574.29 | 576.07 | 571.49 | 575.79 | 16719.0 |
| 2020-12-07 | FTUK | Futures | 6259.3 | 6299.9 | 6221.1 | 6260.3 | 102844.0 |
| 2020-12-07 | FVSA | Futures | 151.35 | 157.64 | 150.61 | 153.57 | 14707.0 |
| 2020-12-07 | FXXP | Futures | 364.3 | 364.8 | 361.6 | 364.1 | 67128.0 |
> showing 50 of 121 rows — these rows as CSV