PREVIEW / futures_5min / 2012-08-31
file: by_date/futures_5min/2012/2012-08-31.parquet size: 190 KB rows: 10,756
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-31 00:00:00 | ES | Futures | 1422.21 | 1422.21 | 1421.95 | 1421.95 | 35.0 |
| 2012-08-31 00:05:00 | ES | Futures | 1421.95 | 1422.46 | 1421.95 | 1422.21 | 250.0 |
| 2012-08-31 00:10:00 | ES | Futures | 1422.21 | 1422.46 | 1422.21 | 1422.21 | 217.0 |
| 2012-08-31 00:15:00 | ES | Futures | 1422.21 | 1422.46 | 1422.21 | 1422.21 | 112.0 |
| 2012-08-31 00:20:00 | ES | Futures | 1422.21 | 1422.72 | 1421.95 | 1422.46 | 494.0 |
| 2012-08-31 00:25:00 | ES | Futures | 1422.46 | 1422.72 | 1422.21 | 1422.46 | 162.0 |
| 2012-08-31 00:30:00 | ES | Futures | 1422.46 | 1422.72 | 1422.21 | 1422.46 | 308.0 |
| 2012-08-31 00:35:00 | ES | Futures | 1422.46 | 1422.46 | 1422.21 | 1422.46 | 110.0 |
| 2012-08-31 00:40:00 | ES | Futures | 1422.46 | 1422.46 | 1422.21 | 1422.46 | 107.0 |
| 2012-08-31 00:45:00 | ES | Futures | 1422.46 | 1422.46 | 1421.7 | 1421.7 | 405.0 |
| 2012-08-31 00:50:00 | ES | Futures | 1421.7 | 1421.7 | 1421.19 | 1421.7 | 316.0 |
| 2012-08-31 00:55:00 | ES | Futures | 1421.44 | 1421.44 | 1421.19 | 1421.44 | 461.0 |
| 2012-08-31 01:00:00 | ES | Futures | 1421.19 | 1421.7 | 1421.19 | 1421.7 | 229.0 |
| 2012-08-31 01:05:00 | ES | Futures | 1421.44 | 1421.44 | 1421.19 | 1421.19 | 477.0 |
| 2012-08-31 01:10:00 | ES | Futures | 1421.19 | 1421.19 | 1420.94 | 1421.19 | 361.0 |
| 2012-08-31 01:15:00 | ES | Futures | 1421.44 | 1421.44 | 1420.94 | 1421.19 | 244.0 |
| 2012-08-31 01:20:00 | ES | Futures | 1420.94 | 1421.19 | 1420.43 | 1420.68 | 554.0 |
| 2012-08-31 01:25:00 | ES | Futures | 1420.94 | 1420.94 | 1420.94 | 1420.94 | 383.0 |
| 2012-08-31 01:30:00 | ES | Futures | 1421.19 | 1421.44 | 1420.94 | 1421.44 | 414.0 |
| 2012-08-31 01:35:00 | ES | Futures | 1421.19 | 1421.44 | 1420.94 | 1421.19 | 273.0 |
| 2012-08-31 01:40:00 | ES | Futures | 1421.44 | 1421.7 | 1421.19 | 1421.44 | 276.0 |
| 2012-08-31 01:45:00 | ES | Futures | 1421.19 | 1421.44 | 1421.19 | 1421.44 | 92.0 |
| 2012-08-31 01:50:00 | ES | Futures | 1421.19 | 1421.7 | 1421.19 | 1421.44 | 152.0 |
| 2012-08-31 01:55:00 | ES | Futures | 1421.7 | 1421.95 | 1421.7 | 1421.95 | 210.0 |
| 2012-08-31 02:00:00 | ES | Futures | 1421.95 | 1421.95 | 1421.44 | 1421.44 | 1183.0 |
| 2012-08-31 02:05:00 | ES | Futures | 1421.44 | 1421.7 | 1421.19 | 1421.7 | 333.0 |
| 2012-08-31 02:10:00 | ES | Futures | 1421.44 | 1421.7 | 1420.94 | 1420.94 | 692.0 |
| 2012-08-31 02:15:00 | ES | Futures | 1421.19 | 1421.19 | 1420.94 | 1420.94 | 520.0 |
| 2012-08-31 02:20:00 | ES | Futures | 1420.94 | 1421.44 | 1420.94 | 1421.44 | 204.0 |
| 2012-08-31 02:25:00 | ES | Futures | 1421.44 | 1421.44 | 1421.19 | 1421.44 | 403.0 |
| 2012-08-31 02:30:00 | ES | Futures | 1421.44 | 1421.95 | 1421.19 | 1421.7 | 335.0 |
| 2012-08-31 02:35:00 | ES | Futures | 1421.7 | 1422.21 | 1421.44 | 1422.21 | 468.0 |
| 2012-08-31 02:40:00 | ES | Futures | 1422.21 | 1422.46 | 1421.95 | 1422.21 | 556.0 |
| 2012-08-31 02:45:00 | ES | Futures | 1422.46 | 1422.72 | 1422.21 | 1422.46 | 309.0 |
| 2012-08-31 02:50:00 | ES | Futures | 1422.46 | 1422.72 | 1422.21 | 1422.72 | 147.0 |
| 2012-08-31 02:55:00 | ES | Futures | 1422.46 | 1423.22 | 1422.46 | 1422.72 | 1517.0 |
| 2012-08-31 03:00:00 | ES | Futures | 1422.46 | 1422.46 | 1421.44 | 1421.44 | 1571.0 |
| 2012-08-31 03:05:00 | ES | Futures | 1421.44 | 1422.46 | 1421.19 | 1422.46 | 805.0 |
| 2012-08-31 03:10:00 | ES | Futures | 1422.46 | 1423.22 | 1422.21 | 1422.97 | 2335.0 |
| 2012-08-31 03:15:00 | ES | Futures | 1423.22 | 1423.22 | 1422.72 | 1422.97 | 1287.0 |
| 2012-08-31 03:20:00 | ES | Futures | 1423.22 | 1423.99 | 1423.22 | 1423.73 | 1799.0 |
| 2012-08-31 03:25:00 | ES | Futures | 1423.73 | 1423.99 | 1422.72 | 1422.97 | 1780.0 |
| 2012-08-31 03:30:00 | ES | Futures | 1423.22 | 1423.73 | 1422.97 | 1423.48 | 1677.0 |
| 2012-08-31 03:35:00 | ES | Futures | 1423.48 | 1423.99 | 1423.22 | 1423.73 | 1560.0 |
| 2012-08-31 03:40:00 | ES | Futures | 1423.48 | 1423.99 | 1423.48 | 1423.73 | 970.0 |
| 2012-08-31 03:45:00 | ES | Futures | 1423.73 | 1423.73 | 1422.97 | 1423.22 | 1303.0 |
| 2012-08-31 03:50:00 | ES | Futures | 1423.22 | 1423.48 | 1422.97 | 1423.22 | 974.0 |
| 2012-08-31 03:55:00 | ES | Futures | 1423.22 | 1423.73 | 1423.22 | 1423.48 | 1060.0 |
| 2012-08-31 04:00:00 | ES | Futures | 1423.73 | 1425.51 | 1423.73 | 1425.0 | 7186.0 |
| 2012-08-31 04:05:00 | ES | Futures | 1425.0 | 1425.26 | 1424.5 | 1425.0 | 2005.0 |
> showing 50 of 10,756 rows — these rows as CSV