PREVIEW / futures_1hour / 2015-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-04-09.parquet
  size:    51 KB
  rows:    1,550

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-04-09 00:00:00	ES	Futures	2192.18	2192.18	2190.86	2191.12	1731.0
2015-04-09 01:00:00	ES	Futures	2190.86	2191.39	2190.33	2190.59	2927.0
2015-04-09 02:00:00	ES	Futures	2190.59	2191.12	2189.8	2190.59	4373.0
2015-04-09 03:00:00	ES	Futures	2190.59	2191.91	2185.31	2186.37	17816.0
2015-04-09 04:00:00	ES	Futures	2186.1	2187.69	2183.99	2186.1	16086.0
2015-04-09 05:00:00	ES	Futures	2186.37	2189.01	2186.37	2187.16	8461.0
2015-04-09 06:00:00	ES	Futures	2187.42	2190.33	2186.9	2189.27	8133.0
2015-04-09 07:00:00	ES	Futures	2189.27	2195.08	2189.01	2194.03	16130.0
2015-04-09 08:00:00	ES	Futures	2194.03	2194.29	2189.27	2189.8	25997.0
2015-04-09 09:00:00	ES	Futures	2189.8	2199.04	2188.48	2192.18	199965.0
2015-04-09 10:00:00	ES	Futures	2191.91	2195.61	2185.57	2189.54	225595.0
2015-04-09 11:00:00	ES	Futures	2189.8	2192.18	2183.46	2190.59	144790.0
2015-04-09 12:00:00	ES	Futures	2190.86	2195.61	2190.06	2195.35	81455.0
2015-04-09 13:00:00	ES	Futures	2195.35	2196.93	2192.44	2193.5	78145.0
2015-04-09 14:00:00	ES	Futures	2193.5	2197.72	2192.44	2197.2	68241.0
2015-04-09 15:00:00	ES	Futures	2197.2	2204.86	2196.93	2202.21	225796.0
2015-04-09 16:00:00	ES	Futures	2202.21	2204.59	2201.16	2202.74	67055.0
2015-04-09 17:00:00	ES	Futures	2202.74	2204.06	2202.48	2204.06	1910.0
2015-04-09 18:00:00	ES	Futures	2203.8	2204.59	2202.74	2203.53	2706.0
2015-04-09 19:00:00	ES	Futures	2203.27	2203.8	2202.74	2203.01	1289.0
2015-04-09 20:00:00	ES	Futures	2203.27	2203.27	2201.16	2201.69	4702.0
2015-04-09 21:00:00	ES	Futures	2201.95	2202.21	2200.63	2201.16	2947.0
2015-04-09 22:00:00	ES	Futures	2201.16	2201.95	2200.89	2201.42	1882.0
2015-04-09 23:00:00	ES	Futures	2201.69	2202.48	2201.16	2201.42	1347.0
2015-04-09 00:00:00	NQ	Futures	5146.11	5146.11	5143.17	5143.76	330.0
2015-04-09 01:00:00	NQ	Futures	5143.47	5144.94	5141.99	5144.05	437.0
2015-04-09 02:00:00	NQ	Futures	5143.76	5144.05	5141.41	5143.47	543.0
2015-04-09 03:00:00	NQ	Futures	5143.76	5145.52	5127.59	5128.17	4096.0
2015-04-09 04:00:00	NQ	Futures	5128.17	5130.53	5123.17	5126.7	3767.0
2015-04-09 05:00:00	NQ	Futures	5126.7	5134.06	5126.7	5130.53	967.0
2015-04-09 06:00:00	NQ	Futures	5130.53	5139.05	5129.06	5135.82	1616.0
2015-04-09 07:00:00	NQ	Futures	5135.82	5150.23	5134.64	5147.58	4231.0
2015-04-09 08:00:00	NQ	Futures	5147.29	5149.05	5139.94	5143.17	5118.0
2015-04-09 09:00:00	NQ	Futures	5143.17	5163.76	5134.94	5146.99	40832.0
2015-04-09 10:00:00	NQ	Futures	5147.29	5154.64	5127.29	5136.41	39347.0
2015-04-09 11:00:00	NQ	Futures	5136.41	5140.82	5119.94	5137.58	21717.0
2015-04-09 12:00:00	NQ	Futures	5137.88	5155.23	5136.11	5151.7	15346.0
2015-04-09 13:00:00	NQ	Futures	5151.7	5154.93	5143.76	5147.88	10876.0
2015-04-09 14:00:00	NQ	Futures	5147.88	5157.29	5143.47	5155.52	10644.0
2015-04-09 15:00:00	NQ	Futures	5155.52	5174.05	5155.23	5172.28	33052.0
2015-04-09 16:00:00	NQ	Futures	5171.99	5176.99	5168.75	5174.05	6179.0
2015-04-09 17:00:00	NQ	Futures	5173.46	5175.52	5173.46	5175.52	111.0
2015-04-09 18:00:00	NQ	Futures	5174.34	5176.11	5171.11	5172.87	748.0
2015-04-09 19:00:00	NQ	Futures	5172.87	5173.17	5171.11	5171.99	161.0
2015-04-09 20:00:00	NQ	Futures	5171.99	5172.28	5168.46	5171.11	574.0
2015-04-09 21:00:00	NQ	Futures	5170.23	5171.7	5168.46	5170.52	387.0
2015-04-09 22:00:00	NQ	Futures	5170.23	5172.58	5169.05	5171.11	265.0
2015-04-09 23:00:00	NQ	Futures	5170.81	5173.17	5169.64	5170.81	180.0
2015-04-09 00:00:00	YM	Futures	18692.5	18693.5	18677.8	18682.0	374.0
2015-04-09 01:00:00	YM	Futures	18680.9	18684.1	18677.8	18680.9	388.0

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

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