PREVIEW / etf_1hour / 2025-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-10.parquet
  size:    691 KB
  rows:    26,468

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-10 04:00:00	SPY	ETF	652.12	652.44	651.45	651.63	29461.0
2025-09-10 05:00:00	SPY	ETF	651.73	651.92	651.34	651.9	12358.0
2025-09-10 06:00:00	SPY	ETF	651.89	652.28	651.83	652.25	23927.0
2025-09-10 07:00:00	SPY	ETF	652.28	652.84	652.27	652.621	127578.0
2025-09-10 08:00:00	SPY	ETF	652.28	654.8	651.48	653.81	873807.0
2025-09-10 09:00:00	SPY	ETF	653.76	654.2	652.68	653.5971	8151617.0
2025-09-10 10:00:00	SPY	ETF	653.59	654.55	653.305	653.42	8204291.0
2025-09-10 11:00:00	SPY	ETF	653.42	653.63	652.3401	653.305	6752996.0
2025-09-10 12:00:00	SPY	ETF	653.31	653.41	652.16	652.94	3449564.0
2025-09-10 13:00:00	SPY	ETF	652.94	653.46	651.94	652.345	4229505.0
2025-09-10 14:00:00	SPY	ETF	652.34	652.41	651.39	651.995	5958795.0
2025-09-10 15:00:00	SPY	ETF	651.995	652.7	650.63	652.225	12851976.0
2025-09-10 16:00:00	SPY	ETF	652.22	652.44	651.96	652.04	2135182.0
2025-09-10 17:00:00	SPY	ETF	652.05	652.07	651.9	651.97	129813.0
2025-09-10 18:00:00	SPY	ETF	651.99	653.03	651.96	652.77	68467.0
2025-09-10 19:00:00	SPY	ETF	652.75	653.05	652.27	652.88	162713.0
2025-09-10 20:00:00	SPY	ETF	652.88	652.88	652.88	652.88	200.0
2025-09-10 04:00:00	QQQ	ETF	582.25	582.28	581.07	581.2	56750.0
2025-09-10 05:00:00	QQQ	ETF	581.34	581.53	580.93	581.51	55144.0
2025-09-10 06:00:00	QQQ	ETF	581.41	581.95	581.41	581.89	61771.0
2025-09-10 07:00:00	QQQ	ETF	581.93	582.7	581.866	582.5	98586.0
2025-09-10 08:00:00	QQQ	ETF	581.97	584.77	581.03	583.88	819736.0
2025-09-10 09:00:00	QQQ	ETF	583.87	584.1	581.33	582.035	7118543.0
2025-09-10 10:00:00	QQQ	ETF	582.03	583.45	581.9	582.91	6105932.0
2025-09-10 11:00:00	QQQ	ETF	582.92	583.195	581.8499	582.5	4875297.0
2025-09-10 12:00:00	QQQ	ETF	582.5	582.51	581.25	581.9	2944600.0
2025-09-10 13:00:00	QQQ	ETF	581.89	582.29	580.73	581.27	3130103.0
2025-09-10 14:00:00	QQQ	ETF	581.27	581.31	579.762	580.415	4022507.0
2025-09-10 15:00:00	QQQ	ETF	580.41	581.14	578.55	580.7	7472146.0
2025-09-10 16:00:00	QQQ	ETF	580.7	580.95	580.26	580.35	964493.0
2025-09-10 17:00:00	QQQ	ETF	580.3	580.39	580.2	580.3	21320.0
2025-09-10 18:00:00	QQQ	ETF	580.23	581.4404	580.23	581.2899	138897.0
2025-09-10 19:00:00	QQQ	ETF	581.2101	581.59	581.11	581.27	43565.0
2025-09-10 04:00:00	IWM	ETF	236.49	236.59	236.01	236.11	21692.0
2025-09-10 05:00:00	IWM	ETF	236.15	236.27	235.93	236.23	24384.0
2025-09-10 06:00:00	IWM	ETF	236.25	236.27	236.06	236.23	13951.0
2025-09-10 07:00:00	IWM	ETF	236.24	236.37	236.0	236.36	72018.0
2025-09-10 08:00:00	IWM	ETF	236.16	238.51	235.93	237.72	809122.0
2025-09-10 09:00:00	IWM	ETF	237.71	238.25	236.9	238.07	4499605.0
2025-09-10 10:00:00	IWM	ETF	238.07	238.27	236.88	237.03	4345898.0
2025-09-10 11:00:00	IWM	ETF	237.02	237.15	236.495	237.06	3107086.0
2025-09-10 12:00:00	IWM	ETF	237.055	237.13	236.25	236.81	2678017.0
2025-09-10 13:00:00	IWM	ETF	236.8	237.205	236.1001	236.33	2484943.0
2025-09-10 14:00:00	IWM	ETF	236.325	236.695	236.04	236.65	2789196.0
2025-09-10 15:00:00	IWM	ETF	236.65	236.72	235.46	236.41	5807671.0
2025-09-10 16:00:00	IWM	ETF	236.43	236.56	236.14	236.25	1305732.0
2025-09-10 17:00:00	IWM	ETF	236.28	236.38	236.06	236.22	31759.0
2025-09-10 18:00:00	IWM	ETF	236.18	236.62	236.14	236.6	18524.0
2025-09-10 19:00:00	IWM	ETF	236.47	236.68	236.42	236.44	37380.0
2025-09-10 04:00:00	DIA	ETF	457.86	457.96	457.05	457.16	4993.0

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

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