PREVIEW / futures_5min / 2017-05-28
file: by_date/futures_5min/2017/2017-05-28.parquet size: 39 KB rows: 2,181
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-05-28 18:00:00 | ES | Futures | 2637.47 | 2638.29 | 2637.2 | 2638.01 | 969.0 |
| 2017-05-28 18:05:00 | ES | Futures | 2638.29 | 2640.47 | 2638.29 | 2639.38 | 1789.0 |
| 2017-05-28 18:10:00 | ES | Futures | 2639.38 | 2639.65 | 2639.11 | 2639.11 | 108.0 |
| 2017-05-28 18:15:00 | ES | Futures | 2638.83 | 2639.38 | 2638.83 | 2639.11 | 631.0 |
| 2017-05-28 18:20:00 | ES | Futures | 2639.11 | 2639.38 | 2638.83 | 2639.38 | 75.0 |
| 2017-05-28 18:25:00 | ES | Futures | 2639.38 | 2639.38 | 2639.11 | 2639.11 | 86.0 |
| 2017-05-28 18:30:00 | ES | Futures | 2639.38 | 2639.93 | 2639.11 | 2639.65 | 315.0 |
| 2017-05-28 18:35:00 | ES | Futures | 2639.65 | 2639.93 | 2639.65 | 2639.65 | 77.0 |
| 2017-05-28 18:40:00 | ES | Futures | 2639.38 | 2639.65 | 2639.38 | 2639.38 | 65.0 |
| 2017-05-28 18:45:00 | ES | Futures | 2639.38 | 2639.65 | 2639.38 | 2639.65 | 40.0 |
| 2017-05-28 18:50:00 | ES | Futures | 2639.65 | 2640.2 | 2639.65 | 2639.93 | 342.0 |
| 2017-05-28 18:55:00 | ES | Futures | 2639.93 | 2640.75 | 2639.93 | 2640.47 | 322.0 |
| 2017-05-28 19:00:00 | ES | Futures | 2640.2 | 2640.75 | 2640.2 | 2640.2 | 295.0 |
| 2017-05-28 19:05:00 | ES | Futures | 2640.2 | 2640.2 | 2640.2 | 2640.2 | 35.0 |
| 2017-05-28 19:10:00 | ES | Futures | 2640.2 | 2640.47 | 2640.2 | 2640.47 | 76.0 |
| 2017-05-28 19:15:00 | ES | Futures | 2640.47 | 2640.47 | 2640.2 | 2640.47 | 71.0 |
| 2017-05-28 19:20:00 | ES | Futures | 2640.2 | 2640.2 | 2640.2 | 2640.2 | 13.0 |
| 2017-05-28 19:25:00 | ES | Futures | 2640.2 | 2640.47 | 2640.2 | 2640.2 | 102.0 |
| 2017-05-28 19:30:00 | ES | Futures | 2640.2 | 2640.47 | 2639.65 | 2639.65 | 248.0 |
| 2017-05-28 19:35:00 | ES | Futures | 2639.65 | 2639.93 | 2639.65 | 2639.93 | 12.0 |
| 2017-05-28 19:40:00 | ES | Futures | 2639.65 | 2639.65 | 2639.38 | 2639.38 | 75.0 |
| 2017-05-28 19:45:00 | ES | Futures | 2639.38 | 2639.38 | 2639.11 | 2639.38 | 150.0 |
| 2017-05-28 19:50:00 | ES | Futures | 2639.38 | 2639.65 | 2639.11 | 2639.11 | 133.0 |
| 2017-05-28 19:55:00 | ES | Futures | 2639.38 | 2639.38 | 2639.11 | 2639.38 | 125.0 |
| 2017-05-28 20:00:00 | ES | Futures | 2639.11 | 2639.11 | 2638.29 | 2638.29 | 714.0 |
| 2017-05-28 20:05:00 | ES | Futures | 2638.29 | 2638.56 | 2638.29 | 2638.56 | 484.0 |
| 2017-05-28 20:10:00 | ES | Futures | 2638.29 | 2638.29 | 2637.74 | 2638.01 | 534.0 |
| 2017-05-28 20:15:00 | ES | Futures | 2638.01 | 2638.29 | 2637.2 | 2638.29 | 885.0 |
| 2017-05-28 20:20:00 | ES | Futures | 2638.01 | 2638.83 | 2638.01 | 2638.83 | 128.0 |
| 2017-05-28 20:25:00 | ES | Futures | 2638.56 | 2639.11 | 2638.29 | 2639.11 | 501.0 |
| 2017-05-28 20:30:00 | ES | Futures | 2639.11 | 2639.65 | 2639.11 | 2639.11 | 322.0 |
| 2017-05-28 20:35:00 | ES | Futures | 2639.11 | 2639.93 | 2638.83 | 2639.65 | 304.0 |
| 2017-05-28 20:40:00 | ES | Futures | 2639.65 | 2640.2 | 2639.38 | 2639.65 | 357.0 |
| 2017-05-28 20:45:00 | ES | Futures | 2639.65 | 2639.65 | 2639.38 | 2639.65 | 137.0 |
| 2017-05-28 20:50:00 | ES | Futures | 2639.65 | 2639.93 | 2639.65 | 2639.65 | 134.0 |
| 2017-05-28 20:55:00 | ES | Futures | 2639.65 | 2639.93 | 2639.38 | 2639.93 | 53.0 |
| 2017-05-28 21:00:00 | ES | Futures | 2639.65 | 2639.93 | 2639.38 | 2639.65 | 140.0 |
| 2017-05-28 21:05:00 | ES | Futures | 2639.65 | 2639.93 | 2639.65 | 2639.93 | 14.0 |
| 2017-05-28 21:10:00 | ES | Futures | 2639.93 | 2639.93 | 2639.65 | 2639.65 | 57.0 |
| 2017-05-28 21:15:00 | ES | Futures | 2639.93 | 2639.93 | 2639.65 | 2639.65 | 155.0 |
| 2017-05-28 21:20:00 | ES | Futures | 2639.65 | 2640.2 | 2639.65 | 2640.2 | 110.0 |
| 2017-05-28 21:25:00 | ES | Futures | 2639.93 | 2640.2 | 2639.65 | 2639.65 | 194.0 |
| 2017-05-28 21:30:00 | ES | Futures | 2639.65 | 2639.65 | 2639.11 | 2639.11 | 255.0 |
| 2017-05-28 21:35:00 | ES | Futures | 2639.38 | 2639.93 | 2639.38 | 2639.65 | 108.0 |
| 2017-05-28 21:40:00 | ES | Futures | 2639.65 | 2639.93 | 2638.83 | 2638.83 | 586.0 |
| 2017-05-28 21:45:00 | ES | Futures | 2639.11 | 2639.38 | 2639.11 | 2639.38 | 337.0 |
| 2017-05-28 21:50:00 | ES | Futures | 2639.38 | 2639.65 | 2639.11 | 2639.65 | 214.0 |
| 2017-05-28 21:55:00 | ES | Futures | 2639.65 | 2639.65 | 2639.38 | 2639.65 | 175.0 |
| 2017-05-28 22:00:00 | ES | Futures | 2639.93 | 2640.2 | 2639.65 | 2639.65 | 431.0 |
| 2017-05-28 22:05:00 | ES | Futures | 2639.65 | 2639.93 | 2639.65 | 2639.65 | 124.0 |
> showing 50 of 2,181 rows — these rows as CSV