PREVIEW / etf_1hour / 2026-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-29.parquet
  size:    724 KB
  rows:    28,706

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-29 04:00:00	SPY	ETF	755.49	756.09	754.85	755.4	79578.0
2026-05-29 05:00:00	SPY	ETF	755.41	756.23	755.4	755.89	14810.0
2026-05-29 06:00:00	SPY	ETF	755.86	755.93	755.32	755.71	18491.0
2026-05-29 07:00:00	SPY	ETF	755.82	756.39	755.25	756.15	114951.0
2026-05-29 08:00:00	SPY	ETF	756.1	756.3	755.38	755.94	168154.0
2026-05-29 09:00:00	SPY	ETF	755.98	757.91	755.5	757.82	4301219.0
2026-05-29 10:00:00	SPY	ETF	757.82	758.08	754.69	756.04	7084292.0
2026-05-29 11:00:00	SPY	ETF	756.03	757.42	755.89	756.42	3303602.0
2026-05-29 12:00:00	SPY	ETF	756.42	757.82	756.34	756.81	2635204.0
2026-05-29 13:00:00	SPY	ETF	756.81	757.025	755.23	755.3	2337921.0
2026-05-29 14:00:00	SPY	ETF	755.31	756.77	755.13	755.49	3473739.0
2026-05-29 15:00:00	SPY	ETF	755.48	757.63	755.36	756.4	11023867.0
2026-05-29 16:00:00	SPY	ETF	756.42	756.86	755.88	756.0298	4824981.0
2026-05-29 17:00:00	SPY	ETF	755.96	756.48	755.2	755.47	542325.0
2026-05-29 18:00:00	SPY	ETF	755.49	755.81	755.4325	755.6234	43843.0
2026-05-29 19:00:00	SPY	ETF	755.64	755.8	755.3	755.64	53640.0
2026-05-29 04:00:00	QQQ	ETF	736.45	737.02	734.87	736.27	145329.0
2026-05-29 05:00:00	QQQ	ETF	736.27	737.5	736.15	736.64	69969.0
2026-05-29 06:00:00	QQQ	ETF	736.61	737.01	735.92	736.76	57370.0
2026-05-29 07:00:00	QQQ	ETF	736.77	737.57	735.85	737.0	205762.0
2026-05-29 08:00:00	QQQ	ETF	737.0	737.05	735.8	737.0	273823.0
2026-05-29 09:00:00	QQQ	ETF	737.01	741.2199	736.69	741.17	3927810.0
2026-05-29 10:00:00	QQQ	ETF	741.17	741.63	735.25	737.45	7372625.0
2026-05-29 11:00:00	QQQ	ETF	737.45	739.35	736.915	737.46	2555673.0
2026-05-29 12:00:00	QQQ	ETF	737.49	739.54	737.42	738.35	1996150.0
2026-05-29 13:00:00	QQQ	ETF	738.35	738.655	735.88	736.02	1689294.0
2026-05-29 14:00:00	QQQ	ETF	736.03	738.41	735.78	736.535	2218254.0
2026-05-29 15:00:00	QQQ	ETF	736.52	739.42	736.31	738.25	4950262.0
2026-05-29 16:00:00	QQQ	ETF	738.26	738.59	737.6195	738.09	2402167.0
2026-05-29 17:00:00	QQQ	ETF	738.06	738.31	737.5218	737.79	193614.0
2026-05-29 18:00:00	QQQ	ETF	737.75	738.26	737.7	737.97	26268.0
2026-05-29 19:00:00	QQQ	ETF	738.02	738.26	737.65	737.65	38988.0
2026-05-29 04:00:00	IWM	ETF	291.8	292.11	291.44	291.56	42472.0
2026-05-29 05:00:00	IWM	ETF	291.61	292.2	291.59	291.96	12767.0
2026-05-29 06:00:00	IWM	ETF	291.94	292.03	291.7	291.93	14979.0
2026-05-29 07:00:00	IWM	ETF	291.91	292.25	291.55	292.25	48541.0
2026-05-29 08:00:00	IWM	ETF	292.19	292.24	291.45	291.73	89082.0
2026-05-29 09:00:00	IWM	ETF	291.75	291.75	290.27	290.55	2531084.0
2026-05-29 10:00:00	IWM	ETF	290.57	290.87	288.33	289.16	5625151.0
2026-05-29 11:00:00	IWM	ETF	289.17	290.28	288.99	290.27	2418434.0
2026-05-29 12:00:00	IWM	ETF	290.26	290.67	289.92	290.255	1850709.0
2026-05-29 13:00:00	IWM	ETF	290.25	290.7	289.755	289.8	1546746.0
2026-05-29 14:00:00	IWM	ETF	289.8	290.3	289.28	289.31	1852395.0
2026-05-29 15:00:00	IWM	ETF	289.3	290.56	289.085	290.41	3508606.0
2026-05-29 16:00:00	IWM	ETF	290.43	290.66	289.88	290.0192	2018992.0
2026-05-29 17:00:00	IWM	ETF	290.05	290.43	289.9	290.06	153207.0
2026-05-29 18:00:00	IWM	ETF	289.91	290.161	289.0	290.05	7441.0
2026-05-29 19:00:00	IWM	ETF	290.05	290.09	289.75	290.04	3702.0
2026-05-29 04:00:00	DIA	ETF	507.62	507.82	507.54	507.61	2033.0
2026-05-29 05:00:00	DIA	ETF	508.06	508.4	508.03	508.4	244.0

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

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