PREVIEW / futures_1hour / 2014-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-03.parquet
  size:    49 KB
  rows:    1,560

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-03 00:00:00	ES	Futures	2086.74	2087.0	2085.95	2086.48	2108.0
2014-09-03 01:00:00	ES	Futures	2086.74	2087.52	2086.21	2087.26	2395.0
2014-09-03 02:00:00	ES	Futures	2087.26	2089.34	2087.0	2088.3	13171.0
2014-09-03 03:00:00	ES	Futures	2088.3	2089.86	2087.52	2089.86	18767.0
2014-09-03 04:00:00	ES	Futures	2089.86	2096.38	2088.82	2090.91	91554.0
2014-09-03 05:00:00	ES	Futures	2090.91	2093.51	2090.38	2091.43	34649.0
2014-09-03 06:00:00	ES	Futures	2091.43	2093.77	2091.17	2093.51	17869.0
2014-09-03 07:00:00	ES	Futures	2093.25	2094.03	2090.12	2090.91	35235.0
2014-09-03 08:00:00	ES	Futures	2090.91	2092.73	2090.65	2092.21	29176.0
2014-09-03 09:00:00	ES	Futures	2092.47	2094.29	2090.12	2090.65	186044.0
2014-09-03 10:00:00	ES	Futures	2090.65	2091.95	2087.78	2089.6	179278.0
2014-09-03 11:00:00	ES	Futures	2089.6	2090.38	2082.57	2082.83	182104.0
2014-09-03 12:00:00	ES	Futures	2082.83	2087.78	2082.05	2087.0	97703.0
2014-09-03 13:00:00	ES	Futures	2086.74	2088.04	2084.65	2086.74	62535.0
2014-09-03 14:00:00	ES	Futures	2086.74	2087.0	2082.31	2082.57	85220.0
2014-09-03 15:00:00	ES	Futures	2082.31	2084.65	2081.0	2084.39	149232.0
2014-09-03 16:00:00	ES	Futures	2084.39	2085.17	2083.35	2083.87	69333.0
2014-09-03 17:00:00	ES	Futures	2083.87	2084.13	2083.61	2083.87	2241.0
2014-09-03 18:00:00	ES	Futures	2083.61	2084.39	2083.61	2084.13	2584.0
2014-09-03 19:00:00	ES	Futures	2084.13	2084.39	2083.09	2083.35	3123.0
2014-09-03 20:00:00	ES	Futures	2083.09	2084.13	2083.09	2083.61	3576.0
2014-09-03 21:00:00	ES	Futures	2083.35	2084.13	2083.35	2083.87	2516.0
2014-09-03 22:00:00	ES	Futures	2084.13	2084.13	2083.61	2083.61	1179.0
2014-09-03 23:00:00	ES	Futures	2083.61	2083.87	2083.09	2083.35	2092.0
2014-09-03 00:00:00	NQ	Futures	4783.49	4784.08	4782.03	4782.91	255.0
2014-09-03 01:00:00	NQ	Futures	4783.2	4786.12	4782.32	4785.83	668.0
2014-09-03 02:00:00	NQ	Futures	4785.54	4789.92	4785.24	4786.7	1788.0
2014-09-03 03:00:00	NQ	Futures	4786.7	4790.5	4785.83	4790.5	2684.0
2014-09-03 04:00:00	NQ	Futures	4790.5	4805.1	4790.21	4795.47	12911.0
2014-09-03 05:00:00	NQ	Futures	4795.47	4801.6	4794.01	4796.34	5197.0
2014-09-03 06:00:00	NQ	Futures	4796.34	4800.43	4795.17	4798.97	2733.0
2014-09-03 07:00:00	NQ	Futures	4799.26	4800.43	4791.96	4793.42	4727.0
2014-09-03 08:00:00	NQ	Futures	4793.42	4796.63	4792.84	4795.47	4611.0
2014-09-03 09:00:00	NQ	Futures	4795.47	4798.68	4776.78	4780.28	48108.0
2014-09-03 10:00:00	NQ	Futures	4779.99	4784.95	4770.64	4773.86	40844.0
2014-09-03 11:00:00	NQ	Futures	4773.86	4775.61	4748.74	4750.49	45767.0
2014-09-03 12:00:00	NQ	Futures	4750.79	4765.1	4747.28	4762.76	23456.0
2014-09-03 13:00:00	NQ	Futures	4763.05	4767.14	4757.5	4762.76	17277.0
2014-09-03 14:00:00	NQ	Futures	4763.05	4764.8	4749.62	4749.91	15768.0
2014-09-03 15:00:00	NQ	Futures	4749.91	4756.04	4745.24	4754.29	28474.0
2014-09-03 16:00:00	NQ	Futures	4754.58	4758.67	4754.0	4755.75	6315.0
2014-09-03 17:00:00	NQ	Futures	4755.75	4756.92	4755.17	4755.46	329.0
2014-09-03 18:00:00	NQ	Futures	4756.04	4758.09	4756.04	4758.09	419.0
2014-09-03 19:00:00	NQ	Futures	4757.21	4757.5	4754.58	4754.58	473.0
2014-09-03 20:00:00	NQ	Futures	4754.88	4758.09	4754.58	4756.63	545.0
2014-09-03 21:00:00	NQ	Futures	4756.34	4758.67	4756.04	4758.67	662.0
2014-09-03 22:00:00	NQ	Futures	4758.67	4758.67	4756.04	4756.04	373.0
2014-09-03 23:00:00	NQ	Futures	4756.04	4756.92	4755.46	4756.63	222.0
2014-09-03 00:00:00	YM	Futures	17658.0	17659.0	17642.5	17651.8	1373.0
2014-09-03 01:00:00	YM	Futures	17650.7	17658.0	17648.7	17656.9	646.0

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

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