PREVIEW / etf_daily / 2025-07-07

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-07.parquet
  size:    157 KB
  rows:    4,184

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-07-07	SPY	ETF	623.36	624.03	617.87	620.68	74790667.0
2025-07-07	QQQ	ETF	553.52	554.34	549.58	552.03	45349323.0
2025-07-07	IWM	ETF	221.57	222.82	218.41	219.73	41880838.0
2025-07-07	DIA	ETF	447.38	447.84	441.56	444.0	3656041.0
2025-07-07	GLD	ETF	305.07	307.705	304.53	307.37	7346336.0
2025-07-07	TLT	ETF	86.54	86.56	85.92	86.14	38309647.0
2025-07-07	AAA	ETF	25.09	25.09	25.0	25.01	2039.0
2025-07-07	AAAU	ETF	32.71	32.99	32.655	32.96	2454160.0
2025-07-07	AADR	ETF	78.9378	78.9378	77.52	78.18	8090.0
2025-07-07	AAPB	ETF	21.58	22.2547	20.8101	21.05	319336.0
2025-07-07	AAPD	ETF	16.9	17.2211	16.65	17.13	718232.0
2025-07-07	AAPR	ETF	27.25	27.2578	27.245	27.2578	986.0
2025-07-07	AAPU	ETF	23.51	24.29	22.65	22.9	4864032.0
2025-07-07	AAPW	ETF	37.51	37.8	36.47	36.67	15575.0
2025-07-07	AAPX	ETF	20.29	20.95	19.59	19.77	316650.0
2025-07-07	AAPY	ETF	22.15	22.16	21.81	21.94	1794.0
2025-07-07	AAVM	ETF	26.7201	26.84	26.7201	26.84	493.0
2025-07-07	AAXJ	ETF	82.3	82.65	81.9	82.05	2151957.0
2025-07-07	ABCS	ETF	29.3	29.3	29.0369	29.0369	3188.0
2025-07-07	ABEQ	ETF	34.5	34.56	34.33	34.4077	47029.0
2025-07-07	ABFL	ETF	70.78	71.15	70.78	71.12	15480.0
2025-07-07	ABLD	ETF	28.82	28.86	28.82	28.85	7120.0
2025-07-07	ABLG	ETF	30.86	30.95	30.86	30.929	951.0
2025-07-07	ABNY	ETF	58.35	58.95	58.25	58.75	9367.0
2025-07-07	ABOT	ETF	39.12	39.12	39.0078	39.0078	144.0
2025-07-07	ABXB	ETF	19.42	19.51	19.42	19.51	161.0
2025-07-07	ACES	ETF	27.33	27.52	27.03	27.19	93616.0
2025-07-07	ACGR	ETF	59.8733	59.8733	59.8733	59.8733	11.0
2025-07-07	ACIO	ETF	41.56	41.6482	41.35	41.44	105907.0
2025-07-07	ACLC	ETF	73.0186	73.0186	72.42	72.6511	2880.0
2025-07-07	ACSI	ETF	63.4319	63.4319	63.4319	63.4319	91.0
2025-07-07	ACTV	ETF	31.76	31.84	31.63	31.8382	2356.0
2025-07-07	ACVF	ETF	47.67	47.67	47.29	47.4098	5883.0
2025-07-07	ACVT	ETF	26.28	26.28	26.164	26.164	3251.0
2025-07-07	ACWI	ETF	129.28	129.37	128.19	128.66	2432008.0
2025-07-07	ACWV	ETF	118.58	118.71	117.91	118.25	202747.0
2025-07-07	ACWX	ETF	60.94	60.94	60.39	60.56	1798753.0
2025-07-07	ADBG	ETF	13.25	13.3796	12.99	13.1	33750.0
2025-07-07	ADFI	ETF	8.46	8.47	8.42	8.4533	20533.0
2025-07-07	ADIV	ETF	17.64	17.695	17.0	17.55	9228.0
2025-07-07	ADME	ETF	48.46	48.46	48.09	48.23	13388.0
2025-07-07	ADPV	ETF	37.0	37.003	36.745	36.96	5543.0
2025-07-07	ADVE	ETF	35.6773	35.6773	35.4884	35.4884	294.0
2025-07-07	AESR	ETF	19.1449	19.17	19.07	19.1209	29580.0
2025-07-07	AETH	ETF	34.975	34.975	34.5	34.7513	1204.0
2025-07-07	AFIF	ETF	9.29	9.32	9.29	9.3	57419.0
2025-07-07	AFIX	ETF	24.82	24.82	24.8136	24.8147	305.0
2025-07-07	AFK	ETF	20.66	20.7	20.5	20.64	35489.0
2025-07-07	AFLG	ETF	36.6	36.6595	36.2838	36.46	50609.0
2025-07-07	AFMC	ETF	32.75	32.889	32.351	32.49	23637.0

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

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