PREVIEW / futures_5min / 2017-05-24
file: by_date/futures_5min/2017/2017-05-24.parquet size: 231 KB rows: 15,519
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-05-24 00:00:00 | ES | Futures | 2617.8 | 2617.8 | 2617.53 | 2617.53 | 131.0 |
| 2017-05-24 00:05:00 | ES | Futures | 2617.53 | 2617.53 | 2616.98 | 2616.98 | 263.0 |
| 2017-05-24 00:10:00 | ES | Futures | 2616.98 | 2617.26 | 2616.98 | 2616.98 | 64.0 |
| 2017-05-24 00:15:00 | ES | Futures | 2617.26 | 2617.53 | 2616.98 | 2617.26 | 163.0 |
| 2017-05-24 00:20:00 | ES | Futures | 2617.26 | 2617.53 | 2617.26 | 2617.53 | 30.0 |
| 2017-05-24 00:25:00 | ES | Futures | 2617.53 | 2617.53 | 2617.26 | 2617.26 | 16.0 |
| 2017-05-24 00:30:00 | ES | Futures | 2617.53 | 2617.53 | 2617.26 | 2617.53 | 204.0 |
| 2017-05-24 00:35:00 | ES | Futures | 2617.53 | 2617.8 | 2617.26 | 2617.8 | 134.0 |
| 2017-05-24 00:40:00 | ES | Futures | 2617.8 | 2617.8 | 2617.26 | 2617.53 | 110.0 |
| 2017-05-24 00:45:00 | ES | Futures | 2617.53 | 2617.53 | 2617.26 | 2617.53 | 36.0 |
| 2017-05-24 00:50:00 | ES | Futures | 2617.26 | 2617.53 | 2617.26 | 2617.26 | 20.0 |
| 2017-05-24 00:55:00 | ES | Futures | 2617.26 | 2617.53 | 2617.26 | 2617.53 | 69.0 |
| 2017-05-24 01:00:00 | ES | Futures | 2617.53 | 2617.53 | 2617.26 | 2617.53 | 88.0 |
| 2017-05-24 01:05:00 | ES | Futures | 2617.53 | 2618.08 | 2617.53 | 2617.8 | 421.0 |
| 2017-05-24 01:10:00 | ES | Futures | 2617.8 | 2618.08 | 2617.8 | 2618.08 | 85.0 |
| 2017-05-24 01:15:00 | ES | Futures | 2618.08 | 2618.08 | 2617.8 | 2618.08 | 62.0 |
| 2017-05-24 01:20:00 | ES | Futures | 2617.8 | 2618.35 | 2617.8 | 2618.35 | 279.0 |
| 2017-05-24 01:25:00 | ES | Futures | 2618.08 | 2618.35 | 2618.08 | 2618.08 | 212.0 |
| 2017-05-24 01:30:00 | ES | Futures | 2618.08 | 2618.08 | 2617.8 | 2618.08 | 99.0 |
| 2017-05-24 01:35:00 | ES | Futures | 2618.08 | 2618.08 | 2617.8 | 2618.08 | 52.0 |
| 2017-05-24 01:40:00 | ES | Futures | 2617.8 | 2618.08 | 2617.8 | 2617.8 | 53.0 |
| 2017-05-24 01:45:00 | ES | Futures | 2618.08 | 2618.08 | 2617.8 | 2617.8 | 83.0 |
| 2017-05-24 01:50:00 | ES | Futures | 2618.08 | 2618.35 | 2617.8 | 2618.08 | 157.0 |
| 2017-05-24 01:55:00 | ES | Futures | 2618.08 | 2618.35 | 2618.08 | 2618.35 | 204.0 |
| 2017-05-24 02:00:00 | ES | Futures | 2618.08 | 2618.89 | 2617.8 | 2618.89 | 1130.0 |
| 2017-05-24 02:05:00 | ES | Futures | 2618.89 | 2618.89 | 2618.08 | 2618.08 | 1409.0 |
| 2017-05-24 02:10:00 | ES | Futures | 2618.35 | 2618.62 | 2617.8 | 2618.62 | 315.0 |
| 2017-05-24 02:15:00 | ES | Futures | 2618.35 | 2618.62 | 2618.08 | 2618.35 | 441.0 |
| 2017-05-24 02:20:00 | ES | Futures | 2618.35 | 2618.62 | 2618.35 | 2618.62 | 187.0 |
| 2017-05-24 02:25:00 | ES | Futures | 2618.62 | 2618.62 | 2617.8 | 2617.8 | 419.0 |
| 2017-05-24 02:30:00 | ES | Futures | 2617.8 | 2618.35 | 2617.53 | 2618.35 | 586.0 |
| 2017-05-24 02:35:00 | ES | Futures | 2618.08 | 2618.35 | 2618.08 | 2618.35 | 380.0 |
| 2017-05-24 02:40:00 | ES | Futures | 2618.35 | 2618.35 | 2618.08 | 2618.08 | 254.0 |
| 2017-05-24 02:45:00 | ES | Futures | 2618.35 | 2618.62 | 2618.08 | 2618.62 | 80.0 |
| 2017-05-24 02:50:00 | ES | Futures | 2618.62 | 2618.89 | 2618.62 | 2618.62 | 302.0 |
| 2017-05-24 02:55:00 | ES | Futures | 2618.62 | 2618.89 | 2618.62 | 2618.62 | 138.0 |
| 2017-05-24 03:00:00 | ES | Futures | 2618.62 | 2618.89 | 2616.98 | 2617.8 | 3623.0 |
| 2017-05-24 03:05:00 | ES | Futures | 2617.53 | 2618.62 | 2617.26 | 2618.35 | 1740.0 |
| 2017-05-24 03:10:00 | ES | Futures | 2618.08 | 2618.62 | 2617.53 | 2617.53 | 1273.0 |
| 2017-05-24 03:15:00 | ES | Futures | 2617.53 | 2618.89 | 2617.53 | 2618.62 | 969.0 |
| 2017-05-24 03:20:00 | ES | Futures | 2618.62 | 2619.71 | 2618.62 | 2619.44 | 1549.0 |
| 2017-05-24 03:25:00 | ES | Futures | 2619.44 | 2619.71 | 2618.35 | 2618.62 | 1615.0 |
| 2017-05-24 03:30:00 | ES | Futures | 2618.89 | 2618.89 | 2618.35 | 2618.62 | 842.0 |
| 2017-05-24 03:35:00 | ES | Futures | 2618.62 | 2619.99 | 2618.62 | 2619.71 | 1595.0 |
| 2017-05-24 03:40:00 | ES | Futures | 2619.44 | 2620.81 | 2619.44 | 2620.53 | 1355.0 |
| 2017-05-24 03:45:00 | ES | Futures | 2620.81 | 2621.35 | 2620.26 | 2620.26 | 2935.0 |
| 2017-05-24 03:50:00 | ES | Futures | 2620.26 | 2620.81 | 2619.71 | 2619.99 | 1150.0 |
| 2017-05-24 03:55:00 | ES | Futures | 2619.99 | 2621.08 | 2619.99 | 2620.81 | 1128.0 |
| 2017-05-24 04:00:00 | ES | Futures | 2620.81 | 2621.08 | 2619.99 | 2619.99 | 1174.0 |
| 2017-05-24 04:05:00 | ES | Futures | 2620.26 | 2621.08 | 2620.26 | 2620.26 | 1549.0 |
> showing 50 of 15,519 rows — these rows as CSV