PREVIEW / etf_1hour / 2026-03-25

all etf 1-hour files

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

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-25 04:00:00	SPY	ETF	658.2	660.53	657.91	658.19	205962.0
2026-03-25 05:00:00	SPY	ETF	658.29	659.19	657.47	658.39	174545.0
2026-03-25 06:00:00	SPY	ETF	658.47	659.25	657.9	658.45	139517.0
2026-03-25 07:00:00	SPY	ETF	658.35	660.06	658.12	659.62	489069.0
2026-03-25 08:00:00	SPY	ETF	658.48	660.5191	656.32	658.53	1930933.0
2026-03-25 09:00:00	SPY	ETF	658.69	660.89	656.42	656.49	10137164.0
2026-03-25 10:00:00	SPY	ETF	656.56	660.5	655.67	658.69	12362184.0
2026-03-25 11:00:00	SPY	ETF	658.69	659.0078	654.24	657.0	13322002.0
2026-03-25 12:00:00	SPY	ETF	657.0	658.315	656.01	657.75	7436533.0
2026-03-25 13:00:00	SPY	ETF	657.75	659.38	656.915	657.9	8549815.0
2026-03-25 14:00:00	SPY	ETF	657.89	658.52	655.64	656.5	7070905.0
2026-03-25 15:00:00	SPY	ETF	656.49	657.3202	655.58	656.74	12653160.0
2026-03-25 16:00:00	SPY	ETF	656.71	657.23	656.05	656.68	1906434.0
2026-03-25 17:00:00	SPY	ETF	656.57	656.74	656.16	656.38	169811.0
2026-03-25 18:00:00	SPY	ETF	656.35	656.5	655.4	655.48	160270.0
2026-03-25 19:00:00	SPY	ETF	655.54	655.81	654.71	655.41	78808.0
2026-03-25 04:00:00	QQQ	ETF	588.6	591.6	588.57	589.4	331227.0
2026-03-25 05:00:00	QQQ	ETF	589.53	590.35	588.76	589.68	206328.0
2026-03-25 06:00:00	QQQ	ETF	589.79	590.51	589.1	589.62	136707.0
2026-03-25 07:00:00	QQQ	ETF	589.61	591.3	589.42	590.69	294472.0
2026-03-25 08:00:00	QQQ	ETF	590.68	591.74	584.417	589.66	1260811.0
2026-03-25 09:00:00	QQQ	ETF	589.56	591.37	587.44	587.62	6163632.0
2026-03-25 10:00:00	QQQ	ETF	587.63	591.2	586.68	590.36	10130565.0
2026-03-25 11:00:00	QQQ	ETF	590.36	590.59	585.69	587.86	9844958.0
2026-03-25 12:00:00	QQQ	ETF	587.84	589.57	586.71	588.86	5211758.0
2026-03-25 13:00:00	QQQ	ETF	588.86	590.57	587.85	588.99	5087146.0
2026-03-25 14:00:00	QQQ	ETF	588.98	589.64	586.49	587.27	3860108.0
2026-03-25 15:00:00	QQQ	ETF	587.26	588.21	586.26	587.74	6448784.0
2026-03-25 16:00:00	QQQ	ETF	587.73	588.1751	587.2	587.56	671027.0
2026-03-25 17:00:00	QQQ	ETF	587.42	587.76	587.3	587.53	66402.0
2026-03-25 18:00:00	QQQ	ETF	587.53	587.53	586.3	586.32	126165.0
2026-03-25 19:00:00	QQQ	ETF	586.3	586.79	585.65	586.56	109692.0
2026-03-25 04:00:00	IWM	ETF	251.98	253.04	251.67	251.88	59070.0
2026-03-25 05:00:00	IWM	ETF	251.89	252.39	251.22	251.74	77923.0
2026-03-25 06:00:00	IWM	ETF	251.74	252.3	251.6	251.81	63624.0
2026-03-25 07:00:00	IWM	ETF	251.8	252.65	251.5	252.09	205874.0
2026-03-25 08:00:00	IWM	ETF	251.8	252.95	250.08	251.55	746634.0
2026-03-25 09:00:00	IWM	ETF	251.49	252.963	251.04	251.14	4190704.0
2026-03-25 10:00:00	IWM	ETF	251.16	253.07	250.78	252.3	4781002.0
2026-03-25 11:00:00	IWM	ETF	252.3	252.41	249.52	251.62	4402907.0
2026-03-25 12:00:00	IWM	ETF	251.64	252.2	250.745	251.91	2455062.0
2026-03-25 13:00:00	IWM	ETF	251.92	252.62	251.3099	251.645	2364402.0
2026-03-25 14:00:00	IWM	ETF	251.63	252.22	250.4	250.97	2622018.0
2026-03-25 15:00:00	IWM	ETF	250.96	251.88	250.58	251.85	5769869.0
2026-03-25 16:00:00	IWM	ETF	251.82	252.13	251.34	251.62	1151425.0
2026-03-25 17:00:00	IWM	ETF	251.54	251.85	251.5	251.69	34043.0
2026-03-25 18:00:00	IWM	ETF	251.61	251.61	250.98	251.14	63659.0
2026-03-25 19:00:00	IWM	ETF	251.24	251.31	250.75	251.22	28935.0
2026-03-25 04:00:00	DIA	ETF	464.96	466.48	464.68	464.68	12795.0
2026-03-25 05:00:00	DIA	ETF	465.3	465.42	464.17	464.71	10272.0

> showing 50 of 24,313 rows — these rows as CSV

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