PREVIEW / futures_1hour / 2014-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-31.parquet
  size:    50 KB
  rows:    1,564

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-07-31 00:00:00	ES	Futures	2045.82	2046.34	2044.78	2045.82	2580.0
2014-07-31 01:00:00	ES	Futures	2046.08	2046.6	2045.3	2045.56	4239.0
2014-07-31 02:00:00	ES	Futures	2045.82	2046.34	2045.04	2045.56	5143.0
2014-07-31 03:00:00	ES	Futures	2045.56	2046.6	2038.26	2038.52	53902.0
2014-07-31 04:00:00	ES	Futures	2038.26	2039.04	2030.44	2032.27	79728.0
2014-07-31 05:00:00	ES	Futures	2032.27	2036.18	2031.49	2034.87	39251.0
2014-07-31 06:00:00	ES	Futures	2034.87	2037.48	2033.83	2036.96	27724.0
2014-07-31 07:00:00	ES	Futures	2037.22	2038.26	2033.83	2037.22	44249.0
2014-07-31 08:00:00	ES	Futures	2037.48	2039.57	2030.96	2032.79	91071.0
2014-07-31 09:00:00	ES	Futures	2033.05	2036.18	2029.66	2030.7	291823.0
2014-07-31 10:00:00	ES	Futures	2030.44	2032.79	2018.72	2019.24	449494.0
2014-07-31 11:00:00	ES	Futures	2019.24	2023.15	2015.59	2016.37	313990.0
2014-07-31 12:00:00	ES	Futures	2016.63	2019.76	2013.5	2018.72	257905.0
2014-07-31 13:00:00	ES	Futures	2018.72	2021.06	2014.55	2019.24	187046.0
2014-07-31 14:00:00	ES	Futures	2019.24	2021.32	2011.42	2011.68	183323.0
2014-07-31 15:00:00	ES	Futures	2011.68	2015.07	2006.73	2006.73	515049.0
2014-07-31 16:00:00	ES	Futures	2006.73	2010.38	2005.16	2006.21	193981.0
2014-07-31 17:00:00	ES	Futures	2006.21	2007.25	2005.42	2007.25	4130.0
2014-07-31 18:00:00	ES	Futures	2007.77	2010.12	2007.77	2009.33	7950.0
2014-07-31 19:00:00	ES	Futures	2009.33	2010.9	2008.81	2010.38	6529.0
2014-07-31 20:00:00	ES	Futures	2010.38	2011.94	2010.12	2011.94	9747.0
2014-07-31 21:00:00	ES	Futures	2011.68	2012.72	2009.86	2011.42	9353.0
2014-07-31 22:00:00	ES	Futures	2011.68	2012.72	2011.16	2012.2	7786.0
2014-07-31 23:00:00	ES	Futures	2012.2	2012.46	2010.9	2012.2	4154.0
2014-07-31 00:00:00	NQ	Futures	4630.48	4631.35	4628.14	4630.77	332.0
2014-07-31 01:00:00	NQ	Futures	4631.35	4633.11	4629.31	4630.48	567.0
2014-07-31 02:00:00	NQ	Futures	4630.18	4632.52	4628.43	4629.89	669.0
2014-07-31 03:00:00	NQ	Futures	4629.6	4633.4	4615.58	4615.58	7444.0
2014-07-31 04:00:00	NQ	Futures	4615.88	4616.75	4591.64	4595.73	13900.0
2014-07-31 05:00:00	NQ	Futures	4595.73	4607.12	4594.85	4604.78	7024.0
2014-07-31 06:00:00	NQ	Futures	4603.9	4608.58	4600.98	4607.7	5168.0
2014-07-31 07:00:00	NQ	Futures	4607.7	4608.28	4597.77	4606.53	6270.0
2014-07-31 08:00:00	NQ	Futures	4606.82	4612.08	4593.98	4596.9	12554.0
2014-07-31 09:00:00	NQ	Futures	4596.9	4604.49	4585.51	4586.09	56185.0
2014-07-31 10:00:00	NQ	Futures	4585.8	4592.51	4558.64	4560.1	75477.0
2014-07-31 11:00:00	NQ	Futures	4560.1	4567.99	4546.38	4549.59	59254.0
2014-07-31 12:00:00	NQ	Futures	4549.59	4560.39	4542.58	4559.81	42000.0
2014-07-31 13:00:00	NQ	Futures	4559.81	4566.82	4551.63	4565.36	24820.0
2014-07-31 14:00:00	NQ	Futures	4565.07	4567.11	4544.04	4544.04	29091.0
2014-07-31 15:00:00	NQ	Futures	4544.33	4553.68	4534.11	4541.12	64936.0
2014-07-31 16:00:00	NQ	Futures	4541.41	4551.92	4537.62	4540.83	14639.0
2014-07-31 17:00:00	NQ	Futures	4541.41	4544.92	4540.24	4544.04	488.0
2014-07-31 18:00:00	NQ	Futures	4544.33	4550.76	4544.33	4548.71	1038.0
2014-07-31 19:00:00	NQ	Futures	4548.42	4551.34	4546.67	4551.34	829.0
2014-07-31 20:00:00	NQ	Futures	4551.34	4555.43	4550.76	4554.85	1256.0
2014-07-31 21:00:00	NQ	Futures	4555.43	4556.01	4550.46	4553.38	1356.0
2014-07-31 22:00:00	NQ	Futures	4553.38	4555.43	4552.22	4554.85	1136.0
2014-07-31 23:00:00	NQ	Futures	4554.26	4555.14	4552.22	4554.26	751.0
2014-07-31 00:00:00	YM	Futures	17382.8	17384.9	17364.2	17379.7	1830.0
2014-07-31 01:00:00	YM	Futures	17379.7	17392.1	17369.4	17377.6	2472.0

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

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