PREVIEW / etf_daily / 2025-01-29

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-29.parquet
  size:    148 KB
  rows:    3,895

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-01-29	SPY	ETF	603.72	604.13	599.22	601.81	36876870.0
2025-01-29	QQQ	ETF	522.46	522.59	516.8988	520.83	26649011.0
2025-01-29	IWM	ETF	226.68	228.22	224.58	226.23	20150803.0
2025-01-29	DIA	ETF	448.21	449.61	445.768	447.18	2174860.0
2025-01-29	GLD	ETF	254.55	254.82	253.3	254.2	5663456.0
2025-01-29	TLT	ETF	88.43	88.615	87.63	88.01	24860205.0
2025-01-29	AAA	ETF	25.21	25.28	25.1101	25.23	41201.0
2025-01-29	AAAU	ETF	27.32	27.32	27.1338	27.24	803817.0
2025-01-29	AADR	ETF	74.22	74.59	74.22	74.435	692.0
2025-01-29	AAPB	ETF	29.13	30.55	29.09	30.43	300164.0
2025-01-29	AAPD	ETF	16.28	16.3	15.9176	15.96	877011.0
2025-01-29	AAPR	ETF	26.64	26.64	26.55	26.6125	10819.0
2025-01-29	AAPU	ETF	32.41	34.0	32.37	33.85	2272569.0
2025-01-29	AAPX	ETF	27.79	29.11	27.71	28.96	73564.0
2025-01-29	AAPY	ETF	25.32	25.78	25.32	25.7531	7726.0
2025-01-29	AAXJ	ETF	72.59	72.79	72.09	72.23	1293151.0
2025-01-29	ABCS	ETF	29.85	29.8615	29.75	29.75	3228.0
2025-01-29	ABEQ	ETF	32.68	32.89	32.6401	32.89	4253.0
2025-01-29	ABFL	ETF	68.85	68.96	68.66	68.8566	10995.0
2025-01-29	ABHY	ETF	19.1616	19.17	19.12	19.1541	3484.0
2025-01-29	ABLD	ETF	29.1	29.1299	28.9	28.9827	1399.0
2025-01-29	ABLG	ETF	29.91	29.99	29.91	29.962	6372.0
2025-01-29	ABNY	ETF	73.65	74.3	73.6	73.8175	1112.0
2025-01-29	ABOT	ETF	37.41	37.41	37.11	37.3326	722.0
2025-01-29	ACES	ETF	25.46	25.61	25.08	25.34	42784.0
2025-01-29	ACGR	ETF	58.75	58.75	58.6874	58.6874	318.0
2025-01-29	ACIO	ETF	41.16	41.16	40.86	41.01	136293.0
2025-01-29	ACLC	ETF	72.31	72.36	71.92	72.1753	5517.0
2025-01-29	ACSI	ETF	63.6237	63.6237	63.6237	63.6237	19.0
2025-01-29	ACT	ETF	33.94	34.32	33.73	33.92	209823.0
2025-01-29	ACTV	ETF	32.74	32.77	32.47	32.7017	3330.0
2025-01-29	ACVF	ETF	45.03	45.07	44.645	44.77	6017.0
2025-01-29	ACWI	ETF	121.24	121.48	120.59	121.04	1494420.0
2025-01-29	ACWV	ETF	111.86	112.1128	111.575	111.62	61455.0
2025-01-29	ACWX	ETF	54.02	54.105	53.7599	53.88	753904.0
2025-01-29	ADFI	ETF	8.42	8.47	8.42	8.46	39739.0
2025-01-29	ADIV	ETF	15.63	15.63	15.61	15.6141	2322.0
2025-01-29	ADME	ETF	48.19	48.19	47.76	47.93	17180.0
2025-01-29	ADPV	ETF	38.25	38.56	38.2	38.44	127879.0
2025-01-29	ADVE	ETF	31.9964	31.9964	31.9964	31.9964	123.0
2025-01-29	AESR	ETF	17.85	17.85	17.7564	17.8	28405.0
2025-01-29	AETH	ETF	32.77	32.7852	32.75	32.7697	4997.0
2025-01-29	AFIF	ETF	9.26	9.26	9.17	9.22	73239.0
2025-01-29	AFK	ETF	16.4	16.5	16.25	16.39	11290.0
2025-01-29	AFLG	ETF	35.69	35.69	35.43	35.6	55304.0
2025-01-29	AFMC	ETF	33.18	33.2	32.87	32.955	11548.0
2025-01-29	AFSM	ETF	30.97	30.979	30.79	30.82	10518.0
2025-01-29	AGG	ETF	97.58	97.645	97.22	97.46	5835999.0
2025-01-29	AGGH	ETF	20.84	20.84	20.61	20.77	60030.0
2025-01-29	AGGS	ETF	40.77	40.77	40.76	40.76	162.0

> showing 50 of 3,895 rows — these rows as CSV

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