PREVIEW / futures_1min / 2017-09-24
file: by_date/futures_1min/2017/2017-09-24.parquet size: 99 KB rows: 8,705
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-09-24 18:00:00 | ES | Futures | 2734.49 | 2734.77 | 2732.85 | 2734.77 | 1901.0 |
| 2017-09-24 18:01:00 | ES | Futures | 2734.49 | 2734.77 | 2733.94 | 2733.94 | 228.0 |
| 2017-09-24 18:02:00 | ES | Futures | 2734.22 | 2734.22 | 2733.67 | 2733.94 | 319.0 |
| 2017-09-24 18:03:00 | ES | Futures | 2733.94 | 2734.22 | 2733.4 | 2734.22 | 263.0 |
| 2017-09-24 18:04:00 | ES | Futures | 2734.22 | 2734.49 | 2734.22 | 2734.22 | 116.0 |
| 2017-09-24 18:05:00 | ES | Futures | 2734.22 | 2734.77 | 2734.22 | 2734.77 | 249.0 |
| 2017-09-24 18:06:00 | ES | Futures | 2735.04 | 2735.04 | 2734.49 | 2734.77 | 116.0 |
| 2017-09-24 18:07:00 | ES | Futures | 2734.77 | 2735.04 | 2734.77 | 2734.77 | 36.0 |
| 2017-09-24 18:08:00 | ES | Futures | 2734.49 | 2735.86 | 2734.49 | 2735.86 | 400.0 |
| 2017-09-24 18:09:00 | ES | Futures | 2735.86 | 2736.68 | 2735.86 | 2735.86 | 754.0 |
| 2017-09-24 18:10:00 | ES | Futures | 2735.86 | 2735.86 | 2735.31 | 2735.59 | 131.0 |
| 2017-09-24 18:11:00 | ES | Futures | 2735.86 | 2735.86 | 2735.04 | 2735.31 | 106.0 |
| 2017-09-24 18:12:00 | ES | Futures | 2735.31 | 2735.86 | 2735.31 | 2735.59 | 140.0 |
| 2017-09-24 18:13:00 | ES | Futures | 2735.31 | 2735.59 | 2735.31 | 2735.59 | 27.0 |
| 2017-09-24 18:14:00 | ES | Futures | 2735.86 | 2736.13 | 2735.86 | 2736.13 | 70.0 |
| 2017-09-24 18:15:00 | ES | Futures | 2735.86 | 2736.41 | 2735.86 | 2736.41 | 155.0 |
| 2017-09-24 18:16:00 | ES | Futures | 2736.41 | 2736.95 | 2736.13 | 2736.68 | 321.0 |
| 2017-09-24 18:17:00 | ES | Futures | 2736.41 | 2736.68 | 2735.86 | 2736.13 | 336.0 |
| 2017-09-24 18:18:00 | ES | Futures | 2736.41 | 2736.41 | 2736.41 | 2736.41 | 40.0 |
| 2017-09-24 18:19:00 | ES | Futures | 2736.41 | 2736.68 | 2736.41 | 2736.41 | 52.0 |
| 2017-09-24 18:20:00 | ES | Futures | 2736.41 | 2736.68 | 2736.13 | 2736.68 | 171.0 |
| 2017-09-24 18:21:00 | ES | Futures | 2736.68 | 2737.5 | 2736.68 | 2736.95 | 419.0 |
| 2017-09-24 18:22:00 | ES | Futures | 2736.95 | 2737.23 | 2736.68 | 2736.68 | 52.0 |
| 2017-09-24 18:23:00 | ES | Futures | 2736.68 | 2737.23 | 2736.68 | 2737.23 | 63.0 |
| 2017-09-24 18:24:00 | ES | Futures | 2737.23 | 2737.23 | 2736.95 | 2736.95 | 55.0 |
| 2017-09-24 18:25:00 | ES | Futures | 2736.95 | 2736.95 | 2736.68 | 2736.68 | 59.0 |
| 2017-09-24 18:26:00 | ES | Futures | 2736.68 | 2736.68 | 2736.68 | 2736.68 | 61.0 |
| 2017-09-24 18:27:00 | ES | Futures | 2736.41 | 2736.68 | 2736.41 | 2736.68 | 4.0 |
| 2017-09-24 18:28:00 | ES | Futures | 2736.68 | 2736.68 | 2736.41 | 2736.41 | 10.0 |
| 2017-09-24 18:29:00 | ES | Futures | 2736.41 | 2736.68 | 2736.41 | 2736.68 | 71.0 |
| 2017-09-24 18:30:00 | ES | Futures | 2736.68 | 2736.95 | 2736.41 | 2736.41 | 95.0 |
| 2017-09-24 18:31:00 | ES | Futures | 2736.41 | 2736.68 | 2736.41 | 2736.68 | 5.0 |
| 2017-09-24 18:32:00 | ES | Futures | 2736.68 | 2736.68 | 2736.41 | 2736.68 | 54.0 |
| 2017-09-24 18:33:00 | ES | Futures | 2736.68 | 2736.68 | 2736.68 | 2736.68 | 7.0 |
| 2017-09-24 18:34:00 | ES | Futures | 2736.68 | 2736.95 | 2736.68 | 2736.95 | 6.0 |
| 2017-09-24 18:35:00 | ES | Futures | 2736.95 | 2736.95 | 2736.95 | 2736.95 | 4.0 |
| 2017-09-24 18:36:00 | ES | Futures | 2736.95 | 2736.95 | 2736.95 | 2736.95 | 3.0 |
| 2017-09-24 18:37:00 | ES | Futures | 2736.95 | 2736.95 | 2736.68 | 2736.68 | 75.0 |
| 2017-09-24 18:38:00 | ES | Futures | 2736.68 | 2736.68 | 2736.41 | 2736.41 | 2.0 |
| 2017-09-24 18:39:00 | ES | Futures | 2736.41 | 2736.95 | 2736.41 | 2736.68 | 64.0 |
| 2017-09-24 18:40:00 | ES | Futures | 2736.68 | 2736.68 | 2736.68 | 2736.68 | 1.0 |
| 2017-09-24 18:41:00 | ES | Futures | 2736.95 | 2736.95 | 2736.68 | 2736.95 | 4.0 |
| 2017-09-24 18:42:00 | ES | Futures | 2736.68 | 2736.95 | 2736.41 | 2736.95 | 83.0 |
| 2017-09-24 18:43:00 | ES | Futures | 2736.68 | 2736.95 | 2736.68 | 2736.95 | 7.0 |
| 2017-09-24 18:44:00 | ES | Futures | 2736.68 | 2736.95 | 2736.68 | 2736.68 | 7.0 |
| 2017-09-24 18:45:00 | ES | Futures | 2736.68 | 2736.95 | 2736.68 | 2736.68 | 9.0 |
| 2017-09-24 18:46:00 | ES | Futures | 2736.68 | 2736.68 | 2736.68 | 2736.68 | 12.0 |
| 2017-09-24 18:47:00 | ES | Futures | 2736.68 | 2736.95 | 2736.68 | 2736.95 | 7.0 |
| 2017-09-24 18:48:00 | ES | Futures | 2736.95 | 2736.95 | 2736.95 | 2736.95 | 128.0 |
| 2017-09-24 18:49:00 | ES | Futures | 2736.95 | 2736.95 | 2736.95 | 2736.95 | 25.0 |
> showing 50 of 8,705 rows — these rows as CSV