PREVIEW / futures_1hour / 2026-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2026/2026-07-31.parquet
  size:    53 KB
  rows:    1,704

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-31 00:00:00	ES	Futures	7496.75	7509.25	7492.5	7508.75	6533.0
2026-07-31 01:00:00	ES	Futures	7508.75	7510.75	7505.5	7508.25	7403.0
2026-07-31 02:00:00	ES	Futures	7508.25	7511.25	7491.75	7496.5	14774.0
2026-07-31 03:00:00	ES	Futures	7496.25	7509.25	7493.25	7506.75	20719.0
2026-07-31 04:00:00	ES	Futures	7506.5	7513.75	7503.0	7513.0	16305.0
2026-07-31 05:00:00	ES	Futures	7513.0	7517.75	7503.75	7504.25	15190.0
2026-07-31 06:00:00	ES	Futures	7504.0	7512.0	7502.0	7506.75	12207.0
2026-07-31 07:00:00	ES	Futures	7506.75	7511.5	7494.5	7499.25	17844.0
2026-07-31 08:00:00	ES	Futures	7499.5	7499.5	7479.5	7483.0	32637.0
2026-07-31 09:00:00	ES	Futures	7483.0	7515.5	7466.75	7470.75	239473.0
2026-07-31 10:00:00	ES	Futures	7470.5	7481.25	7427.5	7477.0	360020.0
2026-07-31 11:00:00	ES	Futures	7477.0	7485.0	7449.25	7482.5	210245.0
2026-07-31 12:00:00	ES	Futures	7482.5	7503.0	7475.75	7497.5	130317.0
2026-07-31 13:00:00	ES	Futures	7497.5	7517.0	7496.5	7506.0	114493.0
2026-07-31 14:00:00	ES	Futures	7505.75	7516.75	7504.25	7513.0	84554.0
2026-07-31 15:00:00	ES	Futures	7512.75	7541.0	7509.0	7520.0	310317.0
2026-07-31 16:00:00	ES	Futures	7520.25	7527.75	7499.0	7503.5	84756.0
2026-07-31 00:00:00	NQ	Futures	28458.25	28557.0	28423.0	28549.0	5114.0
2026-07-31 01:00:00	NQ	Futures	28548.75	28590.75	28538.5	28585.0	6135.0
2026-07-31 02:00:00	NQ	Futures	28585.5	28611.75	28450.0	28488.25	10519.0
2026-07-31 03:00:00	NQ	Futures	28484.25	28584.25	28455.0	28575.0	9607.0
2026-07-31 04:00:00	NQ	Futures	28572.75	28611.0	28524.75	28602.75	7917.0
2026-07-31 05:00:00	NQ	Futures	28603.25	28640.75	28528.5	28533.0	8198.0
2026-07-31 06:00:00	NQ	Futures	28531.75	28591.25	28519.5	28565.5	5795.0
2026-07-31 07:00:00	NQ	Futures	28563.25	28626.0	28523.0	28553.5	7967.0
2026-07-31 08:00:00	NQ	Futures	28554.75	28555.25	28432.25	28468.25	15477.0
2026-07-31 09:00:00	NQ	Futures	28468.5	28725.75	28295.5	28360.5	111095.0
2026-07-31 10:00:00	NQ	Futures	28356.75	28393.0	28079.75	28307.5	129516.0
2026-07-31 11:00:00	NQ	Futures	28308.75	28342.25	28115.5	28274.0	80163.0
2026-07-31 12:00:00	NQ	Futures	28274.0	28390.0	28243.75	28366.75	50009.0
2026-07-31 13:00:00	NQ	Futures	28367.25	28503.0	28360.0	28429.0	43750.0
2026-07-31 14:00:00	NQ	Futures	28429.0	28462.0	28395.25	28433.75	30777.0
2026-07-31 15:00:00	NQ	Futures	28433.5	28524.0	28380.0	28402.75	63467.0
2026-07-31 16:00:00	NQ	Futures	28402.5	28434.25	28258.25	28287.0	25778.0
2026-07-31 00:00:00	YM	Futures	52570.0	52633.0	52555.0	52629.0	805.0
2026-07-31 01:00:00	YM	Futures	52630.0	52639.0	52608.0	52615.0	608.0
2026-07-31 02:00:00	YM	Futures	52613.0	52628.0	52551.0	52590.0	1096.0
2026-07-31 03:00:00	YM	Futures	52591.0	52692.0	52571.0	52660.0	1890.0
2026-07-31 04:00:00	YM	Futures	52659.0	52697.0	52638.0	52664.0	1685.0
2026-07-31 05:00:00	YM	Futures	52666.0	52694.0	52617.0	52641.0	1151.0
2026-07-31 06:00:00	YM	Futures	52640.0	52742.0	52620.0	52725.0	1384.0
2026-07-31 07:00:00	YM	Futures	52726.0	52727.0	52594.0	52662.0	2312.0
2026-07-31 08:00:00	YM	Futures	52662.0	52664.0	52528.0	52552.0	2653.0
2026-07-31 09:00:00	YM	Futures	52553.0	52652.0	52339.0	52341.0	16650.0
2026-07-31 10:00:00	YM	Futures	52339.0	52445.0	52124.0	52434.0	15967.0
2026-07-31 11:00:00	YM	Futures	52433.0	52549.0	52357.0	52537.0	9455.0
2026-07-31 12:00:00	YM	Futures	52534.0	52613.0	52490.0	52576.0	5108.0
2026-07-31 13:00:00	YM	Futures	52575.0	52676.0	52560.0	52616.0	4220.0
2026-07-31 14:00:00	YM	Futures	52617.0	52691.0	52609.0	52662.0	3495.0
2026-07-31 15:00:00	YM	Futures	52667.0	52772.0	52616.0	52638.0	10760.0

> showing 50 of 1,704 rows — these rows as CSV

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