PREVIEW / etf_daily / 2025-09-09

all etf daily files

  file:    by_date/etf_daily/2025/2025-09-09.parquet
  size:    162 KB
  rows:    4,255

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-09-09	SPY	ETF	648.97	650.86	647.22	650.33	66117839.0
2025-09-09	QQQ	ETF	579.67	580.94	577.04	580.51	44007592.0
2025-09-09	IWM	ETF	237.9	237.96	235.42	236.85	35398498.0
2025-09-09	DIA	ETF	455.96	458.55	455.215	458.01	5977893.0
2025-09-09	GLD	ETF	337.03	338.31	333.85	334.06	21638048.0
2025-09-09	TLT	ETF	89.4	89.55	88.99	89.23	37126405.0
2025-09-09	AAA	ETF	25.0014	25.01	24.96	24.96	2514.0
2025-09-09	AAAU	ETF	36.15	36.28	35.82	35.85	2515471.0
2025-09-09	AADR	ETF	83.66	84.59	83.66	84.255	4766.0
2025-09-09	AAPB	ETF	26.25	26.6128	25.45	25.68	477061.0
2025-09-09	AAPD	ETF	15.22	15.4304	15.0901	15.37	2461046.0
2025-09-09	AAPR	ETF	27.7868	27.7868	27.7868	27.7868	41.0
2025-09-09	AAPU	ETF	28.53	28.96	27.65	27.88	3952112.0
2025-09-09	AAPW	ETF	38.6	38.7799	37.8525	37.99	51466.0
2025-09-09	AAPX	ETF	24.61	24.91	23.83	24.0	463366.0
2025-09-09	AAPY	ETF	23.6751	23.6751	23.4678	23.4678	1622.0
2025-09-09	AAVM	ETF	28.19	28.28	28.19	28.28	483.0
2025-09-09	AAXJ	ETF	88.24	88.56	88.215	88.43	534247.0
2025-09-09	ABCS	ETF	30.4499	30.45	30.339	30.339	3046.0
2025-09-09	ABEQ	ETF	35.66	35.66	35.55	35.63	4480.0
2025-09-09	ABFL	ETF	71.3601	71.5504	71.26	71.5504	7811.0
2025-09-09	ABLD	ETF	28.9717	29.01	28.9477	28.9477	2111.0
2025-09-09	ABLG	ETF	30.6046	30.6046	30.6046	30.6046	93.0
2025-09-09	ABNY	ETF	51.25	51.25	50.55	50.55	3273.0
2025-09-09	ABOT	ETF	39.9206	39.9206	39.9206	39.9206	8.0
2025-09-09	ABXB	ETF	19.8359	19.8359	19.8359	19.8359	16.0
2025-09-09	ACES	ETF	29.1	29.1	28.57	28.69	4270.0
2025-09-09	ACGR	ETF	63.7062	63.7062	63.7062	63.7062	4.0
2025-09-09	ACIO	ETF	42.64	42.735	42.5723	42.72	109753.0
2025-09-09	ACLC	ETF	75.7434	75.84	75.605	75.84	3290.0
2025-09-09	ACSI	ETF	66.2706	66.2706	66.2706	66.2706	36.0
2025-09-09	ACTV	ETF	33.13	33.2301	33.1	33.1	1834.0
2025-09-09	ACVF	ETF	48.4199	48.451	48.35	48.451	1867.0
2025-09-09	ACWI	ETF	134.55	134.995	134.38	134.92	2260537.0
2025-09-09	ACWV	ETF	119.82	119.92	119.56	119.79	151297.0
2025-09-09	ACWX	ETF	63.68	63.775	63.54	63.64	3749879.0
2025-09-09	ADBG	ETF	11.64	11.64	11.0601	11.15	298446.0
2025-09-09	ADFI	ETF	8.6495	8.6495	8.5976	8.5976	17526.0
2025-09-09	ADIV	ETF	18.47	18.47	18.38	18.4147	2569.0
2025-09-09	ADME	ETF	49.88	49.88	49.734	49.87	5931.0
2025-09-09	ADPV	ETF	40.3	40.46	40.145	40.46	13926.0
2025-09-09	ADVE	ETF	37.6506	37.6506	37.6506	37.6506	201.0
2025-09-09	AESR	ETF	20.06	20.11	20.0167	20.106	38396.0
2025-09-09	AETH	ETF	51.99	52.0557	51.88	52.055	2880.0
2025-09-09	AFIF	ETF	9.38	9.41	9.37	9.4057	48706.0
2025-09-09	AFIX	ETF	25.36	25.36	25.3292	25.335	896.0
2025-09-09	AFK	ETF	23.07	23.0986	22.8114	22.86	42700.0
2025-09-09	AFLG	ETF	37.99	38.02	37.84	38.01	33743.0
2025-09-09	AFMC	ETF	34.0258	34.0258	33.845	33.9639	8313.0
2025-09-09	AFSC	ETF	30.17	30.17	30.17	30.17	132.0

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

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