PREVIEW / futures_5min / 2011-06-14
file: by_date/futures_5min/2011/2011-06-14.parquet size: 219 KB rows: 12,965
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-06-14 00:00:00 | ES | Futures | 1270.97 | 1270.97 | 1270.47 | 1270.97 | 308.0 |
| 2011-06-14 00:05:00 | ES | Futures | 1270.72 | 1270.97 | 1270.47 | 1270.72 | 155.0 |
| 2011-06-14 00:10:00 | ES | Futures | 1270.72 | 1270.97 | 1270.47 | 1270.47 | 113.0 |
| 2011-06-14 00:15:00 | ES | Futures | 1270.72 | 1270.97 | 1270.47 | 1270.72 | 158.0 |
| 2011-06-14 00:20:00 | ES | Futures | 1270.72 | 1271.47 | 1270.72 | 1271.22 | 463.0 |
| 2011-06-14 00:25:00 | ES | Futures | 1271.22 | 1271.22 | 1270.97 | 1270.97 | 100.0 |
| 2011-06-14 00:30:00 | ES | Futures | 1271.22 | 1271.22 | 1270.97 | 1271.22 | 67.0 |
| 2011-06-14 00:35:00 | ES | Futures | 1270.97 | 1270.97 | 1270.72 | 1270.97 | 72.0 |
| 2011-06-14 00:40:00 | ES | Futures | 1271.22 | 1271.47 | 1270.97 | 1271.47 | 309.0 |
| 2011-06-14 00:45:00 | ES | Futures | 1271.47 | 1271.72 | 1271.22 | 1271.47 | 282.0 |
| 2011-06-14 00:50:00 | ES | Futures | 1271.47 | 1271.72 | 1271.47 | 1271.72 | 133.0 |
| 2011-06-14 00:55:00 | ES | Futures | 1271.72 | 1271.97 | 1271.47 | 1271.72 | 405.0 |
| 2011-06-14 01:00:00 | ES | Futures | 1271.47 | 1271.97 | 1271.22 | 1271.47 | 875.0 |
| 2011-06-14 01:05:00 | ES | Futures | 1271.47 | 1273.22 | 1271.47 | 1272.72 | 2461.0 |
| 2011-06-14 01:10:00 | ES | Futures | 1272.47 | 1272.97 | 1272.47 | 1272.47 | 540.0 |
| 2011-06-14 01:15:00 | ES | Futures | 1272.47 | 1272.72 | 1272.22 | 1272.47 | 262.0 |
| 2011-06-14 01:20:00 | ES | Futures | 1272.47 | 1272.72 | 1271.97 | 1272.47 | 362.0 |
| 2011-06-14 01:25:00 | ES | Futures | 1272.22 | 1272.97 | 1272.22 | 1272.47 | 214.0 |
| 2011-06-14 01:30:00 | ES | Futures | 1272.72 | 1272.72 | 1271.47 | 1271.47 | 816.0 |
| 2011-06-14 01:35:00 | ES | Futures | 1271.72 | 1271.97 | 1271.47 | 1271.97 | 367.0 |
| 2011-06-14 01:40:00 | ES | Futures | 1271.97 | 1272.47 | 1271.97 | 1272.47 | 294.0 |
| 2011-06-14 01:45:00 | ES | Futures | 1272.22 | 1272.47 | 1271.97 | 1272.22 | 221.0 |
| 2011-06-14 01:50:00 | ES | Futures | 1272.22 | 1272.47 | 1271.72 | 1271.97 | 686.0 |
| 2011-06-14 01:55:00 | ES | Futures | 1271.72 | 1271.97 | 1271.47 | 1271.47 | 377.0 |
| 2011-06-14 02:00:00 | ES | Futures | 1271.47 | 1272.97 | 1271.47 | 1272.22 | 1477.0 |
| 2011-06-14 02:05:00 | ES | Futures | 1272.22 | 1272.97 | 1272.22 | 1272.72 | 1545.0 |
| 2011-06-14 02:10:00 | ES | Futures | 1272.97 | 1272.97 | 1272.72 | 1272.72 | 568.0 |
| 2011-06-14 02:15:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.72 | 643.0 |
| 2011-06-14 02:20:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.47 | 717.0 |
| 2011-06-14 02:25:00 | ES | Futures | 1272.47 | 1272.47 | 1271.97 | 1271.97 | 535.0 |
| 2011-06-14 02:30:00 | ES | Futures | 1272.22 | 1272.22 | 1271.72 | 1271.97 | 643.0 |
| 2011-06-14 02:35:00 | ES | Futures | 1271.97 | 1272.22 | 1271.97 | 1271.97 | 323.0 |
| 2011-06-14 02:40:00 | ES | Futures | 1272.22 | 1272.47 | 1272.22 | 1272.47 | 793.0 |
| 2011-06-14 02:45:00 | ES | Futures | 1272.47 | 1273.22 | 1272.47 | 1272.72 | 1725.0 |
| 2011-06-14 02:50:00 | ES | Futures | 1272.97 | 1272.97 | 1272.22 | 1272.47 | 795.0 |
| 2011-06-14 02:55:00 | ES | Futures | 1272.47 | 1272.47 | 1271.97 | 1272.47 | 1361.0 |
| 2011-06-14 03:00:00 | ES | Futures | 1272.22 | 1273.71 | 1272.22 | 1273.22 | 5291.0 |
| 2011-06-14 03:05:00 | ES | Futures | 1273.46 | 1274.71 | 1273.22 | 1274.46 | 6498.0 |
| 2011-06-14 03:10:00 | ES | Futures | 1274.71 | 1275.46 | 1274.46 | 1274.71 | 6267.0 |
| 2011-06-14 03:15:00 | ES | Futures | 1274.96 | 1275.21 | 1274.46 | 1274.46 | 2405.0 |
| 2011-06-14 03:20:00 | ES | Futures | 1274.46 | 1274.71 | 1272.72 | 1272.72 | 6614.0 |
| 2011-06-14 03:25:00 | ES | Futures | 1272.72 | 1273.96 | 1272.22 | 1273.71 | 3465.0 |
| 2011-06-14 03:30:00 | ES | Futures | 1273.71 | 1273.96 | 1272.47 | 1272.72 | 2510.0 |
| 2011-06-14 03:35:00 | ES | Futures | 1272.97 | 1273.22 | 1271.97 | 1272.22 | 2263.0 |
| 2011-06-14 03:40:00 | ES | Futures | 1272.47 | 1272.47 | 1271.72 | 1271.72 | 1688.0 |
| 2011-06-14 03:45:00 | ES | Futures | 1271.72 | 1271.97 | 1271.47 | 1271.97 | 2353.0 |
| 2011-06-14 03:50:00 | ES | Futures | 1271.72 | 1272.97 | 1271.72 | 1272.22 | 1754.0 |
| 2011-06-14 03:55:00 | ES | Futures | 1272.47 | 1272.72 | 1272.22 | 1272.47 | 1316.0 |
| 2011-06-14 04:00:00 | ES | Futures | 1272.47 | 1274.21 | 1272.47 | 1274.21 | 4250.0 |
| 2011-06-14 04:05:00 | ES | Futures | 1274.21 | 1274.96 | 1273.96 | 1273.96 | 3338.0 |
> showing 50 of 12,965 rows — these rows as CSV