PREVIEW / etf_1hour / 2026-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-09-09.parquet
  size:    726 KB
  rows:    28,888

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-09 04:00:00	SPY	ETF	766.82	767.13	765.845	766.21	38466.0
2026-09-09 05:00:00	SPY	ETF	766.02	766.03	763.73	763.95	45906.0
2026-09-09 06:00:00	SPY	ETF	764.17	764.53	762.88	763.04	51515.0
2026-09-09 07:00:00	SPY	ETF	763.06	764.34	762.955	763.3	167131.0
2026-09-09 08:00:00	SPY	ETF	763.32	763.69	762.49	763.575	234966.0
2026-09-09 09:00:00	SPY	ETF	763.48	764.38	763.231	764.1	2509029.0
2026-09-09 10:00:00	SPY	ETF	764.09	764.2	762.49	763.78	3160765.0
2026-09-09 11:00:00	SPY	ETF	763.79	764.47	760.94	762.17	4193424.0
2026-09-09 12:00:00	SPY	ETF	762.17	762.86	761.32	762.566	1884717.0
2026-09-09 13:00:00	SPY	ETF	762.575	763.32	762.372	763.025	1782802.0
2026-09-09 14:00:00	SPY	ETF	763.02	763.39	762.28	762.9	2286530.0
2026-09-09 15:00:00	SPY	ETF	762.92	763.4098	762.1	762.34	6933848.0
2026-09-09 16:00:00	SPY	ETF	762.36	762.7629	762.2	762.76	2041167.0
2026-09-09 17:00:00	SPY	ETF	762.78	762.93	762.19	762.61	148437.0
2026-09-09 18:00:00	SPY	ETF	762.61	763.02	762.6	762.67	36191.0
2026-09-09 19:00:00	SPY	ETF	762.63	763.25	762.55	763.14	23868.0
2026-09-09 04:00:00	QQQ	ETF	719.46	720.67	718.47	719.01	114150.0
2026-09-09 05:00:00	QQQ	ETF	719.04	719.26	714.8	715.05	167215.0
2026-09-09 06:00:00	QQQ	ETF	715.045	715.84	714.35	714.83	209513.0
2026-09-09 07:00:00	QQQ	ETF	714.88	716.27	714.51	715.02	271558.0
2026-09-09 08:00:00	QQQ	ETF	715.01	715.11	713.495	714.85	408408.0
2026-09-09 09:00:00	QQQ	ETF	714.7	719.06	714.7	718.86	2918110.0
2026-09-09 10:00:00	QQQ	ETF	718.86	719.7	716.49	718.17	3490895.0
2026-09-09 11:00:00	QQQ	ETF	718.19	718.97	714.02	716.19	3894364.0
2026-09-09 12:00:00	QQQ	ETF	716.1911	716.88	714.71	716.42	2131599.0
2026-09-09 13:00:00	QQQ	ETF	716.4	717.05	715.7	716.7	1534670.0
2026-09-09 14:00:00	QQQ	ETF	716.69	716.8	715.93	716.15	1151272.0
2026-09-09 15:00:00	QQQ	ETF	716.16	716.745	715.53	716.28	2882490.0
2026-09-09 16:00:00	QQQ	ETF	716.32	716.42	715.8333	716.36	1511257.0
2026-09-09 17:00:00	QQQ	ETF	716.36	716.36	715.75	716.02	82514.0
2026-09-09 18:00:00	QQQ	ETF	716.0	716.711	715.5716	715.76	145306.0
2026-09-09 19:00:00	QQQ	ETF	715.7	716.61	715.45	716.51	68010.0
2026-09-09 04:00:00	IWM	ETF	294.36	294.82	294.29	294.43	56664.0
2026-09-09 05:00:00	IWM	ETF	294.37	294.52	293.18	293.29	16918.0
2026-09-09 06:00:00	IWM	ETF	293.45	293.71	292.87	292.89	260459.0
2026-09-09 07:00:00	IWM	ETF	292.86	293.72	292.84	293.19	199343.0
2026-09-09 08:00:00	IWM	ETF	293.13	293.15	292.62	293.05	108221.0
2026-09-09 09:00:00	IWM	ETF	293.0	294.155	292.62	292.79	2309910.0
2026-09-09 10:00:00	IWM	ETF	292.79	293.28	291.86	292.09	2213583.0
2026-09-09 11:00:00	IWM	ETF	292.085	292.51	290.925	290.97	2307384.0
2026-09-09 12:00:00	IWM	ETF	290.985	291.29	290.58	290.94	1170760.0
2026-09-09 13:00:00	IWM	ETF	290.94	291.14	290.75	291.035	1112552.0
2026-09-09 14:00:00	IWM	ETF	291.04	291.17	290.68	290.69	1463568.0
2026-09-09 15:00:00	IWM	ETF	290.69	290.86	290.31	290.67	2508278.0
2026-09-09 16:00:00	IWM	ETF	290.67	290.85	290.5	290.85	845750.0
2026-09-09 17:00:00	IWM	ETF	290.82	290.86	290.69	290.69	16978.0
2026-09-09 18:00:00	IWM	ETF	290.71	290.77	290.54	290.59	12698.0
2026-09-09 19:00:00	IWM	ETF	290.606	290.73	290.5671	290.7	17685.0
2026-09-09 04:00:00	DIA	ETF	528.0	528.0	527.235	527.24	1805.0
2026-09-09 05:00:00	DIA	ETF	527.11	527.3	525.79	525.81	3170.0

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

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