PREVIEW / etf_daily / 2025-06-09

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-09.parquet
  size:    154 KB
  rows:    4,134

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-09	SPY	ETF	599.72	601.25	598.49	599.68	52918904.0
2025-06-09	QQQ	ETF	530.14	532.35	529.01	530.7	33688671.0
2025-06-09	IWM	ETF	213.87	214.28	212.55	213.36	34579233.0
2025-06-09	DIA	ETF	428.52	429.72	426.43	428.36	2676851.0
2025-06-09	GLD	ETF	305.39	307.61	305.06	306.62	7124582.0
2025-06-09	TLT	ETF	85.04	85.64	85.035	85.44	26442304.0
2025-06-09	AAA	ETF	24.98	24.99	24.92	24.9593	17834.0
2025-06-09	AAAU	ETF	32.73	32.9752	32.71	32.86	2224072.0
2025-06-09	AADR	ETF	79.09	79.09	77.67	78.46	2182.0
2025-06-09	AAPB	ETF	20.14	20.49	19.32	19.58	382220.0
2025-06-09	AAPD	ETF	17.69	18.055	17.54	17.93	3201393.0
2025-06-09	AAPR	ETF	26.9332	26.9332	26.9332	26.9332	87.0
2025-06-09	AAPU	ETF	22.06	22.39	21.1	21.42	6413078.0
2025-06-09	AAPW	ETF	36.49	36.67	35.5632	35.86	13247.0
2025-06-09	AAPX	ETF	19.0	19.28	18.2	18.46	257451.0
2025-06-09	AAPY	ETF	21.62	21.85	21.27	21.2956	13012.0
2025-06-09	AAVM	ETF	26.47	26.48	26.4	26.4	6689.0
2025-06-09	AAXJ	ETF	80.72	81.06	80.575	80.92	290490.0
2025-06-09	ABCS	ETF	28.2898	28.32	28.18	28.3157	6329.0
2025-06-09	ABEQ	ETF	34.33	34.41	34.1101	34.2916	21736.0
2025-06-09	ABFL	ETF	70.502	70.5199	70.2689	70.2689	13283.0
2025-06-09	ABLD	ETF	28.37	28.54	28.36	28.4105	4722.0
2025-06-09	ABLG	ETF	31.06	31.0913	31.06	31.0913	291.0
2025-06-09	ABNY	ETF	61.8925	61.95	61.2	61.4945	1486.0
2025-06-09	ABOT	ETF	38.01	38.02	37.9336	37.9336	6291.0
2025-06-09	ABXB	ETF	19.51	19.51	19.51	19.51	7.0
2025-06-09	ACES	ETF	24.94	25.42	24.82	25.22	68330.0
2025-06-09	ACGR	ETF	57.6951	57.6951	57.6951	57.6951	170.0
2025-06-09	ACIO	ETF	40.64	40.7	40.52	40.56	499678.0
2025-06-09	ACLC	ETF	70.3929	70.46	70.33	70.36	3137.0
2025-06-09	ACSI	ETF	62.28	62.3	62.28	62.2808	2622.0
2025-06-09	ACT	ETF	34.53	34.62	33.95	34.25	478411.0
2025-06-09	ACTV	ETF	31.11	31.21	31.11	31.1382	6917.0
2025-06-09	ACVF	ETF	45.97	45.97	45.68	45.7949	4421.0
2025-06-09	ACVT	ETF	25.84	25.87	25.82	25.82	1491.0
2025-06-09	ACWI	ETF	125.79	126.26	125.67	125.92	1253442.0
2025-06-09	ACWV	ETF	118.62	118.62	117.8014	118.25	49628.0
2025-06-09	ACWX	ETF	60.58	60.836	60.51	60.65	970018.0
2025-06-09	ADBG	ETF	16.32	16.48	16.2	16.29	18783.0
2025-06-09	ADFI	ETF	8.53	8.53	8.41	8.445	13587.0
2025-06-09	ADIV	ETF	17.02	17.13	17.02	17.07	4249.0
2025-06-09	ADME	ETF	47.06	47.06	46.825	46.905	16177.0
2025-06-09	ADPV	ETF	34.58	34.79	34.58	34.6522	11902.0
2025-06-09	ADVE	ETF	35.08	35.2687	35.06	35.1677	4091.0
2025-06-09	AESR	ETF	18.24	18.34	18.23	18.25	20335.0
2025-06-09	AETH	ETF	38.38	39.12	38.37	39.0989	1817.0
2025-06-09	AFIF	ETF	9.26	9.2798	9.26	9.275	7462.0
2025-06-09	AFIX	ETF	24.61	24.61	24.61	24.61	138.0
2025-06-09	AFK	ETF	19.76	19.95	19.67	19.89	13737.0
2025-06-09	AFLG	ETF	35.66	35.66	35.45	35.45	45351.0

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

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