PREVIEW / futures_1hour / 2017-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-07.parquet
  size:    15 KB
  rows:    300

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
2017-05-07 18:00:00	ES	Futures	2624.9	2626.27	2618.62	2619.17	21056.0
2017-05-07 19:00:00	ES	Futures	2619.44	2620.53	2617.8	2618.89	6159.0
2017-05-07 20:00:00	ES	Futures	2618.62	2619.44	2615.89	2618.62	12899.0
2017-05-07 21:00:00	ES	Futures	2618.62	2619.17	2617.26	2617.8	5166.0
2017-05-07 22:00:00	ES	Futures	2617.8	2618.89	2616.98	2618.35	4471.0
2017-05-07 23:00:00	ES	Futures	2618.35	2619.44	2617.53	2618.89	4006.0
2017-05-07 18:00:00	NQ	Futures	6747.81	6750.49	6730.22	6731.41	4186.0
2017-05-07 19:00:00	NQ	Futures	6731.41	6733.79	6727.53	6730.51	1187.0
2017-05-07 20:00:00	NQ	Futures	6730.51	6732.01	6723.96	6730.51	2082.0
2017-05-07 21:00:00	NQ	Futures	6730.81	6731.41	6726.64	6728.43	1241.0
2017-05-07 22:00:00	NQ	Futures	6728.13	6730.81	6726.94	6730.22	819.0
2017-05-07 23:00:00	NQ	Futures	6730.51	6732.9	6728.13	6731.71	713.0
2017-05-07 18:00:00	YM	Futures	22823.7	22833.5	22759.6	22767.2	3149.0
2017-05-07 19:00:00	YM	Futures	22768.3	22781.3	22761.8	22769.4	1092.0
2017-05-07 20:00:00	YM	Futures	22768.3	22774.8	22747.6	22767.2	1567.0
2017-05-07 21:00:00	YM	Futures	22767.2	22773.7	22760.7	22763.9	1033.0
2017-05-07 22:00:00	YM	Futures	22763.9	22773.7	22761.8	22770.4	434.0
2017-05-07 23:00:00	YM	Futures	22771.5	22781.3	22763.9	22777.0	579.0
2017-05-07 18:00:00	CL	Futures	42.73	42.98	42.7	42.86	5070.0
2017-05-07 19:00:00	CL	Futures	42.86	43.29	42.85	43.26	7269.0
2017-05-07 20:00:00	CL	Futures	43.26	43.31	43.15	43.29	5096.0
2017-05-07 21:00:00	CL	Futures	43.29	43.29	43.06	43.13	6751.0
2017-05-07 22:00:00	CL	Futures	43.13	43.24	43.12	43.15	3589.0
2017-05-07 23:00:00	CL	Futures	43.15	43.23	43.12	43.19	2765.0
2017-05-07 18:00:00	GC	Futures	1642.0	1648.2	1639.2	1648.2	5366.0
2017-05-07 19:00:00	GC	Futures	1648.1	1658.0	1647.5	1657.7	10099.0
2017-05-07 20:00:00	GC	Futures	1657.9	1658.0	1652.9	1655.2	8718.0
2017-05-07 21:00:00	GC	Futures	1655.0	1655.0	1651.5	1653.3	6012.0
2017-05-07 22:00:00	GC	Futures	1653.3	1653.8	1652.1	1652.5	3033.0
2017-05-07 23:00:00	GC	Futures	1652.5	1653.0	1651.9	1652.3	2095.0
2017-05-07 18:00:00	ZN	Futures	124.089839	124.167337	124.02784	124.136337	38013.0
2017-05-07 19:00:00	ZN	Futures	124.120838	124.167337	124.120838	124.136337	8754.0
2017-05-07 20:00:00	ZN	Futures	124.151837	124.151837	124.120838	124.136337	13290.0
2017-05-07 21:00:00	ZN	Futures	124.151837	124.182836	124.120838	124.182836	14934.0
2017-05-07 22:00:00	ZN	Futures	124.167337	124.182836	124.151837	124.151837	8448.0
2017-05-07 23:00:00	ZN	Futures	124.151837	124.182836	124.136337	124.136337	8164.0

> showing 36 of 300 rows — these rows as CSV

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