PREVIEW / etf_1hour / 2026-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-23.parquet
  size:    658 KB
  rows:    26,618

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-23 04:00:00	SPY	ETF	642.95	644.89	642.25	644.37	288704.0
2026-03-23 05:00:00	SPY	ETF	644.47	645.2	642.41	643.23	256104.0
2026-03-23 06:00:00	SPY	ETF	643.4	644.36	641.61	643.21	437913.0
2026-03-23 07:00:00	SPY	ETF	643.28	666.82	643.17	656.08	6430094.0
2026-03-23 08:00:00	SPY	ETF	656.1	666.8	641.0	661.2516	3505984.0
2026-03-23 09:00:00	SPY	ETF	661.38	661.88	656.07	660.22	14429637.0
2026-03-23 10:00:00	SPY	ETF	660.2	662.27	658.58	661.05	13395787.0
2026-03-23 11:00:00	SPY	ETF	661.07	662.615	655.83	656.01	15872398.0
2026-03-23 12:00:00	SPY	ETF	655.99	657.63	653.94	655.58	11844757.0
2026-03-23 13:00:00	SPY	ETF	655.6	658.25	654.31	658.06	7948001.0
2026-03-23 14:00:00	SPY	ETF	658.09	659.65	656.53	658.95	10266421.0
2026-03-23 15:00:00	SPY	ETF	658.95	659.02	655.37	655.375	15017814.0
2026-03-23 16:00:00	SPY	ETF	655.38	656.15	654.3839	655.53	6816833.0
2026-03-23 17:00:00	SPY	ETF	655.66	656.03	655.63	655.9	77985.0
2026-03-23 18:00:00	SPY	ETF	655.81	657.4422	654.8	657.28	144655.0
2026-03-23 19:00:00	SPY	ETF	657.21	657.21	656.13	656.75	124040.0
2026-03-23 04:00:00	QQQ	ETF	575.82	577.62	574.89	577.06	359949.0
2026-03-23 05:00:00	QQQ	ETF	577.08	577.99	575.01	576.03	190505.0
2026-03-23 06:00:00	QQQ	ETF	576.01	577.0	574.33	575.83	240556.0
2026-03-23 07:00:00	QQQ	ETF	575.89	597.0	575.82	588.14	2499227.0
2026-03-23 08:00:00	QQQ	ETF	593.58	597.0	573.25	593.35	2900345.0
2026-03-23 09:00:00	QQQ	ETF	593.4	594.15	589.001	592.98	10064596.0
2026-03-23 10:00:00	QQQ	ETF	592.98	595.0799	591.23	593.21	10636582.0
2026-03-23 11:00:00	QQQ	ETF	593.24	595.08	587.49	587.73	10480872.0
2026-03-23 12:00:00	QQQ	ETF	587.73	589.8	585.96	587.445	13839720.0
2026-03-23 13:00:00	QQQ	ETF	587.45	589.99	586.07	589.845	7759760.0
2026-03-23 14:00:00	QQQ	ETF	589.85	591.51	588.62	590.955	5721325.0
2026-03-23 15:00:00	QQQ	ETF	590.97	591.03	588.16	588.18	8815662.0
2026-03-23 16:00:00	QQQ	ETF	588.2	589.0	587.25	588.21	2184499.0
2026-03-23 17:00:00	QQQ	ETF	588.17	588.77	588.17	588.72	50439.0
2026-03-23 18:00:00	QQQ	ETF	588.72	590.3109	587.8	590.19	215109.0
2026-03-23 19:00:00	QQQ	ETF	590.11	590.11	588.91	589.4835	108133.0
2026-03-23 04:00:00	IWM	ETF	239.0	239.99	238.9	239.54	64568.0
2026-03-23 05:00:00	IWM	ETF	239.43	239.83	238.4	238.91	144473.0
2026-03-23 06:00:00	IWM	ETF	239.1	239.8	238.38	239.17	68476.0
2026-03-23 07:00:00	IWM	ETF	239.19	253.85	239.11	247.7	4167821.0
2026-03-23 08:00:00	IWM	ETF	248.3	253.9	238.46	249.46	1889157.0
2026-03-23 09:00:00	IWM	ETF	249.5	249.95	246.11	249.66	8774227.0
2026-03-23 10:00:00	IWM	ETF	249.65	250.49	248.62	250.275	7142588.0
2026-03-23 11:00:00	IWM	ETF	250.28	251.36	247.29	247.51	6666720.0
2026-03-23 12:00:00	IWM	ETF	247.5	248.51	246.94	247.73	5255560.0
2026-03-23 13:00:00	IWM	ETF	247.735	249.45	247.05	249.1701	4368461.0
2026-03-23 14:00:00	IWM	ETF	249.16	250.08	248.36	249.54	4575735.0
2026-03-23 15:00:00	IWM	ETF	249.54	249.6	247.4	247.44	6370502.0
2026-03-23 16:00:00	IWM	ETF	247.41	247.98	247.09	247.57	2192106.0
2026-03-23 17:00:00	IWM	ETF	247.59	247.98	247.4799	247.63	38286.0
2026-03-23 18:00:00	IWM	ETF	247.73	248.5	247.16	248.4	67051.0
2026-03-23 19:00:00	IWM	ETF	248.22	248.5	247.84	248.15	44211.0
2026-03-23 04:00:00	DIA	ETF	452.6	454.15	452.48	453.82	10840.0
2026-03-23 05:00:00	DIA	ETF	453.76	454.14	452.36	452.63	5090.0

> showing 50 of 26,618 rows — these rows as CSV

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