PREVIEW / futures_1hour / 2015-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-09.parquet
  size:    53 KB
  rows:    1,570

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-07-09 00:00:00	ES	Futures	2183.77	2185.37	2182.97	2185.37	3930.0
2015-07-09 01:00:00	ES	Futures	2185.37	2187.23	2184.57	2186.96	8373.0
2015-07-09 02:00:00	ES	Futures	2187.23	2187.76	2182.7	2186.96	17034.0
2015-07-09 03:00:00	ES	Futures	2186.96	2189.09	2184.57	2185.9	27590.0
2015-07-09 04:00:00	ES	Futures	2186.16	2189.09	2185.9	2188.83	19142.0
2015-07-09 05:00:00	ES	Futures	2188.83	2193.09	2186.7	2191.76	27844.0
2015-07-09 06:00:00	ES	Futures	2191.76	2195.22	2191.22	2193.09	23131.0
2015-07-09 07:00:00	ES	Futures	2193.35	2195.75	2192.82	2194.42	37499.0
2015-07-09 08:00:00	ES	Futures	2194.15	2197.35	2193.62	2196.81	45174.0
2015-07-09 09:00:00	ES	Futures	2196.81	2202.41	2194.15	2196.55	322512.0
2015-07-09 10:00:00	ES	Futures	2196.81	2198.15	2187.23	2194.15	316785.0
2015-07-09 11:00:00	ES	Futures	2194.42	2196.81	2188.03	2188.29	188047.0
2015-07-09 12:00:00	ES	Futures	2188.03	2190.16	2184.83	2186.96	145084.0
2015-07-09 13:00:00	ES	Futures	2187.23	2188.03	2181.11	2184.83	143697.0
2015-07-09 14:00:00	ES	Futures	2184.57	2185.1	2176.31	2183.5	188250.0
2015-07-09 15:00:00	ES	Futures	2183.24	2186.16	2176.05	2176.31	284838.0
2015-07-09 16:00:00	ES	Futures	2176.05	2177.64	2170.72	2174.72	108610.0
2015-07-09 17:00:00	ES	Futures	2174.45	2174.98	2173.38	2173.92	2176.0
2015-07-09 18:00:00	ES	Futures	2177.64	2195.48	2177.64	2194.95	51063.0
2015-07-09 19:00:00	ES	Futures	2194.95	2195.75	2189.89	2190.96	8538.0
2015-07-09 20:00:00	ES	Futures	2190.69	2192.55	2186.7	2188.03	12853.0
2015-07-09 21:00:00	ES	Futures	2188.03	2195.75	2187.5	2193.89	13029.0
2015-07-09 22:00:00	ES	Futures	2193.89	2197.61	2193.89	2196.28	9821.0
2015-07-09 23:00:00	ES	Futures	2196.28	2200.01	2194.15	2199.21	11360.0
2015-07-09 00:00:00	NQ	Futures	5171.29	5176.61	5169.22	5175.72	633.0
2015-07-09 01:00:00	NQ	Futures	5176.02	5181.64	5174.54	5180.75	1303.0
2015-07-09 02:00:00	NQ	Futures	5181.05	5181.64	5170.1	5178.68	2203.0
2015-07-09 03:00:00	NQ	Futures	5179.57	5187.55	5173.95	5179.86	4712.0
2015-07-09 04:00:00	NQ	Futures	5179.57	5186.67	5177.79	5185.48	2215.0
2015-07-09 05:00:00	NQ	Futures	5185.78	5196.13	5181.34	5193.47	3624.0
2015-07-09 06:00:00	NQ	Futures	5193.47	5204.71	5191.1	5199.09	3863.0
2015-07-09 07:00:00	NQ	Futures	5198.79	5202.94	5197.02	5201.16	4967.0
2015-07-09 08:00:00	NQ	Futures	5200.87	5204.41	5198.79	5203.53	4958.0
2015-07-09 09:00:00	NQ	Futures	5203.53	5215.36	5191.99	5202.05	42464.0
2015-07-09 10:00:00	NQ	Futures	5201.75	5206.19	5179.86	5195.25	37906.0
2015-07-09 11:00:00	NQ	Futures	5194.95	5203.23	5178.39	5179.27	22069.0
2015-07-09 12:00:00	NQ	Futures	5178.98	5185.48	5174.24	5179.57	19695.0
2015-07-09 13:00:00	NQ	Futures	5179.57	5181.64	5160.34	5166.85	19922.0
2015-07-09 14:00:00	NQ	Futures	5166.85	5168.62	5138.45	5156.2	32163.0
2015-07-09 15:00:00	NQ	Futures	5156.2	5164.48	5138.45	5138.45	34354.0
2015-07-09 16:00:00	NQ	Futures	5138.45	5142.3	5125.14	5135.79	12619.0
2015-07-09 17:00:00	NQ	Futures	5135.2	5136.09	5133.72	5134.31	216.0
2015-07-09 18:00:00	NQ	Futures	5141.71	5184.6	5141.71	5182.53	6321.0
2015-07-09 19:00:00	NQ	Futures	5182.82	5183.71	5170.4	5172.47	1104.0
2015-07-09 20:00:00	NQ	Futures	5172.17	5175.72	5161.23	5165.67	1778.0
2015-07-09 21:00:00	NQ	Futures	5165.37	5184.3	5164.48	5178.98	1715.0
2015-07-09 22:00:00	NQ	Futures	5179.27	5188.15	5178.39	5183.71	1655.0
2015-07-09 23:00:00	NQ	Futures	5183.41	5193.17	5178.68	5191.7	1197.0
2015-07-09 00:00:00	YM	Futures	18457.7	18475.6	18454.5	18474.5	611.0
2015-07-09 01:00:00	YM	Futures	18474.5	18491.4	18468.2	18490.3	1107.0

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

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