PREVIEW / futures_1hour / 2014-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-05.parquet
  size:    50 KB
  rows:    1,562

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-05 00:00:00	ES	Futures	2011.68	2012.46	2011.42	2012.2	2056.0
2014-08-05 01:00:00	ES	Futures	2012.2	2012.2	2009.33	2010.12	10625.0
2014-08-05 02:00:00	ES	Futures	2010.38	2012.46	2010.12	2012.46	10145.0
2014-08-05 03:00:00	ES	Futures	2012.2	2013.76	2010.64	2011.68	30948.0
2014-08-05 04:00:00	ES	Futures	2011.94	2015.33	2011.94	2014.02	20437.0
2014-08-05 05:00:00	ES	Futures	2014.02	2014.81	2011.16	2011.42	21909.0
2014-08-05 06:00:00	ES	Futures	2011.42	2012.2	2009.86	2010.9	24625.0
2014-08-05 07:00:00	ES	Futures	2011.16	2011.16	2007.51	2007.77	34960.0
2014-08-05 08:00:00	ES	Futures	2007.77	2007.77	2003.86	2006.99	77280.0
2014-08-05 09:00:00	ES	Futures	2006.99	2010.64	2002.04	2004.64	277720.0
2014-08-05 10:00:00	ES	Futures	2005.16	2011.94	2001.52	2007.77	317254.0
2014-08-05 11:00:00	ES	Futures	2007.77	2012.46	2005.16	2005.95	197200.0
2014-08-05 12:00:00	ES	Futures	2005.69	2007.25	2001.52	2004.64	114584.0
2014-08-05 13:00:00	ES	Futures	2004.9	2007.25	1991.35	1994.22	295002.0
2014-08-05 14:00:00	ES	Futures	1993.96	1997.35	1988.48	1993.18	260402.0
2014-08-05 15:00:00	ES	Futures	1992.92	1998.91	1989.27	1995.52	315756.0
2014-08-05 16:00:00	ES	Futures	1995.52	1996.3	1993.7	1995.26	92117.0
2014-08-05 17:00:00	ES	Futures	1995.26	1995.78	1994.74	1995.78	1518.0
2014-08-05 18:00:00	ES	Futures	1996.04	1997.61	1995.78	1997.35	3715.0
2014-08-05 19:00:00	ES	Futures	1997.35	1997.35	1995.52	1996.82	2499.0
2014-08-05 20:00:00	ES	Futures	1996.56	1997.08	1993.96	1995.0	7602.0
2014-08-05 21:00:00	ES	Futures	1995.0	1996.04	1993.96	1994.22	5254.0
2014-08-05 22:00:00	ES	Futures	1994.22	1995.26	1992.13	1993.18	8254.0
2014-08-05 23:00:00	ES	Futures	1993.18	1995.78	1992.39	1995.26	4817.0
2014-08-05 00:00:00	NQ	Futures	4546.08	4547.84	4545.5	4546.67	292.0
2014-08-05 01:00:00	NQ	Futures	4546.38	4547.25	4540.54	4542.29	1287.0
2014-08-05 02:00:00	NQ	Futures	4542.29	4546.96	4541.7	4546.38	1177.0
2014-08-05 03:00:00	NQ	Futures	4546.67	4551.05	4543.16	4546.38	3436.0
2014-08-05 04:00:00	NQ	Futures	4546.67	4555.72	4546.67	4552.51	2457.0
2014-08-05 05:00:00	NQ	Futures	4552.51	4553.97	4544.62	4545.79	2626.0
2014-08-05 06:00:00	NQ	Futures	4545.79	4547.54	4541.7	4545.21	2697.0
2014-08-05 07:00:00	NQ	Futures	4545.21	4545.21	4538.49	4538.49	3728.0
2014-08-05 08:00:00	NQ	Futures	4538.78	4539.08	4531.48	4536.45	7770.0
2014-08-05 09:00:00	NQ	Futures	4536.45	4547.25	4518.64	4523.89	44662.0
2014-08-05 10:00:00	NQ	Futures	4524.18	4547.84	4518.05	4538.78	54934.0
2014-08-05 11:00:00	NQ	Futures	4538.78	4550.46	4530.02	4533.24	35281.0
2014-08-05 12:00:00	NQ	Futures	4532.94	4536.16	4522.43	4532.07	21911.0
2014-08-05 13:00:00	NQ	Futures	4532.36	4539.95	4506.08	4511.92	57650.0
2014-08-05 14:00:00	NQ	Futures	4511.92	4519.51	4499.07	4509.0	47111.0
2014-08-05 15:00:00	NQ	Futures	4509.0	4524.48	4499.95	4520.97	55130.0
2014-08-05 16:00:00	NQ	Futures	4520.97	4526.23	4518.05	4524.77	9778.0
2014-08-05 17:00:00	NQ	Futures	4524.77	4526.23	4524.77	4526.23	255.0
2014-08-05 18:00:00	NQ	Futures	4525.64	4530.02	4525.64	4529.44	846.0
2014-08-05 19:00:00	NQ	Futures	4528.86	4529.15	4525.94	4528.27	266.0
2014-08-05 20:00:00	NQ	Futures	4528.27	4528.86	4522.72	4524.48	866.0
2014-08-05 21:00:00	NQ	Futures	4524.48	4526.81	4521.56	4522.43	963.0
2014-08-05 22:00:00	NQ	Futures	4522.72	4524.48	4518.64	4519.8	1341.0
2014-08-05 23:00:00	NQ	Futures	4520.1	4525.94	4518.34	4525.06	890.0
2014-08-05 00:00:00	YM	Futures	17036.2	17043.5	17034.2	17040.4	330.0
2014-08-05 01:00:00	YM	Futures	17039.3	17041.4	17024.9	17028.0	1263.0

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

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