PREVIEW / etf_daily / 2025-07-16

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-16.parquet
  size:    160 KB
  rows:    4,205

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-07-16	SPY	ETF	623.74	624.73	618.05	624.22	88947593.0
2025-07-16	QQQ	ETF	557.28	560.21	551.56	557.29	52314711.0
2025-07-16	IWM	ETF	220.22	221.365	216.91	221.02	48174743.0
2025-07-16	DIA	ETF	441.86	442.61	437.64	442.36	4219957.0
2025-07-16	GLD	ETF	307.11	311.09	305.73	308.26	17739308.0
2025-07-16	TLT	ETF	85.275	85.6566	84.19	85.13	65940603.0
2025-07-16	AAA	ETF	24.93	24.99	24.91	24.95	9210.0
2025-07-16	AAAU	ETF	32.96	33.35	32.78	33.06	4112523.0
2025-07-16	AADR	ETF	78.145	78.6183	78.01	78.335	10292.0
2025-07-16	AAPB	ETF	21.08	21.4678	20.7318	21.02	245819.0
2025-07-16	AAPD	ETF	17.15	17.27	16.9699	17.15	1006651.0
2025-07-16	AAPR	ETF	27.32	27.335	27.32	27.335	1551.0
2025-07-16	AAPU	ETF	22.9	23.37	22.56	22.89	3495280.0
2025-07-16	AAPW	ETF	35.885	36.3	35.62	35.9287	51680.0
2025-07-16	AAPX	ETF	19.78	20.1536	19.5296	19.77	198124.0
2025-07-16	AAPY	ETF	21.707	21.76	21.63	21.6864	3271.0
2025-07-16	AAVM	ETF	26.585	26.585	26.585	26.585	79.0
2025-07-16	AAXJ	ETF	83.57	84.16	83.32	84.13	934412.0
2025-07-16	ABCS	ETF	28.83	28.8313	28.59	28.8313	2979.0
2025-07-16	ABEQ	ETF	33.95	34.0799	33.95	34.06	10707.0
2025-07-16	ABFL	ETF	69.06	69.43	68.92	69.37	17785.0
2025-07-16	ABLD	ETF	28.7303	28.77	28.7303	28.7433	5711.0
2025-07-16	ABLG	ETF	30.29	30.5399	30.29	30.5399	511.0
2025-07-16	ABNY	ETF	59.0	59.4995	58.75	58.85	1367.0
2025-07-16	ABOT	ETF	38.12	38.2511	38.12	38.2511	243.0
2025-07-16	ABXB	ETF	19.45	19.45	19.45	19.45	57.0
2025-07-16	ACES	ETF	27.62	27.62	26.93	27.22	21243.0
2025-07-16	ACGR	ETF	60.3916	60.3916	60.3916	60.3916	3.0
2025-07-16	ACIO	ETF	41.48	41.57	41.25	41.545	261462.0
2025-07-16	ACLC	ETF	72.39	72.64	72.3099	72.6282	5396.0
2025-07-16	ACSI	ETF	62.65	62.7853	62.65	62.7853	1423.0
2025-07-16	ACTV	ETF	31.8	31.9279	31.6	31.9279	4603.0
2025-07-16	ACVF	ETF	47.42	47.47	47.0	47.47	9011.0
2025-07-16	ACVT	ETF	26.27	26.27	26.255	26.255	395.0
2025-07-16	ACWI	ETF	128.94	129.4	128.24	129.34	3138599.0
2025-07-16	ACWV	ETF	116.72	117.31	116.61	117.24	144487.0
2025-07-16	ACWX	ETF	60.54	60.825	60.32	60.82	987854.0
2025-07-16	ADBG	ETF	12.23	12.23	11.82	11.99	29682.0
2025-07-16	ADFI	ETF	8.43	8.53	8.43	8.4978	13767.0
2025-07-16	ADIV	ETF	17.83	17.92	17.8	17.9106	10966.0
2025-07-16	ADME	ETF	48.08	48.37	48.08	48.37	12849.0
2025-07-16	ADPV	ETF	39.6	39.6585	39.2433	39.6585	22398.0
2025-07-16	ADVE	ETF	35.9	35.9247	35.9	35.9247	363.0
2025-07-16	AESR	ETF	19.11	19.155	18.99	19.15	18123.0
2025-07-16	AETH	ETF	43.62	46.0713	43.62	46.0713	4069.0
2025-07-16	AFIF	ETF	9.28	9.33	9.28	9.33	112791.0
2025-07-16	AFIX	ETF	24.7633	24.82	24.74	24.775	4247.0
2025-07-16	AFK	ETF	20.59	20.7799	20.585	20.75	4960.0
2025-07-16	AFLG	ETF	36.31	36.33	35.95	36.32	50573.0
2025-07-16	AFMC	ETF	32.18	32.18	31.79	32.16	12336.0

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

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