PREVIEW / etf_1hour / 2026-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-01.parquet
  size:    650 KB
  rows:    25,920

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-04-01 04:00:00	SPY	ETF	654.0	655.51	651.3	653.36	329594.0
2026-04-01 05:00:00	SPY	ETF	653.43	654.01	651.97	653.57	129378.0
2026-04-01 06:00:00	SPY	ETF	653.52	655.09	653.18	655.02	160382.0
2026-04-01 07:00:00	SPY	ETF	654.84	656.26	650.34	656.04	498973.0
2026-04-01 08:00:00	SPY	ETF	655.99	657.5	650.34	652.8395	2426586.0
2026-04-01 09:00:00	SPY	ETF	652.88	656.05	652.29	654.29	13210464.0
2026-04-01 10:00:00	SPY	ETF	654.3	656.85	653.58	656.5	12276685.0
2026-04-01 11:00:00	SPY	ETF	656.5	658.095	655.93	657.82	8209139.0
2026-04-01 12:00:00	SPY	ETF	657.815	658.0896	656.84	657.81	6180538.0
2026-04-01 13:00:00	SPY	ETF	657.82	658.52	656.77	656.79	5937672.0
2026-04-01 14:00:00	SPY	ETF	656.79	656.94	653.667	654.41	12317476.0
2026-04-01 15:00:00	SPY	ETF	654.39	656.75	654.255	655.17	15537243.0
2026-04-01 16:00:00	SPY	ETF	655.17	655.72	654.88	655.01	3640292.0
2026-04-01 17:00:00	SPY	ETF	655.05	655.4	654.9	655.0	105779.0
2026-04-01 18:00:00	SPY	ETF	655.0	655.46	654.32	654.5848	96860.0
2026-04-01 19:00:00	SPY	ETF	654.6	655.17	654.32	654.75	38239.0
2026-04-01 04:00:00	QQQ	ETF	580.77	583.7	578.86	581.07	542682.0
2026-04-01 05:00:00	QQQ	ETF	581.06	581.52	579.49	580.99	201033.0
2026-04-01 06:00:00	QQQ	ETF	581.03	582.71	580.59	582.43	205182.0
2026-04-01 07:00:00	QQQ	ETF	582.41	584.3	582.326	583.9737	523110.0
2026-04-01 08:00:00	QQQ	ETF	583.95	585.19	576.748	580.84	1272811.0
2026-04-01 09:00:00	QQQ	ETF	580.86	584.026	580.26	582.1798	8194582.0
2026-04-01 10:00:00	QQQ	ETF	582.18	585.8	581.95	585.57	10507188.0
2026-04-01 11:00:00	QQQ	ETF	585.57	587.18	584.85	586.875	8092070.0
2026-04-01 12:00:00	QQQ	ETF	586.88	587.31	586.27	587.0374	4959339.0
2026-04-01 13:00:00	QQQ	ETF	587.05	587.739	585.7	585.76	6354043.0
2026-04-01 14:00:00	QQQ	ETF	585.7501	585.95	582.3265	583.17	12582552.0
2026-04-01 15:00:00	QQQ	ETF	583.165	585.51	583.05	584.26	12315188.0
2026-04-01 16:00:00	QQQ	ETF	584.31	584.6	583.7	583.91	1636867.0
2026-04-01 17:00:00	QQQ	ETF	583.96	584.11	583.82	583.94	32727.0
2026-04-01 18:00:00	QQQ	ETF	583.86	584.31	583.28	583.6	100014.0
2026-04-01 19:00:00	QQQ	ETF	583.51	584.29	583.32	583.87	71018.0
2026-04-01 04:00:00	IWM	ETF	249.55	250.94	248.29	249.59	141975.0
2026-04-01 05:00:00	IWM	ETF	249.69	249.84	248.78	249.63	16833.0
2026-04-01 06:00:00	IWM	ETF	249.55	250.25	249.35	250.03	56078.0
2026-04-01 07:00:00	IWM	ETF	250.0	250.83	248.0	250.7487	144060.0
2026-04-01 08:00:00	IWM	ETF	250.68	251.36	248.65	248.89	629828.0
2026-04-01 09:00:00	IWM	ETF	248.93	251.36	248.69	250.75	5668810.0
2026-04-01 10:00:00	IWM	ETF	250.74	251.87	250.13	251.74	5549513.0
2026-04-01 11:00:00	IWM	ETF	251.74	252.38	251.35	252.205	3582444.0
2026-04-01 12:00:00	IWM	ETF	252.21	252.44	251.36	252.04	3466334.0
2026-04-01 13:00:00	IWM	ETF	252.04	252.34	251.1	251.13	2438315.0
2026-04-01 14:00:00	IWM	ETF	251.135	251.2	249.11	249.48	5770472.0
2026-04-01 15:00:00	IWM	ETF	249.48	250.36	249.35	249.54	7609265.0
2026-04-01 16:00:00	IWM	ETF	249.56	250.0	249.43	249.69	846394.0
2026-04-01 17:00:00	IWM	ETF	249.65	249.72	249.3891	249.39	66503.0
2026-04-01 18:00:00	IWM	ETF	249.49	249.81	249.32	249.54	67592.0
2026-04-01 19:00:00	IWM	ETF	249.44	249.71	249.4	249.56	20197.0
2026-04-01 04:00:00	DIA	ETF	463.64	466.02	463.64	465.46	15168.0
2026-04-01 05:00:00	DIA	ETF	465.46	465.79	464.57	465.52	5044.0

> showing 50 of 25,920 rows — these rows as CSV

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