PREVIEW / etf_daily / 2025-03-31

all etf daily files

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

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-31	SPY	ETF	549.83	560.7112	546.87	559.39	95153677.0
2025-03-31	QQQ	ETF	461.92	469.86	457.33	468.92	53000303.0
2025-03-31	IWM	ETF	197.48	200.64	195.49	199.49	32192094.0
2025-03-31	DIA	ETF	412.2	421.36	411.4366	419.88	2977300.0
2025-03-31	GLD	ETF	287.53	288.39	285.85	288.14	13691469.0
2025-03-31	TLT	ETF	91.23	91.335	90.36	91.03	38776771.0
2025-03-31	AAA	ETF	24.86	24.875	24.83	24.87	16666.0
2025-03-31	AAAU	ETF	30.82	30.9	30.64	30.88	2067669.0
2025-03-31	AADR	ETF	73.7	74.4	72.9649	74.4	29744.0
2025-03-31	AAPB	ETF	24.37	26.03	24.295	25.6	112686.0
2025-03-31	AAPD	ETF	17.445	17.51	16.89	17.06	2311775.0
2025-03-31	AAPR	ETF	26.045	26.1715	26.045	26.1685	5220.0
2025-03-31	AAPU	ETF	26.75	28.58	26.65	28.06	784595.0
2025-03-31	AAPW	ETF	42.79	43.3904	41.95	43.3904	3137.0
2025-03-31	AAPX	ETF	23.09	24.66	23.0	24.19	48460.0
2025-03-31	AAPY	ETF	22.81	23.46	22.67	23.42	11002.0
2025-03-31	AAVM	ETF	24.1	24.5426	24.1	24.5426	339.0
2025-03-31	AAXJ	ETF	73.34	74.09	73.05	74.0	294122.0
2025-03-31	ABCS	ETF	27.36	27.73	27.36	27.6693	3406.0
2025-03-31	ABEQ	ETF	33.855	34.1145	33.855	34.08	15603.0
2025-03-31	ABFL	ETF	63.07	64.029	62.51	63.91	151172.0
2025-03-31	ABHY	ETF	18.7	19.0153	18.7	19.0153	350.0
2025-03-31	ABLD	ETF	28.3103	28.51	28.26	28.4683	22486.0
2025-03-31	ABLG	ETF	28.11	28.3569	28.03	28.3569	12112.0
2025-03-31	ABNY	ETF	62.1	62.2	60.5	62.115	5608.0
2025-03-31	ABOT	ETF	33.37	34.0201	33.37	34.0201	1041.0
2025-03-31	ACES	ETF	22.66	23.04	22.31	22.92	43463.0
2025-03-31	ACGR	ETF	50.9517	50.9517	50.9517	50.9517	160.0
2025-03-31	ACIO	ETF	38.25	38.72	38.165	38.69	137503.0
2025-03-31	ACLC	ETF	64.52	65.51	64.27	65.47	7465.0
2025-03-31	ACSI	ETF	59.456	59.456	59.456	59.456	41.0
2025-03-31	ACT	ETF	34.14	34.88	34.05	34.75	222328.0
2025-03-31	ACTV	ETF	30.05	30.4904	30.04	30.365	11109.0
2025-03-31	ACVF	ETF	42.16	42.8999	41.9257	42.82	13399.0
2025-03-31	ACWI	ETF	114.98	116.65	114.26	116.39	2622021.0
2025-03-31	ACWV	ETF	115.09	116.68	115.09	116.37	225368.0
2025-03-31	ACWX	ETF	55.1	55.555	54.84	55.45	1129390.0
2025-03-31	ADBG	ETF	14.012	14.469	13.97	14.469	848.0
2025-03-31	ADFI	ETF	8.502	8.51	8.47	8.505	8119.0
2025-03-31	ADIV	ETF	15.3	15.385	15.27	15.3819	6704.0
2025-03-31	ADME	ETF	43.665	44.46	43.665	44.405	10898.0
2025-03-31	ADPV	ETF	34.37	34.41	34.36	34.39	4781.0
2025-03-31	ADVE	ETF	32.208	32.4285	32.208	32.4285	312.0
2025-03-31	AESR	ETF	16.19	16.529	16.19	16.49	13739.0
2025-03-31	AETH	ETF	27.38	27.39	27.38	27.39	392.0
2025-03-31	AFIF	ETF	9.2108	9.24	9.19	9.21	21958.0
2025-03-31	AFIX	ETF	24.99	24.99	24.9727	24.9727	442.0
2025-03-31	AFK	ETF	17.38	17.54	17.09	17.39	19822.0
2025-03-31	AFLG	ETF	33.03	33.77	33.02	33.69	109337.0
2025-03-31	AFMC	ETF	29.7418	30.6	29.7418	30.46	18403.0

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

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