PREVIEW / etf_1hour / 2026-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-24.parquet
  size:    635 KB
  rows:    25,209

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-03-24 04:00:00	SPY	ETF	655.17	657.47	654.33	654.87	105733.0
2026-03-24 05:00:00	SPY	ETF	654.37	655.76	652.85	655.53	64539.0
2026-03-24 06:00:00	SPY	ETF	655.4	655.84	654.4	655.18	56572.0
2026-03-24 07:00:00	SPY	ETF	655.34	655.7	652.86	655.06	347676.0
2026-03-24 08:00:00	SPY	ETF	655.07	657.63	650.72	652.34	786901.0
2026-03-24 09:00:00	SPY	ETF	652.3476	653.04	649.88	651.48	8074903.0
2026-03-24 10:00:00	SPY	ETF	651.48	655.94	651.22	653.94	14644620.0
2026-03-24 11:00:00	SPY	ETF	653.98	657.03	653.92	655.04	8453389.0
2026-03-24 12:00:00	SPY	ETF	655.05	656.25	654.04	655.15	6329018.0
2026-03-24 13:00:00	SPY	ETF	655.13	655.39	652.38	654.3	9289254.0
2026-03-24 14:00:00	SPY	ETF	654.3	656.59	653.2	654.86	9162778.0
2026-03-24 15:00:00	SPY	ETF	654.83	655.69	652.56	653.2	11732548.0
2026-03-24 16:00:00	SPY	ETF	653.21	660.41	653.0692	657.14	10451610.0
2026-03-24 17:00:00	SPY	ETF	657.25	658.31	657.0	657.52	445615.0
2026-03-24 18:00:00	SPY	ETF	657.63	658.46	656.65	658.0	283310.0
2026-03-24 19:00:00	SPY	ETF	658.0	658.36	657.39	657.55	211558.0
2026-03-24 04:00:00	QQQ	ETF	589.48	590.4	587.41	587.77	208819.0
2026-03-24 05:00:00	QQQ	ETF	587.69	589.0	586.01	588.81	124917.0
2026-03-24 06:00:00	QQQ	ETF	588.76	589.06	587.56	588.4	83310.0
2026-03-24 07:00:00	QQQ	ETF	588.47	588.85	585.86	587.94	278665.0
2026-03-24 08:00:00	QQQ	ETF	587.94	590.81	583.4	585.37	760684.0
2026-03-24 09:00:00	QQQ	ETF	585.35	586.28	581.93	583.88	6240519.0
2026-03-24 10:00:00	QQQ	ETF	583.86	586.95	582.93	584.52	9177890.0
2026-03-24 11:00:00	QQQ	ETF	584.54	587.93	584.47	585.77	5691302.0
2026-03-24 12:00:00	QQQ	ETF	585.74	586.99	584.58	585.47	4228766.0
2026-03-24 13:00:00	QQQ	ETF	585.45	585.78	582.59	584.55	5667674.0
2026-03-24 14:00:00	QQQ	ETF	584.555	587.038	583.73	585.32	5358249.0
2026-03-24 15:00:00	QQQ	ETF	585.29	586.36	583.25	583.93	5996224.0
2026-03-24 16:00:00	QQQ	ETF	583.92	591.82	583.78	588.23	3529764.0
2026-03-24 17:00:00	QQQ	ETF	588.58	589.24	587.56	588.7614	432003.0
2026-03-24 18:00:00	QQQ	ETF	588.87	589.68	587.9	588.9	318859.0
2026-03-24 19:00:00	QQQ	ETF	588.94	589.29	588.36	588.67	159990.0
2026-03-24 04:00:00	IWM	ETF	248.07	248.49	246.8	246.95	73884.0
2026-03-24 05:00:00	IWM	ETF	246.85	247.55	245.98	247.4	28359.0
2026-03-24 06:00:00	IWM	ETF	247.1	247.64	246.77	247.26	18255.0
2026-03-24 07:00:00	IWM	ETF	247.03	247.58	245.9	247.18	80142.0
2026-03-24 08:00:00	IWM	ETF	248.02	248.44	244.57	245.69	413840.0
2026-03-24 09:00:00	IWM	ETF	245.76	246.59	244.6	245.63	4173107.0
2026-03-24 10:00:00	IWM	ETF	245.6	248.77	245.38	248.09	5189926.0
2026-03-24 11:00:00	IWM	ETF	248.1	249.87	248.1	248.76	3049243.0
2026-03-24 12:00:00	IWM	ETF	248.76	249.46	248.3	249.14	2717332.0
2026-03-24 13:00:00	IWM	ETF	249.14	249.38	247.26	248.7	3617652.0
2026-03-24 14:00:00	IWM	ETF	248.7	250.16	248.2	249.26	2090965.0
2026-03-24 15:00:00	IWM	ETF	249.28	250.005	248.57	248.79	4069685.0
2026-03-24 16:00:00	IWM	ETF	248.8	253.28	248.55	251.62	3143390.0
2026-03-24 17:00:00	IWM	ETF	251.61	251.9702	251.13	251.69	143269.0
2026-03-24 18:00:00	IWM	ETF	251.65	252.0	250.9	251.78	94931.0
2026-03-24 19:00:00	IWM	ETF	251.85	251.92	251.48	251.74	30206.0
2026-03-24 04:00:00	DIA	ETF	462.88	463.05	460.96	460.97	8093.0
2026-03-24 05:00:00	DIA	ETF	460.93	461.67	459.88	461.66	7294.0

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

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