PREVIEW / futures_1hour / 2023-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-12.parquet
  size:    19 KB
  rows:    428

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-11-12 18:00:00	ES	Futures	4807.4	4810.93	4800.88	4802.24	15556.0
2023-11-12 19:00:00	ES	Futures	4802.24	4803.32	4796.54	4798.16	10229.0
2023-11-12 20:00:00	ES	Futures	4798.44	4799.52	4796.54	4798.44	7302.0
2023-11-12 21:00:00	ES	Futures	4798.16	4799.52	4793.01	4793.28	9252.0
2023-11-12 22:00:00	ES	Futures	4793.28	4793.55	4789.2	4791.1	9417.0
2023-11-12 23:00:00	ES	Futures	4791.1	4791.38	4789.2	4790.02	3590.0
2023-11-12 18:00:00	NQ	Futures	17123.94	17140.42	17081.92	17096.2	9866.0
2023-11-12 19:00:00	NQ	Futures	17095.92	17102.79	17073.95	17082.46	5585.0
2023-11-12 20:00:00	NQ	Futures	17082.46	17085.76	17073.68	17076.15	4815.0
2023-11-12 21:00:00	NQ	Futures	17075.6	17079.44	17048.68	17054.17	6787.0
2023-11-12 22:00:00	NQ	Futures	17054.17	17054.72	17042.91	17048.96	3878.0
2023-11-12 23:00:00	NQ	Futures	17048.68	17049.78	17039.62	17044.29	2258.0
2023-11-12 18:00:00	YM	Futures	37207.3	37222.5	37183.5	37186.7	1778.0
2023-11-12 19:00:00	YM	Futures	37190.0	37193.2	37156.3	37158.5	996.0
2023-11-12 20:00:00	YM	Futures	37158.5	37172.6	37148.8	37168.3	976.0
2023-11-12 21:00:00	YM	Futures	37169.4	37173.7	37137.9	37139.0	775.0
2023-11-12 22:00:00	YM	Futures	37140.1	37143.3	37107.5	37120.5	1083.0
2023-11-12 23:00:00	YM	Futures	37120.5	37122.7	37108.6	37113.0	314.0
2023-11-12 18:00:00	CL	Futures	64.75	64.86	64.48	64.55	2379.0
2023-11-12 19:00:00	CL	Futures	64.55	64.55	64.39	64.42	1400.0
2023-11-12 20:00:00	CL	Futures	64.43	64.44	64.23	64.37	3479.0
2023-11-12 21:00:00	CL	Futures	64.37	64.42	64.16	64.17	2619.0
2023-11-12 22:00:00	CL	Futures	64.16	64.23	64.12	64.18	1401.0
2023-11-12 23:00:00	CL	Futures	64.19	64.2	64.08	64.1	903.0
2023-11-12 18:00:00	GC	Futures	2170.7	2172.5	2168.4	2171.9	3160.0
2023-11-12 19:00:00	GC	Futures	2171.9	2173.7	2170.8	2170.8	3490.0
2023-11-12 20:00:00	GC	Futures	2170.7	2172.5	2169.3	2171.8	3352.0
2023-11-12 21:00:00	GC	Futures	2171.9	2172.9	2168.6	2168.6	3393.0
2023-11-12 22:00:00	GC	Futures	2168.7	2169.1	2164.8	2166.2	4031.0
2023-11-12 23:00:00	GC	Futures	2166.2	2167.4	2165.1	2166.8	1315.0
2023-11-12 18:00:00	ZN	Futures	109.02183	109.053569	108.958353	108.974222	24625.0
2023-11-12 19:00:00	ZN	Futures	108.990092	109.053569	108.958353	109.005961	10281.0
2023-11-12 20:00:00	ZN	Futures	109.005961	109.005961	108.942484	108.942484	13518.0
2023-11-12 21:00:00	ZN	Futures	108.942484	108.990092	108.942484	108.958353	7381.0
2023-11-12 22:00:00	ZN	Futures	108.958353	108.974222	108.910745	108.974222	14680.0
2023-11-12 23:00:00	ZN	Futures	108.958353	108.990092	108.942484	108.974222	6796.0

> showing 36 of 428 rows — these rows as CSV

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