PREVIEW / etf_daily / 2026-08-18

all etf daily files

  file:    by_date/etf_daily/2026/2026-08-18.parquet
  size:    157 KB
  rows:    4,151

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-08-18	SPY	ETF	768.7	769.5	766.92	767.45	43920908.0
2026-08-18	QQQ	ETF	720.21	722.13	715.92	717.51	48997172.0
2026-08-18	IWM	ETF	302.45	303.15	300.11	300.23	18263746.0
2026-08-18	DIA	ETF	533.38	534.26	532.02	532.91	3825717.0
2026-08-18	GLD	ETF	402.55	404.32	397.87	398.55	10660892.0
2026-08-18	TLT	ETF	81.26	81.75	81.17	81.66	25037129.0
2026-08-18	AAA	ETF	24.93	24.95	24.93	24.95	2581.0
2026-08-18	AAAU	ETF	43.29	43.44	42.775	42.85	1145924.0
2026-08-18	AADR	ETF	85.4	85.4	83.5	84.0894	1461.0
2026-08-18	AAOG	ETF	5.02	5.44	3.99	4.0	3983906.0
2026-08-18	AAOX	ETF	22.8	24.45	17.855	17.92	10524286.0
2026-08-18	AAPB	ETF	37.6	38.47	37.13	38.22	121257.0
2026-08-18	AAPD	ETF	11.3	11.37	11.17	11.21	7677748.0
2026-08-18	AAPU	ETF	38.54	39.5	38.064	39.17	1889743.0
2026-08-18	AAPW	ETF	38.34	38.961	38.34	38.82	7441.0
2026-08-18	AAPX	ETF	34.8	35.6	34.372	35.33	45531.0
2026-08-18	AAPY	ETF	25.65	26.06	25.65	26.01	5205.0
2026-08-18	AAVM	ETF	34.525	34.525	34.4794	34.4794	1112.0
2026-08-18	AAXJ	ETF	114.77	115.18	113.31	113.55	342332.0
2026-08-18	ABCS	ETF	36.295	36.32	36.0182	36.0182	1742.0
2026-08-18	ABEQ	ETF	38.83	38.8499	38.725	38.725	9495.0
2026-08-18	ABFL	ETF	83.73	83.95	83.42	83.42	10124.0
2026-08-18	ABLD	ETF	32.73	32.73	32.35	32.4	21234.0
2026-08-18	ABLG	ETF	31.8	31.8	31.58	31.58	9972.0
2026-08-18	ABOT	ETF	43.75	43.75	43.4553	43.4553	157.0
2026-08-18	ACES	ETF	31.58	31.77	31.01	31.07	78966.0
2026-08-18	ACIO	ETF	47.17	47.17	47.06	47.07	98083.0
2026-08-18	ACLC	ETF	86.3315	86.39	86.2453	86.2453	11510.0
2026-08-18	ACSG	ETF	50.15	50.15	49.8429	49.8429	406.0
2026-08-18	ACVF	ETF	56.18	56.18	55.8772	55.8772	8106.0
2026-08-18	ACVT	ETF	28.6	28.6	28.5149	28.5149	1095.0
2026-08-18	ACWI	ETF	160.81	160.98	160.055	160.08	2352272.0
2026-08-18	ACWV	ETF	126.09	126.6599	126.03	126.03	51111.0
2026-08-18	ACWX	ETF	77.22	77.475	76.735	76.77	705304.0
2026-08-18	ACYN	ETF	20.75	20.75	20.69	20.7	2339161.0
2026-08-18	ADBG	ETF	4.56	4.81	4.5	4.66	2347571.0
2026-08-18	ADIV	ETF	19.69	19.69	19.5899	19.5899	6626.0
2026-08-18	ADME	ETF	56.5999	56.5999	56.45	56.45	6758.0
2026-08-18	ADPV	ETF	45.44	45.4441	45.42	45.43	1920.0
2026-08-18	ADVE	ETF	45.77	45.77	45.61	45.664	4425.0
2026-08-18	AESR	ETF	20.21	20.21	20.131	20.14	23171.0
2026-08-18	AFIF	ETF	9.43	9.43	9.4	9.42	92472.0
2026-08-18	AFIX	ETF	24.449	24.45	24.4401	24.445	2777.0
2026-08-18	AFK	ETF	27.81	28.05	27.68	27.68	18041.0
2026-08-18	AFLG	ETF	45.02	45.0372	44.835	44.89	63286.0
2026-08-18	AFMC	ETF	41.91	41.91	41.5	41.5	21642.0
2026-08-18	AFSC	ETF	39.2182	39.2182	39.2182	39.2182	131.0
2026-08-18	AFSM	ETF	41.35	41.43	40.895	40.95	77838.0
2026-08-18	AGEM	ETF	48.59	48.59	47.68	47.7616	12892.0
2026-08-18	AGG	ETF	97.19	97.39	97.135	97.35	5965670.0

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

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