PREVIEW / futures_1hour / 2015-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-17.parquet
  size:    49 KB
  rows:    1,530

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-17 00:00:00	ES	Futures	2183.73	2184.52	2182.93	2183.2	1896.0
2015-03-17 01:00:00	ES	Futures	2183.46	2183.46	2181.35	2181.61	1728.0
2015-03-17 02:00:00	ES	Futures	2181.61	2183.46	2181.08	2182.93	2439.0
2015-03-17 03:00:00	ES	Futures	2182.93	2185.84	2182.67	2185.84	8644.0
2015-03-17 04:00:00	ES	Futures	2185.57	2186.9	2183.46	2183.99	16610.0
2015-03-17 05:00:00	ES	Futures	2183.99	2184.25	2180.03	2180.82	12265.0
2015-03-17 06:00:00	ES	Futures	2180.82	2181.35	2177.65	2178.18	19534.0
2015-03-17 07:00:00	ES	Futures	2178.18	2179.5	2177.12	2178.44	25586.0
2015-03-17 08:00:00	ES	Futures	2178.44	2182.14	2178.18	2181.08	43190.0
2015-03-17 09:00:00	ES	Futures	2181.08	2184.25	2175.27	2178.71	169782.0
2015-03-17 10:00:00	ES	Futures	2178.71	2181.88	2177.12	2179.5	147566.0
2015-03-17 11:00:00	ES	Futures	2179.5	2179.5	2172.37	2177.39	164948.0
2015-03-17 12:00:00	ES	Futures	2177.12	2181.61	2173.69	2181.61	96035.0
2015-03-17 13:00:00	ES	Futures	2181.61	2184.78	2180.03	2184.25	71765.0
2015-03-17 14:00:00	ES	Futures	2184.25	2185.84	2179.76	2182.93	74982.0
2015-03-17 15:00:00	ES	Futures	2183.2	2187.42	2181.61	2182.93	146596.0
2015-03-17 16:00:00	ES	Futures	2182.67	2183.73	2180.56	2182.67	52577.0
2015-03-17 17:00:00	ES	Futures	2182.93	2182.93	2182.41	2182.93	1503.0
2015-03-17 18:00:00	ES	Futures	2182.93	2183.73	2182.41	2182.67	2293.0
2015-03-17 19:00:00	ES	Futures	2182.67	2183.99	2182.67	2183.73	1164.0
2015-03-17 20:00:00	ES	Futures	2183.46	2183.99	2182.93	2183.46	2964.0
2015-03-17 21:00:00	ES	Futures	2183.46	2183.99	2182.93	2183.46	1932.0
2015-03-17 22:00:00	ES	Futures	2183.73	2183.99	2182.93	2183.2	1389.0
2015-03-17 23:00:00	ES	Futures	2183.2	2183.73	2182.93	2183.46	1246.0
2015-03-17 00:00:00	NQ	Futures	5119.94	5122.29	5118.47	5119.35	491.0
2015-03-17 01:00:00	NQ	Futures	5119.35	5120.23	5115.24	5116.12	445.0
2015-03-17 02:00:00	NQ	Futures	5116.12	5120.82	5115.24	5119.94	512.0
2015-03-17 03:00:00	NQ	Futures	5119.94	5126.12	5119.06	5125.23	3247.0
2015-03-17 04:00:00	NQ	Futures	5125.53	5129.06	5119.35	5120.23	2998.0
2015-03-17 05:00:00	NQ	Futures	5119.94	5121.41	5113.76	5114.35	2115.0
2015-03-17 06:00:00	NQ	Futures	5114.35	5114.94	5107.88	5110.24	3141.0
2015-03-17 07:00:00	NQ	Futures	5110.24	5114.35	5108.18	5113.18	3326.0
2015-03-17 08:00:00	NQ	Futures	5113.47	5122.29	5113.18	5121.7	6085.0
2015-03-17 09:00:00	NQ	Futures	5122.0	5129.64	5112.29	5125.82	27543.0
2015-03-17 10:00:00	NQ	Futures	5125.82	5127.0	5117.88	5121.7	28059.0
2015-03-17 11:00:00	NQ	Futures	5122.0	5125.53	5107.0	5124.94	26939.0
2015-03-17 12:00:00	NQ	Futures	5124.94	5133.17	5119.06	5132.88	15618.0
2015-03-17 13:00:00	NQ	Futures	5132.88	5143.17	5130.82	5140.82	13155.0
2015-03-17 14:00:00	NQ	Futures	5141.41	5145.52	5133.47	5140.23	11676.0
2015-03-17 15:00:00	NQ	Futures	5140.52	5149.35	5137.88	5139.64	21303.0
2015-03-17 16:00:00	NQ	Futures	5139.64	5142.88	5136.7	5141.41	6658.0
2015-03-17 17:00:00	NQ	Futures	5141.41	5141.7	5140.52	5141.41	117.0
2015-03-17 18:00:00	NQ	Futures	5140.82	5143.17	5140.23	5141.11	347.0
2015-03-17 19:00:00	NQ	Futures	5141.41	5143.17	5140.82	5142.58	252.0
2015-03-17 20:00:00	NQ	Futures	5142.29	5143.17	5141.7	5142.29	174.0
2015-03-17 21:00:00	NQ	Futures	5142.29	5143.76	5141.41	5143.17	307.0
2015-03-17 22:00:00	NQ	Futures	5142.88	5144.35	5142.29	5142.88	267.0
2015-03-17 23:00:00	NQ	Futures	5142.58	5144.35	5141.99	5142.58	187.0
2015-03-17 00:00:00	YM	Futures	18717.6	18729.2	18714.5	18720.8	603.0
2015-03-17 01:00:00	YM	Futures	18720.8	18721.8	18703.0	18705.1	318.0

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

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