PREVIEW / futures_1hour / 2015-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-31.parquet
  size:    52 KB
  rows:    1,587

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
2015-03-31 00:00:00	ES	Futures	2189.54	2190.06	2188.22	2189.01	2060.0
2015-03-31 01:00:00	ES	Futures	2189.01	2189.54	2187.95	2188.48	4355.0
2015-03-31 02:00:00	ES	Futures	2188.48	2189.27	2185.57	2187.69	10676.0
2015-03-31 03:00:00	ES	Futures	2187.95	2191.12	2186.9	2190.59	18498.0
2015-03-31 04:00:00	ES	Futures	2190.33	2190.86	2188.48	2188.74	12028.0
2015-03-31 05:00:00	ES	Futures	2189.01	2189.01	2181.88	2182.41	25879.0
2015-03-31 06:00:00	ES	Futures	2182.41	2182.41	2180.03	2180.29	20808.0
2015-03-31 07:00:00	ES	Futures	2180.29	2182.93	2178.71	2181.88	30391.0
2015-03-31 08:00:00	ES	Futures	2181.88	2183.99	2179.76	2182.93	34932.0
2015-03-31 09:00:00	ES	Futures	2182.93	2187.95	2181.08	2185.31	200618.0
2015-03-31 10:00:00	ES	Futures	2185.31	2190.86	2184.78	2187.42	167069.0
2015-03-31 11:00:00	ES	Futures	2187.69	2193.5	2185.57	2185.57	154896.0
2015-03-31 12:00:00	ES	Futures	2185.84	2187.95	2182.93	2186.37	84336.0
2015-03-31 13:00:00	ES	Futures	2186.37	2191.12	2185.84	2186.9	73189.0
2015-03-31 14:00:00	ES	Futures	2186.9	2188.74	2184.52	2187.95	88879.0
2015-03-31 15:00:00	ES	Futures	2187.95	2187.95	2174.75	2176.07	467676.0
2015-03-31 16:00:00	ES	Futures	2176.07	2176.33	2172.37	2174.75	170819.0
2015-03-31 17:00:00	ES	Futures	2174.75	2175.01	2173.95	2173.95	3365.0
2015-03-31 18:00:00	ES	Futures	2174.22	2175.27	2172.63	2174.48	7120.0
2015-03-31 19:00:00	ES	Futures	2174.48	2176.86	2174.22	2175.01	4392.0
2015-03-31 20:00:00	ES	Futures	2175.27	2175.54	2148.33	2154.67	35732.0
2015-03-31 21:00:00	ES	Futures	2154.67	2164.18	2151.5	2159.16	27598.0
2015-03-31 22:00:00	ES	Futures	2159.16	2163.39	2158.37	2159.69	7184.0
2015-03-31 23:00:00	ES	Futures	2159.96	2160.48	2157.31	2158.63	6395.0
2015-03-31 00:00:00	NQ	Futures	5139.64	5141.11	5137.58	5139.05	372.0
2015-03-31 01:00:00	NQ	Futures	5138.76	5141.11	5137.58	5139.64	606.0
2015-03-31 02:00:00	NQ	Futures	5139.05	5139.64	5131.11	5135.53	1314.0
2015-03-31 03:00:00	NQ	Futures	5135.82	5144.05	5133.47	5141.99	2286.0
2015-03-31 04:00:00	NQ	Futures	5141.99	5143.76	5135.53	5137.58	1651.0
2015-03-31 05:00:00	NQ	Futures	5137.29	5137.29	5119.65	5120.23	4269.0
2015-03-31 06:00:00	NQ	Futures	5120.53	5121.7	5113.47	5118.76	4150.0
2015-03-31 07:00:00	NQ	Futures	5118.47	5122.59	5113.76	5120.82	4632.0
2015-03-31 08:00:00	NQ	Futures	5120.53	5128.47	5115.82	5126.7	5608.0
2015-03-31 09:00:00	NQ	Futures	5126.7	5133.76	5110.53	5122.0	37497.0
2015-03-31 10:00:00	NQ	Futures	5121.7	5134.35	5119.35	5126.12	31453.0
2015-03-31 11:00:00	NQ	Futures	5126.12	5141.11	5121.41	5121.7	25066.0
2015-03-31 12:00:00	NQ	Futures	5121.7	5126.7	5114.06	5125.82	14152.0
2015-03-31 13:00:00	NQ	Futures	5126.12	5133.76	5119.65	5121.12	11461.0
2015-03-31 14:00:00	NQ	Futures	5121.12	5128.17	5117.59	5126.41	13728.0
2015-03-31 15:00:00	NQ	Futures	5126.12	5126.12	5088.77	5090.83	49869.0
2015-03-31 16:00:00	NQ	Futures	5091.12	5092.0	5082.3	5085.24	13471.0
2015-03-31 17:00:00	NQ	Futures	5085.24	5085.24	5082.59	5084.06	156.0
2015-03-31 18:00:00	NQ	Futures	5083.48	5088.48	5082.59	5086.42	816.0
2015-03-31 19:00:00	NQ	Futures	5086.42	5091.42	5086.42	5088.18	385.0
2015-03-31 20:00:00	NQ	Futures	5087.59	5088.18	5009.67	5027.31	5784.0
2015-03-31 21:00:00	NQ	Futures	5027.6	5052.01	5022.02	5041.43	4600.0
2015-03-31 22:00:00	NQ	Futures	5040.54	5053.78	5040.25	5044.37	1888.0
2015-03-31 23:00:00	NQ	Futures	5044.95	5048.19	5038.48	5043.78	1023.0
2015-03-31 00:00:00	YM	Futures	18717.6	18720.8	18706.1	18712.4	751.0
2015-03-31 01:00:00	YM	Futures	18713.5	18716.6	18705.1	18707.2	1068.0

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

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