PREVIEW / futures_5min / 2011-01-19
file: by_date/futures_5min/2011/2011-01-19.parquet size: 230 KB rows: 13,722
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-01-19 00:00:00 | ES | Futures | 1280.93 | 1281.18 | 1280.93 | 1281.18 | 68.0 |
| 2011-01-19 00:05:00 | ES | Futures | 1281.18 | 1281.42 | 1281.18 | 1281.18 | 155.0 |
| 2011-01-19 00:10:00 | ES | Futures | 1281.18 | 1281.18 | 1280.93 | 1281.18 | 186.0 |
| 2011-01-19 00:15:00 | ES | Futures | 1280.93 | 1281.18 | 1280.93 | 1280.93 | 24.0 |
| 2011-01-19 00:20:00 | ES | Futures | 1280.93 | 1281.18 | 1280.93 | 1281.18 | 217.0 |
| 2011-01-19 00:25:00 | ES | Futures | 1281.18 | 1281.42 | 1280.93 | 1281.42 | 249.0 |
| 2011-01-19 00:30:00 | ES | Futures | 1281.42 | 1281.42 | 1281.18 | 1281.18 | 176.0 |
| 2011-01-19 00:35:00 | ES | Futures | 1281.18 | 1281.42 | 1281.18 | 1281.42 | 202.0 |
| 2011-01-19 00:40:00 | ES | Futures | 1281.42 | 1281.42 | 1280.93 | 1281.18 | 80.0 |
| 2011-01-19 00:45:00 | ES | Futures | 1280.93 | 1281.67 | 1280.93 | 1281.42 | 304.0 |
| 2011-01-19 00:50:00 | ES | Futures | 1281.67 | 1281.67 | 1281.42 | 1281.42 | 309.0 |
| 2011-01-19 00:55:00 | ES | Futures | 1281.42 | 1281.92 | 1281.42 | 1281.92 | 714.0 |
| 2011-01-19 01:00:00 | ES | Futures | 1281.67 | 1281.92 | 1281.67 | 1281.92 | 267.0 |
| 2011-01-19 01:05:00 | ES | Futures | 1281.92 | 1282.17 | 1281.67 | 1282.17 | 391.0 |
| 2011-01-19 01:10:00 | ES | Futures | 1282.17 | 1282.66 | 1282.17 | 1282.17 | 1289.0 |
| 2011-01-19 01:15:00 | ES | Futures | 1282.17 | 1282.17 | 1281.92 | 1282.17 | 147.0 |
| 2011-01-19 01:20:00 | ES | Futures | 1282.17 | 1282.66 | 1282.17 | 1282.41 | 747.0 |
| 2011-01-19 01:25:00 | ES | Futures | 1282.66 | 1282.66 | 1282.41 | 1282.66 | 222.0 |
| 2011-01-19 01:30:00 | ES | Futures | 1282.41 | 1282.66 | 1282.41 | 1282.41 | 58.0 |
| 2011-01-19 01:35:00 | ES | Futures | 1282.41 | 1282.66 | 1282.17 | 1282.41 | 227.0 |
| 2011-01-19 01:40:00 | ES | Futures | 1282.17 | 1282.41 | 1281.92 | 1282.17 | 187.0 |
| 2011-01-19 01:45:00 | ES | Futures | 1282.17 | 1282.17 | 1281.92 | 1281.92 | 85.0 |
| 2011-01-19 01:50:00 | ES | Futures | 1282.17 | 1282.66 | 1282.17 | 1282.41 | 187.0 |
| 2011-01-19 01:55:00 | ES | Futures | 1282.17 | 1282.91 | 1282.17 | 1282.66 | 704.0 |
| 2011-01-19 02:00:00 | ES | Futures | 1282.91 | 1282.91 | 1280.93 | 1281.18 | 1868.0 |
| 2011-01-19 02:05:00 | ES | Futures | 1281.42 | 1281.42 | 1280.68 | 1280.93 | 494.0 |
| 2011-01-19 02:10:00 | ES | Futures | 1281.18 | 1281.42 | 1280.93 | 1280.93 | 609.0 |
| 2011-01-19 02:15:00 | ES | Futures | 1281.18 | 1281.18 | 1280.93 | 1281.18 | 391.0 |
| 2011-01-19 02:20:00 | ES | Futures | 1280.93 | 1281.18 | 1280.68 | 1281.18 | 681.0 |
| 2011-01-19 02:25:00 | ES | Futures | 1281.18 | 1281.42 | 1280.93 | 1280.93 | 838.0 |
| 2011-01-19 02:30:00 | ES | Futures | 1281.18 | 1281.42 | 1280.68 | 1281.18 | 1329.0 |
| 2011-01-19 02:35:00 | ES | Futures | 1281.18 | 1281.18 | 1280.44 | 1280.68 | 745.0 |
| 2011-01-19 02:40:00 | ES | Futures | 1280.68 | 1280.68 | 1280.44 | 1280.68 | 287.0 |
| 2011-01-19 02:45:00 | ES | Futures | 1280.44 | 1280.68 | 1280.44 | 1280.68 | 302.0 |
| 2011-01-19 02:50:00 | ES | Futures | 1280.68 | 1280.68 | 1280.44 | 1280.68 | 452.0 |
| 2011-01-19 02:55:00 | ES | Futures | 1280.68 | 1280.93 | 1280.44 | 1280.93 | 2691.0 |
| 2011-01-19 03:00:00 | ES | Futures | 1281.18 | 1281.18 | 1280.44 | 1280.68 | 3503.0 |
| 2011-01-19 03:05:00 | ES | Futures | 1280.68 | 1280.93 | 1280.44 | 1280.44 | 2381.0 |
| 2011-01-19 03:10:00 | ES | Futures | 1280.68 | 1280.68 | 1279.69 | 1279.69 | 2585.0 |
| 2011-01-19 03:15:00 | ES | Futures | 1279.69 | 1280.44 | 1279.69 | 1280.19 | 1621.0 |
| 2011-01-19 03:20:00 | ES | Futures | 1280.44 | 1280.44 | 1279.45 | 1279.94 | 3219.0 |
| 2011-01-19 03:25:00 | ES | Futures | 1280.19 | 1280.19 | 1279.45 | 1279.94 | 1930.0 |
| 2011-01-19 03:30:00 | ES | Futures | 1279.94 | 1280.68 | 1279.94 | 1280.44 | 1360.0 |
| 2011-01-19 03:35:00 | ES | Futures | 1280.44 | 1280.93 | 1280.19 | 1280.44 | 1130.0 |
| 2011-01-19 03:40:00 | ES | Futures | 1280.44 | 1280.44 | 1280.19 | 1280.44 | 1101.0 |
| 2011-01-19 03:45:00 | ES | Futures | 1280.44 | 1280.93 | 1280.19 | 1280.68 | 1029.0 |
| 2011-01-19 03:50:00 | ES | Futures | 1280.93 | 1280.93 | 1279.94 | 1280.19 | 1265.0 |
| 2011-01-19 03:55:00 | ES | Futures | 1280.19 | 1280.44 | 1279.69 | 1279.69 | 1637.0 |
| 2011-01-19 04:00:00 | ES | Futures | 1279.69 | 1279.94 | 1278.95 | 1279.2 | 2703.0 |
| 2011-01-19 04:05:00 | ES | Futures | 1279.45 | 1279.69 | 1279.2 | 1279.45 | 1097.0 |
> showing 50 of 13,722 rows — these rows as CSV