PREVIEW / futures_30min / 2012-10-08
file: by_date/futures_30min/2012/2012-10-08.parquet size: 70 KB rows: 2,700
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-10-08 00:00:00 | ES | Futures | 1484.5 | 1484.76 | 1483.99 | 1484.24 | 634.0 |
| 2012-10-08 00:30:00 | ES | Futures | 1484.24 | 1484.5 | 1483.99 | 1484.24 | 558.0 |
| 2012-10-08 01:00:00 | ES | Futures | 1484.24 | 1485.01 | 1483.99 | 1484.24 | 1238.0 |
| 2012-10-08 01:30:00 | ES | Futures | 1483.99 | 1484.5 | 1483.99 | 1484.24 | 1180.0 |
| 2012-10-08 02:00:00 | ES | Futures | 1484.24 | 1485.52 | 1484.24 | 1485.27 | 3628.0 |
| 2012-10-08 02:30:00 | ES | Futures | 1485.27 | 1486.29 | 1484.5 | 1486.03 | 2229.0 |
| 2012-10-08 03:00:00 | ES | Futures | 1485.78 | 1485.78 | 1482.71 | 1482.71 | 20000.0 |
| 2012-10-08 03:30:00 | ES | Futures | 1482.97 | 1482.97 | 1481.18 | 1481.69 | 22490.0 |
| 2012-10-08 04:00:00 | ES | Futures | 1481.69 | 1482.2 | 1480.67 | 1481.18 | 12831.0 |
| 2012-10-08 04:30:00 | ES | Futures | 1481.18 | 1482.71 | 1480.67 | 1482.2 | 7959.0 |
| 2012-10-08 05:00:00 | ES | Futures | 1482.2 | 1482.46 | 1481.43 | 1481.94 | 5552.0 |
| 2012-10-08 05:30:00 | ES | Futures | 1482.2 | 1482.46 | 1481.43 | 1481.43 | 4879.0 |
| 2012-10-08 06:00:00 | ES | Futures | 1481.43 | 1482.2 | 1480.16 | 1480.41 | 8564.0 |
| 2012-10-08 06:30:00 | ES | Futures | 1480.41 | 1481.94 | 1480.16 | 1481.69 | 6204.0 |
| 2012-10-08 07:00:00 | ES | Futures | 1481.69 | 1481.69 | 1480.41 | 1480.92 | 6612.0 |
| 2012-10-08 07:30:00 | ES | Futures | 1480.92 | 1482.2 | 1480.67 | 1481.43 | 7228.0 |
| 2012-10-08 08:00:00 | ES | Futures | 1481.69 | 1482.46 | 1481.18 | 1481.43 | 11101.0 |
| 2012-10-08 08:30:00 | ES | Futures | 1481.43 | 1483.73 | 1481.18 | 1481.94 | 15634.0 |
| 2012-10-08 09:00:00 | ES | Futures | 1481.69 | 1482.71 | 1481.18 | 1482.2 | 15768.0 |
| 2012-10-08 09:30:00 | ES | Futures | 1481.94 | 1482.46 | 1479.65 | 1481.69 | 124455.0 |
| 2012-10-08 10:00:00 | ES | Futures | 1481.43 | 1483.48 | 1479.9 | 1480.16 | 89088.0 |
| 2012-10-08 10:30:00 | ES | Futures | 1480.41 | 1484.24 | 1479.65 | 1482.2 | 98102.0 |
| 2012-10-08 11:00:00 | ES | Futures | 1482.46 | 1483.22 | 1480.16 | 1481.18 | 91048.0 |
| 2012-10-08 11:30:00 | ES | Futures | 1481.43 | 1481.43 | 1479.13 | 1480.92 | 68469.0 |
| 2012-10-08 12:00:00 | ES | Futures | 1480.92 | 1482.2 | 1480.16 | 1481.18 | 38545.0 |
| 2012-10-08 12:30:00 | ES | Futures | 1481.43 | 1482.46 | 1480.67 | 1482.2 | 17725.0 |
| 2012-10-08 13:00:00 | ES | Futures | 1482.46 | 1482.97 | 1480.92 | 1481.69 | 20904.0 |
| 2012-10-08 13:30:00 | ES | Futures | 1481.69 | 1482.97 | 1481.43 | 1481.69 | 23484.0 |
| 2012-10-08 14:00:00 | ES | Futures | 1481.69 | 1482.71 | 1481.18 | 1482.46 | 17749.0 |
| 2012-10-08 14:30:00 | ES | Futures | 1482.2 | 1482.71 | 1481.43 | 1481.94 | 19270.0 |
| 2012-10-08 15:00:00 | ES | Futures | 1481.94 | 1485.27 | 1481.94 | 1483.48 | 49669.0 |
| 2012-10-08 15:30:00 | ES | Futures | 1483.48 | 1484.24 | 1481.94 | 1482.46 | 74144.0 |
| 2012-10-08 16:00:00 | ES | Futures | 1482.46 | 1482.97 | 1481.18 | 1481.69 | 45560.0 |
| 2012-10-08 16:30:00 | ES | Futures | 1481.43 | 1481.43 | 1480.67 | 1480.92 | 3729.0 |
| 2012-10-08 17:00:00 | ES | Futures | 1480.92 | 1481.69 | 1480.92 | 1481.43 | 942.0 |
| 2012-10-08 18:00:00 | ES | Futures | 1481.43 | 1481.43 | 1480.41 | 1481.18 | 1295.0 |
| 2012-10-08 18:30:00 | ES | Futures | 1481.18 | 1481.43 | 1480.92 | 1481.18 | 316.0 |
| 2012-10-08 19:00:00 | ES | Futures | 1481.43 | 1482.71 | 1481.18 | 1482.2 | 1694.0 |
| 2012-10-08 19:30:00 | ES | Futures | 1482.2 | 1483.22 | 1481.94 | 1482.97 | 1473.0 |
| 2012-10-08 20:00:00 | ES | Futures | 1483.22 | 1484.76 | 1482.71 | 1483.99 | 4402.0 |
| 2012-10-08 20:30:00 | ES | Futures | 1483.99 | 1485.01 | 1483.99 | 1484.5 | 2382.0 |
| 2012-10-08 21:00:00 | ES | Futures | 1484.76 | 1485.52 | 1484.24 | 1485.01 | 3361.0 |
| 2012-10-08 21:30:00 | ES | Futures | 1485.27 | 1485.52 | 1484.76 | 1484.76 | 1513.0 |
| 2012-10-08 22:00:00 | ES | Futures | 1485.01 | 1486.03 | 1484.76 | 1485.52 | 3744.0 |
| 2012-10-08 22:30:00 | ES | Futures | 1485.52 | 1486.29 | 1485.27 | 1485.27 | 2373.0 |
| 2012-10-08 23:00:00 | ES | Futures | 1485.01 | 1485.27 | 1484.76 | 1484.76 | 491.0 |
| 2012-10-08 23:30:00 | ES | Futures | 1484.76 | 1485.52 | 1484.5 | 1484.76 | 1664.0 |
| 2012-10-08 00:00:00 | NQ | Futures | 3252.71 | 3252.71 | 3251.26 | 3251.84 | 250.0 |
| 2012-10-08 00:30:00 | NQ | Futures | 3252.13 | 3252.13 | 3251.26 | 3252.13 | 80.0 |
| 2012-10-08 01:00:00 | NQ | Futures | 3252.13 | 3253.87 | 3251.84 | 3251.84 | 86.0 |
> showing 50 of 2,700 rows — these rows as CSV