PREVIEW / futures_1hour / 2014-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-18.parquet
  size:    49 KB
  rows:    1,531

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-18 00:00:00	ES	Futures	2136.61	2137.13	2136.34	2136.87	1237.0
2014-11-18 01:00:00	ES	Futures	2136.61	2140.01	2136.61	2138.44	5200.0
2014-11-18 02:00:00	ES	Futures	2138.44	2138.44	2136.87	2136.87	6051.0
2014-11-18 03:00:00	ES	Futures	2137.13	2137.92	2134.25	2134.77	23236.0
2014-11-18 04:00:00	ES	Futures	2134.77	2137.13	2133.72	2136.87	13835.0
2014-11-18 05:00:00	ES	Futures	2137.13	2138.44	2133.2	2135.03	23354.0
2014-11-18 06:00:00	ES	Futures	2135.03	2137.13	2134.25	2136.34	11110.0
2014-11-18 07:00:00	ES	Futures	2136.61	2138.44	2136.08	2137.92	20395.0
2014-11-18 08:00:00	ES	Futures	2137.92	2138.18	2135.56	2136.61	25726.0
2014-11-18 09:00:00	ES	Futures	2136.87	2144.73	2136.34	2144.46	184852.0
2014-11-18 10:00:00	ES	Futures	2144.46	2146.04	2141.85	2144.99	199621.0
2014-11-18 11:00:00	ES	Futures	2144.99	2146.56	2144.2	2146.56	96672.0
2014-11-18 12:00:00	ES	Futures	2146.56	2148.13	2144.99	2147.61	76908.0
2014-11-18 13:00:00	ES	Futures	2147.87	2149.44	2147.08	2148.66	81299.0
2014-11-18 14:00:00	ES	Futures	2148.39	2152.32	2148.39	2150.49	104021.0
2014-11-18 15:00:00	ES	Futures	2150.49	2152.32	2147.61	2148.66	169206.0
2014-11-18 16:00:00	ES	Futures	2148.39	2148.92	2146.04	2146.56	69395.0
2014-11-18 17:00:00	ES	Futures	2146.82	2147.08	2146.3	2146.56	1610.0
2014-11-18 18:00:00	ES	Futures	2146.82	2147.08	2144.73	2145.51	5869.0
2014-11-18 19:00:00	ES	Futures	2145.51	2146.56	2145.25	2145.77	3138.0
2014-11-18 20:00:00	ES	Futures	2146.04	2146.04	2145.25	2146.04	1850.0
2014-11-18 21:00:00	ES	Futures	2145.77	2147.08	2145.77	2146.3	2086.0
2014-11-18 22:00:00	ES	Futures	2146.3	2146.3	2144.46	2144.99	3256.0
2014-11-18 23:00:00	ES	Futures	2144.99	2145.25	2144.46	2144.73	2059.0
2014-11-18 00:00:00	NQ	Futures	4937.15	4937.44	4936.27	4936.56	219.0
2014-11-18 01:00:00	NQ	Futures	4936.56	4947.4	4936.27	4943.89	1630.0
2014-11-18 02:00:00	NQ	Futures	4943.89	4944.76	4938.9	4938.9	1026.0
2014-11-18 03:00:00	NQ	Futures	4938.9	4943.01	4931.58	4933.04	2987.0
2014-11-18 04:00:00	NQ	Futures	4933.04	4940.08	4931.87	4938.9	1941.0
2014-11-18 05:00:00	NQ	Futures	4939.2	4943.01	4926.01	4930.41	4565.0
2014-11-18 06:00:00	NQ	Futures	4930.7	4935.39	4928.94	4934.22	1962.0
2014-11-18 07:00:00	NQ	Futures	4934.51	4939.2	4933.34	4938.32	2315.0
2014-11-18 08:00:00	NQ	Futures	4938.61	4939.2	4933.34	4938.61	3799.0
2014-11-18 09:00:00	NQ	Futures	4938.9	4963.52	4937.44	4961.17	43112.0
2014-11-18 10:00:00	NQ	Futures	4961.76	4969.38	4956.78	4962.34	41115.0
2014-11-18 11:00:00	NQ	Futures	4962.64	4966.45	4955.02	4965.86	18503.0
2014-11-18 12:00:00	NQ	Futures	4966.15	4971.14	4962.93	4969.96	14330.0
2014-11-18 13:00:00	NQ	Futures	4970.26	4973.77	4964.98	4970.26	17372.0
2014-11-18 14:00:00	NQ	Futures	4970.26	4979.63	4969.96	4975.24	20082.0
2014-11-18 15:00:00	NQ	Futures	4975.24	4979.34	4969.67	4972.6	27428.0
2014-11-18 16:00:00	NQ	Futures	4972.31	4972.89	4966.74	4968.2	7001.0
2014-11-18 17:00:00	NQ	Futures	4968.5	4969.08	4965.27	4966.45	597.0
2014-11-18 18:00:00	NQ	Futures	4967.33	4968.2	4963.81	4966.74	906.0
2014-11-18 19:00:00	NQ	Futures	4967.03	4968.79	4965.27	4966.15	473.0
2014-11-18 20:00:00	NQ	Futures	4966.45	4967.33	4964.1	4967.03	457.0
2014-11-18 21:00:00	NQ	Futures	4967.33	4969.67	4966.45	4967.91	273.0
2014-11-18 22:00:00	NQ	Futures	4967.62	4967.91	4964.4	4966.15	480.0
2014-11-18 23:00:00	NQ	Futures	4965.57	4966.45	4964.69	4964.98	315.0
2014-11-18 00:00:00	YM	Futures	18314.4	18315.4	18310.2	18312.3	205.0
2014-11-18 01:00:00	YM	Futures	18313.3	18345.6	18313.3	18331.0	1290.0

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

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