PREVIEW / futures_1min / 2017-11-24
file: by_date/futures_1min/2017/2017-11-24.parquet size: 432 KB rows: 39,826
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-24 00:00:00 | ES | Futures | 2842.82 | 2842.82 | 2842.55 | 2842.55 | 8.0 |
| 2017-11-24 00:01:00 | ES | Futures | 2842.55 | 2842.55 | 2842.55 | 2842.55 | 41.0 |
| 2017-11-24 00:02:00 | ES | Futures | 2842.55 | 2842.55 | 2842.55 | 2842.55 | 10.0 |
| 2017-11-24 00:03:00 | ES | Futures | 2842.55 | 2842.55 | 2842.27 | 2842.27 | 123.0 |
| 2017-11-24 00:04:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 40.0 |
| 2017-11-24 00:05:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.27 | 10.0 |
| 2017-11-24 00:07:00 | ES | Futures | 2842.55 | 2842.55 | 2842.27 | 2842.27 | 27.0 |
| 2017-11-24 00:08:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 7.0 |
| 2017-11-24 00:11:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 46.0 |
| 2017-11-24 00:12:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 3.0 |
| 2017-11-24 00:13:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 3.0 |
| 2017-11-24 00:14:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.0 | 63.0 |
| 2017-11-24 00:17:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 138.0 |
| 2017-11-24 00:18:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 1.0 |
| 2017-11-24 00:19:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 24.0 |
| 2017-11-24 00:20:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 26.0 |
| 2017-11-24 00:21:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 2.0 |
| 2017-11-24 00:22:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 2.0 |
| 2017-11-24 00:23:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 52.0 |
| 2017-11-24 00:24:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 2.0 |
| 2017-11-24 00:25:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 3.0 |
| 2017-11-24 00:26:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 2.0 |
| 2017-11-24 00:27:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 2.0 |
| 2017-11-24 00:28:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 2.0 |
| 2017-11-24 00:29:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.0 | 5.0 |
| 2017-11-24 00:33:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 114.0 |
| 2017-11-24 00:34:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.27 | 9.0 |
| 2017-11-24 00:35:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 83.0 |
| 2017-11-24 00:36:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 110.0 |
| 2017-11-24 00:37:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 34.0 |
| 2017-11-24 00:39:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.27 | 41.0 |
| 2017-11-24 00:40:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 8.0 |
| 2017-11-24 00:41:00 | ES | Futures | 2842.27 | 2842.27 | 2842.27 | 2842.27 | 71.0 |
| 2017-11-24 00:42:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 286.0 |
| 2017-11-24 00:43:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 107.0 |
| 2017-11-24 00:44:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.0 | 58.0 |
| 2017-11-24 00:45:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 41.0 |
| 2017-11-24 00:46:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.0 | 33.0 |
| 2017-11-24 00:47:00 | ES | Futures | 2842.0 | 2842.27 | 2842.0 | 2842.0 | 88.0 |
| 2017-11-24 00:48:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 32.0 |
| 2017-11-24 00:49:00 | ES | Futures | 2842.27 | 2842.27 | 2842.0 | 2842.0 | 44.0 |
| 2017-11-24 00:50:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 23.0 |
| 2017-11-24 00:51:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 3.0 |
| 2017-11-24 00:52:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 13.0 |
| 2017-11-24 00:53:00 | ES | Futures | 2842.0 | 2842.0 | 2842.0 | 2842.0 | 4.0 |
| 2017-11-24 00:54:00 | ES | Futures | 2842.0 | 2842.0 | 2841.73 | 2841.73 | 103.0 |
| 2017-11-24 00:55:00 | ES | Futures | 2841.73 | 2841.73 | 2841.73 | 2841.73 | 17.0 |
| 2017-11-24 00:56:00 | ES | Futures | 2841.73 | 2841.73 | 2841.73 | 2841.73 | 26.0 |
| 2017-11-24 00:57:00 | ES | Futures | 2841.73 | 2842.0 | 2841.45 | 2841.73 | 110.0 |
| 2017-11-24 00:58:00 | ES | Futures | 2841.73 | 2841.73 | 2841.45 | 2841.45 | 356.0 |
> showing 50 of 39,826 rows — these rows as CSV