PREVIEW / futures_5min / 2012-08-19
file: by_date/futures_5min/2012/2012-08-19.parquet size: 35 KB rows: 1,973
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-19 18:00:00 | ES | Futures | 1439.24 | 1441.79 | 1438.99 | 1441.28 | 5108.0 |
| 2012-08-19 18:05:00 | ES | Futures | 1441.28 | 1441.53 | 1440.26 | 1441.02 | 1327.0 |
| 2012-08-19 18:10:00 | ES | Futures | 1440.77 | 1441.02 | 1440.52 | 1440.77 | 217.0 |
| 2012-08-19 18:15:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1440.77 | 61.0 |
| 2012-08-19 18:20:00 | ES | Futures | 1440.77 | 1441.02 | 1440.77 | 1441.02 | 175.0 |
| 2012-08-19 18:25:00 | ES | Futures | 1441.02 | 1441.02 | 1440.52 | 1440.77 | 466.0 |
| 2012-08-19 18:30:00 | ES | Futures | 1440.77 | 1440.77 | 1440.01 | 1440.01 | 495.0 |
| 2012-08-19 18:35:00 | ES | Futures | 1440.01 | 1440.26 | 1439.24 | 1439.5 | 1527.0 |
| 2012-08-19 18:40:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.75 | 92.0 |
| 2012-08-19 18:45:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.75 | 136.0 |
| 2012-08-19 18:50:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.75 | 22.0 |
| 2012-08-19 18:55:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.5 | 20.0 |
| 2012-08-19 19:00:00 | ES | Futures | 1439.5 | 1439.75 | 1439.24 | 1439.24 | 327.0 |
| 2012-08-19 19:05:00 | ES | Futures | 1439.24 | 1439.5 | 1439.24 | 1439.5 | 145.0 |
| 2012-08-19 19:10:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.5 | 44.0 |
| 2012-08-19 19:15:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.5 | 138.0 |
| 2012-08-19 19:20:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.5 | 120.0 |
| 2012-08-19 19:25:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.75 | 276.0 |
| 2012-08-19 19:30:00 | ES | Futures | 1439.75 | 1440.01 | 1439.5 | 1440.01 | 534.0 |
| 2012-08-19 19:35:00 | ES | Futures | 1440.01 | 1440.01 | 1439.75 | 1439.75 | 67.0 |
| 2012-08-19 19:40:00 | ES | Futures | 1439.75 | 1440.01 | 1439.75 | 1440.01 | 165.0 |
| 2012-08-19 19:45:00 | ES | Futures | 1440.01 | 1440.26 | 1440.01 | 1440.26 | 195.0 |
| 2012-08-19 19:50:00 | ES | Futures | 1440.01 | 1440.26 | 1439.5 | 1439.5 | 185.0 |
| 2012-08-19 19:55:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.5 | 266.0 |
| 2012-08-19 20:00:00 | ES | Futures | 1439.24 | 1439.5 | 1438.74 | 1439.24 | 921.0 |
| 2012-08-19 20:05:00 | ES | Futures | 1439.24 | 1439.5 | 1438.99 | 1439.24 | 496.0 |
| 2012-08-19 20:10:00 | ES | Futures | 1439.24 | 1439.5 | 1438.99 | 1438.99 | 257.0 |
| 2012-08-19 20:15:00 | ES | Futures | 1439.24 | 1439.5 | 1438.99 | 1439.5 | 416.0 |
| 2012-08-19 20:20:00 | ES | Futures | 1439.24 | 1439.5 | 1438.99 | 1439.24 | 136.0 |
| 2012-08-19 20:25:00 | ES | Futures | 1439.24 | 1439.75 | 1439.24 | 1439.5 | 509.0 |
| 2012-08-19 20:30:00 | ES | Futures | 1439.5 | 1439.75 | 1439.5 | 1439.5 | 96.0 |
| 2012-08-19 20:35:00 | ES | Futures | 1439.75 | 1439.75 | 1439.5 | 1439.5 | 30.0 |
| 2012-08-19 20:40:00 | ES | Futures | 1439.75 | 1439.75 | 1439.24 | 1439.5 | 153.0 |
| 2012-08-19 20:45:00 | ES | Futures | 1439.5 | 1440.01 | 1439.5 | 1439.75 | 535.0 |
| 2012-08-19 20:50:00 | ES | Futures | 1439.75 | 1440.26 | 1439.75 | 1440.26 | 513.0 |
| 2012-08-19 20:55:00 | ES | Futures | 1440.26 | 1440.26 | 1439.75 | 1440.01 | 274.0 |
| 2012-08-19 21:00:00 | ES | Futures | 1439.75 | 1440.01 | 1439.5 | 1439.5 | 327.0 |
| 2012-08-19 21:05:00 | ES | Futures | 1439.5 | 1440.01 | 1439.5 | 1439.5 | 327.0 |
| 2012-08-19 21:10:00 | ES | Futures | 1439.75 | 1440.26 | 1439.24 | 1439.75 | 485.0 |
| 2012-08-19 21:15:00 | ES | Futures | 1439.75 | 1440.01 | 1439.75 | 1440.01 | 144.0 |
| 2012-08-19 21:20:00 | ES | Futures | 1439.75 | 1440.01 | 1439.24 | 1439.5 | 379.0 |
| 2012-08-19 21:25:00 | ES | Futures | 1439.5 | 1439.75 | 1438.74 | 1438.99 | 1681.0 |
| 2012-08-19 21:30:00 | ES | Futures | 1439.24 | 1439.24 | 1438.74 | 1438.99 | 212.0 |
| 2012-08-19 21:35:00 | ES | Futures | 1438.99 | 1439.5 | 1438.74 | 1439.24 | 379.0 |
| 2012-08-19 21:40:00 | ES | Futures | 1439.24 | 1439.75 | 1438.99 | 1439.5 | 298.0 |
| 2012-08-19 21:45:00 | ES | Futures | 1439.5 | 1439.75 | 1438.99 | 1438.99 | 119.0 |
| 2012-08-19 21:50:00 | ES | Futures | 1438.99 | 1439.24 | 1438.74 | 1438.99 | 510.0 |
| 2012-08-19 21:55:00 | ES | Futures | 1438.99 | 1439.24 | 1438.74 | 1438.99 | 229.0 |
| 2012-08-19 22:00:00 | ES | Futures | 1438.99 | 1439.24 | 1438.99 | 1438.99 | 52.0 |
| 2012-08-19 22:05:00 | ES | Futures | 1438.99 | 1438.99 | 1438.74 | 1438.99 | 97.0 |
> showing 50 of 1,973 rows — these rows as CSV