PREVIEW / futures_1hour / 2016-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-31.parquet
  size:    15 KB
  rows:    287

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-01-31 18:00:00	ES	Futures	2074.16	2077.12	2071.75	2072.82	15854.0
2016-01-31 19:00:00	ES	Futures	2072.82	2074.16	2068.52	2069.6	17993.0
2016-01-31 20:00:00	ES	Futures	2069.6	2072.82	2066.37	2069.6	21754.0
2016-01-31 21:00:00	ES	Futures	2069.6	2073.9	2067.98	2073.36	15499.0
2016-01-31 22:00:00	ES	Futures	2073.36	2073.36	2066.91	2068.79	11640.0
2016-01-31 23:00:00	ES	Futures	2068.79	2070.4	2067.98	2069.6	5208.0
2016-01-31 18:00:00	NQ	Futures	5063.57	5075.15	5060.3	5062.09	2294.0
2016-01-31 19:00:00	NQ	Futures	5062.38	5065.35	5050.8	5052.88	3100.0
2016-01-31 20:00:00	NQ	Futures	5052.88	5060.6	5045.75	5052.29	4023.0
2016-01-31 21:00:00	NQ	Futures	5052.29	5062.68	5049.32	5061.49	2147.0
2016-01-31 22:00:00	NQ	Futures	5061.49	5061.49	5046.05	5050.51	1543.0
2016-01-31 23:00:00	NQ	Futures	5050.21	5055.55	5049.91	5054.07	833.0
2016-01-31 18:00:00	YM	Futures	17422.3	17434.0	17394.6	17397.8	1834.0
2016-01-31 19:00:00	YM	Futures	17397.8	17407.4	17363.8	17370.2	3592.0
2016-01-31 20:00:00	YM	Futures	17372.3	17398.9	17349.9	17379.7	4193.0
2016-01-31 21:00:00	YM	Futures	17377.6	17412.7	17368.0	17409.5	2510.0
2016-01-31 22:00:00	YM	Futures	17409.5	17409.5	17358.4	17373.4	2202.0
2016-01-31 23:00:00	YM	Futures	17374.4	17385.1	17368.0	17378.7	797.0
2016-01-31 18:00:00	CL	Futures	43.09	43.54	42.58	42.84	7936.0
2016-01-31 19:00:00	CL	Futures	42.85	42.85	42.21	42.27	6777.0
2016-01-31 20:00:00	CL	Futures	42.27	42.47	42.11	42.32	8412.0
2016-01-31 21:00:00	CL	Futures	42.3	42.35	41.91	42.25	7980.0
2016-01-31 22:00:00	CL	Futures	42.24	42.24	41.91	42.04	4828.0
2016-01-31 23:00:00	CL	Futures	42.02	42.27	41.96	42.16	2632.0
2016-01-31 18:00:00	GC	Futures	1526.2	1526.9	1522.5	1525.9	1467.0
2016-01-31 19:00:00	GC	Futures	1526.0	1528.2	1524.9	1526.7	3613.0
2016-01-31 20:00:00	GC	Futures	1526.7	1530.3	1525.8	1529.5	4649.0
2016-01-31 21:00:00	GC	Futures	1529.5	1531.5	1529.5	1530.8	2086.0
2016-01-31 22:00:00	GC	Futures	1530.7	1532.3	1530.5	1532.3	1558.0
2016-01-31 23:00:00	GC	Futures	1532.0	1532.3	1530.8	1532.0	1497.0
2016-01-31 18:00:00	ZN	Futures	125.738573	125.768894	125.632452	125.677932	9372.0
2016-01-31 19:00:00	ZN	Futures	125.693093	125.890175	125.662772	125.859855	17868.0
2016-01-31 20:00:00	ZN	Futures	125.859855	125.920495	125.799214	125.829534	18047.0
2016-01-31 21:00:00	ZN	Futures	125.829534	125.875015	125.768894	125.784054	12359.0
2016-01-31 22:00:00	ZN	Futures	125.784054	125.844694	125.768894	125.844694	5968.0
2016-01-31 23:00:00	ZN	Futures	125.844694	125.875015	125.814374	125.875015	7010.0

> showing 36 of 287 rows — these rows as CSV

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