PREVIEW / futures_1hour / 2014-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-05.parquet
  size:    49 KB
  rows:    1,547

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-06-05 00:00:00	ES	Futures	1999.47	1999.73	1999.21	1999.21	979.0
2014-06-05 01:00:00	ES	Futures	1999.47	1999.99	1999.21	1999.47	1573.0
2014-06-05 02:00:00	ES	Futures	1999.47	2000.25	1999.21	1999.47	2794.0
2014-06-05 03:00:00	ES	Futures	1999.47	2001.03	1998.69	2000.77	16546.0
2014-06-05 04:00:00	ES	Futures	2000.51	2000.77	1999.47	1999.73	6666.0
2014-06-05 05:00:00	ES	Futures	1999.99	1999.99	1999.21	1999.73	5243.0
2014-06-05 06:00:00	ES	Futures	1999.73	1999.99	1999.21	1999.47	5668.0
2014-06-05 07:00:00	ES	Futures	1999.47	2004.14	1998.43	2002.06	65856.0
2014-06-05 08:00:00	ES	Futures	2001.81	2009.08	2001.29	2003.88	136491.0
2014-06-05 09:00:00	ES	Futures	2004.14	2005.44	1998.43	2001.55	287886.0
2014-06-05 10:00:00	ES	Futures	2001.55	2003.62	1995.31	2002.58	281702.0
2014-06-05 11:00:00	ES	Futures	2002.58	2011.15	2002.06	2010.89	248082.0
2014-06-05 12:00:00	ES	Futures	2010.89	2015.05	2010.89	2012.97	168924.0
2014-06-05 13:00:00	ES	Futures	2013.23	2014.27	2011.67	2013.49	80575.0
2014-06-05 14:00:00	ES	Futures	2013.49	2015.83	2012.45	2012.97	115001.0
2014-06-05 15:00:00	ES	Futures	2012.97	2014.27	2011.67	2013.49	154507.0
2014-06-05 16:00:00	ES	Futures	2013.49	2014.01	2012.71	2013.23	66295.0
2014-06-05 17:00:00	ES	Futures	2013.49	2014.01	2013.23	2013.75	1603.0
2014-06-05 18:00:00	ES	Futures	2013.49	2013.75	2012.71	2013.75	2263.0
2014-06-05 19:00:00	ES	Futures	2013.49	2014.27	2013.23	2014.27	1838.0
2014-06-05 20:00:00	ES	Futures	2014.01	2014.27	2013.23	2013.23	3235.0
2014-06-05 21:00:00	ES	Futures	2013.49	2014.79	2013.49	2014.27	4107.0
2014-06-05 22:00:00	ES	Futures	2014.53	2016.61	2014.01	2016.35	5098.0
2014-06-05 23:00:00	ES	Futures	2016.35	2016.87	2016.09	2016.61	4494.0
2014-06-05 00:00:00	NQ	Futures	4358.14	4358.72	4357.56	4358.43	204.0
2014-06-05 01:00:00	NQ	Futures	4358.43	4359.89	4358.14	4359.31	278.0
2014-06-05 02:00:00	NQ	Futures	4358.72	4360.47	4358.43	4359.02	438.0
2014-06-05 03:00:00	NQ	Futures	4359.31	4362.22	4356.69	4362.22	2296.0
2014-06-05 04:00:00	NQ	Futures	4362.22	4362.22	4357.85	4358.14	2027.0
2014-06-05 05:00:00	NQ	Futures	4358.43	4358.72	4356.98	4357.56	959.0
2014-06-05 06:00:00	NQ	Futures	4357.56	4357.85	4356.69	4356.69	1165.0
2014-06-05 07:00:00	NQ	Futures	4357.27	4369.79	4356.98	4364.84	8308.0
2014-06-05 08:00:00	NQ	Futures	4364.84	4377.07	4362.8	4366.59	18413.0
2014-06-05 09:00:00	NQ	Futures	4366.59	4374.16	4356.98	4365.71	57197.0
2014-06-05 10:00:00	NQ	Futures	4365.71	4371.54	4349.7	4369.21	46964.0
2014-06-05 11:00:00	NQ	Futures	4369.21	4393.67	4368.33	4387.26	40449.0
2014-06-05 12:00:00	NQ	Futures	4387.55	4401.82	4387.55	4396.58	34836.0
2014-06-05 13:00:00	NQ	Futures	4396.58	4400.95	4391.05	4396.29	13852.0
2014-06-05 14:00:00	NQ	Futures	4396.29	4405.61	4394.84	4397.46	21453.0
2014-06-05 15:00:00	NQ	Futures	4397.46	4401.24	4393.67	4397.75	23417.0
2014-06-05 16:00:00	NQ	Futures	4397.46	4400.37	4396.29	4399.2	5535.0
2014-06-05 17:00:00	NQ	Futures	4399.2	4400.95	4398.62	4400.37	330.0
2014-06-05 18:00:00	NQ	Futures	4400.37	4400.66	4398.33	4399.2	253.0
2014-06-05 19:00:00	NQ	Futures	4399.79	4402.7	4399.2	4402.12	316.0
2014-06-05 20:00:00	NQ	Futures	4401.82	4402.7	4399.2	4399.79	590.0
2014-06-05 21:00:00	NQ	Futures	4399.79	4403.57	4399.49	4402.12	641.0
2014-06-05 22:00:00	NQ	Futures	4402.12	4408.23	4401.53	4407.65	1125.0
2014-06-05 23:00:00	NQ	Futures	4407.65	4407.94	4406.19	4407.65	596.0
2014-06-05 00:00:00	YM	Futures	17216.2	17217.2	17214.1	17216.2	298.0
2014-06-05 01:00:00	YM	Futures	17215.1	17220.3	17214.1	17217.2	361.0

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

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