PREVIEW / etf_daily / 2025-03-17

all etf daily files

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

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-17	SPY	ETF	562.79	569.71	562.35	567.15	47999670.0
2025-03-17	QQQ	ETF	479.61	485.84	477.8	482.77	41744354.0
2025-03-17	IWM	ETF	202.71	206.02	202.6	205.45	26719361.0
2025-03-17	DIA	ETF	414.94	420.7803	414.84	419.21	2098143.0
2025-03-17	GLD	ETF	275.54	276.79	275.39	276.73	8516968.0
2025-03-17	TLT	ETF	90.8	91.18	90.38	90.62	26463414.0
2025-03-17	AAA	ETF	25.07	25.09	24.93	24.99	59701.0
2025-03-17	AAAU	ETF	29.53	29.66	29.52	29.655	1600142.0
2025-03-17	AADR	ETF	77.64	78.77	77.64	78.3889	33190.0
2025-03-17	AAPB	ETF	23.58	24.1286	23.0	23.88	98952.0
2025-03-17	AAPD	ETF	17.87	18.135	17.6949	17.8	1511201.0
2025-03-17	AAPR	ETF	26.219	26.2316	26.15	26.2249	12584.0
2025-03-17	AAPU	ETF	26.34	26.769	25.47	26.51	886799.0
2025-03-17	AAPW	ETF	41.979	42.09	41.635	41.942	3366.0
2025-03-17	AAPX	ETF	22.51	22.877	21.8374	22.69	50605.0
2025-03-17	AAPY	ETF	23.0	23.0	22.63	22.9706	4407.0
2025-03-17	AAVM	ETF	24.63	24.8501	24.63	24.815	2961.0
2025-03-17	AAXJ	ETF	76.08	77.165	76.03	77.09	515829.0
2025-03-17	ABCS	ETF	27.69	27.94	27.69	27.8864	3110.0
2025-03-17	ABEQ	ETF	33.63	33.82	33.55	33.82	70846.0
2025-03-17	ABFL	ETF	64.3996	65.21	64.3996	64.95	227006.0
2025-03-17	ABHY	ETF	19.1	19.115	19.1	19.115	1209.0
2025-03-17	ABLD	ETF	28.455	28.68	28.455	28.6607	6524.0
2025-03-17	ABLG	ETF	29.39	29.71	29.39	29.6261	2276472.0
2025-03-17	ABNY	ETF	64.2	64.5495	63.5505	64.1005	2919.0
2025-03-17	ABOT	ETF	34.6664	35.004	34.6664	34.8993	793.0
2025-03-17	ACES	ETF	23.07	23.75	23.07	23.62	32881.0
2025-03-17	ACGR	ETF	52.75	52.76	52.5305	52.5305	2234.0
2025-03-17	ACIO	ETF	38.88	39.21	38.8075	39.05	101619.0
2025-03-17	ACLC	ETF	66.08	66.99	66.08	66.7187	2932.0
2025-03-17	ACSI	ETF	58.8	59.0813	58.8	59.0813	369.0
2025-03-17	ACT	ETF	33.22	33.5	32.99	33.45	158858.0
2025-03-17	ACTV	ETF	31.14	31.565	31.14	31.4943	4305.0
2025-03-17	ACVF	ETF	42.82	43.31	42.82	43.31	3080.0
2025-03-17	ACWI	ETF	117.63	119.045	117.56	118.62	1387546.0
2025-03-17	ACWV	ETF	114.57	116.07	114.57	115.92	212529.0
2025-03-17	ACWX	ETF	56.65	57.4	56.65	57.35	1519178.0
2025-03-17	ADFI	ETF	8.47	8.51	8.47	8.49	15366.0
2025-03-17	ADIV	ETF	15.92	16.2	15.92	16.0529	9138.0
2025-03-17	ADME	ETF	44.37	45.095	44.37	44.95	7376.0
2025-03-17	ADPV	ETF	34.65	35.2143	34.63	35.01	10452.0
2025-03-17	ADVE	ETF	33.4	33.47	33.4	33.4122	8744.0
2025-03-17	AESR	ETF	16.56	16.67	16.49	16.61	29516.0
2025-03-17	AETH	ETF	31.3019	31.31	31.29	31.31	446.0
2025-03-17	AFIF	ETF	9.22	9.22	9.18	9.1952	12142.0
2025-03-17	AFIX	ETF	24.94	25.0	24.94	24.955	22630.0
2025-03-17	AFK	ETF	17.34	17.39	17.142	17.35	16596.0
2025-03-17	AFLG	ETF	33.74	34.01	33.64	33.88	49006.0
2025-03-17	AFMC	ETF	30.27	30.64	30.27	30.6	13576.0
2025-03-17	AFSC	ETF	26.01	26.15	26.01	26.15	305.0

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

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