PREVIEW / futures_1hour / 2026-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2026/2026-07-27.parquet
  size:    62 KB
  rows:    2,144

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
2026-07-27 00:00:00	ES	Futures	7499.5	7507.0	7498.75	7504.75	5259.0
2026-07-27 01:00:00	ES	Futures	7504.75	7517.0	7504.25	7514.5	8670.0
2026-07-27 02:00:00	ES	Futures	7514.5	7520.0	7510.75	7511.75	13199.0
2026-07-27 03:00:00	ES	Futures	7511.75	7517.25	7505.75	7505.75	15491.0
2026-07-27 04:00:00	ES	Futures	7505.75	7520.0	7505.5	7519.25	14962.0
2026-07-27 05:00:00	ES	Futures	7519.25	7524.75	7516.5	7522.25	11390.0
2026-07-27 06:00:00	ES	Futures	7522.25	7524.25	7518.5	7521.75	9523.0
2026-07-27 07:00:00	ES	Futures	7521.75	7522.0	7507.75	7511.75	18105.0
2026-07-27 08:00:00	ES	Futures	7511.75	7515.25	7504.5	7513.25	23760.0
2026-07-27 09:00:00	ES	Futures	7513.5	7515.25	7473.75	7474.0	168221.0
2026-07-27 10:00:00	ES	Futures	7474.0	7479.25	7423.0	7455.5	301157.0
2026-07-27 11:00:00	ES	Futures	7455.75	7461.75	7421.25	7433.0	178756.0
2026-07-27 12:00:00	ES	Futures	7433.0	7455.25	7424.25	7428.0	149651.0
2026-07-27 13:00:00	ES	Futures	7428.25	7436.5	7416.25	7436.0	101283.0
2026-07-27 14:00:00	ES	Futures	7436.25	7450.5	7424.0	7448.75	110256.0
2026-07-27 15:00:00	ES	Futures	7448.75	7456.75	7442.75	7449.25	165405.0
2026-07-27 16:00:00	ES	Futures	7449.0	7456.5	7445.0	7453.5	35665.0
2026-07-27 18:00:00	ES	Futures	7453.0	7456.0	7444.0	7444.5	5181.0
2026-07-27 19:00:00	ES	Futures	7444.5	7450.0	7440.0	7447.75	5213.0
2026-07-27 20:00:00	ES	Futures	7448.25	7452.0	7434.25	7437.75	12379.0
2026-07-27 21:00:00	ES	Futures	7437.5	7443.5	7425.0	7434.25	13381.0
2026-07-27 22:00:00	ES	Futures	7434.5	7435.75	7426.75	7430.5	8140.0
2026-07-27 23:00:00	ES	Futures	7430.5	7442.0	7424.0	7440.5	11050.0
2026-07-27 00:00:00	NQ	Futures	28614.0	28663.0	28597.75	28644.0	3535.0
2026-07-27 01:00:00	NQ	Futures	28646.25	28704.25	28638.0	28694.5	4323.0
2026-07-27 02:00:00	NQ	Futures	28694.5	28728.5	28680.0	28695.0	5599.0
2026-07-27 03:00:00	NQ	Futures	28692.75	28732.0	28661.25	28661.75	5655.0
2026-07-27 04:00:00	NQ	Futures	28661.0	28749.5	28658.5	28736.0	5273.0
2026-07-27 05:00:00	NQ	Futures	28737.0	28763.25	28718.25	28744.75	4894.0
2026-07-27 06:00:00	NQ	Futures	28744.0	28758.0	28726.25	28740.75	3808.0
2026-07-27 07:00:00	NQ	Futures	28742.0	28743.5	28645.5	28673.0	8279.0
2026-07-27 08:00:00	NQ	Futures	28673.25	28697.75	28629.25	28690.25	9855.0
2026-07-27 09:00:00	NQ	Futures	28692.0	28700.0	28341.25	28347.75	78136.0
2026-07-27 10:00:00	NQ	Futures	28347.75	28372.75	27939.0	28169.25	126917.0
2026-07-27 11:00:00	NQ	Futures	28171.0	28198.5	27980.25	28062.5	73106.0
2026-07-27 12:00:00	NQ	Futures	28062.75	28204.5	28027.75	28048.5	58991.0
2026-07-27 13:00:00	NQ	Futures	28047.0	28106.25	27986.0	28104.75	37766.0
2026-07-27 14:00:00	NQ	Futures	28104.75	28191.0	28019.25	28188.25	39552.0
2026-07-27 15:00:00	NQ	Futures	28188.75	28255.75	28155.25	28192.25	52717.0
2026-07-27 16:00:00	NQ	Futures	28192.75	28230.0	28169.25	28210.0	13627.0
2026-07-27 18:00:00	NQ	Futures	28210.5	28228.0	28123.5	28132.5	5442.0
2026-07-27 19:00:00	NQ	Futures	28131.75	28179.25	28105.25	28163.5	5657.0
2026-07-27 20:00:00	NQ	Futures	28164.75	28195.0	28052.75	28072.0	10329.0
2026-07-27 21:00:00	NQ	Futures	28072.0	28097.0	27969.0	28022.0	11340.0
2026-07-27 22:00:00	NQ	Futures	28021.75	28030.25	27951.5	27993.0	8344.0
2026-07-27 23:00:00	NQ	Futures	27993.0	28070.5	27932.5	28049.25	9835.0
2026-07-27 00:00:00	YM	Futures	52431.0	52475.0	52422.0	52464.0	344.0
2026-07-27 01:00:00	YM	Futures	52468.0	52536.0	52460.0	52520.0	761.0
2026-07-27 02:00:00	YM	Futures	52522.0	52558.0	52518.0	52535.0	1415.0
2026-07-27 03:00:00	YM	Futures	52531.0	52599.0	52517.0	52517.0	1626.0

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

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