PREVIEW / futures_30min / 2014-05-13
file: by_date/futures_30min/2014/2014-05-13.parquet size: 72 KB rows: 2,894
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-13 00:00:00 | ES | Futures | 1967.53 | 1968.31 | 1967.27 | 1968.05 | 1135.0 |
| 2014-05-13 00:30:00 | ES | Futures | 1968.05 | 1968.83 | 1968.05 | 1968.31 | 1409.0 |
| 2014-05-13 01:00:00 | ES | Futures | 1968.57 | 1968.57 | 1967.79 | 1968.05 | 1783.0 |
| 2014-05-13 01:30:00 | ES | Futures | 1968.05 | 1968.57 | 1967.27 | 1967.53 | 1624.0 |
| 2014-05-13 02:00:00 | ES | Futures | 1967.27 | 1968.31 | 1966.75 | 1968.05 | 5250.0 |
| 2014-05-13 02:30:00 | ES | Futures | 1967.79 | 1968.57 | 1967.53 | 1968.57 | 4473.0 |
| 2014-05-13 03:00:00 | ES | Futures | 1968.57 | 1968.83 | 1967.01 | 1967.53 | 9389.0 |
| 2014-05-13 03:30:00 | ES | Futures | 1967.79 | 1969.09 | 1967.79 | 1969.09 | 7465.0 |
| 2014-05-13 04:00:00 | ES | Futures | 1969.09 | 1969.61 | 1968.31 | 1968.57 | 7012.0 |
| 2014-05-13 04:30:00 | ES | Futures | 1968.57 | 1969.87 | 1968.31 | 1969.87 | 7025.0 |
| 2014-05-13 05:00:00 | ES | Futures | 1969.87 | 1969.87 | 1967.79 | 1968.05 | 9806.0 |
| 2014-05-13 05:30:00 | ES | Futures | 1968.31 | 1968.57 | 1967.01 | 1967.27 | 6601.0 |
| 2014-05-13 06:00:00 | ES | Futures | 1967.01 | 1969.87 | 1967.01 | 1968.83 | 13705.0 |
| 2014-05-13 06:30:00 | ES | Futures | 1968.83 | 1969.61 | 1968.31 | 1968.57 | 6480.0 |
| 2014-05-13 07:00:00 | ES | Futures | 1968.57 | 1969.61 | 1968.31 | 1969.09 | 10091.0 |
| 2014-05-13 07:30:00 | ES | Futures | 1969.09 | 1970.13 | 1968.83 | 1969.35 | 8346.0 |
| 2014-05-13 08:00:00 | ES | Futures | 1969.09 | 1969.87 | 1967.79 | 1968.57 | 12690.0 |
| 2014-05-13 08:30:00 | ES | Futures | 1968.57 | 1968.57 | 1965.97 | 1967.27 | 38462.0 |
| 2014-05-13 09:00:00 | ES | Futures | 1967.27 | 1968.31 | 1966.75 | 1967.53 | 20545.0 |
| 2014-05-13 09:30:00 | ES | Futures | 1967.53 | 1970.64 | 1965.97 | 1967.53 | 183494.0 |
| 2014-05-13 10:00:00 | ES | Futures | 1967.53 | 1970.9 | 1967.27 | 1970.13 | 101479.0 |
| 2014-05-13 10:30:00 | ES | Futures | 1970.38 | 1971.94 | 1969.61 | 1969.61 | 75133.0 |
| 2014-05-13 11:00:00 | ES | Futures | 1969.61 | 1970.38 | 1966.75 | 1968.57 | 79609.0 |
| 2014-05-13 11:30:00 | ES | Futures | 1968.57 | 1968.83 | 1965.45 | 1966.49 | 72705.0 |
| 2014-05-13 12:00:00 | ES | Futures | 1966.49 | 1968.05 | 1965.71 | 1967.01 | 42900.0 |
| 2014-05-13 12:30:00 | ES | Futures | 1967.27 | 1968.83 | 1965.71 | 1967.53 | 35805.0 |
| 2014-05-13 13:00:00 | ES | Futures | 1967.79 | 1968.31 | 1966.49 | 1968.05 | 27328.0 |
| 2014-05-13 13:30:00 | ES | Futures | 1968.05 | 1968.05 | 1965.71 | 1967.01 | 31033.0 |
| 2014-05-13 14:00:00 | ES | Futures | 1967.01 | 1968.05 | 1966.49 | 1967.53 | 20499.0 |
| 2014-05-13 14:30:00 | ES | Futures | 1967.53 | 1968.57 | 1967.27 | 1967.79 | 25044.0 |
| 2014-05-13 15:00:00 | ES | Futures | 1968.05 | 1968.31 | 1965.19 | 1967.01 | 37408.0 |
| 2014-05-13 15:30:00 | ES | Futures | 1966.75 | 1967.79 | 1965.97 | 1967.01 | 86793.0 |
| 2014-05-13 16:00:00 | ES | Futures | 1967.01 | 1968.31 | 1967.01 | 1967.53 | 54117.0 |
| 2014-05-13 16:30:00 | ES | Futures | 1967.27 | 1968.05 | 1967.01 | 1968.05 | 4315.0 |
| 2014-05-13 17:00:00 | ES | Futures | 1968.05 | 1968.31 | 1967.53 | 1968.31 | 2356.0 |
| 2014-05-13 18:00:00 | ES | Futures | 1968.05 | 1968.05 | 1967.01 | 1967.27 | 2373.0 |
| 2014-05-13 18:30:00 | ES | Futures | 1967.27 | 1967.27 | 1967.01 | 1967.27 | 308.0 |
| 2014-05-13 19:00:00 | ES | Futures | 1967.27 | 1968.05 | 1967.01 | 1967.79 | 972.0 |
| 2014-05-13 19:30:00 | ES | Futures | 1967.79 | 1968.05 | 1967.27 | 1967.27 | 914.0 |
| 2014-05-13 20:00:00 | ES | Futures | 1967.27 | 1967.79 | 1967.01 | 1967.27 | 1330.0 |
| 2014-05-13 20:30:00 | ES | Futures | 1967.27 | 1967.79 | 1967.01 | 1967.53 | 726.0 |
| 2014-05-13 21:00:00 | ES | Futures | 1967.27 | 1968.31 | 1967.01 | 1968.31 | 1620.0 |
| 2014-05-13 21:30:00 | ES | Futures | 1968.31 | 1968.57 | 1967.79 | 1968.05 | 2077.0 |
| 2014-05-13 22:00:00 | ES | Futures | 1968.05 | 1968.31 | 1967.79 | 1967.79 | 422.0 |
| 2014-05-13 22:30:00 | ES | Futures | 1968.05 | 1969.09 | 1967.79 | 1968.83 | 1690.0 |
| 2014-05-13 23:00:00 | ES | Futures | 1968.83 | 1969.61 | 1968.83 | 1969.35 | 976.0 |
| 2014-05-13 23:30:00 | ES | Futures | 1969.09 | 1970.13 | 1968.83 | 1969.87 | 2781.0 |
| 2014-05-13 00:00:00 | NQ | Futures | 4208.16 | 4209.91 | 4207.29 | 4209.91 | 184.0 |
| 2014-05-13 00:30:00 | NQ | Futures | 4209.91 | 4212.53 | 4209.62 | 4212.24 | 405.0 |
| 2014-05-13 01:00:00 | NQ | Futures | 4212.24 | 4212.24 | 4209.04 | 4209.33 | 487.0 |
> showing 50 of 2,894 rows — these rows as CSV