PREVIEW / etf_daily / 2025-02-27

all etf daily files

  file:    by_date/etf_daily/2025/2025-02-27.parquet
  size:    150 KB
  rows:    3,976

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-02-27	SPY	ETF	596.85	598.02	584.65	585.05	73463162.0
2025-02-27	QQQ	ETF	518.13	519.0699	500.05	500.27	52447966.0
2025-02-27	IWM	ETF	215.64	216.49	212.22	212.39	28958915.0
2025-02-27	DIA	ETF	434.44	438.75	432.1	432.35	3117817.0
2025-02-27	GLD	ETF	266.49	266.67	264.4475	264.93	9125378.0
2025-02-27	TLT	ETF	91.31	91.79	91.14	91.31	52579345.0
2025-02-27	AAA	ETF	25.1	25.12	25.04	25.09	39648.0
2025-02-27	AAAU	ETF	28.6	28.6257	28.3399	28.41	1397107.0
2025-02-27	AADR	ETF	75.25	75.43	74.5499	74.75	4708.0
2025-02-27	AAPB	ETF	30.26	30.92	29.62	29.7	80013.0
2025-02-27	AAPD	ETF	15.94	16.095	15.75	16.09	1104685.0
2025-02-27	AAPR	ETF	26.59	26.59	26.49	26.51	6257.0
2025-02-27	AAPU	ETF	33.57	34.38	32.89	32.95	701806.0
2025-02-27	AAPW	ETF	49.22	49.4092	48.4011	48.4011	2108.0
2025-02-27	AAPX	ETF	28.76	29.32	28.13	28.18	53368.0
2025-02-27	AAPY	ETF	25.5	25.71	25.281	25.281	18103.0
2025-02-27	AAVM	ETF	25.28	25.3	24.9826	24.9826	1298.0
2025-02-27	AAXJ	ETF	75.58	75.77	74.615	74.62	178262.0
2025-02-27	ABCS	ETF	29.02	29.02	28.58	28.6739	3626.0
2025-02-27	ABEQ	ETF	33.09	33.29	33.09	33.1552	4822.0
2025-02-27	ABFL	ETF	68.4312	68.6	67.5118	67.5118	16933.0
2025-02-27	ABHY	ETF	19.3	19.3	19.2601	19.2601	635.0
2025-02-27	ABLD	ETF	29.0	29.0196	28.89	28.89	475.0
2025-02-27	ABLG	ETF	29.95	30.22	29.9387	29.9387	7666.0
2025-02-27	ABNY	ETF	74.95	75.544	72.7	72.75	2865.0
2025-02-27	ABOT	ETF	35.9662	35.9662	35.9662	35.9662	593.0
2025-02-27	ACES	ETF	24.65	24.7293	24.02	24.06	71527.0
2025-02-27	ACGR	ETF	56.05	56.05	54.9564	54.9564	351.0
2025-02-27	ACIO	ETF	40.54	40.64	40.0	40.0	187069.0
2025-02-27	ACLC	ETF	70.53	70.53	69.2639	69.2639	3706.0
2025-02-27	ACSI	ETF	61.7846	61.7846	61.7846	61.7846	33.0
2025-02-27	ACT	ETF	33.58	34.015	33.26	33.96	341711.0
2025-02-27	ACTV	ETF	32.3	32.3	31.95	31.95	3471.0
2025-02-27	ACVF	ETF	45.08	45.2399	44.3649	44.3649	6398.0
2025-02-27	ACWI	ETF	121.68	121.8	119.61	119.67	2306139.0
2025-02-27	ACWV	ETF	114.37	114.9	114.01	114.35	68690.0
2025-02-27	ACWX	ETF	55.88	55.94	55.35	55.38	1635116.0
2025-02-27	ADFI	ETF	8.52	8.54	8.52	8.525	32590.0
2025-02-27	ADIV	ETF	15.98	15.98	15.81	15.81	4619.0
2025-02-27	ADME	ETF	47.07	47.26	46.47	46.47	12449.0
2025-02-27	ADPV	ETF	37.88	38.14	36.9326	36.9326	12639.0
2025-02-27	ADVE	ETF	32.68	32.68	32.4606	32.4606	3186.0
2025-02-27	AESR	ETF	17.72	17.8	17.44	17.44	45829.0
2025-02-27	AETH	ETF	31.28	31.29	31.23	31.265	2507.0
2025-02-27	AFIF	ETF	9.24	9.25	9.23	9.25	8429.0
2025-02-27	AFIX	ETF	24.96	24.9803	24.96	24.9803	498.0
2025-02-27	AFK	ETF	16.74	16.75	16.48	16.57	10345.0
2025-02-27	AFLG	ETF	35.46	35.52	34.8	34.8	40659.0
2025-02-27	AFMC	ETF	31.91	31.91	31.405	31.42	6331.0
2025-02-27	AFSC	ETF	27.3591	27.3591	27.3591	27.3591	1.0

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

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