PREVIEW / futures_1hour / 2014-08-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1995.0	1995.26	1993.44	1995.26	1627.0
2014-08-06 01:00:00	ES	Futures	1995.26	1996.82	1993.96	1996.56	4365.0
2014-08-06 02:00:00	ES	Futures	1996.56	1997.35	1995.52	1997.08	9785.0
2014-08-06 03:00:00	ES	Futures	1997.08	1999.69	1995.26	1998.39	36721.0
2014-08-06 04:00:00	ES	Futures	1998.13	1998.91	1992.65	1993.44	29318.0
2014-08-06 05:00:00	ES	Futures	1993.18	1993.44	1989.53	1991.35	47615.0
2014-08-06 06:00:00	ES	Futures	1991.35	1992.13	1983.79	1987.18	64531.0
2014-08-06 07:00:00	ES	Futures	1987.18	1990.05	1986.14	1986.92	38754.0
2014-08-06 08:00:00	ES	Futures	1987.18	1989.53	1985.36	1986.66	68038.0
2014-08-06 09:00:00	ES	Futures	1986.4	1996.82	1984.84	1993.18	295017.0
2014-08-06 10:00:00	ES	Futures	1993.18	2003.6	1992.92	2003.08	312331.0
2014-08-06 11:00:00	ES	Futures	2003.08	2004.9	1998.91	2003.86	202969.0
2014-08-06 12:00:00	ES	Futures	2003.86	2005.16	1998.91	1999.95	149305.0
2014-08-06 13:00:00	ES	Futures	1999.95	2001.25	1994.74	1995.26	105179.0
2014-08-06 14:00:00	ES	Futures	1995.26	1998.91	1993.96	1996.82	96622.0
2014-08-06 15:00:00	ES	Futures	1997.08	1999.17	1995.26	1996.3	149860.0
2014-08-06 16:00:00	ES	Futures	1996.56	1997.08	1995.78	1996.3	57479.0
2014-08-06 17:00:00	ES	Futures	1996.3	1996.56	1996.04	1996.3	1775.0
2014-08-06 18:00:00	ES	Futures	1996.04	1996.82	1994.74	1995.52	4224.0
2014-08-06 19:00:00	ES	Futures	1995.52	1997.61	1995.0	1997.35	1739.0
2014-08-06 20:00:00	ES	Futures	1997.61	1999.17	1997.08	1997.87	6580.0
2014-08-06 21:00:00	ES	Futures	1997.87	1998.91	1994.74	1995.78	6708.0
2014-08-06 22:00:00	ES	Futures	1995.78	1997.35	1995.78	1996.82	2983.0
2014-08-06 23:00:00	ES	Futures	1996.82	1998.39	1996.3	1997.87	2550.0
2014-08-06 00:00:00	NQ	Futures	4525.06	4525.35	4521.56	4525.06	517.0
2014-08-06 01:00:00	NQ	Futures	4524.48	4528.27	4522.14	4527.98	1468.0
2014-08-06 02:00:00	NQ	Futures	4527.69	4528.86	4524.48	4527.98	1385.0
2014-08-06 03:00:00	NQ	Futures	4527.69	4534.11	4523.6	4531.19	5371.0
2014-08-06 04:00:00	NQ	Futures	4531.48	4532.94	4517.18	4519.51	4425.0
2014-08-06 05:00:00	NQ	Futures	4519.51	4519.8	4509.58	4513.67	8389.0
2014-08-06 06:00:00	NQ	Futures	4513.67	4516.3	4491.48	4499.07	10734.0
2014-08-06 07:00:00	NQ	Futures	4499.07	4504.03	4496.73	4499.36	7701.0
2014-08-06 08:00:00	NQ	Futures	4499.36	4503.74	4493.81	4496.44	11302.0
2014-08-06 09:00:00	NQ	Futures	4496.44	4515.72	4487.68	4504.91	49439.0
2014-08-06 10:00:00	NQ	Futures	4504.91	4535.57	4504.91	4533.82	55467.0
2014-08-06 11:00:00	NQ	Futures	4533.82	4544.33	4525.64	4541.7	32956.0
2014-08-06 12:00:00	NQ	Futures	4541.7	4545.21	4530.02	4533.53	28753.0
2014-08-06 13:00:00	NQ	Futures	4533.53	4534.7	4518.93	4520.97	20643.0
2014-08-06 14:00:00	NQ	Futures	4520.97	4530.02	4517.76	4524.18	19191.0
2014-08-06 15:00:00	NQ	Futures	4523.89	4529.15	4516.01	4517.47	25290.0
2014-08-06 16:00:00	NQ	Futures	4517.18	4520.97	4515.13	4519.22	4208.0
2014-08-06 17:00:00	NQ	Futures	4519.22	4520.39	4519.22	4519.51	52.0
2014-08-06 18:00:00	NQ	Futures	4519.51	4521.85	4516.59	4518.34	448.0
2014-08-06 19:00:00	NQ	Futures	4518.64	4523.6	4517.76	4523.02	356.0
2014-08-06 20:00:00	NQ	Futures	4523.6	4526.81	4522.14	4523.89	1028.0
2014-08-06 21:00:00	NQ	Futures	4523.31	4526.23	4515.42	4517.47	1379.0
2014-08-06 22:00:00	NQ	Futures	4517.47	4522.14	4517.47	4520.1	702.0
2014-08-06 23:00:00	NQ	Futures	4520.1	4522.72	4518.64	4519.22	962.0
2014-08-06 00:00:00	YM	Futures	16927.6	16929.7	16917.3	16927.6	350.0
2014-08-06 01:00:00	YM	Futures	16927.6	16943.1	16918.3	16943.1	1385.0

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

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