PREVIEW / futures_1hour / 2015-08-27
file: by_date/futures_1hour/2015/2015-08-27.parquet size: 53 KB rows: 1,577
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-27 00:00:00 | ES | Futures | 2068.22 | 2068.48 | 2064.22 | 2064.49 | 5599.0 |
| 2015-08-27 01:00:00 | ES | Futures | 2064.49 | 2067.68 | 2063.16 | 2064.22 | 9123.0 |
| 2015-08-27 02:00:00 | ES | Futures | 2064.22 | 2075.67 | 2060.23 | 2073.28 | 25738.0 |
| 2015-08-27 03:00:00 | ES | Futures | 2073.28 | 2087.12 | 2069.02 | 2083.93 | 66800.0 |
| 2015-08-27 04:00:00 | ES | Futures | 2083.93 | 2091.65 | 2080.2 | 2091.11 | 41197.0 |
| 2015-08-27 05:00:00 | ES | Futures | 2091.38 | 2092.18 | 2084.46 | 2086.85 | 31738.0 |
| 2015-08-27 06:00:00 | ES | Futures | 2087.12 | 2091.38 | 2083.66 | 2084.19 | 25807.0 |
| 2015-08-27 07:00:00 | ES | Futures | 2084.46 | 2085.79 | 2079.13 | 2079.93 | 56042.0 |
| 2015-08-27 08:00:00 | ES | Futures | 2079.93 | 2091.38 | 2077.0 | 2089.52 | 85170.0 |
| 2015-08-27 09:00:00 | ES | Futures | 2089.52 | 2097.24 | 2085.26 | 2087.92 | 322439.0 |
| 2015-08-27 10:00:00 | ES | Futures | 2087.92 | 2102.3 | 2083.39 | 2101.5 | 356405.0 |
| 2015-08-27 11:00:00 | ES | Futures | 2101.5 | 2106.29 | 2096.17 | 2101.76 | 270135.0 |
| 2015-08-27 12:00:00 | ES | Futures | 2101.76 | 2114.01 | 2101.5 | 2113.21 | 224172.0 |
| 2015-08-27 13:00:00 | ES | Futures | 2113.48 | 2115.88 | 2106.82 | 2113.21 | 224452.0 |
| 2015-08-27 14:00:00 | ES | Futures | 2113.48 | 2113.48 | 2079.93 | 2081.0 | 358841.0 |
| 2015-08-27 15:00:00 | ES | Futures | 2081.26 | 2115.08 | 2070.61 | 2114.54 | 624668.0 |
| 2015-08-27 16:00:00 | ES | Futures | 2114.54 | 2119.6 | 2114.01 | 2118.27 | 125257.0 |
| 2015-08-27 17:00:00 | ES | Futures | 2118.27 | 2119.07 | 2117.21 | 2118.27 | 2574.0 |
| 2015-08-27 18:00:00 | ES | Futures | 2117.47 | 2118.01 | 2115.08 | 2115.61 | 7038.0 |
| 2015-08-27 19:00:00 | ES | Futures | 2115.61 | 2118.27 | 2114.28 | 2118.01 | 7168.0 |
| 2015-08-27 20:00:00 | ES | Futures | 2118.01 | 2122.27 | 2117.21 | 2119.6 | 13113.0 |
| 2015-08-27 21:00:00 | ES | Futures | 2119.6 | 2119.87 | 2111.08 | 2111.35 | 12029.0 |
| 2015-08-27 22:00:00 | ES | Futures | 2111.35 | 2116.14 | 2106.56 | 2106.82 | 15902.0 |
| 2015-08-27 23:00:00 | ES | Futures | 2107.09 | 2108.69 | 2106.56 | 2107.89 | 6496.0 |
| 2015-08-27 00:00:00 | NQ | Futures | 5003.87 | 5003.87 | 4989.97 | 4992.33 | 1282.0 |
| 2015-08-27 01:00:00 | NQ | Futures | 4992.63 | 5000.91 | 4986.12 | 4988.19 | 1472.0 |
| 2015-08-27 02:00:00 | NQ | Futures | 4988.49 | 5017.48 | 4975.47 | 5009.19 | 3281.0 |
| 2015-08-27 03:00:00 | NQ | Futures | 5008.31 | 5050.01 | 4996.18 | 5035.22 | 10882.0 |
| 2015-08-27 04:00:00 | NQ | Futures | 5035.22 | 5063.32 | 5029.9 | 5059.77 | 6552.0 |
| 2015-08-27 05:00:00 | NQ | Futures | 5059.77 | 5073.08 | 5053.27 | 5057.41 | 5712.0 |
| 2015-08-27 06:00:00 | NQ | Futures | 5058.0 | 5068.94 | 5047.35 | 5048.83 | 3802.0 |
| 2015-08-27 07:00:00 | NQ | Futures | 5049.72 | 5053.27 | 5036.11 | 5037.59 | 6473.0 |
| 2015-08-27 08:00:00 | NQ | Futures | 5037.29 | 5059.77 | 5030.49 | 5054.45 | 11235.0 |
| 2015-08-27 09:00:00 | NQ | Futures | 5055.04 | 5086.99 | 5045.58 | 5054.75 | 54340.0 |
| 2015-08-27 10:00:00 | NQ | Futures | 5055.34 | 5089.94 | 5040.84 | 5087.58 | 61158.0 |
| 2015-08-27 11:00:00 | NQ | Futures | 5087.28 | 5102.96 | 5068.65 | 5082.85 | 45659.0 |
| 2015-08-27 12:00:00 | NQ | Futures | 5082.85 | 5116.86 | 5081.07 | 5115.09 | 33771.0 |
| 2015-08-27 13:00:00 | NQ | Futures | 5114.79 | 5119.82 | 5086.69 | 5103.85 | 31256.0 |
| 2015-08-27 14:00:00 | NQ | Futures | 5103.55 | 5105.92 | 5025.76 | 5030.49 | 61297.0 |
| 2015-08-27 15:00:00 | NQ | Futures | 5030.79 | 5113.31 | 5000.62 | 5112.42 | 107284.0 |
| 2015-08-27 16:00:00 | NQ | Futures | 5112.13 | 5126.33 | 5111.83 | 5118.34 | 12591.0 |
| 2015-08-27 17:00:00 | NQ | Futures | 5118.04 | 5122.78 | 5117.45 | 5121.0 | 277.0 |
| 2015-08-27 18:00:00 | NQ | Futures | 5119.52 | 5119.82 | 5113.9 | 5115.09 | 610.0 |
| 2015-08-27 19:00:00 | NQ | Futures | 5115.68 | 5120.71 | 5114.2 | 5120.71 | 533.0 |
| 2015-08-27 20:00:00 | NQ | Futures | 5120.11 | 5135.79 | 5118.64 | 5129.28 | 2084.0 |
| 2015-08-27 21:00:00 | NQ | Futures | 5128.99 | 5129.58 | 5107.1 | 5110.06 | 1857.0 |
| 2015-08-27 22:00:00 | NQ | Futures | 5109.76 | 5122.19 | 5097.34 | 5097.93 | 2230.0 |
| 2015-08-27 23:00:00 | NQ | Futures | 5098.23 | 5103.25 | 5096.45 | 5100.59 | 1096.0 |
| 2015-08-27 00:00:00 | YM | Futures | 17156.7 | 17156.7 | 17120.8 | 17124.0 | 923.0 |
| 2015-08-27 01:00:00 | YM | Futures | 17125.0 | 17149.3 | 17109.2 | 17118.7 | 1250.0 |
> showing 50 of 1,577 rows — these rows as CSV