PREVIEW / etf_daily / 2025-01-14

all etf daily files

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

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-14	SPY	ETF	584.36	585.0	578.35	582.19	48214409.0
2025-01-14	QQQ	ETF	508.74	510.155	501.59	505.08	33737237.0
2025-01-14	IWM	ETF	219.18	220.225	217.22	219.72	25022231.0
2025-01-14	DIA	ETF	424.88	425.51	421.55	425.15	2616405.0
2025-01-14	GLD	ETF	245.62	247.04	245.52	247.03	5014675.0
2025-01-14	TLT	ETF	85.23	85.36	84.89	85.29	32831930.0
2025-01-14	AAA	ETF	25.14	25.17	25.12	25.14	29383.0
2025-01-14	AAAU	ETF	26.33	26.47	26.305	26.47	1730193.0
2025-01-14	AADR	ETF	70.98	71.395	70.98	71.1249	1622.0
2025-01-14	AAPB	ETF	29.58	29.87	29.1007	29.18	36472.0
2025-01-14	AAPD	ETF	16.3	16.4642	16.2099	16.41	773606.0
2025-01-14	AAPR	ETF	26.3195	26.3195	26.2976	26.2976	1956.0
2025-01-14	AAPU	ETF	32.98	33.32	32.32	32.51	495677.0
2025-01-14	AAPX	ETF	28.37	28.46	27.7	27.82	13365.0
2025-01-14	AAPY	ETF	25.75	25.82	25.5	25.5449	6490.0
2025-01-14	AAXJ	ETF	70.57	70.65	70.18	70.48	488343.0
2025-01-14	ABCS	ETF	28.74	28.8467	28.6399	28.8467	1255.0
2025-01-14	ABEQ	ETF	31.66	31.7848	31.59	31.7848	3714.0
2025-01-14	ABFL	ETF	66.33	66.52	66.2018	66.3817	17573.0
2025-01-14	ABHY	ETF	18.8919	18.9013	18.8713	18.9013	1231.0
2025-01-14	ABLD	ETF	28.66	28.8	28.66	28.793	1151.0
2025-01-14	ABLG	ETF	28.42	28.655	28.42	28.62	18167.0
2025-01-14	ABNY	ETF	71.9	72.45	70.5005	70.7	8951.0
2025-01-14	ABOT	ETF	35.9497	36.0	35.7894	35.7894	352.0
2025-01-14	ACES	ETF	26.95	27.2551	26.43	26.47	55115.0
2025-01-14	ACGR	ETF	57.3599	57.3599	56.58	56.8285	7080.0
2025-01-14	ACIO	ETF	40.01	40.0291	39.72	39.93	125382.0
2025-01-14	ACLC	ETF	70.21	70.41	69.71	70.0521	9690.0
2025-01-14	ACSI	ETF	60.82	60.82	60.5165	60.5165	109.0
2025-01-14	ACT	ETF	31.56	31.99	31.56	31.74	405763.0
2025-01-14	ACTV	ETF	31.97	31.97	31.81	31.907	5703.0
2025-01-14	ACVF	ETF	43.78	43.83	43.4	43.71	8517.0
2025-01-14	ACWI	ETF	117.0	117.0495	116.01	116.68	1796964.0
2025-01-14	ACWV	ETF	107.96	108.24	107.67	108.14	65920.0
2025-01-14	ACWX	ETF	51.69	51.7659	51.445	51.7	917610.0
2025-01-14	ADFI	ETF	8.31	8.32	8.29	8.2994	31101.0
2025-01-14	ADIV	ETF	15.01	15.01	15.01	15.01	4.0
2025-01-14	ADME	ETF	46.555	46.62	46.1209	46.43	22159.0
2025-01-14	ADPV	ETF	35.71	36.0751	35.65	35.8176	2981.0
2025-01-14	ADVE	ETF	31.0982	31.0982	31.0982	31.0982	297.0
2025-01-14	AESR	ETF	17.2684	17.27	17.16	17.21	20471.0
2025-01-14	AETH	ETF	32.69	32.75	32.6705	32.7298	2535.0
2025-01-14	AFIF	ETF	9.14	9.2	9.14	9.17	108412.0
2025-01-14	AFIX	ETF	24.2321	24.2321	24.2321	24.2321	200000.0
2025-01-14	AFK	ETF	15.88	15.88	15.62	15.87	51705.0
2025-01-14	AFLG	ETF	34.62	34.6635	34.387	34.63	129059.0
2025-01-14	AFMC	ETF	31.88	32.2	31.88	32.2	31642.0
2025-01-14	AFSM	ETF	30.03	30.1	29.7031	30.0676	7968.0
2025-01-14	AGG	ETF	95.86	95.93	95.7501	95.88	5329820.0
2025-01-14	AGGH	ETF	20.22	20.32	20.0501	20.11	69241.0

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

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