PREVIEW / etf_daily / 2025-01-28

all etf daily files

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

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-28	SPY	ETF	600.62	605.37	597.25	604.52	43162177.0
2025-01-28	QQQ	ETF	515.22	523.0	511.78	521.81	33194214.0
2025-01-28	IWM	ETF	226.74	227.56	225.18	226.75	16798580.0
2025-01-28	DIA	ETF	447.2	449.74	446.18	448.41	2093308.0
2025-01-28	GLD	ETF	254.225	255.25	253.891	255.18	5350805.0
2025-01-28	TLT	ETF	87.84	88.2	87.6591	88.19	24773423.0
2025-01-28	AAA	ETF	25.1193	25.23	25.1193	25.23	8774.0
2025-01-28	AAAU	ETF	27.34	27.36	27.22	27.335	773257.0
2025-01-28	AADR	ETF	73.325	73.8983	73.26	73.8983	657.0
2025-01-28	AAPB	ETF	28.46	30.64	28.46	30.17	527737.0
2025-01-28	AAPD	ETF	16.55	16.55	15.885	16.02	1299697.0
2025-01-28	AAPR	ETF	26.56	26.65	26.56	26.6402	7749.0
2025-01-28	AAPU	ETF	31.64	34.1	31.5	33.56	3058805.0
2025-01-28	AAPX	ETF	27.0	29.19	27.0	28.74	279113.0
2025-01-28	AAPY	ETF	25.1	25.78	25.1	25.59	13654.0
2025-01-28	AAXJ	ETF	71.77	72.225	71.238	72.21	223051.0
2025-01-28	ABCS	ETF	29.83	29.83	29.785	29.79	3830.0
2025-01-28	ABEQ	ETF	32.8	32.8	32.67	32.6792	1935.0
2025-01-28	ABFL	ETF	68.8715	69.1541	68.8715	69.0373	12884.0
2025-01-28	ABHY	ETF	18.75	19.163	18.75	19.163	614.0
2025-01-28	ABLD	ETF	29.23	29.23	29.02	29.0946	14985.0
2025-01-28	ABLG	ETF	29.8218	29.8494	29.6701	29.83	5176.0
2025-01-28	ABNY	ETF	71.7	72.9705	71.7	72.9705	804.0
2025-01-28	ABOT	ETF	37.5284	37.5284	37.5284	37.5284	56.0
2025-01-28	ACES	ETF	25.59	25.59	24.8022	25.04	46621.0
2025-01-28	ACGR	ETF	58.935	59.11	58.935	58.998	375.0
2025-01-28	ACIO	ETF	41.01	41.21	40.8	41.15	156137.0
2025-01-28	ACLC	ETF	71.85	72.6516	71.7401	72.6416	8753.0
2025-01-28	ACSI	ETF	63.5867	63.5867	63.5867	63.5867	173.0
2025-01-28	ACT	ETF	33.98	34.405	33.78	34.0	237633.0
2025-01-28	ACTV	ETF	33.12	33.12	32.7801	32.9016	4208.0
2025-01-28	ACVF	ETF	44.91	45.08	44.6799	45.02	16637.0
2025-01-28	ACWI	ETF	120.7	121.55	120.25	121.4	1527612.0
2025-01-28	ACWV	ETF	111.99	112.05	111.45	111.56	110502.0
2025-01-28	ACWX	ETF	53.83	53.925	53.54	53.91	665285.0
2025-01-28	ADFI	ETF	8.43	8.46	8.42	8.46	31918.0
2025-01-28	ADIV	ETF	15.54	15.5453	15.4599	15.5453	8834.0
2025-01-28	ADME	ETF	47.54	48.18	47.54	48.1	439180.0
2025-01-28	ADPV	ETF	37.525	38.35	37.31	38.29	14212.0
2025-01-28	ADVE	ETF	32.0666	32.0666	32.0666	32.0666	138.0
2025-01-28	AESR	ETF	17.67	17.8284	17.64	17.8284	29342.0
2025-01-28	AETH	ETF	32.82	32.82	32.75	32.77	1482.0
2025-01-28	AFIF	ETF	9.2	9.23	9.17	9.23	32154.0
2025-01-28	AFIX	ETF	24.61	24.6365	24.61	24.6365	3779.0
2025-01-28	AFK	ETF	16.18	16.3602	16.0212	16.24	12810.0
2025-01-28	AFLG	ETF	35.54	35.7	35.346	35.68	29873.0
2025-01-28	AFMC	ETF	33.17	33.1791	32.9682	33.0784	6986.0
2025-01-28	AFSM	ETF	30.675	30.81	30.56	30.8047	4531.0
2025-01-28	AGG	ETF	97.34	97.53	97.29	97.52	5714325.0
2025-01-28	AGGH	ETF	20.53	20.77	20.53	20.77	27212.0

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

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