PREVIEW / futures_5min / 2012-08-23
file: by_date/futures_5min/2012/2012-08-23.parquet size: 208 KB rows: 13,040
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-08-23 00:00:00 | ES | Futures | 1441.28 | 1441.79 | 1441.28 | 1441.28 | 438.0 |
| 2012-08-23 00:05:00 | ES | Futures | 1441.28 | 1441.28 | 1440.77 | 1440.77 | 403.0 |
| 2012-08-23 00:10:00 | ES | Futures | 1440.77 | 1441.28 | 1440.77 | 1441.28 | 133.0 |
| 2012-08-23 00:15:00 | ES | Futures | 1441.28 | 1441.28 | 1440.77 | 1441.02 | 127.0 |
| 2012-08-23 00:20:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1440.77 | 196.0 |
| 2012-08-23 00:25:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1441.02 | 15.0 |
| 2012-08-23 00:30:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1440.77 | 90.0 |
| 2012-08-23 00:35:00 | ES | Futures | 1440.77 | 1440.77 | 1440.52 | 1440.52 | 79.0 |
| 2012-08-23 00:40:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1441.02 | 243.0 |
| 2012-08-23 00:45:00 | ES | Futures | 1441.28 | 1441.53 | 1440.77 | 1440.77 | 433.0 |
| 2012-08-23 00:50:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1440.77 | 94.0 |
| 2012-08-23 00:55:00 | ES | Futures | 1440.52 | 1440.77 | 1440.52 | 1440.52 | 97.0 |
| 2012-08-23 01:00:00 | ES | Futures | 1440.52 | 1441.02 | 1440.52 | 1440.52 | 240.0 |
| 2012-08-23 01:05:00 | ES | Futures | 1440.77 | 1440.77 | 1440.52 | 1440.77 | 59.0 |
| 2012-08-23 01:10:00 | ES | Futures | 1440.52 | 1440.77 | 1440.26 | 1440.26 | 252.0 |
| 2012-08-23 01:15:00 | ES | Futures | 1440.52 | 1440.52 | 1440.26 | 1440.26 | 280.0 |
| 2012-08-23 01:20:00 | ES | Futures | 1440.52 | 1440.52 | 1440.26 | 1440.52 | 110.0 |
| 2012-08-23 01:25:00 | ES | Futures | 1440.26 | 1440.52 | 1440.26 | 1440.52 | 208.0 |
| 2012-08-23 01:30:00 | ES | Futures | 1440.26 | 1440.77 | 1440.26 | 1440.52 | 252.0 |
| 2012-08-23 01:35:00 | ES | Futures | 1440.26 | 1441.02 | 1440.26 | 1440.77 | 423.0 |
| 2012-08-23 01:40:00 | ES | Futures | 1440.77 | 1441.53 | 1440.77 | 1441.53 | 359.0 |
| 2012-08-23 01:45:00 | ES | Futures | 1441.28 | 1441.28 | 1441.02 | 1441.02 | 367.0 |
| 2012-08-23 01:50:00 | ES | Futures | 1441.02 | 1441.28 | 1440.77 | 1441.02 | 669.0 |
| 2012-08-23 01:55:00 | ES | Futures | 1440.77 | 1441.53 | 1440.77 | 1441.02 | 1113.0 |
| 2012-08-23 02:00:00 | ES | Futures | 1441.28 | 1441.28 | 1440.52 | 1440.77 | 909.0 |
| 2012-08-23 02:05:00 | ES | Futures | 1440.77 | 1441.02 | 1440.26 | 1440.26 | 760.0 |
| 2012-08-23 02:10:00 | ES | Futures | 1440.26 | 1440.52 | 1440.26 | 1440.26 | 339.0 |
| 2012-08-23 02:15:00 | ES | Futures | 1440.52 | 1440.77 | 1440.01 | 1440.26 | 950.0 |
| 2012-08-23 02:20:00 | ES | Futures | 1440.26 | 1440.26 | 1439.75 | 1440.01 | 647.0 |
| 2012-08-23 02:25:00 | ES | Futures | 1439.75 | 1440.01 | 1439.5 | 1439.5 | 678.0 |
| 2012-08-23 02:30:00 | ES | Futures | 1439.75 | 1440.01 | 1439.5 | 1440.01 | 608.0 |
| 2012-08-23 02:35:00 | ES | Futures | 1440.26 | 1440.77 | 1439.75 | 1440.77 | 741.0 |
| 2012-08-23 02:40:00 | ES | Futures | 1440.52 | 1440.77 | 1440.26 | 1440.52 | 470.0 |
| 2012-08-23 02:45:00 | ES | Futures | 1440.52 | 1440.77 | 1440.26 | 1440.77 | 319.0 |
| 2012-08-23 02:50:00 | ES | Futures | 1440.77 | 1441.02 | 1440.01 | 1440.26 | 402.0 |
| 2012-08-23 02:55:00 | ES | Futures | 1440.26 | 1441.28 | 1440.01 | 1440.77 | 1044.0 |
| 2012-08-23 03:00:00 | ES | Futures | 1441.02 | 1441.28 | 1440.26 | 1440.52 | 2569.0 |
| 2012-08-23 03:05:00 | ES | Futures | 1440.77 | 1441.28 | 1440.52 | 1440.77 | 2338.0 |
| 2012-08-23 03:10:00 | ES | Futures | 1440.77 | 1441.53 | 1440.52 | 1440.77 | 2550.0 |
| 2012-08-23 03:15:00 | ES | Futures | 1441.02 | 1441.28 | 1440.52 | 1441.02 | 2587.0 |
| 2012-08-23 03:20:00 | ES | Futures | 1441.28 | 1441.53 | 1441.02 | 1441.28 | 2159.0 |
| 2012-08-23 03:25:00 | ES | Futures | 1441.53 | 1442.3 | 1440.77 | 1441.02 | 4721.0 |
| 2012-08-23 03:30:00 | ES | Futures | 1440.77 | 1441.53 | 1440.52 | 1441.28 | 2400.0 |
| 2012-08-23 03:35:00 | ES | Futures | 1441.02 | 1441.28 | 1440.52 | 1440.77 | 2357.0 |
| 2012-08-23 03:40:00 | ES | Futures | 1440.77 | 1441.28 | 1440.52 | 1440.77 | 1469.0 |
| 2012-08-23 03:45:00 | ES | Futures | 1440.77 | 1440.77 | 1440.52 | 1440.77 | 1084.0 |
| 2012-08-23 03:50:00 | ES | Futures | 1440.77 | 1441.02 | 1439.75 | 1439.75 | 3697.0 |
| 2012-08-23 03:55:00 | ES | Futures | 1439.75 | 1440.52 | 1439.5 | 1439.5 | 2780.0 |
| 2012-08-23 04:00:00 | ES | Futures | 1439.5 | 1439.75 | 1438.99 | 1439.24 | 3371.0 |
| 2012-08-23 04:05:00 | ES | Futures | 1439.24 | 1440.26 | 1439.24 | 1440.26 | 1573.0 |
> showing 50 of 13,040 rows — these rows as CSV