PREVIEW / futures_5min / 2011-06-28
file: by_date/futures_5min/2011/2011-06-28.parquet size: 232 KB rows: 13,088
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-28 00:00:00 | ES | Futures | 1274.71 | 1274.71 | 1274.21 | 1274.21 | 148.0 |
| 2011-06-28 00:05:00 | ES | Futures | 1274.46 | 1274.71 | 1274.46 | 1274.46 | 20.0 |
| 2011-06-28 00:10:00 | ES | Futures | 1274.46 | 1274.46 | 1274.21 | 1274.21 | 6.0 |
| 2011-06-28 00:15:00 | ES | Futures | 1274.21 | 1274.46 | 1273.96 | 1273.96 | 501.0 |
| 2011-06-28 00:20:00 | ES | Futures | 1273.96 | 1274.21 | 1273.96 | 1274.21 | 491.0 |
| 2011-06-28 00:25:00 | ES | Futures | 1273.96 | 1274.21 | 1273.96 | 1273.96 | 81.0 |
| 2011-06-28 00:30:00 | ES | Futures | 1274.21 | 1274.21 | 1273.96 | 1273.96 | 56.0 |
| 2011-06-28 00:35:00 | ES | Futures | 1274.21 | 1274.71 | 1274.21 | 1274.71 | 234.0 |
| 2011-06-28 00:40:00 | ES | Futures | 1274.46 | 1274.96 | 1274.46 | 1274.96 | 178.0 |
| 2011-06-28 00:45:00 | ES | Futures | 1274.96 | 1274.96 | 1273.46 | 1273.96 | 1745.0 |
| 2011-06-28 00:50:00 | ES | Futures | 1274.21 | 1274.21 | 1273.46 | 1273.46 | 181.0 |
| 2011-06-28 00:55:00 | ES | Futures | 1273.46 | 1273.71 | 1273.46 | 1273.46 | 72.0 |
| 2011-06-28 01:00:00 | ES | Futures | 1273.46 | 1274.71 | 1273.46 | 1274.71 | 248.0 |
| 2011-06-28 01:05:00 | ES | Futures | 1274.46 | 1274.46 | 1274.21 | 1274.46 | 126.0 |
| 2011-06-28 01:10:00 | ES | Futures | 1274.46 | 1274.71 | 1273.71 | 1273.71 | 345.0 |
| 2011-06-28 01:15:00 | ES | Futures | 1273.71 | 1274.21 | 1273.46 | 1273.46 | 844.0 |
| 2011-06-28 01:20:00 | ES | Futures | 1273.22 | 1273.46 | 1272.47 | 1272.47 | 1423.0 |
| 2011-06-28 01:25:00 | ES | Futures | 1272.72 | 1272.97 | 1272.22 | 1272.72 | 1284.0 |
| 2011-06-28 01:30:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.47 | 449.0 |
| 2011-06-28 01:35:00 | ES | Futures | 1272.47 | 1272.72 | 1272.47 | 1272.72 | 522.0 |
| 2011-06-28 01:40:00 | ES | Futures | 1272.47 | 1272.97 | 1272.47 | 1272.47 | 532.0 |
| 2011-06-28 01:45:00 | ES | Futures | 1272.47 | 1272.72 | 1272.22 | 1272.22 | 390.0 |
| 2011-06-28 01:50:00 | ES | Futures | 1272.47 | 1272.97 | 1272.22 | 1272.97 | 311.0 |
| 2011-06-28 01:55:00 | ES | Futures | 1272.97 | 1272.97 | 1272.47 | 1272.47 | 349.0 |
| 2011-06-28 02:00:00 | ES | Futures | 1272.72 | 1273.22 | 1272.22 | 1272.97 | 1001.0 |
| 2011-06-28 02:05:00 | ES | Futures | 1272.97 | 1272.97 | 1272.47 | 1272.72 | 610.0 |
| 2011-06-28 02:10:00 | ES | Futures | 1272.72 | 1273.22 | 1272.47 | 1272.97 | 405.0 |
| 2011-06-28 02:15:00 | ES | Futures | 1273.22 | 1273.96 | 1272.97 | 1273.46 | 895.0 |
| 2011-06-28 02:20:00 | ES | Futures | 1273.46 | 1273.96 | 1273.22 | 1273.71 | 663.0 |
| 2011-06-28 02:25:00 | ES | Futures | 1273.96 | 1274.21 | 1273.71 | 1273.96 | 736.0 |
| 2011-06-28 02:30:00 | ES | Futures | 1273.96 | 1274.21 | 1273.71 | 1273.71 | 966.0 |
| 2011-06-28 02:35:00 | ES | Futures | 1273.71 | 1273.96 | 1273.22 | 1273.22 | 483.0 |
| 2011-06-28 02:40:00 | ES | Futures | 1273.22 | 1273.71 | 1273.22 | 1273.22 | 390.0 |
| 2011-06-28 02:45:00 | ES | Futures | 1273.46 | 1273.46 | 1272.97 | 1273.22 | 574.0 |
| 2011-06-28 02:50:00 | ES | Futures | 1273.22 | 1273.22 | 1272.47 | 1272.97 | 939.0 |
| 2011-06-28 02:55:00 | ES | Futures | 1272.97 | 1273.22 | 1272.47 | 1272.47 | 389.0 |
| 2011-06-28 03:00:00 | ES | Futures | 1272.47 | 1272.72 | 1271.47 | 1271.47 | 4683.0 |
| 2011-06-28 03:05:00 | ES | Futures | 1271.47 | 1272.47 | 1271.22 | 1271.47 | 3323.0 |
| 2011-06-28 03:10:00 | ES | Futures | 1271.47 | 1272.47 | 1271.47 | 1272.22 | 2160.0 |
| 2011-06-28 03:15:00 | ES | Futures | 1272.22 | 1273.46 | 1271.97 | 1272.97 | 4075.0 |
| 2011-06-28 03:20:00 | ES | Futures | 1273.22 | 1273.46 | 1272.47 | 1273.22 | 2961.0 |
| 2011-06-28 03:25:00 | ES | Futures | 1273.22 | 1273.71 | 1272.97 | 1272.97 | 908.0 |
| 2011-06-28 03:30:00 | ES | Futures | 1272.97 | 1275.46 | 1272.72 | 1274.46 | 4151.0 |
| 2011-06-28 03:35:00 | ES | Futures | 1274.46 | 1275.71 | 1274.46 | 1275.46 | 2988.0 |
| 2011-06-28 03:40:00 | ES | Futures | 1275.21 | 1275.71 | 1274.46 | 1274.96 | 2223.0 |
| 2011-06-28 03:45:00 | ES | Futures | 1274.96 | 1275.21 | 1274.21 | 1274.96 | 1381.0 |
| 2011-06-28 03:50:00 | ES | Futures | 1274.71 | 1275.46 | 1274.21 | 1275.21 | 1239.0 |
| 2011-06-28 03:55:00 | ES | Futures | 1275.46 | 1275.46 | 1274.21 | 1274.46 | 1112.0 |
| 2011-06-28 04:00:00 | ES | Futures | 1274.46 | 1275.21 | 1274.21 | 1274.46 | 1604.0 |
| 2011-06-28 04:05:00 | ES | Futures | 1274.21 | 1274.46 | 1273.46 | 1274.21 | 1365.0 |
> showing 50 of 13,088 rows — these rows as CSV