PREVIEW / etf_daily / 2025-01-23

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-23.parquet
  size:    148 KB
  rows:    3,893

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-01-23	SPY	ETF	605.8	609.75	605.52	609.75	39545983.0
2025-01-23	QQQ	ETF	529.04	532.76	528.45	532.64	23096588.0
2025-01-23	IWM	ETF	226.93	229.35	226.55	229.33	20718388.0
2025-01-23	DIA	ETF	441.52	445.45	441.52	445.38	2243967.0
2025-01-23	GLD	ETF	253.19	254.54	252.82	254.07	6378938.0
2025-01-23	TLT	ETF	86.64	86.99	86.525	86.83	31479587.0
2025-01-23	AAA	ETF	25.19	25.28	25.15	25.205	40738.0
2025-01-23	AAAU	ETF	27.14	27.2664	27.07	27.22	1177728.0
2025-01-23	AADR	ETF	74.6	74.85	74.26	74.26	11462.0
2025-01-23	AAPB	ETF	26.92	27.4793	26.3898	26.67	434673.0
2025-01-23	AAPD	ETF	17.0	17.1885	16.8252	17.1	693788.0
2025-01-23	AAPR	ETF	26.61	26.635	26.61	26.635	6006.0
2025-01-23	AAPU	ETF	30.01	30.61	29.35	29.72	3677915.0
2025-01-23	AAPX	ETF	25.66	26.21	25.16	25.48	136721.0
2025-01-23	AAPY	ETF	24.39	24.47	24.25	24.265	6648.0
2025-01-23	AAXJ	ETF	72.29	72.68	72.165	72.68	237596.0
2025-01-23	ABCS	ETF	29.59	29.7522	29.59	29.7522	3028.0
2025-01-23	ABEQ	ETF	32.42	32.464	32.42	32.464	9781.0
2025-01-23	ABFL	ETF	68.475	68.981	68.475	68.981	18202.0
2025-01-23	ABHY	ETF	19.09	19.1251	19.09	19.1251	133.0
2025-01-23	ABLD	ETF	29.39	29.39	29.37	29.37	2073.0
2025-01-23	ABLG	ETF	29.47	29.63	29.39	29.567	17363.0
2025-01-23	ABNY	ETF	73.0	73.9	73.0	73.7	1547.0
2025-01-23	ABOT	ETF	37.04	37.37	37.04	37.37	1873.0
2025-01-23	ACES	ETF	25.32	25.98	25.23	25.98	99826.0
2025-01-23	ACGR	ETF	59.64	59.9041	59.64	59.9041	239.0
2025-01-23	ACIO	ETF	41.19	41.43	41.09	41.43	107023.0
2025-01-23	ACLC	ETF	72.91	73.3712	72.91	73.3712	9060.0
2025-01-23	ACSI	ETF	62.31	62.5139	62.31	62.5139	110.0
2025-01-23	ACT	ETF	33.05	33.48	33.04	33.25	238030.0
2025-01-23	ACTV	ETF	32.645	32.88	32.645	32.87	3306.0
2025-01-23	ACVF	ETF	45.65	45.91	45.4838	45.91	9779.0
2025-01-23	ACWI	ETF	121.29	122.07	121.23	122.07	2022946.0
2025-01-23	ACWV	ETF	110.18	110.595	109.9047	110.595	78416.0
2025-01-23	ACWX	ETF	53.54	53.865	53.495	53.85	2392786.0
2025-01-23	ADFI	ETF	8.3942	8.405	8.37	8.405	11220.0
2025-01-23	ADIV	ETF	15.5605	15.5605	15.5605	15.5605	169.0
2025-01-23	ADME	ETF	48.24	48.503	48.24	48.503	4588.0
2025-01-23	ADPV	ETF	38.02	38.45	37.97	38.4125	15050.0
2025-01-23	ADVE	ETF	32.0647	32.0647	32.0647	32.0647	2.0
2025-01-23	AESR	ETF	18.05	18.16	18.05	18.16	11937.0
2025-01-23	AETH	ETF	32.77	32.78	32.7497	32.7497	3538.0
2025-01-23	AFIF	ETF	9.18	9.195	9.16	9.1713	10917.0
2025-01-23	AFK	ETF	16.31	16.399	16.12	16.39	8851.0
2025-01-23	AFLG	ETF	35.78	35.97	35.714	35.97	77180.0
2025-01-23	AFMC	ETF	33.0201	33.3899	33.0201	33.36	18546.0
2025-01-23	AFSM	ETF	31.19	31.28	30.89	31.22	5306.0
2025-01-23	AGG	ETF	96.77	96.92	96.72	96.85	7702638.0
2025-01-23	AGGH	ETF	20.72	20.72	20.6	20.67	32649.0
2025-01-23	AGGS	ETF	40.485	40.485	40.485	40.485	2.0

> showing 50 of 3,893 rows — these rows as CSV

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