PREVIEW / futures_1hour / 2016-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-27.parquet
  size:    14 KB
  rows:    273

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-27 18:00:00	ES	Futures	2192.51	2194.94	2192.24	2193.32	5544.0
2016-03-27 19:00:00	ES	Futures	2193.32	2195.75	2192.78	2195.48	2856.0
2016-03-27 20:00:00	ES	Futures	2195.48	2197.1	2194.4	2196.83	5453.0
2016-03-27 21:00:00	ES	Futures	2196.83	2197.37	2195.75	2197.1	3248.0
2016-03-27 22:00:00	ES	Futures	2197.1	2197.64	2196.56	2196.83	2006.0
2016-03-27 23:00:00	ES	Futures	2196.83	2197.64	2196.29	2197.64	1744.0
2016-03-27 18:00:00	NQ	Futures	5238.31	5246.04	5236.23	5241.28	749.0
2016-03-27 19:00:00	NQ	Futures	5241.88	5248.13	5240.99	5248.13	282.0
2016-03-27 20:00:00	NQ	Futures	5247.83	5251.99	5246.34	5250.8	825.0
2016-03-27 21:00:00	NQ	Futures	5251.7	5253.48	5249.02	5252.89	591.0
2016-03-27 22:00:00	NQ	Futures	5253.18	5255.27	5251.4	5251.4	348.0
2016-03-27 23:00:00	NQ	Futures	5251.7	5253.48	5251.1	5253.48	137.0
2016-03-27 18:00:00	YM	Futures	18693.3	18702.9	18682.6	18689.0	759.0
2016-03-27 19:00:00	YM	Futures	18689.0	18711.5	18686.9	18708.3	510.0
2016-03-27 20:00:00	YM	Futures	18710.4	18719.0	18697.6	18715.8	895.0
2016-03-27 21:00:00	YM	Futures	18714.7	18719.0	18705.1	18715.8	623.0
2016-03-27 22:00:00	YM	Futures	18717.9	18726.5	18714.7	18715.8	603.0
2016-03-27 23:00:00	YM	Futures	18715.8	18724.3	18711.5	18724.3	422.0
2016-03-27 18:00:00	CL	Futures	43.9	44.27	43.89	44.11	2841.0
2016-03-27 19:00:00	CL	Futures	44.11	44.14	44.07	44.13	1327.0
2016-03-27 20:00:00	CL	Futures	44.14	44.23	44.07	44.22	2008.0
2016-03-27 21:00:00	CL	Futures	44.22	44.29	44.17	44.23	2153.0
2016-03-27 22:00:00	CL	Futures	44.23	44.25	44.08	44.14	2291.0
2016-03-27 23:00:00	CL	Futures	44.14	44.19	44.11	44.13	686.0
2016-03-27 18:00:00	GC	Futures	1660.9	1661.9	1656.7	1657.9	620.0
2016-03-27 19:00:00	GC	Futures	1658.5	1659.1	1657.2	1657.6	209.0
2016-03-27 20:00:00	GC	Futures	1657.6	1658.6	1647.1	1653.7	1655.0
2016-03-27 21:00:00	GC	Futures	1653.8	1656.1	1651.4	1652.7	956.0
2016-03-27 22:00:00	GC	Futures	1652.7	1654.9	1652.2	1653.4	522.0
2016-03-27 23:00:00	GC	Futures	1653.4	1654.9	1653.1	1654.9	299.0
2016-03-27 18:00:00	ZN	Futures	125.769108	125.784323	125.693032	125.708247	2533.0
2016-03-27 19:00:00	ZN	Futures	125.693032	125.708247	125.616956	125.616956	2682.0
2016-03-27 20:00:00	ZN	Futures	125.616956	125.662601	125.616956	125.647386	1694.0
2016-03-27 21:00:00	ZN	Futures	125.647386	125.662601	125.616956	125.632171	1269.0
2016-03-27 22:00:00	ZN	Futures	125.632171	125.632171	125.60174	125.632171	2385.0
2016-03-27 23:00:00	ZN	Futures	125.616956	125.693032	125.616956	125.677817	2426.0

> showing 36 of 273 rows — these rows as CSV

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