PREVIEW / futures_30min / 2014-09-30
file: by_date/futures_30min/2014/2014-09-30.parquet size: 80 KB rows: 2,964
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-09-30 00:00:00 | ES | Futures | 2064.04 | 2064.83 | 2063.52 | 2064.83 | 2646.0 |
| 2014-09-30 00:30:00 | ES | Futures | 2064.83 | 2065.61 | 2064.56 | 2065.35 | 2705.0 |
| 2014-09-30 01:00:00 | ES | Futures | 2065.35 | 2065.61 | 2064.83 | 2065.61 | 753.0 |
| 2014-09-30 01:30:00 | ES | Futures | 2065.61 | 2065.61 | 2064.04 | 2064.56 | 2510.0 |
| 2014-09-30 02:00:00 | ES | Futures | 2064.56 | 2065.61 | 2064.3 | 2064.83 | 3245.0 |
| 2014-09-30 02:30:00 | ES | Futures | 2064.56 | 2068.49 | 2064.56 | 2067.97 | 9020.0 |
| 2014-09-30 03:00:00 | ES | Futures | 2067.97 | 2068.23 | 2065.61 | 2066.92 | 10846.0 |
| 2014-09-30 03:30:00 | ES | Futures | 2066.66 | 2067.97 | 2066.14 | 2067.97 | 7440.0 |
| 2014-09-30 04:00:00 | ES | Futures | 2067.97 | 2068.76 | 2066.92 | 2067.71 | 10567.0 |
| 2014-09-30 04:30:00 | ES | Futures | 2067.71 | 2068.49 | 2066.4 | 2067.71 | 7756.0 |
| 2014-09-30 05:00:00 | ES | Futures | 2067.45 | 2072.16 | 2067.45 | 2071.64 | 22121.0 |
| 2014-09-30 05:30:00 | ES | Futures | 2071.64 | 2071.64 | 2069.8 | 2070.85 | 7578.0 |
| 2014-09-30 06:00:00 | ES | Futures | 2070.85 | 2071.64 | 2070.07 | 2070.85 | 7447.0 |
| 2014-09-30 06:30:00 | ES | Futures | 2070.85 | 2071.11 | 2069.02 | 2070.85 | 8640.0 |
| 2014-09-30 07:00:00 | ES | Futures | 2071.11 | 2072.16 | 2069.02 | 2071.38 | 17188.0 |
| 2014-09-30 07:30:00 | ES | Futures | 2071.38 | 2071.64 | 2069.54 | 2071.11 | 9441.0 |
| 2014-09-30 08:00:00 | ES | Futures | 2071.38 | 2071.38 | 2068.76 | 2070.59 | 13491.0 |
| 2014-09-30 08:30:00 | ES | Futures | 2070.59 | 2070.85 | 2068.49 | 2068.76 | 14941.0 |
| 2014-09-30 09:00:00 | ES | Futures | 2068.76 | 2069.02 | 2064.3 | 2066.14 | 47694.0 |
| 2014-09-30 09:30:00 | ES | Futures | 2066.14 | 2069.02 | 2058.28 | 2061.16 | 221043.0 |
| 2014-09-30 10:00:00 | ES | Futures | 2061.16 | 2065.09 | 2056.71 | 2061.95 | 182528.0 |
| 2014-09-30 10:30:00 | ES | Futures | 2062.21 | 2070.07 | 2061.95 | 2068.76 | 131456.0 |
| 2014-09-30 11:00:00 | ES | Futures | 2068.76 | 2072.95 | 2068.23 | 2071.9 | 117238.0 |
| 2014-09-30 11:30:00 | ES | Futures | 2071.9 | 2072.69 | 2066.92 | 2067.97 | 87294.0 |
| 2014-09-30 12:00:00 | ES | Futures | 2067.97 | 2068.49 | 2062.73 | 2063.78 | 72685.0 |
| 2014-09-30 12:30:00 | ES | Futures | 2063.52 | 2064.3 | 2059.33 | 2061.68 | 100594.0 |
| 2014-09-30 13:00:00 | ES | Futures | 2061.68 | 2065.61 | 2059.85 | 2060.37 | 84138.0 |
| 2014-09-30 13:30:00 | ES | Futures | 2060.11 | 2061.16 | 2054.87 | 2058.02 | 111146.0 |
| 2014-09-30 14:00:00 | ES | Futures | 2057.75 | 2059.85 | 2055.13 | 2059.06 | 92198.0 |
| 2014-09-30 14:30:00 | ES | Futures | 2059.06 | 2062.21 | 2058.28 | 2060.37 | 79429.0 |
| 2014-09-30 15:00:00 | ES | Futures | 2060.11 | 2063.52 | 2057.23 | 2062.47 | 83054.0 |
| 2014-09-30 15:30:00 | ES | Futures | 2062.47 | 2065.09 | 2059.06 | 2059.33 | 236687.0 |
| 2014-09-30 16:00:00 | ES | Futures | 2059.33 | 2059.59 | 2056.18 | 2058.54 | 130915.0 |
| 2014-09-30 16:30:00 | ES | Futures | 2058.54 | 2059.06 | 2054.61 | 2055.4 | 20607.0 |
| 2014-09-30 17:00:00 | ES | Futures | 2055.4 | 2055.66 | 2054.35 | 2054.61 | 3766.0 |
| 2014-09-30 18:00:00 | ES | Futures | 2054.87 | 2056.44 | 2053.82 | 2055.66 | 10825.0 |
| 2014-09-30 18:30:00 | ES | Futures | 2055.66 | 2055.66 | 2054.61 | 2055.66 | 1509.0 |
| 2014-09-30 19:00:00 | ES | Futures | 2055.66 | 2055.92 | 2054.35 | 2054.61 | 1639.0 |
| 2014-09-30 19:30:00 | ES | Futures | 2054.87 | 2055.92 | 2054.61 | 2055.13 | 854.0 |
| 2014-09-30 20:00:00 | ES | Futures | 2055.13 | 2055.4 | 2052.78 | 2054.09 | 5165.0 |
| 2014-09-30 20:30:00 | ES | Futures | 2054.09 | 2055.66 | 2053.56 | 2054.35 | 3574.0 |
| 2014-09-30 21:00:00 | ES | Futures | 2054.35 | 2055.66 | 2053.56 | 2055.4 | 4340.0 |
| 2014-09-30 21:30:00 | ES | Futures | 2055.4 | 2055.66 | 2054.87 | 2055.13 | 1609.0 |
| 2014-09-30 22:00:00 | ES | Futures | 2055.13 | 2056.71 | 2055.13 | 2055.66 | 2656.0 |
| 2014-09-30 22:30:00 | ES | Futures | 2055.66 | 2056.97 | 2055.66 | 2056.97 | 1758.0 |
| 2014-09-30 23:00:00 | ES | Futures | 2056.97 | 2058.8 | 2056.44 | 2057.23 | 4181.0 |
| 2014-09-30 23:30:00 | ES | Futures | 2057.49 | 2057.75 | 2056.97 | 2057.23 | 1039.0 |
| 2014-09-30 00:00:00 | NQ | Futures | 4729.99 | 4732.92 | 4729.41 | 4732.92 | 250.0 |
| 2014-09-30 00:30:00 | NQ | Futures | 4732.92 | 4734.97 | 4732.34 | 4734.39 | 336.0 |
| 2014-09-30 01:00:00 | NQ | Futures | 4734.39 | 4734.68 | 4733.21 | 4733.8 | 140.0 |
> showing 50 of 2,964 rows — these rows as CSV