PREVIEW / futures_1hour / 2014-12-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-30.parquet
  size:    49 KB
  rows:    1,513

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-12-30 00:00:00	ES	Futures	2197.84	2198.11	2196.0	2196.0	2621.0
2014-12-30 01:00:00	ES	Futures	2196.0	2196.0	2193.11	2193.9	4164.0
2014-12-30 02:00:00	ES	Futures	2193.9	2194.16	2189.95	2190.21	7700.0
2014-12-30 03:00:00	ES	Futures	2190.48	2191.53	2188.9	2189.42	12408.0
2014-12-30 04:00:00	ES	Futures	2189.42	2190.48	2188.11	2189.95	8591.0
2014-12-30 05:00:00	ES	Futures	2189.95	2191.53	2189.95	2190.21	6609.0
2014-12-30 06:00:00	ES	Futures	2190.21	2190.74	2189.42	2189.42	4479.0
2014-12-30 07:00:00	ES	Futures	2189.42	2192.58	2188.63	2189.95	10479.0
2014-12-30 08:00:00	ES	Futures	2189.69	2190.74	2186.53	2188.63	19504.0
2014-12-30 09:00:00	ES	Futures	2188.63	2191.27	2186.79	2188.9	105011.0
2014-12-30 10:00:00	ES	Futures	2188.9	2189.95	2184.95	2189.42	108247.0
2014-12-30 11:00:00	ES	Futures	2189.16	2189.95	2186.0	2188.11	89284.0
2014-12-30 12:00:00	ES	Futures	2188.11	2189.16	2185.21	2186.53	50170.0
2014-12-30 13:00:00	ES	Futures	2186.53	2188.11	2182.06	2183.11	68186.0
2014-12-30 14:00:00	ES	Futures	2183.37	2186.53	2182.58	2184.95	56588.0
2014-12-30 15:00:00	ES	Futures	2184.95	2187.32	2182.84	2183.11	99486.0
2014-12-30 16:00:00	ES	Futures	2182.84	2186.53	2182.06	2186.0	52728.0
2014-12-30 17:00:00	ES	Futures	2186.27	2186.27	2185.21	2185.21	1167.0
2014-12-30 18:00:00	ES	Futures	2185.48	2187.84	2185.48	2187.84	3200.0
2014-12-30 19:00:00	ES	Futures	2187.84	2187.84	2186.53	2186.53	994.0
2014-12-30 20:00:00	ES	Futures	2186.27	2186.53	2185.74	2186.27	1648.0
2014-12-30 21:00:00	ES	Futures	2186.27	2187.06	2186.27	2187.06	1004.0
2014-12-30 22:00:00	ES	Futures	2187.06	2188.37	2186.79	2188.37	1459.0
2014-12-30 23:00:00	ES	Futures	2188.11	2190.21	2188.11	2190.21	1848.0
2014-12-30 00:00:00	NQ	Futures	5071.7	5072.0	5066.12	5066.12	381.0
2014-12-30 01:00:00	NQ	Futures	5066.12	5066.71	5059.37	5062.01	797.0
2014-12-30 02:00:00	NQ	Futures	5062.01	5062.89	5052.62	5057.61	1613.0
2014-12-30 03:00:00	NQ	Futures	5057.9	5059.37	5053.79	5055.55	1888.0
2014-12-30 04:00:00	NQ	Futures	5055.55	5059.37	5053.2	5059.37	1084.0
2014-12-30 05:00:00	NQ	Futures	5058.78	5062.31	5057.31	5057.61	907.0
2014-12-30 06:00:00	NQ	Futures	5057.61	5059.37	5054.96	5054.96	832.0
2014-12-30 07:00:00	NQ	Futures	5055.26	5062.31	5054.67	5056.73	1602.0
2014-12-30 08:00:00	NQ	Futures	5056.43	5058.2	5047.33	5051.73	3318.0
2014-12-30 09:00:00	NQ	Futures	5051.44	5058.78	5041.46	5045.86	21529.0
2014-12-30 10:00:00	NQ	Futures	5046.45	5047.33	5036.76	5044.98	17401.0
2014-12-30 11:00:00	NQ	Futures	5044.98	5046.15	5038.22	5042.92	9324.0
2014-12-30 12:00:00	NQ	Futures	5042.34	5045.27	5030.59	5034.41	9533.0
2014-12-30 13:00:00	NQ	Futures	5034.11	5036.46	5022.37	5023.83	8346.0
2014-12-30 14:00:00	NQ	Futures	5023.83	5033.82	5020.6	5030.59	10163.0
2014-12-30 15:00:00	NQ	Futures	5030.59	5034.7	5026.77	5027.65	14374.0
2014-12-30 16:00:00	NQ	Futures	5027.36	5033.23	5027.06	5031.47	5803.0
2014-12-30 17:00:00	NQ	Futures	5031.47	5031.76	5029.71	5030.0	88.0
2014-12-30 18:00:00	NQ	Futures	5031.47	5037.64	5031.18	5037.05	329.0
2014-12-30 19:00:00	NQ	Futures	5036.46	5037.34	5033.82	5033.82	132.0
2014-12-30 20:00:00	NQ	Futures	5033.82	5034.11	5031.76	5032.35	249.0
2014-12-30 21:00:00	NQ	Futures	5032.35	5034.41	5031.76	5034.11	231.0
2014-12-30 22:00:00	NQ	Futures	5034.11	5037.05	5033.82	5037.05	203.0
2014-12-30 23:00:00	NQ	Futures	5036.76	5039.11	5035.58	5039.11	324.0
2014-12-30 00:00:00	YM	Futures	18789.8	18790.8	18773.1	18773.1	289.0
2014-12-30 01:00:00	YM	Futures	18773.1	18775.2	18751.2	18759.5	775.0

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

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