PREVIEW / futures_1hour / 2014-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-07.parquet
  size:    51 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-08-07 00:00:00	ES	Futures	1997.87	1998.13	1997.08	1998.13	2420.0
2014-08-07 01:00:00	ES	Futures	1998.13	2000.99	1998.13	1999.43	9199.0
2014-08-07 02:00:00	ES	Futures	1999.43	2000.73	1998.13	1999.17	9517.0
2014-08-07 03:00:00	ES	Futures	1999.17	1999.43	1995.78	1998.65	36090.0
2014-08-07 04:00:00	ES	Futures	1998.65	2003.34	1998.13	2002.04	29297.0
2014-08-07 05:00:00	ES	Futures	2002.04	2002.3	1999.43	2001.52	14070.0
2014-08-07 06:00:00	ES	Futures	2001.25	2002.04	1997.87	1999.43	12694.0
2014-08-07 07:00:00	ES	Futures	1999.43	2001.25	1998.91	2000.47	26435.0
2014-08-07 08:00:00	ES	Futures	2000.47	2006.73	1999.95	2001.78	89621.0
2014-08-07 09:00:00	ES	Futures	2002.04	2007.51	1999.69	2003.08	237022.0
2014-08-07 10:00:00	ES	Futures	2003.08	2004.9	1993.96	1997.35	271602.0
2014-08-07 11:00:00	ES	Futures	1997.08	1997.35	1988.48	1991.61	294270.0
2014-08-07 12:00:00	ES	Futures	1991.61	1993.18	1983.79	1988.22	214857.0
2014-08-07 13:00:00	ES	Futures	1987.96	1995.0	1987.96	1993.7	122375.0
2014-08-07 14:00:00	ES	Futures	1993.44	1993.7	1985.36	1985.88	111243.0
2014-08-07 15:00:00	ES	Futures	1985.62	1988.22	1980.41	1985.36	345944.0
2014-08-07 16:00:00	ES	Futures	1985.36	1986.66	1984.31	1985.1	93316.0
2014-08-07 17:00:00	ES	Futures	1985.1	1986.4	1985.1	1986.4	3624.0
2014-08-07 18:00:00	ES	Futures	1986.14	1987.18	1985.62	1986.66	4767.0
2014-08-07 19:00:00	ES	Futures	1986.66	1987.18	1986.14	1986.92	2191.0
2014-08-07 20:00:00	ES	Futures	1986.92	1987.7	1985.62	1985.88	6411.0
2014-08-07 21:00:00	ES	Futures	1985.88	1986.14	1977.02	1977.54	39463.0
2014-08-07 22:00:00	ES	Futures	1977.54	1978.06	1971.81	1976.24	43532.0
2014-08-07 23:00:00	ES	Futures	1975.98	1977.8	1974.15	1975.98	14167.0
2014-08-07 00:00:00	NQ	Futures	4519.22	4521.26	4518.93	4520.1	703.0
2014-08-07 01:00:00	NQ	Futures	4520.1	4527.69	4520.1	4525.06	1413.0
2014-08-07 02:00:00	NQ	Futures	4525.06	4527.69	4520.39	4523.6	843.0
2014-08-07 03:00:00	NQ	Futures	4523.31	4523.6	4512.21	4518.64	6595.0
2014-08-07 04:00:00	NQ	Futures	4518.64	4530.02	4518.05	4526.81	5063.0
2014-08-07 05:00:00	NQ	Futures	4526.81	4527.1	4521.56	4525.35	2423.0
2014-08-07 06:00:00	NQ	Futures	4525.64	4527.69	4518.34	4521.56	1871.0
2014-08-07 07:00:00	NQ	Futures	4521.85	4526.23	4520.68	4524.18	3593.0
2014-08-07 08:00:00	NQ	Futures	4524.18	4539.08	4523.6	4529.15	11241.0
2014-08-07 09:00:00	NQ	Futures	4529.15	4542.0	4528.27	4539.37	45075.0
2014-08-07 10:00:00	NQ	Futures	4539.37	4546.67	4518.93	4528.27	56806.0
2014-08-07 11:00:00	NQ	Futures	4527.98	4532.65	4511.04	4517.18	52645.0
2014-08-07 12:00:00	NQ	Futures	4516.88	4522.14	4503.45	4510.17	36209.0
2014-08-07 13:00:00	NQ	Futures	4510.46	4526.81	4509.87	4525.35	22943.0
2014-08-07 14:00:00	NQ	Futures	4525.06	4525.35	4505.2	4506.08	22743.0
2014-08-07 15:00:00	NQ	Futures	4506.37	4511.04	4486.22	4502.57	48079.0
2014-08-07 16:00:00	NQ	Futures	4502.28	4506.08	4499.95	4501.99	6289.0
2014-08-07 17:00:00	NQ	Futures	4503.16	4505.2	4502.57	4505.2	134.0
2014-08-07 18:00:00	NQ	Futures	4503.45	4506.37	4500.53	4503.45	883.0
2014-08-07 19:00:00	NQ	Futures	4503.45	4504.03	4501.99	4503.16	315.0
2014-08-07 20:00:00	NQ	Futures	4503.74	4505.2	4500.53	4500.82	616.0
2014-08-07 21:00:00	NQ	Futures	4500.82	4501.11	4481.26	4484.18	4387.0
2014-08-07 22:00:00	NQ	Futures	4483.89	4484.76	4471.62	4480.97	5343.0
2014-08-07 23:00:00	NQ	Futures	4480.38	4484.76	4477.75	4480.67	2913.0
2014-08-07 00:00:00	YM	Futures	16970.0	16976.2	16964.9	16972.1	1244.0
2014-08-07 01:00:00	YM	Futures	16970.0	17001.1	16966.9	16984.5	5675.0

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

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