PREVIEW / futures_1hour / 2025-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2025/2025-05-07.parquet
  size:    69 KB
  rows:    2,135

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
2025-05-07 00:00:00	ES	Futures	5749.94	5757.82	5749.69	5752.23	3338.0
2025-05-07 01:00:00	ES	Futures	5752.48	5752.48	5742.07	5743.85	4969.0
2025-05-07 02:00:00	ES	Futures	5743.85	5748.67	5737.49	5742.83	6814.0
2025-05-07 03:00:00	ES	Futures	5742.83	5751.97	5740.8	5750.45	9765.0
2025-05-07 04:00:00	ES	Futures	5750.45	5754.26	5742.58	5750.96	8457.0
2025-05-07 05:00:00	ES	Futures	5751.21	5754.01	5743.85	5748.16	7072.0
2025-05-07 06:00:00	ES	Futures	5748.16	5755.28	5742.83	5751.21	8097.0
2025-05-07 07:00:00	ES	Futures	5751.47	5759.34	5746.64	5750.96	10474.0
2025-05-07 08:00:00	ES	Futures	5750.96	5751.72	5733.18	5736.48	22307.0
2025-05-07 09:00:00	ES	Futures	5736.22	5743.85	5722.25	5742.32	130196.0
2025-05-07 10:00:00	ES	Futures	5742.32	5747.91	5717.17	5722.0	126944.0
2025-05-07 11:00:00	ES	Futures	5721.74	5729.11	5710.82	5727.08	138967.0
2025-05-07 12:00:00	ES	Futures	5727.08	5742.32	5718.19	5740.54	84456.0
2025-05-07 13:00:00	ES	Futures	5740.54	5747.15	5715.39	5718.7	103609.0
2025-05-07 14:00:00	ES	Futures	5718.7	5740.29	5686.43	5736.22	215144.0
2025-05-07 15:00:00	ES	Futures	5736.48	5766.71	5701.93	5740.03	315504.0
2025-05-07 16:00:00	ES	Futures	5740.29	5752.48	5733.94	5736.99	50984.0
2025-05-07 18:00:00	ES	Futures	5734.45	5739.02	5727.59	5736.22	5841.0
2025-05-07 19:00:00	ES	Futures	5736.48	5743.08	5735.72	5736.99	2757.0
2025-05-07 20:00:00	ES	Futures	5737.24	5760.87	5732.41	5756.04	12274.0
2025-05-07 21:00:00	ES	Futures	5756.04	5776.36	5752.74	5762.64	17041.0
2025-05-07 22:00:00	ES	Futures	5762.64	5774.84	5762.64	5772.3	5816.0
2025-05-07 23:00:00	ES	Futures	5772.3	5789.83	5770.52	5788.56	9012.0
2025-05-07 00:00:00	NQ	Futures	20374.26	20408.38	20373.24	20385.46	3433.0
2025-05-07 01:00:00	NQ	Futures	20386.99	20387.76	20342.94	20351.34	4203.0
2025-05-07 02:00:00	NQ	Futures	20350.07	20373.75	20324.35	20352.87	5439.0
2025-05-07 03:00:00	NQ	Futures	20352.87	20393.36	20345.23	20385.97	6502.0
2025-05-07 04:00:00	NQ	Futures	20386.48	20397.69	20341.16	20379.86	8039.0
2025-05-07 05:00:00	NQ	Futures	20379.35	20391.07	20342.68	20362.55	5359.0
2025-05-07 06:00:00	NQ	Futures	20362.04	20379.86	20338.35	20368.4	6083.0
2025-05-07 07:00:00	NQ	Futures	20369.68	20403.04	20352.11	20367.89	6970.0
2025-05-07 08:00:00	NQ	Futures	20367.64	20369.68	20278.51	20303.47	15839.0
2025-05-07 09:00:00	NQ	Futures	20303.21	20315.94	20227.07	20308.56	60520.0
2025-05-07 10:00:00	NQ	Futures	20307.8	20349.05	20198.29	20212.3	61081.0
2025-05-07 11:00:00	NQ	Futures	20213.06	20226.82	20155.26	20219.43	65777.0
2025-05-07 12:00:00	NQ	Futures	20217.39	20274.69	20174.61	20269.09	38598.0
2025-05-07 13:00:00	NQ	Futures	20268.83	20296.59	20171.05	20187.6	35685.0
2025-05-07 14:00:00	NQ	Futures	20186.33	20273.42	20044.99	20256.36	87703.0
2025-05-07 15:00:00	NQ	Futures	20256.61	20426.72	20131.83	20320.27	102284.0
2025-05-07 16:00:00	NQ	Futures	20321.04	20370.95	20286.15	20328.93	19999.0
2025-05-07 18:00:00	NQ	Futures	20305.5	20328.68	20281.31	20314.67	3626.0
2025-05-07 19:00:00	NQ	Futures	20314.93	20350.07	20311.87	20324.35	3364.0
2025-05-07 20:00:00	NQ	Futures	20324.09	20412.46	20296.34	20400.49	8943.0
2025-05-07 21:00:00	NQ	Futures	20400.23	20498.02	20386.23	20439.45	12673.0
2025-05-07 22:00:00	NQ	Futures	20441.49	20490.38	20441.23	20472.81	4661.0
2025-05-07 23:00:00	NQ	Futures	20472.05	20545.39	20470.26	20539.27	6680.0
2025-05-07 00:00:00	YM	Futures	42344.1	42387.3	42337.9	42348.2	554.0
2025-05-07 01:00:00	YM	Futures	42347.1	42349.2	42296.7	42307.0	733.0
2025-05-07 02:00:00	YM	Futures	42305.0	42332.7	42267.9	42290.5	993.0
2025-05-07 03:00:00	YM	Futures	42289.5	42346.1	42279.2	42334.8	1321.0

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

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