PREVIEW / futures_1hour / 2026-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2026/2026-07-09.parquet
  size:    60 KB
  rows:    2,074

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-09 00:00:00	ES	Futures	7539.0	7547.0	7535.0	7546.0	5813.0
2026-07-09 01:00:00	ES	Futures	7546.0	7554.0	7536.0	7552.5	12730.0
2026-07-09 02:00:00	ES	Futures	7552.25	7553.5	7547.0	7549.75	11183.0
2026-07-09 03:00:00	ES	Futures	7549.75	7557.75	7548.0	7553.5	14449.0
2026-07-09 04:00:00	ES	Futures	7553.5	7558.0	7542.0	7545.75	13287.0
2026-07-09 05:00:00	ES	Futures	7545.5	7546.5	7533.25	7541.75	10165.0
2026-07-09 06:00:00	ES	Futures	7541.75	7544.0	7526.75	7534.5	13117.0
2026-07-09 07:00:00	ES	Futures	7534.5	7546.5	7531.0	7543.25	16673.0
2026-07-09 08:00:00	ES	Futures	7543.25	7554.5	7542.25	7544.5	22829.0
2026-07-09 09:00:00	ES	Futures	7544.75	7566.5	7530.25	7561.25	148992.0
2026-07-09 10:00:00	ES	Futures	7561.25	7564.5	7529.5	7562.0	196334.0
2026-07-09 11:00:00	ES	Futures	7562.0	7578.0	7560.5	7573.75	120100.0
2026-07-09 12:00:00	ES	Futures	7573.75	7584.25	7573.75	7579.5	65253.0
2026-07-09 13:00:00	ES	Futures	7579.75	7595.0	7579.5	7591.5	84610.0
2026-07-09 14:00:00	ES	Futures	7591.25	7594.0	7583.0	7585.0	63548.0
2026-07-09 15:00:00	ES	Futures	7585.25	7591.0	7581.0	7590.5	129527.0
2026-07-09 16:00:00	ES	Futures	7590.5	7592.0	7584.75	7586.25	36531.0
2026-07-09 18:00:00	ES	Futures	7587.25	7589.0	7583.75	7586.75	3811.0
2026-07-09 19:00:00	ES	Futures	7586.75	7591.75	7585.0	7588.5	4008.0
2026-07-09 20:00:00	ES	Futures	7588.5	7589.5	7574.5	7580.75	12732.0
2026-07-09 21:00:00	ES	Futures	7580.75	7583.75	7576.0	7580.25	9161.0
2026-07-09 22:00:00	ES	Futures	7580.25	7586.5	7577.0	7586.25	8240.0
2026-07-09 23:00:00	ES	Futures	7586.25	7588.5	7581.75	7583.25	5957.0
2026-07-09 00:00:00	NQ	Futures	29507.5	29558.5	29462.5	29554.0	4462.0
2026-07-09 01:00:00	NQ	Futures	29554.75	29610.0	29474.75	29607.75	7882.0
2026-07-09 02:00:00	NQ	Futures	29606.5	29644.25	29572.25	29612.0	7240.0
2026-07-09 03:00:00	NQ	Futures	29613.25	29706.75	29603.75	29686.25	8869.0
2026-07-09 04:00:00	NQ	Futures	29684.75	29735.75	29643.0	29661.25	7193.0
2026-07-09 05:00:00	NQ	Futures	29663.5	29669.0	29613.75	29644.0	4155.0
2026-07-09 06:00:00	NQ	Futures	29645.5	29669.0	29564.5	29600.25	5617.0
2026-07-09 07:00:00	NQ	Futures	29601.75	29721.75	29579.0	29696.0	9800.0
2026-07-09 08:00:00	NQ	Futures	29696.75	29786.5	29681.0	29736.0	14082.0
2026-07-09 09:00:00	NQ	Futures	29735.25	29931.25	29672.0	29909.5	68192.0
2026-07-09 10:00:00	NQ	Futures	29910.0	29922.75	29614.5	29787.75	83651.0
2026-07-09 11:00:00	NQ	Futures	29788.25	29905.25	29779.5	29886.25	39757.0
2026-07-09 12:00:00	NQ	Futures	29886.5	29924.25	29864.0	29897.25	29518.0
2026-07-09 13:00:00	NQ	Futures	29897.0	29993.5	29893.5	29973.75	31823.0
2026-07-09 14:00:00	NQ	Futures	29974.75	29985.0	29929.5	29939.25	25260.0
2026-07-09 15:00:00	NQ	Futures	29939.75	29958.25	29896.75	29948.75	48997.0
2026-07-09 16:00:00	NQ	Futures	29948.5	29973.75	29926.25	29931.25	14337.0
2026-07-09 18:00:00	NQ	Futures	29937.75	29961.0	29904.0	29922.0	4527.0
2026-07-09 19:00:00	NQ	Futures	29921.5	29964.25	29907.0	29932.5	4502.0
2026-07-09 20:00:00	NQ	Futures	29933.25	29952.0	29804.25	29866.5	13167.0
2026-07-09 21:00:00	NQ	Futures	29866.5	29922.75	29817.5	29891.5	7734.0
2026-07-09 22:00:00	NQ	Futures	29895.0	29952.5	29854.25	29952.0	6748.0
2026-07-09 23:00:00	NQ	Futures	29952.0	29963.5	29912.5	29932.25	3430.0
2026-07-09 00:00:00	YM	Futures	52695.0	52724.0	52685.0	52718.0	371.0
2026-07-09 01:00:00	YM	Futures	52719.0	52754.0	52670.0	52753.0	869.0
2026-07-09 02:00:00	YM	Futures	52752.0	52760.0	52690.0	52704.0	911.0
2026-07-09 03:00:00	YM	Futures	52705.0	52736.0	52674.0	52699.0	1117.0

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

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