PREVIEW / futures_1hour / 2016-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-16.parquet
  size:    15 KB
  rows:    292

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-16 18:00:00	ES	Futures	2314.03	2316.75	2305.6	2307.77	14219.0
2016-10-16 19:00:00	ES	Futures	2307.5	2310.49	2307.23	2310.22	4173.0
2016-10-16 20:00:00	ES	Futures	2310.22	2311.31	2308.86	2309.95	8120.0
2016-10-16 21:00:00	ES	Futures	2309.68	2309.68	2303.69	2306.69	16607.0
2016-10-16 22:00:00	ES	Futures	2306.41	2310.22	2305.33	2308.86	5279.0
2016-10-16 23:00:00	ES	Futures	2308.86	2310.49	2308.32	2309.41	3163.0
2016-10-16 18:00:00	NQ	Futures	5732.21	5735.19	5709.53	5714.01	2551.0
2016-10-16 19:00:00	NQ	Futures	5714.9	5720.57	5713.71	5719.98	1058.0
2016-10-16 20:00:00	NQ	Futures	5720.27	5725.05	5718.19	5721.77	1720.0
2016-10-16 21:00:00	NQ	Futures	5721.77	5721.77	5705.36	5711.92	2832.0
2016-10-16 22:00:00	NQ	Futures	5711.62	5719.38	5707.45	5716.1	1225.0
2016-10-16 23:00:00	NQ	Futures	5716.69	5721.77	5715.2	5717.29	780.0
2016-10-16 18:00:00	YM	Futures	19507.8	19542.4	19450.5	19465.6	3165.0
2016-10-16 19:00:00	YM	Futures	19464.5	19489.4	19462.4	19487.2	1085.0
2016-10-16 20:00:00	YM	Futures	19487.2	19499.1	19476.4	19484.0	1949.0
2016-10-16 21:00:00	YM	Futures	19484.0	19484.0	19435.4	19459.1	3602.0
2016-10-16 22:00:00	YM	Futures	19457.0	19481.8	19445.1	19474.3	1357.0
2016-10-16 23:00:00	YM	Futures	19475.3	19486.2	19467.8	19476.4	1080.0
2016-10-16 18:00:00	CL	Futures	50.5	50.54	50.34	50.36	766.0
2016-10-16 19:00:00	CL	Futures	50.35	50.37	50.31	50.36	396.0
2016-10-16 20:00:00	CL	Futures	50.37	50.47	50.26	50.42	1408.0
2016-10-16 21:00:00	CL	Futures	50.41	50.46	50.31	50.37	1391.0
2016-10-16 22:00:00	CL	Futures	50.37	50.47	50.36	50.43	674.0
2016-10-16 23:00:00	CL	Futures	50.44	50.51	50.43	50.47	743.0
2016-10-16 18:00:00	GC	Futures	1695.1	1696.3	1692.7	1695.3	1462.0
2016-10-16 19:00:00	GC	Futures	1695.1	1696.7	1694.7	1696.6	733.0
2016-10-16 20:00:00	GC	Futures	1696.5	1696.6	1693.5	1694.8	1691.0
2016-10-16 21:00:00	GC	Futures	1695.0	1697.7	1695.0	1696.5	3805.0
2016-10-16 22:00:00	GC	Futures	1696.6	1697.4	1696.2	1696.6	1850.0
2016-10-16 23:00:00	GC	Futures	1696.6	1698.8	1695.7	1697.1	3910.0
2016-10-16 18:00:00	ZN	Futures	127.30969	127.416969	127.279038	127.401643	7289.0
2016-10-16 19:00:00	ZN	Futures	127.401643	127.44762	127.386318	127.416969	5186.0
2016-10-16 20:00:00	ZN	Futures	127.416969	127.432294	127.294364	127.355666	16078.0
2016-10-16 21:00:00	ZN	Futures	127.355666	127.432294	127.340341	127.386318	10971.0
2016-10-16 22:00:00	ZN	Futures	127.386318	127.401643	127.325015	127.340341	8232.0
2016-10-16 23:00:00	ZN	Futures	127.340341	127.386318	127.325015	127.386318	2830.0

> showing 36 of 292 rows — these rows as CSV

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