PREVIEW / etf_daily / 2025-06-17

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-17.parquet
  size:    158 KB
  rows:    4,155

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-17	SPY	ETF	600.21	601.75	596.76	597.53	81959071.0
2025-06-17	QQQ	ETF	531.71	533.325	527.91	529.08	42180866.0
2025-06-17	IWM	ETF	209.06	210.45	208.37	208.55	32890299.0
2025-06-17	DIA	ETF	424.46	426.42	422.355	423.11	2445414.0
2025-06-17	GLD	ETF	312.66	313.0	310.12	311.94	8177746.0
2025-06-17	TLT	ETF	86.0	86.66	85.75	86.5	34466649.0
2025-06-17	AAA	ETF	24.94	24.995	24.94	24.96	2273.0
2025-06-17	AAAU	ETF	33.54	33.555	33.2467	33.435	3666090.0
2025-06-17	AADR	ETF	77.425	77.425	76.87	76.87	5017.0
2025-06-17	AAPB	ETF	18.72	18.923	18.34	18.41	182950.0
2025-06-17	AAPD	ETF	18.32	18.5101	18.2346	18.49	987146.0
2025-06-17	AAPR	ETF	26.95	26.95	26.91	26.92	1369.0
2025-06-17	AAPU	ETF	20.48	20.69	20.04	20.13	2002402.0
2025-06-17	AAPW	ETF	34.98	34.98	34.211	34.2741	12531.0
2025-06-17	AAPX	ETF	17.62	17.81	17.2575	17.32	141333.0
2025-06-17	AAPY	ETF	20.94	20.94	20.4914	20.5044	5754.0
2025-06-17	AAVM	ETF	26.42	26.4304	26.2929	26.2929	832.0
2025-06-17	AAXJ	ETF	80.67	80.795	80.09	80.18	369669.0
2025-06-17	ABCS	ETF	28.23	28.23	28.0119	28.0119	2813.0
2025-06-17	ABEQ	ETF	34.48	34.49	34.34	34.36	5713.0
2025-06-17	ABFL	ETF	69.405	69.6899	69.2	69.2094	7551.0
2025-06-17	ABLD	ETF	28.44	28.58	28.39	28.3917	7806.0
2025-06-17	ABLG	ETF	30.9	30.9	30.699	30.699	2357.0
2025-06-17	ABNY	ETF	60.0565	60.0565	59.15	59.475	1839.0
2025-06-17	ABOT	ETF	37.65	37.68	37.4892	37.4892	274.0
2025-06-17	ABXB	ETF	19.5801	19.5801	19.5801	19.5801	67.0
2025-06-17	ACES	ETF	25.15	25.34	24.9748	25.09	44151.0
2025-06-17	ACGR	ETF	57.3939	57.3939	57.3939	57.3939	62.0
2025-06-17	ACIO	ETF	40.6	40.7534	40.5401	40.55	125623.0
2025-06-17	ACLC	ETF	70.348	70.348	69.79	69.841	3306.0
2025-06-17	ACSI	ETF	61.4813	61.4813	61.4813	61.4813	77.0
2025-06-17	ACT	ETF	35.69	35.76	34.77	35.04	413318.0
2025-06-17	ACTV	ETF	31.02	31.065	30.92	30.9205	1453.0
2025-06-17	ACTX	ETF	0.0001	0.0001	0.0001	0.0001	447.0
2025-06-17	ACVF	ETF	45.81	45.8478	45.4801	45.5561	8003.0
2025-06-17	ACVT	ETF	25.795	25.795	25.73	25.73	2641.0
2025-06-17	ACWI	ETF	124.885	125.14	124.06	124.25	2055634.0
2025-06-17	ACWV	ETF	116.74	116.8	116.16	116.25	246424.0
2025-06-17	ACWX	ETF	59.65	59.75	59.165	59.21	770953.0
2025-06-17	ADBG	ETF	14.771	14.8	13.55	13.61	166523.0
2025-06-17	ADFI	ETF	8.41	8.48	8.41	8.47	25991.0
2025-06-17	ADIV	ETF	17.33	17.35	17.225	17.235	2458.0
2025-06-17	ADME	ETF	47.055	47.055	46.84	46.8584	8825.0
2025-06-17	ADPV	ETF	35.18	35.18	34.83	34.97	20418.0
2025-06-17	ADVE	ETF	34.975	34.9815	34.975	34.9815	340.0
2025-06-17	AESR	ETF	18.26	18.2979	18.12	18.1646	17069.0
2025-06-17	AETH	ETF	35.68	35.84	34.72	35.647	1531.0
2025-06-17	AFIF	ETF	9.26	9.26	9.25	9.25	41579.0
2025-06-17	AFIX	ETF	24.74	24.77	24.7299	24.77	571.0
2025-06-17	AFK	ETF	19.7	19.7	19.31	19.3829	22715.0

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

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