PREVIEW / etf_1hour / 2026-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-09.parquet
  size:    765 KB
  rows:    30,648

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-09 04:00:00	SPY	ETF	662.47	665.28	661.72	663.93	302368.0
2026-03-09 05:00:00	SPY	ETF	664.08	668.36	663.27	666.42	334850.0
2026-03-09 06:00:00	SPY	ETF	666.65	666.86	664.43	665.07	196869.0
2026-03-09 07:00:00	SPY	ETF	665.0	666.01	664.38	665.1	328449.0
2026-03-09 08:00:00	SPY	ETF	665.09	668.0875	659.24	665.3	966011.0
2026-03-09 09:00:00	SPY	ETF	665.32	667.63	662.7	664.08	10166443.0
2026-03-09 10:00:00	SPY	ETF	664.05	668.31	662.39	667.58	12716846.0
2026-03-09 11:00:00	SPY	ETF	667.58	669.92	667.58	669.44	8960773.0
2026-03-09 12:00:00	SPY	ETF	669.46	672.25	669.1699	671.2699	8240964.0
2026-03-09 13:00:00	SPY	ETF	671.275	671.36	668.09	668.815	7418826.0
2026-03-09 14:00:00	SPY	ETF	668.84	671.3	668.77	670.08	7528629.0
2026-03-09 15:00:00	SPY	ETF	670.1	679.92	669.9	678.31	24986652.0
2026-03-09 16:00:00	SPY	ETF	678.3	679.0	676.28	677.52	4816767.0
2026-03-09 17:00:00	SPY	ETF	677.7	677.93	676.86	677.62	247506.0
2026-03-09 18:00:00	SPY	ETF	677.69	678.0	675.53	675.9896	528694.0
2026-03-09 19:00:00	SPY	ETF	675.91	676.4182	674.72	675.3392	119445.0
2026-03-09 04:00:00	QQQ	ETF	590.51	591.86	589.1	591.32	294731.0
2026-03-09 05:00:00	QQQ	ETF	591.34	595.74	590.69	593.83	362896.0
2026-03-09 06:00:00	QQQ	ETF	594.05	594.22	592.1	592.82	287993.0
2026-03-09 07:00:00	QQQ	ETF	592.75	594.0	592.3	593.01	229010.0
2026-03-09 08:00:00	QQQ	ETF	592.92	595.75	585.87	592.92	1012216.0
2026-03-09 09:00:00	QQQ	ETF	592.98	596.47	591.33	592.72	10203288.0
2026-03-09 10:00:00	QQQ	ETF	592.71	597.88	591.56	597.05	13612712.0
2026-03-09 11:00:00	QQQ	ETF	597.03	599.67	597.03	599.31	7763406.0
2026-03-09 12:00:00	QQQ	ETF	599.31	601.85	599.04	600.88	6943136.0
2026-03-09 13:00:00	QQQ	ETF	600.89	600.97	597.64	598.48	7764645.0
2026-03-09 14:00:00	QQQ	ETF	598.5	600.84	598.45	599.58	7208913.0
2026-03-09 15:00:00	QQQ	ETF	599.59	609.27	599.23	607.755	23093568.0
2026-03-09 16:00:00	QQQ	ETF	607.75	608.53	605.73	606.92	2763538.0
2026-03-09 17:00:00	QQQ	ETF	606.9151	607.1	606.59	606.8	116361.0
2026-03-09 18:00:00	QQQ	ETF	606.85	607.44	604.86	605.65	275706.0
2026-03-09 19:00:00	QQQ	ETF	605.69	606.26	604.5201	605.1	132188.0
2026-03-09 04:00:00	IWM	ETF	245.0	245.44	242.82	245.1	100585.0
2026-03-09 05:00:00	IWM	ETF	245.33	247.85	244.8	246.84	111324.0
2026-03-09 06:00:00	IWM	ETF	246.85	246.98	245.42	245.71	192085.0
2026-03-09 07:00:00	IWM	ETF	245.83	246.7	245.52	246.18	141850.0
2026-03-09 08:00:00	IWM	ETF	245.84	247.58	241.1	246.3952	669641.0
2026-03-09 09:00:00	IWM	ETF	246.55	247.83	245.0	245.64	6919580.0
2026-03-09 10:00:00	IWM	ETF	245.63	247.71	244.39	247.3	6777999.0
2026-03-09 11:00:00	IWM	ETF	247.3	248.75	247.26	247.85	3968592.0
2026-03-09 12:00:00	IWM	ETF	247.88	249.89	247.72	249.455	2999899.0
2026-03-09 13:00:00	IWM	ETF	249.455	249.55	247.68	247.945	2647125.0
2026-03-09 14:00:00	IWM	ETF	247.96	249.89	247.95	249.3	2559676.0
2026-03-09 15:00:00	IWM	ETF	249.31	254.65	249.28	253.61	12523363.0
2026-03-09 16:00:00	IWM	ETF	253.61	254.0	252.41	253.53	1534538.0
2026-03-09 17:00:00	IWM	ETF	253.5	253.86	253.37	253.51	73577.0
2026-03-09 18:00:00	IWM	ETF	253.51	253.65	251.84	252.16	167890.0
2026-03-09 19:00:00	IWM	ETF	252.16	252.3	251.46	251.78	75768.0
2026-03-09 04:00:00	DIA	ETF	470.0	470.0	467.16	468.38	13277.0
2026-03-09 05:00:00	DIA	ETF	468.51	471.88	468.06	470.69	14979.0

> showing 50 of 30,648 rows — these rows as CSV

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