PREVIEW / futures_1hour / 2015-08-26
file: by_date/futures_1hour/2015/2015-08-26.parquet size: 54 KB rows: 1,586
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-26 00:00:00 | ES | Futures | 2003.25 | 2018.96 | 2000.06 | 2018.69 | 19342.0 |
| 2015-08-26 01:00:00 | ES | Futures | 2018.96 | 2027.75 | 2017.1 | 2021.89 | 25069.0 |
| 2015-08-26 02:00:00 | ES | Futures | 2022.16 | 2025.88 | 2004.58 | 2014.43 | 42213.0 |
| 2015-08-26 03:00:00 | ES | Futures | 2014.43 | 2016.83 | 2001.65 | 2009.38 | 57985.0 |
| 2015-08-26 04:00:00 | ES | Futures | 2009.11 | 2033.07 | 2008.04 | 2021.09 | 65359.0 |
| 2015-08-26 05:00:00 | ES | Futures | 2021.36 | 2025.08 | 2016.56 | 2020.03 | 25528.0 |
| 2015-08-26 06:00:00 | ES | Futures | 2019.76 | 2030.94 | 2015.23 | 2029.61 | 47001.0 |
| 2015-08-26 07:00:00 | ES | Futures | 2029.88 | 2039.46 | 2026.42 | 2028.01 | 73481.0 |
| 2015-08-26 08:00:00 | ES | Futures | 2027.75 | 2048.51 | 2026.68 | 2040.26 | 129822.0 |
| 2015-08-26 09:00:00 | ES | Futures | 2040.26 | 2043.46 | 2018.43 | 2025.08 | 424510.0 |
| 2015-08-26 10:00:00 | ES | Futures | 2025.35 | 2032.81 | 2007.51 | 2017.63 | 492627.0 |
| 2015-08-26 11:00:00 | ES | Futures | 2017.63 | 2020.03 | 2001.65 | 2009.91 | 333666.0 |
| 2015-08-26 12:00:00 | ES | Futures | 2009.91 | 2012.57 | 1997.39 | 2012.3 | 260175.0 |
| 2015-08-26 13:00:00 | ES | Futures | 2012.3 | 2030.41 | 2006.98 | 2028.81 | 270485.0 |
| 2015-08-26 14:00:00 | ES | Futures | 2028.55 | 2040.26 | 2015.23 | 2036.53 | 286299.0 |
| 2015-08-26 15:00:00 | ES | Futures | 2036.27 | 2066.62 | 2032.27 | 2063.96 | 628687.0 |
| 2015-08-26 16:00:00 | ES | Futures | 2063.96 | 2069.28 | 2060.5 | 2062.63 | 143851.0 |
| 2015-08-26 17:00:00 | ES | Futures | 2062.63 | 2066.62 | 2062.09 | 2065.82 | 4958.0 |
| 2015-08-26 18:00:00 | ES | Futures | 2067.42 | 2068.75 | 2064.22 | 2065.82 | 5998.0 |
| 2015-08-26 19:00:00 | ES | Futures | 2065.55 | 2069.02 | 2062.89 | 2068.22 | 7224.0 |
| 2015-08-26 20:00:00 | ES | Futures | 2068.22 | 2073.81 | 2064.76 | 2068.48 | 15939.0 |
| 2015-08-26 21:00:00 | ES | Futures | 2068.22 | 2076.47 | 2067.15 | 2075.67 | 17690.0 |
| 2015-08-26 22:00:00 | ES | Futures | 2075.67 | 2075.94 | 2070.35 | 2072.48 | 9193.0 |
| 2015-08-26 23:00:00 | ES | Futures | 2072.48 | 2072.48 | 2066.35 | 2068.48 | 6399.0 |
| 2015-08-26 00:00:00 | NQ | Futures | 4774.93 | 4823.44 | 4766.35 | 4821.96 | 3565.0 |
| 2015-08-26 01:00:00 | NQ | Futures | 4822.25 | 4845.03 | 4819.3 | 4832.02 | 3986.0 |
| 2015-08-26 02:00:00 | NQ | Futures | 4834.97 | 4843.55 | 4779.37 | 4803.32 | 4396.0 |
| 2015-08-26 03:00:00 | NQ | Futures | 4804.21 | 4817.52 | 4775.22 | 4792.38 | 8939.0 |
| 2015-08-26 04:00:00 | NQ | Futures | 4791.2 | 4847.99 | 4788.83 | 4820.18 | 11042.0 |
| 2015-08-26 05:00:00 | NQ | Futures | 4820.18 | 4832.02 | 4808.06 | 4822.85 | 4773.0 |
| 2015-08-26 06:00:00 | NQ | Futures | 4821.96 | 4850.35 | 4809.54 | 4846.81 | 9173.0 |
| 2015-08-26 07:00:00 | NQ | Futures | 4846.51 | 4875.5 | 4844.44 | 4853.61 | 11652.0 |
| 2015-08-26 08:00:00 | NQ | Futures | 4853.02 | 4906.55 | 4847.99 | 4889.4 | 16923.0 |
| 2015-08-26 09:00:00 | NQ | Futures | 4889.99 | 4909.81 | 4851.54 | 4870.17 | 77189.0 |
| 2015-08-26 10:00:00 | NQ | Futures | 4870.47 | 4891.17 | 4824.92 | 4854.5 | 94891.0 |
| 2015-08-26 11:00:00 | NQ | Futures | 4854.79 | 4858.05 | 4800.37 | 4827.87 | 62932.0 |
| 2015-08-26 12:00:00 | NQ | Futures | 4827.87 | 4839.41 | 4789.42 | 4830.83 | 49201.0 |
| 2015-08-26 13:00:00 | NQ | Futures | 4831.42 | 4889.4 | 4819.59 | 4884.96 | 55447.0 |
| 2015-08-26 14:00:00 | NQ | Futures | 4884.67 | 4921.34 | 4848.88 | 4910.4 | 58990.0 |
| 2015-08-26 15:00:00 | NQ | Futures | 4910.4 | 5000.62 | 4898.57 | 4987.6 | 111483.0 |
| 2015-08-26 16:00:00 | NQ | Futures | 4987.31 | 5004.17 | 4979.02 | 4980.21 | 17875.0 |
| 2015-08-26 17:00:00 | NQ | Futures | 4980.8 | 4989.38 | 4979.91 | 4986.42 | 337.0 |
| 2015-08-26 18:00:00 | NQ | Futures | 4996.18 | 4997.36 | 4983.46 | 4992.04 | 1164.0 |
| 2015-08-26 19:00:00 | NQ | Futures | 4992.04 | 4996.18 | 4984.35 | 4994.11 | 850.0 |
| 2015-08-26 20:00:00 | NQ | Futures | 4992.93 | 5006.53 | 4984.64 | 5000.02 | 3068.0 |
| 2015-08-26 21:00:00 | NQ | Futures | 5000.32 | 5022.8 | 4997.07 | 5019.84 | 2897.0 |
| 2015-08-26 22:00:00 | NQ | Futures | 5020.14 | 5021.32 | 5007.42 | 5012.45 | 1828.0 |
| 2015-08-26 23:00:00 | NQ | Futures | 5012.45 | 5012.45 | 4996.47 | 5004.46 | 1451.0 |
| 2015-08-26 00:00:00 | YM | Futures | 16641.5 | 16765.8 | 16614.1 | 16765.8 | 2314.0 |
| 2015-08-26 01:00:00 | YM | Futures | 16765.8 | 16829.0 | 16744.7 | 16776.4 | 2518.0 |
> showing 50 of 1,586 rows — these rows as CSV