PREVIEW / etf_daily / 2025-07-23

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-23.parquet
  size:    163 KB
  rows:    4,217

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-07-23	SPY	ETF	632.42	634.21	632.37	634.21	30648725.0
2025-07-23	QQQ	ETF	562.34	563.85	559.58	563.81	40215259.0
2025-07-23	IWM	ETF	225.22	226.71	225.19	226.68	10696349.0
2025-07-23	DIA	ETF	449.48	450.25	449.32	450.21	1915771.0
2025-07-23	GLD	ETF	312.33	312.77	312.07	312.18	3047400.0
2025-07-23	TLT	ETF	85.94	86.1	85.922	86.04	12527976.0
2025-07-23	AAA	ETF	25.025	25.025	25.025	25.025	7.0
2025-07-23	AAAU	ETF	33.495	33.535	33.45	33.475	1534052.0
2025-07-23	AADR	ETF	80.475	80.475	80.475	80.475	139.0
2025-07-23	AAPB	ETF	21.85	21.88	21.7	21.7952	72448.0
2025-07-23	AAPD	ETF	16.815	16.88	16.8072	16.8469	195399.0
2025-07-23	AAPR	ETF	27.445	27.445	27.445	27.445	1.0
2025-07-23	AAPU	ETF	23.8	23.84	23.6047	23.74	763974.0
2025-07-23	AAPW	ETF	36.36	36.36	35.9	36.32	27703.0
2025-07-23	AAPX	ETF	20.54	20.575	20.41	20.54	47264.0
2025-07-23	AAPY	ETF	22.01	22.01	21.98	21.98	741.0
2025-07-23	AAVM	ETF	27.41	27.42	27.41	27.42	202.0
2025-07-23	AAXJ	ETF	85.95	86.09	85.95	86.07	160955.0
2025-07-23	ABCS	ETF	29.59	29.5991	29.57	29.5991	303.0
2025-07-23	ABEQ	ETF	34.833	34.833	34.833	34.833	165.0
2025-07-23	ABFL	ETF	70.73	70.7485	70.69	70.7485	4043.0
2025-07-23	ABLD	ETF	29.24	29.27	29.24	29.27	932.0
2025-07-23	ABLG	ETF	31.0781	31.0781	31.0781	31.0781	74.0
2025-07-23	ABNY	ETF	61.047	61.1	60.675	60.675	2020.0
2025-07-23	ABOT	ETF	39.1498	39.1498	39.124	39.124	252.0
2025-07-23	ABXB	ETF	19.5933	19.5933	19.5933	19.5933	7.0
2025-07-23	ACES	ETF	28.97	29.01	28.95	28.995	1259.0
2025-07-23	ACGR	ETF	61.1082	61.1082	61.1082	61.1082	11.0
2025-07-23	ACIO	ETF	41.7995	41.85	41.7995	41.85	59903.0
2025-07-23	ACLC	ETF	73.69	73.69	73.6831	73.6831	186.0
2025-07-23	ACSI	ETF	64.2224	64.2224	64.2224	64.2224	20.0
2025-07-23	ACTV	ETF	32.58	32.6428	32.58	32.6428	894.0
2025-07-23	ACVF	ETF	47.9726	48.07	47.9726	48.0658	1867.0
2025-07-23	ACVT	ETF	26.43	26.46	26.425	26.46	1796.0
2025-07-23	ACWI	ETF	131.56	131.91	131.55	131.9	2056533.0
2025-07-23	ACWV	ETF	118.7314	118.89	118.67	118.86	54949.0
2025-07-23	ACWX	ETF	62.48	62.63	62.4799	62.62	359823.0
2025-07-23	ADBG	ETF	12.72	12.75	12.47	12.6614	59390.0
2025-07-23	ADFI	ETF	8.47	8.51	8.46	8.49	9509.0
2025-07-23	ADIV	ETF	18.14	18.14	18.1	18.1307	3983.0
2025-07-23	ADME	ETF	48.7898	48.827	48.76	48.82	3042.0
2025-07-23	ADPV	ETF	39.9731	40.1184	39.9731	40.1184	8020.0
2025-07-23	ADVE	ETF	36.8695	36.8695	36.8695	36.8695	3.0
2025-07-23	AESR	ETF	19.48	19.5	19.47	19.5	6043.0
2025-07-23	AETH	ETF	49.17	49.17	49.1273	49.1273	230.0
2025-07-23	AFIF	ETF	9.29	9.39	9.29	9.33	1727.0
2025-07-23	AFIX	ETF	24.89	24.89	24.885	24.885	1028.0
2025-07-23	AFK	ETF	21.75	21.75	21.6	21.6	2077.0
2025-07-23	AFLG	ETF	36.9397	37.01	36.939	37.01	10699.0
2025-07-23	AFMC	ETF	32.9	32.9799	32.9	32.91	13905.0

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

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