PREVIEW / futures_1hour / 2016-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-28.parquet
  size:    55 KB
  rows:    1,642

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
2016-04-28 00:00:00	ES	Futures	2247.31	2249.74	2244.88	2247.04	11645.0
2016-04-28 01:00:00	ES	Futures	2247.31	2248.12	2243.53	2245.42	11634.0
2016-04-28 02:00:00	ES	Futures	2245.42	2246.5	2242.45	2242.72	21043.0
2016-04-28 03:00:00	ES	Futures	2242.72	2247.58	2240.02	2242.72	43305.0
2016-04-28 04:00:00	ES	Futures	2242.45	2242.99	2235.7	2237.32	42573.0
2016-04-28 05:00:00	ES	Futures	2237.32	2241.1	2237.05	2240.29	19270.0
2016-04-28 06:00:00	ES	Futures	2240.29	2242.72	2239.48	2239.75	16919.0
2016-04-28 07:00:00	ES	Futures	2240.02	2244.07	2239.21	2241.1	27984.0
2016-04-28 08:00:00	ES	Futures	2241.37	2244.88	2241.1	2244.07	35082.0
2016-04-28 09:00:00	ES	Futures	2244.07	2253.25	2243.26	2252.98	200875.0
2016-04-28 10:00:00	ES	Futures	2252.71	2257.57	2251.36	2257.03	237237.0
2016-04-28 11:00:00	ES	Futures	2257.03	2260.81	2256.22	2258.38	146367.0
2016-04-28 12:00:00	ES	Futures	2258.38	2260.27	2255.95	2259.19	95985.0
2016-04-28 13:00:00	ES	Futures	2259.46	2259.73	2252.98	2254.87	111600.0
2016-04-28 14:00:00	ES	Futures	2255.14	2256.22	2247.04	2248.39	127791.0
2016-04-28 15:00:00	ES	Futures	2248.39	2248.39	2230.3	2235.97	536642.0
2016-04-28 16:00:00	ES	Futures	2236.24	2240.56	2234.89	2240.02	150810.0
2016-04-28 18:00:00	ES	Futures	2239.48	2240.29	2237.32	2238.67	7269.0
2016-04-28 19:00:00	ES	Futures	2238.67	2240.29	2238.4	2239.75	3544.0
2016-04-28 20:00:00	ES	Futures	2239.75	2241.91	2237.32	2237.32	9433.0
2016-04-28 21:00:00	ES	Futures	2237.59	2238.94	2233.54	2234.62	15093.0
2016-04-28 22:00:00	ES	Futures	2234.62	2238.67	2234.62	2238.4	5102.0
2016-04-28 23:00:00	ES	Futures	2238.4	2238.4	2237.05	2237.86	2364.0
2016-04-28 00:00:00	NQ	Futures	5257.35	5263.6	5251.4	5254.67	1490.0
2016-04-28 01:00:00	NQ	Futures	5254.97	5257.94	5245.45	5250.51	1127.0
2016-04-28 02:00:00	NQ	Futures	5249.91	5254.37	5243.37	5244.56	2288.0
2016-04-28 03:00:00	NQ	Futures	5243.96	5253.18	5234.74	5240.99	6379.0
2016-04-28 04:00:00	NQ	Futures	5240.99	5243.07	5227.3	5232.06	5143.0
2016-04-28 05:00:00	NQ	Futures	5231.46	5240.39	5230.87	5237.71	2444.0
2016-04-28 06:00:00	NQ	Futures	5238.01	5245.15	5234.74	5235.33	2458.0
2016-04-28 07:00:00	NQ	Futures	5235.63	5245.15	5235.33	5244.26	3068.0
2016-04-28 08:00:00	NQ	Futures	5244.85	5251.4	5240.99	5250.8	4614.0
2016-04-28 09:00:00	NQ	Futures	5250.8	5269.25	5246.04	5266.57	38736.0
2016-04-28 10:00:00	NQ	Futures	5266.28	5280.85	5257.65	5280.26	36401.0
2016-04-28 11:00:00	NQ	Futures	5280.26	5284.43	5276.09	5277.88	19768.0
2016-04-28 12:00:00	NQ	Futures	5278.18	5280.85	5257.65	5262.71	17365.0
2016-04-28 13:00:00	NQ	Futures	5262.41	5263.6	5245.45	5247.23	19005.0
2016-04-28 14:00:00	NQ	Futures	5247.23	5252.59	5220.46	5226.41	29794.0
2016-04-28 15:00:00	NQ	Futures	5226.41	5226.7	5172.55	5183.86	79737.0
2016-04-28 16:00:00	NQ	Futures	5183.86	5219.56	5182.37	5218.67	22125.0
2016-04-28 18:00:00	NQ	Futures	5216.89	5222.84	5214.51	5217.78	1714.0
2016-04-28 19:00:00	NQ	Futures	5218.08	5223.13	5217.18	5219.86	595.0
2016-04-28 20:00:00	NQ	Futures	5220.16	5226.11	5213.61	5213.61	1307.0
2016-04-28 21:00:00	NQ	Futures	5213.61	5218.37	5205.58	5208.85	2150.0
2016-04-28 22:00:00	NQ	Futures	5208.26	5219.27	5208.26	5218.67	759.0
2016-04-28 23:00:00	NQ	Futures	5218.67	5219.27	5215.4	5218.97	463.0
2016-04-28 00:00:00	YM	Futures	19123.6	19140.7	19104.3	19119.3	2111.0
2016-04-28 01:00:00	YM	Futures	19120.4	19126.8	19099.0	19106.5	2315.0
2016-04-28 02:00:00	YM	Futures	19105.4	19124.7	19093.6	19104.3	3657.0
2016-04-28 03:00:00	YM	Futures	19102.2	19137.5	19078.6	19093.6	6405.0

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

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