PREVIEW / etf_1hour / 2026-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-21.parquet
  size:    710 KB
  rows:    28,411

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-21 04:00:00	SPY	ETF	745.07	746.41	744.7	746.02	66184.0
2026-07-21 05:00:00	SPY	ETF	746.1	746.45	745.82	745.87	20542.0
2026-07-21 06:00:00	SPY	ETF	746.0	746.68	745.72	746.05	140149.0
2026-07-21 07:00:00	SPY	ETF	745.89	746.05	745.0	745.181	120764.0
2026-07-21 08:00:00	SPY	ETF	745.25	745.85	744.27	745.23	251352.0
2026-07-21 09:00:00	SPY	ETF	745.28	746.69	744.18	745.37	3419535.0
2026-07-21 10:00:00	SPY	ETF	745.38	747.26	744.79	746.74	2991554.0
2026-07-21 11:00:00	SPY	ETF	746.77	748.01	745.83	747.52	2644350.0
2026-07-21 12:00:00	SPY	ETF	747.52	749.04	747.49	748.69	2052803.0
2026-07-21 13:00:00	SPY	ETF	748.6884	748.93	748.215	748.59	2226253.0
2026-07-21 14:00:00	SPY	ETF	748.59	748.77	747.94	748.37	2328195.0
2026-07-21 15:00:00	SPY	ETF	748.38	748.7	748.09	748.315	5466884.0
2026-07-21 16:00:00	SPY	ETF	748.295	748.41	747.82	748.04	3704626.0
2026-07-21 17:00:00	SPY	ETF	748.01	748.3	747.94	748.08	68187.0
2026-07-21 18:00:00	SPY	ETF	748.19	748.221	747.57	747.8	76620.0
2026-07-21 19:00:00	SPY	ETF	747.72	748.12	747.7	748.06	24312.0
2026-07-21 04:00:00	QQQ	ETF	704.07	705.46	701.63	705.2834	394512.0
2026-07-21 05:00:00	QQQ	ETF	705.23	705.93	704.88	705.01	89772.0
2026-07-21 06:00:00	QQQ	ETF	705.01	706.11	705.0	705.21	154673.0
2026-07-21 07:00:00	QQQ	ETF	705.25	705.67	704.13	704.84	217764.0
2026-07-21 08:00:00	QQQ	ETF	704.95	705.9	695.538	705.35	249845.0
2026-07-21 09:00:00	QQQ	ETF	705.4511	707.13	703.5	704.89	3218007.0
2026-07-21 10:00:00	QQQ	ETF	704.97	707.4	702.8	707.0	3343816.0
2026-07-21 11:00:00	QQQ	ETF	706.98	708.99	705.65	707.5203	2497074.0
2026-07-21 12:00:00	QQQ	ETF	707.52	709.79	707.43	709.3	2295363.0
2026-07-21 13:00:00	QQQ	ETF	709.3	710.05	709.09	709.53	1724945.0
2026-07-21 14:00:00	QQQ	ETF	709.54	710.03	708.8	709.2299	1835904.0
2026-07-21 15:00:00	QQQ	ETF	709.23	709.87	708.33	708.94	5307827.0
2026-07-21 16:00:00	QQQ	ETF	708.89	709.0	708.1	708.4	2342796.0
2026-07-21 17:00:00	QQQ	ETF	708.57	709.397	708.44	709.02	227287.0
2026-07-21 18:00:00	QQQ	ETF	709.05	709.05	707.51	707.96	121575.0
2026-07-21 19:00:00	QQQ	ETF	707.95	708.7	707.69	708.62	57066.0
2026-07-21 04:00:00	IWM	ETF	294.46	294.91	293.67	294.74	59624.0
2026-07-21 05:00:00	IWM	ETF	294.75	294.88	294.31	294.31	8251.0
2026-07-21 06:00:00	IWM	ETF	294.28	294.65	294.04	294.23	15684.0
2026-07-21 07:00:00	IWM	ETF	294.16	294.2123	293.5438	293.61	71536.0
2026-07-21 08:00:00	IWM	ETF	293.78	293.84	293.09	293.4	56952.0
2026-07-21 09:00:00	IWM	ETF	293.4	294.52	292.68	293.54	2313337.0
2026-07-21 10:00:00	IWM	ETF	293.56	295.18	293.415	294.605	1985455.0
2026-07-21 11:00:00	IWM	ETF	294.61	295.53	294.18	295.37	1132705.0
2026-07-21 12:00:00	IWM	ETF	295.35	296.2498	295.315	296.09	1033153.0
2026-07-21 13:00:00	IWM	ETF	296.095	296.31	295.57	296.08	1053439.0
2026-07-21 14:00:00	IWM	ETF	296.07	296.28	295.82	295.9	824368.0
2026-07-21 15:00:00	IWM	ETF	295.91	296.75	295.76	296.51	2710003.0
2026-07-21 16:00:00	IWM	ETF	296.51	296.58	296.23	296.45	1185574.0
2026-07-21 17:00:00	IWM	ETF	296.42	296.58	296.2	296.45	47523.0
2026-07-21 18:00:00	IWM	ETF	296.5	296.5	296.28	296.31	12374.0
2026-07-21 19:00:00	IWM	ETF	296.41	296.56	296.37	296.56	5072.0
2026-07-21 04:00:00	DIA	ETF	519.36	520.2	519.17	519.6	7125.0
2026-07-21 05:00:00	DIA	ETF	519.85	520.0	519.48	519.48	1346.0

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

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