PREVIEW / etf_1hour / 2026-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-07.parquet
  size:    757 KB
  rows:    30,859

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-04-07 04:00:00	SPY	ETF	656.45	659.5212	655.41	659.31	111957.0
2026-04-07 05:00:00	SPY	ETF	659.32	660.36	659.03	660.0	48134.0
2026-04-07 06:00:00	SPY	ETF	659.9	660.09	655.11	655.5	648086.0
2026-04-07 07:00:00	SPY	ETF	655.48	656.8	654.84	655.75	677721.0
2026-04-07 08:00:00	SPY	ETF	655.75	657.68	653.91	656.12	1144168.0
2026-04-07 09:00:00	SPY	ETF	656.12	657.58	654.16	654.56	4173490.0
2026-04-07 10:00:00	SPY	ETF	654.56	655.34	651.92	652.95	8627144.0
2026-04-07 11:00:00	SPY	ETF	652.95	654.4	651.06	653.6302	6999478.0
2026-04-07 12:00:00	SPY	ETF	653.64	657.0	653.56	656.39	5228838.0
2026-04-07 13:00:00	SPY	ETF	656.4	658.4	655.48	656.78	3855725.0
2026-04-07 14:00:00	SPY	ETF	656.77	657.02	653.4301	653.99	4297630.0
2026-04-07 15:00:00	SPY	ETF	653.96	659.2	653.4122	658.54	13740749.0
2026-04-07 16:00:00	SPY	ETF	658.54	660.99	658.51	660.05	4650107.0
2026-04-07 17:00:00	SPY	ETF	660.05	661.09	659.92	660.9	614186.0
2026-04-07 18:00:00	SPY	ETF	660.88	672.14	656.0	671.72	3581448.0
2026-04-07 19:00:00	SPY	ETF	671.72	675.15	670.28	673.87	1912456.0
2026-04-07 20:00:00	SPY	ETF	673.87	673.99	673.55	673.6406	9054.0
2026-04-07 04:00:00	QQQ	ETF	585.52	589.0	584.69	588.51	245682.0
2026-04-07 05:00:00	QQQ	ETF	588.62	589.9	588.29	589.23	124044.0
2026-04-07 06:00:00	QQQ	ETF	589.22	589.24	584.21	584.6885	321552.0
2026-04-07 07:00:00	QQQ	ETF	584.64	585.95	584.0	584.93	391977.0
2026-04-07 08:00:00	QQQ	ETF	584.91	586.46	582.97	584.97	770297.0
2026-04-07 09:00:00	QQQ	ETF	584.99	587.06	583.119	583.32	4167998.0
2026-04-07 10:00:00	QQQ	ETF	583.32	583.41	579.69	580.44	7006521.0
2026-04-07 11:00:00	QQQ	ETF	580.44	582.98	578.4001	582.22	4794181.0
2026-04-07 12:00:00	QQQ	ETF	582.21	585.62	582.18	584.96	4087066.0
2026-04-07 13:00:00	QQQ	ETF	584.954	586.99	583.9	585.27	3415166.0
2026-04-07 14:00:00	QQQ	ETF	585.235	585.5399	581.66	582.26	3025475.0
2026-04-07 15:00:00	QQQ	ETF	582.26	588.35	581.82	588.02	8357410.0
2026-04-07 16:00:00	QQQ	ETF	588.0	590.6	587.96	589.3881	2634844.0
2026-04-07 17:00:00	QQQ	ETF	589.39	590.8756	589.16	590.78	543853.0
2026-04-07 18:00:00	QQQ	ETF	590.79	601.47	588.7	601.2279	2172800.0
2026-04-07 19:00:00	QQQ	ETF	601.2	605.87	599.8147	605.2	1911218.0
2026-04-07 20:00:00	QQQ	ETF	605.1892	605.3	604.96	605.17	44345.0
2026-04-07 04:00:00	IWM	ETF	251.2	252.66	250.39	252.44	89630.0
2026-04-07 05:00:00	IWM	ETF	252.39	252.99	252.39	252.66	26270.0
2026-04-07 06:00:00	IWM	ETF	252.65	252.69	250.08	250.38	285868.0
2026-04-07 07:00:00	IWM	ETF	250.4	250.98	250.13	250.58	748096.0
2026-04-07 08:00:00	IWM	ETF	250.57	251.54	249.67	250.71	566971.0
2026-04-07 09:00:00	IWM	ETF	250.69	251.75	250.13	250.68	2773966.0
2026-04-07 10:00:00	IWM	ETF	250.64	251.73	249.6	250.56	3753106.0
2026-04-07 11:00:00	IWM	ETF	250.58	251.13	249.52	250.77	2134790.0
2026-04-07 12:00:00	IWM	ETF	250.78	252.76	250.72	251.85	2593511.0
2026-04-07 13:00:00	IWM	ETF	251.86	253.48	251.51	252.32	1493448.0
2026-04-07 14:00:00	IWM	ETF	252.32	252.37	250.42	250.78	1978020.0
2026-04-07 15:00:00	IWM	ETF	250.76	252.93	250.4	252.545	4709332.0
2026-04-07 16:00:00	IWM	ETF	252.54	253.7369	252.5	253.37	1855655.0
2026-04-07 17:00:00	IWM	ETF	253.38	254.4	253.21	254.238	278803.0
2026-04-07 18:00:00	IWM	ETF	254.23	260.02	252.51	259.9822	881092.0
2026-04-07 19:00:00	IWM	ETF	260.01	261.76	259.89	261.76	1114810.0

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

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