PREVIEW / etf_daily / 2025-03-19

all etf daily files

  file:    by_date/etf_daily/2025/2025-03-19.parquet
  size:    152 KB
  rows:    4,009

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-03-19	SPY	ETF	562.83	570.95	561.63	567.13	71728632.0
2025-03-19	QQQ	ETF	476.81	485.33	474.87	480.89	40430334.0
2025-03-19	IWM	ETF	203.35	207.68	202.9	206.37	30116660.0
2025-03-19	DIA	ETF	417.61	422.493	416.8007	420.42	1731350.0
2025-03-19	GLD	ETF	279.85	281.479	279.06	281.11	8734657.0
2025-03-19	TLT	ETF	90.68	91.22	90.38	91.18	31200383.0
2025-03-19	AAA	ETF	25.06	25.1	25.0001	25.055	17858.0
2025-03-19	AAAU	ETF	29.98	30.16	29.915	30.13	1295003.0
2025-03-19	AADR	ETF	77.68	78.72	77.68	78.72	2443.0
2025-03-19	AAPB	ETF	23.97	24.92	23.84	24.15	125245.0
2025-03-19	AAPD	ETF	17.78	17.82	17.41	17.69	1029065.0
2025-03-19	AAPR	ETF	26.17	26.24	26.13	26.23	10194.0
2025-03-19	AAPU	ETF	26.5	27.61	26.38	26.76	974412.0
2025-03-19	AAPW	ETF	42.8	42.8	42.1852	42.1852	757.0
2025-03-19	AAPX	ETF	22.64	23.5	22.62	22.91	40062.0
2025-03-19	AAPY	ETF	22.72	23.02	22.665	22.7898	3980.0
2025-03-19	AAVM	ETF	24.8	25.08	24.8	25.0	4347.0
2025-03-19	AAXJ	ETF	77.11	77.13	76.565	76.92	256009.0
2025-03-19	ABCS	ETF	27.87	28.08	27.87	28.0276	3575.0
2025-03-19	ABEQ	ETF	33.62	33.7746	33.58	33.7	9619.0
2025-03-19	ABFL	ETF	64.8022	65.0248	64.71	65.0248	15407.0
2025-03-19	ABHY	ETF	19.1104	19.185	19.1104	19.185	522.0
2025-03-19	ABLD	ETF	28.65	28.74	28.56	28.6968	7514.0
2025-03-19	ABLG	ETF	29.29	29.52	29.29	29.52	8201.0
2025-03-19	ABNY	ETF	63.623	64.009	63.2505	64.009	1364.0
2025-03-19	ABOT	ETF	34.744	34.8963	34.744	34.8963	296.0
2025-03-19	ACES	ETF	23.44	23.854	23.44	23.73	55145.0
2025-03-19	ACGR	ETF	52.2958	52.2958	52.2958	52.2958	135.0
2025-03-19	ACIO	ETF	38.74	39.19	38.74	38.95	235728.0
2025-03-19	ACLC	ETF	66.19	66.54	66.1	66.54	7392.0
2025-03-19	ACSI	ETF	58.9184	58.9184	58.9184	58.9184	70.0
2025-03-19	ACT	ETF	33.55	34.06	33.55	33.94	209876.0
2025-03-19	ACTV	ETF	31.28	31.43	31.28	31.43	2839.0
2025-03-19	ACVF	ETF	42.98	43.38	42.98	43.3128	4114.0
2025-03-19	ACWI	ETF	117.96	119.45	117.7	118.73	5355807.0
2025-03-19	ACWV	ETF	115.65	115.92	115.065	115.74	399070.0
2025-03-19	ACWX	ETF	57.2	57.62	57.08	57.43	3710367.0
2025-03-19	ADFI	ETF	8.4899	8.5056	8.47	8.5056	15032.0
2025-03-19	ADIV	ETF	15.88	16.07	15.8613	15.8807	4747.0
2025-03-19	ADME	ETF	44.41	45.04	44.41	44.81	6117.0
2025-03-19	ADPV	ETF	34.42	34.4398	34.33	34.34	13400.0
2025-03-19	ADVE	ETF	33.58	33.58	33.4861	33.4861	101.0
2025-03-19	AESR	ETF	16.51	16.66	16.51	16.64	23077.0
2025-03-19	AETH	ETF	31.34	31.34	31.34	31.34	236.0
2025-03-19	AFIF	ETF	9.2183	9.2183	9.19	9.2	13201.0
2025-03-19	AFIX	ETF	24.94	25.03	24.94	25.03	237.0
2025-03-19	AFK	ETF	17.56	17.699	17.45	17.66	18538.0
2025-03-19	AFLG	ETF	33.7	34.02	33.6	33.88	18582.0
2025-03-19	AFMC	ETF	30.54	31.0199	30.54	30.8423	5578.0
2025-03-19	AFSC	ETF	26.17	26.42	26.17	26.41	400.0

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

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