PREVIEW / etf_daily / 2025-01-06

all etf daily files

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

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-06	SPY	ETF	596.27	599.7	593.6	595.36	46787965.0
2025-01-06	QQQ	ETF	524.02	527.92	522.03	524.54	36109734.0
2025-01-06	IWM	ETF	225.76	227.17	224.14	224.52	22064713.0
2025-01-06	DIA	ETF	428.86	431.12	426.08	427.13	3231879.0
2025-01-06	GLD	ETF	242.33	243.79	242.05	243.19	3693002.0
2025-01-06	TLT	ETF	87.05	87.23	86.67	86.9	30152628.0
2025-01-06	AAA	ETF	25.15	25.15	25.0796	25.15	15018.0
2025-01-06	AAAU	ETF	25.97	26.115	25.924	26.045	2754790.0
2025-01-06	AADR	ETF	71.89	71.9	71.1719	71.28	4724.0
2025-01-06	AAPB	ETF	32.07	32.85	31.9712	32.29	105001.0
2025-01-06	AAPD	ETF	15.66	15.6704	15.4694	15.61	556035.0
2025-01-06	AAPR	ETF	26.55	26.55	26.46	26.4801	2225.0
2025-01-06	AAPU	ETF	35.8	36.68	35.7044	35.97	732846.0
2025-01-06	AAPX	ETF	30.6	31.33	30.55	30.77	28781.0
2025-01-06	AAPY	ETF	26.68	26.96	26.67	26.7204	5831.0
2025-01-06	AAXJ	ETF	73.36	73.64	72.785	72.83	338362.0
2025-01-06	ABCS	ETF	29.06	29.0824	28.78	28.78	2009.0
2025-01-06	ABEQ	ETF	31.59	31.7399	31.4878	31.4878	4246.0
2025-01-06	ABFL	ETF	67.59	67.59	67.39	67.39	10715.0
2025-01-06	ABHY	ETF	19.02	19.0431	19.02	19.0431	224.0
2025-01-06	ABLD	ETF	28.4506	28.4506	28.249	28.249	5798.0
2025-01-06	ABLG	ETF	28.96	28.96	28.8532	28.8983	8098.0
2025-01-06	ABNY	ETF	77.5	77.5	76.2	76.5375	3877.0
2025-01-06	ABOT	ETF	37.08	37.0902	36.87	36.9129	6726.0
2025-01-06	ACES	ETF	28.3	28.64	28.005	28.03	22149.0
2025-01-06	ACGR	ETF	59.19	59.2222	59.19	59.2222	635.0
2025-01-06	ACIO	ETF	40.72	40.8591	40.53	40.62	129308.0
2025-01-06	ACLC	ETF	72.29	72.3593	71.631	71.8139	6202.0
2025-01-06	ACSI	ETF	61.2716	61.2716	61.2716	61.2716	63.0
2025-01-06	ACT	ETF	32.34	32.41	31.635	31.72	369740.0
2025-01-06	ACTV	ETF	33.0076	33.02	32.7179	32.7179	3067.0
2025-01-06	ACVF	ETF	44.52	44.8	44.3994	44.3994	5471.0
2025-01-06	ACWI	ETF	119.53	120.1	119.03	119.31	3330888.0
2025-01-06	ACWV	ETF	109.33	109.34	108.56	108.67	81632.0
2025-01-06	ACWX	ETF	52.69	53.025	52.65	52.72	2253188.0
2025-01-06	ADFI	ETF	8.3967	8.4	8.3739	8.3884	20443.0
2025-01-06	ADIV	ETF	15.35	15.365	15.35	15.365	1643.0
2025-01-06	ADME	ETF	47.65	47.6699	47.29	47.31	13000.0
2025-01-06	ADPV	ETF	37.16	37.16	36.7	36.7529	21465.0
2025-01-06	ADVE	ETF	32.32	32.32	32.1347	32.1347	192.0
2025-01-06	AESR	ETF	17.81	17.81	17.7137	17.7152	13489.0
2025-01-06	AETH	ETF	37.17	37.21	36.69	37.0555	8999.0
2025-01-06	AFIF	ETF	9.19	9.19	9.1428	9.165	60183.0
2025-01-06	AFIX	ETF	24.47	24.47	24.47	24.47	392.0
2025-01-06	AFK	ETF	16.3	16.3599	15.93	16.05	16681.0
2025-01-06	AFLG	ETF	35.2091	35.339	35.02	35.12	43267.0
2025-01-06	AFMC	ETF	32.04	32.26	31.96	31.99	2144.0
2025-01-06	AFSM	ETF	30.54	30.5783	30.2602	30.2893	3332.0
2025-01-06	AGG	ETF	96.72	96.7999	96.58	96.71	8765057.0
2025-01-06	AGGH	ETF	20.52	20.57	20.4	20.47	74834.0

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

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