PREVIEW / futures_1min / 2012-08-19
file: by_date/futures_1min/2012/2012-08-19.parquet size: 65 KB rows: 5,670
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-19 18:00:00 | ES | Futures | 1439.24 | 1440.77 | 1438.99 | 1440.01 | 2310.0 |
| 2012-08-19 18:01:00 | ES | Futures | 1440.26 | 1441.79 | 1440.01 | 1441.02 | 1243.0 |
| 2012-08-19 18:02:00 | ES | Futures | 1441.02 | 1441.53 | 1440.77 | 1441.28 | 1132.0 |
| 2012-08-19 18:03:00 | ES | Futures | 1441.28 | 1441.79 | 1441.28 | 1441.79 | 168.0 |
| 2012-08-19 18:04:00 | ES | Futures | 1441.53 | 1441.79 | 1441.28 | 1441.28 | 255.0 |
| 2012-08-19 18:05:00 | ES | Futures | 1441.28 | 1441.53 | 1440.77 | 1440.77 | 472.0 |
| 2012-08-19 18:06:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1440.77 | 367.0 |
| 2012-08-19 18:07:00 | ES | Futures | 1440.52 | 1440.52 | 1440.26 | 1440.26 | 187.0 |
| 2012-08-19 18:08:00 | ES | Futures | 1440.26 | 1440.52 | 1440.26 | 1440.26 | 48.0 |
| 2012-08-19 18:09:00 | ES | Futures | 1440.52 | 1441.02 | 1440.52 | 1441.02 | 253.0 |
| 2012-08-19 18:10:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1440.77 | 77.0 |
| 2012-08-19 18:11:00 | ES | Futures | 1440.52 | 1440.77 | 1440.52 | 1440.77 | 52.0 |
| 2012-08-19 18:12:00 | ES | Futures | 1440.77 | 1440.77 | 1440.77 | 1440.77 | 31.0 |
| 2012-08-19 18:13:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 37.0 |
| 2012-08-19 18:14:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 20.0 |
| 2012-08-19 18:15:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1441.02 | 11.0 |
| 2012-08-19 18:16:00 | ES | Futures | 1441.02 | 1441.02 | 1440.77 | 1440.77 | 13.0 |
| 2012-08-19 18:17:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1441.02 | 33.0 |
| 2012-08-19 18:18:00 | ES | Futures | 1441.02 | 1441.02 | 1441.02 | 1441.02 | 1.0 |
| 2012-08-19 18:19:00 | ES | Futures | 1440.77 | 1440.77 | 1440.77 | 1440.77 | 3.0 |
| 2012-08-19 18:20:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 4.0 |
| 2012-08-19 18:21:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 6.0 |
| 2012-08-19 18:22:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 14.0 |
| 2012-08-19 18:23:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 30.0 |
| 2012-08-19 18:24:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1441.02 | 121.0 |
| 2012-08-19 18:25:00 | ES | Futures | 1441.02 | 1441.02 | 1440.77 | 1440.77 | 116.0 |
| 2012-08-19 18:26:00 | ES | Futures | 1441.02 | 1441.02 | 1440.77 | 1440.77 | 130.0 |
| 2012-08-19 18:27:00 | ES | Futures | 1440.77 | 1440.77 | 1440.52 | 1440.77 | 31.0 |
| 2012-08-19 18:28:00 | ES | Futures | 1440.77 | 1440.77 | 1440.77 | 1440.77 | 168.0 |
| 2012-08-19 18:29:00 | ES | Futures | 1440.77 | 1440.77 | 1440.77 | 1440.77 | 21.0 |
| 2012-08-19 18:30:00 | ES | Futures | 1440.77 | 1440.77 | 1440.52 | 1440.52 | 19.0 |
| 2012-08-19 18:31:00 | ES | Futures | 1440.77 | 1440.77 | 1440.52 | 1440.52 | 13.0 |
| 2012-08-19 18:32:00 | ES | Futures | 1440.52 | 1440.52 | 1440.01 | 1440.26 | 425.0 |
| 2012-08-19 18:33:00 | ES | Futures | 1440.26 | 1440.52 | 1440.26 | 1440.26 | 30.0 |
| 2012-08-19 18:34:00 | ES | Futures | 1440.26 | 1440.26 | 1440.01 | 1440.01 | 8.0 |
| 2012-08-19 18:35:00 | ES | Futures | 1440.01 | 1440.26 | 1440.01 | 1440.26 | 5.0 |
| 2012-08-19 18:36:00 | ES | Futures | 1440.26 | 1440.26 | 1440.26 | 1440.26 | 3.0 |
| 2012-08-19 18:37:00 | ES | Futures | 1440.26 | 1440.26 | 1439.5 | 1439.5 | 845.0 |
| 2012-08-19 18:38:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.75 | 36.0 |
| 2012-08-19 18:39:00 | ES | Futures | 1439.75 | 1439.75 | 1439.24 | 1439.5 | 638.0 |
| 2012-08-19 18:40:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.75 | 36.0 |
| 2012-08-19 18:41:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.5 | 11.0 |
| 2012-08-19 18:42:00 | ES | Futures | 1439.5 | 1439.5 | 1439.5 | 1439.5 | 15.0 |
| 2012-08-19 18:43:00 | ES | Futures | 1439.5 | 1439.5 | 1439.5 | 1439.5 | 7.0 |
| 2012-08-19 18:44:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.75 | 23.0 |
| 2012-08-19 18:45:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.5 | 66.0 |
| 2012-08-19 18:46:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.75 | 38.0 |
| 2012-08-19 18:47:00 | ES | Futures | 1439.5 | 1439.5 | 1439.5 | 1439.5 | 25.0 |
| 2012-08-19 18:48:00 | ES | Futures | 1439.75 | 1439.75 | 1439.75 | 1439.75 | 6.0 |
| 2012-08-19 18:49:00 | ES | Futures | 1439.75 | 1439.75 | 1439.75 | 1439.75 | 1.0 |
> showing 50 of 5,670 rows — these rows as CSV