PREVIEW / futures_1min / 2011-11-01
file: by_date/futures_1min/2011/2011-11-01.parquet size: 717 KB rows: 54,104
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-11-01 00:00:00 | ES | Futures | 1245.26 | 1245.52 | 1245.01 | 1245.26 | 55.0 |
| 2011-11-01 00:01:00 | ES | Futures | 1245.52 | 1245.52 | 1245.01 | 1245.01 | 15.0 |
| 2011-11-01 00:02:00 | ES | Futures | 1245.26 | 1245.26 | 1245.26 | 1245.26 | 7.0 |
| 2011-11-01 00:03:00 | ES | Futures | 1245.26 | 1245.26 | 1244.76 | 1245.01 | 108.0 |
| 2011-11-01 00:04:00 | ES | Futures | 1245.01 | 1245.01 | 1244.76 | 1244.76 | 27.0 |
| 2011-11-01 00:05:00 | ES | Futures | 1244.76 | 1244.76 | 1244.76 | 1244.76 | 3.0 |
| 2011-11-01 00:06:00 | ES | Futures | 1244.76 | 1245.01 | 1244.76 | 1245.01 | 41.0 |
| 2011-11-01 00:07:00 | ES | Futures | 1245.01 | 1245.26 | 1245.01 | 1245.01 | 107.0 |
| 2011-11-01 00:08:00 | ES | Futures | 1245.26 | 1245.26 | 1245.01 | 1245.26 | 14.0 |
| 2011-11-01 00:09:00 | ES | Futures | 1245.01 | 1245.01 | 1245.01 | 1245.01 | 1.0 |
| 2011-11-01 00:10:00 | ES | Futures | 1245.26 | 1245.77 | 1245.26 | 1245.52 | 106.0 |
| 2011-11-01 00:11:00 | ES | Futures | 1245.77 | 1245.77 | 1245.52 | 1245.77 | 9.0 |
| 2011-11-01 00:12:00 | ES | Futures | 1245.77 | 1245.77 | 1245.26 | 1245.26 | 68.0 |
| 2011-11-01 00:13:00 | ES | Futures | 1245.26 | 1245.52 | 1245.26 | 1245.26 | 24.0 |
| 2011-11-01 00:14:00 | ES | Futures | 1245.26 | 1245.52 | 1245.26 | 1245.52 | 17.0 |
| 2011-11-01 00:15:00 | ES | Futures | 1245.26 | 1245.77 | 1245.26 | 1245.77 | 35.0 |
| 2011-11-01 00:16:00 | ES | Futures | 1245.77 | 1245.77 | 1245.52 | 1245.52 | 29.0 |
| 2011-11-01 00:17:00 | ES | Futures | 1245.52 | 1245.77 | 1245.52 | 1245.77 | 16.0 |
| 2011-11-01 00:18:00 | ES | Futures | 1245.52 | 1245.77 | 1245.26 | 1245.52 | 66.0 |
| 2011-11-01 00:19:00 | ES | Futures | 1245.52 | 1245.77 | 1245.52 | 1245.77 | 28.0 |
| 2011-11-01 00:20:00 | ES | Futures | 1245.52 | 1245.52 | 1245.26 | 1245.52 | 54.0 |
| 2011-11-01 00:21:00 | ES | Futures | 1245.77 | 1245.77 | 1245.26 | 1245.52 | 22.0 |
| 2011-11-01 00:22:00 | ES | Futures | 1245.52 | 1245.77 | 1245.52 | 1245.52 | 83.0 |
| 2011-11-01 00:23:00 | ES | Futures | 1245.52 | 1245.52 | 1245.26 | 1245.26 | 3.0 |
| 2011-11-01 00:24:00 | ES | Futures | 1245.26 | 1245.26 | 1244.76 | 1245.01 | 98.0 |
| 2011-11-01 00:25:00 | ES | Futures | 1245.26 | 1245.52 | 1244.76 | 1245.01 | 35.0 |
| 2011-11-01 00:26:00 | ES | Futures | 1244.76 | 1244.76 | 1244.51 | 1244.76 | 134.0 |
| 2011-11-01 00:27:00 | ES | Futures | 1244.76 | 1244.76 | 1244.76 | 1244.76 | 15.0 |
| 2011-11-01 00:28:00 | ES | Futures | 1244.76 | 1244.76 | 1244.51 | 1244.51 | 28.0 |
| 2011-11-01 00:29:00 | ES | Futures | 1244.51 | 1244.51 | 1244.26 | 1244.51 | 28.0 |
| 2011-11-01 00:30:00 | ES | Futures | 1244.51 | 1244.51 | 1244.26 | 1244.26 | 36.0 |
| 2011-11-01 00:31:00 | ES | Futures | 1244.51 | 1244.51 | 1244.26 | 1244.51 | 11.0 |
| 2011-11-01 00:32:00 | ES | Futures | 1244.51 | 1244.51 | 1244.51 | 1244.51 | 26.0 |
| 2011-11-01 00:33:00 | ES | Futures | 1244.51 | 1244.76 | 1244.26 | 1244.76 | 49.0 |
| 2011-11-01 00:34:00 | ES | Futures | 1244.76 | 1244.76 | 1244.26 | 1244.51 | 70.0 |
| 2011-11-01 00:35:00 | ES | Futures | 1244.51 | 1245.26 | 1244.51 | 1245.01 | 132.0 |
| 2011-11-01 00:36:00 | ES | Futures | 1244.76 | 1245.01 | 1244.76 | 1244.76 | 14.0 |
| 2011-11-01 00:37:00 | ES | Futures | 1244.76 | 1244.76 | 1244.76 | 1244.76 | 27.0 |
| 2011-11-01 00:38:00 | ES | Futures | 1244.76 | 1244.76 | 1244.76 | 1244.76 | 2.0 |
| 2011-11-01 00:39:00 | ES | Futures | 1244.51 | 1244.76 | 1244.51 | 1244.51 | 7.0 |
| 2011-11-01 00:40:00 | ES | Futures | 1244.51 | 1244.76 | 1244.51 | 1244.76 | 114.0 |
| 2011-11-01 00:41:00 | ES | Futures | 1244.76 | 1245.01 | 1244.51 | 1245.01 | 110.0 |
| 2011-11-01 00:42:00 | ES | Futures | 1244.76 | 1244.76 | 1244.51 | 1244.51 | 18.0 |
| 2011-11-01 00:43:00 | ES | Futures | 1244.76 | 1244.76 | 1244.01 | 1244.26 | 101.0 |
| 2011-11-01 00:44:00 | ES | Futures | 1244.01 | 1244.26 | 1244.01 | 1244.26 | 4.0 |
| 2011-11-01 00:45:00 | ES | Futures | 1244.26 | 1244.26 | 1244.26 | 1244.26 | 52.0 |
| 2011-11-01 00:46:00 | ES | Futures | 1244.26 | 1244.26 | 1244.01 | 1244.01 | 5.0 |
| 2011-11-01 00:47:00 | ES | Futures | 1244.01 | 1244.51 | 1243.51 | 1244.26 | 256.0 |
| 2011-11-01 00:48:00 | ES | Futures | 1244.26 | 1244.26 | 1244.26 | 1244.26 | 2.0 |
| 2011-11-01 00:49:00 | ES | Futures | 1244.26 | 1244.51 | 1244.26 | 1244.51 | 41.0 |
> showing 50 of 54,104 rows — these rows as CSV