PREVIEW / futures_5min / 2012-12-31
file: by_date/futures_5min/2012/2012-12-31.parquet size: 159 KB rows: 8,928
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-12-31 00:00:00 | ES | Futures | 1424.08 | 1424.34 | 1424.08 | 1424.08 | 156.0 |
| 2012-12-31 00:05:00 | ES | Futures | 1424.34 | 1424.34 | 1423.05 | 1423.05 | 273.0 |
| 2012-12-31 00:10:00 | ES | Futures | 1423.05 | 1423.82 | 1423.05 | 1423.82 | 192.0 |
| 2012-12-31 00:15:00 | ES | Futures | 1423.82 | 1424.34 | 1423.57 | 1424.34 | 56.0 |
| 2012-12-31 00:20:00 | ES | Futures | 1424.08 | 1424.34 | 1423.82 | 1423.82 | 114.0 |
| 2012-12-31 00:25:00 | ES | Futures | 1423.82 | 1424.08 | 1423.82 | 1423.82 | 45.0 |
| 2012-12-31 00:30:00 | ES | Futures | 1424.08 | 1424.08 | 1423.57 | 1423.57 | 61.0 |
| 2012-12-31 00:35:00 | ES | Futures | 1423.57 | 1424.59 | 1423.57 | 1424.34 | 237.0 |
| 2012-12-31 00:40:00 | ES | Futures | 1424.34 | 1424.59 | 1424.34 | 1424.34 | 34.0 |
| 2012-12-31 00:45:00 | ES | Futures | 1424.59 | 1424.59 | 1424.08 | 1424.34 | 50.0 |
| 2012-12-31 00:50:00 | ES | Futures | 1424.08 | 1424.34 | 1424.08 | 1424.08 | 52.0 |
| 2012-12-31 00:55:00 | ES | Futures | 1424.08 | 1424.34 | 1424.08 | 1424.08 | 20.0 |
| 2012-12-31 01:00:00 | ES | Futures | 1424.08 | 1424.08 | 1423.57 | 1423.82 | 59.0 |
| 2012-12-31 01:05:00 | ES | Futures | 1423.82 | 1424.34 | 1423.82 | 1424.34 | 82.0 |
| 2012-12-31 01:10:00 | ES | Futures | 1424.34 | 1424.34 | 1424.08 | 1424.08 | 42.0 |
| 2012-12-31 01:15:00 | ES | Futures | 1424.34 | 1424.85 | 1424.08 | 1424.85 | 218.0 |
| 2012-12-31 01:20:00 | ES | Futures | 1424.85 | 1424.85 | 1424.59 | 1424.85 | 33.0 |
| 2012-12-31 01:25:00 | ES | Futures | 1424.59 | 1425.36 | 1424.59 | 1425.36 | 144.0 |
| 2012-12-31 01:30:00 | ES | Futures | 1425.36 | 1425.36 | 1424.85 | 1425.11 | 239.0 |
| 2012-12-31 01:35:00 | ES | Futures | 1425.36 | 1425.62 | 1425.11 | 1425.62 | 179.0 |
| 2012-12-31 01:40:00 | ES | Futures | 1425.62 | 1425.62 | 1425.36 | 1425.36 | 37.0 |
| 2012-12-31 01:45:00 | ES | Futures | 1425.36 | 1425.88 | 1425.36 | 1425.88 | 230.0 |
| 2012-12-31 01:50:00 | ES | Futures | 1425.62 | 1425.88 | 1425.62 | 1425.62 | 26.0 |
| 2012-12-31 01:55:00 | ES | Futures | 1425.62 | 1425.88 | 1425.36 | 1425.36 | 284.0 |
| 2012-12-31 02:00:00 | ES | Futures | 1425.62 | 1425.62 | 1425.11 | 1425.62 | 91.0 |
| 2012-12-31 02:05:00 | ES | Futures | 1425.62 | 1425.62 | 1425.36 | 1425.36 | 60.0 |
| 2012-12-31 02:10:00 | ES | Futures | 1425.36 | 1425.88 | 1425.36 | 1425.62 | 83.0 |
| 2012-12-31 02:15:00 | ES | Futures | 1425.62 | 1425.88 | 1425.62 | 1425.62 | 233.0 |
| 2012-12-31 02:20:00 | ES | Futures | 1425.88 | 1425.88 | 1425.11 | 1425.36 | 118.0 |
| 2012-12-31 02:25:00 | ES | Futures | 1425.36 | 1425.88 | 1425.36 | 1425.62 | 390.0 |
| 2012-12-31 02:30:00 | ES | Futures | 1425.62 | 1425.88 | 1425.62 | 1425.62 | 113.0 |
| 2012-12-31 02:35:00 | ES | Futures | 1425.62 | 1425.88 | 1425.36 | 1425.88 | 222.0 |
| 2012-12-31 02:40:00 | ES | Futures | 1425.62 | 1426.13 | 1425.62 | 1426.13 | 105.0 |
| 2012-12-31 02:45:00 | ES | Futures | 1425.88 | 1426.13 | 1425.88 | 1425.88 | 111.0 |
| 2012-12-31 02:50:00 | ES | Futures | 1425.88 | 1425.88 | 1425.62 | 1425.88 | 109.0 |
| 2012-12-31 02:55:00 | ES | Futures | 1425.62 | 1425.88 | 1425.62 | 1425.62 | 34.0 |
| 2012-12-31 03:00:00 | ES | Futures | 1425.62 | 1426.39 | 1425.62 | 1425.62 | 409.0 |
| 2012-12-31 03:05:00 | ES | Futures | 1425.88 | 1426.13 | 1425.62 | 1425.88 | 329.0 |
| 2012-12-31 03:10:00 | ES | Futures | 1425.62 | 1426.39 | 1425.62 | 1426.13 | 744.0 |
| 2012-12-31 03:15:00 | ES | Futures | 1426.39 | 1426.65 | 1426.13 | 1426.65 | 788.0 |
| 2012-12-31 03:20:00 | ES | Futures | 1426.65 | 1426.9 | 1426.39 | 1426.65 | 350.0 |
| 2012-12-31 03:25:00 | ES | Futures | 1426.39 | 1427.16 | 1426.39 | 1426.39 | 660.0 |
| 2012-12-31 03:30:00 | ES | Futures | 1426.65 | 1426.9 | 1426.13 | 1426.65 | 621.0 |
| 2012-12-31 03:35:00 | ES | Futures | 1426.39 | 1427.42 | 1426.39 | 1427.16 | 809.0 |
| 2012-12-31 03:40:00 | ES | Futures | 1427.16 | 1427.93 | 1426.9 | 1427.42 | 965.0 |
| 2012-12-31 03:45:00 | ES | Futures | 1427.42 | 1427.67 | 1426.9 | 1427.16 | 564.0 |
| 2012-12-31 03:50:00 | ES | Futures | 1427.16 | 1427.42 | 1426.39 | 1427.42 | 497.0 |
| 2012-12-31 03:55:00 | ES | Futures | 1427.42 | 1427.93 | 1427.42 | 1427.93 | 357.0 |
| 2012-12-31 04:00:00 | ES | Futures | 1427.67 | 1427.93 | 1427.16 | 1427.42 | 542.0 |
| 2012-12-31 04:05:00 | ES | Futures | 1427.42 | 1427.67 | 1426.65 | 1427.16 | 371.0 |
> showing 50 of 8,928 rows — these rows as CSV