PREVIEW / futures_30min / 2014-08-20
file: by_date/futures_30min/2014/2014-08-20.parquet size: 74 KB rows: 2,864
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-08-20 00:00:00 | ES | Futures | 2060.67 | 2060.67 | 2059.63 | 2059.63 | 695.0 |
| 2014-08-20 00:30:00 | ES | Futures | 2059.63 | 2059.89 | 2059.63 | 2059.63 | 447.0 |
| 2014-08-20 01:00:00 | ES | Futures | 2059.89 | 2060.15 | 2059.63 | 2059.89 | 1183.0 |
| 2014-08-20 01:30:00 | ES | Futures | 2059.89 | 2060.15 | 2059.63 | 2059.63 | 980.0 |
| 2014-08-20 02:00:00 | ES | Futures | 2059.89 | 2060.41 | 2059.63 | 2059.89 | 3409.0 |
| 2014-08-20 02:30:00 | ES | Futures | 2059.89 | 2060.15 | 2058.85 | 2059.37 | 3549.0 |
| 2014-08-20 03:00:00 | ES | Futures | 2059.37 | 2060.15 | 2058.59 | 2059.89 | 9787.0 |
| 2014-08-20 03:30:00 | ES | Futures | 2059.89 | 2060.67 | 2058.85 | 2059.11 | 7533.0 |
| 2014-08-20 04:00:00 | ES | Futures | 2059.11 | 2059.37 | 2056.77 | 2057.81 | 14208.0 |
| 2014-08-20 04:30:00 | ES | Futures | 2057.55 | 2059.11 | 2057.55 | 2058.33 | 4899.0 |
| 2014-08-20 05:00:00 | ES | Futures | 2058.59 | 2058.85 | 2057.81 | 2058.07 | 6032.0 |
| 2014-08-20 05:30:00 | ES | Futures | 2058.07 | 2059.11 | 2057.55 | 2058.59 | 7758.0 |
| 2014-08-20 06:00:00 | ES | Futures | 2058.33 | 2059.37 | 2058.33 | 2059.11 | 3389.0 |
| 2014-08-20 06:30:00 | ES | Futures | 2059.11 | 2060.67 | 2059.11 | 2059.89 | 6756.0 |
| 2014-08-20 07:00:00 | ES | Futures | 2060.15 | 2061.2 | 2059.37 | 2060.94 | 10615.0 |
| 2014-08-20 07:30:00 | ES | Futures | 2060.94 | 2062.5 | 2060.15 | 2061.72 | 11105.0 |
| 2014-08-20 08:00:00 | ES | Futures | 2061.46 | 2061.72 | 2057.55 | 2059.11 | 28883.0 |
| 2014-08-20 08:30:00 | ES | Futures | 2059.37 | 2059.89 | 2057.29 | 2059.63 | 18735.0 |
| 2014-08-20 09:00:00 | ES | Futures | 2059.37 | 2059.89 | 2058.07 | 2059.37 | 15943.0 |
| 2014-08-20 09:30:00 | ES | Futures | 2059.63 | 2063.28 | 2059.11 | 2061.98 | 130377.0 |
| 2014-08-20 10:00:00 | ES | Futures | 2061.72 | 2064.32 | 2060.94 | 2064.06 | 70728.0 |
| 2014-08-20 10:30:00 | ES | Futures | 2064.06 | 2064.84 | 2061.98 | 2064.32 | 59343.0 |
| 2014-08-20 11:00:00 | ES | Futures | 2064.32 | 2065.11 | 2063.8 | 2064.58 | 42608.0 |
| 2014-08-20 11:30:00 | ES | Futures | 2064.32 | 2065.89 | 2064.32 | 2064.84 | 48368.0 |
| 2014-08-20 12:00:00 | ES | Futures | 2065.11 | 2065.11 | 2064.32 | 2064.84 | 22098.0 |
| 2014-08-20 12:30:00 | ES | Futures | 2065.11 | 2065.11 | 2064.32 | 2064.84 | 10638.0 |
| 2014-08-20 13:00:00 | ES | Futures | 2064.84 | 2067.45 | 2064.58 | 2066.41 | 39672.0 |
| 2014-08-20 13:30:00 | ES | Futures | 2066.41 | 2067.71 | 2065.37 | 2065.89 | 34355.0 |
| 2014-08-20 14:00:00 | ES | Futures | 2065.63 | 2065.89 | 2060.15 | 2064.32 | 151998.0 |
| 2014-08-20 14:30:00 | ES | Futures | 2064.32 | 2068.23 | 2064.32 | 2067.97 | 72837.0 |
| 2014-08-20 15:00:00 | ES | Futures | 2067.97 | 2070.06 | 2067.71 | 2068.75 | 61518.0 |
| 2014-08-20 15:30:00 | ES | Futures | 2068.75 | 2070.32 | 2067.45 | 2067.71 | 83800.0 |
| 2014-08-20 16:00:00 | ES | Futures | 2067.71 | 2067.97 | 2066.67 | 2067.71 | 48386.0 |
| 2014-08-20 16:30:00 | ES | Futures | 2067.71 | 2067.71 | 2066.67 | 2067.19 | 5390.0 |
| 2014-08-20 17:00:00 | ES | Futures | 2067.45 | 2067.71 | 2067.19 | 2067.71 | 1624.0 |
| 2014-08-20 18:00:00 | ES | Futures | 2066.93 | 2067.19 | 2066.41 | 2066.67 | 1847.0 |
| 2014-08-20 18:30:00 | ES | Futures | 2066.67 | 2067.19 | 2066.67 | 2066.93 | 622.0 |
| 2014-08-20 19:00:00 | ES | Futures | 2066.93 | 2067.45 | 2066.67 | 2067.45 | 1230.0 |
| 2014-08-20 19:30:00 | ES | Futures | 2067.19 | 2069.28 | 2067.19 | 2068.75 | 3624.0 |
| 2014-08-20 20:00:00 | ES | Futures | 2068.75 | 2069.01 | 2067.97 | 2068.23 | 1678.0 |
| 2014-08-20 20:30:00 | ES | Futures | 2068.23 | 2068.49 | 2067.71 | 2067.97 | 1440.0 |
| 2014-08-20 21:00:00 | ES | Futures | 2067.97 | 2068.49 | 2067.71 | 2068.49 | 1568.0 |
| 2014-08-20 21:30:00 | ES | Futures | 2068.75 | 2069.01 | 2066.41 | 2067.71 | 5000.0 |
| 2014-08-20 22:00:00 | ES | Futures | 2067.71 | 2068.49 | 2067.71 | 2068.49 | 1930.0 |
| 2014-08-20 22:30:00 | ES | Futures | 2068.23 | 2068.75 | 2067.97 | 2068.23 | 1552.0 |
| 2014-08-20 23:00:00 | ES | Futures | 2068.23 | 2068.23 | 2067.45 | 2067.97 | 1924.0 |
| 2014-08-20 23:30:00 | ES | Futures | 2067.71 | 2068.49 | 2067.71 | 2067.97 | 1577.0 |
| 2014-08-20 00:00:00 | NQ | Futures | 4711.36 | 4711.66 | 4709.03 | 4709.03 | 146.0 |
| 2014-08-20 00:30:00 | NQ | Futures | 4709.03 | 4710.2 | 4709.03 | 4709.9 | 77.0 |
| 2014-08-20 01:00:00 | NQ | Futures | 4709.9 | 4710.78 | 4709.32 | 4710.2 | 202.0 |
> showing 50 of 2,864 rows — these rows as CSV