PREVIEW / etf_1hour / 2026-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-02.parquet
  size:    631 KB
  rows:    25,057

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-02 04:00:00	SPY	ETF	648.01	649.35	645.76	647.87	345179.0
2026-04-02 05:00:00	SPY	ETF	648.1	648.42	647.5	647.75	74994.0
2026-04-02 06:00:00	SPY	ETF	647.7	647.9	646.43	647.31	152402.0
2026-04-02 07:00:00	SPY	ETF	647.4198	647.5	644.59	644.59	781538.0
2026-04-02 08:00:00	SPY	ETF	644.6	646.15	644.16	645.38	578588.0
2026-04-02 09:00:00	SPY	ETF	645.39	649.89	645.11	649.63	7417358.0
2026-04-02 10:00:00	SPY	ETF	649.645	658.2	648.55	655.39	15420340.0
2026-04-02 11:00:00	SPY	ETF	655.39	655.93	653.0301	654.0	6498227.0
2026-04-02 12:00:00	SPY	ETF	653.985	654.95	652.17	653.56	4543917.0
2026-04-02 13:00:00	SPY	ETF	653.57	655.04	652.55	653.2102	2733705.0
2026-04-02 14:00:00	SPY	ETF	653.24	655.015	653.24	654.46	3810123.0
2026-04-02 15:00:00	SPY	ETF	654.46	656.1	654.09	655.88	8110157.0
2026-04-02 16:00:00	SPY	ETF	655.9	656.4	654.6334	655.91	3148281.0
2026-04-02 17:00:00	SPY	ETF	655.85	656.07	655.64	655.8	104478.0
2026-04-02 18:00:00	SPY	ETF	655.72	656.1	655.5	655.9	67456.0
2026-04-02 19:00:00	SPY	ETF	655.84	656.08	655.63	655.92	41388.0
2026-04-02 04:00:00	QQQ	ETF	579.15	579.15	573.75	575.7166	463519.0
2026-04-02 05:00:00	QQQ	ETF	575.7484	576.28	575.34	575.6	134709.0
2026-04-02 06:00:00	QQQ	ETF	575.5584	575.8	574.3	575.06	147472.0
2026-04-02 07:00:00	QQQ	ETF	575.17	575.36	572.02	572.03	549908.0
2026-04-02 08:00:00	QQQ	ETF	572.07	573.78	571.66	573.02	489820.0
2026-04-02 09:00:00	QQQ	ETF	573.04	577.43	571.92	577.19	8397879.0
2026-04-02 10:00:00	QQQ	ETF	577.2	586.05	576.23	583.83	12713338.0
2026-04-02 11:00:00	QQQ	ETF	583.82	584.74	581.73	582.8703	5243894.0
2026-04-02 12:00:00	QQQ	ETF	582.84	583.85	580.97	582.52	4169768.0
2026-04-02 13:00:00	QQQ	ETF	582.52	583.96	581.14	581.81	3268246.0
2026-04-02 14:00:00	QQQ	ETF	581.815	583.54	581.815	582.9642	2599016.0
2026-04-02 15:00:00	QQQ	ETF	582.99	585.09	582.8401	585.0	5278258.0
2026-04-02 16:00:00	QQQ	ETF	585.01	585.29	584.48	584.88	1180601.0
2026-04-02 17:00:00	QQQ	ETF	584.87	584.9	584.56	584.6383	45555.0
2026-04-02 18:00:00	QQQ	ETF	584.65	584.8899	584.0104	584.6022	111951.0
2026-04-02 19:00:00	QQQ	ETF	584.5	584.85	584.26	584.8	74875.0
2026-04-02 04:00:00	IWM	ETF	246.01	246.24	244.41	245.81	131436.0
2026-04-02 05:00:00	IWM	ETF	245.84	245.98	245.49	245.66	27979.0
2026-04-02 06:00:00	IWM	ETF	245.63	245.77	245.1	245.43	65990.0
2026-04-02 07:00:00	IWM	ETF	245.49	245.58	244.2048	244.2213	493823.0
2026-04-02 08:00:00	IWM	ETF	244.24	244.99	243.8	244.74	283728.0
2026-04-02 09:00:00	IWM	ETF	244.64	246.94	244.53	246.92	4093602.0
2026-04-02 10:00:00	IWM	ETF	246.93	252.37	246.42	250.79	6404885.0
2026-04-02 11:00:00	IWM	ETF	250.83	251.255	249.65	250.36	2011323.0
2026-04-02 12:00:00	IWM	ETF	250.38	250.825	249.2675	249.91	1648491.0
2026-04-02 13:00:00	IWM	ETF	249.895	250.52	249.5	249.79	957892.0
2026-04-02 14:00:00	IWM	ETF	249.8	250.965	249.76	250.765	1330257.0
2026-04-02 15:00:00	IWM	ETF	250.77	251.37	250.625	251.25	3360450.0
2026-04-02 16:00:00	IWM	ETF	251.28	251.34	250.84	251.17	1151939.0
2026-04-02 17:00:00	IWM	ETF	251.1	251.18	250.9648	251.07	6751.0
2026-04-02 18:00:00	IWM	ETF	250.97	251.25	250.89	251.1896	20876.0
2026-04-02 19:00:00	IWM	ETF	251.06	251.2499	251.02	251.19	33420.0
2026-04-02 04:00:00	DIA	ETF	461.67	461.74	459.74	461.74	4382.0
2026-04-02 05:00:00	DIA	ETF	461.37	461.47	460.93	460.94	1537.0

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

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