PREVIEW / futures_1hour / 2023-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-23.parquet
  size:    66 KB
  rows:    2,035

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-02-23 00:00:00	ES	Futures	4494.4	4494.4	4490.76	4491.6	4365.0
2023-02-23 01:00:00	ES	Futures	4491.6	4493.84	4490.76	4490.76	3596.0
2023-02-23 02:00:00	ES	Futures	4490.76	4492.16	4488.52	4489.92	8280.0
2023-02-23 03:00:00	ES	Futures	4489.92	4499.71	4488.52	4494.12	28416.0
2023-02-23 04:00:00	ES	Futures	4494.4	4499.15	4484.05	4490.76	23662.0
2023-02-23 05:00:00	ES	Futures	4491.04	4492.16	4486.85	4490.76	13246.0
2023-02-23 06:00:00	ES	Futures	4490.48	4495.51	4486.85	4495.51	15024.0
2023-02-23 07:00:00	ES	Futures	4495.23	4497.75	4492.16	4495.51	23123.0
2023-02-23 08:00:00	ES	Futures	4495.23	4501.11	4485.73	4493.84	74591.0
2023-02-23 09:00:00	ES	Futures	4493.84	4512.01	4492.72	4507.82	269685.0
2023-02-23 10:00:00	ES	Futures	4507.82	4512.01	4474.26	4477.9	298041.0
2023-02-23 11:00:00	ES	Futures	4477.9	4483.49	4446.86	4447.7	275410.0
2023-02-23 12:00:00	ES	Futures	4447.7	4460.56	4444.91	4459.72	163035.0
2023-02-23 13:00:00	ES	Futures	4460.0	4469.51	4453.57	4466.99	151340.0
2023-02-23 14:00:00	ES	Futures	4466.99	4494.12	4463.36	4488.52	210511.0
2023-02-23 15:00:00	ES	Futures	4488.8	4505.58	4488.8	4494.4	245016.0
2023-02-23 16:00:00	ES	Futures	4494.68	4496.07	4489.64	4490.76	47200.0
2023-02-23 18:00:00	ES	Futures	4490.76	4492.44	4486.85	4487.41	6290.0
2023-02-23 19:00:00	ES	Futures	4487.13	4494.95	4486.01	4493.84	9475.0
2023-02-23 20:00:00	ES	Futures	4493.84	4499.71	4486.57	4491.04	16451.0
2023-02-23 21:00:00	ES	Futures	4491.04	4492.72	4488.52	4490.48	6546.0
2023-02-23 22:00:00	ES	Futures	4490.48	4494.95	4490.2	4493.84	4524.0
2023-02-23 23:00:00	ES	Futures	4494.12	4494.4	4489.64	4490.2	3678.0
2023-02-23 00:00:00	NQ	Futures	13890.42	13891.56	13868.52	13872.78	2776.0
2023-02-23 01:00:00	NQ	Futures	13872.78	13882.46	13868.8	13871.65	2029.0
2023-02-23 02:00:00	NQ	Futures	13871.65	13876.77	13861.69	13863.11	3849.0
2023-02-23 03:00:00	NQ	Futures	13863.68	13913.18	13854.29	13890.14	12111.0
2023-02-23 04:00:00	NQ	Futures	13890.14	13910.91	13827.26	13863.96	12852.0
2023-02-23 05:00:00	NQ	Futures	13863.68	13872.78	13851.16	13870.22	4873.0
2023-02-23 06:00:00	NQ	Futures	13869.65	13893.27	13858.27	13892.13	6710.0
2023-02-23 07:00:00	NQ	Futures	13891.85	13905.79	13879.33	13899.53	9428.0
2023-02-23 08:00:00	NQ	Futures	13899.24	13926.55	13866.53	13907.78	28200.0
2023-02-23 09:00:00	NQ	Futures	13907.21	13952.73	13880.18	13919.73	88463.0
2023-02-23 10:00:00	NQ	Futures	13920.01	13937.08	13772.07	13784.31	103026.0
2023-02-23 11:00:00	NQ	Futures	13784.88	13809.06	13689.85	13692.13	84912.0
2023-02-23 12:00:00	NQ	Futures	13692.7	13749.6	13688.15	13745.62	50919.0
2023-02-23 13:00:00	NQ	Futures	13746.18	13797.96	13718.87	13788.0	45452.0
2023-02-23 14:00:00	NQ	Futures	13788.0	13899.53	13774.63	13871.93	66726.0
2023-02-23 15:00:00	NQ	Futures	13873.35	13938.79	13873.07	13890.14	75042.0
2023-02-23 16:00:00	NQ	Futures	13889.85	13895.54	13869.94	13875.34	12316.0
2023-02-23 18:00:00	NQ	Futures	13871.93	13874.49	13851.16	13853.44	3983.0
2023-02-23 19:00:00	NQ	Futures	13853.15	13881.6	13849.74	13876.48	4025.0
2023-02-23 20:00:00	NQ	Futures	13877.34	13899.81	13840.92	13865.67	6032.0
2023-02-23 21:00:00	NQ	Futures	13865.1	13871.93	13854.29	13860.84	2552.0
2023-02-23 22:00:00	NQ	Futures	13860.27	13877.05	13859.41	13871.93	1990.0
2023-02-23 23:00:00	NQ	Futures	13872.5	13875.06	13853.44	13857.71	1748.0
2023-02-23 00:00:00	YM	Futures	36966.3	36966.3	36946.3	36950.7	516.0
2023-02-23 01:00:00	YM	Futures	36951.8	36965.2	36937.4	36937.4	579.0
2023-02-23 02:00:00	YM	Futures	36939.6	36951.8	36919.5	36937.4	1198.0
2023-02-23 03:00:00	YM	Futures	36936.2	37003.1	36930.7	36957.4	3029.0

> showing 50 of 2,035 rows — these rows as CSV

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