PREVIEW / futures_daily / 2020-08-06
file: by_date/futures_daily/2020/2020-08-06.parquet size: 10 KB rows: 119
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-06 | ES | Futures | 3733.57 | 3765.65 | 3715.0 | 3764.24 | 1346665.0 |
| 2020-08-06 | NQ | Futures | 12876.13 | 13082.44 | 12826.52 | 13070.25 | 420437.0 |
| 2020-08-06 | YM | Futures | 29007.5 | 29258.2 | 28854.2 | 29241.1 | 177413.0 |
| 2020-08-06 | CL | Futures | 30.79 | 31.12 | 30.36 | 30.61 | 359610.0 |
| 2020-08-06 | GC | Futures | 2427.0 | 2458.6 | 2419.9 | 2444.0 | 312758.0 |
| 2020-08-06 | ZN | Futures | 138.775464 | 139.147101 | 138.744494 | 138.899343 | 883198.0 |
| 2020-08-06 | A6 | Futures | 0.74003 | 0.74487 | 0.73808 | 0.74425 | 106293.0 |
| 2020-08-06 | AD | Futures | 0.7651 | 0.76642 | 0.76185 | 0.76393 | 65972.0 |
| 2020-08-06 | ALI | Futures | 2180.56 | 2186.32 | 2161.13 | 2181.16 | 495.0 |
| 2020-08-06 | B | Futures | 29.22 | 29.47 | 28.91 | 29.07 | 184521.0 |
| 2020-08-06 | B6 | Futures | 1.3324 | 1.3392 | 1.3319 | 1.3356 | 111822.0 |
| 2020-08-06 | BR | Futures | 0.14896 | 0.14928 | 0.14734 | 0.14793 | 3534.0 |
| 2020-08-06 | BTC | Futures | 16321.1 | 16533.1 | 16013.3 | 16471.6 | 4902.0 |
| 2020-08-06 | BZ | Futures | 28.48 | 28.78 | 28.23 | 28.39 | 23131.0 |
| 2020-08-06 | C | Futures | 1523.0 | 1533.0 | 1515.0 | 1533.0 | 4951.0 |
| 2020-08-06 | CB | Futures | 176.611 | 176.611 | 172.278 | 172.278 | 27.0 |
| 2020-08-06 | CC | Futures | 1625.0 | 1653.0 | 1621.0 | 1638.0 | 31655.0 |
| 2020-08-06 | CNH | Futures | 6.8534 | 6.8652 | 6.8456 | 6.8594 | 1051.0 |
| 2020-08-06 | CSC | Futures | 3.546 | 3.599 | 3.488 | 3.537 | 80.0 |
| 2020-08-06 | CT | Futures | 65.31 | 65.31 | 64.9 | 65.14 | 15.0 |
| 2020-08-06 | DC | Futures | 28.99 | 29.57 | 28.28 | 28.84 | 671.0 |
| 2020-08-06 | DX | Futures | 89.619 | 89.914 | 89.325 | 89.608 | 24332.0 |
| 2020-08-06 | E1 | Futures | 1.25181 | 1.25408 | 1.24534 | 1.24908 | 26462.0 |
| 2020-08-06 | E6 | Futures | 1.2741 | 1.27968 | 1.269 | 1.27517 | 233843.0 |
| 2020-08-06 | E7 | Futures | 1.2678 | 1.2732 | 1.2627 | 1.2688 | 10067.0 |
| 2020-08-06 | EBM | Futures | 214.06 | 216.16 | 214.06 | 214.66 | 10454.0 |
| 2020-08-06 | ED | Futures | 96.462 | 96.4668 | 96.4523 | 96.4572 | 71899.0 |
| 2020-08-06 | ER | Futures | 98.382 | 98.391 | 98.382 | 98.386 | 65817.0 |
| 2020-08-06 | EW | Futures | 2037.8 | 2047.8 | 2025.8 | 2033.1 | 11444.0 |
| 2020-08-06 | FBON | Futures | 146.55 | 147.41 | 146.55 | 147.29 | 134.0 |
| 2020-08-06 | FBTP | Futures | 133.26 | 133.89 | 133.23 | 133.78 | 73857.0 |
| 2020-08-06 | FBTS | Futures | 108.861 | 108.909 | 108.832 | 108.9 | 34485.0 |
| 2020-08-06 | FCE | Futures | 4740.7 | 4785.1 | 4693.8 | 4718.4 | 62974.0 |
| 2020-08-06 | FDAX | Futures | 13404.1 | 13594.3 | 13289.9 | 13388.7 | 79768.0 |
| 2020-08-06 | FDXM | Futures | 13368.5 | 13545.2 | 13242.5 | 13340.4 | 50399.0 |
| 2020-08-06 | FESX | Futures | 3001.9 | 3030.6 | 2970.5 | 2989.0 | 680977.0 |
| 2020-08-06 | FEU3 | Futures | 99.129 | 99.134 | 99.129 | 99.134 | 75.0 |
| 2020-08-06 | FGBL | Futures | 169.13 | 169.89 | 169.04 | 169.69 | 547056.0 |
| 2020-08-06 | FGBM | Futures | 134.97 | 135.19 | 134.88 | 135.11 | 349545.0 |
| 2020-08-06 | FGBS | Futures | 112.78 | 112.815 | 112.759 | 112.79 | 266698.0 |
| 2020-08-06 | FGBX | Futures | 230.99 | 232.97 | 230.09 | 232.23 | 43106.0 |
| 2020-08-06 | FMWO | Futures | 8238.8 | 8290.9 | 8206.8 | 8235.2 | 1349.0 |
| 2020-08-06 | FOAT | Futures | 156.59 | 157.16 | 156.47 | 156.99 | 211979.0 |
| 2020-08-06 | FTDX | Futures | 3085.8 | 3099.1 | 3058.8 | 3064.4 | 8.0 |
| 2020-08-06 | FTI | Futures | 521.14 | 525.58 | 518.81 | 520.24 | 23519.0 |
| 2020-08-06 | FTUK | Futures | 5700.1 | 5735.1 | 5622.1 | 5672.2 | 97046.0 |
| 2020-08-06 | FVSA | Futures | 213.56 | 226.68 | 210.84 | 224.42 | 21757.0 |
| 2020-08-06 | FXXP | Futures | 335.0 | 337.4 | 332.4 | 333.8 | 41504.0 |
| 2020-08-06 | G | Futures | 127.48 | 128.13 | 127.45 | 128.01 | 224548.0 |
| 2020-08-06 | GF | Futures | 281.273 | 282.969 | 277.59 | 278.123 | 2080.0 |
> showing 50 of 119 rows — these rows as CSV