PREVIEW / etf_daily / 2025-08-20

all etf daily files

  file:    by_date/etf_daily/2025/2025-08-20.parquet
  size:    163 KB
  rows:    4,246

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-08-20	SPY	ETF	639.4	639.66	632.95	638.11	88876832.0
2025-08-20	QQQ	ETF	568.33	568.45	558.84	565.9	76781087.0
2025-08-20	IWM	ETF	225.93	226.375	223.69	225.41	29183795.0
2025-08-20	DIA	ETF	449.79	450.521	447.67	449.36	4719071.0
2025-08-20	GLD	ETF	307.54	308.47	307.4	308.36	6513514.0
2025-08-20	TLT	ETF	86.59	86.965	86.56	86.84	25905369.0
2025-08-20	AAA	ETF	25.0	25.0413	24.95	25.0118	2653.0
2025-08-20	AAAU	ETF	32.98	33.08	32.9745	33.07	1118639.0
2025-08-20	AADR	ETF	81.23	81.86	81.23	81.705	1388.0
2025-08-20	AAPB	ETF	24.86	24.89	23.981	24.02	325379.0
2025-08-20	AAPD	ETF	15.65	15.93	15.62	15.91	902838.0
2025-08-20	AAPR	ETF	27.56	27.5771	27.56	27.5771	975.0
2025-08-20	AAPU	ETF	27.03	27.15	26.05	26.09	2727795.0
2025-08-20	AAPW	ETF	38.01	38.01	37.06	37.1	24642.0
2025-08-20	AAPX	ETF	23.29	23.36	22.48	22.49	136167.0
2025-08-20	AAPY	ETF	22.73	22.74	22.485	22.4989	10487.0
2025-08-20	AAVM	ETF	27.62	27.62	27.62	27.62	68.0
2025-08-20	AAXJ	ETF	85.65	85.75	85.17	85.65	435223.0
2025-08-20	ABCS	ETF	29.82	29.82	29.7499	29.7813	2401.0
2025-08-20	ABEQ	ETF	35.08	35.1	35.02	35.0788	8331.0
2025-08-20	ABFL	ETF	68.2383	68.7627	68.2383	68.705	12136.0
2025-08-20	ABLD	ETF	28.65	28.66	28.59	28.6231	5447.0
2025-08-20	ABLG	ETF	29.88	29.88	29.8656	29.8656	4161.0
2025-08-20	ABNY	ETF	53.05	53.05	52.45	52.9	2561.0
2025-08-20	ABOT	ETF	38.1514	38.1514	38.1514	38.1514	14.0
2025-08-20	ABXB	ETF	19.6465	19.6465	19.6465	19.6465	6.0
2025-08-20	ACES	ETF	28.79	28.79	28.38	28.5475	20171.0
2025-08-20	ACGR	ETF	61.753	61.753	61.753	61.753	57.0
2025-08-20	ACIO	ETF	42.24	42.305	42.03	42.219	214860.0
2025-08-20	ACLC	ETF	73.735	74.39	73.6601	74.39	5135.0
2025-08-20	ACSI	ETF	65.41	65.41	65.41	65.41	164.0
2025-08-20	ACTV	ETF	32.7	32.7	32.405	32.4963	1540.0
2025-08-20	ACVF	ETF	48.11	48.21	47.9099	48.1734	4052.0
2025-08-20	ACWI	ETF	132.67	132.81	131.73	132.55	5554879.0
2025-08-20	ACWV	ETF	120.17	120.92	120.17	120.57	73705.0
2025-08-20	ACWX	ETF	62.88	62.96	62.7	62.9	597098.0
2025-08-20	ADBG	ETF	11.74	11.78	11.2	11.2117	176999.0
2025-08-20	ADFI	ETF	8.5214	8.5214	8.4646	8.51	15792.0
2025-08-20	ADIV	ETF	18.12	18.18	18.12	18.18	4292.0
2025-08-20	ADME	ETF	48.97	49.26	48.96	49.235	6612.0
2025-08-20	ADPV	ETF	39.0	39.25	38.445	39.25	25367.0
2025-08-20	ADVE	ETF	36.8299	36.8636	36.8299	36.8636	113.0
2025-08-20	AESR	ETF	19.44	19.5	19.28	19.4846	35179.0
2025-08-20	AETH	ETF	50.78	53.2934	50.47	53.2934	13126.0
2025-08-20	AFIF	ETF	9.36	9.39	9.35	9.365	517605.0
2025-08-20	AFIX	ETF	25.025	25.025	25.025	25.025	120.0
2025-08-20	AFK	ETF	21.5	21.525	21.2723	21.5096	23342.0
2025-08-20	AFLG	ETF	37.315	37.345	37.1	37.3	39545.0
2025-08-20	AFMC	ETF	32.86	32.955	32.76	32.8951	18377.0
2025-08-20	AFSC	ETF	29.03	29.0923	29.03	29.0923	106.0

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

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