PREVIEW / futures_5min / 2012-07-20
file: by_date/futures_5min/2012/2012-07-20.parquet size: 195 KB rows: 11,520
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-20 00:00:00 | ES | Futures | 1391.44 | 1391.95 | 1391.44 | 1391.95 | 159.0 |
| 2012-07-20 00:05:00 | ES | Futures | 1391.69 | 1391.95 | 1391.69 | 1391.69 | 88.0 |
| 2012-07-20 00:10:00 | ES | Futures | 1391.95 | 1391.95 | 1391.44 | 1391.44 | 150.0 |
| 2012-07-20 00:15:00 | ES | Futures | 1391.69 | 1391.95 | 1391.44 | 1391.44 | 130.0 |
| 2012-07-20 00:20:00 | ES | Futures | 1391.69 | 1391.69 | 1391.44 | 1391.69 | 128.0 |
| 2012-07-20 00:25:00 | ES | Futures | 1391.69 | 1391.69 | 1391.18 | 1391.44 | 173.0 |
| 2012-07-20 00:30:00 | ES | Futures | 1391.44 | 1391.44 | 1391.18 | 1391.44 | 92.0 |
| 2012-07-20 00:35:00 | ES | Futures | 1391.44 | 1391.44 | 1390.93 | 1391.44 | 322.0 |
| 2012-07-20 00:40:00 | ES | Futures | 1391.44 | 1391.44 | 1391.18 | 1391.44 | 18.0 |
| 2012-07-20 00:45:00 | ES | Futures | 1391.18 | 1391.44 | 1391.18 | 1391.44 | 84.0 |
| 2012-07-20 00:50:00 | ES | Futures | 1391.44 | 1391.44 | 1390.93 | 1391.18 | 115.0 |
| 2012-07-20 00:55:00 | ES | Futures | 1391.18 | 1391.18 | 1390.93 | 1391.18 | 334.0 |
| 2012-07-20 01:00:00 | ES | Futures | 1391.18 | 1391.44 | 1390.93 | 1391.44 | 102.0 |
| 2012-07-20 01:05:00 | ES | Futures | 1391.44 | 1391.44 | 1390.68 | 1390.93 | 530.0 |
| 2012-07-20 01:10:00 | ES | Futures | 1390.68 | 1390.93 | 1390.42 | 1390.42 | 604.0 |
| 2012-07-20 01:15:00 | ES | Futures | 1390.68 | 1390.93 | 1390.42 | 1390.68 | 426.0 |
| 2012-07-20 01:20:00 | ES | Futures | 1390.68 | 1390.93 | 1390.68 | 1390.68 | 110.0 |
| 2012-07-20 01:25:00 | ES | Futures | 1390.93 | 1390.93 | 1390.42 | 1390.42 | 325.0 |
| 2012-07-20 01:30:00 | ES | Futures | 1390.68 | 1390.68 | 1390.42 | 1390.68 | 153.0 |
| 2012-07-20 01:35:00 | ES | Futures | 1390.42 | 1390.68 | 1389.91 | 1390.17 | 486.0 |
| 2012-07-20 01:40:00 | ES | Futures | 1390.17 | 1390.42 | 1389.91 | 1390.42 | 442.0 |
| 2012-07-20 01:45:00 | ES | Futures | 1390.17 | 1390.42 | 1389.91 | 1390.17 | 482.0 |
| 2012-07-20 01:50:00 | ES | Futures | 1390.17 | 1390.42 | 1389.91 | 1390.42 | 536.0 |
| 2012-07-20 01:55:00 | ES | Futures | 1390.17 | 1390.42 | 1390.17 | 1390.17 | 80.0 |
| 2012-07-20 02:00:00 | ES | Futures | 1390.17 | 1390.93 | 1389.91 | 1390.68 | 1105.0 |
| 2012-07-20 02:05:00 | ES | Futures | 1390.42 | 1390.68 | 1390.42 | 1390.42 | 178.0 |
| 2012-07-20 02:10:00 | ES | Futures | 1390.42 | 1391.18 | 1390.42 | 1391.18 | 414.0 |
| 2012-07-20 02:15:00 | ES | Futures | 1391.18 | 1391.44 | 1390.68 | 1390.68 | 625.0 |
| 2012-07-20 02:20:00 | ES | Futures | 1390.68 | 1390.93 | 1390.68 | 1390.68 | 300.0 |
| 2012-07-20 02:25:00 | ES | Futures | 1390.68 | 1390.93 | 1390.68 | 1390.93 | 128.0 |
| 2012-07-20 02:30:00 | ES | Futures | 1390.93 | 1391.18 | 1390.93 | 1391.18 | 359.0 |
| 2012-07-20 02:35:00 | ES | Futures | 1391.44 | 1391.44 | 1390.68 | 1390.93 | 444.0 |
| 2012-07-20 02:40:00 | ES | Futures | 1390.93 | 1390.93 | 1390.68 | 1390.68 | 282.0 |
| 2012-07-20 02:45:00 | ES | Futures | 1390.42 | 1390.68 | 1390.17 | 1390.17 | 566.0 |
| 2012-07-20 02:50:00 | ES | Futures | 1390.17 | 1390.42 | 1390.17 | 1390.42 | 183.0 |
| 2012-07-20 02:55:00 | ES | Futures | 1390.42 | 1391.44 | 1390.17 | 1390.93 | 757.0 |
| 2012-07-20 03:00:00 | ES | Futures | 1391.18 | 1391.44 | 1390.42 | 1390.68 | 1182.0 |
| 2012-07-20 03:05:00 | ES | Futures | 1390.93 | 1392.46 | 1390.68 | 1391.95 | 4296.0 |
| 2012-07-20 03:10:00 | ES | Futures | 1391.95 | 1393.22 | 1391.95 | 1392.96 | 4184.0 |
| 2012-07-20 03:15:00 | ES | Futures | 1393.22 | 1393.22 | 1391.95 | 1392.2 | 1922.0 |
| 2012-07-20 03:20:00 | ES | Futures | 1392.2 | 1392.46 | 1391.69 | 1391.95 | 1297.0 |
| 2012-07-20 03:25:00 | ES | Futures | 1391.69 | 1392.2 | 1391.18 | 1391.18 | 1560.0 |
| 2012-07-20 03:30:00 | ES | Futures | 1391.18 | 1391.69 | 1390.93 | 1391.44 | 1125.0 |
| 2012-07-20 03:35:00 | ES | Futures | 1391.18 | 1391.95 | 1390.93 | 1391.95 | 1302.0 |
| 2012-07-20 03:40:00 | ES | Futures | 1391.69 | 1393.22 | 1391.44 | 1392.46 | 2041.0 |
| 2012-07-20 03:45:00 | ES | Futures | 1392.46 | 1392.96 | 1391.69 | 1392.46 | 1703.0 |
| 2012-07-20 03:50:00 | ES | Futures | 1392.71 | 1392.96 | 1392.2 | 1392.71 | 1265.0 |
| 2012-07-20 03:55:00 | ES | Futures | 1392.46 | 1393.22 | 1392.46 | 1392.96 | 2268.0 |
| 2012-07-20 04:00:00 | ES | Futures | 1392.71 | 1393.22 | 1392.46 | 1392.46 | 1792.0 |
| 2012-07-20 04:05:00 | ES | Futures | 1392.71 | 1393.22 | 1392.46 | 1393.22 | 1175.0 |
> showing 50 of 11,520 rows — these rows as CSV