PREVIEW / futures_30min / 2016-02-25
file: by_date/futures_30min/2016/2016-02-25.parquet size: 85 KB rows: 3,007
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-25 00:00:00 | ES | Futures | 2076.85 | 2077.66 | 2074.16 | 2075.78 | 3442.0 |
| 2016-02-25 00:30:00 | ES | Futures | 2075.78 | 2077.12 | 2074.43 | 2076.58 | 2665.0 |
| 2016-02-25 01:00:00 | ES | Futures | 2076.58 | 2076.58 | 2069.6 | 2069.6 | 5713.0 |
| 2016-02-25 01:30:00 | ES | Futures | 2069.6 | 2071.21 | 2068.25 | 2069.33 | 5667.0 |
| 2016-02-25 02:00:00 | ES | Futures | 2069.33 | 2069.33 | 2064.76 | 2066.37 | 14863.0 |
| 2016-02-25 02:30:00 | ES | Futures | 2066.37 | 2069.6 | 2065.03 | 2069.33 | 13505.0 |
| 2016-02-25 03:00:00 | ES | Futures | 2069.33 | 2073.09 | 2063.95 | 2067.45 | 31639.0 |
| 2016-02-25 03:30:00 | ES | Futures | 2067.72 | 2071.48 | 2065.84 | 2066.1 | 20440.0 |
| 2016-02-25 04:00:00 | ES | Futures | 2065.84 | 2073.63 | 2065.84 | 2072.55 | 18905.0 |
| 2016-02-25 04:30:00 | ES | Futures | 2072.82 | 2073.63 | 2068.25 | 2071.48 | 11717.0 |
| 2016-02-25 05:00:00 | ES | Futures | 2071.21 | 2072.55 | 2067.45 | 2071.75 | 16013.0 |
| 2016-02-25 05:30:00 | ES | Futures | 2071.48 | 2076.05 | 2071.21 | 2075.24 | 12688.0 |
| 2016-02-25 06:00:00 | ES | Futures | 2074.97 | 2076.05 | 2072.28 | 2075.78 | 8264.0 |
| 2016-02-25 06:30:00 | ES | Futures | 2075.78 | 2079.0 | 2074.97 | 2078.2 | 12370.0 |
| 2016-02-25 07:00:00 | ES | Futures | 2078.2 | 2081.69 | 2077.39 | 2077.93 | 22559.0 |
| 2016-02-25 07:30:00 | ES | Futures | 2077.66 | 2079.0 | 2076.05 | 2076.05 | 13239.0 |
| 2016-02-25 08:00:00 | ES | Futures | 2076.05 | 2076.31 | 2073.63 | 2074.97 | 19184.0 |
| 2016-02-25 08:30:00 | ES | Futures | 2075.24 | 2078.73 | 2073.63 | 2076.85 | 37416.0 |
| 2016-02-25 09:00:00 | ES | Futures | 2076.58 | 2080.61 | 2075.24 | 2075.78 | 35732.0 |
| 2016-02-25 09:30:00 | ES | Futures | 2076.05 | 2081.69 | 2070.67 | 2072.02 | 215059.0 |
| 2016-02-25 10:00:00 | ES | Futures | 2071.75 | 2074.7 | 2065.84 | 2074.7 | 164048.0 |
| 2016-02-25 10:30:00 | ES | Futures | 2074.7 | 2076.58 | 2069.87 | 2070.4 | 113269.0 |
| 2016-02-25 11:00:00 | ES | Futures | 2070.67 | 2073.9 | 2067.98 | 2073.09 | 103411.0 |
| 2016-02-25 11:30:00 | ES | Futures | 2073.09 | 2077.39 | 2070.4 | 2076.58 | 86073.0 |
| 2016-02-25 12:00:00 | ES | Futures | 2076.58 | 2077.93 | 2074.43 | 2075.24 | 50169.0 |
| 2016-02-25 12:30:00 | ES | Futures | 2075.24 | 2076.05 | 2071.48 | 2074.7 | 58414.0 |
| 2016-02-25 13:00:00 | ES | Futures | 2074.7 | 2079.81 | 2073.9 | 2079.54 | 66991.0 |
| 2016-02-25 13:30:00 | ES | Futures | 2079.81 | 2085.99 | 2079.27 | 2085.45 | 96829.0 |
| 2016-02-25 14:00:00 | ES | Futures | 2085.45 | 2087.6 | 2083.03 | 2085.18 | 86743.0 |
| 2016-02-25 14:30:00 | ES | Futures | 2085.45 | 2086.26 | 2082.23 | 2083.3 | 50866.0 |
| 2016-02-25 15:00:00 | ES | Futures | 2083.57 | 2089.21 | 2082.76 | 2086.79 | 80776.0 |
| 2016-02-25 15:30:00 | ES | Futures | 2086.53 | 2095.39 | 2085.45 | 2095.39 | 178416.0 |
| 2016-02-25 16:00:00 | ES | Futures | 2095.12 | 2096.74 | 2094.05 | 2096.47 | 80881.0 |
| 2016-02-25 16:30:00 | ES | Futures | 2096.2 | 2097.54 | 2094.59 | 2095.66 | 10446.0 |
| 2016-02-25 18:00:00 | ES | Futures | 2094.86 | 2095.39 | 2093.78 | 2094.59 | 4269.0 |
| 2016-02-25 18:30:00 | ES | Futures | 2094.86 | 2097.27 | 2093.78 | 2096.74 | 4138.0 |
| 2016-02-25 19:00:00 | ES | Futures | 2096.47 | 2098.62 | 2095.66 | 2095.93 | 8312.0 |
| 2016-02-25 19:30:00 | ES | Futures | 2096.2 | 2097.54 | 2095.93 | 2097.27 | 2523.0 |
| 2016-02-25 20:00:00 | ES | Futures | 2097.27 | 2097.54 | 2095.39 | 2096.2 | 3253.0 |
| 2016-02-25 20:30:00 | ES | Futures | 2095.93 | 2097.01 | 2094.86 | 2095.12 | 4302.0 |
| 2016-02-25 21:00:00 | ES | Futures | 2095.12 | 2096.47 | 2094.32 | 2096.2 | 2566.0 |
| 2016-02-25 21:30:00 | ES | Futures | 2096.47 | 2099.42 | 2096.2 | 2098.35 | 4068.0 |
| 2016-02-25 22:00:00 | ES | Futures | 2098.35 | 2098.62 | 2097.01 | 2097.54 | 3433.0 |
| 2016-02-25 22:30:00 | ES | Futures | 2097.54 | 2099.96 | 2096.47 | 2096.47 | 4113.0 |
| 2016-02-25 23:00:00 | ES | Futures | 2096.74 | 2098.08 | 2095.66 | 2097.54 | 2113.0 |
| 2016-02-25 23:30:00 | ES | Futures | 2097.27 | 2097.54 | 2097.01 | 2097.54 | 943.0 |
| 2016-02-25 00:00:00 | NQ | Futures | 5007.45 | 5010.12 | 5000.03 | 5005.07 | 454.0 |
| 2016-02-25 00:30:00 | NQ | Futures | 5005.07 | 5008.64 | 5001.51 | 5008.04 | 250.0 |
| 2016-02-25 01:00:00 | NQ | Futures | 5007.75 | 5008.34 | 4986.07 | 4986.07 | 1292.0 |
| 2016-02-25 01:30:00 | NQ | Futures | 4986.07 | 4990.82 | 4981.62 | 4983.7 | 1520.0 |
> showing 50 of 3,007 rows — these rows as CSV