PREVIEW / futures_1hour / 2016-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-08.parquet
  size:    53 KB
  rows:    1,580

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-08 00:00:00	ES	Futures	2143.76	2143.76	2140.54	2141.88	5231.0
2016-03-08 01:00:00	ES	Futures	2141.88	2141.88	2137.85	2140.0	5822.0
2016-03-08 02:00:00	ES	Futures	2140.0	2141.34	2135.7	2136.24	12990.0
2016-03-08 03:00:00	ES	Futures	2136.24	2137.85	2131.4	2133.01	43564.0
2016-03-08 04:00:00	ES	Futures	2133.01	2137.58	2132.21	2132.74	21273.0
2016-03-08 05:00:00	ES	Futures	2132.74	2133.55	2128.98	2131.94	25227.0
2016-03-08 06:00:00	ES	Futures	2131.94	2136.51	2130.59	2135.97	21492.0
2016-03-08 07:00:00	ES	Futures	2135.97	2143.22	2135.7	2140.8	44188.0
2016-03-08 08:00:00	ES	Futures	2140.54	2142.95	2137.04	2139.73	47990.0
2016-03-08 09:00:00	ES	Futures	2140.0	2140.27	2130.06	2132.74	273112.0
2016-03-08 10:00:00	ES	Futures	2132.74	2135.97	2125.49	2127.64	318413.0
2016-03-08 11:00:00	ES	Futures	2127.37	2137.04	2127.1	2135.16	214427.0
2016-03-08 12:00:00	ES	Futures	2135.16	2140.8	2133.28	2136.77	138870.0
2016-03-08 13:00:00	ES	Futures	2137.04	2142.15	2134.36	2139.46	98926.0
2016-03-08 14:00:00	ES	Futures	2139.46	2142.15	2131.94	2133.82	128389.0
2016-03-08 15:00:00	ES	Futures	2133.82	2135.16	2123.88	2125.22	271361.0
2016-03-08 16:00:00	ES	Futures	2125.49	2131.4	2124.95	2130.86	91461.0
2016-03-08 18:00:00	ES	Futures	2130.06	2131.94	2127.91	2129.79	7022.0
2016-03-08 19:00:00	ES	Futures	2129.79	2130.86	2126.83	2128.71	7758.0
2016-03-08 20:00:00	ES	Futures	2128.71	2131.67	2128.18	2130.59	8560.0
2016-03-08 21:00:00	ES	Futures	2130.33	2130.86	2128.98	2129.79	3079.0
2016-03-08 22:00:00	ES	Futures	2129.79	2131.13	2128.98	2130.59	3464.0
2016-03-08 23:00:00	ES	Futures	2130.86	2132.47	2129.79	2131.13	3823.0
2016-03-08 00:00:00	NQ	Futures	5092.08	5092.37	5084.36	5088.51	988.0
2016-03-08 01:00:00	NQ	Futures	5087.92	5087.92	5077.53	5084.06	795.0
2016-03-08 02:00:00	NQ	Futures	5083.46	5087.03	5071.29	5072.78	1731.0
2016-03-08 03:00:00	NQ	Futures	5073.07	5075.15	5055.26	5060.3	6002.0
2016-03-08 04:00:00	NQ	Futures	5060.6	5070.7	5057.04	5058.23	2676.0
2016-03-08 05:00:00	NQ	Futures	5058.23	5061.19	5049.61	5057.93	2422.0
2016-03-08 06:00:00	NQ	Futures	5058.23	5070.7	5054.96	5070.1	3100.0
2016-03-08 07:00:00	NQ	Futures	5070.7	5091.78	5070.4	5085.25	6000.0
2016-03-08 08:00:00	NQ	Futures	5084.95	5092.37	5075.45	5084.36	7267.0
2016-03-08 09:00:00	NQ	Futures	5084.06	5100.09	5058.23	5086.73	48936.0
2016-03-08 10:00:00	NQ	Futures	5086.43	5097.42	5064.46	5077.53	49788.0
2016-03-08 11:00:00	NQ	Futures	5077.82	5103.95	5075.45	5101.28	32479.0
2016-03-08 12:00:00	NQ	Futures	5101.28	5116.42	5094.45	5100.39	26181.0
2016-03-08 13:00:00	NQ	Futures	5100.39	5117.61	5092.67	5109.89	16117.0
2016-03-08 14:00:00	NQ	Futures	5109.59	5112.56	5083.76	5088.81	21458.0
2016-03-08 15:00:00	NQ	Futures	5088.81	5092.97	5055.55	5064.16	44723.0
2016-03-08 16:00:00	NQ	Futures	5064.16	5077.82	5063.27	5075.74	9731.0
2016-03-08 18:00:00	NQ	Futures	5072.78	5078.42	5066.84	5071.59	1061.0
2016-03-08 19:00:00	NQ	Futures	5071.29	5074.26	5063.27	5069.51	1159.0
2016-03-08 20:00:00	NQ	Futures	5068.91	5077.23	5067.43	5073.96	1401.0
2016-03-08 21:00:00	NQ	Futures	5074.26	5075.74	5070.4	5072.48	414.0
2016-03-08 22:00:00	NQ	Futures	5072.18	5075.74	5070.4	5074.85	531.0
2016-03-08 23:00:00	NQ	Futures	5075.45	5080.2	5072.48	5076.04	432.0
2016-03-08 00:00:00	YM	Futures	18107.8	18108.9	18085.5	18094.0	797.0
2016-03-08 01:00:00	YM	Futures	18095.1	18095.1	18066.3	18083.4	1208.0
2016-03-08 02:00:00	YM	Futures	18083.4	18090.8	18050.4	18053.6	1946.0
2016-03-08 03:00:00	YM	Futures	18054.6	18062.1	18016.3	18029.1	5216.0

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

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