PREVIEW / etf_daily / 2025-09-02

all etf daily files

  file:    by_date/etf_daily/2025/2025-09-02.parquet
  size:    161 KB
  rows:    4,249

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-02	SPY	ETF	637.5	640.49	634.92	640.27	81959037.0
2025-09-02	QQQ	ETF	561.31	565.965	559.535	565.62	65876765.0
2025-09-02	IWM	ETF	231.99	234.4	231.47	233.9	33081918.0
2025-09-02	DIA	ETF	451.99	453.7	450.155	453.61	6006620.0
2025-09-02	GLD	ETF	320.82	325.92	320.24	325.59	21240148.0
2025-09-02	TLT	ETF	85.63	85.84	85.48	85.63	48759989.0
2025-09-02	AAA	ETF	25.0	25.02	24.87	24.965	20733.0
2025-09-02	AAAU	ETF	34.44	34.96	34.3542	34.92	2558943.0
2025-09-02	AADR	ETF	81.7451	82.1283	81.5	81.9754	1985.0
2025-09-02	AAPB	ETF	24.65	24.966	24.14	24.73	284238.0
2025-09-02	AAPD	ETF	15.72	15.86	15.62	15.69	806187.0
2025-09-02	AAPR	ETF	27.59	27.645	27.59	27.645	988.0
2025-09-02	AAPU	ETF	26.8	27.13	26.23	26.86	2824722.0
2025-09-02	AAPW	ETF	37.57	37.5899	36.82	37.13	23752.0
2025-09-02	AAPX	ETF	23.11	23.37	22.6	23.14	238460.0
2025-09-02	AAPY	ETF	23.02	23.04	22.84	22.9656	1991.0
2025-09-02	AAVM	ETF	27.41	27.68	27.41	27.68	2645.0
2025-09-02	AAXJ	ETF	85.4	85.905	85.19	85.85	830275.0
2025-09-02	ABCS	ETF	30.27	30.39	30.26	30.373	2441.0
2025-09-02	ABEQ	ETF	35.42	35.6291	35.42	35.5687	13231.0
2025-09-02	ABFL	ETF	69.42	70.0656	69.42	70.0656	13558.0
2025-09-02	ABLD	ETF	28.87	28.87	28.71	28.82	14050.0
2025-09-02	ABLG	ETF	29.7	29.81	29.645	29.7726	1997.0
2025-09-02	ABNY	ETF	52.25	52.425	51.5	51.9	1822.0
2025-09-02	ABOT	ETF	38.62	38.7405	38.61	38.7405	33738.0
2025-09-02	ABXB	ETF	19.675	19.675	19.675	19.675	9.0
2025-09-02	ACES	ETF	28.77	28.93	28.665	28.88	18344.0
2025-09-02	ACGR	ETF	62.103	62.103	62.103	62.103	37.0
2025-09-02	ACIO	ETF	42.03	42.2299	41.9638	42.18	98363.0
2025-09-02	ACLC	ETF	74.54	74.66	74.01	74.66	4886.0
2025-09-02	ACSI	ETF	65.19	65.617	65.19	65.617	265.0
2025-09-02	ACTV	ETF	32.7037	32.7037	32.7037	32.7037	352.0
2025-09-02	ACVF	ETF	47.98	48.16	47.82	48.16	14758.0
2025-09-02	ACVT	ETF	26.63	26.6864	26.63	26.6864	152.0
2025-09-02	ACWI	ETF	131.93	132.535	131.52	132.5	3193077.0
2025-09-02	ACWV	ETF	119.19	119.5999	119.08	119.41	98788.0
2025-09-02	ACWX	ETF	62.0	62.355	61.885	62.33	1098617.0
2025-09-02	ADBG	ETF	10.98	11.08	10.4	10.6281	255611.0
2025-09-02	ADFI	ETF	8.5	8.5295	8.5	8.525	1878.0
2025-09-02	ADIV	ETF	18.0	18.0	17.92	17.999	10936.0
2025-09-02	ADME	ETF	49.2	49.28	48.92	49.273	11541.0
2025-09-02	ADPV	ETF	40.1	40.5434	39.78	40.5434	6874.0
2025-09-02	ADVE	ETF	36.7932	36.7932	36.7932	36.7932	29.0
2025-09-02	AESR	ETF	19.63	19.68	19.55	19.68	8539.0
2025-09-02	AETH	ETF	52.8334	53.48	52.0	52.1251	11960.0
2025-09-02	AFIF	ETF	9.35	9.39	9.32	9.37	948865.0
2025-09-02	AFIX	ETF	24.99	24.99	24.9852	24.9852	279.0
2025-09-02	AFK	ETF	22.39	22.45	22.1957	22.45	73964.0
2025-09-02	AFLG	ETF	37.17	37.46	37.17	37.44	30458.0
2025-09-02	AFMC	ETF	33.36	33.54	33.285	33.524	16243.0

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

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