PREVIEW / futures_1min / 2011-07-31
file: by_date/futures_1min/2011/2011-07-31.parquet size: 107 KB rows: 7,763
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-07-31 18:00:00 | ES | Futures | 1302.89 | 1302.89 | 1299.9 | 1300.65 | 8387.0 |
| 2011-07-31 18:01:00 | ES | Futures | 1300.9 | 1301.9 | 1300.9 | 1301.9 | 2026.0 |
| 2011-07-31 18:02:00 | ES | Futures | 1301.9 | 1302.89 | 1301.9 | 1302.89 | 1407.0 |
| 2011-07-31 18:03:00 | ES | Futures | 1302.89 | 1303.64 | 1302.15 | 1303.14 | 1981.0 |
| 2011-07-31 18:04:00 | ES | Futures | 1303.14 | 1303.64 | 1302.65 | 1302.89 | 1405.0 |
| 2011-07-31 18:05:00 | ES | Futures | 1302.89 | 1303.14 | 1302.65 | 1302.65 | 647.0 |
| 2011-07-31 18:06:00 | ES | Futures | 1302.65 | 1303.14 | 1302.65 | 1302.89 | 1228.0 |
| 2011-07-31 18:07:00 | ES | Futures | 1302.89 | 1303.14 | 1302.65 | 1302.89 | 763.0 |
| 2011-07-31 18:08:00 | ES | Futures | 1302.89 | 1304.39 | 1302.65 | 1304.39 | 1543.0 |
| 2011-07-31 18:09:00 | ES | Futures | 1304.14 | 1305.64 | 1303.89 | 1304.89 | 2055.0 |
| 2011-07-31 18:10:00 | ES | Futures | 1304.89 | 1304.89 | 1303.89 | 1304.64 | 715.0 |
| 2011-07-31 18:11:00 | ES | Futures | 1304.39 | 1304.64 | 1303.89 | 1303.89 | 626.0 |
| 2011-07-31 18:12:00 | ES | Futures | 1304.14 | 1304.14 | 1303.14 | 1303.39 | 542.0 |
| 2011-07-31 18:13:00 | ES | Futures | 1303.64 | 1303.89 | 1303.14 | 1303.14 | 330.0 |
| 2011-07-31 18:14:00 | ES | Futures | 1303.39 | 1303.39 | 1302.65 | 1302.89 | 679.0 |
| 2011-07-31 18:15:00 | ES | Futures | 1302.89 | 1303.64 | 1302.89 | 1303.14 | 587.0 |
| 2011-07-31 18:16:00 | ES | Futures | 1303.14 | 1303.39 | 1302.4 | 1302.65 | 701.0 |
| 2011-07-31 18:17:00 | ES | Futures | 1302.65 | 1302.89 | 1300.9 | 1300.9 | 1131.0 |
| 2011-07-31 18:18:00 | ES | Futures | 1300.9 | 1301.65 | 1300.4 | 1301.15 | 1265.0 |
| 2011-07-31 18:19:00 | ES | Futures | 1301.15 | 1301.4 | 1300.9 | 1301.4 | 364.0 |
| 2011-07-31 18:20:00 | ES | Futures | 1301.65 | 1301.65 | 1301.15 | 1301.4 | 185.0 |
| 2011-07-31 18:21:00 | ES | Futures | 1301.4 | 1301.9 | 1301.15 | 1301.4 | 214.0 |
| 2011-07-31 18:22:00 | ES | Futures | 1301.65 | 1301.65 | 1301.4 | 1301.65 | 29.0 |
| 2011-07-31 18:23:00 | ES | Futures | 1301.65 | 1301.65 | 1301.15 | 1301.15 | 134.0 |
| 2011-07-31 18:24:00 | ES | Futures | 1301.15 | 1301.15 | 1300.4 | 1300.4 | 268.0 |
| 2011-07-31 18:25:00 | ES | Futures | 1300.65 | 1301.65 | 1300.4 | 1301.65 | 564.0 |
| 2011-07-31 18:26:00 | ES | Futures | 1301.4 | 1301.65 | 1301.4 | 1301.4 | 63.0 |
| 2011-07-31 18:27:00 | ES | Futures | 1301.4 | 1302.15 | 1301.4 | 1301.9 | 578.0 |
| 2011-07-31 18:28:00 | ES | Futures | 1301.9 | 1301.9 | 1299.9 | 1300.4 | 1092.0 |
| 2011-07-31 18:29:00 | ES | Futures | 1300.4 | 1301.4 | 1300.4 | 1301.15 | 312.0 |
| 2011-07-31 18:30:00 | ES | Futures | 1301.15 | 1301.4 | 1298.9 | 1299.4 | 1471.0 |
| 2011-07-31 18:31:00 | ES | Futures | 1299.15 | 1300.15 | 1298.9 | 1299.65 | 539.0 |
| 2011-07-31 18:32:00 | ES | Futures | 1299.65 | 1299.9 | 1298.9 | 1299.15 | 399.0 |
| 2011-07-31 18:33:00 | ES | Futures | 1298.9 | 1299.65 | 1298.65 | 1299.4 | 568.0 |
| 2011-07-31 18:34:00 | ES | Futures | 1299.65 | 1299.9 | 1299.15 | 1299.4 | 277.0 |
| 2011-07-31 18:35:00 | ES | Futures | 1299.4 | 1300.9 | 1299.4 | 1300.65 | 650.0 |
| 2011-07-31 18:36:00 | ES | Futures | 1300.65 | 1301.65 | 1300.4 | 1301.15 | 536.0 |
| 2011-07-31 18:37:00 | ES | Futures | 1301.15 | 1302.65 | 1301.15 | 1301.9 | 1431.0 |
| 2011-07-31 18:38:00 | ES | Futures | 1301.9 | 1301.9 | 1300.9 | 1301.4 | 649.0 |
| 2011-07-31 18:39:00 | ES | Futures | 1301.4 | 1301.65 | 1301.4 | 1301.4 | 84.0 |
| 2011-07-31 18:40:00 | ES | Futures | 1301.4 | 1302.15 | 1301.4 | 1301.4 | 269.0 |
| 2011-07-31 18:41:00 | ES | Futures | 1301.9 | 1302.15 | 1300.9 | 1301.65 | 269.0 |
| 2011-07-31 18:42:00 | ES | Futures | 1301.65 | 1301.65 | 1300.65 | 1301.15 | 533.0 |
| 2011-07-31 18:43:00 | ES | Futures | 1301.15 | 1301.15 | 1299.9 | 1300.4 | 494.0 |
| 2011-07-31 18:44:00 | ES | Futures | 1300.4 | 1300.4 | 1299.9 | 1300.4 | 243.0 |
| 2011-07-31 18:45:00 | ES | Futures | 1300.15 | 1300.9 | 1300.15 | 1300.4 | 419.0 |
| 2011-07-31 18:46:00 | ES | Futures | 1300.4 | 1300.4 | 1299.65 | 1299.65 | 193.0 |
| 2011-07-31 18:47:00 | ES | Futures | 1299.9 | 1301.15 | 1299.9 | 1300.65 | 499.0 |
| 2011-07-31 18:48:00 | ES | Futures | 1300.65 | 1300.65 | 1299.9 | 1299.9 | 296.0 |
| 2011-07-31 18:49:00 | ES | Futures | 1300.4 | 1302.15 | 1300.4 | 1300.9 | 971.0 |
> showing 50 of 7,763 rows — these rows as CSV