PREVIEW / futures_1hour / 2014-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-04.parquet
  size:    52 KB
  rows:    1,553

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-04 00:00:00	ES	Futures	2083.61	2083.61	2083.35	2083.35	638.0
2014-09-04 01:00:00	ES	Futures	2083.61	2083.61	2083.09	2083.35	1275.0
2014-09-04 02:00:00	ES	Futures	2083.35	2083.87	2083.09	2083.61	5665.0
2014-09-04 03:00:00	ES	Futures	2083.87	2084.65	2083.09	2084.13	14384.0
2014-09-04 04:00:00	ES	Futures	2084.13	2084.65	2081.78	2082.31	17900.0
2014-09-04 05:00:00	ES	Futures	2082.57	2086.21	2082.05	2085.69	16979.0
2014-09-04 06:00:00	ES	Futures	2085.95	2089.6	2085.43	2088.82	26619.0
2014-09-04 07:00:00	ES	Futures	2088.82	2092.73	2088.3	2088.82	64473.0
2014-09-04 08:00:00	ES	Futures	2089.08	2092.99	2087.26	2088.3	86592.0
2014-09-04 09:00:00	ES	Futures	2088.56	2093.51	2085.95	2092.47	205051.0
2014-09-04 10:00:00	ES	Futures	2092.47	2095.34	2091.17	2093.77	219989.0
2014-09-04 11:00:00	ES	Futures	2093.77	2095.34	2089.34	2090.38	147639.0
2014-09-04 12:00:00	ES	Futures	2090.38	2091.69	2088.04	2089.08	85505.0
2014-09-04 13:00:00	ES	Futures	2089.08	2090.12	2087.26	2087.78	58773.0
2014-09-04 14:00:00	ES	Futures	2087.78	2089.34	2079.96	2081.0	159274.0
2014-09-04 15:00:00	ES	Futures	2080.74	2081.52	2075.27	2081.26	286422.0
2014-09-04 16:00:00	ES	Futures	2081.0	2085.43	2080.74	2084.39	70609.0
2014-09-04 17:00:00	ES	Futures	2084.65	2084.65	2084.13	2084.13	1712.0
2014-09-04 18:00:00	ES	Futures	2083.87	2084.39	2083.09	2084.13	4069.0
2014-09-04 19:00:00	ES	Futures	2083.87	2084.39	2083.09	2083.61	2974.0
2014-09-04 20:00:00	ES	Futures	2083.61	2083.61	2081.0	2081.52	7582.0
2014-09-04 21:00:00	ES	Futures	2081.52	2081.78	2080.22	2080.48	4304.0
2014-09-04 22:00:00	ES	Futures	2080.48	2080.74	2078.92	2079.44	6039.0
2014-09-04 23:00:00	ES	Futures	2079.44	2080.74	2079.18	2079.96	3758.0
2014-09-04 00:00:00	NQ	Futures	4756.63	4756.92	4755.46	4755.75	221.0
2014-09-04 01:00:00	NQ	Futures	4755.75	4756.04	4754.88	4755.75	172.0
2014-09-04 02:00:00	NQ	Futures	4756.34	4758.09	4755.46	4758.09	645.0
2014-09-04 03:00:00	NQ	Futures	4758.09	4760.13	4756.92	4758.96	2005.0
2014-09-04 04:00:00	NQ	Futures	4759.26	4760.72	4741.15	4744.36	8934.0
2014-09-04 05:00:00	NQ	Futures	4744.65	4756.34	4744.36	4754.88	3268.0
2014-09-04 06:00:00	NQ	Futures	4754.88	4766.56	4753.42	4764.51	4587.0
2014-09-04 07:00:00	NQ	Futures	4764.51	4770.94	4761.59	4764.22	8835.0
2014-09-04 08:00:00	NQ	Futures	4764.51	4773.86	4762.76	4766.85	13801.0
2014-09-04 09:00:00	NQ	Futures	4766.85	4786.7	4759.55	4783.49	43641.0
2014-09-04 10:00:00	NQ	Futures	4783.78	4790.21	4779.99	4785.24	34669.0
2014-09-04 11:00:00	NQ	Futures	4785.24	4788.75	4773.56	4775.61	30607.0
2014-09-04 12:00:00	NQ	Futures	4775.32	4779.11	4768.31	4771.23	17489.0
2014-09-04 13:00:00	NQ	Futures	4771.23	4776.78	4769.48	4771.81	13128.0
2014-09-04 14:00:00	NQ	Futures	4772.1	4777.07	4751.95	4754.58	29529.0
2014-09-04 15:00:00	NQ	Futures	4754.58	4755.75	4737.94	4749.91	48889.0
2014-09-04 16:00:00	NQ	Futures	4749.91	4758.67	4749.33	4756.92	7400.0
2014-09-04 17:00:00	NQ	Futures	4756.92	4757.21	4755.46	4755.46	397.0
2014-09-04 18:00:00	NQ	Futures	4756.63	4756.63	4753.71	4754.88	458.0
2014-09-04 19:00:00	NQ	Futures	4755.46	4756.63	4754.0	4754.29	281.0
2014-09-04 20:00:00	NQ	Futures	4754.58	4754.58	4749.03	4749.62	1359.0
2014-09-04 21:00:00	NQ	Futures	4749.33	4750.2	4746.7	4748.16	719.0
2014-09-04 22:00:00	NQ	Futures	4748.16	4748.74	4745.53	4747.28	1918.0
2014-09-04 23:00:00	NQ	Futures	4746.99	4748.74	4746.11	4747.57	561.0
2014-09-04 00:00:00	YM	Futures	17660.1	17661.1	17655.9	17655.9	146.0
2014-09-04 01:00:00	YM	Futures	17656.9	17656.9	17651.8	17652.8	316.0

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

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