PREVIEW / etf_daily / 2025-03-20

all etf daily files

  file:    by_date/etf_daily/2025/2025-03-20.parquet
  size:    151 KB
  rows:    4,003

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-03-20	SPY	ETF	563.33	570.57	562.6012	565.49	60469759.0
2025-03-20	QQQ	ETF	476.88	484.55	476.18	479.26	36780549.0
2025-03-20	IWM	ETF	204.32	207.3	204.195	205.06	25768257.0
2025-03-20	DIA	ETF	417.92	423.14	417.64	420.12	1520601.0
2025-03-20	GLD	ETF	279.49	280.9	279.43	280.75	6296774.0
2025-03-20	TLT	ETF	92.2	92.24	91.155	91.24	34688383.0
2025-03-20	AAA	ETF	25.02	25.07	25.0001	25.07	12855.0
2025-03-20	AAAU	ETF	29.95	30.1	29.93	30.085	732426.0
2025-03-20	AADR	ETF	77.26	77.38	76.87	77.04	3721.0
2025-03-20	AAPB	ETF	23.96	24.6351	23.48	23.87	123471.0
2025-03-20	AAPD	ETF	17.83	17.95	17.53	17.79	1154952.0
2025-03-20	AAPR	ETF	26.24	26.24	26.19	26.2041	12766.0
2025-03-20	AAPU	ETF	26.41	27.2972	25.9998	26.46	697797.0
2025-03-20	AAPW	ETF	42.655	42.655	42.0015	42.0015	1289.0
2025-03-20	AAPX	ETF	22.61	23.22	22.26	22.66	52965.0
2025-03-20	AAPY	ETF	22.835	23.0	22.6306	22.7088	1591.0
2025-03-20	AAVM	ETF	24.81	24.91	24.81	24.865	1208.0
2025-03-20	AAXJ	ETF	75.88	76.24	75.71	76.08	294181.0
2025-03-20	ABCS	ETF	28.13	28.13	27.931	27.931	2729.0
2025-03-20	ABEQ	ETF	33.71	33.8	33.665	33.7999	7095.0
2025-03-20	ABFL	ETF	65.27	65.27	64.6175	64.75	11202.0
2025-03-20	ABHY	ETF	19.19	19.195	19.19	19.195	621.0
2025-03-20	ABLD	ETF	28.62	28.634	28.525	28.5317	5914.0
2025-03-20	ABLG	ETF	29.2	29.3198	29.121	29.31	9557.0
2025-03-20	ABNY	ETF	64.8	64.8	64.248	64.374	576.0
2025-03-20	ABOT	ETF	34.78	34.9794	34.7541	34.7541	639.0
2025-03-20	ACES	ETF	23.48	23.79	23.47	23.53	11941.0
2025-03-20	ACGR	ETF	52.1733	52.1733	52.1733	52.1733	82.0
2025-03-20	ACIO	ETF	38.86	39.16	38.7945	38.9	138672.0
2025-03-20	ACLC	ETF	66.07	66.95	66.07	66.46	7417.0
2025-03-20	ACSI	ETF	58.7651	58.7651	58.7651	58.7651	61.0
2025-03-20	ACT	ETF	33.73	34.31	33.73	33.97	188106.0
2025-03-20	ACTV	ETF	31.36	31.4701	31.33	31.3619	5000.0
2025-03-20	ACVF	ETF	43.05	43.48	43.05	43.224	4917.0
2025-03-20	ACWI	ETF	117.63	118.855	117.54	118.23	2269007.0
2025-03-20	ACWV	ETF	115.18	115.55	114.91	115.34	459388.0
2025-03-20	ACWX	ETF	56.64	57.03	56.6	56.98	1783672.0
2025-03-20	ADFI	ETF	8.53	8.56	8.5	8.55	21642.0
2025-03-20	ADIV	ETF	15.7065	15.74	15.705	15.705	3364.0
2025-03-20	ADME	ETF	44.56	45.01	44.56	44.67	7864.0
2025-03-20	ADPV	ETF	34.35	34.379	34.33	34.355	3897.0
2025-03-20	ADVE	ETF	33.19	33.21	33.1629	33.1629	2417.0
2025-03-20	AESR	ETF	16.55	16.64	16.55	16.6	23003.0
2025-03-20	AETH	ETF	31.34	31.34	31.34	31.34	462.0
2025-03-20	AFIF	ETF	9.21	9.23	9.18	9.23	34635.0
2025-03-20	AFIX	ETF	25.09	25.09	25.0391	25.0391	8971.0
2025-03-20	AFK	ETF	17.56	17.825	17.45	17.56	6449.0
2025-03-20	AFLG	ETF	33.76	34.0156	33.75	33.8	24087.0
2025-03-20	AFMC	ETF	30.696	30.99	30.67	30.69	6762.0
2025-03-20	AFSC	ETF	26.51	26.51	26.29	26.29	968.0

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

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