PREVIEW / futures_1hour / 2016-02-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-29.parquet
  size:    53 KB
  rows:    1,613

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-29 00:00:00	ES	Futures	2081.96	2083.03	2077.12	2077.39	8602.0
2016-02-29 01:00:00	ES	Futures	2077.39	2077.93	2072.02	2077.12	14385.0
2016-02-29 02:00:00	ES	Futures	2077.12	2079.54	2074.43	2076.05	17483.0
2016-02-29 03:00:00	ES	Futures	2076.05	2079.27	2072.02	2072.55	38024.0
2016-02-29 04:00:00	ES	Futures	2072.82	2077.93	2072.28	2074.7	22632.0
2016-02-29 05:00:00	ES	Futures	2074.7	2085.99	2074.7	2078.73	44867.0
2016-02-29 06:00:00	ES	Futures	2079.0	2085.99	2076.05	2084.38	27198.0
2016-02-29 07:00:00	ES	Futures	2084.38	2088.94	2082.49	2084.64	28473.0
2016-02-29 08:00:00	ES	Futures	2084.38	2093.78	2084.38	2092.44	55227.0
2016-02-29 09:00:00	ES	Futures	2092.71	2093.51	2086.26	2090.56	187945.0
2016-02-29 10:00:00	ES	Futures	2090.29	2093.78	2086.26	2092.97	209340.0
2016-02-29 11:00:00	ES	Futures	2092.97	2102.65	2092.71	2099.42	233320.0
2016-02-29 12:00:00	ES	Futures	2099.42	2100.5	2095.12	2098.08	107676.0
2016-02-29 13:00:00	ES	Futures	2098.08	2098.62	2092.44	2094.59	78537.0
2016-02-29 14:00:00	ES	Futures	2094.86	2095.12	2081.69	2082.49	191504.0
2016-02-29 15:00:00	ES	Futures	2082.49	2082.49	2072.02	2072.55	352004.0
2016-02-29 16:00:00	ES	Futures	2072.82	2077.12	2070.67	2072.55	129134.0
2016-02-29 18:00:00	ES	Futures	2072.28	2078.2	2071.21	2076.05	11124.0
2016-02-29 19:00:00	ES	Futures	2076.31	2077.93	2069.6	2070.4	12284.0
2016-02-29 20:00:00	ES	Futures	2070.4	2074.16	2064.49	2066.37	23523.0
2016-02-29 21:00:00	ES	Futures	2066.37	2068.79	2065.3	2067.45	8206.0
2016-02-29 22:00:00	ES	Futures	2067.18	2070.67	2066.91	2070.67	7271.0
2016-02-29 23:00:00	ES	Futures	2070.4	2072.28	2069.87	2072.02	4720.0
2016-02-29 00:00:00	NQ	Futures	4998.84	5002.7	4986.66	4986.66	2295.0
2016-02-29 01:00:00	NQ	Futures	4986.37	4988.45	4972.71	4985.18	2561.0
2016-02-29 02:00:00	NQ	Futures	4985.18	4991.42	4978.05	4981.91	2888.0
2016-02-29 03:00:00	NQ	Futures	4981.62	4990.53	4970.04	4971.82	6225.0
2016-02-29 04:00:00	NQ	Futures	4971.82	4984.59	4970.93	4975.08	2874.0
2016-02-29 05:00:00	NQ	Futures	4975.68	5008.04	4975.68	4988.45	5260.0
2016-02-29 06:00:00	NQ	Futures	4988.74	5010.72	4982.21	5006.56	3199.0
2016-02-29 07:00:00	NQ	Futures	5006.86	5018.73	5002.11	5009.53	3373.0
2016-02-29 08:00:00	NQ	Futures	5008.04	5031.5	5007.45	5029.13	6346.0
2016-02-29 09:00:00	NQ	Futures	5029.42	5045.16	5017.84	5038.03	36375.0
2016-02-29 10:00:00	NQ	Futures	5037.74	5044.86	5025.27	5041.3	35652.0
2016-02-29 11:00:00	NQ	Futures	5041.6	5063.57	5037.44	5057.93	25925.0
2016-02-29 12:00:00	NQ	Futures	5057.33	5061.19	5046.05	5055.85	16572.0
2016-02-29 13:00:00	NQ	Futures	5055.85	5057.04	5033.88	5039.22	10869.0
2016-02-29 14:00:00	NQ	Futures	5039.22	5040.41	5007.45	5012.5	25456.0
2016-02-29 15:00:00	NQ	Futures	5012.5	5012.79	4986.07	4987.26	40411.0
2016-02-29 16:00:00	NQ	Futures	4986.96	4996.17	4983.7	4987.85	13481.0
2016-02-29 18:00:00	NQ	Futures	4987.56	5002.11	4979.54	4997.65	2006.0
2016-02-29 19:00:00	NQ	Futures	4997.95	5002.11	4980.73	4981.32	1681.0
2016-02-29 20:00:00	NQ	Futures	4981.62	4992.31	4964.99	4968.85	3211.0
2016-02-29 21:00:00	NQ	Futures	4969.74	4977.46	4967.07	4973.6	895.0
2016-02-29 22:00:00	NQ	Futures	4972.71	4981.91	4972.41	4981.02	876.0
2016-02-29 23:00:00	NQ	Futures	4980.73	4985.77	4978.94	4984.59	516.0
2016-02-29 00:00:00	YM	Futures	17616.1	17625.6	17582.0	17582.0	1589.0
2016-02-29 01:00:00	YM	Futures	17583.1	17586.2	17545.8	17584.1	2816.0
2016-02-29 02:00:00	YM	Futures	17584.1	17603.3	17563.9	17578.8	3048.0
2016-02-29 03:00:00	YM	Futures	17578.8	17599.0	17540.5	17543.7	6457.0

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

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