PREVIEW / etf_1hour / 2025-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-26.parquet
  size:    661 KB
  rows:    25,174

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-06-26 04:00:00	SPY	ETF	607.72	609.47	607.72	609.09	25647.0
2025-06-26 05:00:00	SPY	ETF	609.06	609.12	608.66	608.8	13280.0
2025-06-26 06:00:00	SPY	ETF	608.74	609.47	608.64	608.89	36221.0
2025-06-26 07:00:00	SPY	ETF	608.87	609.41	608.86	609.35	172886.0
2025-06-26 08:00:00	SPY	ETF	609.35	609.47	607.72	609.07	463215.0
2025-06-26 09:00:00	SPY	ETF	609.06	609.39	608.37	609.12	5292673.0
2025-06-26 10:00:00	SPY	ETF	609.13	610.58	609.07	610.3693	6619407.0
2025-06-26 11:00:00	SPY	ETF	610.37	610.865	609.83	610.53	4520176.0
2025-06-26 12:00:00	SPY	ETF	610.52	611.1283	610.46	610.845	3318754.0
2025-06-26 13:00:00	SPY	ETF	610.8329	611.59	610.64	611.271	3345806.0
2025-06-26 14:00:00	SPY	ETF	611.28	612.12	611.095	611.45	5904449.0
2025-06-26 15:00:00	SPY	ETF	611.44	612.31	611.23	611.89	13555701.0
2025-06-26 16:00:00	SPY	ETF	611.88	611.95	611.26	611.86	2814936.0
2025-06-26 17:00:00	SPY	ETF	611.83	612.26	611.7306	612.17	618020.0
2025-06-26 18:00:00	SPY	ETF	612.09	612.82	611.88	612.5	119076.0
2025-06-26 19:00:00	SPY	ETF	612.6	612.61	611.9	612.0982	57339.0
2025-06-26 04:00:00	QQQ	ETF	541.0	543.96	541.0	543.6	53581.0
2025-06-26 05:00:00	QQQ	ETF	543.63	543.7	543.18	543.34	39061.0
2025-06-26 06:00:00	QQQ	ETF	543.4	544.02	543.18	543.46	37258.0
2025-06-26 07:00:00	QQQ	ETF	543.45	543.89	543.41	543.88	295698.0
2025-06-26 08:00:00	QQQ	ETF	543.49	544.05	540.755	543.35	296376.0
2025-06-26 09:00:00	QQQ	ETF	543.39	543.7	541.52	543.13	4156165.0
2025-06-26 10:00:00	QQQ	ETF	543.14	544.39	543.0	543.762	3984822.0
2025-06-26 11:00:00	QQQ	ETF	543.76	544.88	543.3125	544.7096	3261656.0
2025-06-26 12:00:00	QQQ	ETF	544.71	545.23	544.41	544.65	1892996.0
2025-06-26 13:00:00	QQQ	ETF	544.64	545.69	544.4255	545.42	2113166.0
2025-06-26 14:00:00	QQQ	ETF	545.43	546.52	545.3	546.05	2778051.0
2025-06-26 15:00:00	QQQ	ETF	546.055	546.67	545.7307	546.21	5467632.0
2025-06-26 16:00:00	QQQ	ETF	546.21	546.29	544.65	546.18	1915848.0
2025-06-26 17:00:00	QQQ	ETF	546.22	546.8696	546.14	546.55	86360.0
2025-06-26 18:00:00	QQQ	ETF	546.55	547.08	546.15	546.8	107594.0
2025-06-26 19:00:00	QQQ	ETF	546.7509	546.85	546.22	546.38	58171.0
2025-06-26 04:00:00	IWM	ETF	212.36	212.77	212.25	212.51	79257.0
2025-06-26 05:00:00	IWM	ETF	212.49	212.51	212.22	212.22	10037.0
2025-06-26 06:00:00	IWM	ETF	212.18	212.67	212.15	212.39	25369.0
2025-06-26 07:00:00	IWM	ETF	212.41	212.94	212.4	212.82	67333.0
2025-06-26 08:00:00	IWM	ETF	212.8	212.9101	212.08	212.85	232362.0
2025-06-26 09:00:00	IWM	ETF	212.84	213.48	212.5001	212.78	3171563.0
2025-06-26 10:00:00	IWM	ETF	212.79	214.22	212.79	214.04	3199853.0
2025-06-26 11:00:00	IWM	ETF	214.05	214.335	213.515	213.705	2095657.0
2025-06-26 12:00:00	IWM	ETF	213.72	214.36	213.69	214.09	1239858.0
2025-06-26 13:00:00	IWM	ETF	214.09	214.22	213.83	213.96	2047794.0
2025-06-26 14:00:00	IWM	ETF	213.95	214.5399	213.62	214.515	2010496.0
2025-06-26 15:00:00	IWM	ETF	214.52	215.545	214.515	215.4	5710705.0
2025-06-26 16:00:00	IWM	ETF	215.41	215.7	215.17	215.49	874491.0
2025-06-26 17:00:00	IWM	ETF	215.52	215.88	215.4	215.64	21869.0
2025-06-26 18:00:00	IWM	ETF	215.65	215.85	215.45	215.68	28641.0
2025-06-26 19:00:00	IWM	ETF	215.68	215.68	215.18	215.34	27000.0
2025-06-26 04:00:00	DIA	ETF	431.03	431.03	430.88	430.88	1943.0
2025-06-26 05:00:00	DIA	ETF	430.8	430.81	430.72	430.74	800.0

> showing 50 of 25,174 rows — these rows as CSV

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