PREVIEW / futures_1hour / 2016-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-17.parquet
  size:    15 KB
  rows:    295

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-04-17 18:00:00	ES	Futures	2229.22	2231.65	2226.79	2229.76	22428.0
2016-04-17 19:00:00	ES	Futures	2229.76	2230.84	2227.87	2228.14	7202.0
2016-04-17 20:00:00	ES	Futures	2227.87	2228.95	2225.45	2225.45	15892.0
2016-04-17 21:00:00	ES	Futures	2225.45	2230.3	2225.45	2227.33	12853.0
2016-04-17 22:00:00	ES	Futures	2227.06	2228.41	2226.79	2227.6	4722.0
2016-04-17 23:00:00	ES	Futures	2227.6	2228.68	2226.79	2227.6	3488.0
2016-04-17 18:00:00	NQ	Futures	5377.85	5378.15	5363.57	5373.09	2685.0
2016-04-17 19:00:00	NQ	Futures	5372.49	5375.77	5365.65	5365.65	1184.0
2016-04-17 20:00:00	NQ	Futures	5366.25	5368.92	5360.89	5361.19	2468.0
2016-04-17 21:00:00	NQ	Futures	5360.89	5372.79	5360.3	5365.35	1455.0
2016-04-17 22:00:00	NQ	Futures	5365.65	5368.33	5363.87	5365.06	928.0
2016-04-17 23:00:00	NQ	Futures	5364.46	5368.03	5363.27	5365.35	460.0
2016-04-17 18:00:00	YM	Futures	18982.3	18989.8	18951.3	18974.8	3163.0
2016-04-17 19:00:00	YM	Futures	18976.9	18986.6	18963.0	18966.2	906.0
2016-04-17 20:00:00	YM	Futures	18964.1	18970.5	18950.2	18951.3	1527.0
2016-04-17 21:00:00	YM	Futures	18950.2	18984.4	18948.0	18964.1	1342.0
2016-04-17 22:00:00	YM	Futures	18963.0	18970.5	18960.9	18963.0	529.0
2016-04-17 23:00:00	YM	Futures	18962.0	18970.5	18957.7	18964.1	402.0
2016-04-17 18:00:00	CL	Futures	42.87	42.98	41.9	42.36	25670.0
2016-04-17 19:00:00	CL	Futures	42.37	42.51	42.34	42.46	5688.0
2016-04-17 20:00:00	CL	Futures	42.44	42.47	42.33	42.43	4501.0
2016-04-17 21:00:00	CL	Futures	42.43	42.98	42.41	42.83	9889.0
2016-04-17 22:00:00	CL	Futures	42.83	42.86	42.55	42.67	3905.0
2016-04-17 23:00:00	CL	Futures	42.67	42.8	42.66	42.75	2201.0
2016-04-17 18:00:00	GC	Futures	1686.1	1692.8	1685.9	1691.1	3815.0
2016-04-17 19:00:00	GC	Futures	1691.1	1691.1	1687.1	1689.4	2115.0
2016-04-17 20:00:00	GC	Futures	1689.7	1693.0	1688.3	1688.6	4547.0
2016-04-17 21:00:00	GC	Futures	1688.6	1689.7	1684.5	1686.6	5955.0
2016-04-17 22:00:00	GC	Futures	1686.4	1688.2	1685.6	1685.9	3128.0
2016-04-17 23:00:00	GC	Futures	1685.7	1686.8	1685.2	1686.0	1461.0
2016-04-17 18:00:00	ZN	Futures	127.427568	127.427568	127.351492	127.427568	15129.0
2016-04-17 19:00:00	ZN	Futures	127.412353	127.442784	127.397138	127.412353	9918.0
2016-04-17 20:00:00	ZN	Futures	127.427568	127.457999	127.412353	127.442784	13302.0
2016-04-17 21:00:00	ZN	Futures	127.442784	127.442784	127.366707	127.412353	13339.0
2016-04-17 22:00:00	ZN	Futures	127.427568	127.442784	127.412353	127.427568	5075.0
2016-04-17 23:00:00	ZN	Futures	127.442784	127.457999	127.412353	127.442784	7764.0

> showing 36 of 295 rows — these rows as CSV

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