PREVIEW / futures_1hour / 2017-11-05
file: by_date/futures_1hour/2017/2017-11-05.parquet size: 15 KB rows: 291
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-11-05 18:00:00 | ES | Futures | 2823.12 | 2828.05 | 2823.12 | 2826.68 | 9483.0 |
| 2017-11-05 19:00:00 | ES | Futures | 2826.41 | 2827.23 | 2826.13 | 2826.68 | 4397.0 |
| 2017-11-05 20:00:00 | ES | Futures | 2826.95 | 2828.32 | 2823.67 | 2823.67 | 12326.0 |
| 2017-11-05 21:00:00 | ES | Futures | 2823.95 | 2823.95 | 2818.75 | 2819.84 | 17515.0 |
| 2017-11-05 22:00:00 | ES | Futures | 2819.84 | 2821.76 | 2818.2 | 2821.21 | 9054.0 |
| 2017-11-05 23:00:00 | ES | Futures | 2820.94 | 2821.76 | 2819.29 | 2821.48 | 5518.0 |
| 2017-11-05 18:00:00 | NQ | Futures | 7477.35 | 7492.22 | 7475.86 | 7488.35 | 2477.0 |
| 2017-11-05 19:00:00 | NQ | Futures | 7488.35 | 7489.84 | 7484.78 | 7486.86 | 1053.0 |
| 2017-11-05 20:00:00 | NQ | Futures | 7487.16 | 7493.41 | 7472.59 | 7473.48 | 3803.0 |
| 2017-11-05 21:00:00 | NQ | Futures | 7473.18 | 7473.48 | 7456.83 | 7462.77 | 4854.0 |
| 2017-11-05 22:00:00 | NQ | Futures | 7462.77 | 7471.1 | 7458.01 | 7470.8 | 2575.0 |
| 2017-11-05 23:00:00 | NQ | Futures | 7470.21 | 7471.4 | 7464.26 | 7470.51 | 1209.0 |
| 2017-11-05 18:00:00 | YM | Futures | 25499.7 | 25536.7 | 25493.1 | 25525.8 | 2128.0 |
| 2017-11-05 19:00:00 | YM | Futures | 25525.8 | 25530.1 | 25518.2 | 25525.8 | 900.0 |
| 2017-11-05 20:00:00 | YM | Futures | 25525.8 | 25542.1 | 25498.6 | 25500.8 | 2408.0 |
| 2017-11-05 21:00:00 | YM | Futures | 25500.8 | 25501.8 | 25461.6 | 25471.4 | 3186.0 |
| 2017-11-05 22:00:00 | YM | Futures | 25472.5 | 25492.1 | 25459.4 | 25488.8 | 2065.0 |
| 2017-11-05 23:00:00 | YM | Futures | 25488.8 | 25492.1 | 25470.3 | 25487.7 | 1314.0 |
| 2017-11-05 18:00:00 | CL | Futures | 49.84 | 49.86 | 49.68 | 49.71 | 8107.0 |
| 2017-11-05 19:00:00 | CL | Futures | 49.71 | 49.73 | 49.67 | 49.69 | 4253.0 |
| 2017-11-05 20:00:00 | CL | Futures | 49.68 | 49.76 | 49.67 | 49.71 | 4721.0 |
| 2017-11-05 21:00:00 | CL | Futures | 49.72 | 49.74 | 49.58 | 49.64 | 6406.0 |
| 2017-11-05 22:00:00 | CL | Futures | 49.65 | 49.69 | 49.62 | 49.68 | 2728.0 |
| 2017-11-05 23:00:00 | CL | Futures | 49.68 | 49.68 | 49.61 | 49.64 | 2224.0 |
| 2017-11-05 18:00:00 | GC | Futures | 1692.8 | 1693.7 | 1690.9 | 1693.2 | 3639.0 |
| 2017-11-05 19:00:00 | GC | Futures | 1693.2 | 1693.2 | 1689.6 | 1690.2 | 6367.0 |
| 2017-11-05 20:00:00 | GC | Futures | 1690.1 | 1690.5 | 1687.0 | 1690.2 | 13933.0 |
| 2017-11-05 21:00:00 | GC | Futures | 1690.2 | 1693.0 | 1690.2 | 1691.8 | 9990.0 |
| 2017-11-05 22:00:00 | GC | Futures | 1691.8 | 1692.4 | 1690.9 | 1691.7 | 4261.0 |
| 2017-11-05 23:00:00 | GC | Futures | 1691.7 | 1693.3 | 1691.2 | 1692.1 | 5159.0 |
| 2017-11-05 18:00:00 | ZN | Futures | 124.718624 | 124.734185 | 124.671942 | 124.671942 | 10497.0 |
| 2017-11-05 19:00:00 | ZN | Futures | 124.656382 | 124.703064 | 124.640821 | 124.656382 | 16007.0 |
| 2017-11-05 20:00:00 | ZN | Futures | 124.640821 | 124.656382 | 124.594139 | 124.656382 | 16486.0 |
| 2017-11-05 21:00:00 | ZN | Futures | 124.640821 | 124.734185 | 124.640821 | 124.703064 | 22244.0 |
| 2017-11-05 22:00:00 | ZN | Futures | 124.718624 | 124.734185 | 124.687503 | 124.703064 | 8527.0 |
| 2017-11-05 23:00:00 | ZN | Futures | 124.703064 | 124.749746 | 124.703064 | 124.734185 | 6680.0 |
> showing 36 of 291 rows — these rows as CSV