PREVIEW / futures_1hour / 2015-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-21.parquet
  size:    50 KB
  rows:    1,558

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-05-21 00:00:00	ES	Futures	2238.13	2238.66	2237.87	2238.4	1250.0
2015-05-21 01:00:00	ES	Futures	2238.4	2239.19	2238.13	2238.93	1714.0
2015-05-21 02:00:00	ES	Futures	2238.93	2239.72	2237.34	2238.4	6603.0
2015-05-21 03:00:00	ES	Futures	2238.4	2239.45	2236.02	2237.08	13299.0
2015-05-21 04:00:00	ES	Futures	2237.08	2239.19	2236.81	2236.81	11931.0
2015-05-21 05:00:00	ES	Futures	2236.81	2238.13	2236.81	2237.61	7164.0
2015-05-21 06:00:00	ES	Futures	2237.87	2238.4	2236.81	2237.61	8423.0
2015-05-21 07:00:00	ES	Futures	2237.87	2240.51	2237.87	2239.72	10172.0
2015-05-21 08:00:00	ES	Futures	2239.98	2239.98	2238.13	2239.72	15488.0
2015-05-21 09:00:00	ES	Futures	2239.45	2243.94	2238.93	2242.89	114842.0
2015-05-21 10:00:00	ES	Futures	2242.62	2248.17	2241.57	2246.59	108117.0
2015-05-21 11:00:00	ES	Futures	2246.85	2250.81	2246.59	2249.49	109354.0
2015-05-21 12:00:00	ES	Futures	2249.76	2251.08	2248.17	2249.23	43990.0
2015-05-21 13:00:00	ES	Futures	2249.23	2250.28	2245.79	2246.32	53058.0
2015-05-21 14:00:00	ES	Futures	2246.59	2250.55	2245.79	2249.49	51558.0
2015-05-21 15:00:00	ES	Futures	2249.23	2252.4	2246.32	2249.23	152236.0
2015-05-21 16:00:00	ES	Futures	2249.49	2250.02	2247.38	2248.96	52239.0
2015-05-21 17:00:00	ES	Futures	2248.96	2249.23	2248.7	2248.96	1330.0
2015-05-21 18:00:00	ES	Futures	2249.49	2250.02	2247.64	2248.96	2332.0
2015-05-21 19:00:00	ES	Futures	2248.96	2249.23	2247.11	2247.91	1567.0
2015-05-21 20:00:00	ES	Futures	2247.64	2248.43	2247.38	2247.64	2657.0
2015-05-21 21:00:00	ES	Futures	2247.91	2248.7	2247.38	2248.43	2186.0
2015-05-21 22:00:00	ES	Futures	2248.43	2250.81	2248.43	2249.76	3237.0
2015-05-21 23:00:00	ES	Futures	2250.02	2250.02	2249.23	2250.02	2223.0
2015-05-21 00:00:00	NQ	Futures	5286.38	5286.97	5285.2	5286.09	149.0
2015-05-21 01:00:00	NQ	Futures	5286.09	5288.14	5285.2	5287.56	207.0
2015-05-21 02:00:00	NQ	Futures	5287.56	5290.5	5283.73	5286.38	591.0
2015-05-21 03:00:00	NQ	Futures	5286.38	5288.73	5279.32	5281.38	1822.0
2015-05-21 04:00:00	NQ	Futures	5281.68	5287.26	5280.2	5281.09	1184.0
2015-05-21 05:00:00	NQ	Futures	5281.09	5283.44	5280.2	5281.09	909.0
2015-05-21 06:00:00	NQ	Futures	5281.09	5283.44	5279.03	5281.97	881.0
2015-05-21 07:00:00	NQ	Futures	5282.26	5289.91	5282.26	5288.73	1245.0
2015-05-21 08:00:00	NQ	Futures	5289.03	5289.61	5284.03	5286.97	3034.0
2015-05-21 09:00:00	NQ	Futures	5287.26	5299.61	5283.73	5297.55	17752.0
2015-05-21 10:00:00	NQ	Futures	5297.55	5322.55	5295.79	5319.9	21973.0
2015-05-21 11:00:00	NQ	Futures	5320.2	5331.67	5320.2	5326.67	18233.0
2015-05-21 12:00:00	NQ	Futures	5326.67	5333.14	5324.61	5328.14	10042.0
2015-05-21 13:00:00	NQ	Futures	5328.73	5330.78	5317.26	5319.9	10629.0
2015-05-21 14:00:00	NQ	Futures	5320.2	5332.25	5318.14	5329.31	8800.0
2015-05-21 15:00:00	NQ	Futures	5329.31	5336.08	5321.08	5328.43	19229.0
2015-05-21 16:00:00	NQ	Futures	5328.73	5329.9	5325.78	5327.55	3233.0
2015-05-21 17:00:00	NQ	Futures	5327.25	5328.43	5326.96	5328.43	179.0
2015-05-21 18:00:00	NQ	Futures	5329.02	5330.78	5325.78	5328.43	361.0
2015-05-21 19:00:00	NQ	Futures	5328.14	5329.02	5325.49	5326.37	219.0
2015-05-21 20:00:00	NQ	Futures	5326.37	5328.43	5326.08	5326.67	251.0
2015-05-21 21:00:00	NQ	Futures	5326.96	5329.31	5326.37	5328.73	233.0
2015-05-21 22:00:00	NQ	Futures	5329.02	5332.25	5327.25	5330.49	437.0
2015-05-21 23:00:00	NQ	Futures	5331.08	5331.67	5329.9	5331.37	221.0
2015-05-21 00:00:00	YM	Futures	19111.9	19116.1	19111.9	19114.0	346.0
2015-05-21 01:00:00	YM	Futures	19115.1	19123.5	19114.0	19121.4	362.0

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

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