PREVIEW / futures_1hour / 2016-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-25.parquet
  size:    14 KB
  rows:    285

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-09-25 18:00:00	ES	Futures	2346.68	2349.95	2345.87	2349.67	5663.0
2016-09-25 19:00:00	ES	Futures	2349.67	2350.22	2348.86	2349.13	2311.0
2016-09-25 20:00:00	ES	Futures	2349.13	2350.22	2348.59	2349.13	3372.0
2016-09-25 21:00:00	ES	Futures	2349.13	2349.4	2344.5	2345.05	6799.0
2016-09-25 22:00:00	ES	Futures	2345.32	2345.87	2342.33	2344.78	9566.0
2016-09-25 23:00:00	ES	Futures	2344.78	2345.87	2343.69	2345.32	4189.0
2016-09-25 18:00:00	NQ	Futures	5790.08	5796.95	5788.0	5796.35	779.0
2016-09-25 19:00:00	NQ	Futures	5796.95	5799.03	5795.75	5796.35	360.0
2016-09-25 20:00:00	NQ	Futures	5796.95	5799.03	5795.16	5796.35	404.0
2016-09-25 21:00:00	NQ	Futures	5796.35	5796.35	5784.12	5785.31	1459.0
2016-09-25 22:00:00	NQ	Futures	5785.61	5787.4	5776.66	5783.22	1976.0
2016-09-25 23:00:00	NQ	Futures	5783.22	5786.21	5779.94	5783.82	724.0
2016-09-25 18:00:00	YM	Futures	19639.6	19667.7	19633.1	19666.6	873.0
2016-09-25 19:00:00	YM	Futures	19666.6	19673.1	19662.3	19664.5	293.0
2016-09-25 20:00:00	YM	Futures	19665.6	19673.1	19660.2	19667.7	504.0
2016-09-25 21:00:00	YM	Futures	19666.6	19667.7	19628.8	19633.1	1215.0
2016-09-25 22:00:00	YM	Futures	19633.1	19640.7	19611.5	19631.0	1251.0
2016-09-25 23:00:00	YM	Futures	19629.9	19639.6	19622.3	19635.3	667.0
2016-09-25 18:00:00	CL	Futures	44.79	45.12	44.74	45.07	6178.0
2016-09-25 19:00:00	CL	Futures	45.07	45.11	45.01	45.06	1386.0
2016-09-25 20:00:00	CL	Futures	45.06	45.1	45.02	45.06	1212.0
2016-09-25 21:00:00	CL	Futures	45.06	45.07	45.02	45.06	1474.0
2016-09-25 22:00:00	CL	Futures	45.05	45.07	44.91	44.97	2325.0
2016-09-25 23:00:00	CL	Futures	44.97	45.02	44.95	44.98	1447.0
2016-09-25 18:00:00	GC	Futures	1814.0	1816.2	1813.8	1815.9	840.0
2016-09-25 19:00:00	GC	Futures	1816.1	1816.7	1815.4	1816.1	499.0
2016-09-25 20:00:00	GC	Futures	1816.1	1818.2	1815.8	1816.9	1567.0
2016-09-25 21:00:00	GC	Futures	1816.9	1816.9	1812.1	1812.4	4251.0
2016-09-25 22:00:00	GC	Futures	1812.4	1813.2	1810.4	1810.5	2873.0
2016-09-25 23:00:00	GC	Futures	1810.5	1810.9	1808.2	1810.1	3471.0
2016-09-25 18:00:00	ZN	Futures	128.551063	128.566388	128.48976	128.551063	3777.0
2016-09-25 19:00:00	ZN	Futures	128.551063	128.551063	128.520411	128.535737	3774.0
2016-09-25 20:00:00	ZN	Futures	128.551063	128.551063	128.48976	128.520411	7439.0
2016-09-25 21:00:00	ZN	Futures	128.535737	128.551063	128.505086	128.535737	4297.0
2016-09-25 22:00:00	ZN	Futures	128.551063	128.551063	128.535737	128.535737	2218.0
2016-09-25 23:00:00	ZN	Futures	128.535737	128.551063	128.535737	128.535737	2042.0

> showing 36 of 285 rows — these rows as CSV

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