PREVIEW / futures_1min / 2012-06-24
file: by_date/futures_1min/2012/2012-06-24.parquet size: 86 KB rows: 7,018
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-06-24 18:00:00 | ES | Futures | 1348.21 | 1349.23 | 1348.21 | 1348.72 | 988.0 |
| 2012-06-24 18:01:00 | ES | Futures | 1348.97 | 1349.23 | 1348.72 | 1348.97 | 376.0 |
| 2012-06-24 18:02:00 | ES | Futures | 1348.97 | 1348.97 | 1348.72 | 1348.72 | 266.0 |
| 2012-06-24 18:03:00 | ES | Futures | 1348.97 | 1348.97 | 1348.72 | 1348.97 | 329.0 |
| 2012-06-24 18:04:00 | ES | Futures | 1348.97 | 1348.97 | 1348.72 | 1348.97 | 65.0 |
| 2012-06-24 18:05:00 | ES | Futures | 1348.97 | 1348.97 | 1348.72 | 1348.72 | 99.0 |
| 2012-06-24 18:06:00 | ES | Futures | 1348.72 | 1348.72 | 1348.72 | 1348.72 | 92.0 |
| 2012-06-24 18:07:00 | ES | Futures | 1348.97 | 1348.97 | 1348.72 | 1348.97 | 90.0 |
| 2012-06-24 18:08:00 | ES | Futures | 1348.97 | 1348.97 | 1348.97 | 1348.97 | 22.0 |
| 2012-06-24 18:09:00 | ES | Futures | 1348.72 | 1348.97 | 1348.72 | 1348.72 | 110.0 |
| 2012-06-24 18:10:00 | ES | Futures | 1348.72 | 1348.72 | 1346.69 | 1347.19 | 1152.0 |
| 2012-06-24 18:11:00 | ES | Futures | 1347.19 | 1347.7 | 1347.19 | 1347.45 | 208.0 |
| 2012-06-24 18:12:00 | ES | Futures | 1347.45 | 1347.7 | 1347.45 | 1347.45 | 157.0 |
| 2012-06-24 18:13:00 | ES | Futures | 1347.7 | 1347.7 | 1347.45 | 1347.45 | 228.0 |
| 2012-06-24 18:14:00 | ES | Futures | 1347.7 | 1347.7 | 1347.45 | 1347.45 | 36.0 |
| 2012-06-24 18:15:00 | ES | Futures | 1347.45 | 1347.7 | 1347.45 | 1347.45 | 80.0 |
| 2012-06-24 18:16:00 | ES | Futures | 1347.45 | 1347.7 | 1347.45 | 1347.45 | 50.0 |
| 2012-06-24 18:17:00 | ES | Futures | 1347.7 | 1347.7 | 1346.43 | 1346.43 | 578.0 |
| 2012-06-24 18:18:00 | ES | Futures | 1346.69 | 1346.69 | 1345.92 | 1346.18 | 1167.0 |
| 2012-06-24 18:19:00 | ES | Futures | 1346.43 | 1346.43 | 1345.92 | 1346.18 | 126.0 |
| 2012-06-24 18:20:00 | ES | Futures | 1346.18 | 1346.43 | 1345.92 | 1346.18 | 63.0 |
| 2012-06-24 18:21:00 | ES | Futures | 1346.18 | 1346.69 | 1346.18 | 1346.69 | 89.0 |
| 2012-06-24 18:22:00 | ES | Futures | 1346.43 | 1346.69 | 1346.43 | 1346.69 | 17.0 |
| 2012-06-24 18:23:00 | ES | Futures | 1346.69 | 1346.69 | 1345.92 | 1345.92 | 144.0 |
| 2012-06-24 18:24:00 | ES | Futures | 1346.18 | 1346.43 | 1345.92 | 1346.18 | 285.0 |
| 2012-06-24 18:25:00 | ES | Futures | 1345.92 | 1345.92 | 1345.67 | 1345.67 | 195.0 |
| 2012-06-24 18:26:00 | ES | Futures | 1345.67 | 1345.67 | 1345.67 | 1345.67 | 127.0 |
| 2012-06-24 18:27:00 | ES | Futures | 1345.67 | 1345.92 | 1345.41 | 1345.67 | 166.0 |
| 2012-06-24 18:28:00 | ES | Futures | 1345.41 | 1345.92 | 1345.41 | 1345.92 | 26.0 |
| 2012-06-24 18:29:00 | ES | Futures | 1345.67 | 1345.92 | 1345.67 | 1345.67 | 46.0 |
| 2012-06-24 18:30:00 | ES | Futures | 1345.67 | 1346.18 | 1345.41 | 1345.92 | 401.0 |
| 2012-06-24 18:31:00 | ES | Futures | 1346.18 | 1346.18 | 1345.92 | 1346.18 | 14.0 |
| 2012-06-24 18:32:00 | ES | Futures | 1346.18 | 1346.43 | 1345.92 | 1346.43 | 54.0 |
| 2012-06-24 18:33:00 | ES | Futures | 1346.43 | 1346.43 | 1346.18 | 1346.43 | 51.0 |
| 2012-06-24 18:34:00 | ES | Futures | 1346.18 | 1346.43 | 1346.18 | 1346.43 | 56.0 |
| 2012-06-24 18:35:00 | ES | Futures | 1346.43 | 1346.69 | 1346.18 | 1346.43 | 34.0 |
| 2012-06-24 18:36:00 | ES | Futures | 1346.43 | 1346.43 | 1346.43 | 1346.43 | 1.0 |
| 2012-06-24 18:37:00 | ES | Futures | 1346.43 | 1346.43 | 1346.18 | 1346.43 | 10.0 |
| 2012-06-24 18:38:00 | ES | Futures | 1346.43 | 1346.43 | 1346.18 | 1346.18 | 4.0 |
| 2012-06-24 18:39:00 | ES | Futures | 1346.43 | 1346.43 | 1346.18 | 1346.18 | 29.0 |
| 2012-06-24 18:40:00 | ES | Futures | 1346.43 | 1346.69 | 1346.18 | 1346.69 | 44.0 |
| 2012-06-24 18:41:00 | ES | Futures | 1346.69 | 1346.69 | 1346.43 | 1346.69 | 31.0 |
| 2012-06-24 18:42:00 | ES | Futures | 1346.43 | 1346.43 | 1346.43 | 1346.43 | 27.0 |
| 2012-06-24 18:43:00 | ES | Futures | 1346.43 | 1346.43 | 1346.18 | 1346.43 | 17.0 |
| 2012-06-24 18:44:00 | ES | Futures | 1346.18 | 1346.43 | 1346.18 | 1346.43 | 155.0 |
| 2012-06-24 18:45:00 | ES | Futures | 1346.18 | 1346.18 | 1345.92 | 1345.92 | 53.0 |
| 2012-06-24 18:46:00 | ES | Futures | 1345.92 | 1345.92 | 1345.41 | 1345.92 | 218.0 |
| 2012-06-24 18:47:00 | ES | Futures | 1345.67 | 1346.18 | 1345.67 | 1345.92 | 140.0 |
| 2012-06-24 18:48:00 | ES | Futures | 1345.67 | 1345.92 | 1345.41 | 1345.92 | 61.0 |
| 2012-06-24 18:49:00 | ES | Futures | 1345.67 | 1345.67 | 1345.67 | 1345.67 | 97.0 |
> showing 50 of 7,018 rows — these rows as CSV