PREVIEW / etf_1hour / 2026-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-26.parquet
  size:    739 KB
  rows:    29,485

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-05-26 04:00:00	SPY	ETF	748.8	750.99	748.8	749.89	73418.0
2026-05-26 05:00:00	SPY	ETF	749.99	750.5	749.7	750.4	35681.0
2026-05-26 06:00:00	SPY	ETF	750.37	751.69	750.32	750.87	92429.0
2026-05-26 07:00:00	SPY	ETF	750.84	751.04	749.82	750.6013	289017.0
2026-05-26 08:00:00	SPY	ETF	750.64	751.42	750.2	751.04	209746.0
2026-05-26 09:00:00	SPY	ETF	751.05	751.12	749.131	750.78	3545797.0
2026-05-26 10:00:00	SPY	ETF	750.79	752.13	750.54	751.4	3447492.0
2026-05-26 11:00:00	SPY	ETF	751.39	751.47	748.37	748.93	4590474.0
2026-05-26 12:00:00	SPY	ETF	748.93	750.03	748.6194	749.01	3093214.0
2026-05-26 13:00:00	SPY	ETF	749.01	749.435	748.5	749.03	2369707.0
2026-05-26 14:00:00	SPY	ETF	749.03	750.0	748.8	749.1	3061112.0
2026-05-26 15:00:00	SPY	ETF	749.09	750.87	748.85	750.49	7852347.0
2026-05-26 16:00:00	SPY	ETF	750.49	750.68	749.76	749.94	2284563.0
2026-05-26 17:00:00	SPY	ETF	749.97	750.141	749.89	750.04	43628.0
2026-05-26 18:00:00	SPY	ETF	750.03	750.36	749.6	749.9	80091.0
2026-05-26 19:00:00	SPY	ETF	749.9	751.03	749.9	750.85	100044.0
2026-05-26 04:00:00	QQQ	ETF	722.93	724.52	721.18	723.75	150662.0
2026-05-26 05:00:00	QQQ	ETF	723.75	724.75	723.628	724.6726	66732.0
2026-05-26 06:00:00	QQQ	ETF	724.68	726.27	724.62	724.86	142845.0
2026-05-26 07:00:00	QQQ	ETF	724.83	725.32	724.0	725.1	271214.0
2026-05-26 08:00:00	QQQ	ETF	725.14	726.6	718.078	726.42	316377.0
2026-05-26 09:00:00	QQQ	ETF	726.42	728.44	724.16	728.44	5437768.0
2026-05-26 10:00:00	QQQ	ETF	728.45	731.17	727.69	729.63	5094603.0
2026-05-26 11:00:00	QQQ	ETF	729.66	729.93	725.57	726.565	3921532.0
2026-05-26 12:00:00	QQQ	ETF	726.56	728.6899	726.39	727.71	2298644.0
2026-05-26 13:00:00	QQQ	ETF	727.72	728.63	727.23	728.26	1364102.0
2026-05-26 14:00:00	QQQ	ETF	728.235	729.77	727.9001	728.62	1949900.0
2026-05-26 15:00:00	QQQ	ETF	728.65	731.02	728.45	730.21	4349865.0
2026-05-26 16:00:00	QQQ	ETF	730.225	730.33	729.12	729.44	1446664.0
2026-05-26 17:00:00	QQQ	ETF	729.46	730.04	729.39	729.85	74071.0
2026-05-26 18:00:00	QQQ	ETF	729.77	730.18	729.14	729.31	115765.0
2026-05-26 19:00:00	QQQ	ETF	729.33	730.8	729.33	730.73	91218.0
2026-05-26 04:00:00	IWM	ETF	287.8	288.7	287.55	287.88	61276.0
2026-05-26 05:00:00	IWM	ETF	287.99	288.2	287.81	288.05	20984.0
2026-05-26 06:00:00	IWM	ETF	288.1	288.74	287.96	288.41	33992.0
2026-05-26 07:00:00	IWM	ETF	288.371	288.5	287.89	288.28	68190.0
2026-05-26 08:00:00	IWM	ETF	288.13	288.67	287.83	288.37	153136.0
2026-05-26 09:00:00	IWM	ETF	288.34	289.96	287.74	289.66	3992743.0
2026-05-26 10:00:00	IWM	ETF	289.68	290.515	289.37	290.08	3143481.0
2026-05-26 11:00:00	IWM	ETF	290.08	290.12	288.31	288.82	2160382.0
2026-05-26 12:00:00	IWM	ETF	288.83	290.1099	288.8207	289.43	1538492.0
2026-05-26 13:00:00	IWM	ETF	289.44	290.05	289.16	289.735	1790719.0
2026-05-26 14:00:00	IWM	ETF	289.73	290.25	289.52	289.5851	1450413.0
2026-05-26 15:00:00	IWM	ETF	289.6	290.55	289.475	290.51	3388822.0
2026-05-26 16:00:00	IWM	ETF	290.51	291.0	290.3	290.49	1130316.0
2026-05-26 17:00:00	IWM	ETF	290.59	290.59	290.35	290.38	14611.0
2026-05-26 18:00:00	IWM	ETF	290.53	290.53	290.02	290.46	52226.0
2026-05-26 19:00:00	IWM	ETF	290.5	291.21	290.47	290.98	45004.0
2026-05-26 04:00:00	DIA	ETF	509.14	509.64	508.61	508.61	10118.0
2026-05-26 05:00:00	DIA	ETF	508.67	508.98	508.42	508.67	4260.0

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

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