PREVIEW / futures_1hour / 2020-02-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-16.parquet
  size:    16 KB
  rows:    339

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
2020-02-16 18:00:00	ES	Futures	3666.2	3674.1	3666.0	3672.2	13750.0
2020-02-16 19:00:00	ES	Futures	3672.2	3672.7	3667.3	3667.6	12952.0
2020-02-16 20:00:00	ES	Futures	3667.6	3674.4	3666.5	3672.5	14658.0
2020-02-16 21:00:00	ES	Futures	3672.5	3674.1	3671.9	3673.3	6024.0
2020-02-16 22:00:00	ES	Futures	3673.3	3673.5	3671.6	3672.7	3483.0
2020-02-16 23:00:00	ES	Futures	3672.5	3672.7	3671.1	3671.6	3114.0
2020-02-16 18:00:00	NQ	Futures	11144.74	11183.78	11143.87	11177.99	8936.0
2020-02-16 19:00:00	NQ	Futures	11177.7	11182.91	11167.58	11168.74	8721.0
2020-02-16 20:00:00	NQ	Futures	11168.16	11193.03	11165.56	11187.82	8120.0
2020-02-16 21:00:00	NQ	Futures	11187.82	11192.16	11182.33	11187.25	3063.0
2020-02-16 22:00:00	NQ	Futures	11187.25	11189.56	11183.78	11188.4	2211.0
2020-02-16 23:00:00	NQ	Futures	11188.11	11188.98	11184.07	11186.09	2302.0
2020-02-16 18:00:00	YM	Futures	31991.6	32078.7	31991.6	32058.0	2805.0
2020-02-16 19:00:00	YM	Futures	32055.8	32061.3	32011.2	32013.4	2408.0
2020-02-16 20:00:00	YM	Futures	32013.4	32074.4	32004.7	32061.3	3591.0
2020-02-16 21:00:00	YM	Futures	32062.4	32072.2	32053.7	32063.5	1673.0
2020-02-16 22:00:00	YM	Futures	32064.6	32068.9	32051.5	32059.1	985.0
2020-02-16 23:00:00	YM	Futures	32059.1	32059.1	32038.4	32045.0	1387.0
2020-02-16 18:00:00	CL	Futures	46.28	46.42	46.15	46.17	2432.0
2020-02-16 19:00:00	CL	Futures	46.16	46.17	46.05	46.1	3370.0
2020-02-16 20:00:00	CL	Futures	46.09	46.13	45.89	46.11	8334.0
2020-02-16 21:00:00	CL	Futures	46.11	46.15	46.07	46.12	2590.0
2020-02-16 22:00:00	CL	Futures	46.12	46.12	46.05	46.11	2246.0
2020-02-16 23:00:00	CL	Futures	46.1	46.12	46.07	46.08	1064.0
2020-02-16 18:00:00	GC	Futures	1979.9	1981.3	1977.6	1981.0	4547.0
2020-02-16 19:00:00	GC	Futures	1981.1	1982.0	1979.0	1979.9	4071.0
2020-02-16 20:00:00	GC	Futures	1979.9	1981.9	1979.0	1979.9	7205.0
2020-02-16 21:00:00	GC	Futures	1979.9	1981.3	1979.8	1980.5	4332.0
2020-02-16 22:00:00	GC	Futures	1980.5	1980.6	1979.4	1980.4	1942.0
2020-02-16 23:00:00	GC	Futures	1980.3	1981.3	1980.1	1981.0	1116.0
2020-02-16 18:00:00	ZN	Futures	131.09388	131.109523	131.000018	131.062592	21520.0
2020-02-16 19:00:00	ZN	Futures	131.062592	131.140811	131.062592	131.125167	13943.0
2020-02-16 20:00:00	ZN	Futures	131.109523	131.140811	131.031305	131.062592	15435.0
2020-02-16 21:00:00	ZN	Futures	131.062592	131.062592	131.031305	131.031305	5803.0
2020-02-16 22:00:00	ZN	Futures	131.031305	131.062592	131.031305	131.062592	5899.0
2020-02-16 23:00:00	ZN	Futures	131.062592	131.078236	131.046949	131.062592	3049.0

> showing 36 of 339 rows — these rows as CSV

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