PREVIEW / etf_daily / 2025-01-15

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-15.parquet
  size:    147 KB
  rows:    3,882

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-15	SPY	ETF	590.325	593.94	589.195	592.78	55988234.0
2025-01-15	QQQ	ETF	513.03	517.85	511.46	516.7	34957554.0
2025-01-15	IWM	ETF	225.44	225.575	223.0	224.04	29942865.0
2025-01-15	DIA	ETF	431.56	433.28	430.5	432.24	3733379.0
2025-01-15	GLD	ETF	248.21	248.9	247.0102	248.88	6239589.0
2025-01-15	TLT	ETF	86.695	86.975	86.395	86.76	53543079.0
2025-01-15	AAA	ETF	25.1508	25.17	25.11	25.1457	17193.0
2025-01-15	AAAU	ETF	26.59	26.67	26.465	26.67	2105424.0
2025-01-15	AADR	ETF	72.12	72.48	72.12	72.22	719.0
2025-01-15	AAPB	ETF	29.5	30.474	29.5	30.34	52124.0
2025-01-15	AAPD	ETF	16.3	16.31	16.045	16.08	727020.0
2025-01-15	AAPR	ETF	26.465	26.465	26.465	26.465	172.0
2025-01-15	AAPU	ETF	32.93	33.99	32.885	33.79	792217.0
2025-01-15	AAPX	ETF	28.64	29.0	28.64	28.9	18158.0
2025-01-15	AAPY	ETF	25.31	26.1	25.31	26.0306	1981.0
2025-01-15	AAXJ	ETF	71.15	71.27	70.98	71.18	468388.0
2025-01-15	ABCS	ETF	29.3059	29.3059	29.17	29.17	1202.0
2025-01-15	ABEQ	ETF	32.02	32.02	31.87	31.9615	2182.0
2025-01-15	ABFL	ETF	67.4701	67.6799	67.4701	67.5016	6081.0
2025-01-15	ABLD	ETF	29.03	29.03	28.9	28.9853	3721.0
2025-01-15	ABLG	ETF	28.85	28.86	28.84	28.8457	1809.0
2025-01-15	ABNY	ETF	71.65	73.4	71.65	72.9	3381.0
2025-01-15	ABOT	ETF	36.3771	36.3771	36.3771	36.3771	35.0
2025-01-15	ACES	ETF	27.11	27.19	26.86	26.91	97724.0
2025-01-15	ACGR	ETF	57.58	58.14	57.58	58.0965	2041.0
2025-01-15	ACIO	ETF	40.24	40.5119	40.22	40.46	137809.0
2025-01-15	ACLC	ETF	71.12	71.47	71.08	71.4336	4498.0
2025-01-15	ACSI	ETF	61.3884	61.3884	61.3884	61.3884	42.0
2025-01-15	ACT	ETF	32.29	32.38	31.97	32.2	657246.0
2025-01-15	ACTV	ETF	32.45	32.46	32.11	32.25	15662.0
2025-01-15	ACVF	ETF	44.3	44.48	44.164	44.4004	15912.0
2025-01-15	ACWI	ETF	118.37	118.8175	118.05	118.58	2159751.0
2025-01-15	ACWV	ETF	109.09	109.12	108.44	108.71	90481.0
2025-01-15	ACWX	ETF	52.24	52.39	52.12	52.31	1756265.0
2025-01-15	ADFI	ETF	8.38	8.38	8.355	8.355	30151.0
2025-01-15	ADIV	ETF	15.2859	15.2859	15.2859	15.2859	150.0
2025-01-15	ADME	ETF	46.93	47.3	46.93	47.24	49990.0
2025-01-15	ADPV	ETF	36.94	36.94	36.64	36.6907	5436.0
2025-01-15	ADVE	ETF	31.5053	31.5053	31.5053	31.5053	51.0
2025-01-15	AESR	ETF	17.58	17.62	17.515	17.6	35869.0
2025-01-15	AETH	ETF	32.78	32.78	32.71	32.7297	4392.0
2025-01-15	AFIF	ETF	9.1502	9.18	9.1502	9.165	27552.0
2025-01-15	AFIX	ETF	24.42	24.4444	24.42	24.4444	102.0
2025-01-15	AFK	ETF	16.03	16.0599	15.91	16.05	16224.0
2025-01-15	AFLG	ETF	35.11	35.18	35.0	35.13	37962.0
2025-01-15	AFMC	ETF	32.811	32.811	32.545	32.6533	169509.0
2025-01-15	AFSM	ETF	30.56	30.6599	30.49	30.6225	6513.0
2025-01-15	AGG	ETF	96.94	96.94	96.552	96.71	9276018.0
2025-01-15	AGGH	ETF	20.33	20.7	20.33	20.48	71283.0
2025-01-15	AGGS	ETF	40.41	40.41	40.41	40.41	124.0

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

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