PREVIEW / futures_1hour / 2016-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-19.parquet
  size:    53 KB
  rows:    1,614

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-05-19 00:00:00	ES	Futures	2200.61	2200.61	2198.18	2199.26	3403.0
2016-05-19 01:00:00	ES	Futures	2199.26	2200.61	2198.45	2200.34	3676.0
2016-05-19 02:00:00	ES	Futures	2200.07	2201.96	2199.26	2200.88	10212.0
2016-05-19 03:00:00	ES	Futures	2200.88	2201.69	2195.21	2198.99	37841.0
2016-05-19 04:00:00	ES	Futures	2198.99	2202.5	2195.21	2196.29	26846.0
2016-05-19 05:00:00	ES	Futures	2196.29	2198.18	2195.48	2197.1	13118.0
2016-05-19 06:00:00	ES	Futures	2196.83	2200.07	2196.29	2197.37	15203.0
2016-05-19 07:00:00	ES	Futures	2197.37	2204.12	2197.37	2201.42	32525.0
2016-05-19 08:00:00	ES	Futures	2201.69	2202.5	2198.18	2198.99	34602.0
2016-05-19 09:00:00	ES	Futures	2198.72	2202.77	2187.11	2187.11	323149.0
2016-05-19 10:00:00	ES	Futures	2187.38	2193.86	2185.49	2186.57	393193.0
2016-05-19 11:00:00	ES	Futures	2186.84	2190.08	2183.6	2189.0	280896.0
2016-05-19 12:00:00	ES	Futures	2188.73	2193.05	2186.3	2186.84	176409.0
2016-05-19 13:00:00	ES	Futures	2186.57	2196.56	2186.3	2193.32	167567.0
2016-05-19 14:00:00	ES	Futures	2193.05	2198.99	2191.97	2192.51	163509.0
2016-05-19 15:00:00	ES	Futures	2192.78	2201.42	2192.51	2199.26	257020.0
2016-05-19 16:00:00	ES	Futures	2199.53	2201.96	2198.45	2201.96	67898.0
2016-05-19 18:00:00	ES	Futures	2201.69	2202.5	2201.15	2201.96	3982.0
2016-05-19 19:00:00	ES	Futures	2201.96	2202.77	2200.07	2201.15	5456.0
2016-05-19 20:00:00	ES	Futures	2201.15	2207.9	2200.88	2207.63	15147.0
2016-05-19 21:00:00	ES	Futures	2207.63	2207.9	2204.93	2207.63	9440.0
2016-05-19 22:00:00	ES	Futures	2207.63	2208.98	2206.82	2207.9	7293.0
2016-05-19 23:00:00	ES	Futures	2207.63	2207.9	2206.82	2207.09	2116.0
2016-05-19 00:00:00	NQ	Futures	5146.07	5146.67	5141.61	5143.99	408.0
2016-05-19 01:00:00	NQ	Futures	5143.99	5148.45	5142.5	5147.56	525.0
2016-05-19 02:00:00	NQ	Futures	5147.26	5152.32	5144.59	5149.05	1098.0
2016-05-19 03:00:00	NQ	Futures	5149.64	5150.83	5132.98	5146.07	4938.0
2016-05-19 04:00:00	NQ	Futures	5145.18	5155.0	5133.28	5136.55	3308.0
2016-05-19 05:00:00	NQ	Futures	5136.55	5140.72	5132.98	5137.15	1625.0
2016-05-19 06:00:00	NQ	Futures	5136.85	5144.88	5135.07	5138.64	1924.0
2016-05-19 07:00:00	NQ	Futures	5138.64	5154.11	5138.34	5148.16	3436.0
2016-05-19 08:00:00	NQ	Futures	5148.16	5150.83	5138.04	5139.23	5303.0
2016-05-19 09:00:00	NQ	Futures	5139.23	5152.62	5114.54	5114.83	43604.0
2016-05-19 10:00:00	NQ	Futures	5114.54	5121.68	5104.72	5107.99	53152.0
2016-05-19 11:00:00	NQ	Futures	5107.69	5113.94	5094.6	5105.91	33905.0
2016-05-19 12:00:00	NQ	Futures	5105.91	5116.92	5097.87	5101.15	19221.0
2016-05-19 13:00:00	NQ	Futures	5100.85	5126.44	5100.25	5113.94	22348.0
2016-05-19 14:00:00	NQ	Futures	5114.24	5126.44	5107.69	5109.48	19431.0
2016-05-19 15:00:00	NQ	Futures	5109.48	5140.12	5108.88	5133.88	38602.0
2016-05-19 16:00:00	NQ	Futures	5133.88	5138.93	5131.79	5138.93	6352.0
2016-05-19 18:00:00	NQ	Futures	5137.74	5140.42	5135.66	5137.45	631.0
2016-05-19 19:00:00	NQ	Futures	5137.74	5140.12	5134.77	5136.85	795.0
2016-05-19 20:00:00	NQ	Futures	5136.55	5155.59	5135.07	5155.0	1863.0
2016-05-19 21:00:00	NQ	Futures	5154.7	5156.78	5150.24	5154.7	1955.0
2016-05-19 22:00:00	NQ	Futures	5155.0	5160.06	5153.51	5157.97	1800.0
2016-05-19 23:00:00	NQ	Futures	5157.68	5158.27	5155.89	5155.89	361.0
2016-05-19 00:00:00	YM	Futures	18675.1	18677.2	18662.2	18669.7	684.0
2016-05-19 01:00:00	YM	Futures	18668.7	18677.2	18663.3	18676.2	603.0
2016-05-19 02:00:00	YM	Futures	18674.0	18692.2	18665.5	18679.4	1652.0
2016-05-19 03:00:00	YM	Futures	18680.4	18686.9	18631.2	18659.0	5783.0

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

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