PREVIEW / futures_1hour / 2023-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-29.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
2023-01-29 18:00:00	ES	Futures	4559.82	4569.89	4556.47	4560.66	14062.0
2023-01-29 19:00:00	ES	Futures	4560.94	4565.98	4558.71	4561.78	7224.0
2023-01-29 20:00:00	ES	Futures	4561.78	4562.34	4557.31	4557.59	8954.0
2023-01-29 21:00:00	ES	Futures	4557.87	4559.82	4553.95	4557.03	7706.0
2023-01-29 22:00:00	ES	Futures	4557.31	4558.15	4553.11	4557.03	6070.0
2023-01-29 23:00:00	ES	Futures	4556.75	4558.71	4553.67	4554.51	5352.0
2023-01-29 18:00:00	NQ	Futures	13897.53	13942.49	13872.78	13889.57	10399.0
2023-01-29 19:00:00	NQ	Futures	13889.57	13910.62	13875.63	13892.98	4658.0
2023-01-29 20:00:00	NQ	Futures	13892.7	13894.97	13864.25	13872.5	5612.0
2023-01-29 21:00:00	NQ	Futures	13872.78	13875.91	13850.88	13864.53	3857.0
2023-01-29 22:00:00	NQ	Futures	13864.82	13870.22	13849.17	13865.96	3197.0
2023-01-29 23:00:00	NQ	Futures	13866.53	13874.78	13856.28	13860.55	2654.0
2023-01-29 18:00:00	YM	Futures	37897.8	37922.3	37841.0	37872.2	1724.0
2023-01-29 19:00:00	YM	Futures	37876.6	37908.9	37866.6	37887.8	874.0
2023-01-29 20:00:00	YM	Futures	37888.9	37892.2	37865.5	37869.9	1123.0
2023-01-29 21:00:00	YM	Futures	37869.9	37887.8	37844.3	37865.5	847.0
2023-01-29 22:00:00	YM	Futures	37865.5	37867.7	37836.5	37859.9	901.0
2023-01-29 23:00:00	YM	Futures	37859.9	37868.8	37832.0	37837.6	598.0
2023-01-29 18:00:00	CL	Futures	65.28	65.65	65.13	65.52	7266.0
2023-01-29 19:00:00	CL	Futures	65.53	65.61	65.45	65.46	2260.0
2023-01-29 20:00:00	CL	Futures	65.46	65.56	65.23	65.26	5123.0
2023-01-29 21:00:00	CL	Futures	65.26	65.33	65.04	65.13	2946.0
2023-01-29 22:00:00	CL	Futures	65.14	65.15	64.9	64.95	2638.0
2023-01-29 23:00:00	CL	Futures	64.95	64.99	64.78	64.87	1679.0
2023-01-29 18:00:00	GC	Futures	2257.4	2259.2	2254.9	2258.7	2374.0
2023-01-29 19:00:00	GC	Futures	2258.8	2259.9	2257.4	2258.4	1942.0
2023-01-29 20:00:00	GC	Futures	2258.3	2261.3	2253.0	2256.9	4911.0
2023-01-29 21:00:00	GC	Futures	2256.9	2256.9	2253.6	2255.4	2126.0
2023-01-29 22:00:00	GC	Futures	2255.3	2255.4	2252.9	2255.2	1701.0
2023-01-29 23:00:00	GC	Futures	2255.1	2264.5	2254.9	2263.2	5377.0
2023-01-29 18:00:00	ZN	Futures	118.111141	118.127237	118.030662	118.095045	10102.0
2023-01-29 19:00:00	ZN	Futures	118.095045	118.111141	117.982374	118.014566	15836.0
2023-01-29 20:00:00	ZN	Futures	117.99847	118.046758	117.966279	117.99847	17674.0
2023-01-29 21:00:00	ZN	Futures	117.99847	118.078949	117.99847	118.046758	8023.0
2023-01-29 22:00:00	ZN	Futures	118.062854	118.143333	118.046758	118.143333	7549.0
2023-01-29 23:00:00	ZN	Futures	118.143333	118.207716	118.111141	118.127237	16353.0

> showing 36 of 436 rows — these rows as CSV

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