PREVIEW / futures_5min / 2018-08-31
file: by_date/futures_5min/2018/2018-08-31.parquet size: 217 KB rows: 12,846
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-08-31 00:00:00 | ES | Futures | 3162.52 | 3163.06 | 3162.24 | 3163.06 | 313.0 |
| 2018-08-31 00:05:00 | ES | Futures | 3162.79 | 3163.33 | 3162.79 | 3163.06 | 154.0 |
| 2018-08-31 00:10:00 | ES | Futures | 3163.06 | 3163.33 | 3162.79 | 3163.33 | 180.0 |
| 2018-08-31 00:15:00 | ES | Futures | 3163.33 | 3163.33 | 3162.24 | 3162.52 | 347.0 |
| 2018-08-31 00:20:00 | ES | Futures | 3162.52 | 3162.79 | 3161.97 | 3162.24 | 145.0 |
| 2018-08-31 00:25:00 | ES | Futures | 3161.97 | 3162.24 | 3161.97 | 3162.24 | 39.0 |
| 2018-08-31 00:30:00 | ES | Futures | 3162.24 | 3162.24 | 3161.97 | 3162.24 | 211.0 |
| 2018-08-31 00:35:00 | ES | Futures | 3162.52 | 3162.79 | 3162.52 | 3162.52 | 177.0 |
| 2018-08-31 00:40:00 | ES | Futures | 3162.52 | 3162.52 | 3162.24 | 3162.24 | 117.0 |
| 2018-08-31 00:45:00 | ES | Futures | 3162.52 | 3162.79 | 3162.24 | 3162.52 | 134.0 |
| 2018-08-31 00:50:00 | ES | Futures | 3162.79 | 3163.06 | 3162.24 | 3162.24 | 182.0 |
| 2018-08-31 00:55:00 | ES | Futures | 3162.52 | 3162.79 | 3162.24 | 3162.79 | 61.0 |
| 2018-08-31 01:00:00 | ES | Futures | 3162.52 | 3164.15 | 3162.52 | 3163.33 | 1377.0 |
| 2018-08-31 01:05:00 | ES | Futures | 3163.06 | 3163.88 | 3163.06 | 3163.61 | 343.0 |
| 2018-08-31 01:10:00 | ES | Futures | 3163.61 | 3164.15 | 3163.33 | 3163.61 | 283.0 |
| 2018-08-31 01:15:00 | ES | Futures | 3163.61 | 3164.15 | 3163.33 | 3163.61 | 295.0 |
| 2018-08-31 01:20:00 | ES | Futures | 3163.61 | 3163.61 | 3163.33 | 3163.61 | 61.0 |
| 2018-08-31 01:25:00 | ES | Futures | 3163.61 | 3164.15 | 3163.61 | 3163.88 | 240.0 |
| 2018-08-31 01:30:00 | ES | Futures | 3163.61 | 3164.97 | 3163.61 | 3164.97 | 840.0 |
| 2018-08-31 01:35:00 | ES | Futures | 3164.97 | 3164.97 | 3164.42 | 3164.7 | 366.0 |
| 2018-08-31 01:40:00 | ES | Futures | 3164.42 | 3164.97 | 3164.42 | 3164.42 | 555.0 |
| 2018-08-31 01:45:00 | ES | Futures | 3164.42 | 3164.7 | 3164.42 | 3164.7 | 245.0 |
| 2018-08-31 01:50:00 | ES | Futures | 3164.7 | 3164.7 | 3163.61 | 3163.88 | 692.0 |
| 2018-08-31 01:55:00 | ES | Futures | 3163.61 | 3163.61 | 3163.06 | 3163.06 | 1067.0 |
| 2018-08-31 02:00:00 | ES | Futures | 3163.06 | 3163.61 | 3162.79 | 3163.06 | 802.0 |
| 2018-08-31 02:05:00 | ES | Futures | 3163.06 | 3163.06 | 3161.7 | 3162.24 | 659.0 |
| 2018-08-31 02:10:00 | ES | Futures | 3162.24 | 3162.79 | 3161.97 | 3162.79 | 524.0 |
| 2018-08-31 02:15:00 | ES | Futures | 3162.52 | 3163.33 | 3162.52 | 3163.06 | 593.0 |
| 2018-08-31 02:20:00 | ES | Futures | 3163.06 | 3163.61 | 3162.79 | 3163.61 | 345.0 |
| 2018-08-31 02:25:00 | ES | Futures | 3163.61 | 3163.88 | 3163.33 | 3163.61 | 549.0 |
| 2018-08-31 02:30:00 | ES | Futures | 3163.61 | 3163.61 | 3163.06 | 3163.33 | 435.0 |
| 2018-08-31 02:35:00 | ES | Futures | 3163.33 | 3163.88 | 3163.06 | 3163.33 | 437.0 |
| 2018-08-31 02:40:00 | ES | Futures | 3163.33 | 3163.61 | 3163.06 | 3163.06 | 343.0 |
| 2018-08-31 02:45:00 | ES | Futures | 3163.06 | 3163.61 | 3163.06 | 3163.61 | 399.0 |
| 2018-08-31 02:50:00 | ES | Futures | 3163.33 | 3163.61 | 3163.06 | 3163.06 | 445.0 |
| 2018-08-31 02:55:00 | ES | Futures | 3163.33 | 3164.15 | 3162.79 | 3163.61 | 775.0 |
| 2018-08-31 03:00:00 | ES | Futures | 3163.61 | 3163.61 | 3162.24 | 3162.52 | 2245.0 |
| 2018-08-31 03:05:00 | ES | Futures | 3162.52 | 3163.06 | 3161.97 | 3162.79 | 1522.0 |
| 2018-08-31 03:10:00 | ES | Futures | 3162.79 | 3163.33 | 3161.97 | 3162.24 | 1193.0 |
| 2018-08-31 03:15:00 | ES | Futures | 3161.97 | 3161.97 | 3159.25 | 3159.52 | 2700.0 |
| 2018-08-31 03:20:00 | ES | Futures | 3159.25 | 3159.52 | 3157.34 | 3158.16 | 3404.0 |
| 2018-08-31 03:25:00 | ES | Futures | 3158.16 | 3158.97 | 3157.61 | 3158.43 | 1880.0 |
| 2018-08-31 03:30:00 | ES | Futures | 3158.43 | 3159.25 | 3158.16 | 3158.7 | 1149.0 |
| 2018-08-31 03:35:00 | ES | Futures | 3158.97 | 3159.25 | 3157.61 | 3158.97 | 1820.0 |
| 2018-08-31 03:40:00 | ES | Futures | 3158.97 | 3159.79 | 3158.43 | 3159.79 | 1411.0 |
| 2018-08-31 03:45:00 | ES | Futures | 3159.79 | 3160.06 | 3159.25 | 3160.06 | 641.0 |
| 2018-08-31 03:50:00 | ES | Futures | 3160.06 | 3161.43 | 3159.79 | 3160.61 | 1555.0 |
| 2018-08-31 03:55:00 | ES | Futures | 3160.61 | 3160.61 | 3158.7 | 3158.7 | 1626.0 |
| 2018-08-31 04:00:00 | ES | Futures | 3158.7 | 3159.25 | 3157.61 | 3159.25 | 2162.0 |
| 2018-08-31 04:05:00 | ES | Futures | 3159.25 | 3160.34 | 3159.25 | 3159.52 | 1439.0 |
> showing 50 of 12,846 rows — these rows as CSV