PREVIEW / etf_1hour / 2026-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-28.parquet
  size:    688 KB
  rows:    27,894

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-28 04:00:00	SPY	ETF	714.35	715.92	713.5	714.57	65475.0
2026-04-28 05:00:00	SPY	ETF	714.67	714.71	713.41	713.84	57970.0
2026-04-28 06:00:00	SPY	ETF	713.92	714.02	713.23	713.58	92802.0
2026-04-28 07:00:00	SPY	ETF	713.52	713.74	710.19	710.52	404775.0
2026-04-28 08:00:00	SPY	ETF	710.56	711.6	709.41	711.54	627448.0
2026-04-28 09:00:00	SPY	ETF	711.56	712.88	710.7176	711.58	4751038.0
2026-04-28 10:00:00	SPY	ETF	711.585	712.36	709.25	710.52	5253385.0
2026-04-28 11:00:00	SPY	ETF	710.53	711.07	709.38	709.98	2711798.0
2026-04-28 12:00:00	SPY	ETF	709.98	710.59	709.36	710.18	1960416.0
2026-04-28 13:00:00	SPY	ETF	710.17	711.15	709.46	711.03	2069894.0
2026-04-28 14:00:00	SPY	ETF	711.04	711.65	710.76	711.52	2927865.0
2026-04-28 15:00:00	SPY	ETF	711.525	712.19	711.2	711.68	7059813.0
2026-04-28 16:00:00	SPY	ETF	711.69	712.17	711.33	711.81	3580784.0
2026-04-28 17:00:00	SPY	ETF	711.71	711.85	711.65	711.84	33517.0
2026-04-28 18:00:00	SPY	ETF	711.84	712.35	711.84	712.09	58435.0
2026-04-28 19:00:00	SPY	ETF	712.12	712.5	712.0	712.47	20802.0
2026-04-28 04:00:00	QQQ	ETF	663.0	664.21	660.945	662.11	244042.0
2026-04-28 05:00:00	QQQ	ETF	662.1	662.18	659.76	660.43	176229.0
2026-04-28 06:00:00	QQQ	ETF	660.41	660.8	659.31	659.91	126755.0
2026-04-28 07:00:00	QQQ	ETF	659.85	660.05	655.5	655.86	683634.0
2026-04-28 08:00:00	QQQ	ETF	655.87	657.275	654.5	657.16	746898.0
2026-04-28 09:00:00	QQQ	ETF	657.15	659.64	655.275	658.47	5707791.0
2026-04-28 10:00:00	QQQ	ETF	658.38	659.2	653.86	655.775	5154936.0
2026-04-28 11:00:00	QQQ	ETF	655.76	656.42	653.81	654.86	2582203.0
2026-04-28 12:00:00	QQQ	ETF	654.88	655.86	654.2501	655.58	1971846.0
2026-04-28 13:00:00	QQQ	ETF	655.6	657.03	654.7014	656.9897	1575966.0
2026-04-28 14:00:00	QQQ	ETF	656.9701	658.25	656.38	658.24	2153652.0
2026-04-28 15:00:00	QQQ	ETF	658.25	658.964	656.38	657.57	4163843.0
2026-04-28 16:00:00	QQQ	ETF	657.58	658.45	657.06	658.13	1187093.0
2026-04-28 17:00:00	QQQ	ETF	658.09	658.33	657.55	657.55	169309.0
2026-04-28 18:00:00	QQQ	ETF	658.36	659.09	658.3	658.85	78064.0
2026-04-28 19:00:00	QQQ	ETF	658.93	659.49	658.7	659.38	47215.0
2026-04-28 04:00:00	IWM	ETF	276.98	277.73	276.52	277.26	46078.0
2026-04-28 05:00:00	IWM	ETF	277.14	277.41	276.54	276.6	32809.0
2026-04-28 06:00:00	IWM	ETF	276.69	276.69	276.22	276.54	29508.0
2026-04-28 07:00:00	IWM	ETF	276.52	276.69	274.78	275.0	158085.0
2026-04-28 08:00:00	IWM	ETF	274.94	275.85	274.43	275.72	410443.0
2026-04-28 09:00:00	IWM	ETF	275.7	276.97	274.94	274.97	3323557.0
2026-04-28 10:00:00	IWM	ETF	274.98	275.13	272.915	273.77	3264982.0
2026-04-28 11:00:00	IWM	ETF	273.8	274.17	273.09	273.45	1539147.0
2026-04-28 12:00:00	IWM	ETF	273.48	273.7	273.11	273.61	873763.0
2026-04-28 13:00:00	IWM	ETF	273.595	273.92	273.18	273.83	1240933.0
2026-04-28 14:00:00	IWM	ETF	273.84	273.95	273.48	273.8	1384996.0
2026-04-28 15:00:00	IWM	ETF	273.795	274.12	273.27	273.92	2947647.0
2026-04-28 16:00:00	IWM	ETF	273.91	274.4	273.82	274.19	798223.0
2026-04-28 17:00:00	IWM	ETF	274.03	274.13	273.85	273.91	54640.0
2026-04-28 18:00:00	IWM	ETF	274.07	274.31	274.07	274.27	12654.0
2026-04-28 19:00:00	IWM	ETF	274.34	274.49	274.25	274.46	13769.0
2026-04-28 04:00:00	DIA	ETF	492.3	492.67	491.8	492.67	2974.0
2026-04-28 05:00:00	DIA	ETF	492.83	493.5	492.78	493.35	5869.0

> showing 50 of 27,894 rows — these rows as CSV

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