PREVIEW / etf_daily / 2025-06-04

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-04.parquet
  size:    156 KB
  rows:    4,127

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-04	SPY	ETF	596.96	597.95	595.49	595.93	57199731.0
2025-06-04	QQQ	ETF	528.01	529.84	525.9694	528.77	41359322.0
2025-06-04	IWM	ETF	209.18	210.01	208.14	208.44	27512875.0
2025-06-04	DIA	ETF	426.38	427.16	424.86	424.94	2150167.0
2025-06-04	GLD	ETF	309.41	311.88	308.74	310.9	7449037.0
2025-06-04	TLT	ETF	85.79	86.65	85.645	86.39	57593914.0
2025-06-04	AAA	ETF	24.98	24.99	24.88	24.935	31920.0
2025-06-04	AAAU	ETF	33.23	33.44	33.1	33.33	2109972.0
2025-06-04	AADR	ETF	78.0	78.25	77.765	77.8	6595.0
2025-06-04	AAPB	ETF	19.92	20.56	19.79	19.91	298523.0
2025-06-04	AAPD	ETF	17.8	17.85	17.51	17.8	767975.0
2025-06-04	AAPR	ETF	26.8608	26.9099	26.8608	26.8756	3199.0
2025-06-04	AAPU	ETF	21.77	22.465	21.61	21.75	4008132.0
2025-06-04	AAPW	ETF	36.41	36.9127	36.35	36.39	7101.0
2025-06-04	AAPX	ETF	18.74	19.29	18.6	18.72	146391.0
2025-06-04	AAPY	ETF	21.45	21.86	21.35	21.3893	4979.0
2025-06-04	AAVM	ETF	26.42	26.42	26.3708	26.3708	403.0
2025-06-04	AAXJ	ETF	79.2	79.56	79.07	79.47	391419.0
2025-06-04	ABCS	ETF	28.17	28.24	28.0492	28.0492	4228.0
2025-06-04	ABEQ	ETF	34.53	34.53	34.3562	34.3562	18879.0
2025-06-04	ABFL	ETF	69.855	70.28	69.855	70.0533	10931.0
2025-06-04	ABHY	ETF	19.54	19.5411	19.54	19.5411	104.0
2025-06-04	ABLD	ETF	28.3096	28.3096	28.1405	28.1405	3470.0
2025-06-04	ABLG	ETF	30.943	30.943	30.943	30.943	59.0
2025-06-04	ABNY	ETF	59.6	60.35	59.6	59.95	1185.0
2025-06-04	ABOT	ETF	37.72	37.72	37.5891	37.5891	496.0
2025-06-04	ACES	ETF	24.77	24.79	24.45	24.64	13144.0
2025-06-04	ACGR	ETF	57.4207	57.4207	57.4207	57.4207	53.0
2025-06-04	ACIO	ETF	40.51	40.7	40.51	40.54	108412.0
2025-06-04	ACLC	ETF	70.0063	70.0073	69.912	69.9178	2069.0
2025-06-04	ACSI	ETF	62.0284	62.0284	62.0284	62.0284	73.0
2025-06-04	ACT	ETF	34.83	34.98	34.575	34.64	354034.0
2025-06-04	ACTV	ETF	30.86	31.0145	30.86	30.95	2247.0
2025-06-04	ACVF	ETF	45.71	45.71	45.5604	45.5604	2226.0
2025-06-04	ACVT	ETF	25.78	25.78	25.7523	25.7523	4002.0
2025-06-04	ACWI	ETF	125.07	125.54	125.04	125.17	2672311.0
2025-06-04	ACWV	ETF	118.63	118.79	118.26	118.28	84490.0
2025-06-04	ACWX	ETF	60.18	60.3999	60.08	60.26	865004.0
2025-06-04	ADBG	ETF	16.125	16.2437	16.0	16.18	3800.0
2025-06-04	ADFI	ETF	8.4777	8.529	8.46	8.474	13010.0
2025-06-04	ADIV	ETF	16.88	17.569	16.83	16.9059	7602.0
2025-06-04	ADME	ETF	46.84	46.9393	46.8119	46.8119	10665.0
2025-06-04	ADPV	ETF	34.31	34.31	34.06	34.12	22094.0
2025-06-04	ADVE	ETF	34.74	34.875	34.74	34.8331	1007.0
2025-06-04	AESR	ETF	18.07	18.24	18.0461	18.05	13234.0
2025-06-04	AETH	ETF	39.79	40.29	39.79	39.86	672.0
2025-06-04	AFIF	ETF	9.26	9.28	9.26	9.28	24654.0
2025-06-04	AFIX	ETF	24.76	24.76	24.76	24.76	4.0
2025-06-04	AFK	ETF	19.22	19.5	19.22	19.5	16246.0
2025-06-04	AFLG	ETF	35.48	35.48	35.31	35.32	58384.0

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

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