PREVIEW / etf_1hour / 2026-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-04.parquet
  size:    720 KB
  rows:    29,098

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
2026-05-04 04:00:00	SPY	ETF	721.8	722.34	720.34	721.21	57316.0
2026-05-04 05:00:00	SPY	ETF	721.14	721.77	721.14	721.4843	12950.0
2026-05-04 06:00:00	SPY	ETF	721.359	721.49	716.46	719.68	889905.0
2026-05-04 07:00:00	SPY	ETF	719.69	720.35	718.67	719.55	245806.0
2026-05-04 08:00:00	SPY	ETF	719.56	720.57	719.56	719.95	251202.0
2026-05-04 09:00:00	SPY	ETF	719.76	720.8	718.84	720.7602	4066938.0
2026-05-04 10:00:00	SPY	ETF	720.77	722.12	719.865	720.91	4345054.0
2026-05-04 11:00:00	SPY	ETF	720.92	721.56	716.98	717.5898	9189889.0
2026-05-04 12:00:00	SPY	ETF	717.59	717.87	714.99	716.55	5349075.0
2026-05-04 13:00:00	SPY	ETF	716.54	718.64	716.48	718.3301	3181678.0
2026-05-04 14:00:00	SPY	ETF	718.33	718.995	716.83	717.47	3646605.0
2026-05-04 15:00:00	SPY	ETF	717.48	718.26	717.13	718.07	8709264.0
2026-05-04 16:00:00	SPY	ETF	718.08	718.08	717.28	717.57	2150729.0
2026-05-04 17:00:00	SPY	ETF	717.59	717.95	717.5729	717.8	38755.0
2026-05-04 18:00:00	SPY	ETF	717.96	718.46	717.63	717.76	67419.0
2026-05-04 19:00:00	SPY	ETF	717.75	717.95	717.57	717.7622	32393.0
2026-05-04 04:00:00	QQQ	ETF	676.0	677.35	674.91	675.64	213242.0
2026-05-04 05:00:00	QQQ	ETF	675.56	676.35	675.4	675.64	96882.0
2026-05-04 06:00:00	QQQ	ETF	675.53	675.62	670.08	673.63	539342.0
2026-05-04 07:00:00	QQQ	ETF	673.68	674.5	672.88	674.06	219267.0
2026-05-04 08:00:00	QQQ	ETF	674.14	675.27	674.07	674.33	274524.0
2026-05-04 09:00:00	QQQ	ETF	674.4	675.67	673.09	675.61	2974433.0
2026-05-04 10:00:00	QQQ	ETF	675.6	676.73	674.45	675.3	3824690.0
2026-05-04 11:00:00	QQQ	ETF	675.33	676.0893	670.86	671.775	4941475.0
2026-05-04 12:00:00	QQQ	ETF	671.78	672.08	668.9	671.14	3775117.0
2026-05-04 13:00:00	QQQ	ETF	671.09	673.45	671.07	673.1701	2439478.0
2026-05-04 14:00:00	QQQ	ETF	673.17	673.7899	671.39	672.39	1815676.0
2026-05-04 15:00:00	QQQ	ETF	672.42	673.2	671.91	672.88	3598130.0
2026-05-04 16:00:00	QQQ	ETF	672.83	672.88	671.86	671.92	998750.0
2026-05-04 17:00:00	QQQ	ETF	672.0	672.35	671.9508	672.33	56779.0
2026-05-04 18:00:00	QQQ	ETF	672.26	673.0	671.98	672.13	83839.0
2026-05-04 19:00:00	QQQ	ETF	672.18	672.4	671.79	672.0	60529.0
2026-05-04 04:00:00	IWM	ETF	279.11	279.75	278.8	279.3	65203.0
2026-05-04 05:00:00	IWM	ETF	279.26	279.49	279.2	279.23	10352.0
2026-05-04 06:00:00	IWM	ETF	279.2	279.2	276.1	278.26	349499.0
2026-05-04 07:00:00	IWM	ETF	278.3	278.68	277.57	278.1586	132093.0
2026-05-04 08:00:00	IWM	ETF	278.28	278.9419	278.06	278.57	113689.0
2026-05-04 09:00:00	IWM	ETF	278.52	280.095	277.845	279.7225	3617961.0
2026-05-04 10:00:00	IWM	ETF	279.71	280.79	279.4	280.07	2269600.0
2026-05-04 11:00:00	IWM	ETF	280.08	280.42	277.24	277.63	4005727.0
2026-05-04 12:00:00	IWM	ETF	277.62	277.83	276.1	276.65	3024041.0
2026-05-04 13:00:00	IWM	ETF	276.64	278.17	276.49	278.01	1743284.0
2026-05-04 14:00:00	IWM	ETF	278.0	278.43	277.53	277.725	1589796.0
2026-05-04 15:00:00	IWM	ETF	277.71	278.24	277.5	277.93	3060966.0
2026-05-04 16:00:00	IWM	ETF	277.88	277.9	277.33	277.69	1026015.0
2026-05-04 17:00:00	IWM	ETF	277.7	277.95	277.7	277.83	30514.0
2026-05-04 18:00:00	IWM	ETF	277.79	278.05	277.73	277.78	22232.0
2026-05-04 19:00:00	IWM	ETF	277.74	277.83	277.6	277.81	19353.0
2026-05-04 04:00:00	DIA	ETF	494.54	495.1	493.7	494.17	4066.0
2026-05-04 05:00:00	DIA	ETF	494.2	494.35	494.2	494.35	424.0

> showing 50 of 29,098 rows — these rows as CSV

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