PREVIEW / futures_1hour / 2015-09-29
file: by_date/futures_1hour/2015/2015-09-29.parquet size: 52 KB rows: 1,569
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-09-29 00:00:00 | ES | Futures | 2000.4 | 2004.42 | 1997.73 | 2000.94 | 7240.0 |
| 2015-09-29 01:00:00 | ES | Futures | 2000.67 | 2002.01 | 1996.92 | 1997.46 | 7865.0 |
| 2015-09-29 02:00:00 | ES | Futures | 1996.92 | 1998.8 | 1991.84 | 1997.73 | 32596.0 |
| 2015-09-29 03:00:00 | ES | Futures | 1997.73 | 2010.57 | 1995.59 | 2006.56 | 57976.0 |
| 2015-09-29 04:00:00 | ES | Futures | 2006.29 | 2018.6 | 2005.49 | 2014.32 | 51698.0 |
| 2015-09-29 05:00:00 | ES | Futures | 2014.58 | 2016.19 | 2008.16 | 2009.77 | 32963.0 |
| 2015-09-29 06:00:00 | ES | Futures | 2010.04 | 2015.12 | 2009.5 | 2014.58 | 24851.0 |
| 2015-09-29 07:00:00 | ES | Futures | 2014.58 | 2015.65 | 2009.77 | 2012.71 | 40193.0 |
| 2015-09-29 08:00:00 | ES | Futures | 2012.71 | 2018.06 | 2011.91 | 2015.65 | 51296.0 |
| 2015-09-29 09:00:00 | ES | Futures | 2015.92 | 2016.19 | 1996.92 | 2010.84 | 319350.0 |
| 2015-09-29 10:00:00 | ES | Futures | 2010.57 | 2022.61 | 2007.09 | 2014.32 | 409341.0 |
| 2015-09-29 11:00:00 | ES | Futures | 2014.32 | 2017.8 | 2004.95 | 2008.16 | 258971.0 |
| 2015-09-29 12:00:00 | ES | Futures | 2008.43 | 2009.77 | 1999.87 | 2000.67 | 214173.0 |
| 2015-09-29 13:00:00 | ES | Futures | 2000.67 | 2013.78 | 1999.87 | 2011.37 | 153225.0 |
| 2015-09-29 14:00:00 | ES | Futures | 2011.11 | 2011.64 | 1999.6 | 1999.6 | 171402.0 |
| 2015-09-29 15:00:00 | ES | Futures | 1999.87 | 2008.97 | 1992.38 | 2004.42 | 392995.0 |
| 2015-09-29 16:00:00 | ES | Futures | 2004.42 | 2009.77 | 2003.08 | 2006.29 | 74623.0 |
| 2015-09-29 18:00:00 | ES | Futures | 2006.82 | 2010.04 | 2005.75 | 2007.63 | 4914.0 |
| 2015-09-29 19:00:00 | ES | Futures | 2007.9 | 2009.5 | 2006.29 | 2007.63 | 3931.0 |
| 2015-09-29 20:00:00 | ES | Futures | 2007.63 | 2011.91 | 2002.81 | 2011.11 | 12139.0 |
| 2015-09-29 21:00:00 | ES | Futures | 2010.84 | 2016.99 | 2010.84 | 2015.39 | 18092.0 |
| 2015-09-29 22:00:00 | ES | Futures | 2015.39 | 2018.6 | 2013.51 | 2016.99 | 7468.0 |
| 2015-09-29 23:00:00 | ES | Futures | 2016.99 | 2020.47 | 2016.19 | 2019.94 | 7057.0 |
| 2015-09-29 00:00:00 | NQ | Futures | 4844.66 | 4855.34 | 4839.92 | 4847.33 | 1664.0 |
| 2015-09-29 01:00:00 | NQ | Futures | 4847.33 | 4851.78 | 4835.47 | 4836.66 | 2461.0 |
| 2015-09-29 02:00:00 | NQ | Futures | 4835.77 | 4844.37 | 4824.5 | 4841.4 | 4174.0 |
| 2015-09-29 03:00:00 | NQ | Futures | 4840.81 | 4870.46 | 4832.8 | 4863.34 | 10891.0 |
| 2015-09-29 04:00:00 | NQ | Futures | 4863.05 | 4896.55 | 4861.86 | 4887.65 | 10040.0 |
| 2015-09-29 05:00:00 | NQ | Futures | 4887.65 | 4891.51 | 4872.24 | 4876.39 | 6179.0 |
| 2015-09-29 06:00:00 | NQ | Futures | 4876.09 | 4884.99 | 4872.24 | 4882.91 | 4269.0 |
| 2015-09-29 07:00:00 | NQ | Futures | 4882.61 | 4885.28 | 4873.72 | 4877.28 | 4877.0 |
| 2015-09-29 08:00:00 | NQ | Futures | 4878.17 | 4891.81 | 4875.5 | 4885.28 | 7736.0 |
| 2015-09-29 09:00:00 | NQ | Futures | 4885.28 | 4885.58 | 4830.14 | 4876.68 | 53390.0 |
| 2015-09-29 10:00:00 | NQ | Futures | 4877.28 | 4914.93 | 4866.9 | 4889.73 | 70845.0 |
| 2015-09-29 11:00:00 | NQ | Futures | 4889.73 | 4899.81 | 4864.53 | 4871.64 | 43441.0 |
| 2015-09-29 12:00:00 | NQ | Futures | 4871.94 | 4876.39 | 4836.95 | 4839.03 | 41508.0 |
| 2015-09-29 13:00:00 | NQ | Futures | 4839.33 | 4876.09 | 4837.55 | 4867.49 | 29840.0 |
| 2015-09-29 14:00:00 | NQ | Futures | 4868.38 | 4869.57 | 4823.91 | 4824.5 | 34028.0 |
| 2015-09-29 15:00:00 | NQ | Futures | 4824.8 | 4839.33 | 4792.18 | 4827.76 | 77357.0 |
| 2015-09-29 16:00:00 | NQ | Futures | 4827.76 | 4841.7 | 4824.5 | 4830.14 | 10619.0 |
| 2015-09-29 18:00:00 | NQ | Futures | 4837.25 | 4841.4 | 4830.73 | 4834.29 | 1517.0 |
| 2015-09-29 19:00:00 | NQ | Futures | 4833.99 | 4839.03 | 4830.73 | 4834.29 | 606.0 |
| 2015-09-29 20:00:00 | NQ | Futures | 4834.58 | 4845.55 | 4822.13 | 4844.96 | 2672.0 |
| 2015-09-29 21:00:00 | NQ | Futures | 4844.96 | 4859.49 | 4843.18 | 4855.63 | 2520.0 |
| 2015-09-29 22:00:00 | NQ | Futures | 4854.74 | 4862.45 | 4850.59 | 4858.3 | 2214.0 |
| 2015-09-29 23:00:00 | NQ | Futures | 4857.71 | 4868.98 | 4856.52 | 4866.9 | 1538.0 |
| 2015-09-29 00:00:00 | YM | Futures | 16806.1 | 16842.1 | 16784.9 | 16810.4 | 2241.0 |
| 2015-09-29 01:00:00 | YM | Futures | 16811.4 | 16826.2 | 16783.9 | 16784.9 | 1633.0 |
| 2015-09-29 02:00:00 | YM | Futures | 16783.9 | 16790.2 | 16735.1 | 16777.5 | 5462.0 |
| 2015-09-29 03:00:00 | YM | Futures | 16776.5 | 16877.1 | 16758.4 | 16850.6 | 10517.0 |
> showing 50 of 1,569 rows — these rows as CSV