PREVIEW / etf_daily / 2025-01-21

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-21.parquet
  size:    146 KB
  rows:    3,887

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-21	SPY	ETF	600.67	603.06	598.67	603.05	40412934.0
2025-01-21	QQQ	ETF	524.48	525.97	520.06	524.8	23627971.0
2025-01-21	IWM	ETF	227.52	229.89	226.985	229.79	23730895.0
2025-01-21	DIA	ETF	436.35	440.43	436.31	440.1	1964716.0
2025-01-21	GLD	ETF	251.95	253.3598	251.83	253.13	7658330.0
2025-01-21	TLT	ETF	87.89	88.17	87.63	87.97	30363461.0
2025-01-21	AAA	ETF	25.17	25.19	25.17	25.18	10872.0
2025-01-21	AAAU	ETF	27.0	27.145	26.98	27.115	1711387.0
2025-01-21	AADR	ETF	73.56	74.34	73.095	74.3208	1343.0
2025-01-21	AAPB	ETF	26.86	26.87	25.69	26.49	698125.0
2025-01-21	AAPD	ETF	17.08	17.39	17.04	17.16	987144.0
2025-01-21	AAPR	ETF	26.55	26.596	26.55	26.595	4165.0
2025-01-21	AAPU	ETF	29.91	29.91	28.59	29.45	4367624.0
2025-01-21	AAPX	ETF	25.73	25.73	24.501	25.18	155357.0
2025-01-21	AAPY	ETF	25.09	25.09	24.15	24.47	23157.0
2025-01-21	AAXJ	ETF	72.38	72.65	72.08	72.55	521688.0
2025-01-21	ABCS	ETF	29.68	29.8148	29.68	29.8148	3689.0
2025-01-21	ABEQ	ETF	32.5839	32.6499	32.5822	32.5822	2582.0
2025-01-21	ABFL	ETF	68.22	68.55	68.22	68.5499	44645.0
2025-01-21	ABHY	ETF	19.12	19.1334	19.12	19.1334	295.0
2025-01-21	ABLD	ETF	29.6685	29.6685	29.6685	29.6685	207.0
2025-01-21	ABLG	ETF	29.22	29.5	29.17	29.5	30756.0
2025-01-21	ABNY	ETF	74.7	74.84	72.9	73.55	18231.0
2025-01-21	ABOT	ETF	36.84	36.9979	36.84	36.9979	825.0
2025-01-21	ACES	ETF	27.02	27.02	26.2675	26.37	42809.0
2025-01-21	ACGR	ETF	58.6	58.95	58.6	58.8758	11203.0
2025-01-21	ACIO	ETF	40.86	41.03	40.785	41.01	311951.0
2025-01-21	ACLC	ETF	72.17	72.5714	72.17	72.5714	5245.0
2025-01-21	ACSI	ETF	62.1048	62.1048	62.1048	62.1048	22.0
2025-01-21	ACT	ETF	32.6	33.17	32.6	33.04	437586.0
2025-01-21	ACTV	ETF	32.66	33.0886	32.66	33.0886	6471.0
2025-01-21	ACVF	ETF	45.26	45.46	45.2097	45.4423	12336.0
2025-01-21	ACWI	ETF	120.4	120.97	120.07	120.96	2311777.0
2025-01-21	ACWV	ETF	109.76	110.5	109.76	110.5	196994.0
2025-01-21	ACWX	ETF	53.31	53.605	53.2	53.59	2192921.0
2025-01-21	ADFI	ETF	8.45	8.46	8.4	8.41	36193.0
2025-01-21	ADIV	ETF	15.5501	15.5501	15.5501	15.5501	238.0
2025-01-21	ADME	ETF	47.8	48.04	47.8	48.03	42742.0
2025-01-21	ADPV	ETF	37.89	38.05	37.56	37.8941	20747.0
2025-01-21	ADVE	ETF	32.0611	32.0611	32.0611	32.0611	42.0
2025-01-21	AESR	ETF	17.8403	17.96	17.83	17.95	48442.0
2025-01-21	AETH	ETF	32.8	32.8099	32.7301	32.7497	4852.0
2025-01-21	AFIF	ETF	9.26	9.26	9.17	9.19	230135.0
2025-01-21	AFIX	ETF	24.565	24.5907	24.565	24.5907	13955.0
2025-01-21	AFK	ETF	16.3	16.3	16.18	16.3	7059.0
2025-01-21	AFLG	ETF	35.58	35.66	35.4666	35.66	31323.0
2025-01-21	AFMC	ETF	33.22	33.52	33.22	33.51	19808.0
2025-01-21	AFSM	ETF	30.86	31.29	30.86	31.29	15832.0
2025-01-21	AGG	ETF	97.15	97.28	97.09	97.24	7691206.0
2025-01-21	AGGH	ETF	20.75	20.75	20.6545	20.73	58920.0

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

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