PREVIEW / futures_1hour / 2016-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-28.parquet
  size:    42 KB
  rows:    1,246

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-03-28 00:00:00	ES	Futures	2197.91	2198.18	2194.94	2196.02	3545.0
2016-03-28 01:00:00	ES	Futures	2196.02	2197.37	2195.48	2197.37	1671.0
2016-03-28 02:00:00	ES	Futures	2197.37	2197.64	2196.29	2196.83	1925.0
2016-03-28 03:00:00	ES	Futures	2196.83	2202.77	2196.56	2202.5	7735.0
2016-03-28 04:00:00	ES	Futures	2202.23	2202.5	2199.26	2199.26	4641.0
2016-03-28 05:00:00	ES	Futures	2199.53	2199.8	2198.18	2198.18	2825.0
2016-03-28 06:00:00	ES	Futures	2198.18	2198.72	2196.56	2196.56	2579.0
2016-03-28 07:00:00	ES	Futures	2196.56	2197.37	2194.94	2195.21	6422.0
2016-03-28 08:00:00	ES	Futures	2195.21	2196.02	2193.59	2194.4	15227.0
2016-03-28 09:00:00	ES	Futures	2194.4	2195.75	2187.65	2189.54	123440.0
2016-03-28 10:00:00	ES	Futures	2189.0	2191.97	2183.6	2187.11	155621.0
2016-03-28 11:00:00	ES	Futures	2187.38	2190.62	2184.68	2190.08	101515.0
2016-03-28 12:00:00	ES	Futures	2190.08	2194.4	2187.38	2193.86	83662.0
2016-03-28 13:00:00	ES	Futures	2194.13	2194.4	2191.43	2193.32	60108.0
2016-03-28 14:00:00	ES	Futures	2193.59	2196.56	2188.46	2190.08	102622.0
2016-03-28 15:00:00	ES	Futures	2189.81	2194.4	2188.19	2189.81	153795.0
2016-03-28 16:00:00	ES	Futures	2190.08	2191.97	2189.27	2190.08	48990.0
2016-03-28 18:00:00	ES	Futures	2189.81	2192.24	2188.73	2192.24	3396.0
2016-03-28 19:00:00	ES	Futures	2192.24	2192.24	2189.0	2189.54	2734.0
2016-03-28 20:00:00	ES	Futures	2189.54	2193.05	2189.27	2191.97	5262.0
2016-03-28 21:00:00	ES	Futures	2191.97	2196.02	2191.7	2194.94	9061.0
2016-03-28 22:00:00	ES	Futures	2194.94	2196.02	2191.97	2193.05	4919.0
2016-03-28 23:00:00	ES	Futures	2193.32	2193.86	2191.16	2192.78	4248.0
2016-03-28 00:00:00	NQ	Futures	5254.08	5254.67	5245.45	5247.83	846.0
2016-03-28 01:00:00	NQ	Futures	5247.83	5251.99	5247.53	5251.7	257.0
2016-03-28 02:00:00	NQ	Futures	5251.99	5252.89	5249.02	5249.61	314.0
2016-03-28 03:00:00	NQ	Futures	5249.91	5267.17	5249.02	5266.87	1190.0
2016-03-28 04:00:00	NQ	Futures	5266.57	5266.57	5256.46	5256.75	836.0
2016-03-28 05:00:00	NQ	Futures	5256.46	5258.54	5254.37	5254.97	336.0
2016-03-28 06:00:00	NQ	Futures	5254.67	5256.16	5247.83	5249.02	712.0
2016-03-28 07:00:00	NQ	Futures	5248.42	5251.7	5246.34	5247.23	832.0
2016-03-28 08:00:00	NQ	Futures	5246.94	5250.51	5245.75	5247.53	1767.0
2016-03-28 09:00:00	NQ	Futures	5247.53	5253.78	5214.51	5223.13	23237.0
2016-03-28 10:00:00	NQ	Futures	5223.43	5241.88	5219.27	5227.3	24799.0
2016-03-28 11:00:00	NQ	Futures	5227.3	5237.71	5220.75	5235.63	14627.0
2016-03-28 12:00:00	NQ	Futures	5235.63	5240.39	5225.51	5237.12	12311.0
2016-03-28 13:00:00	NQ	Futures	5237.42	5237.71	5225.81	5233.55	8821.0
2016-03-28 14:00:00	NQ	Futures	5233.55	5242.18	5216.89	5221.65	13694.0
2016-03-28 15:00:00	NQ	Futures	5221.65	5234.44	5219.27	5224.62	21870.0
2016-03-28 16:00:00	NQ	Futures	5224.62	5226.41	5222.84	5225.81	4330.0
2016-03-28 18:00:00	NQ	Futures	5224.32	5230.27	5221.35	5229.38	519.0
2016-03-28 19:00:00	NQ	Futures	5228.79	5229.38	5220.16	5220.75	358.0
2016-03-28 20:00:00	NQ	Futures	5221.35	5231.46	5220.75	5229.38	796.0
2016-03-28 21:00:00	NQ	Futures	5228.79	5239.2	5227.89	5235.33	1232.0
2016-03-28 22:00:00	NQ	Futures	5234.44	5239.2	5229.38	5232.65	757.0
2016-03-28 23:00:00	NQ	Futures	5232.95	5235.04	5227.0	5230.87	650.0
2016-03-28 00:00:00	YM	Futures	18724.3	18728.6	18705.1	18714.7	642.0
2016-03-28 01:00:00	YM	Futures	18712.6	18719.0	18707.2	18717.9	554.0
2016-03-28 02:00:00	YM	Futures	18717.9	18720.0	18709.3	18712.6	380.0
2016-03-28 03:00:00	YM	Futures	18713.6	18759.7	18711.5	18756.4	1576.0

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

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