PREVIEW / futures_daily / 2020-08-10
file: by_date/futures_daily/2020/2020-08-10.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-08-10 | ES | Futures | 3767.34 | 3778.88 | 3747.08 | 3773.81 | 1201751.0 |
| 2020-08-10 | NQ | Futures | 12929.81 | 12948.67 | 12683.76 | 12850.6 | 485730.0 |
| 2020-08-10 | YM | Futures | 29325.8 | 29699.8 | 29214.3 | 29663.3 | 169115.0 |
| 2020-08-10 | CL | Futures | 30.28 | 30.89 | 30.04 | 30.6 | 367796.0 |
| 2020-08-10 | GC | Futures | 2414.9 | 2433.8 | 2394.9 | 2408.9 | 251306.0 |
| 2020-08-10 | ZN | Futures | 138.682554 | 138.883858 | 138.57416 | 138.620615 | 678683.0 |
| 2020-08-10 | A6 | Futures | 0.73613 | 0.73911 | 0.73458 | 0.73571 | 61378.0 |
| 2020-08-10 | AD | Futures | 0.75865 | 0.76129 | 0.75784 | 0.76033 | 38707.0 |
| 2020-08-10 | ALI | Futures | 2155.06 | 2189.66 | 2142.92 | 2188.14 | 281.0 |
| 2020-08-10 | B | Futures | 28.79 | 29.18 | 28.6 | 29.0 | 135301.0 |
| 2020-08-10 | B6 | Futures | 1.3261 | 1.3308 | 1.3222 | 1.3272 | 73699.0 |
| 2020-08-10 | BR | Futures | 0.14659 | 0.14785 | 0.14421 | 0.14504 | 5989.0 |
| 2020-08-10 | BTC | Futures | 16143.2 | 16717.8 | 15931.2 | 16437.4 | 9860.0 |
| 2020-08-10 | BZ | Futures | 28.08 | 28.49 | 27.95 | 28.32 | 13672.0 |
| 2020-08-10 | C | Futures | 1553.0 | 1566.0 | 1543.0 | 1551.0 | 5835.0 |
| 2020-08-10 | CB | Futures | 171.208 | 172.252 | 171.182 | 171.182 | 71.0 |
| 2020-08-10 | CC | Futures | 1654.0 | 1665.0 | 1619.0 | 1634.0 | 31594.0 |
| 2020-08-10 | CNH | Futures | 6.8802 | 6.8862 | 6.8714 | 6.8716 | 637.0 |
| 2020-08-10 | CSC | Futures | 3.41 | 3.496 | 3.396 | 3.426 | 152.0 |
| 2020-08-10 | CT | Futures | 63.11 | 63.49 | 63.05 | 63.05 | 8.0 |
| 2020-08-10 | DC | Futures | 27.61 | 28.48 | 27.51 | 27.7 | 549.0 |
| 2020-08-10 | DX | Futures | 90.233 | 90.493 | 90.097 | 90.381 | 15751.0 |
| 2020-08-10 | E1 | Futures | 1.24613 | 1.24625 | 1.23773 | 1.24204 | 21539.0 |
| 2020-08-10 | E6 | Futures | 1.26562 | 1.26718 | 1.26021 | 1.26106 | 161515.0 |
| 2020-08-10 | E7 | Futures | 1.2594 | 1.2608 | 1.2538 | 1.2548 | 5717.0 |
| 2020-08-10 | EBM | Futures | 212.87 | 213.47 | 211.67 | 211.97 | 13042.0 |
| 2020-08-10 | ED | Futures | 96.4523 | 96.4523 | 96.4378 | 96.4378 | 126669.0 |
| 2020-08-10 | ER | Futures | 98.386 | 98.391 | 98.382 | 98.391 | 22924.0 |
| 2020-08-10 | ESG | Futures | 304.72 | 305.1 | 304.72 | 304.89 | 7.0 |
| 2020-08-10 | EW | Futures | 2054.6 | 2078.1 | 2053.0 | 2068.0 | 10474.0 |
| 2020-08-10 | FBON | Futures | 147.32 | 147.52 | 147.0 | 147.48 | 154.0 |
| 2020-08-10 | FBTP | Futures | 133.8 | 133.98 | 133.59 | 133.82 | 32992.0 |
| 2020-08-10 | FBTS | Futures | 108.948 | 108.977 | 108.89 | 108.938 | 30304.0 |
| 2020-08-10 | FCE | Futures | 4751.8 | 4770.6 | 4711.2 | 4742.6 | 47224.0 |
| 2020-08-10 | FDAX | Futures | 13476.4 | 13571.4 | 13379.1 | 13461.0 | 66762.0 |
| 2020-08-10 | FDIV | Futures | 144.08 | 145.4 | 144.08 | 145.4 | 55.0 |
| 2020-08-10 | FDXM | Futures | 13441.5 | 13520.9 | 13331.4 | 13412.4 | 35416.0 |
| 2020-08-10 | FESX | Futures | 3006.6 | 3022.3 | 2985.3 | 3003.8 | 471504.0 |
| 2020-08-10 | FEU3 | Futures | 99.129 | 99.139 | 99.129 | 99.139 | 225.0 |
| 2020-08-10 | FGBL | Futures | 169.27 | 169.73 | 169.01 | 169.59 | 366166.0 |
| 2020-08-10 | FGBM | Futures | 134.96 | 135.13 | 134.86 | 135.1 | 231467.0 |
| 2020-08-10 | FGBS | Futures | 112.749 | 112.8 | 112.739 | 112.795 | 169253.0 |
| 2020-08-10 | FGBX | Futures | 230.27 | 232.17 | 229.61 | 231.57 | 30328.0 |
| 2020-08-10 | FMWO | Futures | 8295.7 | 8300.4 | 8238.8 | 8266.0 | 1293.0 |
| 2020-08-10 | FOAT | Futures | 156.75 | 157.24 | 156.58 | 157.15 | 98327.0 |
| 2020-08-10 | FTDX | Futures | 3121.6 | 3121.6 | 3083.8 | 3087.9 | 11.0 |
| 2020-08-10 | FTI | Futures | 521.71 | 521.71 | 517.81 | 517.81 | 65.0 |
| 2020-08-10 | FTUK | Futures | 5690.7 | 5739.3 | 5667.5 | 5689.2 | 60311.0 |
| 2020-08-10 | FVSA | Futures | 216.27 | 224.87 | 214.46 | 217.63 | 9843.0 |
| 2020-08-10 | FXXP | Futures | 336.9 | 337.6 | 334.1 | 335.7 | 29345.0 |
> showing 50 of 121 rows — these rows as CSV