PREVIEW / etf_1hour / 2025-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-05.parquet
  size:    631 KB
  rows:    24,863

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-05 04:00:00	SPY	ETF	596.5	597.7	596.5	596.87	44487.0
2025-06-05 05:00:00	SPY	ETF	596.83	596.87	596.33	596.45	21491.0
2025-06-05 06:00:00	SPY	ETF	596.59	597.07	596.08	596.42	20708.0
2025-06-05 07:00:00	SPY	ETF	596.4	596.59	595.92	596.41	48414.0
2025-06-05 08:00:00	SPY	ETF	595.8	599.73	595.3	597.33	1249530.0
2025-06-05 09:00:00	SPY	ETF	597.27	597.905	593.91	594.2896	6413123.0
2025-06-05 10:00:00	SPY	ETF	594.29	597.58	594.0	597.295	10499403.0
2025-06-05 11:00:00	SPY	ETF	597.29	599.0	597.06	598.7799	6227320.0
2025-06-05 12:00:00	SPY	ETF	598.76	598.95	594.26	594.76	7564350.0
2025-06-05 13:00:00	SPY	ETF	594.75	596.9797	594.305	595.82	5155329.0
2025-06-05 14:00:00	SPY	ETF	595.84	596.12	593.06	595.24	7111558.0
2025-06-05 15:00:00	SPY	ETF	595.24	595.51	591.05	593.01	19546727.0
2025-06-05 16:00:00	SPY	ETF	592.99	593.7	592.11	592.17	2806853.0
2025-06-05 17:00:00	SPY	ETF	592.19	592.4	591.5	591.5	208225.0
2025-06-05 18:00:00	SPY	ETF	591.42	592.96	591.33	592.8802	116825.0
2025-06-05 19:00:00	SPY	ETF	592.94	593.3199	592.53	592.83	64192.0
2025-06-05 04:00:00	QQQ	ETF	530.07	530.86	529.12	529.68	56835.0
2025-06-05 05:00:00	QQQ	ETF	529.67	529.67	529.05	529.29	32687.0
2025-06-05 06:00:00	QQQ	ETF	529.31	529.96	528.78	529.32	43371.0
2025-06-05 07:00:00	QQQ	ETF	529.36	529.409	528.6	529.1	82688.0
2025-06-05 08:00:00	QQQ	ETF	528.55	532.14	527.81	529.87	564280.0
2025-06-05 09:00:00	QQQ	ETF	529.86	530.85	527.27	528.028	3863996.0
2025-06-05 10:00:00	QQQ	ETF	528.04	531.75	527.55	531.29	7138028.0
2025-06-05 11:00:00	QQQ	ETF	531.29	533.05	530.96	532.79	4001158.0
2025-06-05 12:00:00	QQQ	ETF	532.78	532.85	526.78	527.175	5222916.0
2025-06-05 13:00:00	QQQ	ETF	527.15	529.62	526.51	528.16	3891898.0
2025-06-05 14:00:00	QQQ	ETF	528.19	528.42	525.12	527.12	5100991.0
2025-06-05 15:00:00	QQQ	ETF	527.12	527.39	522.66	524.7	9704236.0
2025-06-05 16:00:00	QQQ	ETF	524.71	525.44	522.88	522.9	1525563.0
2025-06-05 17:00:00	QQQ	ETF	522.95	523.53	522.1	522.1	243755.0
2025-06-05 18:00:00	QQQ	ETF	522.02	524.0	522.01	523.95	209029.0
2025-06-05 19:00:00	QQQ	ETF	523.9792	524.29	523.5598	523.67	132253.0
2025-06-05 04:00:00	IWM	ETF	209.02	209.22	208.74	208.79	12399.0
2025-06-05 05:00:00	IWM	ETF	208.93	209.04	208.65	208.65	8225.0
2025-06-05 06:00:00	IWM	ETF	208.69	208.96	208.55	208.64	15960.0
2025-06-05 07:00:00	IWM	ETF	208.58	208.62	208.25	208.36	17286.0
2025-06-05 08:00:00	IWM	ETF	208.35	210.07	207.79	208.99	722653.0
2025-06-05 09:00:00	IWM	ETF	208.99	209.27	207.0	207.39	3885436.0
2025-06-05 10:00:00	IWM	ETF	207.4	208.84	207.19	208.715	4855729.0
2025-06-05 11:00:00	IWM	ETF	208.71	209.6	208.61	209.51	2221744.0
2025-06-05 12:00:00	IWM	ETF	209.52	209.83	208.3	208.465	2972289.0
2025-06-05 13:00:00	IWM	ETF	208.47	209.7	208.31	209.47	2330087.0
2025-06-05 14:00:00	IWM	ETF	209.47	209.61	208.45	209.12	3026956.0
2025-06-05 15:00:00	IWM	ETF	209.11	209.2582	207.47	208.515	6976353.0
2025-06-05 16:00:00	IWM	ETF	208.53	208.81	208.44	208.61	555775.0
2025-06-05 17:00:00	IWM	ETF	208.58	208.64	208.05	208.07	21671.0
2025-06-05 18:00:00	IWM	ETF	208.26	208.71	208.26	208.71	55934.0
2025-06-05 19:00:00	IWM	ETF	208.68	208.87	208.53	208.73	14391.0
2025-06-05 04:00:00	DIA	ETF	425.98	426.16	425.67	425.76	3414.0
2025-06-05 05:00:00	DIA	ETF	425.91	425.91	425.72	425.72	300.0

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

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