PREVIEW / etf_daily / 2025-01-16

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-16.parquet
  size:    147 KB
  rows:    3,885

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-16	SPY	ETF	594.175	594.35	590.93	591.64	44181617.0
2025-01-16	QQQ	ETF	518.98	519.0599	512.95	513.08	28229037.0
2025-01-16	IWM	ETF	224.15	225.23	222.71	224.49	20346831.0
2025-01-16	DIA	ETF	432.09	432.91	430.76	431.56	2353467.0
2025-01-16	GLD	ETF	250.56	251.39	250.27	250.6	9032389.0
2025-01-16	TLT	ETF	86.64	87.395	86.28	87.04	34230366.0
2025-01-16	AAA	ETF	25.11	25.213	25.0799	25.178	51574.0
2025-01-16	AAAU	ETF	26.85	26.9299	26.805	26.84	2224787.0
2025-01-16	AADR	ETF	72.25	72.43	72.25	72.3	3325.0
2025-01-16	AAPB	ETF	30.28	30.34	27.8452	27.89	205542.0
2025-01-16	AAPD	ETF	16.09	16.755	16.08	16.75	1218314.0
2025-01-16	AAPR	ETF	26.46	26.47	26.46	26.4608	5842.0
2025-01-16	AAPU	ETF	33.74	33.79	31.0	31.07	1665748.0
2025-01-16	AAPX	ETF	28.99	28.99	26.57	26.63	63113.0
2025-01-16	AAPY	ETF	25.96	25.96	25.04	25.0458	8683.0
2025-01-16	AAXJ	ETF	71.58	71.58	71.27	71.28	470592.0
2025-01-16	ABCS	ETF	29.14	29.375	29.14	29.375	1931.0
2025-01-16	ABEQ	ETF	32.01	32.21	32.01	32.21	9203.0
2025-01-16	ABFL	ETF	67.905	67.9559	67.7016	67.7016	7855.0
2025-01-16	ABHY	ETF	19.02	19.1029	19.02	19.1029	760.0
2025-01-16	ABLD	ETF	29.14	29.2461	29.14	29.2461	2573.0
2025-01-16	ABLG	ETF	28.9	28.94	28.83	28.9015	74863.0
2025-01-16	ABNY	ETF	72.75	73.4	72.45	73.2275	1260.0
2025-01-16	ABOT	ETF	36.47	36.47	36.4279	36.4279	226.0
2025-01-16	ACES	ETF	26.87	27.34	26.84	27.26	104303.0
2025-01-16	ACGR	ETF	57.8667	57.8667	57.8667	57.8667	52.0
2025-01-16	ACIO	ETF	40.61	40.61	40.3404	40.4	350674.0
2025-01-16	ACLC	ETF	71.4	71.53	71.28	71.3668	2140.0
2025-01-16	ACSI	ETF	61.0729	61.0729	61.0729	61.0729	20.0
2025-01-16	ACT	ETF	32.07	32.58	32.01	32.52	565011.0
2025-01-16	ACTV	ETF	32.24	32.45	32.15	32.4442	9120.0
2025-01-16	ACVF	ETF	44.6	44.65	44.409	44.56	9510.0
2025-01-16	ACWI	ETF	118.88	118.99	118.39	118.59	4744673.0
2025-01-16	ACWV	ETF	108.63	109.31	108.63	109.25	89445.0
2025-01-16	ACWX	ETF	52.5	52.6602	52.32	52.46	2830196.0
2025-01-16	ADFI	ETF	8.37	8.41	8.37	8.41	14422.0
2025-01-16	ADIV	ETF	15.266	15.266	15.266	15.266	203.0
2025-01-16	ADME	ETF	47.37	47.37	47.1	47.185	75785.0
2025-01-16	ADPV	ETF	37.0	37.06	36.79	36.9005	5575.0
2025-01-16	ADVE	ETF	31.4458	31.4458	31.4458	31.4458	102.0
2025-01-16	AESR	ETF	17.59	17.67	17.58	17.58	18476.0
2025-01-16	AETH	ETF	32.72	32.75	32.72	32.7299	1836.0
2025-01-16	AFIF	ETF	9.14	9.21	9.14	9.17	33790.0
2025-01-16	AFIX	ETF	24.53	24.53	24.505	24.505	1751586.0
2025-01-16	AFK	ETF	16.16	16.16	15.9	15.98	7879.0
2025-01-16	AFLG	ETF	35.23	35.23	35.0843	35.14	36345.0
2025-01-16	AFMC	ETF	32.6823	32.8899	32.68	32.85	12130.0
2025-01-16	AFSM	ETF	30.8	30.869	30.54	30.6196	8867.0
2025-01-16	AGG	ETF	96.63	97.025	96.5	96.92	9774749.0
2025-01-16	AGGH	ETF	20.67	20.7	20.48	20.7	52654.0

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

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