PREVIEW / futures_5min / 2011-06-23
file: by_date/futures_5min/2011/2011-06-23.parquet size: 245 KB rows: 13,267
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-23 00:00:00 | ES | Futures | 1271.97 | 1272.22 | 1271.97 | 1272.22 | 647.0 |
| 2011-06-23 00:05:00 | ES | Futures | 1271.97 | 1272.72 | 1271.97 | 1272.47 | 285.0 |
| 2011-06-23 00:10:00 | ES | Futures | 1272.22 | 1272.72 | 1272.22 | 1272.47 | 80.0 |
| 2011-06-23 00:15:00 | ES | Futures | 1272.47 | 1272.72 | 1272.47 | 1272.47 | 113.0 |
| 2011-06-23 00:20:00 | ES | Futures | 1272.22 | 1272.72 | 1272.22 | 1272.72 | 781.0 |
| 2011-06-23 00:25:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.97 | 117.0 |
| 2011-06-23 00:30:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.72 | 78.0 |
| 2011-06-23 00:35:00 | ES | Futures | 1272.47 | 1272.72 | 1272.47 | 1272.72 | 52.0 |
| 2011-06-23 00:40:00 | ES | Futures | 1272.47 | 1272.72 | 1272.47 | 1272.72 | 42.0 |
| 2011-06-23 00:45:00 | ES | Futures | 1272.72 | 1272.97 | 1271.97 | 1272.97 | 418.0 |
| 2011-06-23 00:50:00 | ES | Futures | 1272.72 | 1272.97 | 1271.97 | 1271.97 | 515.0 |
| 2011-06-23 00:55:00 | ES | Futures | 1272.22 | 1272.47 | 1271.97 | 1272.22 | 93.0 |
| 2011-06-23 01:00:00 | ES | Futures | 1271.97 | 1272.97 | 1271.97 | 1272.97 | 183.0 |
| 2011-06-23 01:05:00 | ES | Futures | 1272.72 | 1273.22 | 1272.72 | 1273.22 | 477.0 |
| 2011-06-23 01:10:00 | ES | Futures | 1272.97 | 1273.46 | 1272.97 | 1272.97 | 238.0 |
| 2011-06-23 01:15:00 | ES | Futures | 1273.22 | 1273.46 | 1272.97 | 1273.22 | 114.0 |
| 2011-06-23 01:20:00 | ES | Futures | 1272.97 | 1273.46 | 1272.72 | 1272.72 | 236.0 |
| 2011-06-23 01:25:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.72 | 198.0 |
| 2011-06-23 01:30:00 | ES | Futures | 1272.47 | 1273.22 | 1272.47 | 1272.72 | 530.0 |
| 2011-06-23 01:35:00 | ES | Futures | 1272.47 | 1272.72 | 1271.97 | 1272.22 | 489.0 |
| 2011-06-23 01:40:00 | ES | Futures | 1272.22 | 1272.22 | 1271.72 | 1271.97 | 537.0 |
| 2011-06-23 01:45:00 | ES | Futures | 1271.97 | 1273.96 | 1271.97 | 1273.46 | 1385.0 |
| 2011-06-23 01:50:00 | ES | Futures | 1273.46 | 1273.96 | 1273.22 | 1273.46 | 503.0 |
| 2011-06-23 01:55:00 | ES | Futures | 1273.46 | 1273.46 | 1271.72 | 1272.22 | 1269.0 |
| 2011-06-23 02:00:00 | ES | Futures | 1272.22 | 1273.46 | 1272.22 | 1272.72 | 2453.0 |
| 2011-06-23 02:05:00 | ES | Futures | 1272.72 | 1273.22 | 1272.47 | 1273.22 | 476.0 |
| 2011-06-23 02:10:00 | ES | Futures | 1273.22 | 1273.22 | 1272.47 | 1272.97 | 765.0 |
| 2011-06-23 02:15:00 | ES | Futures | 1272.97 | 1273.46 | 1272.72 | 1273.22 | 672.0 |
| 2011-06-23 02:20:00 | ES | Futures | 1273.22 | 1273.71 | 1273.22 | 1273.71 | 640.0 |
| 2011-06-23 02:25:00 | ES | Futures | 1273.71 | 1274.96 | 1273.71 | 1274.96 | 2218.0 |
| 2011-06-23 02:30:00 | ES | Futures | 1274.96 | 1274.96 | 1274.46 | 1274.71 | 703.0 |
| 2011-06-23 02:35:00 | ES | Futures | 1274.71 | 1274.71 | 1274.21 | 1274.46 | 967.0 |
| 2011-06-23 02:40:00 | ES | Futures | 1274.21 | 1274.96 | 1273.96 | 1274.96 | 1627.0 |
| 2011-06-23 02:45:00 | ES | Futures | 1274.96 | 1274.96 | 1274.71 | 1274.71 | 1815.0 |
| 2011-06-23 02:50:00 | ES | Futures | 1274.96 | 1274.96 | 1274.71 | 1274.96 | 1435.0 |
| 2011-06-23 02:55:00 | ES | Futures | 1274.71 | 1274.96 | 1273.96 | 1273.96 | 2196.0 |
| 2011-06-23 03:00:00 | ES | Futures | 1274.21 | 1274.46 | 1272.72 | 1272.97 | 5558.0 |
| 2011-06-23 03:05:00 | ES | Futures | 1272.97 | 1273.71 | 1271.72 | 1271.97 | 8977.0 |
| 2011-06-23 03:10:00 | ES | Futures | 1271.72 | 1272.47 | 1271.47 | 1272.22 | 2675.0 |
| 2011-06-23 03:15:00 | ES | Futures | 1271.97 | 1271.97 | 1270.47 | 1270.97 | 6989.0 |
| 2011-06-23 03:20:00 | ES | Futures | 1270.97 | 1272.47 | 1270.72 | 1272.47 | 4047.0 |
| 2011-06-23 03:25:00 | ES | Futures | 1272.22 | 1272.47 | 1271.47 | 1271.72 | 1997.0 |
| 2011-06-23 03:30:00 | ES | Futures | 1271.47 | 1272.72 | 1271.47 | 1272.22 | 2536.0 |
| 2011-06-23 03:35:00 | ES | Futures | 1272.22 | 1272.97 | 1271.97 | 1272.72 | 1735.0 |
| 2011-06-23 03:40:00 | ES | Futures | 1272.47 | 1273.46 | 1272.22 | 1272.97 | 3435.0 |
| 2011-06-23 03:45:00 | ES | Futures | 1273.22 | 1273.96 | 1272.72 | 1273.71 | 4488.0 |
| 2011-06-23 03:50:00 | ES | Futures | 1273.71 | 1274.71 | 1273.71 | 1273.96 | 4040.0 |
| 2011-06-23 03:55:00 | ES | Futures | 1273.71 | 1273.71 | 1272.72 | 1273.22 | 1368.0 |
| 2011-06-23 04:00:00 | ES | Futures | 1273.22 | 1273.46 | 1271.97 | 1272.47 | 2976.0 |
| 2011-06-23 04:05:00 | ES | Futures | 1272.22 | 1273.22 | 1271.22 | 1273.22 | 5498.0 |
> showing 50 of 13,267 rows — these rows as CSV