PREVIEW / futures_1hour / 2014-08-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-11.parquet
  size:    47 KB
  rows:    1,503

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-11 00:00:00	ES	Futures	2008.29	2009.86	2008.29	2009.33	2444.0
2014-08-11 01:00:00	ES	Futures	2009.33	2010.12	2009.07	2009.86	4399.0
2014-08-11 02:00:00	ES	Futures	2009.59	2010.38	2008.55	2010.38	10667.0
2014-08-11 03:00:00	ES	Futures	2010.12	2012.72	2008.03	2012.46	34284.0
2014-08-11 04:00:00	ES	Futures	2012.46	2012.72	2010.9	2012.2	17311.0
2014-08-11 05:00:00	ES	Futures	2012.46	2012.98	2011.94	2012.46	11626.0
2014-08-11 06:00:00	ES	Futures	2012.46	2014.29	2011.94	2013.5	18991.0
2014-08-11 07:00:00	ES	Futures	2013.76	2015.33	2013.5	2014.81	22166.0
2014-08-11 08:00:00	ES	Futures	2015.07	2017.67	2014.29	2015.07	53992.0
2014-08-11 09:00:00	ES	Futures	2015.07	2018.98	2014.02	2018.19	178776.0
2014-08-11 10:00:00	ES	Futures	2018.19	2020.8	2016.89	2018.46	189693.0
2014-08-11 11:00:00	ES	Futures	2018.46	2023.41	2017.67	2020.8	151099.0
2014-08-11 12:00:00	ES	Futures	2020.8	2021.32	2018.72	2019.24	79765.0
2014-08-11 13:00:00	ES	Futures	2019.24	2020.54	2014.55	2015.59	83235.0
2014-08-11 14:00:00	ES	Futures	2015.33	2016.89	2013.24	2015.33	83885.0
2014-08-11 15:00:00	ES	Futures	2015.33	2017.93	2013.5	2014.29	140561.0
2014-08-11 16:00:00	ES	Futures	2014.02	2015.59	2013.76	2015.33	51809.0
2014-08-11 17:00:00	ES	Futures	2015.59	2015.85	2015.07	2015.59	2225.0
2014-08-11 18:00:00	ES	Futures	2016.11	2016.37	2015.59	2015.85	2972.0
2014-08-11 19:00:00	ES	Futures	2016.37	2016.37	2015.59	2016.11	1393.0
2014-08-11 20:00:00	ES	Futures	2016.11	2018.72	2015.85	2017.93	5534.0
2014-08-11 21:00:00	ES	Futures	2017.67	2018.19	2016.11	2016.89	6197.0
2014-08-11 22:00:00	ES	Futures	2016.89	2017.67	2016.63	2016.89	2187.0
2014-08-11 23:00:00	ES	Futures	2016.89	2017.67	2016.37	2016.63	1747.0
2014-08-11 00:00:00	NQ	Futures	4533.82	4537.32	4533.82	4537.03	308.0
2014-08-11 01:00:00	NQ	Futures	4537.03	4537.62	4535.57	4536.74	348.0
2014-08-11 02:00:00	NQ	Futures	4536.74	4538.49	4534.7	4537.32	1158.0
2014-08-11 03:00:00	NQ	Futures	4537.91	4545.5	4533.53	4544.92	5199.0
2014-08-11 04:00:00	NQ	Futures	4544.92	4545.21	4541.7	4544.33	2417.0
2014-08-11 05:00:00	NQ	Futures	4544.62	4546.38	4543.75	4546.08	1660.0
2014-08-11 06:00:00	NQ	Futures	4546.38	4550.76	4544.33	4548.71	2568.0
2014-08-11 07:00:00	NQ	Futures	4549.0	4552.51	4548.13	4551.34	3186.0
2014-08-11 08:00:00	NQ	Futures	4551.05	4553.68	4547.54	4549.3	5129.0
2014-08-11 09:00:00	NQ	Futures	4549.0	4566.23	4548.42	4564.77	31409.0
2014-08-11 10:00:00	NQ	Futures	4564.48	4572.07	4560.69	4567.11	28012.0
2014-08-11 11:00:00	NQ	Futures	4566.82	4576.16	4564.77	4570.91	22222.0
2014-08-11 12:00:00	NQ	Futures	4570.61	4572.37	4566.23	4566.53	12541.0
2014-08-11 13:00:00	NQ	Futures	4566.82	4571.2	4559.23	4562.15	13269.0
2014-08-11 14:00:00	NQ	Futures	4562.15	4565.07	4556.89	4563.31	16762.0
2014-08-11 15:00:00	NQ	Futures	4563.31	4568.86	4560.1	4562.44	22106.0
2014-08-11 16:00:00	NQ	Futures	4562.44	4563.61	4559.52	4563.61	5743.0
2014-08-11 17:00:00	NQ	Futures	4563.9	4565.36	4563.31	4565.36	110.0
2014-08-11 18:00:00	NQ	Futures	4564.19	4565.07	4562.73	4563.9	585.0
2014-08-11 19:00:00	NQ	Futures	4564.48	4565.07	4563.02	4563.9	199.0
2014-08-11 20:00:00	NQ	Futures	4563.9	4570.32	4563.31	4569.15	864.0
2014-08-11 21:00:00	NQ	Futures	4569.45	4569.74	4564.48	4567.11	552.0
2014-08-11 22:00:00	NQ	Futures	4567.11	4569.15	4565.94	4566.82	511.0
2014-08-11 23:00:00	NQ	Futures	4566.82	4569.15	4565.65	4566.53	370.0
2014-08-11 00:00:00	YM	Futures	17075.6	17085.9	17075.6	17081.8	567.0
2014-08-11 01:00:00	YM	Futures	17081.8	17084.9	17077.6	17080.7	797.0

> showing 50 of 1,503 rows — these rows as CSV

> unlock the full archive -- $79 one-time