PREVIEW / futures_1hour / 2023-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-24.parquet
  size:    68 KB
  rows:    2,054

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-05-24 00:00:00	ES	Futures	4618.49	4620.98	4618.49	4620.43	2840.0
2023-05-24 01:00:00	ES	Futures	4620.71	4621.82	4614.61	4615.44	6318.0
2023-05-24 02:00:00	ES	Futures	4615.44	4615.99	4609.06	4611.83	12777.0
2023-05-24 03:00:00	ES	Futures	4611.83	4611.83	4596.02	4598.8	40893.0
2023-05-24 04:00:00	ES	Futures	4599.07	4611.55	4597.69	4610.72	29645.0
2023-05-24 05:00:00	ES	Futures	4610.72	4612.66	4602.96	4602.96	17875.0
2023-05-24 06:00:00	ES	Futures	4602.96	4606.84	4593.53	4597.69	29710.0
2023-05-24 07:00:00	ES	Futures	4597.96	4599.63	4592.42	4593.8	21983.0
2023-05-24 08:00:00	ES	Futures	4594.08	4601.02	4590.75	4591.59	37347.0
2023-05-24 09:00:00	ES	Futures	4591.59	4594.36	4576.89	4578.55	220546.0
2023-05-24 10:00:00	ES	Futures	4578.55	4581.32	4568.84	4571.06	290363.0
2023-05-24 11:00:00	ES	Futures	4570.78	4587.15	4567.46	4570.51	245811.0
2023-05-24 12:00:00	ES	Futures	4570.51	4576.61	4564.13	4572.45	129717.0
2023-05-24 13:00:00	ES	Futures	4572.45	4582.99	4565.51	4578.55	120307.0
2023-05-24 14:00:00	ES	Futures	4578.83	4582.99	4566.9	4570.78	138510.0
2023-05-24 15:00:00	ES	Futures	4570.78	4597.13	4567.46	4578.27	349006.0
2023-05-24 16:00:00	ES	Futures	4578.55	4605.18	4574.94	4604.9	133111.0
2023-05-24 18:00:00	ES	Futures	4611.83	4611.83	4583.54	4595.47	29638.0
2023-05-24 19:00:00	ES	Futures	4595.47	4601.57	4593.53	4597.96	9756.0
2023-05-24 20:00:00	ES	Futures	4598.24	4600.46	4595.47	4598.52	11669.0
2023-05-24 21:00:00	ES	Futures	4598.52	4600.74	4589.37	4592.97	12574.0
2023-05-24 22:00:00	ES	Futures	4592.97	4597.13	4590.2	4594.91	6761.0
2023-05-24 23:00:00	ES	Futures	4595.19	4597.96	4593.53	4593.8	7265.0
2023-05-24 00:00:00	NQ	Futures	15478.66	15487.11	15478.1	15484.01	1567.0
2023-05-24 01:00:00	NQ	Futures	15484.29	15487.95	15462.05	15466.27	3577.0
2023-05-24 02:00:00	NQ	Futures	15466.55	15467.11	15443.75	15458.11	6247.0
2023-05-24 03:00:00	NQ	Futures	15457.54	15457.54	15417.0	15427.7	13599.0
2023-05-24 04:00:00	NQ	Futures	15428.26	15456.42	15420.38	15452.76	10280.0
2023-05-24 05:00:00	NQ	Futures	15452.47	15464.3	15439.8	15440.65	7876.0
2023-05-24 06:00:00	NQ	Futures	15440.93	15452.19	15404.61	15416.44	11984.0
2023-05-24 07:00:00	NQ	Futures	15416.15	15424.04	15386.31	15391.94	11715.0
2023-05-24 08:00:00	NQ	Futures	15391.94	15409.96	15365.76	15368.29	16512.0
2023-05-24 09:00:00	NQ	Futures	15368.57	15400.95	15339.85	15364.91	95075.0
2023-05-24 10:00:00	NQ	Futures	15365.19	15373.08	15282.98	15294.52	111466.0
2023-05-24 11:00:00	NQ	Futures	15295.09	15356.18	15278.76	15313.11	86334.0
2023-05-24 12:00:00	NQ	Futures	15313.95	15343.51	15289.74	15319.86	44260.0
2023-05-24 13:00:00	NQ	Futures	15319.86	15367.73	15291.99	15355.9	46570.0
2023-05-24 14:00:00	NQ	Futures	15357.31	15370.26	15318.45	15331.41	56254.0
2023-05-24 15:00:00	NQ	Futures	15331.69	15435.58	15318.17	15375.89	102630.0
2023-05-24 16:00:00	NQ	Futures	15376.17	15593.25	15362.66	15589.31	51105.0
2023-05-24 18:00:00	NQ	Futures	15628.44	15636.05	15545.11	15576.36	20267.0
2023-05-24 19:00:00	NQ	Futures	15576.64	15607.61	15567.07	15594.66	8168.0
2023-05-24 20:00:00	NQ	Futures	15594.66	15601.42	15584.24	15598.6	5396.0
2023-05-24 21:00:00	NQ	Futures	15598.32	15610.71	15569.88	15579.45	7484.0
2023-05-24 22:00:00	NQ	Futures	15578.61	15590.15	15568.19	15583.96	3745.0
2023-05-24 23:00:00	NQ	Futures	15583.68	15592.97	15580.3	15584.24	2639.0
2023-05-24 00:00:00	YM	Futures	36653.1	36667.5	36652.0	36664.2	452.0
2023-05-24 01:00:00	YM	Futures	36665.3	36675.2	36633.2	36638.8	917.0
2023-05-24 02:00:00	YM	Futures	36638.8	36641.0	36592.3	36610.0	2237.0
2023-05-24 03:00:00	YM	Futures	36611.1	36611.1	36470.8	36489.5	6712.0

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

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