PREVIEW / etf_1hour / 2026-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-09-08.parquet
  size:    734 KB
  rows:    29,373

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-09-08 04:00:00	SPY	ETF	767.65	770.48	766.73	767.07	94100.0
2026-09-08 05:00:00	SPY	ETF	766.98	768.79	766.925	768.79	35223.0
2026-09-08 06:00:00	SPY	ETF	768.73	769.7	767.5536	767.8897	48586.0
2026-09-08 07:00:00	SPY	ETF	767.83	768.54	767.29	768.51	172457.0
2026-09-08 08:00:00	SPY	ETF	768.5	769.34	767.62	769.29	213075.0
2026-09-08 09:00:00	SPY	ETF	769.34	769.7	766.82	767.46	3778626.0
2026-09-08 10:00:00	SPY	ETF	767.45	767.949	765.99	767.65	3786263.0
2026-09-08 11:00:00	SPY	ETF	767.67	768.37	767.34	767.39	2864518.0
2026-09-08 12:00:00	SPY	ETF	767.4	767.79	766.55	766.94	2605184.0
2026-09-08 13:00:00	SPY	ETF	766.9292	768.12	766.9292	767.46	1787956.0
2026-09-08 14:00:00	SPY	ETF	767.48	767.89	765.67	766.77	3147340.0
2026-09-08 15:00:00	SPY	ETF	766.78	767.15	765.14	765.94	9075200.0
2026-09-08 16:00:00	SPY	ETF	765.96	766.17	765.33	765.8084	7756639.0
2026-09-08 17:00:00	SPY	ETF	765.76	765.93	765.7	765.87	35345.0
2026-09-08 18:00:00	SPY	ETF	765.88	766.18	765.61	766.18	43452.0
2026-09-08 19:00:00	SPY	ETF	766.15	766.15	765.25	765.41	17920.0
2026-09-08 04:00:00	QQQ	ETF	718.37	723.72	716.9	717.3942	348844.0
2026-09-08 05:00:00	QQQ	ETF	717.43	719.7	717.06	719.7	68421.0
2026-09-08 06:00:00	QQQ	ETF	719.72	720.96	718.6	719.16	82193.0
2026-09-08 07:00:00	QQQ	ETF	719.02	719.85	718.27	719.84	167359.0
2026-09-08 08:00:00	QQQ	ETF	719.78	721.1	718.6	721.07	201082.0
2026-09-08 09:00:00	QQQ	ETF	721.0	721.886	716.28	717.47	3147751.0
2026-09-08 10:00:00	QQQ	ETF	717.47	718.94	715.57	718.94	3020351.0
2026-09-08 11:00:00	QQQ	ETF	718.95	720.93	718.555	719.97	3113490.0
2026-09-08 12:00:00	QQQ	ETF	719.99	720.4	718.67	719.23	2186076.0
2026-09-08 13:00:00	QQQ	ETF	719.24	720.855	719.22	719.66	1589727.0
2026-09-08 14:00:00	QQQ	ETF	719.67	720.24	717.91	719.29	1810881.0
2026-09-08 15:00:00	QQQ	ETF	719.315	719.55	717.25	718.3806	3700780.0
2026-09-08 16:00:00	QQQ	ETF	718.4	718.59	717.5	717.9801	1714818.0
2026-09-08 17:00:00	QQQ	ETF	718.1	718.29	717.95	718.09	118243.0
2026-09-08 18:00:00	QQQ	ETF	718.01	718.52	717.46	718.49	103343.0
2026-09-08 19:00:00	QQQ	ETF	718.45	718.5	717.21	717.38	43167.0
2026-09-08 04:00:00	IWM	ETF	294.2	295.63	293.8	294.29	64642.0
2026-09-08 05:00:00	IWM	ETF	294.28	295.03	294.28	295.02	12684.0
2026-09-08 06:00:00	IWM	ETF	294.93	295.51	294.72	295.03	50644.0
2026-09-08 07:00:00	IWM	ETF	295.0062	295.29	294.79	295.22	128113.0
2026-09-08 08:00:00	IWM	ETF	295.23	295.91	294.9	295.87	128575.0
2026-09-08 09:00:00	IWM	ETF	295.88	295.88	294.26	295.03	2682130.0
2026-09-08 10:00:00	IWM	ETF	295.03	295.425	294.475	295.37	2323991.0
2026-09-08 11:00:00	IWM	ETF	295.37	295.68	295.1	295.61	1577310.0
2026-09-08 12:00:00	IWM	ETF	295.61	295.85	295.2	295.38	1080389.0
2026-09-08 13:00:00	IWM	ETF	295.37	296.1	295.36	295.755	1041862.0
2026-09-08 14:00:00	IWM	ETF	295.76	296.04	295.05	295.3674	1225268.0
2026-09-08 15:00:00	IWM	ETF	295.37	295.71	294.35	294.68	3827610.0
2026-09-08 16:00:00	IWM	ETF	294.67	294.8	294.36	294.5	849681.0
2026-09-08 17:00:00	IWM	ETF	294.67	294.67	294.45	294.65	27488.0
2026-09-08 18:00:00	IWM	ETF	294.66	294.84	294.55	294.84	20948.0
2026-09-08 19:00:00	IWM	ETF	294.825	294.85	294.44	294.49	28554.0
2026-09-08 04:00:00	DIA	ETF	529.99	531.04	529.1	529.19	9536.0
2026-09-08 05:00:00	DIA	ETF	529.71	529.98	529.65	529.98	487.0

> showing 50 of 29,373 rows — these rows as CSV

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