PREVIEW / futures_5min / 2019-06-20
file: by_date/futures_5min/2019/2019-06-20.parquet size: 295 KB rows: 18,032
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-20 00:00:00 | ES | Futures | 3188.36 | 3188.91 | 3188.36 | 3188.36 | 491.0 |
| 2019-06-20 00:05:00 | ES | Futures | 3188.36 | 3188.64 | 3188.09 | 3188.09 | 180.0 |
| 2019-06-20 00:10:00 | ES | Futures | 3188.36 | 3188.36 | 3188.09 | 3188.09 | 83.0 |
| 2019-06-20 00:15:00 | ES | Futures | 3188.09 | 3188.36 | 3188.09 | 3188.09 | 211.0 |
| 2019-06-20 00:20:00 | ES | Futures | 3188.36 | 3188.36 | 3188.09 | 3188.36 | 194.0 |
| 2019-06-20 00:25:00 | ES | Futures | 3188.09 | 3188.36 | 3187.82 | 3187.82 | 105.0 |
| 2019-06-20 00:30:00 | ES | Futures | 3188.09 | 3188.36 | 3187.28 | 3187.55 | 658.0 |
| 2019-06-20 00:35:00 | ES | Futures | 3187.55 | 3187.82 | 3187.55 | 3187.82 | 227.0 |
| 2019-06-20 00:40:00 | ES | Futures | 3187.55 | 3187.82 | 3187.28 | 3187.55 | 295.0 |
| 2019-06-20 00:45:00 | ES | Futures | 3187.55 | 3187.55 | 3187.28 | 3187.28 | 271.0 |
| 2019-06-20 00:50:00 | ES | Futures | 3187.28 | 3187.82 | 3187.28 | 3187.55 | 266.0 |
| 2019-06-20 00:55:00 | ES | Futures | 3187.28 | 3188.91 | 3187.28 | 3188.91 | 928.0 |
| 2019-06-20 01:00:00 | ES | Futures | 3188.91 | 3189.18 | 3188.36 | 3188.91 | 1174.0 |
| 2019-06-20 01:05:00 | ES | Futures | 3188.91 | 3189.18 | 3188.64 | 3188.64 | 935.0 |
| 2019-06-20 01:10:00 | ES | Futures | 3188.64 | 3188.91 | 3188.09 | 3188.36 | 902.0 |
| 2019-06-20 01:15:00 | ES | Futures | 3188.36 | 3188.36 | 3187.82 | 3187.82 | 405.0 |
| 2019-06-20 01:20:00 | ES | Futures | 3187.55 | 3188.36 | 3187.55 | 3188.09 | 562.0 |
| 2019-06-20 01:25:00 | ES | Futures | 3188.36 | 3188.91 | 3188.36 | 3188.64 | 437.0 |
| 2019-06-20 01:30:00 | ES | Futures | 3188.36 | 3189.45 | 3188.36 | 3189.45 | 735.0 |
| 2019-06-20 01:35:00 | ES | Futures | 3189.45 | 3189.72 | 3188.91 | 3188.91 | 565.0 |
| 2019-06-20 01:40:00 | ES | Futures | 3189.18 | 3189.72 | 3189.18 | 3189.18 | 545.0 |
| 2019-06-20 01:45:00 | ES | Futures | 3188.91 | 3189.99 | 3188.91 | 3189.18 | 642.0 |
| 2019-06-20 01:50:00 | ES | Futures | 3189.18 | 3189.72 | 3188.91 | 3188.91 | 600.0 |
| 2019-06-20 01:55:00 | ES | Futures | 3189.18 | 3189.18 | 3188.36 | 3188.64 | 782.0 |
| 2019-06-20 02:00:00 | ES | Futures | 3188.64 | 3188.91 | 3187.82 | 3188.91 | 1475.0 |
| 2019-06-20 02:05:00 | ES | Futures | 3188.91 | 3190.8 | 3188.91 | 3189.99 | 2192.0 |
| 2019-06-20 02:10:00 | ES | Futures | 3189.99 | 3190.26 | 3189.72 | 3189.99 | 910.0 |
| 2019-06-20 02:15:00 | ES | Futures | 3189.99 | 3190.8 | 3189.99 | 3190.53 | 1095.0 |
| 2019-06-20 02:20:00 | ES | Futures | 3190.53 | 3191.34 | 3190.26 | 3190.8 | 1580.0 |
| 2019-06-20 02:25:00 | ES | Futures | 3190.8 | 3192.7 | 3190.8 | 3192.7 | 2736.0 |
| 2019-06-20 02:30:00 | ES | Futures | 3192.42 | 3193.78 | 3192.15 | 3192.7 | 2109.0 |
| 2019-06-20 02:35:00 | ES | Futures | 3192.7 | 3193.51 | 3192.15 | 3193.24 | 1094.0 |
| 2019-06-20 02:40:00 | ES | Futures | 3193.24 | 3194.05 | 3192.7 | 3193.78 | 1143.0 |
| 2019-06-20 02:45:00 | ES | Futures | 3193.78 | 3194.59 | 3193.51 | 3194.32 | 2692.0 |
| 2019-06-20 02:50:00 | ES | Futures | 3194.05 | 3194.32 | 3193.51 | 3194.32 | 1361.0 |
| 2019-06-20 02:55:00 | ES | Futures | 3194.32 | 3194.32 | 3193.51 | 3193.51 | 1054.0 |
| 2019-06-20 03:00:00 | ES | Futures | 3193.51 | 3194.59 | 3193.51 | 3194.32 | 3819.0 |
| 2019-06-20 03:05:00 | ES | Futures | 3194.32 | 3194.59 | 3193.78 | 3194.32 | 4285.0 |
| 2019-06-20 03:10:00 | ES | Futures | 3194.32 | 3195.94 | 3194.32 | 3195.13 | 3740.0 |
| 2019-06-20 03:15:00 | ES | Futures | 3195.13 | 3196.49 | 3194.86 | 3195.13 | 3862.0 |
| 2019-06-20 03:20:00 | ES | Futures | 3195.13 | 3195.67 | 3194.59 | 3195.4 | 2112.0 |
| 2019-06-20 03:25:00 | ES | Futures | 3195.67 | 3197.03 | 3195.4 | 3196.21 | 2332.0 |
| 2019-06-20 03:30:00 | ES | Futures | 3195.94 | 3196.76 | 3195.67 | 3195.94 | 3385.0 |
| 2019-06-20 03:35:00 | ES | Futures | 3196.21 | 3197.03 | 3195.67 | 3195.94 | 2065.0 |
| 2019-06-20 03:40:00 | ES | Futures | 3195.94 | 3197.03 | 3195.67 | 3196.21 | 1622.0 |
| 2019-06-20 03:45:00 | ES | Futures | 3195.94 | 3197.57 | 3195.13 | 3195.4 | 3497.0 |
| 2019-06-20 03:50:00 | ES | Futures | 3195.67 | 3195.94 | 3194.59 | 3195.67 | 3043.0 |
| 2019-06-20 03:55:00 | ES | Futures | 3195.67 | 3195.67 | 3194.59 | 3195.13 | 1288.0 |
| 2019-06-20 04:00:00 | ES | Futures | 3194.86 | 3195.67 | 3194.59 | 3195.4 | 1530.0 |
| 2019-06-20 04:05:00 | ES | Futures | 3195.13 | 3196.21 | 3195.13 | 3195.94 | 1183.0 |
> showing 50 of 18,032 rows — these rows as CSV