PREVIEW / futures_1hour / 2016-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-16.parquet
  size:    56 KB
  rows:    1,642

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-16 00:00:00	ES	Futures	2232.68	2233.49	2228.07	2229.97	11569.0
2016-06-16 01:00:00	ES	Futures	2229.97	2230.51	2228.61	2230.24	8578.0
2016-06-16 02:00:00	ES	Futures	2229.97	2230.24	2225.63	2226.98	26071.0
2016-06-16 03:00:00	ES	Futures	2226.98	2232.14	2225.9	2229.69	51234.0
2016-06-16 04:00:00	ES	Futures	2229.69	2231.59	2227.8	2230.78	27826.0
2016-06-16 05:00:00	ES	Futures	2230.78	2232.41	2229.69	2231.86	19175.0
2016-06-16 06:00:00	ES	Futures	2231.86	2232.41	2229.97	2231.05	18970.0
2016-06-16 07:00:00	ES	Futures	2230.78	2231.05	2226.44	2228.61	37043.0
2016-06-16 08:00:00	ES	Futures	2228.34	2229.15	2225.63	2227.8	34453.0
2016-06-16 09:00:00	ES	Futures	2227.8	2228.34	2217.49	2217.49	242425.0
2016-06-16 10:00:00	ES	Futures	2217.76	2220.47	2213.69	2219.39	319860.0
2016-06-16 11:00:00	ES	Futures	2219.66	2229.15	2218.85	2221.56	267006.0
2016-06-16 12:00:00	ES	Futures	2221.56	2237.56	2219.93	2233.22	288772.0
2016-06-16 13:00:00	ES	Futures	2233.49	2237.56	2229.42	2230.78	235173.0
2016-06-16 14:00:00	ES	Futures	2230.51	2242.44	2229.97	2238.92	232464.0
2016-06-16 15:00:00	ES	Futures	2238.92	2247.05	2238.1	2245.42	285307.0
2016-06-16 16:00:00	ES	Futures	2245.15	2246.78	2244.07	2244.88	80224.0
2016-06-16 18:00:00	ES	Futures	2244.07	2246.78	2243.53	2245.69	4116.0
2016-06-16 19:00:00	ES	Futures	2245.42	2248.95	2245.42	2248.95	5340.0
2016-06-16 20:00:00	ES	Futures	2248.68	2250.58	2247.05	2249.22	11177.0
2016-06-16 21:00:00	ES	Futures	2249.22	2250.03	2247.05	2248.14	6797.0
2016-06-16 22:00:00	ES	Futures	2248.41	2249.76	2247.59	2248.95	4824.0
2016-06-16 23:00:00	ES	Futures	2248.95	2249.76	2247.59	2248.41	4354.0
2016-06-16 00:00:00	NQ	Futures	5236.47	5239.45	5226.93	5231.1	1269.0
2016-06-16 01:00:00	NQ	Futures	5231.1	5232.3	5226.93	5229.61	1092.0
2016-06-16 02:00:00	NQ	Futures	5229.61	5230.8	5214.71	5218.88	5861.0
2016-06-16 03:00:00	NQ	Futures	5218.88	5232.0	5215.31	5225.14	5212.0
2016-06-16 04:00:00	NQ	Futures	5225.44	5230.51	5221.27	5227.82	2602.0
2016-06-16 05:00:00	NQ	Futures	5227.82	5233.49	5225.14	5232.59	1902.0
2016-06-16 06:00:00	NQ	Futures	5232.89	5235.28	5229.31	5232.0	2068.0
2016-06-16 07:00:00	NQ	Futures	5232.0	5232.3	5222.16	5226.33	3995.0
2016-06-16 08:00:00	NQ	Futures	5226.04	5229.31	5220.67	5227.23	4205.0
2016-06-16 09:00:00	NQ	Futures	5227.53	5228.42	5203.98	5205.17	35787.0
2016-06-16 10:00:00	NQ	Futures	5204.87	5208.75	5189.08	5198.02	45631.0
2016-06-16 11:00:00	NQ	Futures	5197.72	5217.39	5196.53	5200.4	33621.0
2016-06-16 12:00:00	NQ	Futures	5200.4	5242.73	5196.83	5237.36	45039.0
2016-06-16 13:00:00	NQ	Futures	5237.66	5247.5	5228.12	5230.21	34119.0
2016-06-16 14:00:00	NQ	Futures	5230.21	5255.25	5228.72	5247.2	30563.0
2016-06-16 15:00:00	NQ	Futures	5247.5	5270.74	5246.6	5265.68	35384.0
2016-06-16 16:00:00	NQ	Futures	5265.38	5267.76	5262.4	5263.89	5561.0
2016-06-16 18:00:00	NQ	Futures	5263.89	5268.36	5262.99	5266.57	412.0
2016-06-16 19:00:00	NQ	Futures	5266.57	5277.0	5265.68	5276.7	1109.0
2016-06-16 20:00:00	NQ	Futures	5276.7	5284.45	5274.32	5281.18	2387.0
2016-06-16 21:00:00	NQ	Futures	5281.18	5282.67	5274.02	5277.3	1111.0
2016-06-16 22:00:00	NQ	Futures	5277.3	5280.28	5274.32	5277.3	768.0
2016-06-16 23:00:00	NQ	Futures	5277.6	5281.77	5274.32	5274.92	782.0
2016-06-16 00:00:00	YM	Futures	18844.3	18849.7	18814.2	18825.0	1805.0
2016-06-16 01:00:00	YM	Futures	18825.0	18830.4	18814.2	18826.1	1596.0
2016-06-16 02:00:00	YM	Futures	18827.1	18829.3	18793.8	18807.8	3045.0
2016-06-16 03:00:00	YM	Futures	18806.7	18840.0	18797.0	18820.7	5532.0

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

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