PREVIEW / futures_1hour / 2015-01-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	2155.21	2155.48	2152.58	2153.11	3676.0
2015-01-05 01:00:00	ES	Futures	2153.11	2153.63	2150.74	2150.74	2991.0
2015-01-05 02:00:00	ES	Futures	2150.74	2151.53	2148.11	2148.63	10891.0
2015-01-05 03:00:00	ES	Futures	2148.37	2156.0	2148.37	2155.21	24067.0
2015-01-05 04:00:00	ES	Futures	2155.48	2155.74	2149.95	2150.74	13254.0
2015-01-05 05:00:00	ES	Futures	2150.74	2152.06	2147.32	2147.85	12049.0
2015-01-05 06:00:00	ES	Futures	2147.85	2151.53	2147.32	2149.16	15954.0
2015-01-05 07:00:00	ES	Futures	2148.9	2151.27	2147.85	2149.42	14965.0
2015-01-05 08:00:00	ES	Futures	2149.42	2151.27	2141.79	2143.9	52956.0
2015-01-05 09:00:00	ES	Futures	2143.64	2147.85	2133.9	2134.69	268200.0
2015-01-05 10:00:00	ES	Futures	2134.42	2138.37	2127.58	2130.74	327279.0
2015-01-05 11:00:00	ES	Futures	2131.0	2131.79	2123.9	2129.69	276426.0
2015-01-05 12:00:00	ES	Futures	2129.69	2130.74	2118.64	2121.79	192690.0
2015-01-05 13:00:00	ES	Futures	2121.53	2123.9	2117.32	2122.06	168992.0
2015-01-05 14:00:00	ES	Futures	2122.06	2122.32	2115.48	2116.27	185135.0
2015-01-05 15:00:00	ES	Futures	2116.27	2126.0	2115.21	2120.21	311357.0
2015-01-05 16:00:00	ES	Futures	2120.21	2124.69	2118.11	2124.42	97295.0
2015-01-05 17:00:00	ES	Futures	2124.42	2124.69	2123.64	2124.16	1068.0
2015-01-05 18:00:00	ES	Futures	2125.21	2126.79	2124.16	2126.53	7154.0
2015-01-05 19:00:00	ES	Futures	2126.53	2126.53	2121.53	2122.06	7122.0
2015-01-05 20:00:00	ES	Futures	2122.32	2124.16	2122.32	2122.85	4527.0
2015-01-05 21:00:00	ES	Futures	2123.11	2124.95	2121.0	2123.64	5906.0
2015-01-05 22:00:00	ES	Futures	2123.9	2123.9	2120.74	2121.27	5333.0
2015-01-05 23:00:00	ES	Futures	2121.0	2121.27	2119.16	2120.21	3882.0
2015-01-05 00:00:00	NQ	Futures	4957.17	4958.34	4950.41	4950.71	1182.0
2015-01-05 01:00:00	NQ	Futures	4950.71	4953.05	4946.01	4946.01	459.0
2015-01-05 02:00:00	NQ	Futures	4946.3	4947.18	4940.43	4941.31	1386.0
2015-01-05 03:00:00	NQ	Futures	4941.89	4958.34	4941.31	4957.75	4101.0
2015-01-05 04:00:00	NQ	Futures	4957.46	4958.05	4942.78	4944.54	1866.0
2015-01-05 05:00:00	NQ	Futures	4944.54	4947.77	4937.78	4938.96	1938.0
2015-01-05 06:00:00	NQ	Futures	4938.66	4947.18	4937.49	4941.31	2514.0
2015-01-05 07:00:00	NQ	Futures	4941.31	4946.59	4939.25	4941.89	2278.0
2015-01-05 08:00:00	NQ	Futures	4941.89	4946.89	4928.39	4932.79	8940.0
2015-01-05 09:00:00	NQ	Futures	4932.5	4942.48	4913.99	4915.17	44780.0
2015-01-05 10:00:00	NQ	Futures	4915.17	4927.8	4899.9	4909.59	57304.0
2015-01-05 11:00:00	NQ	Futures	4909.59	4917.22	4892.26	4911.64	39726.0
2015-01-05 12:00:00	NQ	Futures	4911.64	4914.29	4885.8	4892.26	23636.0
2015-01-05 13:00:00	NQ	Futures	4892.56	4895.79	4878.46	4889.62	27914.0
2015-01-05 14:00:00	NQ	Futures	4889.62	4891.38	4869.35	4874.35	24066.0
2015-01-05 15:00:00	NQ	Futures	4874.05	4894.9	4871.41	4883.16	46757.0
2015-01-05 16:00:00	NQ	Futures	4883.16	4894.9	4879.05	4894.32	14012.0
2015-01-05 17:00:00	NQ	Futures	4894.32	4894.9	4892.26	4894.02	113.0
2015-01-05 18:00:00	NQ	Futures	4894.61	4897.84	4891.97	4896.96	1113.0
2015-01-05 19:00:00	NQ	Futures	4896.67	4896.96	4886.09	4886.97	1589.0
2015-01-05 20:00:00	NQ	Futures	4886.97	4893.44	4886.97	4890.5	954.0
2015-01-05 21:00:00	NQ	Futures	4890.21	4893.44	4884.33	4891.09	1174.0
2015-01-05 22:00:00	NQ	Futures	4890.79	4890.79	4883.45	4884.92	1160.0
2015-01-05 23:00:00	NQ	Futures	4884.92	4886.68	4881.1	4884.04	883.0
2015-01-05 00:00:00	YM	Futures	18520.5	18522.6	18496.5	18499.6	746.0
2015-01-05 01:00:00	YM	Futures	18499.6	18505.9	18479.8	18479.8	708.0

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

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