PREVIEW / futures_1hour / 2014-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-12.parquet
  size:    48 KB
  rows:    1,533

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	1113.0
2014-08-12 01:00:00	ES	Futures	2016.63	2017.67	2016.37	2017.67	2060.0
2014-08-12 02:00:00	ES	Futures	2017.41	2018.19	2016.89	2017.15	3885.0
2014-08-12 03:00:00	ES	Futures	2017.41	2018.98	2015.85	2018.72	27956.0
2014-08-12 04:00:00	ES	Futures	2018.72	2019.76	2017.41	2019.5	14175.0
2014-08-12 05:00:00	ES	Futures	2019.5	2020.28	2017.67	2020.02	12607.0
2014-08-12 06:00:00	ES	Futures	2020.28	2021.06	2017.93	2018.72	14082.0
2014-08-12 07:00:00	ES	Futures	2018.98	2019.5	2014.81	2015.85	25693.0
2014-08-12 08:00:00	ES	Futures	2015.85	2017.15	2014.81	2015.59	25558.0
2014-08-12 09:00:00	ES	Futures	2015.59	2017.67	2010.12	2016.37	196306.0
2014-08-12 10:00:00	ES	Futures	2016.11	2018.19	2010.38	2011.42	216752.0
2014-08-12 11:00:00	ES	Futures	2011.42	2011.42	2006.47	2009.33	176513.0
2014-08-12 12:00:00	ES	Futures	2009.33	2013.76	2007.25	2011.68	96600.0
2014-08-12 13:00:00	ES	Futures	2011.94	2013.5	2008.81	2010.64	67764.0
2014-08-12 14:00:00	ES	Futures	2010.9	2010.9	2005.16	2007.77	124369.0
2014-08-12 15:00:00	ES	Futures	2008.03	2013.5	2007.77	2011.68	151856.0
2014-08-12 16:00:00	ES	Futures	2011.42	2014.81	2011.42	2014.55	53645.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	2015.07	2014.29	2014.29	3043.0
2014-08-12 19:00:00	ES	Futures	2014.55	2014.55	2013.76	2014.02	1088.0
2014-08-12 20:00:00	ES	Futures	2013.76	2015.07	2013.24	2013.76	5012.0
2014-08-12 21:00:00	ES	Futures	2014.02	2014.81	2012.72	2014.02	4446.0
2014-08-12 22:00:00	ES	Futures	2013.76	2015.33	2012.98	2012.98	4124.0
2014-08-12 23:00:00	ES	Futures	2013.24	2014.29	2012.72	2014.02	1505.0
2014-08-12 00:00:00	NQ	Futures	4566.53	4566.82	4565.07	4565.94	209.0
2014-08-12 01:00:00	NQ	Futures	4566.53	4568.28	4566.53	4568.28	234.0
2014-08-12 02:00:00	NQ	Futures	4567.69	4569.45	4566.53	4567.69	510.0
2014-08-12 03:00:00	NQ	Futures	4567.69	4571.49	4563.9	4571.2	4037.0
2014-08-12 04:00:00	NQ	Futures	4570.91	4573.83	4567.69	4573.24	2503.0
2014-08-12 05:00:00	NQ	Futures	4572.95	4574.7	4569.74	4574.12	1550.0
2014-08-12 06:00:00	NQ	Futures	4574.41	4575.58	4570.03	4572.07	1910.0
2014-08-12 07:00:00	NQ	Futures	4572.07	4572.95	4559.23	4562.73	4703.0
2014-08-12 08:00:00	NQ	Futures	4562.73	4567.11	4560.98	4563.61	4455.0
2014-08-12 09:00:00	NQ	Futures	4563.61	4570.61	4552.51	4568.57	32249.0
2014-08-12 10:00:00	NQ	Futures	4568.28	4571.78	4551.34	4553.97	39244.0
2014-08-12 11:00:00	NQ	Futures	4554.26	4554.26	4539.08	4549.3	34855.0
2014-08-12 12:00:00	NQ	Futures	4549.0	4559.23	4543.46	4553.97	16853.0
2014-08-12 13:00:00	NQ	Futures	4554.26	4556.89	4547.25	4551.05	14909.0
2014-08-12 14:00:00	NQ	Futures	4550.76	4551.34	4535.86	4542.29	23161.0
2014-08-12 15:00:00	NQ	Futures	4542.58	4562.15	4542.29	4559.52	30139.0
2014-08-12 16:00:00	NQ	Futures	4559.52	4564.77	4558.93	4563.9	5656.0
2014-08-12 17:00:00	NQ	Futures	4563.9	4564.77	4562.73	4563.61	202.0
2014-08-12 18:00:00	NQ	Futures	4562.44	4564.19	4562.44	4563.31	415.0
2014-08-12 19:00:00	NQ	Futures	4563.02	4563.31	4560.98	4561.27	315.0
2014-08-12 20:00:00	NQ	Futures	4561.56	4563.9	4560.1	4561.27	400.0
2014-08-12 21:00:00	NQ	Futures	4560.98	4563.9	4560.39	4562.44	670.0
2014-08-12 22:00:00	NQ	Futures	4562.15	4564.77	4559.81	4560.1	584.0
2014-08-12 23:00:00	NQ	Futures	4560.1	4562.44	4558.06	4562.15	538.0
2014-08-12 00:00:00	YM	Futures	17106.6	17107.6	17101.4	17103.5	277.0
2014-08-12 01:00:00	YM	Futures	17104.5	17109.7	17104.5	17109.7	266.0

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

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