PREVIEW / futures_30min / 2014-10-30
file: by_date/futures_30min/2014/2014-10-30.parquet size: 83 KB rows: 2,962
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-10-30 00:00:00 | ES | Futures | 2067.18 | 2067.45 | 2065.87 | 2066.66 | 1262.0 |
| 2014-10-30 00:30:00 | ES | Futures | 2066.66 | 2066.92 | 2066.66 | 2066.66 | 358.0 |
| 2014-10-30 01:00:00 | ES | Futures | 2066.92 | 2067.71 | 2066.92 | 2067.71 | 585.0 |
| 2014-10-30 01:30:00 | ES | Futures | 2067.45 | 2067.71 | 2066.92 | 2067.45 | 468.0 |
| 2014-10-30 02:00:00 | ES | Futures | 2067.18 | 2069.28 | 2066.92 | 2068.49 | 2191.0 |
| 2014-10-30 02:30:00 | ES | Futures | 2068.49 | 2068.76 | 2067.71 | 2067.97 | 455.0 |
| 2014-10-30 03:00:00 | ES | Futures | 2067.97 | 2070.33 | 2067.97 | 2070.07 | 5261.0 |
| 2014-10-30 03:30:00 | ES | Futures | 2069.8 | 2073.47 | 2068.76 | 2073.47 | 8510.0 |
| 2014-10-30 04:00:00 | ES | Futures | 2073.21 | 2075.57 | 2071.9 | 2073.21 | 23350.0 |
| 2014-10-30 04:30:00 | ES | Futures | 2073.47 | 2074.0 | 2068.76 | 2069.8 | 15069.0 |
| 2014-10-30 05:00:00 | ES | Futures | 2070.07 | 2070.07 | 2061.68 | 2064.56 | 24945.0 |
| 2014-10-30 05:30:00 | ES | Futures | 2064.56 | 2064.56 | 2058.28 | 2060.9 | 24950.0 |
| 2014-10-30 06:00:00 | ES | Futures | 2060.64 | 2062.73 | 2060.11 | 2060.64 | 14857.0 |
| 2014-10-30 06:30:00 | ES | Futures | 2060.64 | 2062.21 | 2055.4 | 2057.75 | 33741.0 |
| 2014-10-30 07:00:00 | ES | Futures | 2057.75 | 2058.8 | 2055.13 | 2055.4 | 23285.0 |
| 2014-10-30 07:30:00 | ES | Futures | 2055.4 | 2057.49 | 2053.04 | 2057.23 | 31790.0 |
| 2014-10-30 08:00:00 | ES | Futures | 2057.49 | 2061.16 | 2056.97 | 2059.06 | 20311.0 |
| 2014-10-30 08:30:00 | ES | Futures | 2059.33 | 2063.52 | 2058.02 | 2059.33 | 45346.0 |
| 2014-10-30 09:00:00 | ES | Futures | 2059.33 | 2064.3 | 2059.06 | 2064.3 | 30167.0 |
| 2014-10-30 09:30:00 | ES | Futures | 2064.3 | 2072.69 | 2064.04 | 2064.83 | 252301.0 |
| 2014-10-30 10:00:00 | ES | Futures | 2065.09 | 2070.59 | 2062.21 | 2069.8 | 182483.0 |
| 2014-10-30 10:30:00 | ES | Futures | 2069.8 | 2072.16 | 2066.66 | 2071.64 | 109255.0 |
| 2014-10-30 11:00:00 | ES | Futures | 2071.9 | 2074.78 | 2070.85 | 2072.16 | 113482.0 |
| 2014-10-30 11:30:00 | ES | Futures | 2072.42 | 2077.14 | 2071.11 | 2076.35 | 106795.0 |
| 2014-10-30 12:00:00 | ES | Futures | 2076.62 | 2077.93 | 2074.26 | 2077.14 | 74684.0 |
| 2014-10-30 12:30:00 | ES | Futures | 2076.88 | 2079.24 | 2076.88 | 2078.19 | 58896.0 |
| 2014-10-30 13:00:00 | ES | Futures | 2077.93 | 2085.78 | 2077.66 | 2084.21 | 117651.0 |
| 2014-10-30 13:30:00 | ES | Futures | 2084.47 | 2089.19 | 2083.43 | 2087.88 | 101968.0 |
| 2014-10-30 14:00:00 | ES | Futures | 2087.88 | 2089.71 | 2083.43 | 2083.69 | 90227.0 |
| 2014-10-30 14:30:00 | ES | Futures | 2083.69 | 2085.78 | 2075.83 | 2077.14 | 124017.0 |
| 2014-10-30 15:00:00 | ES | Futures | 2077.4 | 2080.54 | 2076.09 | 2077.93 | 92568.0 |
| 2014-10-30 15:30:00 | ES | Futures | 2078.19 | 2084.74 | 2077.4 | 2084.21 | 157025.0 |
| 2014-10-30 16:00:00 | ES | Futures | 2084.21 | 2084.74 | 2082.38 | 2083.95 | 61412.0 |
| 2014-10-30 16:30:00 | ES | Futures | 2083.43 | 2084.47 | 2082.9 | 2084.21 | 6845.0 |
| 2014-10-30 17:00:00 | ES | Futures | 2084.21 | 2084.47 | 2083.16 | 2083.43 | 3228.0 |
| 2014-10-30 18:00:00 | ES | Futures | 2082.9 | 2083.16 | 2081.85 | 2082.64 | 2763.0 |
| 2014-10-30 18:30:00 | ES | Futures | 2082.9 | 2085.0 | 2082.64 | 2084.21 | 2843.0 |
| 2014-10-30 19:00:00 | ES | Futures | 2084.21 | 2084.47 | 2083.43 | 2083.43 | 966.0 |
| 2014-10-30 19:30:00 | ES | Futures | 2083.43 | 2085.52 | 2083.43 | 2085.0 | 1524.0 |
| 2014-10-30 20:00:00 | ES | Futures | 2084.74 | 2085.0 | 2082.38 | 2083.16 | 3188.0 |
| 2014-10-30 20:30:00 | ES | Futures | 2083.16 | 2084.74 | 2082.9 | 2084.21 | 2084.0 |
| 2014-10-30 21:00:00 | ES | Futures | 2084.47 | 2086.31 | 2084.21 | 2086.05 | 2503.0 |
| 2014-10-30 21:30:00 | ES | Futures | 2086.31 | 2087.88 | 2085.52 | 2087.36 | 3979.0 |
| 2014-10-30 22:00:00 | ES | Futures | 2087.62 | 2087.62 | 2085.78 | 2086.57 | 1710.0 |
| 2014-10-30 22:30:00 | ES | Futures | 2086.83 | 2088.67 | 2086.83 | 2087.88 | 2006.0 |
| 2014-10-30 23:00:00 | ES | Futures | 2087.88 | 2088.67 | 2087.62 | 2088.14 | 1012.0 |
| 2014-10-30 23:30:00 | ES | Futures | 2088.14 | 2088.4 | 2087.62 | 2087.88 | 1358.0 |
| 2014-10-30 00:00:00 | NQ | Futures | 4776.58 | 4776.58 | 4774.24 | 4774.53 | 161.0 |
| 2014-10-30 00:30:00 | NQ | Futures | 4774.53 | 4776.58 | 4774.53 | 4776.58 | 141.0 |
| 2014-10-30 01:00:00 | NQ | Futures | 4776.58 | 4778.04 | 4776.29 | 4777.75 | 130.0 |
> showing 50 of 2,962 rows — these rows as CSV