PREVIEW / futures_1hour / 2023-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-04.parquet
  size:    19 KB
  rows:    407

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-06-04 18:00:00	ES	Futures	4757.17	4762.44	4754.11	4761.6	9013.0
2023-06-04 19:00:00	ES	Futures	4761.6	4761.6	4752.73	4753.56	8886.0
2023-06-04 20:00:00	ES	Futures	4753.84	4755.22	4748.84	4753.01	10306.0
2023-06-04 21:00:00	ES	Futures	4753.28	4755.78	4749.68	4753.28	11007.0
2023-06-04 22:00:00	ES	Futures	4753.01	4754.39	4751.62	4754.11	4807.0
2023-06-04 23:00:00	ES	Futures	4753.84	4756.89	4752.17	4752.45	5399.0
2023-06-04 18:00:00	NQ	Futures	16416.79	16419.61	16393.42	16405.81	4624.0
2023-06-04 19:00:00	NQ	Futures	16406.38	16407.22	16355.7	16371.46	6066.0
2023-06-04 20:00:00	NQ	Futures	16372.03	16372.03	16344.43	16361.61	5875.0
2023-06-04 21:00:00	NQ	Futures	16361.89	16372.59	16352.88	16367.52	4520.0
2023-06-04 22:00:00	NQ	Futures	16366.96	16379.63	16361.33	16376.81	3051.0
2023-06-04 23:00:00	NQ	Futures	16376.53	16382.73	16360.48	16362.17	3665.0
2023-06-04 18:00:00	YM	Futures	37378.2	37463.3	37368.3	37458.9	2233.0
2023-06-04 19:00:00	YM	Futures	37458.9	37462.2	37391.5	37397.0	2063.0
2023-06-04 20:00:00	YM	Futures	37398.1	37419.1	37368.3	37403.6	1652.0
2023-06-04 21:00:00	YM	Futures	37402.5	37418.0	37378.2	37397.0	1506.0
2023-06-04 22:00:00	YM	Futures	37394.8	37408.1	37381.5	37402.5	601.0
2023-06-04 23:00:00	YM	Futures	37402.5	37422.4	37393.7	37397.0	602.0
2023-06-04 18:00:00	CL	Futures	61.04	61.06	59.63	59.89	18786.0
2023-06-04 19:00:00	CL	Futures	59.9	59.94	59.61	59.69	4121.0
2023-06-04 20:00:00	CL	Futures	59.69	59.69	59.1	59.12	7328.0
2023-06-04 21:00:00	CL	Futures	59.13	59.21	58.78	59.09	10560.0
2023-06-04 22:00:00	CL	Futures	59.07	59.09	58.89	58.94	3767.0
2023-06-04 23:00:00	CL	Futures	58.94	59.21	58.94	59.12	2886.0
2023-06-04 18:00:00	GC	Futures	2235.3	2239.5	2235.3	2238.2	1911.0
2023-06-04 19:00:00	GC	Futures	2238.2	2239.4	2236.6	2238.7	1949.0
2023-06-04 20:00:00	GC	Futures	2238.8	2239.0	2234.4	2235.5	2755.0
2023-06-04 21:00:00	GC	Futures	2235.5	2237.5	2234.5	2236.6	7526.0
2023-06-04 22:00:00	GC	Futures	2236.6	2237.5	2232.2	2233.5	5047.0
2023-06-04 23:00:00	GC	Futures	2233.5	2236.4	2232.8	2235.9	1962.0
2023-06-04 18:00:00	ZN	Futures	115.864216	115.880243	115.848188	115.880243	18.0
2023-06-04 20:00:00	ZN	Futures	115.848188	115.848188	115.800105	115.816132	48.0
2023-06-04 21:00:00	ZN	Futures	115.768049	115.768049	115.752022	115.752022	204.0
2023-06-04 22:00:00	ZN	Futures	115.752022	115.752022	115.719966	115.735994	8.0
2023-06-04 23:00:00	ZN	Futures	115.768049	115.768049	115.768049	115.768049	3.0

> showing 35 of 407 rows — these rows as CSV

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