PREVIEW / etf_daily / 2025-09-04

all etf daily files

  file:    by_date/etf_daily/2025/2025-09-04.parquet
  size:    163 KB
  rows:    4,256

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-09-04	SPY	ETF	644.42	649.15	643.51	649.12	65194865.0
2025-09-04	QQQ	ETF	570.74	575.6	569.025	575.23	47526280.0
2025-09-04	IWM	ETF	234.23	236.6665	233.58	236.59	30295337.0
2025-09-04	DIA	ETF	453.55	457.26	452.56	457.05	4520511.0
2025-09-04	GLD	ETF	327.03	327.56	325.35	326.69	11684287.0
2025-09-04	TLT	ETF	87.02	87.24	86.58	87.23	40484987.0
2025-09-04	AAA	ETF	25.0272	25.05	24.965	25.025	28926.0
2025-09-04	AAAU	ETF	35.13	35.13	34.91	35.045	1573171.0
2025-09-04	AADR	ETF	82.45	82.69	82.07	82.415	2345.0
2025-09-04	AAPB	ETF	26.62	26.91	26.27	26.89	282477.0
2025-09-04	AAPD	ETF	15.07	15.2	15.0086	15.01	1741142.0
2025-09-04	AAPR	ETF	27.69	27.7249	27.69	27.7249	6347.0
2025-09-04	AAPU	ETF	28.97	29.26	28.5	29.22	1925821.0
2025-09-04	AAPW	ETF	38.65	39.47	38.65	39.29	26308.0
2025-09-04	AAPX	ETF	24.87	25.2	24.56	25.16	154828.0
2025-09-04	AAPY	ETF	23.7099	23.7916	23.7	23.7916	1383.0
2025-09-04	AAVM	ETF	27.8066	27.9445	27.8066	27.9445	1250.0
2025-09-04	AAXJ	ETF	85.72	85.85	85.38	85.82	569873.0
2025-09-04	ABCS	ETF	30.26	30.535	30.25	30.535	3785.0
2025-09-04	ABEQ	ETF	35.57	35.79	35.57	35.79	6815.0
2025-09-04	ABFL	ETF	70.14	70.44	69.7707	70.44	13302.0
2025-09-04	ABLD	ETF	28.71	28.98	28.71	28.98	7737.0
2025-09-04	ABLG	ETF	29.89	30.0555	29.89	30.0555	213.0
2025-09-04	ABNY	ETF	51.25	51.3	50.45	51.3	1522.0
2025-09-04	ABOT	ETF	38.96	39.0232	38.96	39.0232	241.0
2025-09-04	ABXB	ETF	19.7662	19.7662	19.7662	19.7662	10.0
2025-09-04	ACES	ETF	28.97	28.98	28.7	28.9568	16524.0
2025-09-04	ACGR	ETF	63.12	63.12	63.115	63.115	167.0
2025-09-04	ACIO	ETF	42.36	42.62	42.35	42.58	119076.0
2025-09-04	ACLC	ETF	74.96	75.66	74.96	75.66	4112.0
2025-09-04	ACSI	ETF	66.7577	66.7577	66.7577	66.7577	179.0
2025-09-04	ACTV	ETF	32.72	33.0593	32.72	33.0593	3713.0
2025-09-04	ACVF	ETF	48.26	48.365	48.14	48.365	5253.0
2025-09-04	ACWI	ETF	133.0	133.99	132.94	133.95	2395317.0
2025-09-04	ACWV	ETF	119.4	119.6	119.24	119.58	63289.0
2025-09-04	ACWX	ETF	62.49	62.74	62.3962	62.73	439269.0
2025-09-04	ADBG	ETF	10.4	10.56	9.8	10.56	403334.0
2025-09-04	ADFI	ETF	8.5666	8.62	8.5432	8.62	27414.0
2025-09-04	ADIV	ETF	17.8258	17.98	17.8258	17.9607	5133.0
2025-09-04	ADME	ETF	49.4397	49.83	49.4397	49.83	12607.0
2025-09-04	ADPV	ETF	40.28	40.28	39.98	40.06	2023.0
2025-09-04	ADVE	ETF	36.57	36.704	36.57	36.704	196.0
2025-09-04	AESR	ETF	19.84	19.9434	19.79	19.9434	21826.0
2025-09-04	AETH	ETF	52.167	52.167	51.8701	52.025	1008.0
2025-09-04	AFIF	ETF	9.39	9.405	9.37	9.401	62007.0
2025-09-04	AFIX	ETF	25.12	25.178	25.12	25.178	847.0
2025-09-04	AFK	ETF	22.67	22.6815	22.31	22.33	82488.0
2025-09-04	AFLG	ETF	37.67	37.96	37.67	37.95	25222.0
2025-09-04	AFMC	ETF	33.63	33.9717	33.63	33.9717	7874.0
2025-09-04	AFSC	ETF	30.27	30.34	30.27	30.34	237.0

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

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