PREVIEW / futures_1hour / 2014-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-09.parquet
  size:    14 KB
  rows:    276

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
2014-11-09 18:00:00	ES	Futures	2122.72	2124.29	2120.63	2124.03	4762.0
2014-11-09 19:00:00	ES	Futures	2123.77	2123.77	2120.89	2122.72	4599.0
2014-11-09 20:00:00	ES	Futures	2122.98	2126.65	2122.98	2125.34	7059.0
2014-11-09 21:00:00	ES	Futures	2125.08	2125.6	2124.29	2125.6	2200.0
2014-11-09 22:00:00	ES	Futures	2125.6	2125.6	2124.29	2124.82	1824.0
2014-11-09 23:00:00	ES	Futures	2124.82	2126.65	2123.51	2123.77	3106.0
2014-11-09 18:00:00	NQ	Futures	4867.12	4869.46	4861.84	4868.58	765.0
2014-11-09 19:00:00	NQ	Futures	4868.88	4869.17	4862.43	4867.41	697.0
2014-11-09 20:00:00	NQ	Futures	4867.7	4875.62	4867.7	4872.39	1180.0
2014-11-09 21:00:00	NQ	Futures	4873.27	4874.74	4871.51	4874.15	363.0
2014-11-09 22:00:00	NQ	Futures	4874.15	4874.15	4871.81	4872.98	450.0
2014-11-09 23:00:00	NQ	Futures	4872.39	4875.32	4870.05	4870.93	544.0
2014-11-09 18:00:00	YM	Futures	18194.8	18207.3	18185.5	18206.3	1137.0
2014-11-09 19:00:00	YM	Futures	18204.2	18205.2	18181.3	18196.9	683.0
2014-11-09 20:00:00	YM	Futures	18199.0	18237.4	18197.9	18221.8	1569.0
2014-11-09 21:00:00	YM	Futures	18223.9	18225.0	18215.6	18225.0	502.0
2014-11-09 22:00:00	YM	Futures	18222.9	18225.0	18217.7	18221.8	271.0
2014-11-09 23:00:00	YM	Futures	18219.8	18231.2	18208.3	18211.5	497.0
2014-11-09 18:00:00	CL	Futures	132.08	132.65	131.82	132.48	1815.0
2014-11-09 19:00:00	CL	Futures	132.46	132.82	132.43	132.61	949.0
2014-11-09 20:00:00	CL	Futures	132.6	132.92	132.58	132.9	713.0
2014-11-09 21:00:00	CL	Futures	132.9	133.09	132.83	132.9	924.0
2014-11-09 22:00:00	CL	Futures	132.9	132.9	132.7	132.78	510.0
2014-11-09 23:00:00	CL	Futures	132.78	132.88	132.66	132.88	589.0
2014-11-09 18:00:00	GC	Futures	1611.0	1611.9	1600.7	1601.7	6154.0
2014-11-09 19:00:00	GC	Futures	1601.7	1602.8	1598.7	1601.7	4487.0
2014-11-09 20:00:00	GC	Futures	1601.7	1610.8	1600.0	1605.0	16227.0
2014-11-09 21:00:00	GC	Futures	1604.8	1608.1	1603.6	1605.4	5003.0
2014-11-09 22:00:00	GC	Futures	1605.4	1606.3	1603.7	1604.3	1893.0
2014-11-09 23:00:00	GC	Futures	1604.1	1606.6	1603.4	1605.1	2235.0
2014-11-09 18:00:00	ZN	Futures	119.872678	119.90225	119.857891	119.887464	7987.0
2014-11-09 19:00:00	ZN	Futures	119.887464	119.90225	119.872678	119.887464	6957.0
2014-11-09 20:00:00	ZN	Futures	119.887464	119.90225	119.843105	119.872678	7222.0
2014-11-09 21:00:00	ZN	Futures	119.872678	119.917037	119.872678	119.90225	7421.0
2014-11-09 22:00:00	ZN	Futures	119.90225	119.917037	119.872678	119.90225	4447.0
2014-11-09 23:00:00	ZN	Futures	119.917037	119.931823	119.917037	119.917037	2012.0

> showing 36 of 276 rows — these rows as CSV

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