PREVIEW / etf_daily / 2025-05-20

all etf daily files

  file:    by_date/etf_daily/2025/2025-05-20.parquet
  size:    155 KB
  rows:    4,102

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-05-20	SPY	ETF	593.09	594.05	589.6	592.85	60511811.0
2025-05-20	QQQ	ETF	519.47	520.93	516.66	520.27	42517561.0
2025-05-20	IWM	ETF	208.66	209.755	207.96	209.08	22356617.0
2025-05-20	DIA	ETF	427.4	428.2	425.03	426.97	1970074.0
2025-05-20	GLD	ETF	298.35	303.6825	298.3	303.58	12894342.0
2025-05-20	TLT	ETF	85.425	85.6	85.06	85.43	35455436.0
2025-05-20	AAA	ETF	25.01	25.012	24.88	24.95	4091.0
2025-05-20	AAAU	ETF	32.01	32.545	31.975	32.54	2405514.0
2025-05-20	AADR	ETF	80.95	80.95	79.885	80.28	2491.0
2025-05-20	AAPB	ETF	21.0	21.1062	20.47	20.85	144624.0
2025-05-20	AAPD	ETF	17.36	17.5901	17.32	17.45	419675.0
2025-05-20	AAPR	ETF	26.75	26.7675	26.75	26.7675	296.0
2025-05-20	AAPU	ETF	23.0	23.13	22.37	22.78	2084388.0
2025-05-20	AAPW	ETF	37.86	37.945	37.5	37.6843	6141.0
2025-05-20	AAPX	ETF	19.82	19.9202	19.3	19.63	157016.0
2025-05-20	AAPY	ETF	22.0232	22.12	21.9	21.975	3930.0
2025-05-20	AAVM	ETF	26.08	26.097	26.08	26.097	488.0
2025-05-20	AAXJ	ETF	78.57	78.625	78.36	78.61	376944.0
2025-05-20	ABCS	ETF	28.66	28.66	28.5217	28.5217	2380.0
2025-05-20	ABEQ	ETF	34.11	34.135	34.0801	34.1058	4136.0
2025-05-20	ABFL	ETF	69.26	69.28	68.73	69.05	14229.0
2025-05-20	ABHY	ETF	19.41	19.4107	19.41	19.4107	246.0
2025-05-20	ABLD	ETF	28.58	28.6	28.45	28.49	6857.0
2025-05-20	ABLG	ETF	30.6501	30.78	30.6501	30.78	958.0
2025-05-20	ABNY	ETF	62.8	62.8	61.21	61.95	2695.0
2025-05-20	ABOT	ETF	37.33	37.36	37.165	37.3491	2869.0
2025-05-20	ACES	ETF	25.93	26.44	25.93	26.16	65421.0
2025-05-20	ACGR	ETF	56.65	56.65	56.6363	56.6363	131.0
2025-05-20	ACIO	ETF	40.34	40.41	40.21	40.31	112983.0
2025-05-20	ACLC	ETF	69.55	69.69	69.24	69.65	11907.0
2025-05-20	ACSI	ETF	61.9313	61.9313	61.9313	61.9313	69.0
2025-05-20	ACT	ETF	36.38	37.065	36.32	36.78	310346.0
2025-05-20	ACTV	ETF	30.8	30.86	30.71	30.7979	4384.0
2025-05-20	ACVF	ETF	45.61	45.61	45.35	45.5233	3117.0
2025-05-20	ACVT	ETF	25.7855	25.7855	25.77	25.77	460.0
2025-05-20	ACWI	ETF	124.16	124.39	123.71	124.29	1078710.0
2025-05-20	ACWV	ETF	118.91	119.11	118.79	119.02	106583.0
2025-05-20	ACWX	ETF	59.46	59.64	59.39	59.63	643279.0
2025-05-20	ADBG	ETF	16.57	16.57	16.2851	16.48	5768.0
2025-05-20	ADFI	ETF	8.39	8.4	8.35	8.4	14140.0
2025-05-20	ADIV	ETF	16.39	16.42	16.39	16.42	4216.0
2025-05-20	ADME	ETF	46.495	46.495	46.33	46.4575	3423.0
2025-05-20	ADPV	ETF	34.6	34.91	34.6	34.735	23302.0
2025-05-20	ADVE	ETF	34.26	34.26	34.2299	34.2564	1758.0
2025-05-20	AESR	ETF	18.0465	18.0739	17.94	18.0215	15728.0
2025-05-20	AETH	ETF	37.68	38.1524	37.68	38.1524	1914.0
2025-05-20	AFIF	ETF	9.22	9.24	9.22	9.225	5092.0
2025-05-20	AFIX	ETF	24.66	24.66	24.655	24.655	10638.0
2025-05-20	AFK	ETF	18.51	18.74	18.02	18.7149	9795.0
2025-05-20	AFLG	ETF	35.43	35.43	35.22	35.35	159579.0

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

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