PREVIEW / futures_1hour / 2014-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-17.parquet
  size:    50 KB
  rows:    1,521

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-17 00:00:00	ES	Futures	2126.13	2126.91	2123.25	2124.56	5614.0
2014-11-17 01:00:00	ES	Futures	2124.82	2127.18	2124.56	2125.08	3643.0
2014-11-17 02:00:00	ES	Futures	2125.08	2127.7	2124.82	2126.65	10388.0
2014-11-17 03:00:00	ES	Futures	2126.65	2132.68	2126.65	2127.44	26720.0
2014-11-17 04:00:00	ES	Futures	2127.44	2130.06	2124.82	2127.44	19278.0
2014-11-17 05:00:00	ES	Futures	2127.18	2130.84	2126.91	2129.27	10168.0
2014-11-17 06:00:00	ES	Futures	2129.53	2131.37	2128.22	2129.53	15823.0
2014-11-17 07:00:00	ES	Futures	2129.53	2131.37	2128.48	2130.58	17164.0
2014-11-17 08:00:00	ES	Futures	2130.32	2131.89	2128.48	2131.37	30393.0
2014-11-17 09:00:00	ES	Futures	2131.1	2133.46	2129.01	2132.68	120440.0
2014-11-17 10:00:00	ES	Futures	2132.68	2137.39	2130.58	2135.03	227163.0
2014-11-17 11:00:00	ES	Futures	2135.03	2135.03	2128.48	2131.37	149718.0
2014-11-17 12:00:00	ES	Futures	2131.37	2136.34	2130.06	2134.51	72227.0
2014-11-17 13:00:00	ES	Futures	2134.51	2138.18	2134.25	2136.34	78942.0
2014-11-17 14:00:00	ES	Futures	2136.61	2137.65	2135.56	2136.87	47779.0
2014-11-17 15:00:00	ES	Futures	2136.87	2137.39	2134.51	2136.08	109985.0
2014-11-17 16:00:00	ES	Futures	2136.34	2137.65	2136.08	2137.13	44931.0
2014-11-17 17:00:00	ES	Futures	2137.13	2137.39	2136.34	2136.87	1856.0
2014-11-17 18:00:00	ES	Futures	2136.87	2137.13	2135.82	2136.61	4313.0
2014-11-17 19:00:00	ES	Futures	2136.34	2137.39	2136.08	2136.34	2375.0
2014-11-17 20:00:00	ES	Futures	2136.34	2136.87	2135.82	2136.34	1709.0
2014-11-17 21:00:00	ES	Futures	2136.08	2136.34	2135.56	2135.82	2179.0
2014-11-17 22:00:00	ES	Futures	2136.08	2136.87	2135.56	2136.08	2076.0
2014-11-17 23:00:00	ES	Futures	2136.08	2136.87	2136.08	2136.61	1378.0
2014-11-17 00:00:00	NQ	Futures	4930.41	4932.17	4924.25	4927.18	956.0
2014-11-17 01:00:00	NQ	Futures	4927.18	4932.46	4925.72	4928.94	871.0
2014-11-17 02:00:00	NQ	Futures	4928.36	4933.04	4926.01	4930.41	2128.0
2014-11-17 03:00:00	NQ	Futures	4930.7	4943.01	4930.7	4933.04	4726.0
2014-11-17 04:00:00	NQ	Futures	4933.04	4935.68	4926.6	4932.17	2619.0
2014-11-17 05:00:00	NQ	Futures	4931.87	4940.66	4930.7	4937.15	1855.0
2014-11-17 06:00:00	NQ	Futures	4937.15	4941.54	4934.51	4938.03	2481.0
2014-11-17 07:00:00	NQ	Futures	4938.32	4943.59	4934.22	4941.54	2352.0
2014-11-17 08:00:00	NQ	Futures	4941.25	4943.89	4933.63	4942.42	6720.0
2014-11-17 09:00:00	NQ	Futures	4942.13	4948.87	4934.8	4946.23	32306.0
2014-11-17 10:00:00	NQ	Futures	4946.82	4951.21	4927.77	4935.97	45418.0
2014-11-17 11:00:00	NQ	Futures	4935.68	4936.56	4912.53	4925.13	43176.0
2014-11-17 12:00:00	NQ	Futures	4924.84	4941.83	4920.45	4930.41	23363.0
2014-11-17 13:00:00	NQ	Futures	4930.41	4941.54	4930.11	4936.27	16046.0
2014-11-17 14:00:00	NQ	Futures	4936.27	4941.83	4933.34	4939.78	9683.0
2014-11-17 15:00:00	NQ	Futures	4939.49	4940.08	4930.99	4935.39	19635.0
2014-11-17 16:00:00	NQ	Futures	4935.39	4938.32	4935.39	4937.44	5085.0
2014-11-17 17:00:00	NQ	Futures	4937.44	4938.61	4936.27	4936.27	296.0
2014-11-17 18:00:00	NQ	Futures	4938.03	4938.61	4933.34	4935.68	517.0
2014-11-17 19:00:00	NQ	Futures	4935.39	4938.61	4935.1	4936.85	323.0
2014-11-17 20:00:00	NQ	Futures	4937.15	4937.44	4935.1	4935.39	255.0
2014-11-17 21:00:00	NQ	Futures	4935.39	4935.97	4933.34	4934.8	415.0
2014-11-17 22:00:00	NQ	Futures	4934.8	4937.15	4934.22	4935.68	384.0
2014-11-17 23:00:00	NQ	Futures	4935.68	4937.73	4935.39	4936.85	330.0
2014-11-17 00:00:00	YM	Futures	18236.4	18243.7	18215.6	18225.0	1136.0
2014-11-17 01:00:00	YM	Futures	18223.9	18240.6	18222.9	18228.1	513.0

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

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