PREVIEW / etf_daily / 2025-07-08

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-08.parquet
  size:    158 KB
  rows:    4,176

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-08	SPY	ETF	621.35	622.11	619.52	620.34	59014202.0
2025-07-08	QQQ	ETF	553.38	554.01	551.1	552.34	36153258.0
2025-07-08	IWM	ETF	220.58	222.29	220.33	221.25	36161255.0
2025-07-08	DIA	ETF	443.69	444.38	442.05	442.38	3559712.0
2025-07-08	GLD	ETF	306.3	306.445	302.77	304.16	11834143.0
2025-07-08	TLT	ETF	85.57	86.04	85.44	86.03	31406021.0
2025-07-08	AAA	ETF	25.01	25.01	24.87	24.9784	8139.0
2025-07-08	AAAU	ETF	32.85	32.8535	32.4601	32.61	2835498.0
2025-07-08	AADR	ETF	78.75	79.0	78.0	78.9	65483.0
2025-07-08	AAPB	ETF	21.04	21.32	20.74	21.06	240268.0
2025-07-08	AAPD	ETF	17.12	17.2577	17.0252	17.14	387228.0
2025-07-08	AAPR	ETF	27.26	27.275	27.26	27.275	436.0
2025-07-08	AAPU	ETF	22.93	23.215	22.57	22.91	2704865.0
2025-07-08	AAPW	ETF	36.46	36.74	36.27	36.67	12087.0
2025-07-08	AAPX	ETF	19.78	20.035	19.53	19.77	103709.0
2025-07-08	AAPY	ETF	21.75	21.96	21.75	21.9304	1162.0
2025-07-08	AAVM	ETF	26.945	26.945	26.87	26.9099	2776.0
2025-07-08	AAXJ	ETF	82.67	82.705	82.44	82.61	372681.0
2025-07-08	ABCS	ETF	29.109	29.23	29.109	29.1705	1858.0
2025-07-08	ABEQ	ETF	34.32	34.33	34.24	34.29	10233.0
2025-07-08	ABFL	ETF	71.07	71.3	70.605	70.72	43599.0
2025-07-08	ABLD	ETF	28.945	29.08	28.945	28.9959	2388.0
2025-07-08	ABLG	ETF	31.0776	31.0776	31.0776	31.0776	252.0
2025-07-08	ABNY	ETF	59.0	59.35	59.0	59.004	465.0
2025-07-08	ABOT	ETF	38.8946	38.8946	38.8946	38.8946	54.0
2025-07-08	ABXB	ETF	19.475	19.475	19.4705	19.4705	164.0
2025-07-08	ACES	ETF	26.95	27.18	26.87	27.04	69943.0
2025-07-08	ACGR	ETF	59.7922	59.7922	59.7922	59.7922	7.0
2025-07-08	ACIO	ETF	41.43	41.5	41.37	41.39	160799.0
2025-07-08	ACLC	ETF	72.635	72.66	72.47	72.47	4155.0
2025-07-08	ACSI	ETF	63.2933	63.2933	63.2933	63.2933	62.0
2025-07-08	ACTV	ETF	31.82	31.9501	31.82	31.9307	2256.0
2025-07-08	ACVF	ETF	47.53	47.56	47.4376	47.4664	5049.0
2025-07-08	ACWI	ETF	128.81	129.135	128.605	128.88	1526634.0
2025-07-08	ACWV	ETF	118.15	118.15	117.745	117.87	286144.0
2025-07-08	ACWX	ETF	60.7	60.98	60.65	60.9	824912.0
2025-07-08	ADBG	ETF	13.18	13.71	13.12	13.44	57901.0
2025-07-08	ADFI	ETF	8.4759	8.52	8.4442	8.4665	8893.0
2025-07-08	ADIV	ETF	17.62	17.67	17.24	17.6	6672.0
2025-07-08	ADME	ETF	48.24	48.24	48.04	48.0959	5633.0
2025-07-08	ADPV	ETF	37.1	37.3	36.73	36.8548	11961.0
2025-07-08	ADVE	ETF	35.71	35.7243	35.71	35.7243	337.0
2025-07-08	AESR	ETF	19.02	19.0868	19.02	19.0538	11765.0
2025-07-08	AETH	ETF	35.2	35.6213	35.16	35.6213	598.0
2025-07-08	AFIF	ETF	9.31	9.32	9.3	9.3	11712.0
2025-07-08	AFIX	ETF	24.775	24.7968	24.775	24.7968	220.0
2025-07-08	AFK	ETF	20.6	20.64	20.4145	20.5	12195.0
2025-07-08	AFLG	ETF	36.53	36.53	36.35	36.4	58358.0
2025-07-08	AFMC	ETF	32.6	32.67	32.48	32.51	154533.0
2025-07-08	AFSC	ETF	29.23	29.23	28.9	29.01	3344.0

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

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