PREVIEW / etf_1hour / 2025-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-01.parquet
  size:    646 KB
  rows:    24,687

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-05-01 04:00:00	SPY	ETF	560.07	561.04	559.65	561.0	55530.0
2025-05-01 05:00:00	SPY	ETF	560.99	562.05	560.89	561.9	51747.0
2025-05-01 06:00:00	SPY	ETF	561.93	562.07	560.62	561.05	90238.0
2025-05-01 07:00:00	SPY	ETF	561.05	561.74	560.36	561.31	426232.0
2025-05-01 08:00:00	SPY	ETF	560.75	561.91	554.125	559.85	710015.0
2025-05-01 09:00:00	SPY	ETF	559.88	561.36	558.65	558.85	5714525.0
2025-05-01 10:00:00	SPY	ETF	558.85	563.395	558.83	563.35	6715154.0
2025-05-01 11:00:00	SPY	ETF	563.36	564.0699	559.69	560.38	5266633.0
2025-05-01 12:00:00	SPY	ETF	560.4	561.26	559.06	559.69	3328576.0
2025-05-01 13:00:00	SPY	ETF	559.64	561.9462	559.64	560.57	2603535.0
2025-05-01 14:00:00	SPY	ETF	560.58	562.69	560.47	561.705	3815150.0
2025-05-01 15:00:00	SPY	ETF	561.73	562.49	557.86	558.46	10284316.0
2025-05-01 16:00:00	SPY	ETF	558.43	559.8	556.0	557.0	3495761.0
2025-05-01 17:00:00	SPY	ETF	557.06	558.47	555.3	556.95	219811.0
2025-05-01 18:00:00	SPY	ETF	556.89	557.2	556.06	556.88	105917.0
2025-05-01 19:00:00	SPY	ETF	556.9	557.77	556.81	557.18	114484.0
2025-05-01 04:00:00	QQQ	ETF	483.0	483.79	482.48	483.73	55411.0
2025-05-01 05:00:00	QQQ	ETF	483.74	484.65	483.51	484.53	91534.0
2025-05-01 06:00:00	QQQ	ETF	484.5	484.78	483.75	484.21	65836.0
2025-05-01 07:00:00	QQQ	ETF	484.21	484.73	483.72	484.29	187898.0
2025-05-01 08:00:00	QQQ	ETF	484.62	484.95	481.9	483.09	607896.0
2025-05-01 09:00:00	QQQ	ETF	483.0699	483.95	480.8201	481.0	4338970.0
2025-05-01 10:00:00	QQQ	ETF	481.09	485.93	480.91	485.92	4890427.0
2025-05-01 11:00:00	QQQ	ETF	485.92	487.18	482.54	483.24	5421053.0
2025-05-01 12:00:00	QQQ	ETF	483.21	484.145	482.0	482.798	2693813.0
2025-05-01 13:00:00	QQQ	ETF	482.75	484.85	482.69	483.74	1937112.0
2025-05-01 14:00:00	QQQ	ETF	483.71	485.31	483.59	484.38	2228171.0
2025-05-01 15:00:00	QQQ	ETF	484.39	484.7	480.74	481.19	4778209.0
2025-05-01 16:00:00	QQQ	ETF	481.195	482.49	478.37	479.12	3168336.0
2025-05-01 17:00:00	QQQ	ETF	479.15	480.3	478.7	478.93	232267.0
2025-05-01 18:00:00	QQQ	ETF	478.93	479.23	478.12	478.87	218826.0
2025-05-01 19:00:00	QQQ	ETF	478.8915	479.86	478.8	479.0	139042.0
2025-05-01 04:00:00	IWM	ETF	195.23	195.52	195.01	195.45	27788.0
2025-05-01 05:00:00	IWM	ETF	195.47	195.85	195.4	195.85	69523.0
2025-05-01 06:00:00	IWM	ETF	195.84	195.97	195.38	195.55	19582.0
2025-05-01 07:00:00	IWM	ETF	195.5	195.87	195.3	195.75	81770.0
2025-05-01 08:00:00	IWM	ETF	195.38	196.07	194.61	194.62	598999.0
2025-05-01 09:00:00	IWM	ETF	194.64	196.1	193.74	194.9	3850671.0
2025-05-01 10:00:00	IWM	ETF	195.08	197.55	194.935	197.52	4318409.0
2025-05-01 11:00:00	IWM	ETF	197.5	197.67	195.65	195.78	3482866.0
2025-05-01 12:00:00	IWM	ETF	195.8	196.02	195.18	195.64	2235411.0
2025-05-01 13:00:00	IWM	ETF	195.67	196.64	195.65	195.77	1104892.0
2025-05-01 14:00:00	IWM	ETF	195.78	196.911	195.72	196.83	2006989.0
2025-05-01 15:00:00	IWM	ETF	196.83	197.41	195.825	196.075	4502762.0
2025-05-01 16:00:00	IWM	ETF	196.07	196.35	195.36	195.95	1494016.0
2025-05-01 17:00:00	IWM	ETF	195.92	196.06	195.5	195.65	25647.0
2025-05-01 18:00:00	IWM	ETF	195.74	196.13	195.71	195.9	33220.0
2025-05-01 19:00:00	IWM	ETF	196.01	196.19	195.87	196.011	15861.0
2025-05-01 04:00:00	DIA	ETF	408.27	408.89	408.14	408.89	4000.0
2025-05-01 05:00:00	DIA	ETF	409.4	409.71	409.4	409.71	800.0

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

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