PREVIEW / futures_30min / 2014-07-07
file: by_date/futures_30min/2014/2014-07-07.parquet size: 68 KB rows: 2,681
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-07-07 00:00:00 | ES | Futures | 2059.89 | 2060.41 | 2059.37 | 2059.63 | 680.0 |
| 2014-07-07 00:30:00 | ES | Futures | 2059.89 | 2059.89 | 2059.11 | 2059.11 | 216.0 |
| 2014-07-07 01:00:00 | ES | Futures | 2059.11 | 2059.37 | 2058.85 | 2058.85 | 833.0 |
| 2014-07-07 01:30:00 | ES | Futures | 2058.85 | 2060.15 | 2058.85 | 2059.37 | 973.0 |
| 2014-07-07 02:00:00 | ES | Futures | 2059.37 | 2059.63 | 2058.07 | 2058.07 | 4097.0 |
| 2014-07-07 02:30:00 | ES | Futures | 2058.07 | 2058.85 | 2058.07 | 2058.07 | 2300.0 |
| 2014-07-07 03:00:00 | ES | Futures | 2058.07 | 2059.63 | 2057.29 | 2058.85 | 9083.0 |
| 2014-07-07 03:30:00 | ES | Futures | 2058.85 | 2059.11 | 2057.55 | 2057.81 | 4701.0 |
| 2014-07-07 04:00:00 | ES | Futures | 2057.81 | 2058.59 | 2057.03 | 2058.33 | 7463.0 |
| 2014-07-07 04:30:00 | ES | Futures | 2058.33 | 2058.59 | 2057.03 | 2057.81 | 4828.0 |
| 2014-07-07 05:00:00 | ES | Futures | 2058.07 | 2058.85 | 2057.55 | 2058.85 | 3806.0 |
| 2014-07-07 05:30:00 | ES | Futures | 2058.85 | 2058.85 | 2058.07 | 2058.33 | 2605.0 |
| 2014-07-07 06:00:00 | ES | Futures | 2058.59 | 2059.63 | 2058.33 | 2059.37 | 4559.0 |
| 2014-07-07 06:30:00 | ES | Futures | 2059.37 | 2059.37 | 2057.81 | 2057.81 | 4743.0 |
| 2014-07-07 07:00:00 | ES | Futures | 2058.07 | 2058.33 | 2057.81 | 2058.33 | 3758.0 |
| 2014-07-07 07:30:00 | ES | Futures | 2058.33 | 2058.33 | 2056.5 | 2057.03 | 7288.0 |
| 2014-07-07 08:00:00 | ES | Futures | 2057.29 | 2057.29 | 2054.94 | 2056.24 | 16830.0 |
| 2014-07-07 08:30:00 | ES | Futures | 2056.24 | 2056.77 | 2055.46 | 2056.5 | 7909.0 |
| 2014-07-07 09:00:00 | ES | Futures | 2056.5 | 2058.07 | 2055.98 | 2057.03 | 12932.0 |
| 2014-07-07 09:30:00 | ES | Futures | 2057.29 | 2057.55 | 2054.16 | 2055.72 | 156166.0 |
| 2014-07-07 10:00:00 | ES | Futures | 2055.98 | 2058.85 | 2054.94 | 2057.55 | 104242.0 |
| 2014-07-07 10:30:00 | ES | Futures | 2057.55 | 2057.81 | 2053.12 | 2053.64 | 95917.0 |
| 2014-07-07 11:00:00 | ES | Futures | 2053.9 | 2054.42 | 2052.34 | 2053.12 | 107240.0 |
| 2014-07-07 11:30:00 | ES | Futures | 2052.86 | 2053.64 | 2051.29 | 2052.6 | 72489.0 |
| 2014-07-07 12:00:00 | ES | Futures | 2052.34 | 2054.68 | 2052.07 | 2053.64 | 49203.0 |
| 2014-07-07 12:30:00 | ES | Futures | 2053.64 | 2053.64 | 2051.55 | 2052.34 | 29847.0 |
| 2014-07-07 13:00:00 | ES | Futures | 2052.6 | 2053.64 | 2052.07 | 2053.12 | 27415.0 |
| 2014-07-07 13:30:00 | ES | Futures | 2052.86 | 2055.72 | 2052.6 | 2054.68 | 44271.0 |
| 2014-07-07 14:00:00 | ES | Futures | 2054.68 | 2054.94 | 2053.12 | 2053.12 | 33272.0 |
| 2014-07-07 14:30:00 | ES | Futures | 2053.12 | 2053.64 | 2050.77 | 2052.86 | 61704.0 |
| 2014-07-07 15:00:00 | ES | Futures | 2052.6 | 2053.64 | 2051.81 | 2052.86 | 33655.0 |
| 2014-07-07 15:30:00 | ES | Futures | 2052.86 | 2054.42 | 2051.81 | 2054.16 | 104992.0 |
| 2014-07-07 16:00:00 | ES | Futures | 2053.9 | 2055.2 | 2053.9 | 2054.94 | 59013.0 |
| 2014-07-07 16:30:00 | ES | Futures | 2054.94 | 2054.94 | 2053.9 | 2054.16 | 5183.0 |
| 2014-07-07 17:00:00 | ES | Futures | 2054.16 | 2054.68 | 2053.9 | 2054.42 | 1048.0 |
| 2014-07-07 18:00:00 | ES | Futures | 2054.16 | 2054.42 | 2053.64 | 2054.16 | 1263.0 |
| 2014-07-07 18:30:00 | ES | Futures | 2054.42 | 2054.42 | 2053.64 | 2053.9 | 433.0 |
| 2014-07-07 19:00:00 | ES | Futures | 2053.9 | 2053.9 | 2053.64 | 2053.9 | 620.0 |
| 2014-07-07 19:30:00 | ES | Futures | 2053.9 | 2054.16 | 2052.86 | 2053.64 | 1460.0 |
| 2014-07-07 20:00:00 | ES | Futures | 2053.64 | 2053.9 | 2052.07 | 2052.07 | 3217.0 |
| 2014-07-07 20:30:00 | ES | Futures | 2052.34 | 2052.6 | 2052.07 | 2052.6 | 1633.0 |
| 2014-07-07 21:00:00 | ES | Futures | 2052.34 | 2052.6 | 2052.07 | 2052.6 | 1428.0 |
| 2014-07-07 21:30:00 | ES | Futures | 2052.34 | 2052.6 | 2051.81 | 2052.34 | 1643.0 |
| 2014-07-07 22:00:00 | ES | Futures | 2052.07 | 2052.34 | 2051.55 | 2051.81 | 1180.0 |
| 2014-07-07 22:30:00 | ES | Futures | 2051.81 | 2052.07 | 2051.81 | 2051.81 | 355.0 |
| 2014-07-07 23:00:00 | ES | Futures | 2052.07 | 2052.34 | 2051.81 | 2052.34 | 1090.0 |
| 2014-07-07 23:30:00 | ES | Futures | 2052.07 | 2053.38 | 2051.81 | 2052.86 | 1933.0 |
| 2014-07-07 00:00:00 | NQ | Futures | 4571.2 | 4571.78 | 4570.32 | 4570.32 | 83.0 |
| 2014-07-07 00:30:00 | NQ | Futures | 4570.61 | 4570.91 | 4569.74 | 4569.74 | 97.0 |
| 2014-07-07 01:00:00 | NQ | Futures | 4569.45 | 4570.32 | 4569.15 | 4569.45 | 144.0 |
> showing 50 of 2,681 rows — these rows as CSV