PREVIEW / etf_daily / 2025-06-20

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-20.parquet
  size:    156 KB
  rows:    4,155

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-06-20	SPY	ETF	598.38	599.46	592.86	594.28	94028251.0
2025-06-20	QQQ	ETF	532.26	533.56	524.88	526.83	61643519.0
2025-06-20	IWM	ETF	211.11	211.25	208.46	209.21	36981913.0
2025-06-20	DIA	ETF	423.37	424.15	420.72	421.76	3809018.0
2025-06-20	GLD	ETF	309.33	310.89	309.25	310.13	8791840.0
2025-06-20	TLT	ETF	86.14	86.79	85.95	86.49	25999430.0
2025-06-20	AAA	ETF	25.08	25.08	24.99	25.0	12341.0
2025-06-20	AAAU	ETF	33.17	33.33	33.15	33.25	1984736.0
2025-06-20	AADR	ETF	76.96	76.96	76.155	76.45	3544.0
2025-06-20	AAPB	ETF	18.79	19.5	18.61	19.39	227176.0
2025-06-20	AAPD	ETF	18.25	18.3801	17.94	18.0	1243545.0
2025-06-20	AAPR	ETF	26.91	26.95	26.91	26.9272	766.0
2025-06-20	AAPU	ETF	20.59	21.33	20.35	21.17	4345238.0
2025-06-20	AAPW	ETF	35.0	35.42	34.609	35.42	12878.0
2025-06-20	AAPX	ETF	17.73	18.36	17.5118	18.245	175699.0
2025-06-20	AAPY	ETF	20.925	21.07	20.7512	21.035	2155.0
2025-06-20	AAVM	ETF	26.31	26.31	26.29	26.2952	842.0
2025-06-20	AAXJ	ETF	80.38	80.435	79.47	79.53	1134564.0
2025-06-20	ABCS	ETF	28.25	28.28	28.115	28.1515	2900.0
2025-06-20	ABEQ	ETF	34.38	34.38	34.22	34.22	13951.0
2025-06-20	ABFL	ETF	68.94	68.94	68.33	68.45	10482.0
2025-06-20	ABLD	ETF	28.55	28.58	28.41	28.4352	4330.0
2025-06-20	ABLG	ETF	30.21	30.21	30.2006	30.2006	3246.0
2025-06-20	ABNY	ETF	59.25	59.3	58.7	59.3	1407.0
2025-06-20	ABOT	ETF	37.1823	37.1823	37.1823	37.1823	186.0
2025-06-20	ABXB	ETF	19.6097	19.6097	19.6097	19.6097	6.0
2025-06-20	ACES	ETF	25.54	25.6	24.96	24.96	203549.0
2025-06-20	ACGR	ETF	56.77	56.8735	56.77	56.8735	889.0
2025-06-20	ACIO	ETF	40.53	40.6051	40.3414	40.38	144868.0
2025-06-20	ACLC	ETF	69.9165	69.9165	69.6177	69.6177	3379.0
2025-06-20	ACSI	ETF	61.5123	61.5123	61.5123	61.5123	90.0
2025-06-20	ACT	ETF	36.05	36.36	35.91	36.28	1823932.0
2025-06-20	ACTV	ETF	31.0	31.0	30.88	30.888	331.0
2025-06-20	ACVF	ETF	45.85	45.85	45.3969	45.4681	2923.0
2025-06-20	ACVT	ETF	25.86	25.86	25.84	25.84	341.0
2025-06-20	ACWI	ETF	124.59	124.76	123.57	123.74	2793478.0
2025-06-20	ACWV	ETF	116.29	116.39	115.8	115.95	163176.0
2025-06-20	ACWX	ETF	59.47	59.47	58.805	58.81	807873.0
2025-06-20	ADBG	ETF	13.465	13.55	12.94	13.21	50416.0
2025-06-20	ADFI	ETF	8.41	8.51	8.41	8.51	21912.0
2025-06-20	ADIV	ETF	17.18	17.2	17.04	17.04	4446.0
2025-06-20	ADME	ETF	46.785	46.8719	46.5801	46.6482	12648.0
2025-06-20	ADPV	ETF	35.64	35.64	35.33	35.3736	3571.0
2025-06-20	ADVE	ETF	34.8204	34.8204	34.8204	34.8204	160.0
2025-06-20	AESR	ETF	18.41	18.41	18.2238	18.23	21526.0
2025-06-20	AETH	ETF	35.615	35.615	35.615	35.615	102.0
2025-06-20	AFIF	ETF	9.24	9.2799	9.22	9.25	322361.0
2025-06-20	AFIX	ETF	24.8049	24.8049	24.8049	24.8049	144.0
2025-06-20	AFK	ETF	19.38	19.4999	19.12	19.49	10651.0
2025-06-20	AFLG	ETF	35.39	35.39	35.0801	35.17	223872.0

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

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