PREVIEW / futures_1hour / 2015-08-28
file: by_date/futures_1hour/2015/2015-08-28.parquet size: 45 KB rows: 1,293
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-28 00:00:00 | ES | Futures | 2107.89 | 2113.75 | 2107.09 | 2110.82 | 6579.0 |
| 2015-08-28 01:00:00 | ES | Futures | 2110.82 | 2112.68 | 2106.02 | 2109.49 | 12178.0 |
| 2015-08-28 02:00:00 | ES | Futures | 2109.22 | 2113.21 | 2105.23 | 2107.62 | 17264.0 |
| 2015-08-28 03:00:00 | ES | Futures | 2107.62 | 2112.41 | 2100.7 | 2102.56 | 44992.0 |
| 2015-08-28 04:00:00 | ES | Futures | 2102.83 | 2105.49 | 2096.44 | 2099.37 | 34991.0 |
| 2015-08-28 05:00:00 | ES | Futures | 2099.37 | 2105.76 | 2095.37 | 2103.63 | 34752.0 |
| 2015-08-28 06:00:00 | ES | Futures | 2103.89 | 2105.49 | 2096.44 | 2096.71 | 23970.0 |
| 2015-08-28 07:00:00 | ES | Futures | 2096.97 | 2104.96 | 2095.11 | 2101.5 | 33805.0 |
| 2015-08-28 08:00:00 | ES | Futures | 2101.76 | 2107.89 | 2098.84 | 2103.89 | 49684.0 |
| 2015-08-28 09:00:00 | ES | Futures | 2103.89 | 2113.75 | 2099.37 | 2112.41 | 247254.0 |
| 2015-08-28 10:00:00 | ES | Futures | 2112.15 | 2115.88 | 2104.43 | 2108.15 | 278868.0 |
| 2015-08-28 11:00:00 | ES | Futures | 2108.42 | 2120.4 | 2104.43 | 2106.82 | 242627.0 |
| 2015-08-28 12:00:00 | ES | Futures | 2106.82 | 2113.75 | 2104.96 | 2110.55 | 145296.0 |
| 2015-08-28 13:00:00 | ES | Futures | 2110.55 | 2112.15 | 2099.63 | 2105.76 | 141814.0 |
| 2015-08-28 14:00:00 | ES | Futures | 2105.76 | 2112.95 | 2103.63 | 2111.35 | 147050.0 |
| 2015-08-28 15:00:00 | ES | Futures | 2111.35 | 2115.88 | 2100.17 | 2114.28 | 324870.0 |
| 2015-08-28 16:00:00 | ES | Futures | 2114.54 | 2119.87 | 2112.15 | 2115.08 | 112473.0 |
| 2015-08-28 17:00:00 | ES | Futures | 2114.81 | 2116.14 | 2114.54 | 2115.34 | 2906.0 |
| 2015-08-28 00:00:00 | NQ | Futures | 5100.3 | 5122.48 | 5098.82 | 5115.38 | 2194.0 |
| 2015-08-28 01:00:00 | NQ | Futures | 5114.49 | 5119.52 | 5100.89 | 5108.87 | 2212.0 |
| 2015-08-28 02:00:00 | NQ | Futures | 5108.87 | 5122.19 | 5100.3 | 5108.58 | 1765.0 |
| 2015-08-28 03:00:00 | NQ | Futures | 5108.58 | 5119.82 | 5088.17 | 5092.61 | 6854.0 |
| 2015-08-28 04:00:00 | NQ | Futures | 5093.2 | 5098.23 | 5073.38 | 5081.66 | 6122.0 |
| 2015-08-28 05:00:00 | NQ | Futures | 5081.96 | 5096.16 | 5067.76 | 5090.54 | 4783.0 |
| 2015-08-28 06:00:00 | NQ | Futures | 5090.24 | 5094.09 | 5070.72 | 5071.9 | 2403.0 |
| 2015-08-28 07:00:00 | NQ | Futures | 5072.2 | 5086.69 | 5065.99 | 5080.18 | 3599.0 |
| 2015-08-28 08:00:00 | NQ | Futures | 5080.48 | 5096.45 | 5073.38 | 5087.58 | 7759.0 |
| 2015-08-28 09:00:00 | NQ | Futures | 5087.87 | 5116.27 | 5076.04 | 5107.69 | 43589.0 |
| 2015-08-28 10:00:00 | NQ | Futures | 5106.51 | 5110.06 | 5078.11 | 5097.34 | 44488.0 |
| 2015-08-28 11:00:00 | NQ | Futures | 5097.63 | 5133.43 | 5083.73 | 5091.42 | 45642.0 |
| 2015-08-28 12:00:00 | NQ | Futures | 5091.42 | 5113.02 | 5085.8 | 5105.03 | 22581.0 |
| 2015-08-28 13:00:00 | NQ | Futures | 5105.33 | 5110.95 | 5077.52 | 5089.35 | 23549.0 |
| 2015-08-28 14:00:00 | NQ | Futures | 5089.35 | 5113.9 | 5085.8 | 5109.17 | 27542.0 |
| 2015-08-28 15:00:00 | NQ | Futures | 5109.17 | 5119.82 | 5082.55 | 5116.27 | 48219.0 |
| 2015-08-28 16:00:00 | NQ | Futures | 5115.97 | 5128.1 | 5108.58 | 5114.79 | 12029.0 |
| 2015-08-28 17:00:00 | NQ | Futures | 5115.68 | 5118.93 | 5114.2 | 5116.27 | 152.0 |
| 2015-08-28 00:00:00 | YM | Futures | 17456.9 | 17508.5 | 17450.6 | 17485.3 | 766.0 |
| 2015-08-28 01:00:00 | YM | Futures | 17485.3 | 17500.1 | 17445.3 | 17478.0 | 1479.0 |
| 2015-08-28 02:00:00 | YM | Futures | 17476.9 | 17513.8 | 17448.5 | 17475.9 | 1690.0 |
| 2015-08-28 03:00:00 | YM | Futures | 17473.7 | 17501.1 | 17404.2 | 17422.1 | 4672.0 |
| 2015-08-28 04:00:00 | YM | Futures | 17421.1 | 17437.9 | 17358.9 | 17381.0 | 4813.0 |
| 2015-08-28 05:00:00 | YM | Futures | 17382.1 | 17436.9 | 17345.2 | 17416.9 | 4231.0 |
| 2015-08-28 06:00:00 | YM | Futures | 17417.9 | 17432.7 | 17365.2 | 17367.3 | 2055.0 |
| 2015-08-28 07:00:00 | YM | Futures | 17367.3 | 17425.3 | 17351.5 | 17397.9 | 3558.0 |
| 2015-08-28 08:00:00 | YM | Futures | 17402.1 | 17445.3 | 17377.9 | 17419.0 | 6532.0 |
| 2015-08-28 09:00:00 | YM | Futures | 17417.9 | 17491.7 | 17380.0 | 17479.0 | 26811.0 |
| 2015-08-28 10:00:00 | YM | Futures | 17479.0 | 17505.3 | 17419.0 | 17445.3 | 29648.0 |
| 2015-08-28 11:00:00 | YM | Futures | 17446.4 | 17539.1 | 17425.3 | 17445.3 | 26370.0 |
| 2015-08-28 12:00:00 | YM | Futures | 17443.2 | 17505.3 | 17431.6 | 17480.1 | 14245.0 |
| 2015-08-28 13:00:00 | YM | Futures | 17481.1 | 17492.7 | 17393.7 | 17440.0 | 14454.0 |
> showing 50 of 1,293 rows — these rows as CSV