PREVIEW / etf_daily / 2025-05-23

all etf daily files

  file:    by_date/etf_daily/2025/2025-05-23.parquet
  size:    154 KB
  rows:    4,097

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-05-23	SPY	ETF	575.98	581.8101	575.6	579.11	75987708.0
2025-05-23	QQQ	ETF	506.18	511.84	505.58	509.24	58368075.0
2025-05-23	IWM	ETF	199.78	203.255	199.65	202.56	29107734.0
2025-05-23	DIA	ETF	413.935	418.17	413.83	416.33	3114846.0
2025-05-23	GLD	ETF	308.86	310.25	307.47	309.75	13329320.0
2025-05-23	TLT	ETF	84.77	84.82	84.305	84.55	47124876.0
2025-05-23	AAA	ETF	24.9951	24.9951	24.8909	24.945	4269.0
2025-05-23	AAAU	ETF	33.14	33.2497	32.965	33.195	2979692.0
2025-05-23	AADR	ETF	78.91	79.83	78.17	79.2	1401.0
2025-05-23	AAPB	ETF	18.235	18.962	18.2	18.5	470554.0
2025-05-23	AAPD	ETF	18.63	18.635	18.26	18.48	2807184.0
2025-05-23	AAPR	ETF	26.62	26.62	26.5984	26.5984	133.0
2025-05-23	AAPU	ETF	19.91	20.739	19.84	20.24	6013471.0
2025-05-23	AAPW	ETF	35.35	35.47	35.135	35.2	7801.0
2025-05-23	AAPX	ETF	17.16	17.86	17.12	17.425	228621.0
2025-05-23	AAPY	ETF	20.54	20.8099	20.54	20.6436	2577.0
2025-05-23	AAVM	ETF	25.7001	25.7999	25.7001	25.7999	214.0
2025-05-23	AAXJ	ETF	78.1	78.78	78.1	78.61	197521.0
2025-05-23	ABCS	ETF	27.5173	27.665	27.4799	27.634	5252.0
2025-05-23	ABEQ	ETF	33.76	34.01	33.76	33.9733	6873.0
2025-05-23	ABFL	ETF	66.78	67.91	66.78	67.6897	8410.0
2025-05-23	ABHY	ETF	19.29	19.32	19.29	19.32	211.0
2025-05-23	ABLD	ETF	27.7	27.84	27.7	27.8022	2385.0
2025-05-23	ABLG	ETF	30.28	30.3889	30.28	30.3889	616.0
2025-05-23	ABNY	ETF	58.75	59.45	58.75	59.4	2472.0
2025-05-23	ABOT	ETF	36.46	36.605	36.46	36.4923	587.0
2025-05-23	ACES	ETF	24.02	24.57	24.02	24.51	48136.0
2025-05-23	ACGR	ETF	55.28	55.47	55.19	55.3538	1231.0
2025-05-23	ACIO	ETF	39.55	39.975	39.55	39.71	87857.0
2025-05-23	ACLC	ETF	67.71	68.1	67.63	67.7677	5727.0
2025-05-23	ACSI	ETF	60.467	60.467	60.467	60.467	163.0
2025-05-23	ACT	ETF	35.02	35.39	34.95	35.17	288748.0
2025-05-23	ACTV	ETF	30.065	30.2299	30.065	30.1736	2925.0
2025-05-23	ACVF	ETF	44.3227	44.6181	44.3227	44.5047	1469.0
2025-05-23	ACVT	ETF	25.56	25.6	25.5486	25.5486	563.0
2025-05-23	ACWI	ETF	121.29	122.72	121.25	122.3	2804974.0
2025-05-23	ACWV	ETF	117.49	118.15	117.29	118.01	1006168.0
2025-05-23	ACWX	ETF	58.85	59.55	58.85	59.45	1138658.0
2025-05-23	ADBG	ETF	15.9	15.9	15.64	15.64	2576.0
2025-05-23	ADFI	ETF	8.37	8.469	8.37	8.4	19672.0
2025-05-23	ADIV	ETF	16.53	16.5769	16.53	16.5769	1001.0
2025-05-23	ADME	ETF	45.5091	45.7878	45.5091	45.6498	6214.0
2025-05-23	ADPV	ETF	33.56	34.11	33.56	33.9835	19338.0
2025-05-23	ADVE	ETF	34.16	34.4	34.16	34.3619	657.0
2025-05-23	AESR	ETF	17.64	17.73	17.6304	17.6588	16005.0
2025-05-23	AETH	ETF	39.26	39.31	38.985	39.0055	1938.0
2025-05-23	AFIF	ETF	9.22	9.22	9.2	9.21	7813.0
2025-05-23	AFIX	ETF	24.47	24.479	24.47	24.479	1252.0
2025-05-23	AFK	ETF	18.75	19.0	18.56	18.98	17572.0
2025-05-23	AFLG	ETF	34.32	34.6346	34.32	34.51	421426.0

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

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