PREVIEW / futures_1hour / 2014-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-01.parquet
  size:    44 KB
  rows:    1,275

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-01 00:00:00	ES	Futures	2012.2	2012.72	2011.42	2011.94	2646.0
2014-08-01 01:00:00	ES	Futures	2011.94	2012.2	2009.07	2010.38	6103.0
2014-08-01 02:00:00	ES	Futures	2010.38	2011.42	2008.55	2009.07	11373.0
2014-08-01 03:00:00	ES	Futures	2009.07	2010.64	2004.9	2006.47	49518.0
2014-08-01 04:00:00	ES	Futures	2006.47	2007.25	1997.61	1998.65	74190.0
2014-08-01 05:00:00	ES	Futures	1998.65	1999.43	1991.61	1992.39	69416.0
2014-08-01 06:00:00	ES	Futures	1992.65	1995.78	1991.61	1995.26	50033.0
2014-08-01 07:00:00	ES	Futures	1995.0	1998.39	1992.92	1997.61	47901.0
2014-08-01 08:00:00	ES	Futures	1997.35	2008.55	1992.39	2003.86	263108.0
2014-08-01 09:00:00	ES	Futures	2003.86	2011.94	1999.43	2010.38	349452.0
2014-08-01 10:00:00	ES	Futures	2010.64	2014.29	2003.6	2004.9	392014.0
2014-08-01 11:00:00	ES	Futures	2004.9	2005.16	1991.35	1993.18	397374.0
2014-08-01 12:00:00	ES	Futures	1993.44	1998.13	1992.13	1996.56	246439.0
2014-08-01 13:00:00	ES	Futures	1996.3	2006.47	1993.7	2005.69	312732.0
2014-08-01 14:00:00	ES	Futures	2005.69	2008.55	2002.04	2003.86	175777.0
2014-08-01 15:00:00	ES	Futures	2003.86	2006.73	1999.43	2000.99	255507.0
2014-08-01 16:00:00	ES	Futures	2001.25	2002.82	1997.08	1999.69	122865.0
2014-08-01 17:00:00	ES	Futures	1999.69	2000.21	1998.39	1998.39	1980.0
2014-08-01 00:00:00	NQ	Futures	4553.97	4554.85	4552.22	4553.09	701.0
2014-08-01 01:00:00	NQ	Futures	4553.38	4553.68	4546.67	4548.71	1328.0
2014-08-01 02:00:00	NQ	Futures	4549.59	4552.8	4546.67	4547.54	993.0
2014-08-01 03:00:00	NQ	Futures	4547.54	4550.76	4537.03	4542.29	5850.0
2014-08-01 04:00:00	NQ	Futures	4542.29	4543.75	4518.05	4520.68	11148.0
2014-08-01 05:00:00	NQ	Futures	4520.97	4522.43	4502.28	4504.62	14234.0
2014-08-01 06:00:00	NQ	Futures	4504.33	4511.92	4501.11	4509.58	10419.0
2014-08-01 07:00:00	NQ	Futures	4509.58	4518.93	4503.16	4517.76	7354.0
2014-08-01 08:00:00	NQ	Futures	4517.47	4542.0	4510.46	4534.99	37432.0
2014-08-01 09:00:00	NQ	Futures	4534.99	4556.31	4527.1	4552.22	60621.0
2014-08-01 10:00:00	NQ	Futures	4552.8	4556.89	4525.06	4528.56	65695.0
2014-08-01 11:00:00	NQ	Futures	4528.27	4530.9	4499.95	4504.03	66250.0
2014-08-01 12:00:00	NQ	Futures	4503.74	4513.67	4494.11	4506.08	42436.0
2014-08-01 13:00:00	NQ	Futures	4506.37	4527.4	4498.19	4525.06	41466.0
2014-08-01 14:00:00	NQ	Futures	4525.06	4535.57	4519.22	4522.43	38716.0
2014-08-01 15:00:00	NQ	Futures	4522.43	4531.48	4519.51	4524.18	40996.0
2014-08-01 16:00:00	NQ	Futures	4524.48	4530.9	4517.76	4524.18	10314.0
2014-08-01 17:00:00	NQ	Futures	4524.18	4524.48	4520.39	4520.39	173.0
2014-08-01 00:00:00	YM	Futures	17111.8	17119.0	17108.7	17114.9	466.0
2014-08-01 01:00:00	YM	Futures	17115.9	17115.9	17095.2	17101.4	906.0
2014-08-01 02:00:00	YM	Futures	17102.5	17110.7	17092.1	17096.2	1205.0
2014-08-01 03:00:00	YM	Futures	17095.2	17107.6	17059.0	17073.5	6010.0
2014-08-01 04:00:00	YM	Futures	17073.5	17078.7	16992.8	17004.2	12570.0
2014-08-01 05:00:00	YM	Futures	17004.2	17009.3	16945.2	16952.5	10255.0
2014-08-01 06:00:00	YM	Futures	16951.4	16972.1	16946.2	16966.9	5837.0
2014-08-01 07:00:00	YM	Futures	16966.9	17004.2	16953.5	16996.9	7285.0
2014-08-01 08:00:00	YM	Futures	16998.0	17071.4	16964.9	17043.5	24847.0
2014-08-01 09:00:00	YM	Futures	17043.5	17070.4	17005.2	17059.0	32346.0
2014-08-01 10:00:00	YM	Futures	17060.0	17091.1	17017.6	17030.0	35434.0
2014-08-01 11:00:00	YM	Futures	17030.0	17031.1	16934.9	16949.3	31704.0
2014-08-01 12:00:00	YM	Futures	16948.3	16984.5	16940.0	16970.0	19190.0
2014-08-01 13:00:00	YM	Futures	16970.0	17040.4	16950.4	17034.2	28915.0

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

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