PREVIEW / futures_1hour / 2022-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-25.parquet
  size:    20 KB
  rows:    436

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
2022-09-25 18:00:00	ES	Futures	4177.94	4188.38	4158.78	4176.82	25766.0
2022-09-25 19:00:00	ES	Futures	4176.82	4181.05	4166.95	4173.72	12040.0
2022-09-25 20:00:00	ES	Futures	4173.43	4182.17	4153.42	4155.11	24404.0
2022-09-25 21:00:00	ES	Futures	4155.11	4164.41	4148.63	4163.0	28109.0
2022-09-25 22:00:00	ES	Futures	4163.0	4174.28	4161.03	4161.6	18230.0
2022-09-25 23:00:00	ES	Futures	4161.6	4169.77	4157.08	4159.62	9811.0
2022-09-25 18:00:00	NQ	Futures	13058.96	13098.61	12998.05	13049.19	13273.0
2022-09-25 19:00:00	NQ	Futures	13049.19	13064.42	13019.6	13040.0	5800.0
2022-09-25 20:00:00	NQ	Futures	13038.56	13078.5	12985.69	12992.88	13362.0
2022-09-25 21:00:00	NQ	Futures	12992.59	13032.81	12968.74	13030.23	13368.0
2022-09-25 22:00:00	NQ	Futures	13030.23	13061.26	13020.17	13023.33	7813.0
2022-09-25 23:00:00	NQ	Futures	13023.33	13046.89	13002.07	13011.55	5303.0
2022-09-25 18:00:00	YM	Futures	33268.6	33356.2	33130.6	33293.3	5270.0
2022-09-25 19:00:00	YM	Futures	33292.2	33319.1	33210.3	33261.9	1511.0
2022-09-25 20:00:00	YM	Futures	33252.9	33320.2	33099.2	33110.4	3547.0
2022-09-25 21:00:00	YM	Futures	33109.3	33172.1	33066.6	33160.9	3419.0
2022-09-25 22:00:00	YM	Futures	33162.0	33247.3	33151.9	33153.0	1977.0
2022-09-25 23:00:00	YM	Futures	33151.9	33204.6	33122.7	33139.6	1166.0
2022-09-25 18:00:00	CL	Futures	63.6	63.82	63.32	63.81	3030.0
2022-09-25 19:00:00	CL	Futures	63.81	63.86	63.63	63.86	1042.0
2022-09-25 20:00:00	CL	Futures	63.86	64.2	63.32	63.34	4611.0
2022-09-25 21:00:00	CL	Futures	63.34	63.55	63.14	63.27	6659.0
2022-09-25 22:00:00	CL	Futures	63.27	63.55	62.86	62.92	4568.0
2022-09-25 23:00:00	CL	Futures	62.93	63.03	62.84	62.88	2951.0
2022-09-25 18:00:00	GC	Futures	1950.1	1952.9	1945.9	1950.4	3272.0
2022-09-25 19:00:00	GC	Futures	1950.4	1951.1	1948.5	1950.4	1290.0
2022-09-25 20:00:00	GC	Futures	1950.5	1952.1	1929.7	1931.6	11176.0
2022-09-25 21:00:00	GC	Futures	1931.5	1952.1	1931.2	1946.3	14829.0
2022-09-25 22:00:00	GC	Futures	1946.5	1947.9	1943.9	1945.6	4050.0
2022-09-25 23:00:00	GC	Futures	1945.3	1947.1	1943.3	1943.3	2842.0
2022-09-25 18:00:00	ZN	Futures	116.257511	116.257511	116.04798	116.04798	11559.0
2022-09-25 19:00:00	ZN	Futures	116.04798	116.080215	115.822331	115.870684	16810.0
2022-09-25 20:00:00	ZN	Futures	115.870684	115.90292	115.773978	115.886802	25552.0
2022-09-25 21:00:00	ZN	Futures	115.886802	115.999627	115.806213	115.999627	15974.0
2022-09-25 22:00:00	ZN	Futures	115.999627	116.031862	115.919038	115.919038	8920.0
2022-09-25 23:00:00	ZN	Futures	115.919038	115.967391	115.806213	115.838449	8675.0

> showing 36 of 436 rows — these rows as CSV

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