PREVIEW / futures_5min / 2017-08-17
file: by_date/futures_5min/2017/2017-08-17.parquet size: 257 KB rows: 15,096
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-08-17 00:00:00 | ES | Futures | 2695.12 | 2695.4 | 2695.12 | 2695.12 | 235.0 |
| 2017-08-17 00:05:00 | ES | Futures | 2695.4 | 2695.4 | 2695.12 | 2695.12 | 45.0 |
| 2017-08-17 00:10:00 | ES | Futures | 2695.4 | 2695.4 | 2695.12 | 2695.12 | 22.0 |
| 2017-08-17 00:15:00 | ES | Futures | 2695.12 | 2695.4 | 2695.12 | 2695.12 | 89.0 |
| 2017-08-17 00:20:00 | ES | Futures | 2695.12 | 2695.4 | 2695.12 | 2695.12 | 35.0 |
| 2017-08-17 00:25:00 | ES | Futures | 2695.12 | 2695.4 | 2695.12 | 2695.12 | 18.0 |
| 2017-08-17 00:30:00 | ES | Futures | 2695.12 | 2695.67 | 2695.12 | 2695.67 | 55.0 |
| 2017-08-17 00:35:00 | ES | Futures | 2695.67 | 2695.67 | 2695.67 | 2695.67 | 16.0 |
| 2017-08-17 00:40:00 | ES | Futures | 2695.67 | 2695.67 | 2695.4 | 2695.67 | 107.0 |
| 2017-08-17 00:45:00 | ES | Futures | 2695.4 | 2695.67 | 2695.4 | 2695.4 | 17.0 |
| 2017-08-17 00:50:00 | ES | Futures | 2695.67 | 2695.67 | 2695.4 | 2695.67 | 44.0 |
| 2017-08-17 00:55:00 | ES | Futures | 2695.67 | 2695.67 | 2695.4 | 2695.4 | 71.0 |
| 2017-08-17 01:00:00 | ES | Futures | 2695.67 | 2695.94 | 2695.4 | 2695.94 | 224.0 |
| 2017-08-17 01:05:00 | ES | Futures | 2695.67 | 2695.94 | 2695.4 | 2695.4 | 213.0 |
| 2017-08-17 01:10:00 | ES | Futures | 2695.4 | 2695.4 | 2694.58 | 2694.85 | 546.0 |
| 2017-08-17 01:15:00 | ES | Futures | 2694.85 | 2695.12 | 2694.58 | 2694.58 | 117.0 |
| 2017-08-17 01:20:00 | ES | Futures | 2694.85 | 2695.12 | 2694.85 | 2694.85 | 76.0 |
| 2017-08-17 01:25:00 | ES | Futures | 2694.85 | 2695.12 | 2694.85 | 2695.12 | 16.0 |
| 2017-08-17 01:30:00 | ES | Futures | 2694.85 | 2695.12 | 2694.58 | 2694.85 | 147.0 |
| 2017-08-17 01:35:00 | ES | Futures | 2694.58 | 2694.58 | 2694.3 | 2694.58 | 297.0 |
| 2017-08-17 01:40:00 | ES | Futures | 2694.3 | 2694.58 | 2694.3 | 2694.3 | 50.0 |
| 2017-08-17 01:45:00 | ES | Futures | 2694.58 | 2694.85 | 2694.3 | 2694.85 | 175.0 |
| 2017-08-17 01:50:00 | ES | Futures | 2694.58 | 2694.85 | 2694.58 | 2694.58 | 50.0 |
| 2017-08-17 01:55:00 | ES | Futures | 2694.58 | 2695.12 | 2694.3 | 2695.12 | 888.0 |
| 2017-08-17 02:00:00 | ES | Futures | 2695.12 | 2696.22 | 2694.85 | 2695.67 | 931.0 |
| 2017-08-17 02:05:00 | ES | Futures | 2695.67 | 2695.94 | 2695.4 | 2695.67 | 346.0 |
| 2017-08-17 02:10:00 | ES | Futures | 2695.4 | 2696.22 | 2695.4 | 2695.94 | 432.0 |
| 2017-08-17 02:15:00 | ES | Futures | 2695.94 | 2695.94 | 2695.4 | 2695.94 | 412.0 |
| 2017-08-17 02:20:00 | ES | Futures | 2695.94 | 2695.94 | 2695.67 | 2695.67 | 402.0 |
| 2017-08-17 02:25:00 | ES | Futures | 2695.67 | 2695.94 | 2695.4 | 2695.94 | 374.0 |
| 2017-08-17 02:30:00 | ES | Futures | 2695.94 | 2696.22 | 2695.94 | 2695.94 | 310.0 |
| 2017-08-17 02:35:00 | ES | Futures | 2695.94 | 2695.94 | 2695.67 | 2695.94 | 81.0 |
| 2017-08-17 02:40:00 | ES | Futures | 2695.94 | 2695.94 | 2695.12 | 2695.12 | 309.0 |
| 2017-08-17 02:45:00 | ES | Futures | 2695.12 | 2695.67 | 2695.12 | 2695.67 | 329.0 |
| 2017-08-17 02:50:00 | ES | Futures | 2695.4 | 2695.94 | 2695.4 | 2695.67 | 148.0 |
| 2017-08-17 02:55:00 | ES | Futures | 2695.4 | 2695.67 | 2695.4 | 2695.4 | 263.0 |
| 2017-08-17 03:00:00 | ES | Futures | 2695.4 | 2695.94 | 2694.58 | 2695.12 | 3084.0 |
| 2017-08-17 03:05:00 | ES | Futures | 2695.4 | 2696.49 | 2695.12 | 2696.22 | 1852.0 |
| 2017-08-17 03:10:00 | ES | Futures | 2696.22 | 2696.22 | 2695.4 | 2695.94 | 1186.0 |
| 2017-08-17 03:15:00 | ES | Futures | 2696.22 | 2698.4 | 2696.22 | 2697.31 | 3555.0 |
| 2017-08-17 03:20:00 | ES | Futures | 2697.58 | 2697.86 | 2697.04 | 2697.58 | 1168.0 |
| 2017-08-17 03:25:00 | ES | Futures | 2697.58 | 2698.95 | 2697.31 | 2698.13 | 1996.0 |
| 2017-08-17 03:30:00 | ES | Futures | 2698.4 | 2698.68 | 2697.86 | 2698.13 | 1006.0 |
| 2017-08-17 03:35:00 | ES | Futures | 2698.13 | 2698.4 | 2697.58 | 2697.86 | 783.0 |
| 2017-08-17 03:40:00 | ES | Futures | 2697.58 | 2698.68 | 2697.31 | 2697.86 | 1362.0 |
| 2017-08-17 03:45:00 | ES | Futures | 2697.86 | 2697.86 | 2696.76 | 2697.04 | 788.0 |
| 2017-08-17 03:50:00 | ES | Futures | 2696.76 | 2697.04 | 2696.49 | 2696.76 | 1093.0 |
| 2017-08-17 03:55:00 | ES | Futures | 2696.76 | 2697.04 | 2696.22 | 2697.04 | 476.0 |
| 2017-08-17 04:00:00 | ES | Futures | 2696.76 | 2697.04 | 2695.94 | 2696.22 | 879.0 |
| 2017-08-17 04:05:00 | ES | Futures | 2696.22 | 2697.04 | 2696.22 | 2696.49 | 1094.0 |
> showing 50 of 15,096 rows — these rows as CSV