PREVIEW / futures_daily / 2019-08-07
file: by_date/futures_daily/2019/2019-08-07.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 |
|---|---|---|---|---|---|---|---|
| 2019-08-07 | ES | Futures | 3100.94 | 3120.09 | 3046.45 | 3108.22 | 2680813.0 |
| 2019-08-07 | NQ | Futures | 8649.61 | 8724.16 | 8505.41 | 8696.24 | 851275.0 |
| 2019-08-07 | YM | Futures | 27192.5 | 27337.4 | 26662.3 | 27237.7 | 352239.0 |
| 2019-08-07 | CL | Futures | 54.51 | 54.87 | 51.55 | 52.13 | 1063214.0 |
| 2019-08-07 | GC | Futures | 1833.9 | 1878.3 | 1831.0 | 1874.5 | 651548.0 |
| 2019-08-07 | ZN | Futures | 129.415566 | 130.255422 | 129.120061 | 129.555542 | 2910174.0 |
| 2019-08-07 | A6 | Futures | 0.69617 | 0.69863 | 0.68773 | 0.69709 | 126028.0 |
| 2019-08-07 | AD | Futures | 0.75954 | 0.76015 | 0.75581 | 0.75753 | 100046.0 |
| 2019-08-07 | ALI | Futures | 2167.69 | 2167.69 | 2151.2 | 2153.03 | 114.0 |
| 2019-08-07 | B | Futures | 44.27 | 44.68 | 42.16 | 42.42 | 485190.0 |
| 2019-08-07 | B6 | Futures | 1.2441 | 1.2466 | 1.2394 | 1.2418 | 105890.0 |
| 2019-08-07 | BR | Futures | 0.20095 | 0.20203 | 0.19968 | 0.20039 | 9071.0 |
| 2019-08-07 | BTC | Futures | 15971.2 | 16976.3 | 15592.6 | 16363.6 | 5017.0 |
| 2019-08-07 | BZ | Futures | 43.61 | 44.08 | 41.61 | 41.87 | 52628.0 |
| 2019-08-07 | C | Futures | 1660.0 | 1672.0 | 1633.0 | 1636.0 | 11476.0 |
| 2019-08-07 | CB | Futures | 275.407 | 275.407 | 273.57 | 275.407 | 24.0 |
| 2019-08-07 | CC | Futures | 1509.0 | 1516.0 | 1485.0 | 1487.0 | 42249.0 |
| 2019-08-07 | CNH | Futures | 7.0707 | 7.1039 | 7.0636 | 7.0872 | 1056.0 |
| 2019-08-07 | CSC | Futures | 3.124 | 3.127 | 3.107 | 3.12 | 66.0 |
| 2019-08-07 | CT | Futures | 57.27 | 57.85 | 56.53 | 57.85 | 31.0 |
| 2019-08-07 | DC | Futures | 26.19 | 26.26 | 26.1 | 26.13 | 136.0 |
| 2019-08-07 | DX | Futures | 93.749 | 93.907 | 93.503 | 93.725 | 15774.0 |
| 2019-08-07 | E1 | Futures | 1.19252 | 1.20076 | 1.18788 | 1.19531 | 42054.0 |
| 2019-08-07 | E6 | Futures | 1.22582 | 1.23013 | 1.22314 | 1.22713 | 212715.0 |
| 2019-08-07 | E7 | Futures | 1.2193 | 1.2236 | 1.2168 | 1.2207 | 7072.0 |
| 2019-08-07 | EBM | Futures | 197.2 | 197.2 | 195.19 | 195.76 | 19323.0 |
| 2019-08-07 | ED | Futures | 95.4207 | 95.5132 | 95.4158 | 95.4596 | 509028.0 |
| 2019-08-07 | ER | Futures | 98.548 | 98.553 | 98.548 | 98.553 | 63544.0 |
| 2019-08-07 | EW | Futures | 1972.3 | 1988.2 | 1945.4 | 1982.8 | 15761.0 |
| 2019-08-07 | FBON | Futures | 145.47 | 146.3 | 145.38 | 146.02 | 277.0 |
| 2019-08-07 | FBTP | Futures | 126.2 | 127.29 | 125.96 | 127.08 | 100074.0 |
| 2019-08-07 | FBTS | Futures | 107.734 | 107.801 | 107.657 | 107.772 | 56969.0 |
| 2019-08-07 | FCE | Futures | 4780.9 | 4838.3 | 4758.6 | 4796.4 | 116151.0 |
| 2019-08-07 | FDAX | Futures | 12223.6 | 12358.4 | 12159.4 | 12246.2 | 149843.0 |
| 2019-08-07 | FDIV | Futures | 139.92 | 139.92 | 138.53 | 138.99 | 46.0 |
| 2019-08-07 | FDXM | Futures | 12064.2 | 12206.7 | 12010.1 | 12095.4 | 79886.0 |
| 2019-08-07 | FESX | Futures | 2875.4 | 2912.1 | 2860.6 | 2882.4 | 1610759.0 |
| 2019-08-07 | FGBL | Futures | 168.06 | 169.01 | 168.04 | 168.64 | 801718.0 |
| 2019-08-07 | FGBM | Futures | 135.37 | 135.71 | 135.36 | 135.65 | 473553.0 |
| 2019-08-07 | FGBS | Futures | 113.217 | 113.313 | 113.217 | 113.303 | 321464.0 |
| 2019-08-07 | FGBX | Futures | 223.63 | 227.54 | 223.5 | 225.36 | 123341.0 |
| 2019-08-07 | FMWO | Futures | 7063.7 | 7123.7 | 6995.6 | 7063.7 | 2939.0 |
| 2019-08-07 | FOAT | Futures | 154.75 | 155.63 | 154.69 | 155.2 | 135161.0 |
| 2019-08-07 | FTDX | Futures | 2739.2 | 2768.8 | 2718.0 | 2741.2 | 130.0 |
| 2019-08-07 | FTI | Futures | 510.19 | 515.17 | 505.54 | 510.16 | 43495.0 |
| 2019-08-07 | FTUK | Futures | 6565.5 | 6634.3 | 6538.7 | 6577.0 | 125837.0 |
| 2019-08-07 | FVSA | Futures | 229.39 | 244.85 | 218.88 | 237.43 | 73585.0 |
| 2019-08-07 | FXXP | Futures | 329.0 | 332.0 | 326.8 | 328.9 | 88717.0 |
| 2019-08-07 | G | Futures | 123.42 | 124.15 | 123.42 | 123.62 | 262022.0 |
| 2019-08-07 | GF | Futures | 274.539 | 277.679 | 272.822 | 273.853 | 1277.0 |
> showing 50 of 119 rows — these rows as CSV