PREVIEW / futures_1hour / 2026-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2026/2026-07-02.parquet
  size:    61 KB
  rows:    2,068

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-02 00:00:00	ES	Futures	7554.75	7556.0	7541.25	7548.25	6265.0
2026-07-02 01:00:00	ES	Futures	7548.5	7555.0	7541.25	7542.75	7484.0
2026-07-02 02:00:00	ES	Futures	7542.75	7544.5	7526.25	7530.5	12930.0
2026-07-02 03:00:00	ES	Futures	7530.5	7536.75	7520.25	7531.0	16080.0
2026-07-02 04:00:00	ES	Futures	7531.0	7545.0	7522.5	7542.25	14533.0
2026-07-02 05:00:00	ES	Futures	7542.25	7542.5	7534.5	7537.25	8716.0
2026-07-02 06:00:00	ES	Futures	7537.25	7544.25	7531.75	7543.0	8722.0
2026-07-02 07:00:00	ES	Futures	7543.0	7549.5	7538.5	7543.5	11884.0
2026-07-02 08:00:00	ES	Futures	7543.5	7576.75	7541.0	7561.75	54820.0
2026-07-02 09:00:00	ES	Futures	7561.75	7593.75	7551.5	7588.75	196205.0
2026-07-02 10:00:00	ES	Futures	7588.75	7593.5	7540.25	7557.25	312227.0
2026-07-02 11:00:00	ES	Futures	7557.25	7559.0	7520.75	7526.75	252339.0
2026-07-02 12:00:00	ES	Futures	7527.0	7529.5	7498.0	7501.5	164321.0
2026-07-02 13:00:00	ES	Futures	7501.5	7503.0	7479.5	7482.0	141815.0
2026-07-02 14:00:00	ES	Futures	7482.25	7514.75	7480.0	7509.0	125064.0
2026-07-02 15:00:00	ES	Futures	7509.25	7534.0	7491.75	7526.25	226894.0
2026-07-02 16:00:00	ES	Futures	7526.25	7527.25	7517.75	7523.0	59053.0
2026-07-02 18:00:00	ES	Futures	7523.75	7536.0	7523.75	7535.5	4292.0
2026-07-02 19:00:00	ES	Futures	7535.25	7537.75	7529.25	7536.25	4600.0
2026-07-02 20:00:00	ES	Futures	7536.0	7540.25	7527.25	7529.75	7877.0
2026-07-02 21:00:00	ES	Futures	7530.25	7550.75	7529.5	7549.25	10700.0
2026-07-02 22:00:00	ES	Futures	7549.5	7553.25	7548.25	7552.75	5157.0
2026-07-02 23:00:00	ES	Futures	7552.5	7555.25	7548.0	7554.0	3491.0
2026-07-02 00:00:00	NQ	Futures	30173.5	30188.25	30050.0	30111.25	5650.0
2026-07-02 01:00:00	NQ	Futures	30114.0	30159.75	30037.25	30051.0	6964.0
2026-07-02 02:00:00	NQ	Futures	30052.0	30066.0	29895.0	29919.75	10894.0
2026-07-02 03:00:00	NQ	Futures	29921.25	29944.5	29826.25	29891.25	10690.0
2026-07-02 04:00:00	NQ	Futures	29893.5	30038.25	29827.25	30033.0	9730.0
2026-07-02 05:00:00	NQ	Futures	30032.75	30033.5	29943.5	29957.75	6395.0
2026-07-02 06:00:00	NQ	Futures	29959.5	30008.5	29920.0	30005.75	5871.0
2026-07-02 07:00:00	NQ	Futures	30005.25	30079.0	29967.0	30034.25	9644.0
2026-07-02 08:00:00	NQ	Futures	30035.25	30320.0	30022.25	30182.75	26532.0
2026-07-02 09:00:00	NQ	Futures	30185.0	30263.0	30007.75	30257.75	77448.0
2026-07-02 10:00:00	NQ	Futures	30258.0	30293.5	29730.75	29840.25	108400.0
2026-07-02 11:00:00	NQ	Futures	29840.25	29852.0	29610.75	29676.0	72654.0
2026-07-02 12:00:00	NQ	Futures	29676.75	29688.25	29434.0	29462.25	61695.0
2026-07-02 13:00:00	NQ	Futures	29461.0	29482.75	29328.5	29338.5	48138.0
2026-07-02 14:00:00	NQ	Futures	29339.5	29528.0	29330.5	29489.0	46973.0
2026-07-02 15:00:00	NQ	Futures	29488.75	29588.0	29349.5	29538.0	62920.0
2026-07-02 16:00:00	NQ	Futures	29537.75	29564.75	29514.0	29551.75	18962.0
2026-07-02 18:00:00	NQ	Futures	29566.0	29622.25	29559.25	29618.75	3563.0
2026-07-02 19:00:00	NQ	Futures	29615.75	29618.75	29552.0	29600.5	4936.0
2026-07-02 20:00:00	NQ	Futures	29598.75	29638.75	29522.0	29536.5	6700.0
2026-07-02 21:00:00	NQ	Futures	29539.5	29699.5	29535.25	29682.5	6840.0
2026-07-02 22:00:00	NQ	Futures	29684.75	29755.75	29680.5	29750.75	4048.0
2026-07-02 23:00:00	NQ	Futures	29749.75	29775.25	29717.75	29767.5	3669.0
2026-07-02 00:00:00	YM	Futures	52718.0	52719.0	52666.0	52687.0	446.0
2026-07-02 01:00:00	YM	Futures	52686.0	52703.0	52650.0	52654.0	644.0
2026-07-02 02:00:00	YM	Futures	52650.0	52664.0	52589.0	52592.0	1312.0
2026-07-02 03:00:00	YM	Futures	52591.0	52653.0	52551.0	52632.0	1701.0

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

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