PREVIEW / futures_1min / 2017-08-27
file: by_date/futures_1min/2017/2017-08-27.parquet size: 100 KB rows: 8,538
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-08-27 18:00:00 | ES | Futures | 2669.98 | 2670.25 | 2665.33 | 2666.7 | 1967.0 |
| 2017-08-27 18:01:00 | ES | Futures | 2666.97 | 2666.97 | 2665.06 | 2665.33 | 687.0 |
| 2017-08-27 18:02:00 | ES | Futures | 2665.33 | 2666.7 | 2665.33 | 2666.15 | 460.0 |
| 2017-08-27 18:03:00 | ES | Futures | 2666.42 | 2666.97 | 2666.15 | 2666.97 | 170.0 |
| 2017-08-27 18:04:00 | ES | Futures | 2666.97 | 2667.52 | 2666.97 | 2667.52 | 130.0 |
| 2017-08-27 18:05:00 | ES | Futures | 2667.52 | 2667.79 | 2667.24 | 2667.24 | 279.0 |
| 2017-08-27 18:06:00 | ES | Futures | 2667.52 | 2668.06 | 2667.24 | 2668.06 | 193.0 |
| 2017-08-27 18:07:00 | ES | Futures | 2667.79 | 2668.34 | 2667.79 | 2668.34 | 146.0 |
| 2017-08-27 18:08:00 | ES | Futures | 2668.34 | 2668.34 | 2667.79 | 2668.06 | 56.0 |
| 2017-08-27 18:09:00 | ES | Futures | 2668.06 | 2668.06 | 2666.97 | 2667.24 | 370.0 |
| 2017-08-27 18:10:00 | ES | Futures | 2667.24 | 2667.24 | 2666.97 | 2666.97 | 146.0 |
| 2017-08-27 18:11:00 | ES | Futures | 2666.97 | 2666.97 | 2666.15 | 2666.42 | 258.0 |
| 2017-08-27 18:12:00 | ES | Futures | 2666.42 | 2666.7 | 2666.42 | 2666.7 | 131.0 |
| 2017-08-27 18:13:00 | ES | Futures | 2666.7 | 2666.97 | 2666.42 | 2666.97 | 227.0 |
| 2017-08-27 18:14:00 | ES | Futures | 2666.97 | 2667.24 | 2666.7 | 2667.24 | 43.0 |
| 2017-08-27 18:15:00 | ES | Futures | 2666.97 | 2667.24 | 2666.97 | 2667.24 | 37.0 |
| 2017-08-27 18:16:00 | ES | Futures | 2667.24 | 2667.52 | 2667.24 | 2667.52 | 51.0 |
| 2017-08-27 18:17:00 | ES | Futures | 2667.52 | 2667.52 | 2667.24 | 2667.52 | 42.0 |
| 2017-08-27 18:18:00 | ES | Futures | 2667.52 | 2667.52 | 2667.52 | 2667.52 | 21.0 |
| 2017-08-27 18:19:00 | ES | Futures | 2667.52 | 2667.52 | 2667.24 | 2667.52 | 16.0 |
| 2017-08-27 18:20:00 | ES | Futures | 2667.52 | 2667.52 | 2667.24 | 2667.52 | 27.0 |
| 2017-08-27 18:21:00 | ES | Futures | 2667.52 | 2667.52 | 2667.24 | 2667.52 | 51.0 |
| 2017-08-27 18:22:00 | ES | Futures | 2667.52 | 2667.52 | 2667.24 | 2667.24 | 88.0 |
| 2017-08-27 18:23:00 | ES | Futures | 2667.24 | 2667.24 | 2666.97 | 2667.24 | 51.0 |
| 2017-08-27 18:24:00 | ES | Futures | 2667.24 | 2667.24 | 2666.97 | 2667.24 | 27.0 |
| 2017-08-27 18:25:00 | ES | Futures | 2667.24 | 2667.24 | 2666.97 | 2667.24 | 59.0 |
| 2017-08-27 18:26:00 | ES | Futures | 2667.24 | 2667.24 | 2666.7 | 2667.24 | 102.0 |
| 2017-08-27 18:27:00 | ES | Futures | 2666.97 | 2667.52 | 2666.97 | 2667.52 | 58.0 |
| 2017-08-27 18:28:00 | ES | Futures | 2667.52 | 2667.52 | 2667.24 | 2667.52 | 12.0 |
| 2017-08-27 18:29:00 | ES | Futures | 2667.52 | 2667.79 | 2667.24 | 2667.79 | 127.0 |
| 2017-08-27 18:30:00 | ES | Futures | 2668.06 | 2668.34 | 2668.06 | 2668.34 | 121.0 |
| 2017-08-27 18:31:00 | ES | Futures | 2668.34 | 2668.61 | 2668.34 | 2668.34 | 106.0 |
| 2017-08-27 18:32:00 | ES | Futures | 2668.34 | 2668.61 | 2668.06 | 2668.34 | 80.0 |
| 2017-08-27 18:33:00 | ES | Futures | 2668.34 | 2668.34 | 2668.06 | 2668.06 | 29.0 |
| 2017-08-27 18:34:00 | ES | Futures | 2668.34 | 2668.34 | 2668.06 | 2668.34 | 43.0 |
| 2017-08-27 18:35:00 | ES | Futures | 2668.34 | 2668.34 | 2667.52 | 2667.79 | 167.0 |
| 2017-08-27 18:36:00 | ES | Futures | 2667.79 | 2668.06 | 2667.52 | 2668.06 | 70.0 |
| 2017-08-27 18:37:00 | ES | Futures | 2668.34 | 2668.61 | 2668.34 | 2668.61 | 112.0 |
| 2017-08-27 18:38:00 | ES | Futures | 2668.88 | 2668.88 | 2668.61 | 2668.61 | 60.0 |
| 2017-08-27 18:39:00 | ES | Futures | 2668.88 | 2669.43 | 2668.88 | 2669.43 | 153.0 |
| 2017-08-27 18:40:00 | ES | Futures | 2669.43 | 2669.43 | 2668.88 | 2668.88 | 77.0 |
| 2017-08-27 18:41:00 | ES | Futures | 2669.16 | 2669.16 | 2669.16 | 2669.16 | 18.0 |
| 2017-08-27 18:42:00 | ES | Futures | 2668.88 | 2669.43 | 2668.88 | 2669.16 | 110.0 |
| 2017-08-27 18:43:00 | ES | Futures | 2668.88 | 2669.7 | 2668.88 | 2669.43 | 289.0 |
| 2017-08-27 18:44:00 | ES | Futures | 2669.7 | 2669.7 | 2669.43 | 2669.7 | 56.0 |
| 2017-08-27 18:45:00 | ES | Futures | 2669.43 | 2669.7 | 2669.43 | 2669.7 | 142.0 |
| 2017-08-27 18:46:00 | ES | Futures | 2669.43 | 2669.7 | 2669.43 | 2669.43 | 184.0 |
| 2017-08-27 18:47:00 | ES | Futures | 2669.43 | 2669.7 | 2669.43 | 2669.43 | 53.0 |
| 2017-08-27 18:48:00 | ES | Futures | 2669.43 | 2669.7 | 2669.43 | 2669.7 | 60.0 |
| 2017-08-27 18:49:00 | ES | Futures | 2669.43 | 2669.7 | 2669.43 | 2669.43 | 27.0 |
> showing 50 of 8,538 rows — these rows as CSV