PREVIEW / etf_1hour / 2026-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-21.parquet
  size:    730 KB
  rows:    28,907

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-08-21 04:00:00	SPY	ETF	764.69	766.6	762.91	765.22	76688.0
2026-08-21 05:00:00	SPY	ETF	765.22	765.28	764.68	765.26	19648.0
2026-08-21 06:00:00	SPY	ETF	765.25	765.63	765.0	765.202	25360.0
2026-08-21 07:00:00	SPY	ETF	765.24	766.34	764.91	765.93	300221.0
2026-08-21 08:00:00	SPY	ETF	765.96	766.85	765.75	766.45	250259.0
2026-08-21 09:00:00	SPY	ETF	766.47	766.61	764.17	764.5124	3859529.0
2026-08-21 10:00:00	SPY	ETF	764.53	765.835	764.215	765.8151	3196781.0
2026-08-21 11:00:00	SPY	ETF	765.81	767.85	765.455	767.2	3585078.0
2026-08-21 12:00:00	SPY	ETF	767.2	767.3299	765.81	766.39	2788312.0
2026-08-21 13:00:00	SPY	ETF	766.39	766.53	765.43	765.43	1873373.0
2026-08-21 14:00:00	SPY	ETF	765.44	766.23	765.06	766.1975	2169026.0
2026-08-21 15:00:00	SPY	ETF	766.2	766.8	765.34	765.69	6443470.0
2026-08-21 16:00:00	SPY	ETF	765.65	765.72	765.2	765.267	2521248.0
2026-08-21 17:00:00	SPY	ETF	765.23	766.5	765.23	766.3034	310031.0
2026-08-21 18:00:00	SPY	ETF	766.33	767.405	766.33	767.29	145763.0
2026-08-21 19:00:00	SPY	ETF	767.13	767.14	766.71	767.0	31278.0
2026-08-21 04:00:00	QQQ	ETF	714.24	715.13	711.68	714.9	198532.0
2026-08-21 05:00:00	QQQ	ETF	714.77	715.77	713.86	715.61	55618.0
2026-08-21 06:00:00	QQQ	ETF	715.58	716.29	715.28	715.49	77465.0
2026-08-21 07:00:00	QQQ	ETF	715.43	716.83	714.7921	715.98	395819.0
2026-08-21 08:00:00	QQQ	ETF	715.94	716.81	710.397	716.17	221082.0
2026-08-21 09:00:00	QQQ	ETF	716.18	716.2677	710.1	711.27	3733186.0
2026-08-21 10:00:00	QQQ	ETF	711.2195	711.97	709.2	711.9	3695527.0
2026-08-21 11:00:00	QQQ	ETF	711.9	715.6738	711.78	714.6	3990865.0
2026-08-21 12:00:00	QQQ	ETF	714.6	714.83	713.05	713.83	1545983.0
2026-08-21 13:00:00	QQQ	ETF	713.81	714.1	712.97	713.12	1281044.0
2026-08-21 14:00:00	QQQ	ETF	713.1299	713.64	712.43	713.565	1706357.0
2026-08-21 15:00:00	QQQ	ETF	713.5495	714.31	712.91	713.41	3636660.0
2026-08-21 16:00:00	QQQ	ETF	713.4	713.47	712.77	712.94	1431453.0
2026-08-21 17:00:00	QQQ	ETF	712.96	713.5334	712.93	713.35	80857.0
2026-08-21 18:00:00	QQQ	ETF	713.35	714.2	713.25	714.1	42349.0
2026-08-21 19:00:00	QQQ	ETF	714.1001	714.44	714.0	714.25	50075.0
2026-08-21 04:00:00	IWM	ETF	299.15	299.48	298.5	299.45	35913.0
2026-08-21 05:00:00	IWM	ETF	299.42	299.67	299.33	299.63	39177.0
2026-08-21 06:00:00	IWM	ETF	299.71	299.8	299.5	299.63	127516.0
2026-08-21 07:00:00	IWM	ETF	299.635	300.35	299.5332	300.1	173937.0
2026-08-21 08:00:00	IWM	ETF	300.11	300.25	299.76	300.13	91744.0
2026-08-21 09:00:00	IWM	ETF	300.16	300.26	299.015	299.42	2320240.0
2026-08-21 10:00:00	IWM	ETF	299.42	299.59	298.17	298.705	2077470.0
2026-08-21 11:00:00	IWM	ETF	298.71	299.805	298.66	299.55	1438484.0
2026-08-21 12:00:00	IWM	ETF	299.55	300.015	299.355	299.62	1359826.0
2026-08-21 13:00:00	IWM	ETF	299.625	299.9	299.46	299.695	810605.0
2026-08-21 14:00:00	IWM	ETF	299.695	300.06	299.5525	300.01	1081662.0
2026-08-21 15:00:00	IWM	ETF	300.02	300.33	299.87	299.94	2716967.0
2026-08-21 16:00:00	IWM	ETF	299.96	300.0938	299.83	299.85	887441.0
2026-08-21 17:00:00	IWM	ETF	299.91	300.21	299.88	300.2	5672.0
2026-08-21 18:00:00	IWM	ETF	300.3	300.78	300.13	300.45	17804.0
2026-08-21 19:00:00	IWM	ETF	300.52	300.75	300.25	300.38	7366.0
2026-08-21 04:00:00	DIA	ETF	527.53	529.18	527.36	529.02	7340.0
2026-08-21 05:00:00	DIA	ETF	529.12	529.2	528.78	528.78	1463.0

> showing 50 of 28,907 rows — these rows as CSV

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