PREVIEW / etf_daily / 2025-07-21

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-21.parquet
  size:    160 KB
  rows:    4,205

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-21	SPY	ETF	628.77	631.54	628.34	628.77	63343740.0
2025-07-21	QQQ	ETF	562.09	566.06	562.06	564.17	39595214.0
2025-07-21	IWM	ETF	223.54	224.41	221.25	221.43	28161890.0
2025-07-21	DIA	ETF	444.2	446.01	443.14	443.44	2547222.0
2025-07-21	GLD	ETF	311.88	313.31	311.61	313.13	10982978.0
2025-07-21	TLT	ETF	86.215	86.505	85.96	86.0	40353980.0
2025-07-21	AAA	ETF	25.03	25.06	24.9501	25.0076	10864.0
2025-07-21	AAAU	ETF	33.43	33.6	33.42	33.57	2820729.0
2025-07-21	AADR	ETF	78.87	79.03	78.6601	78.7276	2003.0
2025-07-21	AAPB	ETF	21.44	22.13	21.31	21.49	548089.0
2025-07-21	AAPD	ETF	16.99	17.0383	16.7	16.97	674588.0
2025-07-21	AAPR	ETF	27.417	27.45	27.3849	27.3849	8451.0
2025-07-21	AAPU	ETF	23.28	24.09	23.21	23.39	4700759.0
2025-07-21	AAPW	ETF	35.91	36.5	35.75	36.09	100901.0
2025-07-21	AAPX	ETF	20.08	20.79	20.06	20.2	250330.0
2025-07-21	AAPY	ETF	21.77	22.05	21.77	21.8799	4369.0
2025-07-21	AAVM	ETF	26.85	26.925	26.76	26.775	1888.0
2025-07-21	AAXJ	ETF	85.05	85.505	84.88	85.16	968939.0
2025-07-21	ABCS	ETF	29.04	29.08	28.845	28.845	3880.0
2025-07-21	ABEQ	ETF	34.34	34.41	34.24	34.2539	4737.0
2025-07-21	ABFL	ETF	70.0776	70.1802	69.87	69.87	12275.0
2025-07-21	ABLD	ETF	28.83	28.89	28.6675	28.6675	4764.0
2025-07-21	ABLG	ETF	30.58	30.58	30.4693	30.4693	2981.0
2025-07-21	ABNY	ETF	60.85	60.85	59.9	60.0	3620.0
2025-07-21	ABOT	ETF	38.76	38.82	38.7404	38.7404	440.0
2025-07-21	ABXB	ETF	19.5661	19.5661	19.5465	19.5465	202.0
2025-07-21	ACES	ETF	28.74	28.9	28.42	28.4966	21868.0
2025-07-21	ACGR	ETF	61.0254	61.0254	61.0254	61.0254	93.0
2025-07-21	ACIO	ETF	41.59	41.8053	41.59	41.65	171015.0
2025-07-21	ACLC	ETF	73.54	73.57	73.1483	73.1483	3319.0
2025-07-21	ACSI	ETF	63.8094	63.8094	63.8094	63.8094	31.0
2025-07-21	ACTV	ETF	32.0783	32.0783	32.0783	32.0783	459.0
2025-07-21	ACVF	ETF	48.04	48.04	47.66	47.66	32435.0
2025-07-21	ACVT	ETF	26.405	26.41	26.405	26.41	819.0
2025-07-21	ACWI	ETF	130.23	130.75	130.04	130.13	2423916.0
2025-07-21	ACWV	ETF	117.415	117.83	117.25	117.39	125708.0
2025-07-21	ACWX	ETF	61.13	61.485	61.07	61.21	532449.0
2025-07-21	ADBG	ETF	12.29	12.3896	12.0857	12.3371	36427.0
2025-07-21	ADFI	ETF	8.47	8.54	8.46	8.4748	15909.0
2025-07-21	ADIV	ETF	18.0683	18.14	18.0683	18.09	1825.0
2025-07-21	ADME	ETF	48.6958	48.79	48.56	48.575	41546.0
2025-07-21	ADPV	ETF	40.69	40.69	39.81	39.8201	12242.0
2025-07-21	ADVE	ETF	36.1963	36.1963	36.1963	36.1963	19.0
2025-07-21	AESR	ETF	19.35	19.48	19.35	19.4	18717.0
2025-07-21	AETH	ETF	52.19	52.809	50.74	51.0547	8852.0
2025-07-21	AFIF	ETF	9.3096	9.325	9.3096	9.325	29706.0
2025-07-21	AFIX	ETF	24.92	24.92	24.905	24.905	1575.0
2025-07-21	AFK	ETF	20.95	21.0	20.817	21.0	13144.0
2025-07-21	AFLG	ETF	36.65	36.73	36.54	36.54	47449.0
2025-07-21	AFMC	ETF	32.48	32.5237	32.21	32.21	41157.0

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

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