PREVIEW / futures_5min / 2017-11-02
file: by_date/futures_5min/2017/2017-11-02.parquet size: 230 KB rows: 15,653
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-11-02 00:00:00 | ES | Futures | 2812.18 | 2812.18 | 2811.64 | 2812.18 | 492.0 |
| 2017-11-02 00:05:00 | ES | Futures | 2812.18 | 2812.46 | 2811.91 | 2812.18 | 176.0 |
| 2017-11-02 00:10:00 | ES | Futures | 2812.18 | 2812.73 | 2811.91 | 2812.46 | 358.0 |
| 2017-11-02 00:15:00 | ES | Futures | 2812.73 | 2812.73 | 2812.46 | 2812.46 | 153.0 |
| 2017-11-02 00:20:00 | ES | Futures | 2812.46 | 2812.73 | 2812.18 | 2812.18 | 179.0 |
| 2017-11-02 00:25:00 | ES | Futures | 2812.18 | 2812.46 | 2812.18 | 2812.46 | 30.0 |
| 2017-11-02 00:30:00 | ES | Futures | 2812.18 | 2812.46 | 2811.91 | 2812.18 | 269.0 |
| 2017-11-02 00:35:00 | ES | Futures | 2811.91 | 2812.18 | 2811.91 | 2812.18 | 60.0 |
| 2017-11-02 00:40:00 | ES | Futures | 2811.91 | 2812.18 | 2811.91 | 2811.91 | 14.0 |
| 2017-11-02 00:45:00 | ES | Futures | 2812.18 | 2812.18 | 2811.36 | 2811.91 | 410.0 |
| 2017-11-02 00:50:00 | ES | Futures | 2811.64 | 2812.18 | 2811.36 | 2811.64 | 293.0 |
| 2017-11-02 00:55:00 | ES | Futures | 2811.64 | 2811.91 | 2811.36 | 2811.91 | 266.0 |
| 2017-11-02 01:00:00 | ES | Futures | 2811.91 | 2812.18 | 2811.64 | 2812.18 | 519.0 |
| 2017-11-02 01:05:00 | ES | Futures | 2812.18 | 2812.18 | 2811.64 | 2811.64 | 381.0 |
| 2017-11-02 01:10:00 | ES | Futures | 2811.64 | 2812.46 | 2811.64 | 2812.18 | 156.0 |
| 2017-11-02 01:15:00 | ES | Futures | 2812.18 | 2812.18 | 2811.64 | 2811.91 | 54.0 |
| 2017-11-02 01:20:00 | ES | Futures | 2811.64 | 2812.46 | 2811.64 | 2812.18 | 340.0 |
| 2017-11-02 01:25:00 | ES | Futures | 2812.18 | 2812.46 | 2812.18 | 2812.46 | 202.0 |
| 2017-11-02 01:30:00 | ES | Futures | 2812.46 | 2812.46 | 2811.64 | 2811.91 | 443.0 |
| 2017-11-02 01:35:00 | ES | Futures | 2812.18 | 2812.46 | 2811.91 | 2811.91 | 166.0 |
| 2017-11-02 01:40:00 | ES | Futures | 2811.91 | 2812.46 | 2811.91 | 2812.18 | 327.0 |
| 2017-11-02 01:45:00 | ES | Futures | 2812.18 | 2812.18 | 2811.64 | 2811.64 | 216.0 |
| 2017-11-02 01:50:00 | ES | Futures | 2811.91 | 2812.46 | 2811.64 | 2812.18 | 388.0 |
| 2017-11-02 01:55:00 | ES | Futures | 2812.18 | 2812.46 | 2812.18 | 2812.46 | 572.0 |
| 2017-11-02 02:00:00 | ES | Futures | 2812.18 | 2812.73 | 2812.18 | 2812.73 | 327.0 |
| 2017-11-02 02:05:00 | ES | Futures | 2812.46 | 2812.46 | 2812.18 | 2812.46 | 499.0 |
| 2017-11-02 02:10:00 | ES | Futures | 2812.46 | 2812.46 | 2811.36 | 2811.36 | 508.0 |
| 2017-11-02 02:15:00 | ES | Futures | 2811.36 | 2811.64 | 2811.36 | 2811.36 | 166.0 |
| 2017-11-02 02:20:00 | ES | Futures | 2811.36 | 2811.64 | 2811.36 | 2811.64 | 131.0 |
| 2017-11-02 02:25:00 | ES | Futures | 2811.36 | 2811.64 | 2811.36 | 2811.36 | 22.0 |
| 2017-11-02 02:30:00 | ES | Futures | 2811.64 | 2811.91 | 2811.36 | 2811.91 | 134.0 |
| 2017-11-02 02:35:00 | ES | Futures | 2811.64 | 2812.18 | 2811.64 | 2811.91 | 104.0 |
| 2017-11-02 02:40:00 | ES | Futures | 2811.91 | 2812.18 | 2811.91 | 2812.18 | 170.0 |
| 2017-11-02 02:45:00 | ES | Futures | 2812.18 | 2812.18 | 2811.91 | 2812.18 | 45.0 |
| 2017-11-02 02:50:00 | ES | Futures | 2811.91 | 2812.18 | 2811.64 | 2811.64 | 198.0 |
| 2017-11-02 02:55:00 | ES | Futures | 2811.64 | 2811.91 | 2811.36 | 2811.64 | 247.0 |
| 2017-11-02 03:00:00 | ES | Futures | 2811.64 | 2812.46 | 2811.64 | 2811.64 | 961.0 |
| 2017-11-02 03:05:00 | ES | Futures | 2811.64 | 2812.18 | 2811.09 | 2812.18 | 1345.0 |
| 2017-11-02 03:10:00 | ES | Futures | 2811.91 | 2811.91 | 2811.64 | 2811.64 | 521.0 |
| 2017-11-02 03:15:00 | ES | Futures | 2811.64 | 2811.91 | 2811.36 | 2811.36 | 441.0 |
| 2017-11-02 03:20:00 | ES | Futures | 2811.64 | 2811.64 | 2811.36 | 2811.36 | 526.0 |
| 2017-11-02 03:25:00 | ES | Futures | 2811.64 | 2811.64 | 2811.09 | 2811.64 | 306.0 |
| 2017-11-02 03:30:00 | ES | Futures | 2811.64 | 2812.18 | 2811.36 | 2811.91 | 412.0 |
| 2017-11-02 03:35:00 | ES | Futures | 2811.91 | 2812.18 | 2811.91 | 2812.18 | 767.0 |
| 2017-11-02 03:40:00 | ES | Futures | 2812.46 | 2812.46 | 2812.18 | 2812.46 | 529.0 |
| 2017-11-02 03:45:00 | ES | Futures | 2812.46 | 2812.73 | 2811.36 | 2811.91 | 795.0 |
| 2017-11-02 03:50:00 | ES | Futures | 2811.91 | 2812.18 | 2811.64 | 2811.91 | 831.0 |
| 2017-11-02 03:55:00 | ES | Futures | 2811.91 | 2812.46 | 2811.91 | 2812.46 | 442.0 |
| 2017-11-02 04:00:00 | ES | Futures | 2812.18 | 2813.55 | 2811.91 | 2813.28 | 4617.0 |
| 2017-11-02 04:05:00 | ES | Futures | 2813.55 | 2814.37 | 2813.28 | 2813.82 | 3626.0 |
> showing 50 of 15,653 rows — these rows as CSV