PREVIEW / futures_1hour / 2014-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-16.parquet
  size:    47 KB
  rows:    1,484

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-16 00:00:00	ES	Futures	2003.08	2003.34	2002.56	2002.82	1306.0
2014-06-16 01:00:00	ES	Futures	2002.82	2005.42	2002.04	2005.42	4493.0
2014-06-16 02:00:00	ES	Futures	2005.16	2005.95	2003.6	2004.12	5581.0
2014-06-16 03:00:00	ES	Futures	2003.86	2006.99	2003.86	2005.95	14442.0
2014-06-16 04:00:00	ES	Futures	2005.95	2006.47	2004.9	2005.95	8206.0
2014-06-16 05:00:00	ES	Futures	2005.95	2006.21	2002.82	2003.6	14274.0
2014-06-16 06:00:00	ES	Futures	2003.34	2005.69	2003.34	2005.42	8453.0
2014-06-16 07:00:00	ES	Futures	2005.42	2005.95	2004.12	2005.42	10502.0
2014-06-16 08:00:00	ES	Futures	2005.69	2007.25	2004.38	2006.47	15574.0
2014-06-16 09:00:00	ES	Futures	2006.47	2012.72	2005.42	2011.16	174378.0
2014-06-16 10:00:00	ES	Futures	2011.16	2015.59	2010.64	2012.98	182910.0
2014-06-16 11:00:00	ES	Futures	2013.24	2013.5	2004.38	2006.73	177473.0
2014-06-16 12:00:00	ES	Futures	2006.47	2010.64	2006.21	2010.12	96183.0
2014-06-16 13:00:00	ES	Futures	2010.38	2014.02	2009.59	2011.16	86649.0
2014-06-16 14:00:00	ES	Futures	2010.9	2012.46	2009.86	2010.12	59931.0
2014-06-16 15:00:00	ES	Futures	2009.86	2012.2	2007.77	2011.16	155890.0
2014-06-16 16:00:00	ES	Futures	2011.42	2011.68	2010.64	2011.16	54867.0
2014-06-16 17:00:00	ES	Futures	2011.42	2011.42	2010.64	2011.16	1357.0
2014-06-16 18:00:00	ES	Futures	2010.9	2012.2	2010.9	2011.68	1529.0
2014-06-16 19:00:00	ES	Futures	2011.68	2012.2	2011.42	2011.68	573.0
2014-06-16 20:00:00	ES	Futures	2011.68	2012.98	2011.42	2012.72	2491.0
2014-06-16 21:00:00	ES	Futures	2012.72	2014.55	2012.46	2014.02	3907.0
2014-06-16 22:00:00	ES	Futures	2014.29	2014.55	2013.24	2014.02	2228.0
2014-06-16 23:00:00	ES	Futures	2014.02	2014.29	2012.72	2014.02	2740.0
2014-06-16 00:00:00	NQ	Futures	4387.81	4388.69	4386.94	4386.94	172.0
2014-06-16 01:00:00	NQ	Futures	4386.64	4393.36	4386.35	4393.36	706.0
2014-06-16 02:00:00	NQ	Futures	4393.36	4395.41	4388.69	4390.15	638.0
2014-06-16 03:00:00	NQ	Futures	4389.86	4397.45	4389.56	4394.82	2619.0
2014-06-16 04:00:00	NQ	Futures	4394.82	4395.7	4391.61	4394.82	1558.0
2014-06-16 05:00:00	NQ	Futures	4394.82	4395.41	4386.35	4388.69	2039.0
2014-06-16 06:00:00	NQ	Futures	4388.98	4393.94	4388.69	4393.07	1175.0
2014-06-16 07:00:00	NQ	Futures	4393.36	4393.65	4389.56	4391.61	2751.0
2014-06-16 08:00:00	NQ	Futures	4391.61	4396.87	4388.69	4395.41	3274.0
2014-06-16 09:00:00	NQ	Futures	4395.41	4412.34	4390.44	4408.55	31563.0
2014-06-16 10:00:00	NQ	Futures	4408.84	4419.35	4405.63	4407.67	31487.0
2014-06-16 11:00:00	NQ	Futures	4407.67	4408.25	4385.48	4393.65	31647.0
2014-06-16 12:00:00	NQ	Futures	4393.36	4403.87	4392.19	4401.83	18698.0
2014-06-16 13:00:00	NQ	Futures	4401.83	4410.01	4397.74	4399.79	15436.0
2014-06-16 14:00:00	NQ	Futures	4399.79	4409.13	4399.2	4403.29	10710.0
2014-06-16 15:00:00	NQ	Futures	4403.0	4407.96	4397.74	4405.92	20034.0
2014-06-16 16:00:00	NQ	Futures	4405.92	4407.67	4405.63	4407.09	4204.0
2014-06-16 17:00:00	NQ	Futures	4407.09	4407.96	4407.09	4407.96	93.0
2014-06-16 18:00:00	NQ	Futures	4406.79	4410.3	4406.79	4409.71	458.0
2014-06-16 19:00:00	NQ	Futures	4409.42	4409.71	4408.84	4408.84	78.0
2014-06-16 20:00:00	NQ	Futures	4408.84	4411.17	4407.96	4410.3	520.0
2014-06-16 21:00:00	NQ	Futures	4410.3	4413.51	4410.01	4413.22	612.0
2014-06-16 22:00:00	NQ	Futures	4413.22	4413.51	4411.47	4411.76	252.0
2014-06-16 23:00:00	NQ	Futures	4412.34	4413.22	4409.13	4412.34	409.0
2014-06-16 00:00:00	YM	Futures	17221.4	17225.6	17220.4	17220.4	161.0
2014-06-16 01:00:00	YM	Futures	17219.4	17242.1	17217.3	17241.1	622.0

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

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