PREVIEW / futures_1hour / 2014-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-13.parquet
  size:    42 KB
  rows:    1,241

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-13 00:00:00	ES	Futures	2004.66	2007.52	2004.14	2007.26	3737.0
2014-06-13 01:00:00	ES	Futures	2007.26	2008.82	2006.74	2008.3	4521.0
2014-06-13 02:00:00	ES	Futures	2008.56	2008.82	2007.52	2008.04	5762.0
2014-06-13 03:00:00	ES	Futures	2008.3	2008.3	2003.88	2004.4	10361.0
2014-06-13 04:00:00	ES	Futures	2004.4	2008.04	2004.14	2006.22	8746.0
2014-06-13 05:00:00	ES	Futures	2006.48	2006.74	2003.1	2003.62	10026.0
2014-06-13 06:00:00	ES	Futures	2003.62	2004.66	2001.81	2002.58	8970.0
2014-06-13 07:00:00	ES	Futures	2002.58	2004.4	2001.03	2004.14	10224.0
2014-06-13 08:00:00	ES	Futures	2004.14	2005.18	2002.06	2005.18	12990.0
2014-06-13 09:00:00	ES	Futures	2005.18	2008.56	2002.84	2004.92	58900.0
2014-06-13 10:00:00	ES	Futures	2004.66	2011.93	2001.29	2010.63	65813.0
2014-06-13 11:00:00	ES	Futures	2010.89	2011.93	2007.0	2007.78	35575.0
2014-06-13 12:00:00	ES	Futures	2008.04	2010.37	2007.26	2007.78	16677.0
2014-06-13 13:00:00	ES	Futures	2007.52	2009.08	2006.48	2008.82	24102.0
2014-06-13 14:00:00	ES	Futures	2008.82	2010.37	2008.56	2009.34	13745.0
2014-06-13 15:00:00	ES	Futures	2009.34	2011.93	2005.18	2010.11	66787.0
2014-06-13 16:00:00	ES	Futures	2009.85	2010.89	2009.08	2010.63	26949.0
2014-06-13 17:00:00	ES	Futures	2010.63	2010.89	2009.6	2009.85	501.0
2014-06-13 00:00:00	NQ	Futures	4396.87	4400.66	4395.42	4400.37	652.0
2014-06-13 01:00:00	NQ	Futures	4400.37	4402.12	4397.75	4401.24	1363.0
2014-06-13 02:00:00	NQ	Futures	4401.24	4402.12	4398.91	4401.24	730.0
2014-06-13 03:00:00	NQ	Futures	4400.66	4400.95	4391.05	4391.63	1785.0
2014-06-13 04:00:00	NQ	Futures	4391.34	4398.91	4391.34	4393.96	1039.0
2014-06-13 05:00:00	NQ	Futures	4394.25	4396.29	4389.59	4390.18	1856.0
2014-06-13 06:00:00	NQ	Futures	4390.18	4393.96	4387.85	4391.05	1493.0
2014-06-13 07:00:00	NQ	Futures	4390.76	4395.42	4387.26	4394.84	2367.0
2014-06-13 08:00:00	NQ	Futures	4395.13	4398.91	4389.88	4398.33	1960.0
2014-06-13 09:00:00	NQ	Futures	4398.62	4406.78	4389.3	4395.13	18612.0
2014-06-13 10:00:00	NQ	Futures	4394.84	4408.23	4379.98	4408.23	18790.0
2014-06-13 11:00:00	NQ	Futures	4408.52	4409.98	4391.63	4394.25	8140.0
2014-06-13 12:00:00	NQ	Futures	4394.54	4402.41	4393.67	4393.96	4167.0
2014-06-13 13:00:00	NQ	Futures	4393.96	4399.2	4390.76	4398.04	3136.0
2014-06-13 14:00:00	NQ	Futures	4398.62	4401.82	4394.84	4396.0	2581.0
2014-06-13 15:00:00	NQ	Futures	4396.29	4401.24	4384.93	4398.33	8370.0
2014-06-13 16:00:00	NQ	Futures	4398.04	4400.66	4396.87	4400.08	1865.0
2014-06-13 17:00:00	NQ	Futures	4400.08	4400.37	4399.2	4400.08	49.0
2014-06-13 00:00:00	YM	Futures	17252.5	17271.1	17250.4	17271.1	669.0
2014-06-13 01:00:00	YM	Futures	17270.0	17281.4	17263.8	17277.3	1007.0
2014-06-13 02:00:00	YM	Futures	17277.3	17281.4	17270.0	17277.3	843.0
2014-06-13 03:00:00	YM	Futures	17278.3	17278.3	17239.0	17241.1	3340.0
2014-06-13 04:00:00	YM	Futures	17242.1	17268.0	17240.0	17258.7	1448.0
2014-06-13 05:00:00	YM	Futures	17258.7	17260.7	17235.9	17236.9	1403.0
2014-06-13 06:00:00	YM	Futures	17236.9	17245.2	17222.5	17228.7	1946.0
2014-06-13 07:00:00	YM	Futures	17228.7	17245.2	17214.2	17242.1	1677.0
2014-06-13 08:00:00	YM	Futures	17243.1	17249.4	17222.5	17248.3	1695.0
2014-06-13 09:00:00	YM	Futures	17249.4	17271.1	17228.7	17243.1	13643.0
2014-06-13 10:00:00	YM	Futures	17243.1	17295.9	17222.5	17278.3	15561.0
2014-06-13 11:00:00	YM	Futures	17279.4	17292.8	17259.7	17270.0	6602.0
2014-06-13 12:00:00	YM	Futures	17270.0	17282.5	17257.6	17257.6	4386.0
2014-06-13 13:00:00	YM	Futures	17257.6	17268.0	17246.3	17264.9	5156.0

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

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