PREVIEW / futures_1hour / 2016-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-20.parquet
  size:    53 KB
  rows:    1,623

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
2016-06-20 00:00:00	ES	Futures	2260.07	2260.34	2257.63	2258.71	7973.0
2016-06-20 01:00:00	ES	Futures	2258.44	2259.25	2257.08	2257.63	5060.0
2016-06-20 02:00:00	ES	Futures	2257.9	2262.78	2257.63	2259.53	26531.0
2016-06-20 03:00:00	ES	Futures	2259.53	2262.24	2258.17	2258.44	37561.0
2016-06-20 04:00:00	ES	Futures	2258.71	2263.05	2257.9	2262.78	24847.0
2016-06-20 05:00:00	ES	Futures	2262.78	2263.86	2260.07	2262.51	21609.0
2016-06-20 06:00:00	ES	Futures	2262.51	2263.86	2261.69	2263.05	16979.0
2016-06-20 07:00:00	ES	Futures	2263.05	2264.41	2262.51	2263.59	22714.0
2016-06-20 08:00:00	ES	Futures	2263.59	2264.14	2261.42	2261.97	28376.0
2016-06-20 09:00:00	ES	Futures	2261.97	2266.85	2259.53	2264.41	244972.0
2016-06-20 10:00:00	ES	Futures	2264.41	2269.83	2263.59	2265.22	212299.0
2016-06-20 11:00:00	ES	Futures	2265.22	2266.85	2260.07	2262.51	143170.0
2016-06-20 12:00:00	ES	Futures	2262.24	2263.86	2260.07	2262.51	82445.0
2016-06-20 13:00:00	ES	Futures	2262.78	2263.59	2258.17	2261.42	112987.0
2016-06-20 14:00:00	ES	Futures	2261.69	2261.97	2257.08	2260.88	109498.0
2016-06-20 15:00:00	ES	Futures	2260.88	2261.42	2249.49	2250.85	299194.0
2016-06-20 16:00:00	ES	Futures	2251.12	2259.8	2246.78	2259.25	114071.0
2016-06-20 18:00:00	ES	Futures	2255.19	2255.73	2253.02	2255.46	9310.0
2016-06-20 19:00:00	ES	Futures	2255.46	2255.73	2253.29	2253.83	3550.0
2016-06-20 20:00:00	ES	Futures	2253.83	2256.0	2250.03	2252.75	15053.0
2016-06-20 21:00:00	ES	Futures	2252.75	2258.17	2252.2	2257.9	8712.0
2016-06-20 22:00:00	ES	Futures	2258.17	2258.44	2254.37	2254.64	6888.0
2016-06-20 23:00:00	ES	Futures	2254.92	2256.81	2254.37	2256.27	2586.0
2016-06-20 00:00:00	NQ	Futures	5259.42	5260.01	5254.95	5257.63	1114.0
2016-06-20 01:00:00	NQ	Futures	5257.93	5258.52	5252.56	5253.75	400.0
2016-06-20 02:00:00	NQ	Futures	5254.05	5266.87	5254.05	5256.44	5158.0
2016-06-20 03:00:00	NQ	Futures	5256.44	5266.57	5253.75	5254.35	5150.0
2016-06-20 04:00:00	NQ	Futures	5254.35	5266.57	5252.26	5266.27	2727.0
2016-06-20 05:00:00	NQ	Futures	5266.27	5267.76	5257.03	5263.29	2389.0
2016-06-20 06:00:00	NQ	Futures	5263.29	5266.87	5262.1	5264.19	1546.0
2016-06-20 07:00:00	NQ	Futures	5264.19	5270.15	5263.59	5267.17	3020.0
2016-06-20 08:00:00	NQ	Futures	5266.57	5268.06	5263.59	5264.78	3736.0
2016-06-20 09:00:00	NQ	Futures	5264.78	5276.7	5260.91	5273.72	33969.0
2016-06-20 10:00:00	NQ	Futures	5273.72	5288.33	5273.72	5285.94	27867.0
2016-06-20 11:00:00	NQ	Futures	5285.94	5289.52	5270.45	5276.41	17885.0
2016-06-20 12:00:00	NQ	Futures	5276.11	5280.88	5270.45	5277.3	11106.0
2016-06-20 13:00:00	NQ	Futures	5277.3	5279.09	5265.38	5271.34	12523.0
2016-06-20 14:00:00	NQ	Futures	5271.34	5271.94	5260.31	5268.96	12117.0
2016-06-20 15:00:00	NQ	Futures	5268.96	5269.55	5232.0	5236.17	34749.0
2016-06-20 16:00:00	NQ	Futures	5235.87	5255.54	5227.82	5254.95	9102.0
2016-06-20 18:00:00	NQ	Futures	5243.92	5245.41	5239.75	5245.11	832.0
2016-06-20 19:00:00	NQ	Futures	5245.11	5245.11	5239.15	5240.04	452.0
2016-06-20 20:00:00	NQ	Futures	5240.34	5245.71	5231.7	5237.96	1877.0
2016-06-20 21:00:00	NQ	Futures	5237.36	5251.97	5236.47	5251.67	1101.0
2016-06-20 22:00:00	NQ	Futures	5251.67	5252.56	5241.24	5242.43	1089.0
2016-06-20 23:00:00	NQ	Futures	5242.73	5246.6	5240.94	5246.6	402.0
2016-06-20 00:00:00	YM	Futures	19096.2	19098.3	19081.1	19087.6	792.0
2016-06-20 01:00:00	YM	Futures	19087.6	19091.9	19074.7	19077.9	1073.0
2016-06-20 02:00:00	YM	Futures	19079.0	19118.8	19079.0	19096.2	2809.0
2016-06-20 03:00:00	YM	Futures	19095.1	19118.8	19084.3	19095.1	4347.0

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

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