PREVIEW / etf_daily / 2025-06-16

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-16.parquet
  size:    157 KB
  rows:    4,146

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-06-16	SPY	ETF	600.4	604.45	600.22	602.68	79104433.0
2025-06-16	QQQ	ETF	530.5	535.37	530.45	534.29	37622051.0
2025-06-16	IWM	ETF	210.48	211.95	209.64	210.77	28918961.0
2025-06-16	DIA	ETF	425.05	428.2	424.88	426.28	3163972.0
2025-06-16	GLD	ETF	314.8	314.87	311.65	311.78	12686559.0
2025-06-16	TLT	ETF	86.08	86.43	85.46	85.46	36458214.0
2025-06-16	AAA	ETF	25.03	25.08	24.91	24.9465	15568.0
2025-06-16	AAAU	ETF	33.85	33.85	33.41	33.425	3643686.0
2025-06-16	AADR	ETF	78.4	78.6249	78.38	78.38	3088.0
2025-06-16	AAPB	ETF	18.72	18.98	18.62	18.94	214721.0
2025-06-16	AAPD	ETF	18.34	18.38	18.2	18.22	1333649.0
2025-06-16	AAPR	ETF	26.99	26.99	26.9501	26.9803	495.0
2025-06-16	AAPU	ETF	20.51	20.77	20.335	20.71	2254493.0
2025-06-16	AAPW	ETF	34.579	34.87	34.56	34.8124	16270.0
2025-06-16	AAPX	ETF	17.65	17.8865	17.54	17.83	146440.0
2025-06-16	AAPY	ETF	20.97	21.05	20.88	20.9987	7058.0
2025-06-16	AAVM	ETF	26.64	26.64	26.55	26.57	1133.0
2025-06-16	AAXJ	ETF	81.11	81.5617	81.09	81.14	383217.0
2025-06-16	ABCS	ETF	28.26	28.37	28.2454	28.2597	11225.0
2025-06-16	ABEQ	ETF	34.61	34.71	34.53	34.5663	8051.0
2025-06-16	ABFL	ETF	69.91	69.91	69.6308	69.7	18458.0
2025-06-16	ABLD	ETF	28.98	28.98	28.5	28.5033	7680.0
2025-06-16	ABLG	ETF	31.085	31.085	30.9689	30.9689	1954.0
2025-06-16	ABNY	ETF	60.05	61.45	60.05	60.65	1138.0
2025-06-16	ABOT	ETF	37.65	37.6967	37.65	37.6967	5796.0
2025-06-16	ABXB	ETF	19.58	19.595	19.58	19.595	2840.0
2025-06-16	ACES	ETF	26.24	26.56	26.16	26.38	44955.0
2025-06-16	ACGR	ETF	57.8722	57.8722	57.8289	57.8289	216.0
2025-06-16	ACIO	ETF	40.68	40.8988	40.68	40.75	125398.0
2025-06-16	ACLC	ETF	70.56	70.7099	70.39	70.39	5106.0
2025-06-16	ACSI	ETF	61.9217	61.9217	61.9217	61.9217	61.0
2025-06-16	ACT	ETF	35.74	36.4	35.74	35.87	485018.0
2025-06-16	ACTV	ETF	31.12	31.128	31.11	31.128	695.0
2025-06-16	ACVF	ETF	45.95	46.1422	45.92	45.9325	4083.0
2025-06-16	ACWI	ETF	125.33	126.04	125.28	125.52	3239282.0
2025-06-16	ACWV	ETF	117.48	117.8422	116.98	117.13	191297.0
2025-06-16	ACWX	ETF	60.16	60.44	59.955	59.99	1573298.0
2025-06-16	ADBG	ETF	14.5	15.2375	14.25	14.99	112346.0
2025-06-16	ADFI	ETF	8.42	8.5	8.42	8.48	26372.0
2025-06-16	ADIV	ETF	17.469	17.49	17.435	17.435	2915.0
2025-06-16	ADME	ETF	47.2156	47.2684	47.07	47.1152	13512.0
2025-06-16	ADPV	ETF	34.9989	35.21	34.9989	35.2	71631.0
2025-06-16	ADVE	ETF	35.3117	35.3117	35.3117	35.3117	94.0
2025-06-16	AESR	ETF	18.26	18.37	18.25	18.3262	21713.0
2025-06-16	AETH	ETF	37.33	37.45	37.15	37.45	1261.0
2025-06-16	AFIF	ETF	9.26	9.2608	9.25	9.25	3979.0
2025-06-16	AFIX	ETF	24.7	24.7	24.69	24.7	2064.0
2025-06-16	AFK	ETF	19.72	19.81	19.52	19.615	13073.0
2025-06-16	AFLG	ETF	35.37	35.53	35.37	35.46	111760.0
2025-06-16	AFMC	ETF	31.44	31.59	31.4	31.44	9948.0

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

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