PREVIEW / futures_5min / 2013-06-18
file: by_date/futures_5min/2013/2013-06-18.parquet size: 211 KB rows: 13,733
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-18 00:00:00 | ES | Futures | 1689.01 | 1689.01 | 1688.75 | 1688.75 | 133.0 |
| 2013-06-18 00:05:00 | ES | Futures | 1689.01 | 1689.78 | 1689.01 | 1689.52 | 179.0 |
| 2013-06-18 00:10:00 | ES | Futures | 1689.52 | 1689.78 | 1689.26 | 1689.26 | 77.0 |
| 2013-06-18 00:15:00 | ES | Futures | 1689.26 | 1689.78 | 1689.26 | 1689.26 | 281.0 |
| 2013-06-18 00:20:00 | ES | Futures | 1689.26 | 1689.52 | 1689.26 | 1689.52 | 87.0 |
| 2013-06-18 00:25:00 | ES | Futures | 1689.26 | 1689.52 | 1689.01 | 1689.52 | 167.0 |
| 2013-06-18 00:30:00 | ES | Futures | 1689.26 | 1689.26 | 1688.75 | 1688.75 | 118.0 |
| 2013-06-18 00:35:00 | ES | Futures | 1688.75 | 1689.52 | 1688.75 | 1689.52 | 181.0 |
| 2013-06-18 00:40:00 | ES | Futures | 1689.26 | 1689.52 | 1689.01 | 1689.26 | 35.0 |
| 2013-06-18 00:45:00 | ES | Futures | 1689.26 | 1689.26 | 1689.01 | 1689.26 | 23.0 |
| 2013-06-18 00:50:00 | ES | Futures | 1689.52 | 1689.52 | 1689.01 | 1689.26 | 84.0 |
| 2013-06-18 00:55:00 | ES | Futures | 1689.26 | 1689.52 | 1689.26 | 1689.52 | 68.0 |
| 2013-06-18 01:00:00 | ES | Futures | 1689.26 | 1689.52 | 1689.26 | 1689.52 | 118.0 |
| 2013-06-18 01:05:00 | ES | Futures | 1689.52 | 1689.52 | 1689.26 | 1689.26 | 216.0 |
| 2013-06-18 01:10:00 | ES | Futures | 1689.26 | 1689.52 | 1689.01 | 1689.52 | 196.0 |
| 2013-06-18 01:15:00 | ES | Futures | 1689.52 | 1689.52 | 1689.26 | 1689.26 | 42.0 |
| 2013-06-18 01:20:00 | ES | Futures | 1689.26 | 1689.52 | 1689.01 | 1689.26 | 401.0 |
| 2013-06-18 01:25:00 | ES | Futures | 1689.26 | 1689.52 | 1689.26 | 1689.26 | 85.0 |
| 2013-06-18 01:30:00 | ES | Futures | 1689.52 | 1689.52 | 1689.01 | 1689.26 | 110.0 |
| 2013-06-18 01:35:00 | ES | Futures | 1689.01 | 1690.04 | 1689.01 | 1689.78 | 192.0 |
| 2013-06-18 01:40:00 | ES | Futures | 1689.78 | 1690.3 | 1689.52 | 1690.04 | 231.0 |
| 2013-06-18 01:45:00 | ES | Futures | 1690.3 | 1690.56 | 1690.04 | 1690.56 | 304.0 |
| 2013-06-18 01:50:00 | ES | Futures | 1690.56 | 1691.33 | 1690.3 | 1691.33 | 750.0 |
| 2013-06-18 01:55:00 | ES | Futures | 1691.33 | 1691.59 | 1691.07 | 1691.59 | 520.0 |
| 2013-06-18 02:00:00 | ES | Futures | 1691.33 | 1691.59 | 1690.81 | 1691.07 | 872.0 |
| 2013-06-18 02:05:00 | ES | Futures | 1690.81 | 1691.07 | 1690.56 | 1690.81 | 271.0 |
| 2013-06-18 02:10:00 | ES | Futures | 1690.56 | 1691.07 | 1690.56 | 1690.81 | 457.0 |
| 2013-06-18 02:15:00 | ES | Futures | 1690.81 | 1690.81 | 1690.56 | 1690.81 | 231.0 |
| 2013-06-18 02:20:00 | ES | Futures | 1690.81 | 1691.59 | 1690.81 | 1691.33 | 477.0 |
| 2013-06-18 02:25:00 | ES | Futures | 1691.33 | 1691.59 | 1691.33 | 1691.33 | 165.0 |
| 2013-06-18 02:30:00 | ES | Futures | 1691.59 | 1691.59 | 1691.07 | 1691.07 | 491.0 |
| 2013-06-18 02:35:00 | ES | Futures | 1691.33 | 1691.59 | 1691.33 | 1691.33 | 118.0 |
| 2013-06-18 02:40:00 | ES | Futures | 1691.07 | 1691.59 | 1691.07 | 1691.33 | 490.0 |
| 2013-06-18 02:45:00 | ES | Futures | 1691.33 | 1691.59 | 1691.07 | 1691.07 | 145.0 |
| 2013-06-18 02:50:00 | ES | Futures | 1691.33 | 1691.33 | 1691.07 | 1691.07 | 213.0 |
| 2013-06-18 02:55:00 | ES | Futures | 1691.33 | 1691.33 | 1691.07 | 1691.07 | 96.0 |
| 2013-06-18 03:00:00 | ES | Futures | 1691.07 | 1691.07 | 1689.78 | 1689.78 | 1810.0 |
| 2013-06-18 03:05:00 | ES | Futures | 1689.78 | 1690.56 | 1689.26 | 1690.04 | 1812.0 |
| 2013-06-18 03:10:00 | ES | Futures | 1690.04 | 1690.3 | 1689.52 | 1689.78 | 1231.0 |
| 2013-06-18 03:15:00 | ES | Futures | 1689.52 | 1689.52 | 1688.75 | 1689.26 | 1399.0 |
| 2013-06-18 03:20:00 | ES | Futures | 1689.26 | 1690.3 | 1689.01 | 1690.3 | 2291.0 |
| 2013-06-18 03:25:00 | ES | Futures | 1690.04 | 1691.59 | 1690.04 | 1691.59 | 1674.0 |
| 2013-06-18 03:30:00 | ES | Futures | 1691.59 | 1691.85 | 1690.81 | 1690.81 | 1231.0 |
| 2013-06-18 03:35:00 | ES | Futures | 1690.56 | 1692.11 | 1690.3 | 1692.11 | 1585.0 |
| 2013-06-18 03:40:00 | ES | Futures | 1692.11 | 1692.37 | 1690.81 | 1691.33 | 2522.0 |
| 2013-06-18 03:45:00 | ES | Futures | 1691.33 | 1693.66 | 1691.07 | 1693.4 | 4741.0 |
| 2013-06-18 03:50:00 | ES | Futures | 1693.4 | 1693.92 | 1692.37 | 1692.88 | 1479.0 |
| 2013-06-18 03:55:00 | ES | Futures | 1692.88 | 1693.4 | 1692.62 | 1693.4 | 1439.0 |
| 2013-06-18 04:00:00 | ES | Futures | 1693.4 | 1693.92 | 1691.85 | 1691.85 | 1962.0 |
| 2013-06-18 04:05:00 | ES | Futures | 1691.85 | 1692.88 | 1691.85 | 1692.62 | 765.0 |
> showing 50 of 13,733 rows — these rows as CSV