PREVIEW / futures_5min / 2012-11-20
file: by_date/futures_5min/2012/2012-11-20.parquet size: 208 KB rows: 13,836
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-11-20 00:00:00 | ES | Futures | 1411.18 | 1411.44 | 1410.93 | 1411.44 | 391.0 |
| 2012-11-20 00:05:00 | ES | Futures | 1411.44 | 1411.69 | 1411.18 | 1411.44 | 291.0 |
| 2012-11-20 00:10:00 | ES | Futures | 1411.69 | 1411.69 | 1411.18 | 1411.44 | 362.0 |
| 2012-11-20 00:15:00 | ES | Futures | 1411.18 | 1411.44 | 1410.93 | 1410.93 | 433.0 |
| 2012-11-20 00:20:00 | ES | Futures | 1410.93 | 1411.18 | 1410.67 | 1410.93 | 426.0 |
| 2012-11-20 00:25:00 | ES | Futures | 1410.93 | 1411.18 | 1410.93 | 1411.18 | 384.0 |
| 2012-11-20 00:30:00 | ES | Futures | 1411.18 | 1411.95 | 1410.93 | 1411.95 | 569.0 |
| 2012-11-20 00:35:00 | ES | Futures | 1411.69 | 1412.2 | 1411.69 | 1411.95 | 262.0 |
| 2012-11-20 00:40:00 | ES | Futures | 1411.95 | 1412.2 | 1411.95 | 1412.2 | 130.0 |
| 2012-11-20 00:45:00 | ES | Futures | 1411.95 | 1412.2 | 1411.69 | 1411.69 | 188.0 |
| 2012-11-20 00:50:00 | ES | Futures | 1411.69 | 1412.2 | 1411.69 | 1411.95 | 238.0 |
| 2012-11-20 00:55:00 | ES | Futures | 1411.69 | 1412.2 | 1411.69 | 1411.95 | 68.0 |
| 2012-11-20 01:00:00 | ES | Futures | 1411.69 | 1411.95 | 1410.93 | 1411.18 | 668.0 |
| 2012-11-20 01:05:00 | ES | Futures | 1411.18 | 1411.18 | 1410.93 | 1411.18 | 131.0 |
| 2012-11-20 01:10:00 | ES | Futures | 1411.18 | 1411.18 | 1410.93 | 1410.93 | 149.0 |
| 2012-11-20 01:15:00 | ES | Futures | 1410.93 | 1411.18 | 1410.67 | 1411.18 | 497.0 |
| 2012-11-20 01:20:00 | ES | Futures | 1410.93 | 1411.18 | 1410.93 | 1411.18 | 67.0 |
| 2012-11-20 01:25:00 | ES | Futures | 1410.93 | 1411.18 | 1410.42 | 1410.42 | 451.0 |
| 2012-11-20 01:30:00 | ES | Futures | 1410.67 | 1410.67 | 1410.42 | 1410.42 | 618.0 |
| 2012-11-20 01:35:00 | ES | Futures | 1410.42 | 1410.67 | 1410.16 | 1410.67 | 650.0 |
| 2012-11-20 01:40:00 | ES | Futures | 1410.67 | 1410.93 | 1410.16 | 1410.16 | 718.0 |
| 2012-11-20 01:45:00 | ES | Futures | 1410.42 | 1410.42 | 1410.16 | 1410.16 | 182.0 |
| 2012-11-20 01:50:00 | ES | Futures | 1410.16 | 1410.42 | 1409.9 | 1410.42 | 716.0 |
| 2012-11-20 01:55:00 | ES | Futures | 1410.42 | 1410.42 | 1410.16 | 1410.42 | 150.0 |
| 2012-11-20 02:00:00 | ES | Futures | 1410.42 | 1410.93 | 1410.16 | 1410.42 | 1054.0 |
| 2012-11-20 02:05:00 | ES | Futures | 1410.67 | 1411.44 | 1410.16 | 1411.44 | 549.0 |
| 2012-11-20 02:10:00 | ES | Futures | 1411.44 | 1411.44 | 1410.67 | 1411.18 | 663.0 |
| 2012-11-20 02:15:00 | ES | Futures | 1410.93 | 1411.18 | 1409.9 | 1410.16 | 1019.0 |
| 2012-11-20 02:20:00 | ES | Futures | 1409.9 | 1410.16 | 1409.14 | 1409.39 | 2407.0 |
| 2012-11-20 02:25:00 | ES | Futures | 1409.39 | 1409.65 | 1409.14 | 1409.39 | 1017.0 |
| 2012-11-20 02:30:00 | ES | Futures | 1409.14 | 1409.65 | 1409.14 | 1409.39 | 1225.0 |
| 2012-11-20 02:35:00 | ES | Futures | 1409.39 | 1409.65 | 1409.14 | 1409.39 | 379.0 |
| 2012-11-20 02:40:00 | ES | Futures | 1409.39 | 1409.39 | 1408.88 | 1409.14 | 953.0 |
| 2012-11-20 02:45:00 | ES | Futures | 1408.88 | 1409.14 | 1408.63 | 1408.88 | 1270.0 |
| 2012-11-20 02:50:00 | ES | Futures | 1408.88 | 1409.14 | 1408.88 | 1409.14 | 302.0 |
| 2012-11-20 02:55:00 | ES | Futures | 1408.88 | 1409.65 | 1408.88 | 1409.14 | 1093.0 |
| 2012-11-20 03:00:00 | ES | Futures | 1409.39 | 1409.39 | 1408.12 | 1408.88 | 3121.0 |
| 2012-11-20 03:05:00 | ES | Futures | 1408.88 | 1410.67 | 1408.37 | 1410.42 | 2962.0 |
| 2012-11-20 03:10:00 | ES | Futures | 1410.16 | 1411.69 | 1409.9 | 1411.69 | 3838.0 |
| 2012-11-20 03:15:00 | ES | Futures | 1411.69 | 1412.97 | 1411.44 | 1412.46 | 5350.0 |
| 2012-11-20 03:20:00 | ES | Futures | 1412.2 | 1412.46 | 1411.69 | 1411.69 | 2341.0 |
| 2012-11-20 03:25:00 | ES | Futures | 1411.69 | 1411.69 | 1410.93 | 1411.44 | 2732.0 |
| 2012-11-20 03:30:00 | ES | Futures | 1411.44 | 1411.69 | 1410.93 | 1410.93 | 2660.0 |
| 2012-11-20 03:35:00 | ES | Futures | 1410.93 | 1411.44 | 1410.93 | 1410.93 | 1378.0 |
| 2012-11-20 03:40:00 | ES | Futures | 1410.93 | 1411.69 | 1410.67 | 1410.93 | 1452.0 |
| 2012-11-20 03:45:00 | ES | Futures | 1410.67 | 1411.69 | 1410.67 | 1411.18 | 1595.0 |
| 2012-11-20 03:50:00 | ES | Futures | 1411.44 | 1411.44 | 1409.65 | 1410.16 | 2792.0 |
| 2012-11-20 03:55:00 | ES | Futures | 1410.16 | 1410.16 | 1409.14 | 1410.16 | 2521.0 |
| 2012-11-20 04:00:00 | ES | Futures | 1409.9 | 1410.42 | 1409.65 | 1410.16 | 1977.0 |
| 2012-11-20 04:05:00 | ES | Futures | 1410.16 | 1410.93 | 1409.65 | 1410.67 | 1389.0 |
> showing 50 of 13,836 rows — these rows as CSV