PREVIEW / futures_1min / 2017-10-20
file: by_date/futures_1min/2017/2017-10-20.parquet size: 570 KB rows: 52,500
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-10-20 00:00:00 | ES | Futures | 2810.27 | 2810.54 | 2810.27 | 2810.54 | 159.0 |
| 2017-10-20 00:01:00 | ES | Futures | 2810.27 | 2810.27 | 2810.27 | 2810.27 | 21.0 |
| 2017-10-20 00:02:00 | ES | Futures | 2810.54 | 2810.54 | 2810.27 | 2810.27 | 35.0 |
| 2017-10-20 00:03:00 | ES | Futures | 2810.27 | 2810.54 | 2810.27 | 2810.27 | 22.0 |
| 2017-10-20 00:04:00 | ES | Futures | 2810.27 | 2810.54 | 2810.27 | 2810.54 | 19.0 |
| 2017-10-20 00:05:00 | ES | Futures | 2810.27 | 2810.54 | 2809.99 | 2810.27 | 116.0 |
| 2017-10-20 00:06:00 | ES | Futures | 2810.27 | 2810.27 | 2810.27 | 2810.27 | 11.0 |
| 2017-10-20 00:07:00 | ES | Futures | 2810.27 | 2810.27 | 2810.27 | 2810.27 | 1.0 |
| 2017-10-20 00:08:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 12.0 |
| 2017-10-20 00:09:00 | ES | Futures | 2809.99 | 2809.99 | 2809.99 | 2809.99 | 11.0 |
| 2017-10-20 00:10:00 | ES | Futures | 2810.27 | 2810.27 | 2809.99 | 2809.99 | 16.0 |
| 2017-10-20 00:11:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 12.0 |
| 2017-10-20 00:12:00 | ES | Futures | 2810.27 | 2810.27 | 2810.27 | 2810.27 | 6.0 |
| 2017-10-20 00:13:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2809.99 | 13.0 |
| 2017-10-20 00:14:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 10.0 |
| 2017-10-20 00:15:00 | ES | Futures | 2810.27 | 2810.27 | 2809.99 | 2809.99 | 29.0 |
| 2017-10-20 00:16:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 10.0 |
| 2017-10-20 00:17:00 | ES | Futures | 2809.99 | 2809.99 | 2809.72 | 2809.99 | 248.0 |
| 2017-10-20 00:18:00 | ES | Futures | 2809.99 | 2809.99 | 2809.72 | 2809.99 | 6.0 |
| 2017-10-20 00:19:00 | ES | Futures | 2809.72 | 2809.99 | 2809.72 | 2809.99 | 18.0 |
| 2017-10-20 00:20:00 | ES | Futures | 2809.72 | 2809.99 | 2809.72 | 2809.99 | 34.0 |
| 2017-10-20 00:21:00 | ES | Futures | 2809.72 | 2810.27 | 2809.72 | 2810.27 | 104.0 |
| 2017-10-20 00:22:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 20.0 |
| 2017-10-20 00:23:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2809.99 | 25.0 |
| 2017-10-20 00:24:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 12.0 |
| 2017-10-20 00:25:00 | ES | Futures | 2809.99 | 2810.27 | 2809.99 | 2810.27 | 14.0 |
| 2017-10-20 00:26:00 | ES | Futures | 2810.27 | 2810.27 | 2809.99 | 2809.99 | 364.0 |
| 2017-10-20 00:27:00 | ES | Futures | 2809.99 | 2809.99 | 2809.72 | 2809.72 | 1478.0 |
| 2017-10-20 00:28:00 | ES | Futures | 2809.72 | 2809.99 | 2809.45 | 2809.45 | 350.0 |
| 2017-10-20 00:29:00 | ES | Futures | 2809.72 | 2809.72 | 2809.45 | 2809.45 | 169.0 |
| 2017-10-20 00:30:00 | ES | Futures | 2809.45 | 2809.72 | 2809.45 | 2809.45 | 169.0 |
| 2017-10-20 00:31:00 | ES | Futures | 2809.45 | 2809.45 | 2808.9 | 2809.17 | 630.0 |
| 2017-10-20 00:32:00 | ES | Futures | 2809.17 | 2809.17 | 2808.9 | 2809.17 | 146.0 |
| 2017-10-20 00:33:00 | ES | Futures | 2808.9 | 2809.17 | 2808.9 | 2809.17 | 63.0 |
| 2017-10-20 00:34:00 | ES | Futures | 2808.9 | 2809.17 | 2808.63 | 2808.9 | 484.0 |
| 2017-10-20 00:35:00 | ES | Futures | 2808.9 | 2808.9 | 2808.9 | 2808.9 | 4.0 |
| 2017-10-20 00:36:00 | ES | Futures | 2809.17 | 2809.17 | 2808.9 | 2808.9 | 24.0 |
| 2017-10-20 00:37:00 | ES | Futures | 2808.9 | 2809.17 | 2808.9 | 2808.9 | 6.0 |
| 2017-10-20 00:38:00 | ES | Futures | 2808.9 | 2809.17 | 2808.9 | 2809.17 | 95.0 |
| 2017-10-20 00:39:00 | ES | Futures | 2809.45 | 2809.45 | 2809.17 | 2809.17 | 304.0 |
| 2017-10-20 00:40:00 | ES | Futures | 2809.45 | 2809.45 | 2809.17 | 2809.17 | 157.0 |
| 2017-10-20 00:41:00 | ES | Futures | 2809.17 | 2809.17 | 2809.17 | 2809.17 | 283.0 |
| 2017-10-20 00:42:00 | ES | Futures | 2809.17 | 2809.17 | 2809.17 | 2809.17 | 13.0 |
| 2017-10-20 00:43:00 | ES | Futures | 2808.9 | 2809.17 | 2808.9 | 2808.9 | 226.0 |
| 2017-10-20 00:44:00 | ES | Futures | 2808.9 | 2808.9 | 2808.9 | 2808.9 | 75.0 |
| 2017-10-20 00:45:00 | ES | Futures | 2808.63 | 2808.9 | 2808.63 | 2808.63 | 379.0 |
| 2017-10-20 00:46:00 | ES | Futures | 2808.9 | 2808.9 | 2808.63 | 2808.9 | 74.0 |
| 2017-10-20 00:47:00 | ES | Futures | 2808.9 | 2808.9 | 2808.63 | 2808.9 | 17.0 |
| 2017-10-20 00:48:00 | ES | Futures | 2808.9 | 2808.9 | 2808.63 | 2808.9 | 57.0 |
| 2017-10-20 00:49:00 | ES | Futures | 2808.9 | 2808.9 | 2808.63 | 2808.9 | 13.0 |
> showing 50 of 52,500 rows — these rows as CSV