PREVIEW / etf_daily / 2025-07-25

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-25.parquet
  size:    161 KB
  rows:    4,213

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-25	SPY	ETF	635.09	637.5799	634.84	637.1	56909727.0
2025-07-25	QQQ	ETF	564.93	567.695	564.27	566.37	30630813.0
2025-07-25	IWM	ETF	224.42	224.595	222.54	224.38	24504989.0
2025-07-25	DIA	ETF	447.53	449.41	446.4102	449.02	3696324.0
2025-07-25	GLD	ETF	307.82	308.31	306.2	307.4	9374046.0
2025-07-25	TLT	ETF	85.8	86.44	85.72	86.43	27194483.0
2025-07-25	AAA	ETF	24.97	25.02	24.9509	25.02	3131.0
2025-07-25	AAAU	ETF	33.0	33.06	32.835	32.96	3029265.0
2025-07-25	AADR	ETF	78.85	79.5024	78.85	79.265	2214.0
2025-07-25	AAPB	ETF	21.87	22.0	21.622	21.74	221111.0
2025-07-25	AAPD	ETF	16.8	16.915	16.7781	16.88	1036655.0
2025-07-25	AAPR	ETF	27.48	27.495	27.48	27.49	595.0
2025-07-25	AAPU	ETF	23.82	23.94	23.53	23.65	2345044.0
2025-07-25	AAPW	ETF	36.4	36.4	36.055	36.36	65377.0
2025-07-25	AAPX	ETF	20.54	20.64	20.349	20.43	90621.0
2025-07-25	AAPY	ETF	22.01	22.0225	22.0	22.0225	1317.0
2025-07-25	AAVM	ETF	27.151	27.18	27.13	27.1684	948.0
2025-07-25	AAXJ	ETF	85.25	85.5	85.0	85.48	326924.0
2025-07-25	ABCS	ETF	29.26	29.4793	29.205	29.4793	4552.0
2025-07-25	ABEQ	ETF	34.5999	34.739	34.56	34.7309	14315.0
2025-07-25	ABFL	ETF	71.0899	71.34	71.0899	71.1737	11435.0
2025-07-25	ABLD	ETF	29.15	29.16	29.01	29.14	12561.0
2025-07-25	ABLG	ETF	30.6321	30.6684	30.6314	30.6684	256.0
2025-07-25	ABNY	ETF	59.25	59.6	59.0	59.1755	3544.0
2025-07-25	ABOT	ETF	39.4	39.4	39.4	39.4	303.0
2025-07-25	ABXB	ETF	19.5767	19.5767	19.5767	19.5767	42.0
2025-07-25	ACES	ETF	28.74	28.7553	28.61	28.7553	2265.0
2025-07-25	ACGR	ETF	61.77	61.8166	61.765	61.8166	489.0
2025-07-25	ACIO	ETF	41.91	42.08	41.91	42.06	97936.0
2025-07-25	ACLC	ETF	73.88	74.08	73.88	74.0522	548.0
2025-07-25	ACSI	ETF	64.42	64.4488	64.42	64.4301	1167.0
2025-07-25	ACTV	ETF	32.59	32.7497	32.59	32.7497	89364.0
2025-07-25	ACVF	ETF	48.08	48.34	48.08	48.3084	3918.0
2025-07-25	ACWI	ETF	131.43	131.96	131.345	131.88	1487005.0
2025-07-25	ACWV	ETF	118.45	118.72	118.35	118.6	80137.0
2025-07-25	ACWX	ETF	61.88	62.11	61.72	62.09	837272.0
2025-07-25	ADBG	ETF	12.58	12.62	12.451	12.5252	25181.0
2025-07-25	ADFI	ETF	8.31	8.53	8.31	8.475	19261.0
2025-07-25	ADIV	ETF	18.1	18.14	18.1	18.115	774.0
2025-07-25	ADME	ETF	48.965	49.18	48.965	49.1076	6308.0
2025-07-25	ADPV	ETF	40.04	40.1817	39.94	40.1817	4403.0
2025-07-25	ADVE	ETF	36.5036	36.5795	36.5036	36.5795	148.0
2025-07-25	AESR	ETF	19.49	19.538	19.47	19.49	20852.0
2025-07-25	AETH	ETF	50.47	50.47	49.7851	49.7851	1213.0
2025-07-25	AFIF	ETF	9.337	9.337	9.32	9.335	8728.0
2025-07-25	AFIX	ETF	24.82	24.82	24.82	24.82	66.0
2025-07-25	AFK	ETF	21.75	21.79	21.36	21.5693	104760.0
2025-07-25	AFLG	ETF	37.04	37.13	36.98	37.1	45656.0
2025-07-25	AFMC	ETF	32.76	32.76	32.46	32.7269	10782.0
2025-07-25	AFSC	ETF	28.5	28.9817	28.5	28.9817	495.0

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

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