PREVIEW / futures_1hour / 2015-08-24
file: by_date/futures_1hour/2015/2015-08-24.parquet size: 56 KB rows: 1,609
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-24 00:00:00 | ES | Futures | 2041.59 | 2053.04 | 2039.99 | 2046.65 | 42131.0 |
| 2015-08-24 01:00:00 | ES | Futures | 2046.38 | 2051.18 | 2035.73 | 2047.45 | 55915.0 |
| 2015-08-24 02:00:00 | ES | Futures | 2047.18 | 2057.57 | 2043.99 | 2048.25 | 66400.0 |
| 2015-08-24 03:00:00 | ES | Futures | 2048.25 | 2061.83 | 2047.72 | 2060.5 | 90659.0 |
| 2015-08-24 04:00:00 | ES | Futures | 2060.23 | 2064.76 | 2054.9 | 2063.69 | 63964.0 |
| 2015-08-24 05:00:00 | ES | Futures | 2063.96 | 2069.02 | 2059.43 | 2059.96 | 54954.0 |
| 2015-08-24 06:00:00 | ES | Futures | 2059.96 | 2062.36 | 2047.45 | 2059.7 | 77379.0 |
| 2015-08-24 07:00:00 | ES | Futures | 2059.96 | 2059.96 | 2021.36 | 2023.75 | 170912.0 |
| 2015-08-24 08:00:00 | ES | Futures | 2024.02 | 2034.94 | 2014.97 | 2018.69 | 193441.0 |
| 2015-08-24 09:00:00 | ES | Futures | 2018.69 | 2028.55 | 1950.0 | 2013.1 | 561487.0 |
| 2015-08-24 10:00:00 | ES | Futures | 2012.84 | 2053.84 | 2005.12 | 2045.05 | 743193.0 |
| 2015-08-24 11:00:00 | ES | Futures | 2044.79 | 2067.42 | 2027.48 | 2064.22 | 522510.0 |
| 2015-08-24 12:00:00 | ES | Futures | 2063.96 | 2076.74 | 2053.84 | 2069.28 | 446259.0 |
| 2015-08-24 13:00:00 | ES | Futures | 2069.28 | 2077.54 | 2041.86 | 2042.92 | 312247.0 |
| 2015-08-24 14:00:00 | ES | Futures | 2042.66 | 2044.52 | 2006.18 | 2008.84 | 448257.0 |
| 2015-08-24 15:00:00 | ES | Futures | 2008.58 | 2047.18 | 1995.26 | 2008.84 | 823797.0 |
| 2015-08-24 16:00:00 | ES | Futures | 2008.84 | 2012.04 | 1988.08 | 1995.8 | 215951.0 |
| 2015-08-24 17:00:00 | ES | Futures | 1995.8 | 1997.13 | 1989.41 | 1992.07 | 6364.0 |
| 2015-08-24 18:00:00 | ES | Futures | 1994.47 | 2010.71 | 1993.4 | 2007.25 | 22886.0 |
| 2015-08-24 19:00:00 | ES | Futures | 2006.98 | 2017.1 | 2002.45 | 2012.3 | 11138.0 |
| 2015-08-24 20:00:00 | ES | Futures | 2012.57 | 2029.88 | 2008.58 | 2021.36 | 30194.0 |
| 2015-08-24 21:00:00 | ES | Futures | 2021.62 | 2035.73 | 2019.23 | 2031.47 | 48380.0 |
| 2015-08-24 22:00:00 | ES | Futures | 2031.47 | 2044.79 | 2027.48 | 2037.6 | 27939.0 |
| 2015-08-24 23:00:00 | ES | Futures | 2037.6 | 2042.12 | 2032.01 | 2039.73 | 13793.0 |
| 2015-08-24 00:00:00 | NQ | Futures | 4762.21 | 4799.48 | 4758.96 | 4775.22 | 8755.0 |
| 2015-08-24 01:00:00 | NQ | Futures | 4775.22 | 4779.66 | 4745.94 | 4771.67 | 6558.0 |
| 2015-08-24 02:00:00 | NQ | Futures | 4772.56 | 4798.89 | 4765.76 | 4787.65 | 6513.0 |
| 2015-08-24 03:00:00 | NQ | Futures | 4787.94 | 4815.16 | 4784.39 | 4810.72 | 13482.0 |
| 2015-08-24 04:00:00 | NQ | Futures | 4810.42 | 4812.49 | 4779.37 | 4795.93 | 7431.0 |
| 2015-08-24 05:00:00 | NQ | Futures | 4795.63 | 4832.61 | 4790.9 | 4813.09 | 7075.0 |
| 2015-08-24 06:00:00 | NQ | Futures | 4813.09 | 4819.89 | 4775.82 | 4796.82 | 9353.0 |
| 2015-08-24 07:00:00 | NQ | Futures | 4796.52 | 4797.11 | 4723.46 | 4723.46 | 19653.0 |
| 2015-08-24 08:00:00 | NQ | Futures | 4723.46 | 4739.73 | 4723.46 | 4723.46 | 5255.0 |
| 2015-08-24 09:00:00 | NQ | Futures | 4723.46 | 4783.8 | 4624.08 | 4745.94 | 59725.0 |
| 2015-08-24 10:00:00 | NQ | Futures | 4744.76 | 4877.57 | 4728.79 | 4855.97 | 144390.0 |
| 2015-08-24 11:00:00 | NQ | Futures | 4856.27 | 4936.43 | 4812.79 | 4927.85 | 85437.0 |
| 2015-08-24 12:00:00 | NQ | Futures | 4927.56 | 4964.83 | 4902.71 | 4934.65 | 68840.0 |
| 2015-08-24 13:00:00 | NQ | Futures | 4934.95 | 4963.05 | 4861.0 | 4863.07 | 47749.0 |
| 2015-08-24 14:00:00 | NQ | Futures | 4863.37 | 4874.31 | 4767.24 | 4773.75 | 54286.0 |
| 2015-08-24 15:00:00 | NQ | Futures | 4773.15 | 4883.19 | 4727.31 | 4769.31 | 98134.0 |
| 2015-08-24 16:00:00 | NQ | Futures | 4769.6 | 4771.08 | 4726.71 | 4743.28 | 21792.0 |
| 2015-08-24 17:00:00 | NQ | Futures | 4743.28 | 4744.76 | 4729.67 | 4735.59 | 611.0 |
| 2015-08-24 18:00:00 | NQ | Futures | 4730.26 | 4777.89 | 4729.97 | 4769.6 | 3565.0 |
| 2015-08-24 19:00:00 | NQ | Futures | 4768.72 | 4784.39 | 4754.22 | 4771.08 | 2052.0 |
| 2015-08-24 20:00:00 | NQ | Futures | 4770.49 | 4812.2 | 4761.03 | 4789.13 | 5172.0 |
| 2015-08-24 21:00:00 | NQ | Futures | 4790.01 | 4825.51 | 4784.39 | 4812.2 | 6502.0 |
| 2015-08-24 22:00:00 | NQ | Futures | 4812.2 | 4851.24 | 4801.25 | 4837.34 | 5408.0 |
| 2015-08-24 23:00:00 | NQ | Futures | 4835.86 | 4843.85 | 4818.11 | 4836.45 | 2917.0 |
| 2015-08-24 00:00:00 | YM | Futures | 16859.6 | 16958.6 | 16846.9 | 16907.0 | 5490.0 |
| 2015-08-24 01:00:00 | YM | Futures | 16907.0 | 16924.9 | 16811.1 | 16894.3 | 8557.0 |
> showing 50 of 1,609 rows — these rows as CSV