PREVIEW / etf_daily / 2025-04-23

all etf daily files

  file:    by_date/etf_daily/2025/2025-04-23.parquet
  size:    153 KB
  rows:    4,081

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-04-23	SPY	ETF	540.43	545.43	533.88	535.42	90363941.0
2025-04-23	QQQ	ETF	458.17	463.38	452.88	454.56	55801136.0
2025-04-23	IWM	ETF	192.92	195.51	189.84	190.25	45373653.0
2025-04-23	DIA	ETF	399.29	403.75	394.9	395.91	4042285.0
2025-04-23	GLD	ETF	304.18	304.74	300.59	303.65	25245085.0
2025-04-23	TLT	ETF	88.88	89.06	87.1701	87.32	44192794.0
2025-04-23	AAA	ETF	24.94	24.97	24.85	24.865	14739.0
2025-04-23	AAAU	ETF	32.58	32.6516	32.22	32.545	3337148.0
2025-04-23	AADR	ETF	73.8	74.98	73.26	74.98	3473.0
2025-04-23	AAPB	ETF	20.92	21.3	20.2602	20.59	208707.0
2025-04-23	AAPD	ETF	17.58	17.8597	17.37	17.72	1812370.0
2025-04-23	AAPR	ETF	25.92	25.92	25.79	25.8016	2623.0
2025-04-23	AAPU	ETF	22.9	23.3	22.195	22.53	1117750.0
2025-04-23	AAPW	ETF	38.97	38.97	38.08	38.3465	2298.0
2025-04-23	AAPX	ETF	19.74	20.09	19.315	19.46	144228.0
2025-04-23	AAPY	ETF	21.675	21.76	21.59	21.5984	1245.0
2025-04-23	AAVM	ETF	24.4	24.41	24.09	24.09	4350.0
2025-04-23	AAXJ	ETF	73.07	73.41	72.53	72.58	528031.0
2025-04-23	ABCS	ETF	26.75	26.785	26.14	26.1843	3463.0
2025-04-23	ABEQ	ETF	33.55	33.75	33.47	33.6	14356.0
2025-04-23	ABFL	ETF	62.65	63.1587	61.83	62.05	14608.0
2025-04-23	ABHY	ETF	18.945	18.9801	18.945	18.945	738.0
2025-04-23	ABLD	ETF	27.02	27.035	26.6044	26.6044	5042.0
2025-04-23	ABLG	ETF	27.26	28.2616	27.26	28.0504	3011.0
2025-04-23	ABNY	ETF	59.749	59.75	58.265	58.265	956.0
2025-04-23	ABOT	ETF	33.4663	33.4663	32.9944	32.9944	1432.0
2025-04-23	ACES	ETF	22.34	22.42	21.76	21.83	30561.0
2025-04-23	ACGR	ETF	50.08	50.2479	49.4373	49.4373	535.0
2025-04-23	ACIO	ETF	37.75	37.97	37.3429	37.46	168371.0
2025-04-23	ACLC	ETF	63.67	63.68	62.43	62.56	14933.0
2025-04-23	ACSI	ETF	57.3401	57.3401	57.3401	57.3401	82.0
2025-04-23	ACT	ETF	35.88	35.96	35.09	35.23	476328.0
2025-04-23	ACTV	ETF	29.35	29.44	28.9803	29.02	2518.0
2025-04-23	ACVF	ETF	41.66	41.9	41.04	41.2154	9042.0
2025-04-23	ACWI	ETF	114.46	115.18	113.17	113.44	2143163.0
2025-04-23	ACWV	ETF	115.75	116.0	114.66	115.18	448411.0
2025-04-23	ACWX	ETF	56.11	56.33	55.6316	55.74	635606.0
2025-04-23	ADBG	ETF	12.4403	12.5	11.89	11.9128	1249.0
2025-04-23	ADFI	ETF	8.405	8.41	8.39	8.3996	14990.0
2025-04-23	ADIV	ETF	15.26	15.26	15.0882	15.0882	22112.0
2025-04-23	ADME	ETF	42.835	43.17	42.55	42.6023	12790.0
2025-04-23	ADPV	ETF	34.49	34.54	34.43	34.43	13295.0
2025-04-23	ADVE	ETF	32.29	32.29	32.2523	32.2523	146.0
2025-04-23	AESR	ETF	16.18	16.2	16.03	16.08	37672.0
2025-04-23	AETH	ETF	27.37	27.37	27.35	27.3668	1481.0
2025-04-23	AFIF	ETF	9.16	9.2	9.14	9.16	17977.0
2025-04-23	AFIX	ETF	24.75	24.75	24.7012	24.7012	195.0
2025-04-23	AFK	ETF	17.63	17.88	17.35	17.4	22641.0
2025-04-23	AFLG	ETF	32.59	32.71	32.125	32.25	124309.0
2025-04-23	AFMC	ETF	29.76	29.82	29.19	29.2682	21717.0

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

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