PREVIEW / etf_1hour / 2025-05-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	560.39	560.49	558.84	559.75	65630.0
2025-05-06 05:00:00	SPY	ETF	559.76	559.76	558.75	559.6	61631.0
2025-05-06 06:00:00	SPY	ETF	559.7	560.26	559.26	560.07	22544.0
2025-05-06 07:00:00	SPY	ETF	560.23	560.55	558.0	558.79	269297.0
2025-05-06 08:00:00	SPY	ETF	560.54	562.41	558.0	558.95	429858.0
2025-05-06 09:00:00	SPY	ETF	558.98	559.76	556.96	557.4	4422699.0
2025-05-06 10:00:00	SPY	ETF	557.4	561.41	557.09	560.75	4877935.0
2025-05-06 11:00:00	SPY	ETF	560.75	561.94	560.19	560.37	3139266.0
2025-05-06 12:00:00	SPY	ETF	560.375	563.3476	559.1204	559.21	5155324.0
2025-05-06 13:00:00	SPY	ETF	559.24	560.5899	558.32	558.44	2825681.0
2025-05-06 14:00:00	SPY	ETF	558.45	561.08	558.43	561.04	3858976.0
2025-05-06 15:00:00	SPY	ETF	561.06	561.4	558.72	558.8	8269774.0
2025-05-06 16:00:00	SPY	ETF	558.83	559.5	556.82	557.8501	2899058.0
2025-05-06 17:00:00	SPY	ETF	557.9	558.8	557.25	557.36	459449.0
2025-05-06 18:00:00	SPY	ETF	557.36	565.06	557.36	563.431	1003307.0
2025-05-06 19:00:00	SPY	ETF	563.5	563.65	562.54	563.4	177163.0
2025-05-06 04:00:00	QQQ	ETF	482.22	482.97	480.49	481.47	105055.0
2025-05-06 05:00:00	QQQ	ETF	481.38	481.42	480.3	481.29	50093.0
2025-05-06 06:00:00	QQQ	ETF	481.16	481.89	480.95	481.81	64695.0
2025-05-06 07:00:00	QQQ	ETF	481.84	482.2	479.87	480.62	163882.0
2025-05-06 08:00:00	QQQ	ETF	482.15	484.23	479.77	480.61	298769.0
2025-05-06 09:00:00	QQQ	ETF	480.63	481.19	478.4	478.6109	3779998.0
2025-05-06 10:00:00	QQQ	ETF	478.66	482.92	478.19	482.15	3454477.0
2025-05-06 11:00:00	QQQ	ETF	482.14	483.29	481.7	481.93	1948052.0
2025-05-06 12:00:00	QQQ	ETF	481.95	485.05	481.06	481.16	3605899.0
2025-05-06 13:00:00	QQQ	ETF	481.215	482.48	480.54	480.725	1837331.0
2025-05-06 14:00:00	QQQ	ETF	480.75	483.34	480.75	483.32	2343222.0
2025-05-06 15:00:00	QQQ	ETF	483.31	483.8	481.31	481.42	3576524.0
2025-05-06 16:00:00	QQQ	ETF	481.43	482.11	479.89	480.86	1473642.0
2025-05-06 17:00:00	QQQ	ETF	480.77	481.41	479.6	479.6	250607.0
2025-05-06 18:00:00	QQQ	ETF	479.75	487.5	479.75	486.34	926195.0
2025-05-06 19:00:00	QQQ	ETF	486.4999	486.4999	485.15	486.04	213943.0
2025-05-06 04:00:00	IWM	ETF	197.66	197.66	196.97	197.4	29545.0
2025-05-06 05:00:00	IWM	ETF	197.35	197.35	196.7	197.14	29213.0
2025-05-06 06:00:00	IWM	ETF	197.11	197.55	197.06	197.55	9381.0
2025-05-06 07:00:00	IWM	ETF	197.6	197.71	196.8	196.96	137397.0
2025-05-06 08:00:00	IWM	ETF	197.27	198.6	196.75	197.23	127767.0
2025-05-06 09:00:00	IWM	ETF	197.24	197.57	195.64	196.34	3597983.0
2025-05-06 10:00:00	IWM	ETF	196.37	198.01	196.32	197.657	2708616.0
2025-05-06 11:00:00	IWM	ETF	197.64	198.27	197.56	197.72	1055777.0
2025-05-06 12:00:00	IWM	ETF	197.715	198.59	196.52	196.57	2359229.0
2025-05-06 13:00:00	IWM	ETF	196.59	197.1	196.155	196.275	1437826.0
2025-05-06 14:00:00	IWM	ETF	196.27	197.36	196.27	197.29	1896419.0
2025-05-06 15:00:00	IWM	ETF	197.28	197.59	196.66	196.78	3765756.0
2025-05-06 16:00:00	IWM	ETF	196.77	197.22	195.73	196.15	1475722.0
2025-05-06 17:00:00	IWM	ETF	196.25	196.31	196.02	196.06	5168.0
2025-05-06 18:00:00	IWM	ETF	196.06	199.17	196.05	198.5	143417.0
2025-05-06 19:00:00	IWM	ETF	198.48	198.48	198.08	198.3301	49859.0
2025-05-06 04:00:00	DIA	ETF	410.53	410.53	409.5	409.5	426.0
2025-05-06 05:00:00	DIA	ETF	409.65	409.65	409.25	409.25	400.0

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

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