PREVIEW / futures_1hour / 2023-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-09.parquet
  size:    19 KB
  rows:    415

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
2023-07-09 18:00:00	ES	Futures	4872.58	4875.32	4864.89	4874.22	14485.0
2023-07-09 19:00:00	ES	Futures	4874.22	4875.05	4871.2	4872.58	4307.0
2023-07-09 20:00:00	ES	Futures	4872.3	4872.85	4862.15	4865.17	12905.0
2023-07-09 21:00:00	ES	Futures	4865.44	4869.01	4857.2	4859.4	13877.0
2023-07-09 22:00:00	ES	Futures	4859.4	4862.15	4859.13	4860.5	6917.0
2023-07-09 23:00:00	ES	Futures	4860.77	4862.97	4855.83	4858.3	8880.0
2023-07-09 18:00:00	NQ	Futures	16908.7	16908.7	16857.81	16898.69	9569.0
2023-07-09 19:00:00	NQ	Futures	16898.14	16901.2	16882.0	16889.79	4248.0
2023-07-09 20:00:00	NQ	Futures	16889.51	16890.9	16842.23	16862.81	7845.0
2023-07-09 21:00:00	NQ	Futures	16863.09	16877.83	16829.72	16836.95	7653.0
2023-07-09 22:00:00	NQ	Futures	16837.22	16846.13	16830.55	16838.34	4529.0
2023-07-09 23:00:00	NQ	Futures	16838.62	16846.96	16821.65	16832.22	4808.0
2023-07-09 18:00:00	YM	Futures	37213.5	37235.4	37154.3	37228.8	2064.0
2023-07-09 19:00:00	YM	Futures	37228.8	37236.5	37215.7	37222.2	588.0
2023-07-09 20:00:00	YM	Futures	37222.2	37224.4	37156.5	37178.4	1940.0
2023-07-09 21:00:00	YM	Futures	37178.4	37201.4	37119.3	37140.1	1845.0
2023-07-09 22:00:00	YM	Futures	37141.2	37160.9	37141.2	37152.1	928.0
2023-07-09 23:00:00	YM	Futures	37152.1	37166.4	37111.6	37125.8	1134.0
2023-07-09 18:00:00	CL	Futures	59.94	60.05	59.65	59.73	1888.0
2023-07-09 19:00:00	CL	Futures	59.74	59.75	59.6	59.7	1064.0
2023-07-09 20:00:00	CL	Futures	59.69	59.72	59.59	59.62	1600.0
2023-07-09 21:00:00	CL	Futures	59.62	59.86	59.62	59.75	3626.0
2023-07-09 22:00:00	CL	Futures	59.75	59.79	59.59	59.59	1523.0
2023-07-09 23:00:00	CL	Futures	59.61	59.67	59.47	59.51	2496.0
2023-07-09 18:00:00	GC	Futures	2199.3	2202.7	2198.3	2200.2	2797.0
2023-07-09 19:00:00	GC	Futures	2200.2	2200.3	2197.8	2199.1	2052.0
2023-07-09 20:00:00	GC	Futures	2199.1	2199.4	2196.7	2198.2	2719.0
2023-07-09 21:00:00	GC	Futures	2198.2	2201.4	2197.9	2199.0	3662.0
2023-07-09 22:00:00	GC	Futures	2199.1	2199.7	2197.9	2199.2	2305.0
2023-07-09 23:00:00	GC	Futures	2199.2	2199.8	2196.6	2198.1	2124.0
2023-07-09 18:00:00	ZN	Futures	112.706535	112.770265	112.690602	112.7384	7139.0
2023-07-09 19:00:00	ZN	Futures	112.7384	112.754332	112.706535	112.722467	5337.0
2023-07-09 20:00:00	ZN	Futures	112.7384	112.770265	112.642805	112.67467	13325.0
2023-07-09 21:00:00	ZN	Futures	112.658737	112.67467	112.595007	112.61094	16402.0
2023-07-09 22:00:00	ZN	Futures	112.61094	112.658737	112.579075	112.658737	11567.0
2023-07-09 23:00:00	ZN	Futures	112.658737	112.67467	112.626872	112.642805	5680.0

> showing 36 of 415 rows — these rows as CSV

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