PREVIEW / futures_5min / 2018-01-22
file: by_date/futures_5min/2018/2018-01-22.parquet size: 247 KB rows: 16,151
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-22 00:00:00 | ES | Futures | 3069.2 | 3069.75 | 3069.2 | 3069.2 | 210.0 |
| 2018-01-22 00:05:00 | ES | Futures | 3069.47 | 3069.47 | 3068.93 | 3069.2 | 263.0 |
| 2018-01-22 00:10:00 | ES | Futures | 3069.47 | 3069.47 | 3069.2 | 3069.47 | 255.0 |
| 2018-01-22 00:15:00 | ES | Futures | 3069.47 | 3069.75 | 3069.47 | 3069.75 | 250.0 |
| 2018-01-22 00:20:00 | ES | Futures | 3069.75 | 3069.75 | 3069.2 | 3069.47 | 156.0 |
| 2018-01-22 00:25:00 | ES | Futures | 3069.47 | 3069.47 | 3069.2 | 3069.2 | 81.0 |
| 2018-01-22 00:30:00 | ES | Futures | 3069.47 | 3070.02 | 3069.47 | 3069.75 | 169.0 |
| 2018-01-22 00:35:00 | ES | Futures | 3070.02 | 3070.02 | 3070.02 | 3070.02 | 180.0 |
| 2018-01-22 00:40:00 | ES | Futures | 3069.75 | 3069.75 | 3069.47 | 3069.75 | 734.0 |
| 2018-01-22 00:45:00 | ES | Futures | 3069.75 | 3069.75 | 3069.2 | 3069.2 | 180.0 |
| 2018-01-22 00:50:00 | ES | Futures | 3069.47 | 3069.75 | 3068.93 | 3068.93 | 494.0 |
| 2018-01-22 00:55:00 | ES | Futures | 3068.93 | 3069.75 | 3068.93 | 3069.75 | 355.0 |
| 2018-01-22 01:00:00 | ES | Futures | 3069.47 | 3070.29 | 3069.47 | 3069.75 | 418.0 |
| 2018-01-22 01:05:00 | ES | Futures | 3070.02 | 3070.02 | 3069.47 | 3069.75 | 230.0 |
| 2018-01-22 01:10:00 | ES | Futures | 3069.75 | 3070.02 | 3069.75 | 3069.75 | 224.0 |
| 2018-01-22 01:15:00 | ES | Futures | 3069.75 | 3069.75 | 3069.47 | 3069.75 | 159.0 |
| 2018-01-22 01:20:00 | ES | Futures | 3069.47 | 3069.75 | 3069.47 | 3069.75 | 93.0 |
| 2018-01-22 01:25:00 | ES | Futures | 3069.75 | 3069.75 | 3069.47 | 3069.47 | 46.0 |
| 2018-01-22 01:30:00 | ES | Futures | 3069.75 | 3069.75 | 3069.2 | 3069.47 | 167.0 |
| 2018-01-22 01:35:00 | ES | Futures | 3069.47 | 3069.47 | 3068.65 | 3068.93 | 290.0 |
| 2018-01-22 01:40:00 | ES | Futures | 3069.2 | 3069.2 | 3068.93 | 3068.93 | 103.0 |
| 2018-01-22 01:45:00 | ES | Futures | 3068.93 | 3069.47 | 3068.93 | 3069.47 | 45.0 |
| 2018-01-22 01:50:00 | ES | Futures | 3069.47 | 3069.47 | 3069.2 | 3069.47 | 186.0 |
| 2018-01-22 01:55:00 | ES | Futures | 3069.2 | 3069.47 | 3069.2 | 3069.2 | 72.0 |
| 2018-01-22 02:00:00 | ES | Futures | 3069.2 | 3069.75 | 3069.2 | 3069.47 | 526.0 |
| 2018-01-22 02:05:00 | ES | Futures | 3069.2 | 3070.02 | 3069.2 | 3069.75 | 209.0 |
| 2018-01-22 02:10:00 | ES | Futures | 3070.02 | 3070.02 | 3069.47 | 3069.47 | 251.0 |
| 2018-01-22 02:15:00 | ES | Futures | 3069.47 | 3069.75 | 3069.2 | 3069.75 | 161.0 |
| 2018-01-22 02:20:00 | ES | Futures | 3069.75 | 3069.75 | 3069.2 | 3069.47 | 313.0 |
| 2018-01-22 02:25:00 | ES | Futures | 3069.2 | 3069.47 | 3068.93 | 3069.2 | 326.0 |
| 2018-01-22 02:30:00 | ES | Futures | 3069.2 | 3069.2 | 3068.93 | 3069.2 | 342.0 |
| 2018-01-22 02:35:00 | ES | Futures | 3069.2 | 3069.2 | 3068.38 | 3068.93 | 345.0 |
| 2018-01-22 02:40:00 | ES | Futures | 3068.93 | 3068.93 | 3068.65 | 3068.65 | 208.0 |
| 2018-01-22 02:45:00 | ES | Futures | 3068.65 | 3068.93 | 3068.38 | 3068.38 | 334.0 |
| 2018-01-22 02:50:00 | ES | Futures | 3068.38 | 3068.38 | 3067.83 | 3068.11 | 382.0 |
| 2018-01-22 02:55:00 | ES | Futures | 3068.11 | 3068.38 | 3067.83 | 3068.38 | 363.0 |
| 2018-01-22 03:00:00 | ES | Futures | 3068.11 | 3068.93 | 3067.83 | 3068.65 | 1364.0 |
| 2018-01-22 03:05:00 | ES | Futures | 3068.93 | 3070.02 | 3068.11 | 3068.65 | 2812.0 |
| 2018-01-22 03:10:00 | ES | Futures | 3068.65 | 3069.47 | 3068.11 | 3069.2 | 1362.0 |
| 2018-01-22 03:15:00 | ES | Futures | 3069.47 | 3069.75 | 3068.65 | 3068.93 | 1561.0 |
| 2018-01-22 03:20:00 | ES | Futures | 3068.93 | 3070.02 | 3068.93 | 3070.02 | 899.0 |
| 2018-01-22 03:25:00 | ES | Futures | 3070.02 | 3070.57 | 3069.47 | 3069.47 | 1212.0 |
| 2018-01-22 03:30:00 | ES | Futures | 3069.75 | 3070.57 | 3069.47 | 3070.02 | 850.0 |
| 2018-01-22 03:35:00 | ES | Futures | 3070.02 | 3070.02 | 3069.2 | 3069.2 | 810.0 |
| 2018-01-22 03:40:00 | ES | Futures | 3069.47 | 3071.11 | 3069.2 | 3071.11 | 732.0 |
| 2018-01-22 03:45:00 | ES | Futures | 3070.84 | 3070.84 | 3069.47 | 3070.02 | 808.0 |
| 2018-01-22 03:50:00 | ES | Futures | 3070.02 | 3070.02 | 3068.93 | 3069.2 | 627.0 |
| 2018-01-22 03:55:00 | ES | Futures | 3068.93 | 3069.47 | 3068.65 | 3069.47 | 681.0 |
| 2018-01-22 04:00:00 | ES | Futures | 3069.2 | 3069.47 | 3068.38 | 3068.38 | 1459.0 |
| 2018-01-22 04:05:00 | ES | Futures | 3068.65 | 3068.65 | 3067.83 | 3067.83 | 1437.0 |
> showing 50 of 16,151 rows — these rows as CSV