PREVIEW / futures_1hour / 2015-10-08
file: by_date/futures_1hour/2015/2015-10-08.parquet size: 52 KB rows: 1,556
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-10-08 00:00:00 | ES | Futures | 2116.0 | 2116.8 | 2112.25 | 2113.86 | 7202.0 |
| 2015-10-08 01:00:00 | ES | Futures | 2114.12 | 2116.26 | 2111.98 | 2111.98 | 8609.0 |
| 2015-10-08 02:00:00 | ES | Futures | 2112.25 | 2114.66 | 2111.18 | 2112.79 | 12457.0 |
| 2015-10-08 03:00:00 | ES | Futures | 2112.52 | 2116.8 | 2109.57 | 2115.19 | 29521.0 |
| 2015-10-08 04:00:00 | ES | Futures | 2115.46 | 2118.14 | 2112.25 | 2112.79 | 20617.0 |
| 2015-10-08 05:00:00 | ES | Futures | 2112.52 | 2118.4 | 2111.45 | 2115.73 | 16825.0 |
| 2015-10-08 06:00:00 | ES | Futures | 2116.0 | 2122.15 | 2116.0 | 2118.67 | 21318.0 |
| 2015-10-08 07:00:00 | ES | Futures | 2118.67 | 2122.15 | 2117.87 | 2121.35 | 24953.0 |
| 2015-10-08 08:00:00 | ES | Futures | 2121.08 | 2121.88 | 2115.19 | 2118.14 | 51697.0 |
| 2015-10-08 09:00:00 | ES | Futures | 2117.87 | 2124.29 | 2116.53 | 2122.42 | 190810.0 |
| 2015-10-08 10:00:00 | ES | Futures | 2122.42 | 2125.36 | 2118.94 | 2124.02 | 186483.0 |
| 2015-10-08 11:00:00 | ES | Futures | 2123.76 | 2126.97 | 2118.67 | 2126.16 | 167997.0 |
| 2015-10-08 12:00:00 | ES | Futures | 2126.43 | 2129.37 | 2119.47 | 2121.62 | 163126.0 |
| 2015-10-08 13:00:00 | ES | Futures | 2121.88 | 2128.84 | 2120.81 | 2128.04 | 112029.0 |
| 2015-10-08 14:00:00 | ES | Futures | 2128.3 | 2143.56 | 2125.63 | 2142.22 | 352809.0 |
| 2015-10-08 15:00:00 | ES | Futures | 2141.95 | 2149.98 | 2141.42 | 2146.23 | 307393.0 |
| 2015-10-08 16:00:00 | ES | Futures | 2145.96 | 2148.37 | 2144.63 | 2146.77 | 77584.0 |
| 2015-10-08 18:00:00 | ES | Futures | 2144.89 | 2146.23 | 2144.09 | 2145.96 | 3827.0 |
| 2015-10-08 19:00:00 | ES | Futures | 2145.96 | 2147.03 | 2145.16 | 2145.7 | 2748.0 |
| 2015-10-08 20:00:00 | ES | Futures | 2145.43 | 2147.3 | 2144.36 | 2145.16 | 6788.0 |
| 2015-10-08 21:00:00 | ES | Futures | 2144.89 | 2146.23 | 2143.02 | 2144.36 | 7412.0 |
| 2015-10-08 22:00:00 | ES | Futures | 2144.63 | 2147.03 | 2144.63 | 2145.43 | 4144.0 |
| 2015-10-08 23:00:00 | ES | Futures | 2145.43 | 2149.98 | 2145.16 | 2149.71 | 5151.0 |
| 2015-10-08 00:00:00 | NQ | Futures | 5102.02 | 5104.09 | 5092.83 | 5096.68 | 1656.0 |
| 2015-10-08 01:00:00 | NQ | Futures | 5096.68 | 5102.31 | 5090.45 | 5091.05 | 1700.0 |
| 2015-10-08 02:00:00 | NQ | Futures | 5091.34 | 5097.87 | 5089.27 | 5092.53 | 2303.0 |
| 2015-10-08 03:00:00 | NQ | Futures | 5093.42 | 5103.2 | 5085.41 | 5099.35 | 5639.0 |
| 2015-10-08 04:00:00 | NQ | Futures | 5099.65 | 5108.84 | 5087.19 | 5089.86 | 3724.0 |
| 2015-10-08 05:00:00 | NQ | Futures | 5088.97 | 5105.58 | 5085.71 | 5099.65 | 2955.0 |
| 2015-10-08 06:00:00 | NQ | Futures | 5099.94 | 5114.47 | 5099.94 | 5106.17 | 3405.0 |
| 2015-10-08 07:00:00 | NQ | Futures | 5106.76 | 5116.25 | 5104.39 | 5113.58 | 3161.0 |
| 2015-10-08 08:00:00 | NQ | Futures | 5112.99 | 5114.47 | 5099.05 | 5104.09 | 7786.0 |
| 2015-10-08 09:00:00 | NQ | Futures | 5103.8 | 5111.21 | 5090.16 | 5100.83 | 38796.0 |
| 2015-10-08 10:00:00 | NQ | Futures | 5100.83 | 5108.54 | 5080.97 | 5090.45 | 34484.0 |
| 2015-10-08 11:00:00 | NQ | Futures | 5090.45 | 5093.72 | 5066.44 | 5086.6 | 28762.0 |
| 2015-10-08 12:00:00 | NQ | Futures | 5086.3 | 5095.2 | 5058.14 | 5064.66 | 27710.0 |
| 2015-10-08 13:00:00 | NQ | Futures | 5065.25 | 5088.38 | 5063.47 | 5088.08 | 18694.0 |
| 2015-10-08 14:00:00 | NQ | Futures | 5087.79 | 5137.6 | 5082.75 | 5133.74 | 69056.0 |
| 2015-10-08 15:00:00 | NQ | Futures | 5133.74 | 5156.87 | 5131.07 | 5147.38 | 49865.0 |
| 2015-10-08 16:00:00 | NQ | Futures | 5147.38 | 5154.5 | 5142.64 | 5149.75 | 8356.0 |
| 2015-10-08 18:00:00 | NQ | Futures | 5144.71 | 5146.79 | 5142.93 | 5146.49 | 821.0 |
| 2015-10-08 19:00:00 | NQ | Futures | 5147.08 | 5151.83 | 5147.08 | 5148.86 | 635.0 |
| 2015-10-08 20:00:00 | NQ | Futures | 5148.57 | 5153.01 | 5146.19 | 5148.57 | 1358.0 |
| 2015-10-08 21:00:00 | NQ | Futures | 5148.27 | 5151.53 | 5142.04 | 5146.19 | 1305.0 |
| 2015-10-08 22:00:00 | NQ | Futures | 5146.79 | 5153.61 | 5146.79 | 5149.46 | 1108.0 |
| 2015-10-08 23:00:00 | NQ | Futures | 5150.05 | 5162.21 | 5149.46 | 5161.61 | 1272.0 |
| 2015-10-08 00:00:00 | YM | Futures | 17724.5 | 17730.8 | 17696.9 | 17707.5 | 1091.0 |
| 2015-10-08 01:00:00 | YM | Futures | 17708.6 | 17724.5 | 17690.6 | 17692.7 | 1227.0 |
| 2015-10-08 02:00:00 | YM | Futures | 17691.7 | 17713.9 | 17684.2 | 17692.7 | 2029.0 |
| 2015-10-08 03:00:00 | YM | Futures | 17692.7 | 17725.5 | 17668.3 | 17710.7 | 3577.0 |
> showing 50 of 1,556 rows — these rows as CSV