PREVIEW / futures_1hour / 2022-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-31.parquet
  size:    19 KB
  rows:    423

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-07-31 18:00:00	ES	Futures	4688.14	4688.71	4661.23	4663.78	14879.0
2022-07-31 19:00:00	ES	Futures	4663.78	4671.43	4661.52	4664.91	6962.0
2022-07-31 20:00:00	ES	Futures	4664.91	4668.6	4661.8	4665.2	7253.0
2022-07-31 21:00:00	ES	Futures	4665.48	4670.3	4662.93	4667.75	10394.0
2022-07-31 22:00:00	ES	Futures	4667.46	4669.73	4664.63	4668.31	4744.0
2022-07-31 23:00:00	ES	Futures	4668.6	4668.6	4660.1	4661.52	6144.0
2022-07-31 18:00:00	NQ	Futures	15018.45	15038.98	14942.96	14953.66	7855.0
2022-07-31 19:00:00	NQ	Futures	14953.08	14969.86	14938.62	14947.87	3676.0
2022-07-31 20:00:00	NQ	Futures	14947.3	14952.5	14933.7	14943.54	3825.0
2022-07-31 21:00:00	NQ	Futures	14944.98	14961.76	14930.81	14958.87	4374.0
2022-07-31 22:00:00	NQ	Futures	14958.58	14967.25	14947.87	14962.91	2692.0
2022-07-31 23:00:00	NQ	Futures	14962.91	14964.07	14934.28	14943.54	3010.0
2022-07-31 18:00:00	YM	Futures	37040.1	37069.5	36860.7	36876.5	3119.0
2022-07-31 19:00:00	YM	Futures	36876.5	36926.2	36866.4	36888.9	1450.0
2022-07-31 20:00:00	YM	Futures	36888.9	36921.7	36867.5	36903.6	1401.0
2022-07-31 21:00:00	YM	Futures	36908.1	36929.6	36888.9	36913.8	1482.0
2022-07-31 22:00:00	YM	Futures	36911.5	36927.3	36892.3	36919.4	798.0
2022-07-31 23:00:00	YM	Futures	36920.5	36921.7	36859.6	36867.5	1206.0
2022-07-31 18:00:00	CL	Futures	78.21	78.36	77.49	77.86	3387.0
2022-07-31 19:00:00	CL	Futures	77.86	77.92	77.61	77.8	1493.0
2022-07-31 20:00:00	CL	Futures	77.8	77.96	77.56	77.67	3067.0
2022-07-31 21:00:00	CL	Futures	77.69	77.89	77.1	77.46	8234.0
2022-07-31 22:00:00	CL	Futures	77.48	77.63	77.17	77.57	3627.0
2022-07-31 23:00:00	CL	Futures	77.57	77.61	77.18	77.26	2406.0
2022-07-31 18:00:00	GC	Futures	2105.4	2106.3	2101.8	2102.2	1482.0
2022-07-31 19:00:00	GC	Futures	2102.2	2102.4	2099.2	2100.9	1290.0
2022-07-31 20:00:00	GC	Futures	2101.0	2103.4	2099.1	2101.6	1798.0
2022-07-31 21:00:00	GC	Futures	2101.6	2105.4	2099.6	2102.2	3919.0
2022-07-31 22:00:00	GC	Futures	2102.1	2104.6	2102.0	2103.4	2201.0
2022-07-31 23:00:00	GC	Futures	2103.5	2103.7	2099.2	2100.1	1846.0
2022-07-31 18:00:00	ZN	Futures	124.880521	124.993345	124.864403	124.912756	6794.0
2022-07-31 19:00:00	ZN	Futures	124.896638	124.928874	124.816049	124.848285	6218.0
2022-07-31 20:00:00	ZN	Futures	124.848285	124.880521	124.799932	124.832167	9632.0
2022-07-31 21:00:00	ZN	Futures	124.832167	124.944992	124.832167	124.896638	13142.0
2022-07-31 22:00:00	ZN	Futures	124.896638	124.928874	124.864403	124.896638	5295.0
2022-07-31 23:00:00	ZN	Futures	124.896638	124.928874	124.799932	124.848285	6055.0

> showing 36 of 423 rows — these rows as CSV

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