PREVIEW / futures_1hour / 2016-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-11.parquet
  size:    52 KB
  rows:    1,611

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-05-11 00:00:00	ES	Futures	2238.94	2240.29	2238.94	2240.02	2531.0
2016-05-11 01:00:00	ES	Futures	2240.02	2240.29	2238.67	2239.75	3790.0
2016-05-11 02:00:00	ES	Futures	2239.75	2241.64	2239.21	2239.75	10500.0
2016-05-11 03:00:00	ES	Futures	2239.75	2241.64	2235.43	2237.05	39683.0
2016-05-11 04:00:00	ES	Futures	2237.32	2239.48	2234.89	2238.94	25307.0
2016-05-11 05:00:00	ES	Futures	2238.94	2239.75	2237.05	2239.21	12025.0
2016-05-11 06:00:00	ES	Futures	2239.21	2239.48	2237.32	2238.94	11925.0
2016-05-11 07:00:00	ES	Futures	2238.94	2240.83	2238.4	2240.56	16674.0
2016-05-11 08:00:00	ES	Futures	2240.29	2241.91	2239.48	2241.64	26881.0
2016-05-11 09:00:00	ES	Futures	2241.37	2241.91	2236.78	2237.32	156585.0
2016-05-11 10:00:00	ES	Futures	2237.59	2244.61	2235.97	2240.29	266923.0
2016-05-11 11:00:00	ES	Futures	2240.29	2240.29	2234.08	2235.97	187667.0
2016-05-11 12:00:00	ES	Futures	2235.97	2238.4	2234.35	2235.7	76142.0
2016-05-11 13:00:00	ES	Futures	2235.97	2236.78	2231.65	2231.92	94769.0
2016-05-11 14:00:00	ES	Futures	2232.19	2232.19	2225.98	2227.06	146395.0
2016-05-11 15:00:00	ES	Futures	2227.06	2229.49	2224.37	2225.18	264842.0
2016-05-11 16:00:00	ES	Futures	2224.91	2225.18	2221.94	2223.83	76939.0
2016-05-11 18:00:00	ES	Futures	2223.56	2225.18	2222.75	2224.91	4211.0
2016-05-11 19:00:00	ES	Futures	2224.91	2225.72	2224.1	2224.37	3557.0
2016-05-11 20:00:00	ES	Futures	2224.64	2225.72	2223.83	2225.18	4362.0
2016-05-11 21:00:00	ES	Futures	2225.18	2226.79	2221.94	2223.02	13152.0
2016-05-11 22:00:00	ES	Futures	2223.02	2225.72	2222.75	2225.72	5934.0
2016-05-11 23:00:00	ES	Futures	2225.45	2226.52	2225.18	2225.45	4307.0
2016-05-11 00:00:00	NQ	Futures	5218.08	5220.46	5217.48	5218.67	548.0
2016-05-11 01:00:00	NQ	Futures	5218.67	5219.86	5215.4	5218.37	529.0
2016-05-11 02:00:00	NQ	Futures	5218.08	5222.84	5216.89	5218.67	1207.0
2016-05-11 03:00:00	NQ	Futures	5218.67	5222.84	5207.07	5211.53	5260.0
2016-05-11 04:00:00	NQ	Futures	5211.83	5218.08	5207.07	5216.59	2375.0
2016-05-11 05:00:00	NQ	Futures	5216.29	5217.78	5211.83	5215.7	1755.0
2016-05-11 06:00:00	NQ	Futures	5215.99	5217.18	5212.72	5216.59	1346.0
2016-05-11 07:00:00	NQ	Futures	5217.18	5220.46	5215.4	5219.86	1765.0
2016-05-11 08:00:00	NQ	Futures	5219.56	5225.22	5218.37	5224.62	3370.0
2016-05-11 09:00:00	NQ	Futures	5224.32	5227.0	5214.51	5226.11	30819.0
2016-05-11 10:00:00	NQ	Futures	5225.81	5240.09	5221.35	5222.84	39238.0
2016-05-11 11:00:00	NQ	Futures	5222.84	5222.84	5207.66	5213.91	28028.0
2016-05-11 12:00:00	NQ	Futures	5213.32	5221.35	5209.45	5215.7	13438.0
2016-05-11 13:00:00	NQ	Futures	5215.7	5216.29	5201.41	5201.41	15048.0
2016-05-11 14:00:00	NQ	Futures	5201.41	5203.5	5187.13	5192.49	21845.0
2016-05-11 15:00:00	NQ	Futures	5192.49	5199.33	5182.97	5185.05	28036.0
2016-05-11 16:00:00	NQ	Futures	5185.35	5185.94	5177.91	5179.69	7241.0
2016-05-11 18:00:00	NQ	Futures	5179.99	5182.67	5172.55	5181.48	948.0
2016-05-11 19:00:00	NQ	Futures	5181.78	5182.97	5179.69	5181.18	533.0
2016-05-11 20:00:00	NQ	Futures	5181.18	5183.86	5179.1	5182.37	664.0
2016-05-11 21:00:00	NQ	Futures	5182.67	5187.43	5174.64	5175.23	1590.0
2016-05-11 22:00:00	NQ	Futures	5175.23	5184.75	5175.23	5183.86	1359.0
2016-05-11 23:00:00	NQ	Futures	5184.46	5186.54	5182.67	5184.16	1068.0
2016-05-11 00:00:00	YM	Futures	19059.4	19071.1	19058.3	19065.8	686.0
2016-05-11 01:00:00	YM	Futures	19065.8	19069.0	19060.4	19064.7	764.0
2016-05-11 02:00:00	YM	Futures	19065.8	19082.9	19062.6	19069.0	2007.0
2016-05-11 03:00:00	YM	Futures	19069.0	19082.9	19029.4	19046.5	6989.0

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

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