PREVIEW / etf_daily / 2025-05-27

all etf daily files

  file:    by_date/etf_daily/2025/2025-05-27.parquet
  size:    155 KB
  rows:    4,121

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-05-27	SPY	ETF	586.07	591.31	578.43	591.15	72451986.0
2025-05-27	QQQ	ETF	516.15	521.71	514.59	521.22	47226323.0
2025-05-27	IWM	ETF	205.64	207.75	204.16	207.7	32683365.0
2025-05-27	DIA	ETF	420.7	423.86	419.19	423.85	3121423.0
2025-05-27	GLD	ETF	303.81	304.875	302.74	304.5	9578320.0
2025-05-27	TLT	ETF	85.35	86.025	85.15	85.73	56743000.0
2025-05-27	AAA	ETF	24.93	24.9749	24.87	24.8904	7634.0
2025-05-27	AAAU	ETF	32.59	32.68	32.46	32.645	1787300.0
2025-05-27	AADR	ETF	81.17	81.17	79.86	80.1	1490.0
2025-05-27	AAPB	ETF	19.12	19.51	18.92	19.45	356124.0
2025-05-27	AAPD	ETF	18.19	18.27	17.96	18.02	744498.0
2025-05-27	AAPR	ETF	26.73	26.7695	26.73	26.7695	1175.0
2025-05-27	AAPU	ETF	20.88	21.34	20.675	21.24	3660002.0
2025-05-27	AAPW	ETF	35.54	36.04	35.41	35.9	35967.0
2025-05-27	AAPX	ETF	17.98	18.37	17.84	18.2765	128130.0
2025-05-27	AAPY	ETF	20.93	21.2	20.93	21.1053	5184.0
2025-05-27	AAVM	ETF	26.185	26.185	26.185	26.185	37.0
2025-05-27	AAXJ	ETF	78.31	78.49	78.19	78.47	424573.0
2025-05-27	ABCS	ETF	27.8	28.16	27.8	28.16	3702.0
2025-05-27	ABEQ	ETF	34.12	34.225	33.88	34.2018	3194.0
2025-05-27	ABFL	ETF	68.48	68.56	68.48	68.5149	11939.0
2025-05-27	ABHY	ETF	19.4414	19.4414	19.4414	19.4414	300.0
2025-05-27	ABLD	ETF	28.17	28.33	28.17	28.3124	3373.0
2025-05-27	ABLG	ETF	30.71	30.8047	30.71	30.8047	2365.0
2025-05-27	ABNY	ETF	60.3	61.6	60.0	61.6	3959.0
2025-05-27	ABOT	ETF	36.93	37.03	36.92	36.9487	3193.0
2025-05-27	ACES	ETF	24.85	24.85	24.55	24.81	21608.0
2025-05-27	ACGR	ETF	56.51	56.5927	56.51	56.5927	108.0
2025-05-27	ACIO	ETF	40.06	40.33	40.0048	40.3	113210.0
2025-05-27	ACLC	ETF	68.66	69.2	68.66	69.13	8710.0
2025-05-27	ACSI	ETF	61.46	61.5833	61.46	61.5833	777.0
2025-05-27	ACT	ETF	35.42	36.9599	35.11	35.72	305138.0
2025-05-27	ACTV	ETF	30.4	30.6933	30.4	30.6933	2607.0
2025-05-27	ACVF	ETF	44.99	45.25	44.94	45.2356	5530.0
2025-05-27	ACVT	ETF	25.53	25.7	25.53	25.69	1062.0
2025-05-27	ACWI	ETF	123.59	124.39	123.33	124.35	4211359.0
2025-05-27	ACWV	ETF	118.39	118.68	118.2	118.68	178875.0
2025-05-27	ACWX	ETF	60.02	60.0869	59.87	59.97	2354162.0
2025-05-27	ADBG	ETF	16.15	16.25	16.0	16.18	9043.0
2025-05-27	ADFI	ETF	8.39	8.439	8.39	8.4144	10652.0
2025-05-27	ADIV	ETF	16.605	16.6173	16.605	16.6173	315.0
2025-05-27	ADME	ETF	46.3371	46.4	46.33	46.34	5230.0
2025-05-27	ADPV	ETF	34.16	34.47	34.13	34.318	31856.0
2025-05-27	ADVE	ETF	34.65	34.65	34.6346	34.6346	381.0
2025-05-27	AESR	ETF	17.91	18.01	17.8628	18.007	8958.0
2025-05-27	AETH	ETF	40.52	41.08	40.52	40.9109	1887.0
2025-05-27	AFIF	ETF	9.22	9.25	9.22	9.24	24706.0
2025-05-27	AFIX	ETF	24.59	24.6	24.58	24.58	713.0
2025-05-27	AFK	ETF	19.17	19.39	18.875	19.07	81204.0
2025-05-27	AFLG	ETF	34.96	35.13	34.8001	35.12	57456.0

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

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