PREVIEW / etf_daily / 2025-06-26

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-26.parquet
  size:    159 KB
  rows:    4,188

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2025-06-26	SPY	ETF	608.99	612.31	608.37	611.87	78715233.0
2025-06-26	QQQ	ETF	543.35	546.67	541.52	546.22	43811432.0
2025-06-26	IWM	ETF	212.83	215.545	212.7	215.41	26262847.0
2025-06-26	DIA	ETF	430.82	434.19	430.8	433.93	2442191.0
2025-06-26	GLD	ETF	305.77	307.28	304.855	306.78	6777996.0
2025-06-26	TLT	ETF	87.59	87.95	87.2	87.95	30466034.0
2025-06-26	AAA	ETF	25.0361	25.0569	25.01	25.03	3278.0
2025-06-26	AAAU	ETF	32.81	32.945	32.6925	32.9	2366736.0
2025-06-26	AADR	ETF	77.9462	78.51	77.77	78.19	2470.0
2025-06-26	AAPB	ETF	19.43	19.64	19.07	19.36	266630.0
2025-06-26	AAPD	ETF	17.84	18.018	17.74	17.87	942080.0
2025-06-26	AAPR	ETF	27.1501	27.18	27.1501	27.17	3817.0
2025-06-26	AAPU	ETF	21.19	21.42	20.7714	21.08	6039635.0
2025-06-26	AAPW	ETF	35.26	35.388	34.97	35.289	14693.0
2025-06-26	AAPX	ETF	18.31	18.5	17.95	18.21	122128.0
2025-06-26	AAPY	ETF	21.0	21.09	20.9	21.0568	3412.0
2025-06-26	AAVM	ETF	26.54	26.845	26.54	26.845	978.0
2025-06-26	AAXJ	ETF	82.86	83.07	82.58	82.89	495976.0
2025-06-26	ABCS	ETF	28.54	28.7027	28.52	28.7027	4429.0
2025-06-26	ABEQ	ETF	34.31	34.4153	34.31	34.4119	2741.0
2025-06-26	ABFL	ETF	69.851	69.98	69.8	69.98	11329.0
2025-06-26	ABLD	ETF	28.48	28.7371	28.48	28.7371	3832.0
2025-06-26	ABLG	ETF	31.13	31.1708	31.13	31.1708	401.0
2025-06-26	ABNY	ETF	57.3	57.8	56.15	57.65	5056.0
2025-06-26	ABOT	ETF	38.0	38.1971	37.9	38.1971	935.0
2025-06-26	ABXB	ETF	19.79	19.8083	19.79	19.8083	104.0
2025-06-26	ACES	ETF	25.58	26.075	25.58	26.05	13893.0
2025-06-26	ACGR	ETF	59.02	59.0516	59.02	59.0516	233.0
2025-06-26	ACIO	ETF	40.87	41.21	40.87	41.12	179303.0
2025-06-26	ACLC	ETF	71.34	71.55	71.33	71.518	1655.0
2025-06-26	ACSI	ETF	62.5778	62.5778	62.5778	62.5778	78.0
2025-06-26	ACT	ETF	36.95	37.08	36.69	36.85	340059.0
2025-06-26	ACTV	ETF	31.39	31.4336	31.39	31.4336	2064.0
2025-06-26	ACVF	ETF	46.49	46.7	46.44	46.6556	6076.0
2025-06-26	ACVT	ETF	26.06	26.06	26.06	26.06	144.0
2025-06-26	ACWI	ETF	126.98	127.545	126.8	127.47	3801822.0
2025-06-26	ACWV	ETF	117.3	117.505	117.2	117.42	74310.0
2025-06-26	ACWX	ETF	60.31	60.625	60.3	60.59	838290.0
2025-06-26	ADBG	ETF	14.039	14.039	13.5781	13.74	45040.0
2025-06-26	ADFI	ETF	8.49	8.57	8.4828	8.505	13117.0
2025-06-26	ADIV	ETF	17.7464	17.81	17.7464	17.7687	5377.0
2025-06-26	ADME	ETF	47.58	47.78	47.58	47.78	10620.0
2025-06-26	ADPV	ETF	36.09	36.46	36.085	36.46	18925.0
2025-06-26	ADVE	ETF	35.773	35.773	35.773	35.773	10.0
2025-06-26	AESR	ETF	18.72	18.8379	18.72	18.8177	15486.0
2025-06-26	AETH	ETF	35.54	35.73	35.54	35.635	324.0
2025-06-26	AFIF	ETF	9.29	9.3	9.2801	9.299	6495.0
2025-06-26	AFIX	ETF	24.95	24.965	24.95	24.965	759608.0
2025-06-26	AFK	ETF	19.86	20.249	19.86	20.2134	22203.0
2025-06-26	AFLG	ETF	35.84	35.9	35.76	35.877	27590.0

> showing 50 of 4,188 rows — these rows as CSV

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