PREVIEW / futures_1hour / 2016-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-24.parquet
  size:    45 KB
  rows:    1,319

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-03-24 00:00:00	ES	Futures	2186.57	2187.38	2186.03	2186.57	3181.0
2016-03-24 01:00:00	ES	Futures	2186.84	2187.92	2186.3	2186.3	2472.0
2016-03-24 02:00:00	ES	Futures	2186.57	2186.84	2183.87	2184.14	7420.0
2016-03-24 03:00:00	ES	Futures	2184.14	2186.03	2183.6	2184.68	11474.0
2016-03-24 04:00:00	ES	Futures	2184.41	2187.38	2181.44	2184.68	36894.0
2016-03-24 05:00:00	ES	Futures	2184.41	2184.68	2180.63	2182.52	22312.0
2016-03-24 06:00:00	ES	Futures	2182.52	2182.52	2178.47	2179.01	35770.0
2016-03-24 07:00:00	ES	Futures	2179.01	2179.55	2177.39	2178.47	28812.0
2016-03-24 08:00:00	ES	Futures	2178.2	2180.09	2174.15	2176.58	61503.0
2016-03-24 09:00:00	ES	Futures	2176.31	2179.28	2173.07	2178.47	233714.0
2016-03-24 10:00:00	ES	Futures	2178.74	2181.98	2175.23	2181.17	241750.0
2016-03-24 11:00:00	ES	Futures	2180.9	2183.06	2177.12	2179.28	158481.0
2016-03-24 12:00:00	ES	Futures	2179.01	2183.33	2175.77	2178.2	157602.0
2016-03-24 13:00:00	ES	Futures	2178.47	2183.06	2177.93	2181.98	92775.0
2016-03-24 14:00:00	ES	Futures	2181.98	2186.3	2179.82	2184.68	120963.0
2016-03-24 15:00:00	ES	Futures	2184.95	2188.73	2183.33	2188.73	198772.0
2016-03-24 16:00:00	ES	Futures	2188.73	2192.51	2188.19	2192.51	65874.0
2016-03-24 00:00:00	NQ	Futures	5219.86	5224.62	5219.56	5222.24	659.0
2016-03-24 01:00:00	NQ	Futures	5221.94	5225.81	5221.65	5222.24	320.0
2016-03-24 02:00:00	NQ	Futures	5222.24	5222.84	5215.1	5215.7	808.0
2016-03-24 03:00:00	NQ	Futures	5215.99	5221.05	5213.32	5215.1	1532.0
2016-03-24 04:00:00	NQ	Futures	5215.7	5222.24	5204.98	5213.91	4605.0
2016-03-24 05:00:00	NQ	Futures	5213.32	5213.32	5202.01	5208.85	2556.0
2016-03-24 06:00:00	NQ	Futures	5208.85	5208.85	5199.03	5202.01	3340.0
2016-03-24 07:00:00	NQ	Futures	5201.71	5204.98	5198.14	5201.71	2386.0
2016-03-24 08:00:00	NQ	Futures	5201.71	5207.36	5194.87	5202.01	5911.0
2016-03-24 09:00:00	NQ	Futures	5201.71	5217.48	5195.17	5215.4	33261.0
2016-03-24 10:00:00	NQ	Futures	5215.4	5227.3	5205.88	5225.51	33563.0
2016-03-24 11:00:00	NQ	Futures	5225.51	5231.17	5213.32	5218.08	23126.0
2016-03-24 12:00:00	NQ	Futures	5218.08	5225.22	5203.5	5210.04	19516.0
2016-03-24 13:00:00	NQ	Futures	5210.04	5219.27	5209.15	5214.8	12445.0
2016-03-24 14:00:00	NQ	Futures	5214.8	5228.49	5209.75	5225.22	15764.0
2016-03-24 15:00:00	NQ	Futures	5225.22	5233.25	5221.05	5230.57	22113.0
2016-03-24 16:00:00	NQ	Futures	5230.87	5237.71	5229.38	5237.12	6514.0
2016-03-24 00:00:00	YM	Futures	18625.9	18631.2	18619.4	18625.9	658.0
2016-03-24 01:00:00	YM	Futures	18625.9	18637.6	18622.6	18624.8	529.0
2016-03-24 02:00:00	YM	Futures	18625.9	18626.9	18604.4	18606.6	1059.0
2016-03-24 03:00:00	YM	Futures	18608.7	18621.6	18604.4	18609.8	1707.0
2016-03-24 04:00:00	YM	Futures	18610.9	18631.2	18580.9	18608.7	4798.0
2016-03-24 05:00:00	YM	Futures	18607.7	18607.7	18574.5	18591.6	1855.0
2016-03-24 06:00:00	YM	Futures	18590.5	18590.5	18560.6	18564.8	4139.0
2016-03-24 07:00:00	YM	Futures	18564.8	18572.3	18547.7	18564.8	5421.0
2016-03-24 08:00:00	YM	Futures	18565.9	18570.2	18529.5	18541.3	7009.0
2016-03-24 09:00:00	YM	Futures	18540.2	18559.5	18516.7	18555.2	20773.0
2016-03-24 10:00:00	YM	Futures	18555.2	18578.8	18521.0	18574.5	18672.0
2016-03-24 11:00:00	YM	Futures	18575.5	18592.7	18546.6	18562.7	11925.0
2016-03-24 12:00:00	YM	Futures	18560.6	18588.4	18524.2	18542.4	11837.0
2016-03-24 13:00:00	YM	Futures	18542.4	18591.6	18541.3	18584.1	7521.0
2016-03-24 14:00:00	YM	Futures	18584.1	18625.9	18564.8	18616.2	9269.0
2016-03-24 15:00:00	YM	Futures	18617.3	18648.3	18603.4	18646.2	12047.0

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

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