PREVIEW / etf_daily / 2025-07-02

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-02.parquet
  size:    159 KB
  rows:    4,201

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-02	SPY	ETF	617.24	620.49	616.61	620.45	66499124.0
2025-07-02	QQQ	ETF	546.16	551.0	546.12	550.8	36538281.0
2025-07-02	IWM	ETF	218.37	221.095	217.36	221.03	35714484.0
2025-07-02	DIA	ETF	444.68	445.4	443.37	444.71	3140343.0
2025-07-02	GLD	ETF	308.035	309.395	306.96	309.25	8305949.0
2025-07-02	TLT	ETF	87.19	87.59	87.1	87.58	39378247.0
2025-07-02	AAA	ETF	25.02	25.02	24.94	24.975	9731.0
2025-07-02	AAAU	ETF	33.03	33.1653	32.9101	33.15	1932157.0
2025-07-02	AADR	ETF	78.48	78.5	77.475	77.745	1918.0
2025-07-02	AAPB	ETF	20.89	21.7403	20.75	21.55	439938.0
2025-07-02	AAPD	ETF	17.2	17.27	16.8516	16.93	1728662.0
2025-07-02	AAPR	ETF	27.28	27.28	27.25	27.2698	38012.0
2025-07-02	AAPU	ETF	22.78	23.688	22.58	23.47	8015261.0
2025-07-02	AAPW	ETF	36.9583	37.455	36.9583	37.301	12288.0
2025-07-02	AAPX	ETF	19.63	20.46	19.52	20.3	276809.0
2025-07-02	AAPY	ETF	21.73	22.12	21.73	22.0982	6858.0
2025-07-02	AAVM	ETF	26.82	27.03	26.82	26.95	2073.0
2025-07-02	AAXJ	ETF	82.39	83.07	82.39	83.06	702992.0
2025-07-02	ABCS	ETF	29.02	29.2399	28.9905	29.21	3289.0
2025-07-02	ABEQ	ETF	34.4014	34.47	34.2914	34.4607	2575.0
2025-07-02	ABFL	ETF	70.4033	70.4033	70.1716	70.32	26096.0
2025-07-02	ABLD	ETF	28.87	29.0809	28.87	29.0809	7911.0
2025-07-02	ABLG	ETF	30.946	30.946	30.946	30.946	86.0
2025-07-02	ABNY	ETF	58.25	58.7185	58.25	58.654	1975.0
2025-07-02	ABOT	ETF	38.5192	38.588	38.48	38.588	608.0
2025-07-02	ABXB	ETF	19.55	19.5792	19.55	19.5792	213.0
2025-07-02	ACES	ETF	26.21	26.8602	26.21	26.59	30646.0
2025-07-02	ACGR	ETF	59.15	59.6459	59.15	59.6459	2211.0
2025-07-02	ACIO	ETF	41.315	41.51	41.315	41.44	163057.0
2025-07-02	ACLC	ETF	72.49	72.6369	72.41	72.6369	891.0
2025-07-02	ACSI	ETF	63.5829	63.5829	63.5829	63.5829	68.0
2025-07-02	ACT	ETF	37.67	37.775	36.98	37.54	412951.0
2025-07-02	ACTV	ETF	31.8	31.9236	31.665	31.9236	2838.0
2025-07-02	ACVF	ETF	47.25	47.3093	47.0682	47.3093	3203.0
2025-07-02	ACVT	ETF	26.12	26.13	26.12	26.125	3125.0
2025-07-02	ACWI	ETF	128.42	129.06	128.19	129.05	2118565.0
2025-07-02	ACWV	ETF	118.87	118.95	118.0	118.34	97723.0
2025-07-02	ACWX	ETF	60.77	61.15	60.66	61.09	745573.0
2025-07-02	ADBG	ETF	13.75	13.75	12.8	13.24	170841.0
2025-07-02	ADFI	ETF	8.493	8.51	8.4743	8.5078	3391.0
2025-07-02	ADIV	ETF	17.6484	17.79	17.6484	17.74	2436.0
2025-07-02	ADME	ETF	48.03	48.24	48.03	48.24	8867.0
2025-07-02	ADPV	ETF	36.41	36.7233	36.41	36.7233	13061.0
2025-07-02	ADVE	ETF	35.939	35.939	35.939	35.939	60.0
2025-07-02	AESR	ETF	19.05	19.0502	18.9834	19.0502	7055.0
2025-07-02	AETH	ETF	35.65	35.65	35.65	35.65	130.0
2025-07-02	AFIF	ETF	9.29	9.35	9.29	9.32	12542.0
2025-07-02	AFIX	ETF	24.92	25.16	24.9199	24.97	38520.0
2025-07-02	AFK	ETF	20.3	20.56	20.3	20.56	26933.0
2025-07-02	AFLG	ETF	36.33	36.38	36.25	36.38	37236.0

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

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