PREVIEW / futures_1hour / 2014-08-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	2006.73	2007.25	2005.95	2006.99	2265.0
2014-08-04 01:00:00	ES	Futures	2006.73	2007.77	2006.21	2006.99	3790.0
2014-08-04 02:00:00	ES	Futures	2007.25	2008.55	2006.99	2008.29	10452.0
2014-08-04 03:00:00	ES	Futures	2008.03	2008.81	2006.21	2006.47	32695.0
2014-08-04 04:00:00	ES	Futures	2006.21	2006.99	2002.82	2005.16	33108.0
2014-08-04 05:00:00	ES	Futures	2004.9	2006.99	2004.64	2006.73	19617.0
2014-08-04 06:00:00	ES	Futures	2006.47	2008.29	2006.21	2006.99	20691.0
2014-08-04 07:00:00	ES	Futures	2006.73	2008.55	2006.47	2007.25	23776.0
2014-08-04 08:00:00	ES	Futures	2007.25	2008.03	2004.9	2005.16	38870.0
2014-08-04 09:00:00	ES	Futures	2005.16	2006.73	2002.3	2005.95	222046.0
2014-08-04 10:00:00	ES	Futures	2005.95	2007.25	1996.04	1997.61	285012.0
2014-08-04 11:00:00	ES	Futures	1997.35	2004.12	1996.56	2002.3	189178.0
2014-08-04 12:00:00	ES	Futures	2002.3	2006.73	2000.99	2005.69	99336.0
2014-08-04 13:00:00	ES	Futures	2005.42	2010.64	2004.12	2009.33	96483.0
2014-08-04 14:00:00	ES	Futures	2009.33	2015.85	2009.07	2014.81	132631.0
2014-08-04 15:00:00	ES	Futures	2014.81	2019.76	2014.02	2015.59	252975.0
2014-08-04 16:00:00	ES	Futures	2015.59	2015.85	2013.24	2014.02	92305.0
2014-08-04 17:00:00	ES	Futures	2013.76	2014.02	2012.72	2013.24	4148.0
2014-08-04 18:00:00	ES	Futures	2012.98	2013.24	2010.12	2012.72	9845.0
2014-08-04 19:00:00	ES	Futures	2012.72	2014.02	2012.46	2013.24	2109.0
2014-08-04 20:00:00	ES	Futures	2013.5	2013.76	2011.42	2012.2	4644.0
2014-08-04 21:00:00	ES	Futures	2011.94	2012.72	2010.12	2011.16	6627.0
2014-08-04 22:00:00	ES	Futures	2011.16	2012.72	2010.9	2011.94	2963.0
2014-08-04 23:00:00	ES	Futures	2011.94	2012.72	2011.68	2011.94	1971.0
2014-08-04 00:00:00	NQ	Futures	4535.28	4536.45	4533.24	4536.16	556.0
2014-08-04 01:00:00	NQ	Futures	4536.16	4537.62	4534.4	4536.45	638.0
2014-08-04 02:00:00	NQ	Futures	4536.45	4539.95	4536.16	4538.49	1317.0
2014-08-04 03:00:00	NQ	Futures	4538.2	4539.95	4533.53	4534.11	3917.0
2014-08-04 04:00:00	NQ	Futures	4534.11	4535.28	4526.81	4532.07	4581.0
2014-08-04 05:00:00	NQ	Futures	4531.78	4537.03	4530.32	4536.45	2755.0
2014-08-04 06:00:00	NQ	Futures	4536.16	4539.37	4534.99	4537.03	3473.0
2014-08-04 07:00:00	NQ	Futures	4536.74	4541.41	4536.16	4539.95	3279.0
2014-08-04 08:00:00	NQ	Futures	4539.66	4541.7	4535.86	4536.74	4376.0
2014-08-04 09:00:00	NQ	Futures	4536.45	4549.0	4529.15	4545.79	38323.0
2014-08-04 10:00:00	NQ	Futures	4545.79	4548.71	4517.18	4520.68	50595.0
2014-08-04 11:00:00	NQ	Futures	4520.39	4543.75	4517.76	4541.12	33020.0
2014-08-04 12:00:00	NQ	Futures	4541.12	4551.63	4537.91	4549.0	18683.0
2014-08-04 13:00:00	NQ	Futures	4549.0	4552.51	4542.87	4548.71	14642.0
2014-08-04 14:00:00	NQ	Futures	4548.71	4562.44	4548.71	4560.39	16906.0
2014-08-04 15:00:00	NQ	Futures	4560.39	4573.83	4555.43	4555.43	37406.0
2014-08-04 16:00:00	NQ	Futures	4555.43	4556.01	4549.88	4550.76	9933.0
2014-08-04 17:00:00	NQ	Futures	4550.76	4551.05	4548.13	4548.13	405.0
2014-08-04 18:00:00	NQ	Futures	4549.3	4550.46	4544.04	4549.3	894.0
2014-08-04 19:00:00	NQ	Futures	4549.59	4551.34	4549.59	4550.17	477.0
2014-08-04 20:00:00	NQ	Futures	4550.46	4550.76	4545.5	4546.96	694.0
2014-08-04 21:00:00	NQ	Futures	4546.96	4549.0	4542.87	4544.92	1334.0
2014-08-04 22:00:00	NQ	Futures	4545.21	4548.71	4544.33	4546.38	671.0
2014-08-04 23:00:00	NQ	Futures	4546.67	4547.84	4546.08	4546.08	263.0
2014-08-04 00:00:00	YM	Futures	17035.2	17039.3	17030.0	17037.3	600.0
2014-08-04 01:00:00	YM	Futures	17037.3	17042.5	17034.2	17036.2	635.0

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

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