PREVIEW / etf_1hour / 2025-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-09.parquet
  size:    678 KB
  rows:    26,094

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
2025-09-09 04:00:00	SPY	ETF	649.75	649.86	649.37	649.46	11306.0
2025-09-09 05:00:00	SPY	ETF	649.62	650.1	649.37	649.47	55486.0
2025-09-09 06:00:00	SPY	ETF	649.56	649.62	649.26	649.43	11031.0
2025-09-09 07:00:00	SPY	ETF	649.45	649.66	648.97	649.61	96212.0
2025-09-09 08:00:00	SPY	ETF	649.33	650.53	649.12	649.42	81836.0
2025-09-09 09:00:00	SPY	ETF	649.39	649.495	648.45	649.02	4681887.0
2025-09-09 10:00:00	SPY	ETF	649.02	649.73	647.22	648.325	9218297.0
2025-09-09 11:00:00	SPY	ETF	648.325	648.835	647.79	648.265	4691739.0
2025-09-09 12:00:00	SPY	ETF	648.26	649.21	648.17	649.04	3930642.0
2025-09-09 13:00:00	SPY	ETF	649.05	649.98	649.02	649.795	4273041.0
2025-09-09 14:00:00	SPY	ETF	649.8	650.1	649.57	649.86	3903598.0
2025-09-09 15:00:00	SPY	ETF	649.86	650.86	649.55	650.33	9195066.0
2025-09-09 16:00:00	SPY	ETF	650.34	651.8192	649.91	651.32	9215480.0
2025-09-09 17:00:00	SPY	ETF	651.56	651.84	651.34	651.7	181647.0
2025-09-09 18:00:00	SPY	ETF	651.64	651.9	651.37	651.6694	115202.0
2025-09-09 19:00:00	SPY	ETF	651.57	651.58	650.8	651.09	139494.0
2025-09-09 04:00:00	QQQ	ETF	580.13	580.22	579.65	579.88	40019.0
2025-09-09 05:00:00	QQQ	ETF	579.85	580.17	579.7	579.88	26199.0
2025-09-09 06:00:00	QQQ	ETF	579.89	580.24	579.76	579.89	24533.0
2025-09-09 07:00:00	QQQ	ETF	579.91	580.05	579.13	580.05	44744.0
2025-09-09 08:00:00	QQQ	ETF	579.8	580.82	579.1682	579.78	141013.0
2025-09-09 09:00:00	QQQ	ETF	579.79	580.2	578.83	579.2	4657041.0
2025-09-09 10:00:00	QQQ	ETF	579.2	580.03	577.04	578.49	7765533.0
2025-09-09 11:00:00	QQQ	ETF	578.48	579.11	577.66	578.43	3986711.0
2025-09-09 12:00:00	QQQ	ETF	578.44	579.63	578.38	579.32	2877397.0
2025-09-09 13:00:00	QQQ	ETF	579.33	580.155	579.33	579.75	3231558.0
2025-09-09 14:00:00	QQQ	ETF	579.76	579.98	579.38	579.87	3079597.0
2025-09-09 15:00:00	QQQ	ETF	579.87	580.94	579.68	580.47	5528724.0
2025-09-09 16:00:00	QQQ	ETF	580.48	581.68	580.01	581.0583	1941572.0
2025-09-09 17:00:00	QQQ	ETF	581.09	581.75	581.01	581.65	115701.0
2025-09-09 18:00:00	QQQ	ETF	581.65	581.65	581.08	581.18	115820.0
2025-09-09 19:00:00	QQQ	ETF	581.17	581.17	580.68	580.9	134889.0
2025-09-09 04:00:00	IWM	ETF	238.5	238.51	238.12	238.13	20281.0
2025-09-09 05:00:00	IWM	ETF	238.16	238.33	238.08	238.23	56214.0
2025-09-09 06:00:00	IWM	ETF	238.2	238.31	238.13	238.18	8398.0
2025-09-09 07:00:00	IWM	ETF	238.2	238.33	238.01	238.13	18989.0
2025-09-09 08:00:00	IWM	ETF	238.13	238.86	238.07	238.07	45630.0
2025-09-09 09:00:00	IWM	ETF	238.06	238.1	236.93	237.39	3855604.0
2025-09-09 10:00:00	IWM	ETF	237.4	237.96	235.42	236.15	6948679.0
2025-09-09 11:00:00	IWM	ETF	236.145	236.835	236.02	236.16	3457512.0
2025-09-09 12:00:00	IWM	ETF	236.16	236.625	236.04	236.135	2267731.0
2025-09-09 13:00:00	IWM	ETF	236.135	236.81	235.96	236.69	2087774.0
2025-09-09 14:00:00	IWM	ETF	236.69	237.05	236.68	237.005	3047498.0
2025-09-09 15:00:00	IWM	ETF	237.005	237.14	236.29	236.83	6706049.0
2025-09-09 16:00:00	IWM	ETF	236.85	236.87	236.22	236.28	1164047.0
2025-09-09 17:00:00	IWM	ETF	236.26	236.4275	236.0	236.2	56058.0
2025-09-09 18:00:00	IWM	ETF	236.25	236.35	236.13	236.18	37429.0
2025-09-09 19:00:00	IWM	ETF	236.15	236.21	235.75	235.92	24530.0
2025-09-09 04:00:00	DIA	ETF	456.36	456.52	456.17	456.17	1100.0
2025-09-09 05:00:00	DIA	ETF	456.27	456.27	456.17	456.17	500.0

> showing 50 of 26,094 rows — these rows as CSV

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