PREVIEW / futures_5min / 2018-07-31
file: by_date/futures_5min/2018/2018-07-31.parquet size: 258 KB rows: 15,804
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-07-31 00:00:00 | ES | Futures | 3057.34 | 3058.98 | 3057.07 | 3057.62 | 1142.0 |
| 2018-07-31 00:05:00 | ES | Futures | 3057.62 | 3060.34 | 3057.62 | 3058.16 | 2033.0 |
| 2018-07-31 00:10:00 | ES | Futures | 3058.16 | 3059.52 | 3057.34 | 3059.25 | 1038.0 |
| 2018-07-31 00:15:00 | ES | Futures | 3058.98 | 3059.8 | 3058.71 | 3058.98 | 1071.0 |
| 2018-07-31 00:20:00 | ES | Futures | 3058.71 | 3059.25 | 3058.71 | 3058.98 | 218.0 |
| 2018-07-31 00:25:00 | ES | Futures | 3058.98 | 3060.07 | 3058.71 | 3059.25 | 457.0 |
| 2018-07-31 00:30:00 | ES | Futures | 3058.98 | 3059.25 | 3058.43 | 3058.71 | 220.0 |
| 2018-07-31 00:35:00 | ES | Futures | 3058.71 | 3059.25 | 3058.43 | 3058.98 | 311.0 |
| 2018-07-31 00:40:00 | ES | Futures | 3058.71 | 3059.8 | 3058.71 | 3059.8 | 615.0 |
| 2018-07-31 00:45:00 | ES | Futures | 3059.8 | 3060.07 | 3059.52 | 3059.8 | 364.0 |
| 2018-07-31 00:50:00 | ES | Futures | 3060.07 | 3060.34 | 3058.98 | 3059.25 | 455.0 |
| 2018-07-31 00:55:00 | ES | Futures | 3059.25 | 3059.25 | 3058.71 | 3059.25 | 428.0 |
| 2018-07-31 01:00:00 | ES | Futures | 3059.25 | 3059.8 | 3059.25 | 3059.25 | 379.0 |
| 2018-07-31 01:05:00 | ES | Futures | 3059.25 | 3059.52 | 3058.71 | 3059.25 | 472.0 |
| 2018-07-31 01:10:00 | ES | Futures | 3058.98 | 3059.25 | 3058.43 | 3058.43 | 327.0 |
| 2018-07-31 01:15:00 | ES | Futures | 3058.71 | 3058.98 | 3058.43 | 3058.98 | 186.0 |
| 2018-07-31 01:20:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3058.98 | 265.0 |
| 2018-07-31 01:25:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3058.98 | 150.0 |
| 2018-07-31 01:30:00 | ES | Futures | 3058.98 | 3058.98 | 3058.71 | 3058.98 | 131.0 |
| 2018-07-31 01:35:00 | ES | Futures | 3058.98 | 3060.61 | 3058.71 | 3060.34 | 1170.0 |
| 2018-07-31 01:40:00 | ES | Futures | 3060.07 | 3060.61 | 3060.07 | 3060.34 | 414.0 |
| 2018-07-31 01:45:00 | ES | Futures | 3060.07 | 3060.34 | 3060.07 | 3060.34 | 186.0 |
| 2018-07-31 01:50:00 | ES | Futures | 3060.34 | 3060.34 | 3060.07 | 3060.07 | 423.0 |
| 2018-07-31 01:55:00 | ES | Futures | 3060.07 | 3060.34 | 3059.8 | 3059.8 | 353.0 |
| 2018-07-31 02:00:00 | ES | Futures | 3060.07 | 3060.61 | 3059.8 | 3060.07 | 609.0 |
| 2018-07-31 02:05:00 | ES | Futures | 3060.07 | 3060.34 | 3059.25 | 3059.8 | 581.0 |
| 2018-07-31 02:10:00 | ES | Futures | 3059.52 | 3059.8 | 3059.25 | 3059.52 | 336.0 |
| 2018-07-31 02:15:00 | ES | Futures | 3059.25 | 3059.52 | 3058.71 | 3059.25 | 667.0 |
| 2018-07-31 02:20:00 | ES | Futures | 3059.52 | 3060.34 | 3059.25 | 3060.07 | 249.0 |
| 2018-07-31 02:25:00 | ES | Futures | 3060.07 | 3060.34 | 3059.52 | 3060.34 | 432.0 |
| 2018-07-31 02:30:00 | ES | Futures | 3060.34 | 3060.61 | 3058.98 | 3058.98 | 759.0 |
| 2018-07-31 02:35:00 | ES | Futures | 3059.25 | 3059.25 | 3058.43 | 3058.98 | 582.0 |
| 2018-07-31 02:40:00 | ES | Futures | 3059.25 | 3059.52 | 3059.25 | 3059.25 | 203.0 |
| 2018-07-31 02:45:00 | ES | Futures | 3059.25 | 3059.52 | 3059.25 | 3059.52 | 150.0 |
| 2018-07-31 02:50:00 | ES | Futures | 3059.25 | 3059.25 | 3058.43 | 3058.98 | 469.0 |
| 2018-07-31 02:55:00 | ES | Futures | 3058.71 | 3058.98 | 3058.16 | 3058.71 | 480.0 |
| 2018-07-31 03:00:00 | ES | Futures | 3058.71 | 3059.52 | 3058.16 | 3058.43 | 2377.0 |
| 2018-07-31 03:05:00 | ES | Futures | 3058.16 | 3059.8 | 3058.16 | 3058.71 | 1517.0 |
| 2018-07-31 03:10:00 | ES | Futures | 3058.71 | 3059.8 | 3058.71 | 3059.52 | 1317.0 |
| 2018-07-31 03:15:00 | ES | Futures | 3059.8 | 3060.34 | 3059.52 | 3060.07 | 543.0 |
| 2018-07-31 03:20:00 | ES | Futures | 3060.07 | 3061.43 | 3060.07 | 3060.34 | 2869.0 |
| 2018-07-31 03:25:00 | ES | Futures | 3060.34 | 3060.89 | 3060.07 | 3060.89 | 649.0 |
| 2018-07-31 03:30:00 | ES | Futures | 3060.61 | 3061.98 | 3060.61 | 3061.7 | 1550.0 |
| 2018-07-31 03:35:00 | ES | Futures | 3061.43 | 3061.7 | 3060.61 | 3060.61 | 878.0 |
| 2018-07-31 03:40:00 | ES | Futures | 3060.89 | 3061.7 | 3060.61 | 3060.89 | 1480.0 |
| 2018-07-31 03:45:00 | ES | Futures | 3060.89 | 3061.16 | 3060.34 | 3060.61 | 521.0 |
| 2018-07-31 03:50:00 | ES | Futures | 3060.61 | 3061.16 | 3059.52 | 3059.52 | 1152.0 |
| 2018-07-31 03:55:00 | ES | Futures | 3059.8 | 3060.07 | 3059.25 | 3060.07 | 1822.0 |
| 2018-07-31 04:00:00 | ES | Futures | 3060.34 | 3060.34 | 3059.52 | 3059.52 | 2234.0 |
| 2018-07-31 04:05:00 | ES | Futures | 3059.52 | 3060.07 | 3058.98 | 3058.98 | 1456.0 |
> showing 50 of 15,804 rows — these rows as CSV