PREVIEW / futures_5min / 2018-07-25
file: by_date/futures_5min/2018/2018-07-25.parquet size: 250 KB rows: 15,600
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-25 00:00:00 | ES | Futures | 3069.06 | 3069.06 | 3068.52 | 3069.06 | 233.0 |
| 2018-07-25 00:05:00 | ES | Futures | 3068.79 | 3069.06 | 3068.24 | 3068.52 | 172.0 |
| 2018-07-25 00:10:00 | ES | Futures | 3068.79 | 3068.79 | 3068.52 | 3068.79 | 86.0 |
| 2018-07-25 00:15:00 | ES | Futures | 3068.52 | 3068.79 | 3068.52 | 3068.79 | 89.0 |
| 2018-07-25 00:20:00 | ES | Futures | 3068.52 | 3069.33 | 3068.24 | 3069.33 | 304.0 |
| 2018-07-25 00:25:00 | ES | Futures | 3069.33 | 3069.33 | 3068.52 | 3068.52 | 104.0 |
| 2018-07-25 00:30:00 | ES | Futures | 3068.79 | 3068.79 | 3068.24 | 3068.52 | 227.0 |
| 2018-07-25 00:35:00 | ES | Futures | 3068.52 | 3068.79 | 3068.24 | 3068.52 | 204.0 |
| 2018-07-25 00:40:00 | ES | Futures | 3068.52 | 3068.79 | 3068.24 | 3068.79 | 221.0 |
| 2018-07-25 00:45:00 | ES | Futures | 3068.79 | 3069.06 | 3068.52 | 3068.52 | 203.0 |
| 2018-07-25 00:50:00 | ES | Futures | 3068.52 | 3068.79 | 3066.88 | 3067.7 | 986.0 |
| 2018-07-25 00:55:00 | ES | Futures | 3067.7 | 3068.79 | 3067.7 | 3068.24 | 408.0 |
| 2018-07-25 01:00:00 | ES | Futures | 3068.52 | 3069.06 | 3068.52 | 3068.79 | 368.0 |
| 2018-07-25 01:05:00 | ES | Futures | 3068.52 | 3069.06 | 3068.52 | 3068.79 | 263.0 |
| 2018-07-25 01:10:00 | ES | Futures | 3068.79 | 3069.06 | 3068.52 | 3068.52 | 91.0 |
| 2018-07-25 01:15:00 | ES | Futures | 3068.52 | 3068.79 | 3068.52 | 3068.52 | 41.0 |
| 2018-07-25 01:20:00 | ES | Futures | 3068.79 | 3068.79 | 3067.97 | 3068.24 | 308.0 |
| 2018-07-25 01:25:00 | ES | Futures | 3068.24 | 3068.52 | 3067.97 | 3068.24 | 160.0 |
| 2018-07-25 01:30:00 | ES | Futures | 3068.24 | 3068.52 | 3067.97 | 3068.24 | 218.0 |
| 2018-07-25 01:35:00 | ES | Futures | 3068.24 | 3068.52 | 3067.97 | 3068.52 | 233.0 |
| 2018-07-25 01:40:00 | ES | Futures | 3068.79 | 3068.79 | 3068.24 | 3068.52 | 362.0 |
| 2018-07-25 01:45:00 | ES | Futures | 3068.52 | 3069.06 | 3068.52 | 3068.79 | 255.0 |
| 2018-07-25 01:50:00 | ES | Futures | 3068.79 | 3069.33 | 3068.52 | 3069.33 | 258.0 |
| 2018-07-25 01:55:00 | ES | Futures | 3069.33 | 3069.88 | 3069.06 | 3069.88 | 258.0 |
| 2018-07-25 02:00:00 | ES | Futures | 3069.61 | 3070.42 | 3069.06 | 3070.42 | 796.0 |
| 2018-07-25 02:05:00 | ES | Futures | 3070.42 | 3070.42 | 3069.61 | 3069.61 | 673.0 |
| 2018-07-25 02:10:00 | ES | Futures | 3069.88 | 3070.15 | 3069.61 | 3069.61 | 515.0 |
| 2018-07-25 02:15:00 | ES | Futures | 3069.88 | 3070.15 | 3069.33 | 3070.15 | 344.0 |
| 2018-07-25 02:20:00 | ES | Futures | 3070.15 | 3070.15 | 3069.61 | 3069.88 | 342.0 |
| 2018-07-25 02:25:00 | ES | Futures | 3070.15 | 3070.42 | 3069.61 | 3069.88 | 193.0 |
| 2018-07-25 02:30:00 | ES | Futures | 3069.88 | 3070.42 | 3069.61 | 3070.42 | 264.0 |
| 2018-07-25 02:35:00 | ES | Futures | 3070.15 | 3071.24 | 3070.15 | 3071.24 | 571.0 |
| 2018-07-25 02:40:00 | ES | Futures | 3071.24 | 3071.79 | 3070.97 | 3071.24 | 603.0 |
| 2018-07-25 02:45:00 | ES | Futures | 3071.24 | 3071.51 | 3070.97 | 3071.51 | 198.0 |
| 2018-07-25 02:50:00 | ES | Futures | 3071.79 | 3071.79 | 3071.51 | 3071.79 | 324.0 |
| 2018-07-25 02:55:00 | ES | Futures | 3071.79 | 3072.33 | 3071.51 | 3072.06 | 515.0 |
| 2018-07-25 03:00:00 | ES | Futures | 3072.06 | 3072.87 | 3071.51 | 3072.33 | 2151.0 |
| 2018-07-25 03:05:00 | ES | Futures | 3072.33 | 3072.6 | 3071.51 | 3071.51 | 1164.0 |
| 2018-07-25 03:10:00 | ES | Futures | 3071.51 | 3072.6 | 3071.24 | 3072.6 | 473.0 |
| 2018-07-25 03:15:00 | ES | Futures | 3072.6 | 3073.15 | 3071.51 | 3071.51 | 854.0 |
| 2018-07-25 03:20:00 | ES | Futures | 3071.51 | 3072.33 | 3071.51 | 3072.33 | 597.0 |
| 2018-07-25 03:25:00 | ES | Futures | 3072.33 | 3073.42 | 3071.79 | 3073.15 | 899.0 |
| 2018-07-25 03:30:00 | ES | Futures | 3072.87 | 3073.42 | 3071.79 | 3072.06 | 606.0 |
| 2018-07-25 03:35:00 | ES | Futures | 3072.33 | 3072.6 | 3071.24 | 3071.51 | 831.0 |
| 2018-07-25 03:40:00 | ES | Futures | 3071.24 | 3072.06 | 3071.24 | 3071.51 | 783.0 |
| 2018-07-25 03:45:00 | ES | Futures | 3071.79 | 3073.15 | 3071.79 | 3073.15 | 889.0 |
| 2018-07-25 03:50:00 | ES | Futures | 3072.87 | 3073.15 | 3072.33 | 3072.6 | 998.0 |
| 2018-07-25 03:55:00 | ES | Futures | 3072.33 | 3072.87 | 3072.06 | 3072.6 | 715.0 |
| 2018-07-25 04:00:00 | ES | Futures | 3072.33 | 3073.96 | 3072.06 | 3073.69 | 1027.0 |
| 2018-07-25 04:05:00 | ES | Futures | 3073.42 | 3073.96 | 3072.6 | 3072.6 | 675.0 |
> showing 50 of 15,600 rows — these rows as CSV