PREVIEW / futures_1hour / 2014-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-29.parquet
  size:    47 KB
  rows:    1,519

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-05-29 00:00:00	ES	Futures	1984.67	1985.45	1984.67	1984.93	2169.0
2014-05-29 01:00:00	ES	Futures	1984.93	1985.71	1984.93	1985.45	1718.0
2014-05-29 02:00:00	ES	Futures	1985.45	1985.71	1984.41	1984.67	3110.0
2014-05-29 03:00:00	ES	Futures	1984.93	1985.97	1983.11	1984.15	16799.0
2014-05-29 04:00:00	ES	Futures	1984.15	1984.67	1982.85	1984.41	7078.0
2014-05-29 05:00:00	ES	Futures	1984.41	1984.67	1983.63	1984.15	4830.0
2014-05-29 06:00:00	ES	Futures	1983.89	1984.93	1983.11	1984.41	6966.0
2014-05-29 07:00:00	ES	Futures	1984.41	1984.93	1983.63	1983.63	8817.0
2014-05-29 08:00:00	ES	Futures	1983.63	1985.97	1982.59	1985.71	44719.0
2014-05-29 09:00:00	ES	Futures	1985.71	1987.78	1984.41	1986.22	143818.0
2014-05-29 10:00:00	ES	Futures	1986.22	1987.0	1981.03	1985.71	181382.0
2014-05-29 11:00:00	ES	Futures	1985.45	1987.26	1984.41	1985.45	93189.0
2014-05-29 12:00:00	ES	Futures	1985.45	1987.0	1984.93	1986.22	48668.0
2014-05-29 13:00:00	ES	Futures	1985.97	1987.0	1985.45	1986.22	36424.0
2014-05-29 14:00:00	ES	Futures	1986.48	1990.38	1985.97	1989.86	97418.0
2014-05-29 15:00:00	ES	Futures	1990.12	1992.2	1989.6	1992.2	185369.0
2014-05-29 16:00:00	ES	Futures	1991.94	1992.2	1991.42	1991.68	68532.0
2014-05-29 17:00:00	ES	Futures	1991.94	1991.94	1991.42	1991.94	2278.0
2014-05-29 18:00:00	ES	Futures	1991.16	1991.94	1990.9	1991.16	4064.0
2014-05-29 19:00:00	ES	Futures	1991.16	1991.42	1990.9	1990.9	1242.0
2014-05-29 20:00:00	ES	Futures	1990.64	1991.16	1989.34	1989.86	5463.0
2014-05-29 21:00:00	ES	Futures	1990.12	1990.9	1989.6	1990.38	2401.0
2014-05-29 22:00:00	ES	Futures	1990.38	1990.38	1988.56	1988.82	6030.0
2014-05-29 23:00:00	ES	Futures	1988.56	1989.86	1988.56	1989.34	2132.0
2014-05-29 00:00:00	NQ	Futures	4331.64	4333.1	4331.35	4332.22	534.0
2014-05-29 01:00:00	NQ	Futures	4332.51	4334.26	4332.22	4334.26	287.0
2014-05-29 02:00:00	NQ	Futures	4333.97	4334.26	4331.35	4332.22	316.0
2014-05-29 03:00:00	NQ	Futures	4332.22	4335.13	4329.31	4331.35	1736.0
2014-05-29 04:00:00	NQ	Futures	4331.93	4333.39	4329.31	4332.51	828.0
2014-05-29 05:00:00	NQ	Futures	4332.51	4333.1	4331.06	4331.35	624.0
2014-05-29 06:00:00	NQ	Futures	4331.64	4333.68	4329.89	4332.22	923.0
2014-05-29 07:00:00	NQ	Futures	4332.51	4334.55	4329.02	4329.31	1749.0
2014-05-29 08:00:00	NQ	Futures	4329.31	4335.13	4327.27	4334.84	6051.0
2014-05-29 09:00:00	NQ	Futures	4334.55	4342.42	4329.89	4338.92	35633.0
2014-05-29 10:00:00	NQ	Futures	4338.92	4341.25	4328.73	4338.92	40156.0
2014-05-29 11:00:00	NQ	Futures	4338.92	4344.75	4334.55	4335.43	19738.0
2014-05-29 12:00:00	NQ	Futures	4335.43	4341.25	4333.97	4338.34	10660.0
2014-05-29 13:00:00	NQ	Futures	4338.34	4340.96	4335.13	4338.34	7738.0
2014-05-29 14:00:00	NQ	Futures	4338.34	4345.33	4337.46	4344.75	13529.0
2014-05-29 15:00:00	NQ	Futures	4345.04	4350.57	4341.54	4349.7	33336.0
2014-05-29 16:00:00	NQ	Futures	4349.7	4353.48	4349.11	4352.32	7902.0
2014-05-29 17:00:00	NQ	Futures	4352.03	4352.9	4351.73	4352.9	115.0
2014-05-29 18:00:00	NQ	Futures	4351.15	4352.9	4350.28	4351.73	539.0
2014-05-29 19:00:00	NQ	Futures	4351.44	4351.73	4350.57	4351.15	192.0
2014-05-29 20:00:00	NQ	Futures	4350.86	4351.44	4348.24	4349.11	982.0
2014-05-29 21:00:00	NQ	Futures	4349.11	4350.57	4348.82	4349.11	646.0
2014-05-29 22:00:00	NQ	Futures	4348.82	4349.11	4344.45	4345.04	1057.0
2014-05-29 23:00:00	NQ	Futures	4345.04	4347.95	4345.04	4347.07	253.0
2014-05-29 00:00:00	YM	Futures	17143.0	17148.2	17143.0	17146.1	399.0
2014-05-29 01:00:00	YM	Futures	17147.2	17149.2	17144.1	17148.2	396.0

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

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