PREVIEW / futures_1hour / 2016-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-09.parquet
  size:    15 KB
  rows:    290

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-10-09 18:00:00	ES	Futures	2342.06	2343.96	2340.7	2342.33	13485.0
2016-10-09 19:00:00	ES	Futures	2342.33	2342.6	2340.15	2341.24	4124.0
2016-10-09 20:00:00	ES	Futures	2341.24	2342.06	2340.42	2342.06	4160.0
2016-10-09 21:00:00	ES	Futures	2341.78	2345.05	2340.7	2341.24	9604.0
2016-10-09 22:00:00	ES	Futures	2341.24	2342.6	2340.97	2341.24	3146.0
2016-10-09 23:00:00	ES	Futures	2341.24	2342.6	2339.34	2342.06	6802.0
2016-10-09 18:00:00	NQ	Futures	5809.18	5816.64	5809.18	5813.06	1701.0
2016-10-09 19:00:00	NQ	Futures	5813.06	5813.35	5807.69	5809.48	682.0
2016-10-09 20:00:00	NQ	Futures	5809.77	5812.76	5807.98	5812.16	436.0
2016-10-09 21:00:00	NQ	Futures	5812.46	5818.43	5807.98	5809.48	1095.0
2016-10-09 22:00:00	NQ	Futures	5809.18	5812.16	5807.98	5808.88	298.0
2016-10-09 23:00:00	NQ	Futures	5809.18	5811.56	5805.0	5810.97	553.0
2016-10-09 18:00:00	YM	Futures	19650.4	19685.0	19650.4	19672.0	1721.0
2016-10-09 19:00:00	YM	Futures	19672.0	19672.0	19653.7	19658.0	635.0
2016-10-09 20:00:00	YM	Futures	19659.1	19671.0	19654.8	19671.0	932.0
2016-10-09 21:00:00	YM	Futures	19672.0	19690.4	19655.8	19659.1	1624.0
2016-10-09 22:00:00	YM	Futures	19659.1	19666.6	19656.9	19656.9	495.0
2016-10-09 23:00:00	YM	Futures	19658.0	19666.6	19641.8	19664.5	875.0
2016-10-09 18:00:00	CL	Futures	49.76	49.95	49.55	49.61	3710.0
2016-10-09 19:00:00	CL	Futures	49.61	49.68	49.34	49.48	8747.0
2016-10-09 20:00:00	CL	Futures	49.48	49.58	49.41	49.49	3559.0
2016-10-09 21:00:00	CL	Futures	49.49	49.54	49.39	49.39	2858.0
2016-10-09 22:00:00	CL	Futures	49.4	49.54	49.39	49.48	2034.0
2016-10-09 23:00:00	CL	Futures	49.49	49.57	49.47	49.55	2193.0
2016-10-09 18:00:00	GC	Futures	1702.7	1705.4	1702.7	1705.1	1866.0
2016-10-09 19:00:00	GC	Futures	1705.0	1709.9	1705.0	1707.6	3293.0
2016-10-09 20:00:00	GC	Futures	1707.4	1710.1	1706.3	1709.9	3444.0
2016-10-09 21:00:00	GC	Futures	1709.7	1713.1	1702.7	1705.8	15576.0
2016-10-09 22:00:00	GC	Futures	1705.7	1711.2	1705.0	1710.7	4680.0
2016-10-09 23:00:00	GC	Futures	1710.5	1711.9	1709.6	1710.5	3277.0
2016-10-09 18:00:00	ZN	Futures	127.616201	127.662178	127.570225	127.646853	10028.0
2016-10-09 19:00:00	ZN	Futures	127.646853	127.677504	127.616201	127.662178	2334.0
2016-10-09 20:00:00	ZN	Futures	127.662178	127.677504	127.58555	127.58555	5057.0
2016-10-09 21:00:00	ZN	Futures	127.58555	127.616201	127.539573	127.600876	6579.0
2016-10-09 22:00:00	ZN	Futures	127.600876	127.662178	127.58555	127.662178	1626.0
2016-10-09 23:00:00	ZN	Futures	127.662178	127.677504	127.600876	127.631527	4184.0

> showing 36 of 290 rows — these rows as CSV

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