PREVIEW / futures_1min / 2011-08-28
file: by_date/futures_1min/2011/2011-08-28.parquet size: 92 KB rows: 6,575
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-28 18:00:00 | ES | Futures | 1172.7 | 1173.45 | 1170.96 | 1170.96 | 1567.0 |
| 2011-08-28 18:01:00 | ES | Futures | 1171.21 | 1171.46 | 1170.71 | 1171.21 | 511.0 |
| 2011-08-28 18:02:00 | ES | Futures | 1171.21 | 1171.21 | 1170.71 | 1171.21 | 52.0 |
| 2011-08-28 18:03:00 | ES | Futures | 1170.96 | 1171.21 | 1170.46 | 1170.71 | 433.0 |
| 2011-08-28 18:04:00 | ES | Futures | 1170.71 | 1170.96 | 1170.71 | 1170.96 | 81.0 |
| 2011-08-28 18:05:00 | ES | Futures | 1171.21 | 1171.21 | 1170.21 | 1170.21 | 363.0 |
| 2011-08-28 18:06:00 | ES | Futures | 1170.46 | 1170.96 | 1170.21 | 1170.46 | 97.0 |
| 2011-08-28 18:07:00 | ES | Futures | 1170.71 | 1171.21 | 1170.71 | 1171.21 | 55.0 |
| 2011-08-28 18:08:00 | ES | Futures | 1170.96 | 1171.21 | 1170.71 | 1170.71 | 99.0 |
| 2011-08-28 18:09:00 | ES | Futures | 1170.71 | 1170.71 | 1169.71 | 1170.21 | 319.0 |
| 2011-08-28 18:10:00 | ES | Futures | 1170.46 | 1170.46 | 1169.46 | 1170.21 | 284.0 |
| 2011-08-28 18:11:00 | ES | Futures | 1170.21 | 1170.46 | 1169.96 | 1170.46 | 282.0 |
| 2011-08-28 18:12:00 | ES | Futures | 1170.71 | 1170.71 | 1170.21 | 1170.46 | 863.0 |
| 2011-08-28 18:13:00 | ES | Futures | 1170.46 | 1170.71 | 1170.21 | 1170.71 | 53.0 |
| 2011-08-28 18:14:00 | ES | Futures | 1170.71 | 1170.71 | 1170.46 | 1170.46 | 30.0 |
| 2011-08-28 18:15:00 | ES | Futures | 1170.71 | 1171.71 | 1170.71 | 1171.46 | 340.0 |
| 2011-08-28 18:16:00 | ES | Futures | 1171.21 | 1171.71 | 1171.21 | 1171.46 | 20.0 |
| 2011-08-28 18:17:00 | ES | Futures | 1171.71 | 1171.96 | 1171.46 | 1171.96 | 148.0 |
| 2011-08-28 18:18:00 | ES | Futures | 1171.96 | 1172.46 | 1171.96 | 1172.21 | 122.0 |
| 2011-08-28 18:19:00 | ES | Futures | 1172.21 | 1172.21 | 1171.71 | 1171.96 | 102.0 |
| 2011-08-28 18:20:00 | ES | Futures | 1171.96 | 1172.21 | 1171.96 | 1172.21 | 57.0 |
| 2011-08-28 18:21:00 | ES | Futures | 1172.21 | 1172.46 | 1171.96 | 1172.21 | 212.0 |
| 2011-08-28 18:22:00 | ES | Futures | 1172.21 | 1172.21 | 1172.21 | 1172.21 | 35.0 |
| 2011-08-28 18:23:00 | ES | Futures | 1172.21 | 1172.7 | 1172.21 | 1172.46 | 140.0 |
| 2011-08-28 18:24:00 | ES | Futures | 1172.46 | 1172.7 | 1172.46 | 1172.46 | 156.0 |
| 2011-08-28 18:25:00 | ES | Futures | 1172.46 | 1172.46 | 1172.21 | 1172.46 | 117.0 |
| 2011-08-28 18:26:00 | ES | Futures | 1172.21 | 1172.46 | 1172.21 | 1172.21 | 9.0 |
| 2011-08-28 18:27:00 | ES | Futures | 1172.21 | 1172.46 | 1172.21 | 1172.21 | 40.0 |
| 2011-08-28 18:28:00 | ES | Futures | 1172.21 | 1172.46 | 1172.21 | 1172.21 | 8.0 |
| 2011-08-28 18:29:00 | ES | Futures | 1172.21 | 1173.2 | 1172.21 | 1173.2 | 397.0 |
| 2011-08-28 18:30:00 | ES | Futures | 1173.2 | 1173.7 | 1173.2 | 1173.45 | 205.0 |
| 2011-08-28 18:31:00 | ES | Futures | 1173.45 | 1173.45 | 1172.95 | 1173.2 | 129.0 |
| 2011-08-28 18:32:00 | ES | Futures | 1173.2 | 1174.2 | 1173.2 | 1174.2 | 259.0 |
| 2011-08-28 18:33:00 | ES | Futures | 1174.2 | 1176.94 | 1174.2 | 1175.95 | 1422.0 |
| 2011-08-28 18:34:00 | ES | Futures | 1176.2 | 1176.45 | 1174.95 | 1174.95 | 504.0 |
| 2011-08-28 18:35:00 | ES | Futures | 1175.2 | 1175.2 | 1174.95 | 1175.2 | 421.0 |
| 2011-08-28 18:36:00 | ES | Futures | 1175.2 | 1175.2 | 1174.2 | 1174.2 | 357.0 |
| 2011-08-28 18:37:00 | ES | Futures | 1174.2 | 1174.7 | 1173.7 | 1173.7 | 258.0 |
| 2011-08-28 18:38:00 | ES | Futures | 1173.95 | 1174.2 | 1173.7 | 1174.2 | 74.0 |
| 2011-08-28 18:39:00 | ES | Futures | 1174.2 | 1174.45 | 1174.2 | 1174.45 | 76.0 |
| 2011-08-28 18:40:00 | ES | Futures | 1174.45 | 1174.45 | 1174.2 | 1174.45 | 85.0 |
| 2011-08-28 18:41:00 | ES | Futures | 1174.45 | 1174.45 | 1173.95 | 1174.2 | 32.0 |
| 2011-08-28 18:42:00 | ES | Futures | 1174.2 | 1174.2 | 1173.7 | 1174.2 | 70.0 |
| 2011-08-28 18:43:00 | ES | Futures | 1174.45 | 1174.45 | 1174.2 | 1174.45 | 33.0 |
| 2011-08-28 18:44:00 | ES | Futures | 1174.45 | 1174.45 | 1174.2 | 1174.2 | 86.0 |
| 2011-08-28 18:45:00 | ES | Futures | 1173.95 | 1174.2 | 1173.95 | 1174.2 | 21.0 |
| 2011-08-28 18:46:00 | ES | Futures | 1174.2 | 1174.2 | 1173.7 | 1173.7 | 133.0 |
| 2011-08-28 18:47:00 | ES | Futures | 1173.7 | 1173.7 | 1173.45 | 1173.45 | 49.0 |
| 2011-08-28 18:48:00 | ES | Futures | 1173.45 | 1173.45 | 1173.2 | 1173.2 | 158.0 |
| 2011-08-28 18:49:00 | ES | Futures | 1173.2 | 1173.45 | 1172.7 | 1172.7 | 281.0 |
> showing 50 of 6,575 rows — these rows as CSV