PREVIEW / futures_daily / 2016-10-31
file: by_date/futures_daily/2016/2016-10-31.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-31 | ES | Futures | 2292.98 | 2304.34 | 2287.31 | 2292.98 | 1371713.0 |
| 2016-10-31 | NQ | Futures | 5651.43 | 5692.39 | 5643.18 | 5653.2 | 199169.0 |
| 2016-10-31 | YM | Futures | 18969.1 | 19055.2 | 18934.5 | 18966.0 | 133450.0 |
| 2016-10-31 | CL | Futures | 52.65 | 53.19 | 50.88 | 51.13 | 649237.0 |
| 2016-10-31 | GC | Futures | 1640.1 | 1642.9 | 1631.9 | 1633.4 | 123697.0 |
| 2016-10-31 | ZN | Futures | 126.070868 | 126.19247 | 125.964467 | 126.101269 | 1087201.0 |
| 2016-10-31 | A6 | Futures | 0.77377 | 0.77652 | 0.77285 | 0.77469 | 59098.0 |
| 2016-10-31 | AD | Futures | 0.76423 | 0.76608 | 0.76326 | 0.76336 | 57141.0 |
| 2016-10-31 | ALI | Futures | 2308.6 | 2308.6 | 2308.6 | 2308.6 | 0.0 |
| 2016-10-31 | B | Futures | 38.24 | 38.56 | 36.8 | 36.92 | 356579.0 |
| 2016-10-31 | B6 | Futures | 1.2841 | 1.2908 | 1.2796 | 1.2901 | 106674.0 |
| 2016-10-31 | BR | Futures | 0.21246 | 0.21448 | 0.21246 | 0.21318 | 3256.0 |
| 2016-10-31 | BZ | Futures | 38.09 | 38.36 | 36.63 | 36.75 | 40803.0 |
| 2016-10-31 | C | Futures | 2431.0 | 2435.0 | 2401.0 | 2413.0 | 8836.0 |
| 2016-10-31 | CB | Futures | 241.788 | 242.098 | 237.448 | 237.479 | 65.0 |
| 2016-10-31 | CC | Futures | 2040.0 | 2049.0 | 1991.0 | 2023.0 | 15825.0 |
| 2016-10-31 | CNH | Futures | 7.3046 | 7.3123 | 7.2788 | 7.3045 | 9.0 |
| 2016-10-31 | CSC | Futures | 3.76 | 3.866 | 3.76 | 3.854 | 86.0 |
| 2016-10-31 | CT | Futures | 79.23 | 79.37 | 77.01 | 77.14 | 21266.0 |
| 2016-10-31 | DC | Futures | 29.7 | 30.51 | 29.63 | 30.37 | 419.0 |
| 2016-10-31 | DX | Futures | 91.476 | 91.839 | 91.467 | 91.603 | 13523.0 |
| 2016-10-31 | E1 | Futures | 1.26512 | 1.26525 | 1.26076 | 1.26113 | 19558.0 |
| 2016-10-31 | E6 | Futures | 1.2755 | 1.27707 | 1.27029 | 1.27365 | 122256.0 |
| 2016-10-31 | E7 | Futures | 1.2688 | 1.2694 | 1.2633 | 1.2667 | 1449.0 |
| 2016-10-31 | EBM | Futures | 193.29 | 195.65 | 192.7 | 195.06 | 13880.0 |
| 2016-10-31 | ED | Futures | 95.6249 | 95.6393 | 95.6249 | 95.6297 | 199865.0 |
| 2016-10-31 | ER | Futures | 98.274 | 98.279 | 98.274 | 98.274 | 32971.0 |
| 2016-10-31 | EW | Futures | 1592.4 | 1607.1 | 1588.9 | 1603.3 | 20830.0 |
| 2016-10-31 | FBON | Futures | 123.35 | 123.66 | 123.16 | 123.36 | 501.0 |
| 2016-10-31 | FBTP | Futures | 106.85 | 106.89 | 106.38 | 106.59 | 125727.0 |
| 2016-10-31 | FBTS | Futures | 100.961 | 100.996 | 100.916 | 100.943 | 23768.0 |
| 2016-10-31 | FCE | Futures | 4026.3 | 4029.9 | 4005.0 | 4013.4 | 67036.0 |
| 2016-10-31 | FDAX | Futures | 11286.0 | 11295.6 | 11230.6 | 11282.9 | 74430.0 |
| 2016-10-31 | FDXM | Futures | 11255.3 | 11271.2 | 11205.8 | 11258.5 | 16693.0 |
| 2016-10-31 | FESX | Futures | 2452.6 | 2455.8 | 2436.6 | 2445.4 | 826958.0 |
| 2016-10-31 | FGBL | Futures | 147.99 | 148.21 | 147.87 | 148.07 | 666426.0 |
| 2016-10-31 | FGBM | Futures | 128.27 | 128.33 | 128.25 | 128.31 | 481006.0 |
| 2016-10-31 | FGBS | Futures | 111.818 | 111.837 | 111.818 | 111.827 | 238877.0 |
| 2016-10-31 | FGBX | Futures | 176.03 | 177.36 | 175.64 | 176.6 | 52846.0 |
| 2016-10-31 | FMWO | Futures | 5657.8 | 5657.8 | 5634.8 | 5654.2 | 296.0 |
| 2016-10-31 | FOAT | Futures | 135.55 | 135.64 | 135.38 | 135.53 | 135817.0 |
| 2016-10-31 | FTDX | Futures | 1690.6 | 1694.5 | 1683.8 | 1689.6 | 134.0 |
| 2016-10-31 | FTI | Futures | 415.23 | 416.19 | 413.76 | 414.91 | 18326.0 |
| 2016-10-31 | FTUK | Futures | 5847.4 | 5874.0 | 5826.3 | 5849.1 | 99599.0 |
| 2016-10-31 | FVSA | Futures | 1338.76 | 1385.14 | 1338.76 | 1369.68 | 17615.0 |
| 2016-10-31 | FXXP | Futures | 279.4 | 280.1 | 278.6 | 279.4 | 18029.0 |
| 2016-10-31 | G | Futures | 111.56 | 111.96 | 111.49 | 111.79 | 182454.0 |
| 2016-10-31 | GF | Futures | 261.943 | 264.037 | 259.42 | 261.675 | 2160.0 |
| 2016-10-31 | GSCI | Futures | 511.57 | 512.54 | 500.0 | 500.83 | 390.0 |
| 2016-10-31 | HE | Futures | 71.879 | 73.913 | 71.495 | 73.606 | 22931.0 |
> showing 50 of 108 rows — these rows as CSV