PREVIEW / etf_daily / 2026-07-27

all etf daily files

  file:    by_date/etf_daily/2026/2026-07-27.parquet
  size:    158 KB
  rows:    4,164

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
2026-07-27	SPY	ETF	744.91	745.53	735.87	739.09	41461194.0
2026-07-27	QQQ	ETF	691.68	692.3	675.945	682.12	42681473.0
2026-07-27	IWM	ETF	293.98	295.52	291.1101	292.91	19445522.0
2026-07-27	DIA	ETF	524.7	525.34	519.29	521.26	3355180.0
2026-07-27	GLD	ETF	373.89	375.53	372.91	374.63	3699961.0
2026-07-27	TLT	ETF	83.73	83.87	83.52	83.75	23818953.0
2026-07-27	AAA	ETF	24.96	25.005	24.9	24.98	5131.0
2026-07-27	AAAU	ETF	40.19	40.36	40.08	40.26	662833.0
2026-07-27	AADR	ETF	82.65	82.65	82.65	82.65	521.0
2026-07-27	AAOG	ETF	2.82	2.94	2.36	2.6658	1304839.0
2026-07-27	AAOX	ETF	12.62	13.2	10.5112	11.89	4193358.0
2026-07-27	AAPB	ETF	44.84	46.16	44.84	45.5288	69519.0
2026-07-27	AAPD	ETF	10.425	10.4601	10.29	10.36	13110004.0
2026-07-27	AAPR	ETF	29.43	29.455	29.43	29.455	1153.0
2026-07-27	AAPU	ETF	46.3	47.5096	46.02	46.8	1554323.0
2026-07-27	AAPW	ETF	43.35	43.87	43.09	43.5798	14368.0
2026-07-27	AAPX	ETF	41.65	42.88	41.64	42.2568	32240.0
2026-07-27	AAPY	ETF	28.27	28.67	28.26	28.43	9443.0
2026-07-27	AAVM	ETF	33.52	33.53	33.45	33.4781	1179.0
2026-07-27	AAXJ	ETF	111.53	111.53	108.95	110.17	326145.0
2026-07-27	ABCS	ETF	35.04	35.055	34.99	35.055	2210.0
2026-07-27	ABEQ	ETF	38.13	38.18	38.1	38.1695	18980.0
2026-07-27	ABFL	ETF	82.47	82.47	81.48	82.13	9486.0
2026-07-27	ABLD	ETF	30.62	30.65	30.56	30.6288	6216.0
2026-07-27	ABLG	ETF	30.4901	30.6403	30.4901	30.6403	153.0
2026-07-27	ABOT	ETF	40.26	40.352	40.26	40.352	116.0
2026-07-27	ABXB	ETF	19.095	19.1142	19.095	19.1142	996.0
2026-07-27	ACES	ETF	30.86	30.92	30.2	30.74	10886.0
2026-07-27	ACGR	ETF	65.5	65.7293	65.4999	65.7293	214.0
2026-07-27	ACIO	ETF	45.965	46.04	45.5	45.66	143475.0
2026-07-27	ACLC	ETF	83.29	83.34	82.88	83.2378	6195.0
2026-07-27	ACSG	ETF	48.06	48.13	47.73	48.13	437.0
2026-07-27	ACVF	ETF	53.79	53.79	53.2	53.4298	3444.0
2026-07-27	ACWI	ETF	155.69	155.79	153.85	154.61	2723743.0
2026-07-27	ACWV	ETF	123.21	123.53	123.0683	123.25	96383.0
2026-07-27	ACWX	ETF	74.92	74.92	73.9329	74.43	2697356.0
2026-07-27	ACYN	ETF	20.58	20.6399	20.52	20.56	1106817.0
2026-07-27	ADBG	ETF	3.67	4.05	3.67	3.9	7441689.0
2026-07-27	ADIV	ETF	19.23	19.32	19.23	19.32	1982.0
2026-07-27	ADME	ETF	54.94	54.9401	54.65	54.7948	8386.0
2026-07-27	ADPV	ETF	45.61	45.61	45.23	45.51	6149.0
2026-07-27	ADVE	ETF	45.085	45.3694	45.085	45.3694	639.0
2026-07-27	AESR	ETF	19.5	19.61	19.39	19.56	34219.0
2026-07-27	AETH	ETF	31.35	31.74	31.35	31.7362	2089.0
2026-07-27	AFIF	ETF	9.37	9.4	9.37	9.38	570164.0
2026-07-27	AFIX	ETF	24.42	24.45	24.42	24.4479	67841.0
2026-07-27	AFK	ETF	25.87	25.925	25.53	25.72	19456.0
2026-07-27	AFLG	ETF	43.68	43.82	43.3282	43.48	80422.0
2026-07-27	AFMC	ETF	40.82	40.8799	40.4001	40.67	41913.0
2026-07-27	AFSC	ETF	37.8009	37.8009	37.8009	37.8009	162.0

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

> register free to download (covers the last year of daily data)