PREVIEW / futures_5min / 2012-07-31
file: by_date/futures_5min/2012/2012-07-31.parquet size: 225 KB rows: 13,557
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-31 00:00:00 | ES | Futures | 1407.97 | 1408.22 | 1407.71 | 1407.97 | 100.0 |
| 2012-07-31 00:05:00 | ES | Futures | 1407.97 | 1408.22 | 1407.71 | 1407.97 | 64.0 |
| 2012-07-31 00:10:00 | ES | Futures | 1407.71 | 1407.97 | 1407.46 | 1407.46 | 217.0 |
| 2012-07-31 00:15:00 | ES | Futures | 1407.46 | 1407.97 | 1407.46 | 1407.46 | 142.0 |
| 2012-07-31 00:20:00 | ES | Futures | 1407.46 | 1407.71 | 1407.46 | 1407.71 | 121.0 |
| 2012-07-31 00:25:00 | ES | Futures | 1407.71 | 1407.97 | 1407.46 | 1407.46 | 189.0 |
| 2012-07-31 00:30:00 | ES | Futures | 1407.46 | 1407.71 | 1407.2 | 1407.2 | 387.0 |
| 2012-07-31 00:35:00 | ES | Futures | 1407.2 | 1407.2 | 1406.95 | 1407.2 | 83.0 |
| 2012-07-31 00:40:00 | ES | Futures | 1407.2 | 1407.71 | 1406.95 | 1407.71 | 330.0 |
| 2012-07-31 00:45:00 | ES | Futures | 1407.71 | 1407.71 | 1406.95 | 1407.2 | 322.0 |
| 2012-07-31 00:50:00 | ES | Futures | 1407.2 | 1408.48 | 1407.2 | 1407.71 | 860.0 |
| 2012-07-31 00:55:00 | ES | Futures | 1407.97 | 1408.48 | 1407.71 | 1408.48 | 465.0 |
| 2012-07-31 01:00:00 | ES | Futures | 1408.48 | 1408.48 | 1407.97 | 1408.22 | 397.0 |
| 2012-07-31 01:05:00 | ES | Futures | 1408.22 | 1409.24 | 1408.22 | 1408.98 | 896.0 |
| 2012-07-31 01:10:00 | ES | Futures | 1409.24 | 1410.0 | 1408.98 | 1409.49 | 1806.0 |
| 2012-07-31 01:15:00 | ES | Futures | 1409.75 | 1410.0 | 1409.49 | 1409.75 | 386.0 |
| 2012-07-31 01:20:00 | ES | Futures | 1409.75 | 1410.26 | 1409.49 | 1410.26 | 797.0 |
| 2012-07-31 01:25:00 | ES | Futures | 1410.26 | 1410.26 | 1409.49 | 1410.26 | 552.0 |
| 2012-07-31 01:30:00 | ES | Futures | 1410.0 | 1410.26 | 1409.75 | 1410.0 | 508.0 |
| 2012-07-31 01:35:00 | ES | Futures | 1410.26 | 1410.26 | 1409.49 | 1409.49 | 332.0 |
| 2012-07-31 01:40:00 | ES | Futures | 1409.49 | 1409.75 | 1409.24 | 1409.49 | 723.0 |
| 2012-07-31 01:45:00 | ES | Futures | 1409.75 | 1409.75 | 1409.24 | 1409.49 | 486.0 |
| 2012-07-31 01:50:00 | ES | Futures | 1409.49 | 1409.75 | 1408.98 | 1408.98 | 350.0 |
| 2012-07-31 01:55:00 | ES | Futures | 1408.98 | 1409.24 | 1408.48 | 1408.98 | 1107.0 |
| 2012-07-31 02:00:00 | ES | Futures | 1408.98 | 1409.49 | 1408.22 | 1408.22 | 1661.0 |
| 2012-07-31 02:05:00 | ES | Futures | 1408.48 | 1408.48 | 1407.46 | 1407.71 | 859.0 |
| 2012-07-31 02:10:00 | ES | Futures | 1407.46 | 1407.71 | 1406.95 | 1406.95 | 964.0 |
| 2012-07-31 02:15:00 | ES | Futures | 1406.7 | 1406.95 | 1406.19 | 1406.7 | 1037.0 |
| 2012-07-31 02:20:00 | ES | Futures | 1406.95 | 1406.95 | 1406.44 | 1406.44 | 369.0 |
| 2012-07-31 02:25:00 | ES | Futures | 1406.7 | 1406.95 | 1406.44 | 1406.7 | 437.0 |
| 2012-07-31 02:30:00 | ES | Futures | 1406.7 | 1406.95 | 1406.19 | 1406.44 | 379.0 |
| 2012-07-31 02:35:00 | ES | Futures | 1406.44 | 1406.7 | 1406.19 | 1406.44 | 386.0 |
| 2012-07-31 02:40:00 | ES | Futures | 1406.44 | 1406.7 | 1405.93 | 1406.44 | 609.0 |
| 2012-07-31 02:45:00 | ES | Futures | 1406.19 | 1406.95 | 1406.19 | 1406.95 | 743.0 |
| 2012-07-31 02:50:00 | ES | Futures | 1406.95 | 1406.95 | 1406.19 | 1406.44 | 172.0 |
| 2012-07-31 02:55:00 | ES | Futures | 1406.7 | 1406.7 | 1405.93 | 1406.44 | 363.0 |
| 2012-07-31 03:00:00 | ES | Futures | 1406.7 | 1406.95 | 1406.19 | 1406.7 | 2216.0 |
| 2012-07-31 03:05:00 | ES | Futures | 1406.7 | 1406.7 | 1405.68 | 1406.19 | 3622.0 |
| 2012-07-31 03:10:00 | ES | Futures | 1406.19 | 1406.44 | 1404.66 | 1404.92 | 5468.0 |
| 2012-07-31 03:15:00 | ES | Futures | 1405.17 | 1405.93 | 1404.66 | 1405.68 | 2577.0 |
| 2012-07-31 03:20:00 | ES | Futures | 1405.68 | 1405.68 | 1404.66 | 1405.17 | 3214.0 |
| 2012-07-31 03:25:00 | ES | Futures | 1405.17 | 1406.7 | 1405.17 | 1405.93 | 2840.0 |
| 2012-07-31 03:30:00 | ES | Futures | 1405.93 | 1406.7 | 1405.93 | 1406.7 | 1426.0 |
| 2012-07-31 03:35:00 | ES | Futures | 1406.7 | 1408.48 | 1406.19 | 1407.46 | 4187.0 |
| 2012-07-31 03:40:00 | ES | Futures | 1407.2 | 1407.71 | 1406.95 | 1407.2 | 2010.0 |
| 2012-07-31 03:45:00 | ES | Futures | 1407.2 | 1407.97 | 1406.7 | 1407.2 | 1366.0 |
| 2012-07-31 03:50:00 | ES | Futures | 1407.2 | 1407.46 | 1406.7 | 1406.95 | 1156.0 |
| 2012-07-31 03:55:00 | ES | Futures | 1406.95 | 1406.95 | 1405.68 | 1405.93 | 1145.0 |
| 2012-07-31 04:00:00 | ES | Futures | 1405.68 | 1407.46 | 1405.68 | 1406.44 | 2327.0 |
| 2012-07-31 04:05:00 | ES | Futures | 1406.7 | 1406.7 | 1404.92 | 1405.42 | 3736.0 |
> showing 50 of 13,557 rows — these rows as CSV