PREVIEW / futures_30min / 2015-09-29
file: by_date/futures_30min/2015/2015-09-29.parquet size: 80 KB rows: 2,921
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 | 2002.54 | 1997.73 | 2002.28 | 3864.0 |
| 2015-09-29 00:30:00 | ES | Futures | 2002.28 | 2004.42 | 2000.94 | 2000.94 | 3376.0 |
| 2015-09-29 01:00:00 | ES | Futures | 2000.67 | 2001.21 | 1997.73 | 1999.87 | 3991.0 |
| 2015-09-29 01:30:00 | ES | Futures | 2000.14 | 2002.01 | 1996.92 | 1997.46 | 3874.0 |
| 2015-09-29 02:00:00 | ES | Futures | 1996.92 | 1997.99 | 1993.98 | 1995.59 | 16808.0 |
| 2015-09-29 02:30:00 | ES | Futures | 1995.59 | 1998.8 | 1991.84 | 1997.73 | 15788.0 |
| 2015-09-29 03:00:00 | ES | Futures | 1997.73 | 2009.77 | 1995.59 | 2008.7 | 33866.0 |
| 2015-09-29 03:30:00 | ES | Futures | 2008.7 | 2010.57 | 2001.47 | 2006.56 | 24110.0 |
| 2015-09-29 04:00:00 | ES | Futures | 2006.29 | 2011.11 | 2005.49 | 2008.97 | 19564.0 |
| 2015-09-29 04:30:00 | ES | Futures | 2008.97 | 2018.6 | 2008.7 | 2014.32 | 32134.0 |
| 2015-09-29 05:00:00 | ES | Futures | 2014.58 | 2016.19 | 2009.5 | 2010.57 | 19277.0 |
| 2015-09-29 05:30:00 | ES | Futures | 2010.84 | 2013.51 | 2008.16 | 2009.77 | 13686.0 |
| 2015-09-29 06:00:00 | ES | Futures | 2010.04 | 2013.78 | 2010.04 | 2012.18 | 11216.0 |
| 2015-09-29 06:30:00 | ES | Futures | 2012.18 | 2015.12 | 2009.5 | 2014.58 | 13635.0 |
| 2015-09-29 07:00:00 | ES | Futures | 2014.58 | 2015.65 | 2011.91 | 2013.25 | 17854.0 |
| 2015-09-29 07:30:00 | ES | Futures | 2013.51 | 2013.78 | 2009.77 | 2012.71 | 22339.0 |
| 2015-09-29 08:00:00 | ES | Futures | 2012.71 | 2018.06 | 2011.91 | 2016.99 | 27734.0 |
| 2015-09-29 08:30:00 | ES | Futures | 2017.26 | 2017.53 | 2014.85 | 2015.65 | 23562.0 |
| 2015-09-29 09:00:00 | ES | Futures | 2015.92 | 2016.19 | 2006.56 | 2006.82 | 39148.0 |
| 2015-09-29 09:30:00 | ES | Futures | 2006.56 | 2011.91 | 1996.92 | 2010.84 | 280202.0 |
| 2015-09-29 10:00:00 | ES | Futures | 2010.57 | 2021.54 | 2007.09 | 2021.54 | 243876.0 |
| 2015-09-29 10:30:00 | ES | Futures | 2021.27 | 2022.61 | 2008.97 | 2014.32 | 165465.0 |
| 2015-09-29 11:00:00 | ES | Futures | 2014.32 | 2017.8 | 2006.02 | 2010.84 | 145160.0 |
| 2015-09-29 11:30:00 | ES | Futures | 2010.84 | 2014.05 | 2004.95 | 2008.16 | 113811.0 |
| 2015-09-29 12:00:00 | ES | Futures | 2008.43 | 2009.77 | 2001.74 | 2007.63 | 124722.0 |
| 2015-09-29 12:30:00 | ES | Futures | 2007.9 | 2008.97 | 1999.87 | 2000.67 | 89451.0 |
| 2015-09-29 13:00:00 | ES | Futures | 2000.67 | 2010.57 | 1999.87 | 2008.7 | 83988.0 |
| 2015-09-29 13:30:00 | ES | Futures | 2008.97 | 2013.78 | 2007.9 | 2011.37 | 69237.0 |
| 2015-09-29 14:00:00 | ES | Futures | 2011.11 | 2011.64 | 2003.88 | 2009.77 | 76559.0 |
| 2015-09-29 14:30:00 | ES | Futures | 2009.77 | 2011.37 | 1999.6 | 1999.6 | 94843.0 |
| 2015-09-29 15:00:00 | ES | Futures | 1999.87 | 2001.21 | 1992.38 | 1993.18 | 147546.0 |
| 2015-09-29 15:30:00 | ES | Futures | 1993.18 | 2008.97 | 1992.91 | 2004.42 | 245449.0 |
| 2015-09-29 16:00:00 | ES | Futures | 2004.42 | 2009.77 | 2003.88 | 2006.56 | 65363.0 |
| 2015-09-29 16:30:00 | ES | Futures | 2006.56 | 2006.82 | 2003.08 | 2006.29 | 9260.0 |
| 2015-09-29 18:00:00 | ES | Futures | 2006.82 | 2010.04 | 2005.75 | 2008.43 | 3869.0 |
| 2015-09-29 18:30:00 | ES | Futures | 2008.16 | 2008.97 | 2007.36 | 2007.63 | 1045.0 |
| 2015-09-29 19:00:00 | ES | Futures | 2007.9 | 2009.5 | 2007.36 | 2008.16 | 2115.0 |
| 2015-09-29 19:30:00 | ES | Futures | 2008.16 | 2008.16 | 2006.29 | 2007.63 | 1816.0 |
| 2015-09-29 20:00:00 | ES | Futures | 2007.63 | 2008.97 | 2002.81 | 2008.97 | 7689.0 |
| 2015-09-29 20:30:00 | ES | Futures | 2008.7 | 2011.91 | 2007.63 | 2011.11 | 4450.0 |
| 2015-09-29 21:00:00 | ES | Futures | 2010.84 | 2016.19 | 2010.84 | 2015.65 | 11765.0 |
| 2015-09-29 21:30:00 | ES | Futures | 2015.65 | 2016.99 | 2014.32 | 2015.39 | 6327.0 |
| 2015-09-29 22:00:00 | ES | Futures | 2015.39 | 2015.92 | 2013.51 | 2015.92 | 2930.0 |
| 2015-09-29 22:30:00 | ES | Futures | 2015.65 | 2018.6 | 2015.39 | 2016.99 | 4538.0 |
| 2015-09-29 23:00:00 | ES | Futures | 2016.99 | 2020.2 | 2016.19 | 2019.67 | 3929.0 |
| 2015-09-29 23:30:00 | ES | Futures | 2019.4 | 2020.47 | 2018.33 | 2019.94 | 3128.0 |
| 2015-09-29 00:00:00 | NQ | Futures | 4844.66 | 4850.3 | 4839.92 | 4849.41 | 843.0 |
| 2015-09-29 00:30:00 | NQ | Futures | 4850.0 | 4855.34 | 4847.04 | 4847.33 | 821.0 |
| 2015-09-29 01:00:00 | NQ | Futures | 4847.33 | 4848.81 | 4840.51 | 4844.96 | 1155.0 |
| 2015-09-29 01:30:00 | NQ | Futures | 4845.26 | 4851.78 | 4835.47 | 4836.66 | 1306.0 |
> showing 50 of 2,921 rows — these rows as CSV