PREVIEW / futures_5min / 2017-11-16
file: by_date/futures_5min/2017/2017-11-16.parquet size: 229 KB rows: 15,778
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-16 00:00:00 | ES | Futures | 2812.18 | 2813.55 | 2811.91 | 2813.0 | 1805.0 |
| 2017-11-16 00:05:00 | ES | Futures | 2812.73 | 2813.0 | 2811.64 | 2812.18 | 791.0 |
| 2017-11-16 00:10:00 | ES | Futures | 2812.46 | 2812.46 | 2811.64 | 2812.18 | 581.0 |
| 2017-11-16 00:15:00 | ES | Futures | 2812.18 | 2813.55 | 2811.91 | 2813.55 | 2022.0 |
| 2017-11-16 00:20:00 | ES | Futures | 2813.28 | 2813.82 | 2813.28 | 2813.55 | 1040.0 |
| 2017-11-16 00:25:00 | ES | Futures | 2813.55 | 2813.82 | 2813.55 | 2813.82 | 546.0 |
| 2017-11-16 00:30:00 | ES | Futures | 2813.82 | 2813.82 | 2812.73 | 2813.0 | 465.0 |
| 2017-11-16 00:35:00 | ES | Futures | 2813.0 | 2813.0 | 2812.73 | 2812.73 | 234.0 |
| 2017-11-16 00:40:00 | ES | Futures | 2813.0 | 2813.0 | 2812.46 | 2812.73 | 368.0 |
| 2017-11-16 00:45:00 | ES | Futures | 2812.73 | 2813.0 | 2812.46 | 2812.73 | 556.0 |
| 2017-11-16 00:50:00 | ES | Futures | 2812.73 | 2813.0 | 2812.46 | 2813.0 | 435.0 |
| 2017-11-16 00:55:00 | ES | Futures | 2813.0 | 2813.55 | 2813.0 | 2813.0 | 336.0 |
| 2017-11-16 01:00:00 | ES | Futures | 2813.28 | 2813.28 | 2812.73 | 2813.28 | 324.0 |
| 2017-11-16 01:05:00 | ES | Futures | 2813.28 | 2814.92 | 2813.0 | 2814.64 | 2854.0 |
| 2017-11-16 01:10:00 | ES | Futures | 2814.92 | 2815.19 | 2813.82 | 2814.1 | 1212.0 |
| 2017-11-16 01:15:00 | ES | Futures | 2814.1 | 2814.1 | 2813.28 | 2813.28 | 856.0 |
| 2017-11-16 01:20:00 | ES | Futures | 2813.55 | 2814.37 | 2813.28 | 2814.1 | 1173.0 |
| 2017-11-16 01:25:00 | ES | Futures | 2814.1 | 2814.1 | 2813.0 | 2813.0 | 328.0 |
| 2017-11-16 01:30:00 | ES | Futures | 2813.28 | 2813.82 | 2813.0 | 2813.55 | 201.0 |
| 2017-11-16 01:35:00 | ES | Futures | 2813.82 | 2814.37 | 2813.55 | 2814.1 | 287.0 |
| 2017-11-16 01:40:00 | ES | Futures | 2814.1 | 2815.19 | 2814.1 | 2814.92 | 828.0 |
| 2017-11-16 01:45:00 | ES | Futures | 2814.92 | 2814.92 | 2814.64 | 2814.92 | 164.0 |
| 2017-11-16 01:50:00 | ES | Futures | 2814.64 | 2815.19 | 2814.37 | 2814.37 | 516.0 |
| 2017-11-16 01:55:00 | ES | Futures | 2814.37 | 2814.92 | 2814.1 | 2814.37 | 569.0 |
| 2017-11-16 02:00:00 | ES | Futures | 2814.64 | 2815.47 | 2814.37 | 2814.92 | 1374.0 |
| 2017-11-16 02:05:00 | ES | Futures | 2814.92 | 2814.92 | 2814.64 | 2814.92 | 630.0 |
| 2017-11-16 02:10:00 | ES | Futures | 2814.92 | 2815.19 | 2814.64 | 2815.19 | 867.0 |
| 2017-11-16 02:15:00 | ES | Futures | 2814.92 | 2817.11 | 2814.92 | 2816.83 | 3613.0 |
| 2017-11-16 02:20:00 | ES | Futures | 2816.56 | 2816.56 | 2815.74 | 2816.01 | 1330.0 |
| 2017-11-16 02:25:00 | ES | Futures | 2816.01 | 2816.56 | 2815.47 | 2815.47 | 2094.0 |
| 2017-11-16 02:30:00 | ES | Futures | 2815.47 | 2815.74 | 2815.19 | 2815.74 | 2724.0 |
| 2017-11-16 02:35:00 | ES | Futures | 2815.47 | 2815.74 | 2814.92 | 2814.92 | 995.0 |
| 2017-11-16 02:40:00 | ES | Futures | 2815.19 | 2816.01 | 2814.92 | 2816.01 | 1280.0 |
| 2017-11-16 02:45:00 | ES | Futures | 2815.74 | 2816.01 | 2814.64 | 2814.92 | 1261.0 |
| 2017-11-16 02:50:00 | ES | Futures | 2814.92 | 2815.19 | 2814.64 | 2814.92 | 890.0 |
| 2017-11-16 02:55:00 | ES | Futures | 2814.92 | 2815.19 | 2813.82 | 2814.64 | 1594.0 |
| 2017-11-16 03:00:00 | ES | Futures | 2814.37 | 2814.64 | 2813.28 | 2814.37 | 5459.0 |
| 2017-11-16 03:05:00 | ES | Futures | 2814.1 | 2814.1 | 2813.28 | 2813.28 | 3484.0 |
| 2017-11-16 03:10:00 | ES | Futures | 2813.28 | 2813.82 | 2813.28 | 2813.82 | 2361.0 |
| 2017-11-16 03:15:00 | ES | Futures | 2813.82 | 2814.37 | 2813.28 | 2814.1 | 2447.0 |
| 2017-11-16 03:20:00 | ES | Futures | 2814.1 | 2814.37 | 2812.46 | 2812.46 | 1871.0 |
| 2017-11-16 03:25:00 | ES | Futures | 2812.46 | 2813.55 | 2812.46 | 2813.55 | 2968.0 |
| 2017-11-16 03:30:00 | ES | Futures | 2813.82 | 2814.37 | 2813.55 | 2813.82 | 1911.0 |
| 2017-11-16 03:35:00 | ES | Futures | 2814.1 | 2815.74 | 2814.1 | 2815.47 | 2732.0 |
| 2017-11-16 03:40:00 | ES | Futures | 2815.47 | 2815.47 | 2814.37 | 2814.64 | 2244.0 |
| 2017-11-16 03:45:00 | ES | Futures | 2814.64 | 2814.92 | 2814.1 | 2814.64 | 1889.0 |
| 2017-11-16 03:50:00 | ES | Futures | 2814.64 | 2814.92 | 2814.1 | 2814.1 | 1391.0 |
| 2017-11-16 03:55:00 | ES | Futures | 2814.1 | 2814.92 | 2813.82 | 2814.64 | 2270.0 |
| 2017-11-16 04:00:00 | ES | Futures | 2814.92 | 2814.92 | 2814.37 | 2814.92 | 1415.0 |
| 2017-11-16 04:05:00 | ES | Futures | 2814.92 | 2814.92 | 2814.37 | 2814.37 | 886.0 |
> showing 50 of 15,778 rows — these rows as CSV