PREVIEW / etf_1hour / 2025-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-30.parquet
  size:    670 KB
  rows:    26,237

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-30 04:00:00	SPY	ETF	617.33	617.57	617.03	617.24	29159.0
2025-06-30 05:00:00	SPY	ETF	617.23	617.85	617.08	617.28	62361.0
2025-06-30 06:00:00	SPY	ETF	617.31	617.74	617.24	617.58	60221.0
2025-06-30 07:00:00	SPY	ETF	617.58	617.87	617.42	617.52	153359.0
2025-06-30 08:00:00	SPY	ETF	617.74	617.9	616.79	617.09	425267.0
2025-06-30 09:00:00	SPY	ETF	617.07	617.62	615.96	616.433	5877208.0
2025-06-30 10:00:00	SPY	ETF	616.44	616.82	615.688	616.01	6274525.0
2025-06-30 11:00:00	SPY	ETF	616.01	616.925	615.71	616.465	5235405.0
2025-06-30 12:00:00	SPY	ETF	616.47	617.13	616.11	616.64	3604278.0
2025-06-30 13:00:00	SPY	ETF	616.64	616.82	615.04	615.84	4935850.0
2025-06-30 14:00:00	SPY	ETF	615.847	616.94	615.32	616.93	7376046.0
2025-06-30 15:00:00	SPY	ETF	616.935	619.22	616.91	617.88	23449306.0
2025-06-30 16:00:00	SPY	ETF	617.91	618.17	617.12	617.3	5636620.0
2025-06-30 17:00:00	SPY	ETF	617.32	617.43	617.2157	617.4	65012.0
2025-06-30 18:00:00	SPY	ETF	617.27	617.68	617.05	617.05	84368.0
2025-06-30 19:00:00	SPY	ETF	617.14	617.779	616.94	617.71	37904.0
2025-06-30 04:00:00	QQQ	ETF	550.62	551.74	550.62	551.33	49962.0
2025-06-30 05:00:00	QQQ	ETF	551.3	552.26	551.22	551.46	57812.0
2025-06-30 06:00:00	QQQ	ETF	551.46	552.09	551.43	551.74	44915.0
2025-06-30 07:00:00	QQQ	ETF	551.65	552.03	551.46	551.76	82062.0
2025-06-30 08:00:00	QQQ	ETF	551.5	552.0	548.37	551.15	264121.0
2025-06-30 09:00:00	QQQ	ETF	551.16	551.68	549.01	550.13	4066290.0
2025-06-30 10:00:00	QQQ	ETF	550.13	550.76	549.7	549.99	3894138.0
2025-06-30 11:00:00	QQQ	ETF	550.0	550.89	549.53	550.5299	2777950.0
2025-06-30 12:00:00	QQQ	ETF	550.53	551.098	550.27	550.48	2360971.0
2025-06-30 13:00:00	QQQ	ETF	550.51	550.7	549.18	549.9726	2350060.0
2025-06-30 14:00:00	QQQ	ETF	549.97	550.7699	549.04	550.67	3911616.0
2025-06-30 15:00:00	QQQ	ETF	550.68	552.8	550.65	551.64	7965906.0
2025-06-30 16:00:00	QQQ	ETF	551.64	551.92	550.83	551.19	1739913.0
2025-06-30 17:00:00	QQQ	ETF	551.29	551.52	551.23	551.51	80498.0
2025-06-30 18:00:00	QQQ	ETF	551.45	551.64	550.95	550.95	86849.0
2025-06-30 19:00:00	QQQ	ETF	551.02	551.6689	550.75	551.56	60700.0
2025-06-30 04:00:00	IWM	ETF	216.0	216.74	216.0	216.6	18037.0
2025-06-30 05:00:00	IWM	ETF	216.6	216.78	216.42	216.46	13976.0
2025-06-30 06:00:00	IWM	ETF	216.44	216.72	216.35	216.61	32781.0
2025-06-30 07:00:00	IWM	ETF	216.63	216.87	216.54	216.57	65169.0
2025-06-30 08:00:00	IWM	ETF	216.7	217.05	216.56	216.65	156008.0
2025-06-30 09:00:00	IWM	ETF	216.62	216.9	215.93	216.315	3149768.0
2025-06-30 10:00:00	IWM	ETF	216.315	216.405	215.66	216.02	2483709.0
2025-06-30 11:00:00	IWM	ETF	216.02	216.18	215.7282	215.89	1710436.0
2025-06-30 12:00:00	IWM	ETF	215.9	216.125	215.5425	215.93	1287186.0
2025-06-30 13:00:00	IWM	ETF	215.94	216.145	215.39	215.675	1660251.0
2025-06-30 14:00:00	IWM	ETF	215.675	216.26	215.64	216.245	1886420.0
2025-06-30 15:00:00	IWM	ETF	216.25	216.47	215.77	215.81	5777676.0
2025-06-30 16:00:00	IWM	ETF	215.79	215.9	215.42	215.6	1592554.0
2025-06-30 17:00:00	IWM	ETF	215.55	216.06	215.27	215.49	71766.0
2025-06-30 18:00:00	IWM	ETF	215.49	215.79	215.41	215.41	111421.0
2025-06-30 19:00:00	IWM	ETF	215.401	215.81	215.4	215.66	62807.0
2025-06-30 04:00:00	DIA	ETF	440.5	440.5	440.2	440.25	5180.0
2025-06-30 05:00:00	DIA	ETF	440.1	440.1	440.08	440.09	400.0

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

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