PREVIEW / etf_1hour / 2026-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-08.parquet
  size:    759 KB
  rows:    30,025

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-08 04:00:00	SPY	ETF	746.67	747.86	740.31	740.51	261659.0
2026-07-08 05:00:00	SPY	ETF	740.6	740.84	739.35	739.86	181937.0
2026-07-08 06:00:00	SPY	ETF	740.02	741.45	739.42	741.09	176341.0
2026-07-08 07:00:00	SPY	ETF	741.09	743.15	740.4929	742.31	594586.0
2026-07-08 08:00:00	SPY	ETF	742.27	744.3	741.821	742.96	418484.0
2026-07-08 09:00:00	SPY	ETF	743.0	744.925	742.64	744.04	4200058.0
2026-07-08 10:00:00	SPY	ETF	744.01	744.7	740.93	741.84	5875866.0
2026-07-08 11:00:00	SPY	ETF	741.83	742.03	739.51	740.64	4314656.0
2026-07-08 12:00:00	SPY	ETF	740.68	744.75	740.61	744.68	3811605.0
2026-07-08 13:00:00	SPY	ETF	744.66	746.09	743.95	744.39	3233620.0
2026-07-08 14:00:00	SPY	ETF	744.38	745.51	744.0	745.33	2812076.0
2026-07-08 15:00:00	SPY	ETF	745.34	746.15	744.41	745.34	6017938.0
2026-07-08 16:00:00	SPY	ETF	745.29	745.57	743.45	743.91	2220509.0
2026-07-08 17:00:00	SPY	ETF	744.08	744.45	743.95	744.38	65591.0
2026-07-08 18:00:00	SPY	ETF	744.33	744.84	744.25	744.42	67378.0
2026-07-08 19:00:00	SPY	ETF	744.5	745.3433	744.25	745.3433	63108.0
2026-07-08 04:00:00	QQQ	ETF	709.3	711.39	699.15	700.22	629360.0
2026-07-08 05:00:00	QQQ	ETF	700.19	700.81	697.86	698.95	213528.0
2026-07-08 06:00:00	QQQ	ETF	699.18	701.79	698.2	700.56	238186.0
2026-07-08 07:00:00	QQQ	ETF	700.51	702.97	699.46	702.18	465208.0
2026-07-08 08:00:00	QQQ	ETF	702.14	708.898	701.45	703.73	405143.0
2026-07-08 09:00:00	QQQ	ETF	703.83	709.8	703.64	708.95	5384387.0
2026-07-08 10:00:00	QQQ	ETF	708.97	709.47	703.75	705.21	4671295.0
2026-07-08 11:00:00	QQQ	ETF	705.26	705.52	700.91	702.405	3965599.0
2026-07-08 12:00:00	QQQ	ETF	702.51	709.17	702.34	709.07	3556468.0
2026-07-08 13:00:00	QQQ	ETF	709.1	711.14	707.88	708.605	2410170.0
2026-07-08 14:00:00	QQQ	ETF	708.64	710.39	708.02	709.9	1630605.0
2026-07-08 15:00:00	QQQ	ETF	709.93	712.2599	709.23	711.3	3490597.0
2026-07-08 16:00:00	QQQ	ETF	711.31	711.51	707.571	709.46	2040777.0
2026-07-08 17:00:00	QQQ	ETF	709.69	710.7	709.57	710.4	82474.0
2026-07-08 18:00:00	QQQ	ETF	710.36	711.0202	710.05	710.53	84941.0
2026-07-08 19:00:00	QQQ	ETF	710.57	712.4	709.88	712.24	139501.0
2026-07-08 04:00:00	IWM	ETF	295.07	296.39	291.7	291.91	85127.0
2026-07-08 05:00:00	IWM	ETF	291.95	292.09	291.35	291.83	195178.0
2026-07-08 06:00:00	IWM	ETF	291.82	292.85	291.66	292.62	338311.0
2026-07-08 07:00:00	IWM	ETF	292.61	294.26	292.35	293.62	457079.0
2026-07-08 08:00:00	IWM	ETF	293.67	294.67	293.46	293.98	117474.0
2026-07-08 09:00:00	IWM	ETF	294.03	295.1	293.61	294.72	2229533.0
2026-07-08 10:00:00	IWM	ETF	294.725	294.94	292.04	292.28	3223396.0
2026-07-08 11:00:00	IWM	ETF	292.3	292.55	290.68	291.01	3631609.0
2026-07-08 12:00:00	IWM	ETF	290.99	293.1	290.99	293.03	2709064.0
2026-07-08 13:00:00	IWM	ETF	293.01	293.69	292.44	293.01	1491029.0
2026-07-08 14:00:00	IWM	ETF	292.98	293.63	292.79	293.42	1452551.0
2026-07-08 15:00:00	IWM	ETF	293.45	293.92	292.51	293.47	2510440.0
2026-07-08 16:00:00	IWM	ETF	293.47	293.61	292.58	292.81	1336730.0
2026-07-08 17:00:00	IWM	ETF	292.89	292.99	292.5	292.73	38745.0
2026-07-08 18:00:00	IWM	ETF	292.84	293.12	292.7	292.751	134793.0
2026-07-08 19:00:00	IWM	ETF	292.88	293.29	292.71	293.25	35533.0
2026-07-08 04:00:00	DIA	ETF	527.53	528.05	521.96	522.08	33674.0
2026-07-08 05:00:00	DIA	ETF	521.83	522.08	521.27	521.46	17540.0

> showing 50 of 30,025 rows — these rows as CSV

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