PREVIEW / futures_1hour / 2014-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-07.parquet
  size:    44 KB
  rows:    1,255

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
2014-11-07 00:00:00	ES	Futures	2128.48	2129.01	2127.44	2128.48	3837.0
2014-11-07 01:00:00	ES	Futures	2128.48	2130.06	2128.22	2130.06	4617.0
2014-11-07 02:00:00	ES	Futures	2130.06	2130.06	2127.44	2128.22	8399.0
2014-11-07 03:00:00	ES	Futures	2128.22	2129.27	2125.87	2128.75	23944.0
2014-11-07 04:00:00	ES	Futures	2128.75	2129.27	2126.65	2127.7	13723.0
2014-11-07 05:00:00	ES	Futures	2127.7	2128.48	2123.25	2124.03	20800.0
2014-11-07 06:00:00	ES	Futures	2124.03	2125.87	2122.46	2125.6	20562.0
2014-11-07 07:00:00	ES	Futures	2125.87	2126.91	2123.77	2125.6	18715.0
2014-11-07 08:00:00	ES	Futures	2125.6	2130.84	2123.25	2126.91	86856.0
2014-11-07 09:00:00	ES	Futures	2126.65	2126.91	2117.74	2120.63	242176.0
2014-11-07 10:00:00	ES	Futures	2120.63	2125.87	2117.22	2125.34	248344.0
2014-11-07 11:00:00	ES	Futures	2125.34	2127.96	2124.29	2124.82	124082.0
2014-11-07 12:00:00	ES	Futures	2124.82	2126.91	2123.77	2125.34	71712.0
2014-11-07 13:00:00	ES	Futures	2125.34	2127.18	2124.56	2125.6	59541.0
2014-11-07 14:00:00	ES	Futures	2125.6	2126.39	2120.89	2121.94	85319.0
2014-11-07 15:00:00	ES	Futures	2121.94	2125.87	2119.05	2125.6	161099.0
2014-11-07 16:00:00	ES	Futures	2125.6	2126.13	2121.67	2122.98	62173.0
2014-11-07 17:00:00	ES	Futures	2122.98	2123.51	2122.46	2122.72	1535.0
2014-11-07 00:00:00	NQ	Futures	4890.27	4892.02	4888.51	4891.14	848.0
2014-11-07 01:00:00	NQ	Futures	4891.44	4897.3	4890.56	4896.42	1097.0
2014-11-07 02:00:00	NQ	Futures	4896.42	4896.42	4889.68	4890.85	1684.0
2014-11-07 03:00:00	NQ	Futures	4891.14	4894.66	4885.87	4894.37	3955.0
2014-11-07 04:00:00	NQ	Futures	4894.07	4895.25	4889.09	4891.73	2599.0
2014-11-07 05:00:00	NQ	Futures	4891.44	4892.9	4880.89	4882.94	2954.0
2014-11-07 06:00:00	NQ	Futures	4882.94	4887.63	4880.6	4887.63	2497.0
2014-11-07 07:00:00	NQ	Futures	4887.63	4890.27	4883.23	4887.34	2326.0
2014-11-07 08:00:00	NQ	Futures	4887.04	4898.76	4880.6	4890.27	16001.0
2014-11-07 09:00:00	NQ	Futures	4890.27	4890.27	4863.31	4868.29	58390.0
2014-11-07 10:00:00	NQ	Futures	4868.58	4869.76	4847.49	4866.53	48436.0
2014-11-07 11:00:00	NQ	Futures	4866.53	4873.56	4861.55	4865.07	20784.0
2014-11-07 12:00:00	NQ	Futures	4865.07	4870.63	4863.02	4868.58	10204.0
2014-11-07 13:00:00	NQ	Futures	4868.88	4879.72	4866.53	4874.74	11628.0
2014-11-07 14:00:00	NQ	Futures	4875.03	4876.2	4862.72	4864.19	10620.0
2014-11-07 15:00:00	NQ	Futures	4864.48	4873.27	4858.91	4873.27	23786.0
2014-11-07 16:00:00	NQ	Futures	4873.27	4873.86	4862.72	4865.95	7730.0
2014-11-07 17:00:00	NQ	Futures	4865.95	4866.24	4864.77	4864.77	62.0
2014-11-07 00:00:00	YM	Futures	18231.2	18239.5	18228.1	18234.3	1212.0
2014-11-07 01:00:00	YM	Futures	18236.4	18245.8	18232.2	18241.6	856.0
2014-11-07 02:00:00	YM	Futures	18242.6	18244.7	18218.7	18222.9	1474.0
2014-11-07 03:00:00	YM	Futures	18223.9	18236.4	18207.3	18233.3	4694.0
2014-11-07 04:00:00	YM	Futures	18232.2	18237.4	18216.7	18222.9	2149.0
2014-11-07 05:00:00	YM	Futures	18221.8	18227.0	18193.8	18200.0	3144.0
2014-11-07 06:00:00	YM	Futures	18199.0	18211.5	18192.7	18210.4	3053.0
2014-11-07 07:00:00	YM	Futures	18210.4	18219.8	18194.8	18209.4	2913.0
2014-11-07 08:00:00	YM	Futures	18208.3	18242.6	18193.8	18211.5	10166.0
2014-11-07 09:00:00	YM	Futures	18212.5	18212.5	18130.4	18151.1	25926.0
2014-11-07 10:00:00	YM	Futures	18152.2	18193.8	18136.6	18188.6	18364.0
2014-11-07 11:00:00	YM	Futures	18188.6	18210.4	18180.3	18190.7	9296.0
2014-11-07 12:00:00	YM	Futures	18192.7	18211.5	18182.3	18204.2	5186.0
2014-11-07 13:00:00	YM	Futures	18204.2	18219.8	18200.0	18207.3	4516.0

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

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