PREVIEW / futures_1hour / 2015-01-28

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-28.parquet
  size:    53 KB
  rows:    1,583

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
2015-01-28 00:00:00	ES	Futures	2151.0	2152.32	2150.21	2150.74	3283.0
2015-01-28 01:00:00	ES	Futures	2151.0	2151.79	2148.9	2149.42	3304.0
2015-01-28 02:00:00	ES	Futures	2149.42	2152.85	2148.63	2149.16	8323.0
2015-01-28 03:00:00	ES	Futures	2149.42	2151.0	2142.32	2142.85	21236.0
2015-01-28 04:00:00	ES	Futures	2143.11	2148.11	2139.69	2146.79	23134.0
2015-01-28 05:00:00	ES	Futures	2147.06	2147.06	2135.21	2136.53	25432.0
2015-01-28 06:00:00	ES	Futures	2136.79	2141.79	2135.48	2140.21	15658.0
2015-01-28 07:00:00	ES	Futures	2139.95	2147.32	2138.64	2146.27	22610.0
2015-01-28 08:00:00	ES	Futures	2146.27	2146.79	2141.79	2142.32	29313.0
2015-01-28 09:00:00	ES	Futures	2142.32	2146.0	2136.79	2139.42	224788.0
2015-01-28 10:00:00	ES	Futures	2139.69	2142.85	2124.16	2125.48	293924.0
2015-01-28 11:00:00	ES	Futures	2125.74	2132.85	2122.06	2130.74	254614.0
2015-01-28 12:00:00	ES	Futures	2130.74	2137.32	2130.21	2133.37	113219.0
2015-01-28 13:00:00	ES	Futures	2133.37	2134.69	2128.64	2129.69	77738.0
2015-01-28 14:00:00	ES	Futures	2129.95	2138.37	2116.27	2123.64	342417.0
2015-01-28 15:00:00	ES	Futures	2123.9	2127.06	2099.43	2101.27	457752.0
2015-01-28 16:00:00	ES	Futures	2101.27	2102.85	2096.0	2099.43	125168.0
2015-01-28 17:00:00	ES	Futures	2099.16	2099.69	2097.32	2097.32	4805.0
2015-01-28 18:00:00	ES	Futures	2098.37	2101.53	2097.85	2101.53	10167.0
2015-01-28 19:00:00	ES	Futures	2101.27	2102.06	2099.95	2101.53	10716.0
2015-01-28 20:00:00	ES	Futures	2101.79	2102.06	2099.43	2101.53	5295.0
2015-01-28 21:00:00	ES	Futures	2101.53	2102.58	2100.48	2102.06	4237.0
2015-01-28 22:00:00	ES	Futures	2102.06	2102.32	2099.43	2100.74	3915.0
2015-01-28 23:00:00	ES	Futures	2100.74	2102.06	2100.21	2100.48	1777.0
2015-01-28 00:00:00	NQ	Futures	4968.62	4974.49	4964.21	4966.27	1648.0
2015-01-28 01:00:00	NQ	Futures	4966.56	4969.5	4962.16	4963.04	686.0
2015-01-28 02:00:00	NQ	Futures	4962.16	4971.56	4961.28	4963.92	1655.0
2015-01-28 03:00:00	NQ	Futures	4963.63	4968.33	4951.88	4953.35	3927.0
2015-01-28 04:00:00	NQ	Futures	4953.35	4966.27	4944.54	4963.92	4106.0
2015-01-28 05:00:00	NQ	Futures	4963.92	4964.51	4934.85	4939.55	4523.0
2015-01-28 06:00:00	NQ	Futures	4939.55	4953.64	4937.2	4949.82	3024.0
2015-01-28 07:00:00	NQ	Futures	4949.53	4967.74	4946.89	4963.63	5269.0
2015-01-28 08:00:00	NQ	Futures	4963.33	4964.21	4954.23	4955.99	6319.0
2015-01-28 09:00:00	NQ	Futures	4955.99	4968.03	4939.25	4952.17	45962.0
2015-01-28 10:00:00	NQ	Futures	4952.47	4961.87	4906.36	4909.59	55953.0
2015-01-28 11:00:00	NQ	Futures	4909.88	4926.04	4897.84	4919.87	36122.0
2015-01-28 12:00:00	NQ	Futures	4919.87	4944.24	4919.57	4938.08	18962.0
2015-01-28 13:00:00	NQ	Futures	4938.08	4942.19	4927.8	4929.85	11939.0
2015-01-28 14:00:00	NQ	Futures	4929.85	4950.41	4892.85	4914.29	65981.0
2015-01-28 15:00:00	NQ	Futures	4913.99	4922.8	4856.73	4858.19	67866.0
2015-01-28 16:00:00	NQ	Futures	4858.49	4863.48	4839.4	4846.45	17932.0
2015-01-28 17:00:00	NQ	Futures	4847.03	4847.62	4843.8	4845.27	371.0
2015-01-28 18:00:00	NQ	Futures	4845.86	4853.49	4845.27	4853.2	981.0
2015-01-28 19:00:00	NQ	Futures	4853.2	4854.96	4849.97	4854.67	977.0
2015-01-28 20:00:00	NQ	Futures	4854.38	4854.38	4849.09	4853.2	851.0
2015-01-28 21:00:00	NQ	Futures	4853.79	4856.73	4851.44	4854.67	801.0
2015-01-28 22:00:00	NQ	Futures	4854.38	4855.55	4849.09	4851.73	770.0
2015-01-28 23:00:00	NQ	Futures	4852.03	4852.91	4849.09	4849.68	549.0
2015-01-28 00:00:00	YM	Futures	18231.3	18241.8	18212.5	18219.8	1056.0
2015-01-28 01:00:00	YM	Futures	18219.8	18228.2	18205.2	18210.4	561.0

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

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