PREVIEW / futures_1hour / 2014-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-21.parquet
  size:    52 KB
  rows:    1,576

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-10-21 00:00:00	ES	Futures	1984.93	1985.71	1982.05	1983.09	6157.0
2014-10-21 01:00:00	ES	Futures	1983.36	1984.4	1981.26	1983.36	5737.0
2014-10-21 02:00:00	ES	Futures	1983.09	1984.4	1978.38	1978.64	20681.0
2014-10-21 03:00:00	ES	Futures	1978.64	1991.21	1976.02	1989.38	54613.0
2014-10-21 04:00:00	ES	Futures	1989.64	1993.31	1987.81	1993.05	24994.0
2014-10-21 05:00:00	ES	Futures	1993.05	1997.76	1988.86	1996.19	43194.0
2014-10-21 06:00:00	ES	Futures	1996.19	2008.24	1996.19	2006.67	69352.0
2014-10-21 07:00:00	ES	Futures	2006.67	2007.98	1998.03	1999.6	76897.0
2014-10-21 08:00:00	ES	Futures	1999.6	2004.31	1997.5	2004.05	80033.0
2014-10-21 09:00:00	ES	Futures	2003.79	2009.29	2000.12	2007.19	289041.0
2014-10-21 10:00:00	ES	Futures	2006.93	2013.48	2005.62	2011.91	339620.0
2014-10-21 11:00:00	ES	Futures	2011.91	2019.51	2011.39	2018.46	307940.0
2014-10-21 12:00:00	ES	Futures	2018.46	2020.29	2015.58	2016.1	165034.0
2014-10-21 13:00:00	ES	Futures	2016.36	2021.86	2014.53	2020.82	168440.0
2014-10-21 14:00:00	ES	Futures	2021.08	2023.96	2019.77	2021.86	144490.0
2014-10-21 15:00:00	ES	Futures	2022.13	2028.94	2021.34	2027.37	275834.0
2014-10-21 16:00:00	ES	Futures	2027.1	2032.34	2027.1	2031.82	117322.0
2014-10-21 17:00:00	ES	Futures	2031.82	2032.6	2031.56	2031.56	2966.0
2014-10-21 18:00:00	ES	Futures	2031.03	2031.3	2029.2	2029.46	8728.0
2014-10-21 19:00:00	ES	Futures	2029.46	2029.72	2028.68	2028.94	4282.0
2014-10-21 20:00:00	ES	Futures	2028.94	2030.51	2028.68	2029.2	6674.0
2014-10-21 21:00:00	ES	Futures	2029.2	2029.72	2028.15	2029.2	5668.0
2014-10-21 22:00:00	ES	Futures	2028.94	2029.46	2028.15	2028.94	2714.0
2014-10-21 23:00:00	ES	Futures	2028.68	2029.72	2028.68	2029.72	1932.0
2014-10-21 00:00:00	NQ	Futures	4523.42	4524.89	4517.27	4519.32	979.0
2014-10-21 01:00:00	NQ	Futures	4519.91	4523.42	4516.1	4520.79	1201.0
2014-10-21 02:00:00	NQ	Futures	4520.79	4523.72	4508.48	4509.94	3158.0
2014-10-21 03:00:00	NQ	Futures	4510.24	4541.0	4507.6	4535.44	7397.0
2014-10-21 04:00:00	NQ	Futures	4535.73	4545.69	4532.21	4544.81	4965.0
2014-10-21 05:00:00	NQ	Futures	4544.81	4554.77	4535.14	4550.67	5983.0
2014-10-21 06:00:00	NQ	Futures	4551.26	4576.46	4550.67	4573.23	10167.0
2014-10-21 07:00:00	NQ	Futures	4573.53	4576.46	4556.24	4560.34	9997.0
2014-10-21 08:00:00	NQ	Futures	4559.76	4575.87	4557.7	4575.58	14455.0
2014-10-21 09:00:00	NQ	Futures	4575.58	4588.76	4569.42	4583.49	61880.0
2014-10-21 10:00:00	NQ	Futures	4584.66	4599.9	4577.04	4598.72	56088.0
2014-10-21 11:00:00	NQ	Futures	4598.72	4614.84	4597.55	4610.15	42271.0
2014-10-21 12:00:00	NQ	Futures	4610.15	4616.6	4607.51	4609.27	23936.0
2014-10-21 13:00:00	NQ	Futures	4609.27	4628.32	4605.46	4624.51	36140.0
2014-10-21 14:00:00	NQ	Futures	4624.51	4636.23	4621.87	4631.54	32329.0
2014-10-21 15:00:00	NQ	Futures	4631.54	4644.43	4630.37	4643.26	47380.0
2014-10-21 16:00:00	NQ	Futures	4643.55	4659.67	4642.38	4658.79	14658.0
2014-10-21 17:00:00	NQ	Futures	4658.79	4659.96	4657.91	4657.91	559.0
2014-10-21 18:00:00	NQ	Futures	4653.52	4654.98	4650.29	4650.59	1453.0
2014-10-21 19:00:00	NQ	Futures	4650.29	4650.59	4648.24	4649.71	540.0
2014-10-21 20:00:00	NQ	Futures	4650.0	4654.4	4649.41	4651.76	845.0
2014-10-21 21:00:00	NQ	Futures	4651.76	4652.93	4650.0	4651.76	863.0
2014-10-21 22:00:00	NQ	Futures	4651.47	4652.64	4650.0	4650.59	371.0
2014-10-21 23:00:00	NQ	Futures	4650.88	4653.22	4650.29	4653.22	250.0
2014-10-21 00:00:00	YM	Futures	16929.4	16935.7	16909.7	16914.9	693.0
2014-10-21 01:00:00	YM	Futures	16914.9	16925.3	16901.4	16921.1	809.0

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

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