PREVIEW / etf_daily / 2025-07-09

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-09.parquet
  size:    158 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-09	SPY	ETF	622.77	624.72	620.9105	624.06	66086855.0
2025-07-09	QQQ	ETF	554.48	557.63	553.1	556.25	43045534.0
2025-07-09	IWM	ETF	222.57	223.69	221.115	223.65	32407425.0
2025-07-09	DIA	ETF	444.39	445.6	442.28	444.52	3249707.0
2025-07-09	GLD	ETF	303.58	305.54	303.23	305.52	10642039.0
2025-07-09	TLT	ETF	86.19	86.93	86.175	86.93	29819746.0
2025-07-09	AAA	ETF	24.9	25.03	24.84	24.96	50362.0
2025-07-09	AAAU	ETF	32.55	32.76	32.5101	32.75	2049236.0
2025-07-09	AADR	ETF	79.5	79.9	79.26	79.5	9231.0
2025-07-09	AAPB	ETF	20.91	21.285	20.49	21.25	225937.0
2025-07-09	AAPD	ETF	17.17	17.36	17.04	17.06	520164.0
2025-07-09	AAPR	ETF	27.2601	27.3159	27.2601	27.3159	1739.0
2025-07-09	AAPU	ETF	22.8	23.185	22.31	23.14	4316228.0
2025-07-09	AAPW	ETF	36.3	36.82	36.0358	36.82	10849.0
2025-07-09	AAPX	ETF	19.68	20.0189	19.2721	19.98	120247.0
2025-07-09	AAPY	ETF	21.94	22.0489	21.67	22.0489	3552.0
2025-07-09	AAVM	ETF	26.95	27.04	26.95	27.03	3914.0
2025-07-09	AAXJ	ETF	82.72	82.72	82.245	82.49	242461.0
2025-07-09	ABCS	ETF	29.14	29.2256	29.115	29.2256	2601.0
2025-07-09	ABEQ	ETF	34.17	34.21	34.12	34.21	4202.0
2025-07-09	ABFL	ETF	70.8699	70.89	70.5124	70.78	19415.0
2025-07-09	ABLD	ETF	29.003	29.1	28.91	29.0752	10649.0
2025-07-09	ABLG	ETF	30.94	31.1104	30.94	31.1104	1239.0
2025-07-09	ABNY	ETF	59.15	59.2505	58.95	59.05	1899.0
2025-07-09	ABOT	ETF	38.78	38.93	38.78	38.93	1508.0
2025-07-09	ABXB	ETF	19.49	19.535	19.49	19.535	738.0
2025-07-09	ACES	ETF	27.08	27.644	27.08	27.57	10895.0
2025-07-09	ACGR	ETF	60.24	60.2911	60.21	60.2911	597.0
2025-07-09	ACIO	ETF	41.52	41.59	41.41	41.57	219903.0
2025-07-09	ACLC	ETF	72.68	72.9291	72.68	72.9291	3113.0
2025-07-09	ACSI	ETF	63.3284	63.3284	63.3284	63.3284	67.0
2025-07-09	ACTV	ETF	31.94	32.0964	31.94	32.0964	2646.0
2025-07-09	ACVF	ETF	47.6	47.62	47.4028	47.6191	3805.0
2025-07-09	ACVT	ETF	26.31	26.34	26.26	26.3102	4520.0
2025-07-09	ACWI	ETF	129.39	129.62	128.97	129.58	1903616.0
2025-07-09	ACWV	ETF	118.04	118.22	117.59	118.12	473794.0
2025-07-09	ACWX	ETF	61.14	61.21	60.92	61.18	956445.0
2025-07-09	ADBG	ETF	13.48	13.5492	12.65	12.87	91917.0
2025-07-09	ADFI	ETF	8.4509	8.5265	8.4509	8.49	16073.0
2025-07-09	ADIV	ETF	17.7259	17.762	17.71	17.71	359.0
2025-07-09	ADME	ETF	48.38	48.4408	48.19	48.3547	10605.0
2025-07-09	ADPV	ETF	36.8637	36.988	36.83	36.9718	3656.0
2025-07-09	ADVE	ETF	35.79	35.79	35.734	35.734	710.0
2025-07-09	AESR	ETF	19.12	19.1523	19.07	19.1523	22042.0
2025-07-09	AETH	ETF	36.4406	37.8731	36.4406	37.8731	1134.0
2025-07-09	AFIF	ETF	9.31	9.34	9.3	9.3201	4828.0
2025-07-09	AFIX	ETF	24.845	24.9	24.845	24.9	906.0
2025-07-09	AFK	ETF	20.47	20.63	20.4	20.45	20741.0
2025-07-09	AFLG	ETF	36.59	36.59	36.4042	36.55	145745.0
2025-07-09	AFMC	ETF	32.74	32.74	32.4103	32.62	18162.0

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

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