PREVIEW / futures_5min / 2012-07-09
file: by_date/futures_5min/2012/2012-07-09.parquet size: 202 KB rows: 13,516
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-07-09 00:00:00 | ES | Futures | 1371.35 | 1371.35 | 1371.1 | 1371.35 | 106.0 |
| 2012-07-09 00:05:00 | ES | Futures | 1371.35 | 1371.35 | 1371.1 | 1371.35 | 305.0 |
| 2012-07-09 00:10:00 | ES | Futures | 1371.35 | 1371.35 | 1371.35 | 1371.35 | 33.0 |
| 2012-07-09 00:15:00 | ES | Futures | 1371.35 | 1371.6 | 1371.35 | 1371.6 | 36.0 |
| 2012-07-09 00:20:00 | ES | Futures | 1371.35 | 1371.6 | 1371.1 | 1371.6 | 316.0 |
| 2012-07-09 00:25:00 | ES | Futures | 1371.6 | 1371.6 | 1371.35 | 1371.35 | 107.0 |
| 2012-07-09 00:30:00 | ES | Futures | 1371.35 | 1371.6 | 1371.1 | 1371.35 | 46.0 |
| 2012-07-09 00:35:00 | ES | Futures | 1371.35 | 1371.35 | 1371.1 | 1371.1 | 61.0 |
| 2012-07-09 00:40:00 | ES | Futures | 1371.1 | 1371.35 | 1371.1 | 1371.35 | 20.0 |
| 2012-07-09 00:45:00 | ES | Futures | 1371.1 | 1371.1 | 1370.84 | 1371.1 | 1608.0 |
| 2012-07-09 00:50:00 | ES | Futures | 1371.1 | 1371.35 | 1371.1 | 1371.1 | 274.0 |
| 2012-07-09 00:55:00 | ES | Futures | 1371.1 | 1371.6 | 1371.1 | 1371.35 | 458.0 |
| 2012-07-09 01:00:00 | ES | Futures | 1371.35 | 1371.6 | 1370.59 | 1370.84 | 671.0 |
| 2012-07-09 01:05:00 | ES | Futures | 1371.1 | 1371.1 | 1370.33 | 1370.59 | 332.0 |
| 2012-07-09 01:10:00 | ES | Futures | 1370.84 | 1370.84 | 1370.59 | 1370.59 | 35.0 |
| 2012-07-09 01:15:00 | ES | Futures | 1370.84 | 1371.35 | 1370.84 | 1371.35 | 399.0 |
| 2012-07-09 01:20:00 | ES | Futures | 1371.35 | 1371.6 | 1371.1 | 1371.35 | 167.0 |
| 2012-07-09 01:25:00 | ES | Futures | 1371.35 | 1371.6 | 1371.35 | 1371.35 | 490.0 |
| 2012-07-09 01:30:00 | ES | Futures | 1371.35 | 1371.35 | 1370.59 | 1370.59 | 447.0 |
| 2012-07-09 01:35:00 | ES | Futures | 1370.59 | 1371.1 | 1370.59 | 1371.1 | 379.0 |
| 2012-07-09 01:40:00 | ES | Futures | 1371.1 | 1371.35 | 1370.84 | 1371.1 | 242.0 |
| 2012-07-09 01:45:00 | ES | Futures | 1371.1 | 1371.1 | 1370.84 | 1371.1 | 271.0 |
| 2012-07-09 01:50:00 | ES | Futures | 1371.1 | 1371.35 | 1370.59 | 1371.1 | 490.0 |
| 2012-07-09 01:55:00 | ES | Futures | 1371.1 | 1371.35 | 1370.59 | 1370.84 | 425.0 |
| 2012-07-09 02:00:00 | ES | Futures | 1370.84 | 1371.1 | 1370.33 | 1370.33 | 846.0 |
| 2012-07-09 02:05:00 | ES | Futures | 1370.59 | 1370.59 | 1369.57 | 1369.82 | 872.0 |
| 2012-07-09 02:10:00 | ES | Futures | 1369.57 | 1370.08 | 1369.32 | 1370.08 | 616.0 |
| 2012-07-09 02:15:00 | ES | Futures | 1369.82 | 1370.84 | 1369.32 | 1370.59 | 690.0 |
| 2012-07-09 02:20:00 | ES | Futures | 1370.84 | 1370.84 | 1369.82 | 1369.82 | 625.0 |
| 2012-07-09 02:25:00 | ES | Futures | 1370.08 | 1370.08 | 1369.82 | 1369.82 | 396.0 |
| 2012-07-09 02:30:00 | ES | Futures | 1370.08 | 1370.08 | 1369.57 | 1370.08 | 235.0 |
| 2012-07-09 02:35:00 | ES | Futures | 1370.33 | 1370.84 | 1370.08 | 1370.33 | 736.0 |
| 2012-07-09 02:40:00 | ES | Futures | 1370.33 | 1370.33 | 1369.57 | 1369.82 | 621.0 |
| 2012-07-09 02:45:00 | ES | Futures | 1369.82 | 1370.33 | 1369.32 | 1369.32 | 1705.0 |
| 2012-07-09 02:50:00 | ES | Futures | 1369.32 | 1369.82 | 1369.06 | 1369.06 | 998.0 |
| 2012-07-09 02:55:00 | ES | Futures | 1369.32 | 1369.57 | 1369.06 | 1369.32 | 590.0 |
| 2012-07-09 03:00:00 | ES | Futures | 1369.57 | 1370.08 | 1368.81 | 1369.82 | 1911.0 |
| 2012-07-09 03:05:00 | ES | Futures | 1369.82 | 1371.1 | 1369.57 | 1370.59 | 2604.0 |
| 2012-07-09 03:10:00 | ES | Futures | 1370.33 | 1371.6 | 1370.33 | 1371.1 | 2620.0 |
| 2012-07-09 03:15:00 | ES | Futures | 1371.1 | 1371.35 | 1370.08 | 1370.08 | 2285.0 |
| 2012-07-09 03:20:00 | ES | Futures | 1370.33 | 1370.33 | 1368.81 | 1369.82 | 4029.0 |
| 2012-07-09 03:25:00 | ES | Futures | 1369.82 | 1370.59 | 1369.57 | 1370.59 | 1495.0 |
| 2012-07-09 03:30:00 | ES | Futures | 1370.59 | 1371.1 | 1370.08 | 1370.84 | 2364.0 |
| 2012-07-09 03:35:00 | ES | Futures | 1370.59 | 1371.1 | 1369.57 | 1370.59 | 2811.0 |
| 2012-07-09 03:40:00 | ES | Futures | 1370.59 | 1370.59 | 1369.82 | 1369.82 | 1120.0 |
| 2012-07-09 03:45:00 | ES | Futures | 1369.82 | 1370.33 | 1369.32 | 1369.32 | 1991.0 |
| 2012-07-09 03:50:00 | ES | Futures | 1369.32 | 1370.08 | 1368.55 | 1369.06 | 2655.0 |
| 2012-07-09 03:55:00 | ES | Futures | 1368.81 | 1369.06 | 1367.28 | 1368.04 | 6845.0 |
| 2012-07-09 04:00:00 | ES | Futures | 1367.79 | 1368.81 | 1367.54 | 1368.55 | 3312.0 |
| 2012-07-09 04:05:00 | ES | Futures | 1368.3 | 1368.81 | 1367.79 | 1368.3 | 2385.0 |
> showing 50 of 13,516 rows — these rows as CSV