PREVIEW / etf_1hour / 2025-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-25.parquet
  size:    629 KB
  rows:    24,208

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-04-25 04:00:00	SPY	ETF	549.35	550.0	548.4	548.77	37724.0
2025-04-25 05:00:00	SPY	ETF	548.85	549.08	547.68	548.75	46041.0
2025-04-25 06:00:00	SPY	ETF	548.64	549.3	544.34	544.76	265209.0
2025-04-25 07:00:00	SPY	ETF	544.62	546.75	544.4	545.5	319482.0
2025-04-25 08:00:00	SPY	ETF	545.5	550.64	544.7	545.28	663751.0
2025-04-25 09:00:00	SPY	ETF	545.29	548.1142	544.66	544.88	4519530.0
2025-04-25 10:00:00	SPY	ETF	544.94	547.93	543.69	546.46	7048590.0
2025-04-25 11:00:00	SPY	ETF	546.47	547.5	545.7	547.07	2769246.0
2025-04-25 12:00:00	SPY	ETF	547.09	549.2	546.96	549.1	2951011.0
2025-04-25 13:00:00	SPY	ETF	549.12	551.05	546.76	547.91	6530256.0
2025-04-25 14:00:00	SPY	ETF	547.9	550.75	547.535	549.84	4683175.0
2025-04-25 15:00:00	SPY	ETF	549.8	550.91	548.76	550.52	7434280.0
2025-04-25 16:00:00	SPY	ETF	550.55	551.77	550.15	550.82	4050008.0
2025-04-25 17:00:00	SPY	ETF	550.85	551.05	550.64	550.6953	689739.0
2025-04-25 18:00:00	SPY	ETF	550.6896	551.1478	550.5792	551.1	82263.0
2025-04-25 19:00:00	SPY	ETF	551.15	551.25	550.877	551.23	30787.0
2025-04-25 04:00:00	QQQ	ETF	469.75	470.55	469.0	469.37	69497.0
2025-04-25 05:00:00	QQQ	ETF	469.31	469.42	468.05	469.31	72216.0
2025-04-25 06:00:00	QQQ	ETF	469.09	469.7	464.98	465.27	212630.0
2025-04-25 07:00:00	QQQ	ETF	465.23	467.43	465.23	465.9	221186.0
2025-04-25 08:00:00	QQQ	ETF	465.6	471.54	465.0304	465.65	579301.0
2025-04-25 09:00:00	QQQ	ETF	465.56	468.47	464.97	465.96	3602237.0
2025-04-25 10:00:00	QQQ	ETF	466.1	469.49	465.39	467.8572	4610226.0
2025-04-25 11:00:00	QQQ	ETF	467.85	469.2	467.21	468.46	2255451.0
2025-04-25 12:00:00	QQQ	ETF	468.46	471.02	468.16	471.0	2443260.0
2025-04-25 13:00:00	QQQ	ETF	470.98	473.09	468.7352	470.0101	4910283.0
2025-04-25 14:00:00	QQQ	ETF	470.015	472.4452	469.69	471.755	3257370.0
2025-04-25 15:00:00	QQQ	ETF	471.76	472.89	470.49	472.53	4509148.0
2025-04-25 16:00:00	QQQ	ETF	472.52	473.89	472.44	473.0	1205682.0
2025-04-25 17:00:00	QQQ	ETF	472.99	473.25	472.85	472.98	46286.0
2025-04-25 18:00:00	QQQ	ETF	472.98	472.98	472.5	472.7	11744.0
2025-04-25 19:00:00	QQQ	ETF	472.6299	473.12	472.4479	472.994	26742.0
2025-04-25 04:00:00	IWM	ETF	193.98	194.2	193.56	193.6	38484.0
2025-04-25 05:00:00	IWM	ETF	193.68	193.74	193.15	193.56	16940.0
2025-04-25 06:00:00	IWM	ETF	193.45	193.81	192.21	192.27	38353.0
2025-04-25 07:00:00	IWM	ETF	192.26	192.79	192.19	192.54	72851.0
2025-04-25 08:00:00	IWM	ETF	192.29	194.49	192.26	192.29	113825.0
2025-04-25 09:00:00	IWM	ETF	192.34	193.16	192.1	192.16	2707496.0
2025-04-25 10:00:00	IWM	ETF	192.2	193.16	191.55	192.7899	2888622.0
2025-04-25 11:00:00	IWM	ETF	192.79	193.179	192.535	192.72	1124722.0
2025-04-25 12:00:00	IWM	ETF	192.71	193.47	192.7	193.24	1341106.0
2025-04-25 13:00:00	IWM	ETF	193.23	194.26	192.2575	192.73	3590015.0
2025-04-25 14:00:00	IWM	ETF	192.71	193.89	192.61	193.58	2038447.0
2025-04-25 15:00:00	IWM	ETF	193.57	194.24	193.33	194.11	2942920.0
2025-04-25 16:00:00	IWM	ETF	194.12	194.44	193.83	194.02	921074.0
2025-04-25 17:00:00	IWM	ETF	194.0101	194.44	194.0101	194.34	12602.0
2025-04-25 18:00:00	IWM	ETF	194.12	194.326	194.12	194.27	2464.0
2025-04-25 19:00:00	IWM	ETF	194.43	194.4894	194.17	194.3	5322.0
2025-04-25 04:00:00	DIA	ETF	401.6	401.64	401.01	401.01	5200.0
2025-04-25 05:00:00	DIA	ETF	401.12	401.12	400.77	400.9	700.0

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

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