PREVIEW / etf_1hour / 2025-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-06.parquet
  size:    632 KB
  rows:    24,075

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-06 04:00:00	SPY	ETF	594.72	595.58	594.72	595.41	41263.0
2025-06-06 05:00:00	SPY	ETF	595.44	595.79	595.17	595.73	58920.0
2025-06-06 06:00:00	SPY	ETF	595.68	595.79	595.06	595.09	123678.0
2025-06-06 07:00:00	SPY	ETF	595.11	595.56	594.65	595.27	127693.0
2025-06-06 08:00:00	SPY	ETF	595.06	598.1	592.606	597.74	1024622.0
2025-06-06 09:00:00	SPY	ETF	597.74	600.83	597.45	600.3	8176509.0
2025-06-06 10:00:00	SPY	ETF	600.31	600.48	598.65	599.3	5904351.0
2025-06-06 11:00:00	SPY	ETF	599.29	600.37	597.25	598.6901	7024628.0
2025-06-06 12:00:00	SPY	ETF	598.7	599.39	596.86	597.62	4285195.0
2025-06-06 13:00:00	SPY	ETF	597.61	599.05	597.125	598.95	3544392.0
2025-06-06 14:00:00	SPY	ETF	598.95	600.64	598.95	599.72	5740730.0
2025-06-06 15:00:00	SPY	ETF	599.73	600.06	598.91	599.05	10318756.0
2025-06-06 16:00:00	SPY	ETF	599.03	599.6	598.84	599.34	2948220.0
2025-06-06 17:00:00	SPY	ETF	599.53	599.56	598.99	598.99	57507.0
2025-06-06 18:00:00	SPY	ETF	598.99	599.32	598.85	599.3001	38151.0
2025-06-06 19:00:00	SPY	ETF	599.33	599.7674	599.33	599.73	24815.0
2025-06-06 04:00:00	QQQ	ETF	526.55	526.93	525.84	526.7	51658.0
2025-06-06 05:00:00	QQQ	ETF	526.7	527.4	526.54	527.31	26525.0
2025-06-06 06:00:00	QQQ	ETF	527.3	527.5	526.56	526.58	29267.0
2025-06-06 07:00:00	QQQ	ETF	526.57	527.21	526.27	526.92	174551.0
2025-06-06 08:00:00	QQQ	ETF	526.59	529.7	525.183	529.13	920472.0
2025-06-06 09:00:00	QQQ	ETF	529.14	531.62	528.8	531.0208	5658750.0
2025-06-06 10:00:00	QQQ	ETF	531.07	531.33	529.222	530.57	4399796.0
2025-06-06 11:00:00	QQQ	ETF	530.56	531.71	528.57	530.25	4438639.0
2025-06-06 12:00:00	QQQ	ETF	530.27	530.92	528.21	529.0208	2609029.0
2025-06-06 13:00:00	QQQ	ETF	529.01	530.73	528.58	530.6198	2554965.0
2025-06-06 14:00:00	QQQ	ETF	530.61	531.8	530.61	530.94	3293665.0
2025-06-06 15:00:00	QQQ	ETF	530.93	531.23	529.74	529.84	5108908.0
2025-06-06 16:00:00	QQQ	ETF	529.845	530.5401	529.63	530.34	1853872.0
2025-06-06 17:00:00	QQQ	ETF	530.3	530.5	530.0	530.0	22080.0
2025-06-06 18:00:00	QQQ	ETF	530.0	530.28	529.94	530.28	20531.0
2025-06-06 19:00:00	QQQ	ETF	530.29	530.79	530.25	530.79	31594.0
2025-06-06 04:00:00	IWM	ETF	209.75	209.97	209.72	209.86	17665.0
2025-06-06 05:00:00	IWM	ETF	209.85	209.88	209.67	209.7	8410.0
2025-06-06 06:00:00	IWM	ETF	209.71	209.77	209.36	209.4	17963.0
2025-06-06 07:00:00	IWM	ETF	209.39	209.68	209.19	209.68	48342.0
2025-06-06 08:00:00	IWM	ETF	209.28	211.5	209.2	211.24	789204.0
2025-06-06 09:00:00	IWM	ETF	211.26	212.1284	210.73	211.07	5541756.0
2025-06-06 10:00:00	IWM	ETF	211.06	211.845	210.6	211.66	3746979.0
2025-06-06 11:00:00	IWM	ETF	211.65	212.1	210.69	211.53	3353201.0
2025-06-06 12:00:00	IWM	ETF	211.53	211.78	210.85	211.075	2239821.0
2025-06-06 13:00:00	IWM	ETF	211.07	211.28	210.855	211.18	1408163.0
2025-06-06 14:00:00	IWM	ETF	211.185	211.54	211.125	211.345	2433979.0
2025-06-06 15:00:00	IWM	ETF	211.34	212.09	211.32	211.89	5790652.0
2025-06-06 16:00:00	IWM	ETF	211.9	212.07	211.74	212.03	936415.0
2025-06-06 17:00:00	IWM	ETF	212.04	212.17	212.01	212.1	6454.0
2025-06-06 18:00:00	IWM	ETF	212.1	212.14	211.73	211.85	7772.0
2025-06-06 19:00:00	IWM	ETF	211.86	212.2091	211.71	212.0891	8627.0
2025-06-06 04:00:00	DIA	ETF	425.8	425.8	425.46	425.6	952.0
2025-06-06 05:00:00	DIA	ETF	425.62	425.64	425.48	425.48	500.0

> showing 50 of 24,075 rows — these rows as CSV

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