PREVIEW / futures_30min / 2014-08-12
file: by_date/futures_30min/2014/2014-08-12.parquet size: 72 KB rows: 2,869
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-12 00:00:00 | ES | Futures | 2016.63 | 2016.89 | 2016.11 | 2016.37 | 655.0 |
| 2014-08-12 00:30:00 | ES | Futures | 2016.37 | 2016.63 | 2016.11 | 2016.37 | 458.0 |
| 2014-08-12 01:00:00 | ES | Futures | 2016.63 | 2017.15 | 2016.37 | 2016.89 | 1073.0 |
| 2014-08-12 01:30:00 | ES | Futures | 2017.15 | 2017.67 | 2016.63 | 2017.67 | 987.0 |
| 2014-08-12 02:00:00 | ES | Futures | 2017.41 | 2017.93 | 2016.89 | 2017.93 | 1581.0 |
| 2014-08-12 02:30:00 | ES | Futures | 2017.93 | 2018.19 | 2017.15 | 2017.15 | 2304.0 |
| 2014-08-12 03:00:00 | ES | Futures | 2017.41 | 2018.19 | 2015.85 | 2017.41 | 18701.0 |
| 2014-08-12 03:30:00 | ES | Futures | 2017.41 | 2018.98 | 2016.89 | 2018.72 | 9255.0 |
| 2014-08-12 04:00:00 | ES | Futures | 2018.72 | 2019.24 | 2017.41 | 2017.67 | 7665.0 |
| 2014-08-12 04:30:00 | ES | Futures | 2017.93 | 2019.76 | 2017.67 | 2019.5 | 6510.0 |
| 2014-08-12 05:00:00 | ES | Futures | 2019.5 | 2019.5 | 2017.67 | 2019.24 | 7337.0 |
| 2014-08-12 05:30:00 | ES | Futures | 2019.24 | 2020.28 | 2018.19 | 2020.02 | 5270.0 |
| 2014-08-12 06:00:00 | ES | Futures | 2020.28 | 2021.06 | 2019.24 | 2019.5 | 6447.0 |
| 2014-08-12 06:30:00 | ES | Futures | 2019.5 | 2020.02 | 2017.93 | 2018.72 | 7635.0 |
| 2014-08-12 07:00:00 | ES | Futures | 2018.98 | 2019.5 | 2017.67 | 2018.19 | 5652.0 |
| 2014-08-12 07:30:00 | ES | Futures | 2017.93 | 2018.19 | 2014.81 | 2015.85 | 20041.0 |
| 2014-08-12 08:00:00 | ES | Futures | 2015.85 | 2017.15 | 2015.07 | 2015.07 | 15093.0 |
| 2014-08-12 08:30:00 | ES | Futures | 2015.33 | 2017.15 | 2014.81 | 2015.59 | 10465.0 |
| 2014-08-12 09:00:00 | ES | Futures | 2015.59 | 2015.59 | 2010.12 | 2012.46 | 56622.0 |
| 2014-08-12 09:30:00 | ES | Futures | 2012.46 | 2017.67 | 2010.12 | 2016.37 | 139684.0 |
| 2014-08-12 10:00:00 | ES | Futures | 2016.11 | 2018.19 | 2011.68 | 2016.11 | 125939.0 |
| 2014-08-12 10:30:00 | ES | Futures | 2016.11 | 2016.11 | 2010.38 | 2011.42 | 90813.0 |
| 2014-08-12 11:00:00 | ES | Futures | 2011.42 | 2011.42 | 2006.47 | 2009.59 | 129428.0 |
| 2014-08-12 11:30:00 | ES | Futures | 2009.33 | 2010.9 | 2008.81 | 2009.33 | 47085.0 |
| 2014-08-12 12:00:00 | ES | Futures | 2009.33 | 2010.64 | 2007.25 | 2009.33 | 46339.0 |
| 2014-08-12 12:30:00 | ES | Futures | 2009.59 | 2013.76 | 2009.33 | 2011.68 | 50261.0 |
| 2014-08-12 13:00:00 | ES | Futures | 2011.94 | 2013.5 | 2010.9 | 2012.2 | 30703.0 |
| 2014-08-12 13:30:00 | ES | Futures | 2011.94 | 2012.2 | 2008.81 | 2010.64 | 37061.0 |
| 2014-08-12 14:00:00 | ES | Futures | 2010.9 | 2010.9 | 2005.95 | 2007.25 | 69082.0 |
| 2014-08-12 14:30:00 | ES | Futures | 2007.25 | 2009.86 | 2005.16 | 2007.77 | 55287.0 |
| 2014-08-12 15:00:00 | ES | Futures | 2008.03 | 2010.9 | 2007.77 | 2009.33 | 40862.0 |
| 2014-08-12 15:30:00 | ES | Futures | 2009.33 | 2013.5 | 2008.81 | 2011.68 | 110994.0 |
| 2014-08-12 16:00:00 | ES | Futures | 2011.42 | 2012.46 | 2011.42 | 2012.46 | 42802.0 |
| 2014-08-12 16:30:00 | ES | Futures | 2012.46 | 2014.81 | 2012.2 | 2014.55 | 10843.0 |
| 2014-08-12 17:00:00 | ES | Futures | 2014.55 | 2014.81 | 2014.29 | 2014.55 | 1713.0 |
| 2014-08-12 18:00:00 | ES | Futures | 2014.29 | 2014.81 | 2014.29 | 2014.55 | 2423.0 |
| 2014-08-12 18:30:00 | ES | Futures | 2014.81 | 2015.07 | 2014.29 | 2014.29 | 620.0 |
| 2014-08-12 19:00:00 | ES | Futures | 2014.55 | 2014.55 | 2014.02 | 2014.02 | 361.0 |
| 2014-08-12 19:30:00 | ES | Futures | 2014.02 | 2014.29 | 2013.76 | 2014.02 | 727.0 |
| 2014-08-12 20:00:00 | ES | Futures | 2013.76 | 2014.81 | 2013.24 | 2014.55 | 3253.0 |
| 2014-08-12 20:30:00 | ES | Futures | 2014.55 | 2015.07 | 2013.5 | 2013.76 | 1759.0 |
| 2014-08-12 21:00:00 | ES | Futures | 2014.02 | 2014.81 | 2013.76 | 2013.76 | 1827.0 |
| 2014-08-12 21:30:00 | ES | Futures | 2013.76 | 2014.02 | 2012.72 | 2014.02 | 2619.0 |
| 2014-08-12 22:00:00 | ES | Futures | 2013.76 | 2014.81 | 2013.5 | 2014.29 | 1823.0 |
| 2014-08-12 22:30:00 | ES | Futures | 2014.29 | 2015.33 | 2012.98 | 2012.98 | 2301.0 |
| 2014-08-12 23:00:00 | ES | Futures | 2013.24 | 2013.5 | 2012.72 | 2013.24 | 593.0 |
| 2014-08-12 23:30:00 | ES | Futures | 2013.5 | 2014.29 | 2013.24 | 2014.02 | 912.0 |
| 2014-08-12 00:00:00 | NQ | Futures | 4566.53 | 4566.82 | 4565.07 | 4565.94 | 104.0 |
| 2014-08-12 00:30:00 | NQ | Futures | 4565.94 | 4566.53 | 4565.36 | 4565.94 | 105.0 |
| 2014-08-12 01:00:00 | NQ | Futures | 4566.53 | 4567.69 | 4566.53 | 4567.4 | 125.0 |
> showing 50 of 2,869 rows — these rows as CSV