PREVIEW / futures_1hour / 2026-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2026/2026-06-29.parquet
  size:    59 KB
  rows:    2,087

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-06-29 00:00:00	ES	Futures	7450.25	7450.5	7439.75	7442.0	5563.0
2026-06-29 01:00:00	ES	Futures	7442.25	7458.5	7439.0	7457.25	10221.0
2026-06-29 02:00:00	ES	Futures	7457.0	7457.75	7444.25	7446.25	10780.0
2026-06-29 03:00:00	ES	Futures	7446.5	7453.25	7436.5	7451.5	12866.0
2026-06-29 04:00:00	ES	Futures	7451.25	7463.75	7450.25	7451.5	12145.0
2026-06-29 05:00:00	ES	Futures	7451.25	7459.25	7447.5	7454.5	10760.0
2026-06-29 06:00:00	ES	Futures	7454.75	7466.75	7452.5	7466.0	12598.0
2026-06-29 07:00:00	ES	Futures	7466.0	7473.75	7458.0	7463.5	16792.0
2026-06-29 08:00:00	ES	Futures	7463.5	7469.25	7455.25	7464.0	17594.0
2026-06-29 09:00:00	ES	Futures	7464.0	7490.0	7444.5	7458.5	219894.0
2026-06-29 10:00:00	ES	Futures	7458.5	7472.5	7409.0	7468.0	348329.0
2026-06-29 11:00:00	ES	Futures	7468.0	7475.75	7453.0	7475.0	147398.0
2026-06-29 12:00:00	ES	Futures	7475.25	7481.75	7470.0	7477.25	92124.0
2026-06-29 13:00:00	ES	Futures	7477.25	7498.75	7477.25	7494.0	93911.0
2026-06-29 14:00:00	ES	Futures	7494.0	7502.0	7491.25	7497.0	73725.0
2026-06-29 15:00:00	ES	Futures	7496.75	7505.0	7491.5	7496.75	185864.0
2026-06-29 16:00:00	ES	Futures	7497.0	7500.0	7491.25	7493.5	51249.0
2026-06-29 18:00:00	ES	Futures	7495.5	7497.5	7490.5	7494.5	5445.0
2026-06-29 19:00:00	ES	Futures	7494.5	7498.75	7491.75	7495.5	3445.0
2026-06-29 20:00:00	ES	Futures	7495.5	7501.0	7481.75	7492.5	11443.0
2026-06-29 21:00:00	ES	Futures	7492.75	7501.5	7484.0	7498.25	10212.0
2026-06-29 22:00:00	ES	Futures	7498.25	7498.5	7488.25	7491.5	5998.0
2026-06-29 23:00:00	ES	Futures	7491.25	7507.0	7490.25	7501.5	7220.0
2026-06-29 00:00:00	NQ	Futures	29592.0	29593.25	29505.0	29518.0	5564.0
2026-06-29 01:00:00	NQ	Futures	29520.0	29672.25	29491.5	29670.75	7069.0
2026-06-29 02:00:00	NQ	Futures	29670.25	29684.75	29590.0	29631.5	6982.0
2026-06-29 03:00:00	NQ	Futures	29631.5	29698.5	29575.75	29664.25	6296.0
2026-06-29 04:00:00	NQ	Futures	29663.5	29732.75	29652.75	29660.25	6770.0
2026-06-29 05:00:00	NQ	Futures	29658.75	29688.25	29620.0	29664.0	5169.0
2026-06-29 06:00:00	NQ	Futures	29666.25	29746.0	29666.25	29740.5	6218.0
2026-06-29 07:00:00	NQ	Futures	29742.25	29759.75	29683.5	29705.5	7446.0
2026-06-29 08:00:00	NQ	Futures	29705.25	29739.25	29650.25	29705.0	7432.0
2026-06-29 09:00:00	NQ	Futures	29705.75	29840.0	29557.0	29617.75	63315.0
2026-06-29 10:00:00	NQ	Futures	29618.75	29716.5	29273.75	29713.75	103922.0
2026-06-29 11:00:00	NQ	Futures	29714.25	29847.25	29659.25	29838.75	55071.0
2026-06-29 12:00:00	NQ	Futures	29839.75	29932.5	29834.25	29915.5	38599.0
2026-06-29 13:00:00	NQ	Futures	29916.0	30038.25	29915.75	30003.5	35179.0
2026-06-29 14:00:00	NQ	Futures	30004.0	30069.5	29986.5	30032.25	29217.0
2026-06-29 15:00:00	NQ	Futures	30032.75	30069.0	29973.75	30046.25	52970.0
2026-06-29 16:00:00	NQ	Futures	30046.75	30051.75	29991.25	29995.0	16211.0
2026-06-29 18:00:00	NQ	Futures	30007.25	30035.5	29970.25	30012.25	5603.0
2026-06-29 19:00:00	NQ	Futures	30011.25	30054.0	30006.0	30041.0	4216.0
2026-06-29 20:00:00	NQ	Futures	30040.0	30086.0	29934.75	30009.5	11288.0
2026-06-29 21:00:00	NQ	Futures	30010.75	30079.25	29951.0	30053.25	8775.0
2026-06-29 22:00:00	NQ	Futures	30054.5	30056.75	29977.5	30020.25	4807.0
2026-06-29 23:00:00	NQ	Futures	30021.5	30130.75	30011.0	30095.0	5279.0
2026-06-29 00:00:00	YM	Futures	52382.0	52382.0	52341.0	52360.0	455.0
2026-06-29 01:00:00	YM	Futures	52361.0	52439.0	52350.0	52432.0	935.0
2026-06-29 02:00:00	YM	Futures	52432.0	52433.0	52343.0	52354.0	886.0
2026-06-29 03:00:00	YM	Futures	52353.0	52419.0	52290.0	52412.0	1131.0

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

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