PREVIEW / futures_5min / 2012-07-19
file: by_date/futures_5min/2012/2012-07-19.parquet size: 228 KB rows: 14,081
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-07-19 00:00:00 | ES | Futures | 1395.0 | 1395.25 | 1395.0 | 1395.0 | 28.0 |
| 2012-07-19 00:05:00 | ES | Futures | 1395.0 | 1395.25 | 1395.0 | 1395.25 | 20.0 |
| 2012-07-19 00:10:00 | ES | Futures | 1395.25 | 1395.25 | 1395.0 | 1395.25 | 45.0 |
| 2012-07-19 00:15:00 | ES | Futures | 1395.0 | 1395.51 | 1395.0 | 1395.25 | 361.0 |
| 2012-07-19 00:20:00 | ES | Futures | 1395.25 | 1395.25 | 1394.74 | 1394.74 | 222.0 |
| 2012-07-19 00:25:00 | ES | Futures | 1394.49 | 1394.74 | 1394.24 | 1394.24 | 237.0 |
| 2012-07-19 00:30:00 | ES | Futures | 1394.49 | 1394.49 | 1394.49 | 1394.49 | 44.0 |
| 2012-07-19 00:35:00 | ES | Futures | 1394.49 | 1394.74 | 1394.49 | 1394.49 | 32.0 |
| 2012-07-19 00:40:00 | ES | Futures | 1394.74 | 1395.0 | 1394.49 | 1394.49 | 191.0 |
| 2012-07-19 00:45:00 | ES | Futures | 1394.49 | 1395.0 | 1394.49 | 1395.0 | 94.0 |
| 2012-07-19 00:50:00 | ES | Futures | 1394.49 | 1394.74 | 1394.49 | 1394.74 | 189.0 |
| 2012-07-19 00:55:00 | ES | Futures | 1394.49 | 1394.74 | 1394.49 | 1394.74 | 29.0 |
| 2012-07-19 01:00:00 | ES | Futures | 1394.49 | 1394.49 | 1393.98 | 1394.49 | 435.0 |
| 2012-07-19 01:05:00 | ES | Futures | 1394.49 | 1394.74 | 1393.98 | 1394.74 | 233.0 |
| 2012-07-19 01:10:00 | ES | Futures | 1394.74 | 1395.0 | 1394.74 | 1394.74 | 123.0 |
| 2012-07-19 01:15:00 | ES | Futures | 1394.49 | 1394.74 | 1393.98 | 1394.24 | 312.0 |
| 2012-07-19 01:20:00 | ES | Futures | 1394.24 | 1394.49 | 1393.98 | 1394.24 | 204.0 |
| 2012-07-19 01:25:00 | ES | Futures | 1394.24 | 1394.74 | 1394.24 | 1394.49 | 266.0 |
| 2012-07-19 01:30:00 | ES | Futures | 1394.49 | 1394.74 | 1394.24 | 1394.49 | 114.0 |
| 2012-07-19 01:35:00 | ES | Futures | 1394.49 | 1395.25 | 1394.49 | 1395.25 | 131.0 |
| 2012-07-19 01:40:00 | ES | Futures | 1395.25 | 1395.25 | 1394.74 | 1394.74 | 301.0 |
| 2012-07-19 01:45:00 | ES | Futures | 1394.74 | 1394.74 | 1394.24 | 1394.49 | 128.0 |
| 2012-07-19 01:50:00 | ES | Futures | 1394.49 | 1394.49 | 1393.98 | 1393.98 | 393.0 |
| 2012-07-19 01:55:00 | ES | Futures | 1393.98 | 1394.49 | 1393.98 | 1394.24 | 442.0 |
| 2012-07-19 02:00:00 | ES | Futures | 1393.98 | 1394.49 | 1393.73 | 1394.49 | 959.0 |
| 2012-07-19 02:05:00 | ES | Futures | 1394.49 | 1395.0 | 1394.24 | 1394.49 | 479.0 |
| 2012-07-19 02:10:00 | ES | Futures | 1394.49 | 1394.74 | 1394.24 | 1394.49 | 740.0 |
| 2012-07-19 02:15:00 | ES | Futures | 1394.49 | 1394.74 | 1393.98 | 1394.49 | 911.0 |
| 2012-07-19 02:20:00 | ES | Futures | 1394.49 | 1394.74 | 1394.24 | 1394.24 | 625.0 |
| 2012-07-19 02:25:00 | ES | Futures | 1394.24 | 1394.49 | 1393.98 | 1393.98 | 658.0 |
| 2012-07-19 02:30:00 | ES | Futures | 1393.98 | 1394.49 | 1393.98 | 1393.98 | 246.0 |
| 2012-07-19 02:35:00 | ES | Futures | 1393.98 | 1394.74 | 1393.98 | 1393.98 | 961.0 |
| 2012-07-19 02:40:00 | ES | Futures | 1394.24 | 1394.24 | 1393.47 | 1393.98 | 962.0 |
| 2012-07-19 02:45:00 | ES | Futures | 1393.73 | 1393.98 | 1393.47 | 1393.73 | 435.0 |
| 2012-07-19 02:50:00 | ES | Futures | 1393.73 | 1394.24 | 1393.47 | 1393.98 | 282.0 |
| 2012-07-19 02:55:00 | ES | Futures | 1393.98 | 1395.0 | 1393.98 | 1394.49 | 667.0 |
| 2012-07-19 03:00:00 | ES | Futures | 1394.24 | 1395.25 | 1393.73 | 1394.74 | 2120.0 |
| 2012-07-19 03:05:00 | ES | Futures | 1395.0 | 1395.25 | 1393.98 | 1393.98 | 2846.0 |
| 2012-07-19 03:10:00 | ES | Futures | 1393.98 | 1395.0 | 1393.98 | 1394.24 | 2516.0 |
| 2012-07-19 03:15:00 | ES | Futures | 1394.49 | 1395.51 | 1394.24 | 1395.0 | 3418.0 |
| 2012-07-19 03:20:00 | ES | Futures | 1395.0 | 1395.25 | 1394.74 | 1395.0 | 2512.0 |
| 2012-07-19 03:25:00 | ES | Futures | 1394.74 | 1394.74 | 1393.98 | 1393.98 | 2056.0 |
| 2012-07-19 03:30:00 | ES | Futures | 1393.98 | 1394.49 | 1393.73 | 1393.98 | 1319.0 |
| 2012-07-19 03:35:00 | ES | Futures | 1393.98 | 1394.49 | 1393.73 | 1393.98 | 1342.0 |
| 2012-07-19 03:40:00 | ES | Futures | 1393.98 | 1394.49 | 1393.98 | 1393.98 | 834.0 |
| 2012-07-19 03:45:00 | ES | Futures | 1393.98 | 1394.24 | 1393.47 | 1394.24 | 1248.0 |
| 2012-07-19 03:50:00 | ES | Futures | 1393.98 | 1395.0 | 1393.73 | 1394.74 | 1685.0 |
| 2012-07-19 03:55:00 | ES | Futures | 1394.74 | 1394.74 | 1393.47 | 1393.73 | 2155.0 |
| 2012-07-19 04:00:00 | ES | Futures | 1393.73 | 1394.24 | 1393.73 | 1394.24 | 2813.0 |
| 2012-07-19 04:05:00 | ES | Futures | 1394.24 | 1395.0 | 1393.73 | 1394.24 | 2459.0 |
> showing 50 of 14,081 rows — these rows as CSV