PREVIEW / futures_1min / 2017-10-29
file: by_date/futures_1min/2017/2017-10-29.parquet size: 107 KB rows: 9,880
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-29 18:00:00 | ES | Futures | 2818.2 | 2819.57 | 2817.38 | 2818.75 | 2496.0 |
| 2017-10-29 18:01:00 | ES | Futures | 2819.02 | 2819.02 | 2818.75 | 2819.02 | 266.0 |
| 2017-10-29 18:02:00 | ES | Futures | 2819.02 | 2819.02 | 2818.75 | 2819.02 | 173.0 |
| 2017-10-29 18:03:00 | ES | Futures | 2818.75 | 2819.02 | 2818.75 | 2818.75 | 38.0 |
| 2017-10-29 18:04:00 | ES | Futures | 2818.75 | 2818.75 | 2818.47 | 2818.75 | 168.0 |
| 2017-10-29 18:05:00 | ES | Futures | 2819.02 | 2819.02 | 2818.75 | 2819.02 | 15.0 |
| 2017-10-29 18:06:00 | ES | Futures | 2819.02 | 2819.02 | 2818.75 | 2819.02 | 209.0 |
| 2017-10-29 18:07:00 | ES | Futures | 2819.02 | 2819.29 | 2819.02 | 2819.29 | 5.0 |
| 2017-10-29 18:08:00 | ES | Futures | 2819.29 | 2819.57 | 2819.02 | 2819.57 | 334.0 |
| 2017-10-29 18:09:00 | ES | Futures | 2819.57 | 2819.84 | 2819.57 | 2819.57 | 32.0 |
| 2017-10-29 18:10:00 | ES | Futures | 2819.57 | 2819.84 | 2819.57 | 2819.84 | 31.0 |
| 2017-10-29 18:11:00 | ES | Futures | 2819.84 | 2820.12 | 2819.57 | 2819.84 | 367.0 |
| 2017-10-29 18:12:00 | ES | Futures | 2820.12 | 2820.39 | 2819.84 | 2819.84 | 135.0 |
| 2017-10-29 18:13:00 | ES | Futures | 2820.12 | 2820.12 | 2819.84 | 2820.12 | 75.0 |
| 2017-10-29 18:14:00 | ES | Futures | 2820.12 | 2820.66 | 2820.12 | 2820.39 | 270.0 |
| 2017-10-29 18:15:00 | ES | Futures | 2820.66 | 2820.94 | 2820.39 | 2820.66 | 397.0 |
| 2017-10-29 18:16:00 | ES | Futures | 2820.66 | 2820.94 | 2820.66 | 2820.94 | 288.0 |
| 2017-10-29 18:17:00 | ES | Futures | 2820.94 | 2821.21 | 2820.66 | 2821.21 | 251.0 |
| 2017-10-29 18:18:00 | ES | Futures | 2821.21 | 2821.21 | 2820.66 | 2820.94 | 104.0 |
| 2017-10-29 18:19:00 | ES | Futures | 2820.94 | 2820.94 | 2820.12 | 2820.12 | 390.0 |
| 2017-10-29 18:20:00 | ES | Futures | 2820.12 | 2820.39 | 2819.57 | 2820.12 | 309.0 |
| 2017-10-29 18:21:00 | ES | Futures | 2820.12 | 2820.12 | 2820.12 | 2820.12 | 12.0 |
| 2017-10-29 18:22:00 | ES | Futures | 2820.12 | 2820.12 | 2820.12 | 2820.12 | 25.0 |
| 2017-10-29 18:23:00 | ES | Futures | 2820.12 | 2820.39 | 2820.12 | 2820.39 | 87.0 |
| 2017-10-29 18:24:00 | ES | Futures | 2820.39 | 2820.66 | 2820.39 | 2820.66 | 54.0 |
| 2017-10-29 18:25:00 | ES | Futures | 2820.66 | 2820.66 | 2820.39 | 2820.66 | 20.0 |
| 2017-10-29 18:26:00 | ES | Futures | 2820.39 | 2820.39 | 2820.12 | 2820.12 | 141.0 |
| 2017-10-29 18:27:00 | ES | Futures | 2819.84 | 2820.12 | 2819.84 | 2820.12 | 176.0 |
| 2017-10-29 18:28:00 | ES | Futures | 2820.12 | 2820.12 | 2819.84 | 2819.84 | 62.0 |
| 2017-10-29 18:29:00 | ES | Futures | 2820.12 | 2820.12 | 2819.84 | 2819.84 | 3.0 |
| 2017-10-29 18:30:00 | ES | Futures | 2819.84 | 2820.12 | 2819.84 | 2819.84 | 110.0 |
| 2017-10-29 18:31:00 | ES | Futures | 2819.84 | 2819.84 | 2819.84 | 2819.84 | 72.0 |
| 2017-10-29 18:32:00 | ES | Futures | 2819.84 | 2820.12 | 2819.57 | 2819.57 | 37.0 |
| 2017-10-29 18:33:00 | ES | Futures | 2819.57 | 2819.57 | 2819.57 | 2819.57 | 10.0 |
| 2017-10-29 18:34:00 | ES | Futures | 2819.57 | 2819.57 | 2819.57 | 2819.57 | 7.0 |
| 2017-10-29 18:35:00 | ES | Futures | 2819.84 | 2819.84 | 2819.57 | 2819.57 | 36.0 |
| 2017-10-29 18:36:00 | ES | Futures | 2819.84 | 2819.84 | 2819.57 | 2819.57 | 13.0 |
| 2017-10-29 18:37:00 | ES | Futures | 2819.84 | 2819.84 | 2819.84 | 2819.84 | 2.0 |
| 2017-10-29 18:38:00 | ES | Futures | 2819.57 | 2819.84 | 2819.57 | 2819.84 | 19.0 |
| 2017-10-29 18:39:00 | ES | Futures | 2819.84 | 2819.84 | 2819.57 | 2819.57 | 25.0 |
| 2017-10-29 18:40:00 | ES | Futures | 2819.57 | 2819.57 | 2819.29 | 2819.29 | 70.0 |
| 2017-10-29 18:41:00 | ES | Futures | 2819.29 | 2819.29 | 2819.02 | 2819.02 | 362.0 |
| 2017-10-29 18:42:00 | ES | Futures | 2819.02 | 2819.29 | 2819.02 | 2819.02 | 44.0 |
| 2017-10-29 18:43:00 | ES | Futures | 2819.02 | 2819.02 | 2819.02 | 2819.02 | 65.0 |
| 2017-10-29 18:44:00 | ES | Futures | 2819.02 | 2819.02 | 2819.02 | 2819.02 | 13.0 |
| 2017-10-29 18:45:00 | ES | Futures | 2819.02 | 2819.02 | 2819.02 | 2819.02 | 8.0 |
| 2017-10-29 18:46:00 | ES | Futures | 2819.29 | 2819.29 | 2818.75 | 2818.75 | 47.0 |
| 2017-10-29 18:47:00 | ES | Futures | 2818.75 | 2819.02 | 2818.75 | 2819.02 | 103.0 |
| 2017-10-29 18:48:00 | ES | Futures | 2819.02 | 2819.29 | 2819.02 | 2819.02 | 39.0 |
| 2017-10-29 18:49:00 | ES | Futures | 2819.02 | 2819.02 | 2818.75 | 2818.75 | 13.0 |
> showing 50 of 9,880 rows — these rows as CSV