PREVIEW / futures_1hour / 2016-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-23.parquet
  size:    52 KB
  rows:    1,554

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-02-23 00:00:00	ES	Futures	2072.55	2075.24	2071.48	2073.9	7116.0
2016-02-23 01:00:00	ES	Futures	2074.16	2074.97	2073.09	2074.16	3495.0
2016-02-23 02:00:00	ES	Futures	2074.16	2075.78	2072.55	2074.43	12636.0
2016-02-23 03:00:00	ES	Futures	2074.43	2078.2	2068.52	2077.39	42300.0
2016-02-23 04:00:00	ES	Futures	2077.39	2079.27	2072.82	2073.36	25514.0
2016-02-23 05:00:00	ES	Futures	2073.36	2076.85	2072.02	2076.05	18752.0
2016-02-23 06:00:00	ES	Futures	2076.05	2080.08	2075.78	2078.46	23299.0
2016-02-23 07:00:00	ES	Futures	2078.2	2081.69	2077.39	2078.46	23084.0
2016-02-23 08:00:00	ES	Futures	2078.46	2083.03	2074.97	2081.96	45169.0
2016-02-23 09:00:00	ES	Futures	2081.69	2082.23	2076.31	2079.0	205796.0
2016-02-23 10:00:00	ES	Futures	2079.27	2080.08	2065.57	2067.18	291277.0
2016-02-23 11:00:00	ES	Futures	2066.91	2070.67	2062.34	2067.98	247730.0
2016-02-23 12:00:00	ES	Futures	2067.72	2068.79	2064.22	2068.79	88543.0
2016-02-23 13:00:00	ES	Futures	2068.52	2069.06	2062.88	2065.57	87843.0
2016-02-23 14:00:00	ES	Futures	2065.57	2069.06	2063.15	2063.42	100999.0
2016-02-23 15:00:00	ES	Futures	2063.42	2067.45	2059.12	2061.27	239682.0
2016-02-23 16:00:00	ES	Futures	2061.27	2062.88	2056.97	2057.51	74303.0
2016-02-23 18:00:00	ES	Futures	2057.24	2058.31	2056.43	2057.51	7183.0
2016-02-23 19:00:00	ES	Futures	2057.77	2058.58	2056.16	2057.77	8365.0
2016-02-23 20:00:00	ES	Futures	2058.04	2062.34	2057.24	2061.0	13176.0
2016-02-23 21:00:00	ES	Futures	2060.73	2061.54	2055.89	2056.97	9505.0
2016-02-23 22:00:00	ES	Futures	2056.7	2057.77	2054.55	2055.09	11029.0
2016-02-23 23:00:00	ES	Futures	2055.09	2055.36	2052.13	2054.55	8537.0
2016-02-23 00:00:00	NQ	Futures	4979.24	4987.26	4976.57	4981.91	1432.0
2016-02-23 01:00:00	NQ	Futures	4982.21	4985.77	4981.32	4983.99	714.0
2016-02-23 02:00:00	NQ	Futures	4983.99	4988.15	4979.24	4983.4	1686.0
2016-02-23 03:00:00	NQ	Futures	4983.1	4995.87	4968.85	4993.2	5783.0
2016-02-23 04:00:00	NQ	Futures	4993.49	4998.84	4978.65	4980.43	3862.0
2016-02-23 05:00:00	NQ	Futures	4980.13	4988.74	4975.98	4987.56	3293.0
2016-02-23 06:00:00	NQ	Futures	4987.26	4997.06	4987.26	4992.31	3085.0
2016-02-23 07:00:00	NQ	Futures	4992.01	5001.21	4989.93	4992.6	3211.0
2016-02-23 08:00:00	NQ	Futures	4992.9	5003.29	4981.62	5000.03	6726.0
2016-02-23 09:00:00	NQ	Futures	5000.03	5008.04	4988.15	4998.84	31262.0
2016-02-23 10:00:00	NQ	Futures	4998.84	4999.73	4952.52	4958.46	45615.0
2016-02-23 11:00:00	NQ	Futures	4958.16	4972.12	4946.88	4962.02	30826.0
2016-02-23 12:00:00	NQ	Futures	4962.02	4970.04	4952.52	4970.04	11888.0
2016-02-23 13:00:00	NQ	Futures	4969.74	4969.74	4949.25	4957.57	13815.0
2016-02-23 14:00:00	NQ	Futures	4957.27	4966.18	4948.36	4948.66	15006.0
2016-02-23 15:00:00	NQ	Futures	4948.66	4958.46	4937.37	4942.13	30436.0
2016-02-23 16:00:00	NQ	Futures	4942.13	4948.66	4934.41	4936.48	9241.0
2016-02-23 18:00:00	NQ	Futures	4936.78	4937.37	4932.03	4935.59	1040.0
2016-02-23 19:00:00	NQ	Futures	4935.3	4938.27	4931.44	4936.48	1024.0
2016-02-23 20:00:00	NQ	Futures	4935.89	4949.25	4935.0	4946.58	1936.0
2016-02-23 21:00:00	NQ	Futures	4945.99	4948.06	4931.44	4933.22	1363.0
2016-02-23 22:00:00	NQ	Futures	4933.51	4935.89	4925.79	4927.87	1664.0
2016-02-23 23:00:00	NQ	Futures	4927.87	4928.17	4919.56	4925.5	992.0
2016-02-23 00:00:00	YM	Futures	17535.2	17557.5	17527.7	17546.9	973.0
2016-02-23 01:00:00	YM	Futures	17547.9	17560.7	17544.7	17556.4	617.0
2016-02-23 02:00:00	YM	Futures	17555.4	17566.0	17537.3	17550.1	1908.0
2016-02-23 03:00:00	YM	Futures	17550.1	17583.1	17511.7	17574.5	5515.0

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

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