PREVIEW / etf_daily / 2025-08-27

all etf daily files

  file:    by_date/etf_daily/2025/2025-08-27.parquet
  size:    162 KB
  rows:    4,243

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-08-27	SPY	ETF	644.57	647.37	644.42	646.63	48478505.0
2025-08-27	QQQ	ETF	571.59	574.405	570.37	573.49	36927144.0
2025-08-27	IWM	ETF	233.74	236.12	233.555	235.94	25364028.0
2025-08-27	DIA	ETF	454.28	456.64	454.21	456.03	2940481.0
2025-08-27	GLD	ETF	311.39	312.91	310.77	312.71	4316195.0
2025-08-27	TLT	ETF	86.105	86.66	86.0	86.65	38140991.0
2025-08-27	AAA	ETF	25.11	25.14	25.07	25.09	6967.0
2025-08-27	AAAU	ETF	33.4	33.555	33.3307	33.54	1478751.0
2025-08-27	AADR	ETF	81.5675	81.885	81.06	81.885	5082.0
2025-08-27	AAPB	ETF	24.5	25.0	24.5	24.9778	183009.0
2025-08-27	AAPD	ETF	15.76	15.76	15.59	15.6055	447323.0
2025-08-27	AAPR	ETF	27.6401	27.69	27.6401	27.69	2056.0
2025-08-27	AAPU	ETF	26.685	27.2	26.61	27.09	1914207.0
2025-08-27	AAPW	ETF	37.61	37.82	37.27	37.82	30649.0
2025-08-27	AAPX	ETF	23.0122	23.43	23.0	23.35	120481.0
2025-08-27	AAPY	ETF	22.8985	22.9446	22.8732	22.9446	1048.0
2025-08-27	AAVM	ETF	27.78	27.87	27.78	27.825	411.0
2025-08-27	AAXJ	ETF	85.91	86.01	85.48	85.96	182852.0
2025-08-27	ABCS	ETF	30.491	30.53	30.45	30.5201	3308.0
2025-08-27	ABEQ	ETF	35.24	35.4299	35.205	35.4299	6482.0
2025-08-27	ABFL	ETF	69.17	69.59	69.17	69.59	15319.0
2025-08-27	ABLD	ETF	28.95	29.08	28.93	29.04	4702.0
2025-08-27	ABLG	ETF	30.15	30.2487	30.15	30.2487	6811.0
2025-08-27	ABNY	ETF	51.6	52.6325	51.6	52.6325	2481.0
2025-08-27	ABOT	ETF	38.63	38.7353	38.63	38.7353	125.0
2025-08-27	ABXB	ETF	19.712	19.712	19.712	19.712	29.0
2025-08-27	ACES	ETF	29.64	29.8164	29.57	29.6	232036.0
2025-08-27	ACGR	ETF	62.72	62.8897	62.72	62.8897	165.0
2025-08-27	ACIO	ETF	42.45	42.62	42.4	42.52	91168.0
2025-08-27	ACLC	ETF	75.29	75.44	75.2801	75.4	3451.0
2025-08-27	ACSI	ETF	66.01	66.0408	66.01	66.0408	502.0
2025-08-27	ACTV	ETF	32.8	32.9801	32.8	32.88	2868.0
2025-08-27	ACVF	ETF	48.45	48.62	48.45	48.61	3908.0
2025-08-27	ACWI	ETF	133.25	133.8	133.215	133.68	1560663.0
2025-08-27	ACWV	ETF	118.845	119.35	118.835	119.16	103833.0
2025-08-27	ACWX	ETF	62.57	62.82	62.39	62.8	445147.0
2025-08-27	ADBG	ETF	11.33	11.59	11.3	11.3597	92853.0
2025-08-27	ADFI	ETF	8.52	8.58	8.52	8.57	14052.0
2025-08-27	ADIV	ETF	18.11	18.11	18.01	18.051	12972.0
2025-08-27	ADME	ETF	49.54	49.72	49.54	49.6883	12556.0
2025-08-27	ADPV	ETF	41.13	41.13	40.89	40.9551	14242.0
2025-08-27	ADVE	ETF	36.9036	36.9036	36.9036	36.9036	38.0
2025-08-27	AESR	ETF	19.7414	19.79	19.655	19.79	44222.0
2025-08-27	AETH	ETF	56.49	56.98	56.04	56.04	3567.0
2025-08-27	AFIF	ETF	9.33	9.4	9.33	9.35	74604.0
2025-08-27	AFIX	ETF	25.0388	25.0388	25.0388	25.0388	100.0
2025-08-27	AFK	ETF	22.36	22.41	22.14	22.372	121538.0
2025-08-27	AFLG	ETF	37.68	37.7878	37.68	37.744	51246.0
2025-08-27	AFMC	ETF	33.68	33.79	33.6499	33.725	6790.0
2025-08-27	AFSC	ETF	30.06	30.1414	30.06	30.1414	277.0

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

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