PREVIEW / futures_1hour / 2014-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-17.parquet
  size:    51 KB
  rows:    1,577

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-09-17 00:00:00	ES	Futures	2086.05	2086.05	2085.26	2085.26	792.0
2014-09-17 01:00:00	ES	Futures	2085.26	2085.78	2085.26	2085.78	2022.0
2014-09-17 02:00:00	ES	Futures	2085.78	2086.05	2084.47	2085.0	7281.0
2014-09-17 03:00:00	ES	Futures	2084.74	2087.09	2084.47	2086.83	20198.0
2014-09-17 04:00:00	ES	Futures	2086.57	2087.62	2085.52	2087.09	15052.0
2014-09-17 05:00:00	ES	Futures	2087.09	2087.62	2086.05	2087.36	9787.0
2014-09-17 06:00:00	ES	Futures	2087.09	2087.88	2086.31	2087.09	8628.0
2014-09-17 07:00:00	ES	Futures	2086.83	2087.62	2085.78	2087.09	14911.0
2014-09-17 08:00:00	ES	Futures	2086.83	2088.93	2084.47	2087.36	43288.0
2014-09-17 09:00:00	ES	Futures	2087.36	2091.81	2086.83	2090.76	154304.0
2014-09-17 10:00:00	ES	Futures	2091.02	2092.33	2086.83	2088.14	175481.0
2014-09-17 11:00:00	ES	Futures	2087.88	2089.45	2086.05	2087.09	107787.0
2014-09-17 12:00:00	ES	Futures	2087.09	2088.4	2084.47	2085.52	71298.0
2014-09-17 13:00:00	ES	Futures	2085.52	2089.19	2083.69	2088.4	82530.0
2014-09-17 14:00:00	ES	Futures	2087.88	2096.0	2078.19	2093.91	460535.0
2014-09-17 15:00:00	ES	Futures	2093.91	2099.14	2086.83	2088.93	380759.0
2014-09-17 16:00:00	ES	Futures	2089.19	2090.24	2088.67	2089.98	70273.0
2014-09-17 17:00:00	ES	Futures	2089.98	2091.55	2089.98	2091.02	2974.0
2014-09-17 18:00:00	ES	Futures	2091.02	2091.02	2089.19	2089.45	6951.0
2014-09-17 19:00:00	ES	Futures	2089.71	2089.71	2088.93	2089.45	3814.0
2014-09-17 20:00:00	ES	Futures	2089.45	2089.71	2088.4	2089.19	5892.0
2014-09-17 21:00:00	ES	Futures	2088.93	2090.24	2088.67	2088.93	4713.0
2014-09-17 22:00:00	ES	Futures	2088.93	2089.71	2088.67	2089.71	3120.0
2014-09-17 23:00:00	ES	Futures	2089.45	2090.5	2089.19	2089.98	2780.0
2014-09-17 00:00:00	NQ	Futures	4753.43	4753.43	4751.38	4751.97	160.0
2014-09-17 01:00:00	NQ	Futures	4751.97	4753.72	4751.97	4753.14	223.0
2014-09-17 02:00:00	NQ	Futures	4753.14	4753.43	4749.33	4750.21	1698.0
2014-09-17 03:00:00	NQ	Futures	4750.5	4754.9	4749.62	4752.85	3246.0
2014-09-17 04:00:00	NQ	Futures	4752.55	4755.78	4750.79	4754.6	2901.0
2014-09-17 05:00:00	NQ	Futures	4754.9	4755.78	4752.55	4754.02	1391.0
2014-09-17 06:00:00	NQ	Futures	4754.02	4755.78	4751.09	4753.14	1449.0
2014-09-17 07:00:00	NQ	Futures	4753.14	4753.72	4749.62	4753.43	2645.0
2014-09-17 08:00:00	NQ	Futures	4753.14	4759.88	4747.28	4756.07	8713.0
2014-09-17 09:00:00	NQ	Futures	4755.78	4767.2	4753.72	4760.76	32977.0
2014-09-17 10:00:00	NQ	Futures	4760.76	4764.57	4749.92	4753.72	31439.0
2014-09-17 11:00:00	NQ	Futures	4753.43	4759.0	4752.55	4756.95	14749.0
2014-09-17 12:00:00	NQ	Futures	4756.95	4758.71	4748.74	4750.21	12597.0
2014-09-17 13:00:00	NQ	Futures	4750.5	4760.17	4747.86	4758.12	10779.0
2014-09-17 14:00:00	NQ	Futures	4758.41	4778.63	4734.09	4776.87	94054.0
2014-09-17 15:00:00	NQ	Futures	4776.87	4786.54	4759.29	4764.86	50017.0
2014-09-17 16:00:00	NQ	Futures	4764.57	4767.5	4763.1	4766.91	5675.0
2014-09-17 17:00:00	NQ	Futures	4766.91	4771.89	4766.91	4770.43	927.0
2014-09-17 18:00:00	NQ	Futures	4771.31	4771.31	4765.15	4766.03	690.0
2014-09-17 19:00:00	NQ	Futures	4766.03	4766.91	4765.15	4766.03	263.0
2014-09-17 20:00:00	NQ	Futures	4766.03	4766.91	4763.39	4764.86	769.0
2014-09-17 21:00:00	NQ	Futures	4765.15	4766.62	4762.81	4763.98	864.0
2014-09-17 22:00:00	NQ	Futures	4763.98	4765.15	4762.81	4763.98	764.0
2014-09-17 23:00:00	NQ	Futures	4763.69	4766.03	4762.51	4764.86	727.0
2014-09-17 00:00:00	YM	Futures	17725.9	17725.9	17719.6	17720.7	219.0
2014-09-17 01:00:00	YM	Futures	17721.7	17723.8	17719.6	17720.7	915.0

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

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