PREVIEW / etf_1hour / 2025-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-01.parquet
  size:    630 KB
  rows:    24,484

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-01 04:00:00	SPY	ETF	557.55	559.0	557.37	558.99	42199.0
2025-04-01 05:00:00	SPY	ETF	559.06	559.81	558.86	559.5	26605.0
2025-04-01 06:00:00	SPY	ETF	559.47	559.48	556.0	557.42	191378.0
2025-04-01 07:00:00	SPY	ETF	557.44	557.57	555.5	556.23	281482.0
2025-04-01 08:00:00	SPY	ETF	557.34	559.63	555.51	557.07	337678.0
2025-04-01 09:00:00	SPY	ETF	557.12	558.58	556.0	557.22	3698661.0
2025-04-01 10:00:00	SPY	ETF	557.1526	559.8	553.68	559.72	6804904.0
2025-04-01 11:00:00	SPY	ETF	559.715	561.8794	559.4	561.57	5383900.0
2025-04-01 12:00:00	SPY	ETF	561.59	562.94	559.335	560.69	4429715.0
2025-04-01 13:00:00	SPY	ETF	560.6728	561.12	558.91	559.0	2783133.0
2025-04-01 14:00:00	SPY	ETF	559.0	559.17	556.15	557.662	4360507.0
2025-04-01 15:00:00	SPY	ETF	557.66	561.52	557.43	561.03	7808230.0
2025-04-01 16:00:00	SPY	ETF	561.06	561.48	560.23	560.75	2388924.0
2025-04-01 17:00:00	SPY	ETF	560.61	561.13	560.61	560.81	101765.0
2025-04-01 18:00:00	SPY	ETF	560.83	563.0	560.8	561.94	189327.0
2025-04-01 19:00:00	SPY	ETF	561.81	562.27	561.59	561.78	38833.0
2025-04-01 04:00:00	QQQ	ETF	466.94	470.0	466.94	469.36	109239.0
2025-04-01 05:00:00	QQQ	ETF	469.5	470.39	469.2	469.84	88544.0
2025-04-01 06:00:00	QQQ	ETF	469.88	469.88	466.38	467.85	223001.0
2025-04-01 07:00:00	QQQ	ETF	467.89	467.96	465.68	466.73	299253.0
2025-04-01 08:00:00	QQQ	ETF	466.65	470.2096	465.7401	467.33	342845.0
2025-04-01 09:00:00	QQQ	ETF	467.4	469.28	466.28	467.69	3723212.0
2025-04-01 10:00:00	QQQ	ETF	467.71	470.65	464.42	470.5502	5220391.0
2025-04-01 11:00:00	QQQ	ETF	470.55	472.725	470.25	472.3888	3983016.0
2025-04-01 12:00:00	QQQ	ETF	472.4	473.63	470.09	471.7102	3584767.0
2025-04-01 13:00:00	QQQ	ETF	471.71	472.155	470.18	470.3	2494311.0
2025-04-01 14:00:00	QQQ	ETF	470.44	470.49	467.37	468.9399	3563220.0
2025-04-01 15:00:00	QQQ	ETF	468.89	473.17	468.66	472.63	4636072.0
2025-04-01 16:00:00	QQQ	ETF	472.62	473.22	471.95	472.5	1237327.0
2025-04-01 17:00:00	QQQ	ETF	472.4475	472.76	472.35	472.75	51567.0
2025-04-01 18:00:00	QQQ	ETF	472.6	474.79	472.45	473.58	157896.0
2025-04-01 19:00:00	QQQ	ETF	473.41	474.09	473.32	473.63	121759.0
2025-04-01 04:00:00	IWM	ETF	198.9	199.6	198.74	199.58	26444.0
2025-04-01 05:00:00	IWM	ETF	199.64	200.1	199.58	200.04	23415.0
2025-04-01 06:00:00	IWM	ETF	199.91	199.91	198.72	199.5	62633.0
2025-04-01 07:00:00	IWM	ETF	199.41	199.44	198.64	198.94	51818.0
2025-04-01 08:00:00	IWM	ETF	199.19	199.6496	198.72	198.95	95010.0
2025-04-01 09:00:00	IWM	ETF	198.9288	199.25	197.32	198.06	3081152.0
2025-04-01 10:00:00	IWM	ETF	198.04	199.19	196.66	199.18	3255069.0
2025-04-01 11:00:00	IWM	ETF	199.17	200.94	199.06	200.9	2829186.0
2025-04-01 12:00:00	IWM	ETF	200.91	201.23	199.32	199.85	2501111.0
2025-04-01 13:00:00	IWM	ETF	199.85	200.055	198.94	198.97	1045619.0
2025-04-01 14:00:00	IWM	ETF	198.99	199.05	197.64	198.31	1823150.0
2025-04-01 15:00:00	IWM	ETF	198.3	199.765	198.24	199.52	4024305.0
2025-04-01 16:00:00	IWM	ETF	199.51	199.79	199.25	199.55	1374477.0
2025-04-01 17:00:00	IWM	ETF	199.56	199.7	199.45	199.7	47999.0
2025-04-01 18:00:00	IWM	ETF	199.6	200.55	199.55	199.97	23452.0
2025-04-01 19:00:00	IWM	ETF	199.88	200.21	199.84	200.02	42680.0
2025-04-01 04:00:00	DIA	ETF	418.51	418.8	418.51	418.8	1419.0
2025-04-01 06:00:00	DIA	ETF	419.33	419.33	417.75	417.75	2225.0

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

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