PREVIEW / etf_daily / 2025-01-17

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-17.parquet
  size:    148 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-17	SPY	ETF	596.96	599.36	595.61	597.58	57682722.0
2025-01-17	QQQ	ETF	522.85	524.0733	513.1086	521.74	51837941.0
2025-01-17	IWM	ETF	226.93	226.9692	224.67	225.46	26408977.0
2025-01-17	DIA	ETF	434.54	436.39	433.97	434.72	2741400.0
2025-01-17	GLD	ETF	249.7	250.81	249.15	249.27	8282410.0
2025-01-17	TLT	ETF	87.43	87.48	87.04	87.19	29625229.0
2025-01-17	AAA	ETF	25.17	25.18	25.1396	25.175	3925.0
2025-01-17	AAAU	ETF	26.73	26.8655	26.6899	26.7	2180213.0
2025-01-17	AADR	ETF	72.85	72.85	72.0	72.26	2905.0
2025-01-17	AAPB	ETF	28.79	28.8	27.92	28.28	193519.0
2025-01-17	AAPD	ETF	16.48	16.7319	16.47	16.62	849567.0
2025-01-17	AAPR	ETF	26.5201	26.58	26.52	26.5452	6808.0
2025-01-17	AAPU	ETF	32.0	32.08	31.09	31.5	1414043.0
2025-01-17	AAPX	ETF	27.42	27.45	26.65	27.0	49027.0
2025-01-17	AAPY	ETF	25.32	25.3699	25.155	25.168	2745.0
2025-01-17	AAXJ	ETF	71.57	72.41	71.51	71.92	269540.0
2025-01-17	ABCS	ETF	29.45	29.4945	29.45	29.4945	2063.0
2025-01-17	ABEQ	ETF	32.27	32.41	32.27	32.3011	7586.0
2025-01-17	ABFL	ETF	68.3	68.3	67.9548	67.9548	13489.0
2025-01-17	ABHY	ETF	19.1048	19.1048	19.1048	19.1048	104.0
2025-01-17	ABLD	ETF	29.3625	29.3625	29.3539	29.3539	373.0
2025-01-17	ABLG	ETF	29.04	29.04	29.0055	29.0055	4163.0
2025-01-17	ABNY	ETF	73.4575	74.2895	73.4575	74.15	1284.0
2025-01-17	ABOT	ETF	36.7	36.74	36.6877	36.6877	460.0
2025-01-17	ACES	ETF	27.52	27.56	27.08	27.1	19754.0
2025-01-17	ACGR	ETF	58.5	58.5	58.3988	58.3988	289.0
2025-01-17	ACIO	ETF	40.84	40.9062	40.64	40.74	150088.0
2025-01-17	ACLC	ETF	71.9	72.1501	71.85	71.9236	4973.0
2025-01-17	ACSI	ETF	61.5108	61.5108	61.5108	61.5108	13.0
2025-01-17	ACT	ETF	32.75	32.755	32.3	32.53	594397.0
2025-01-17	ACTV	ETF	32.565	32.565	32.35	32.4227	6959.0
2025-01-17	ACVF	ETF	44.99	45.09	44.8905	44.975	20435.0
2025-01-17	ACWI	ETF	119.43	119.87	119.245	119.6	1315354.0
2025-01-17	ACWV	ETF	109.49	109.8365	109.41	109.42	132160.0
2025-01-17	ACWX	ETF	52.64	53.03	52.63	52.74	1077393.0
2025-01-17	ADFI	ETF	8.4534	8.4534	8.37	8.37	5947.0
2025-01-17	ADIV	ETF	15.36	15.36	15.36	15.36	27.0
2025-01-17	ADME	ETF	47.55	47.7211	47.55	47.63	11085.0
2025-01-17	ADPV	ETF	37.35	37.53	37.23	37.4396	38457.0
2025-01-17	ADVE	ETF	31.6802	31.6802	31.6802	31.6802	166.0
2025-01-17	AESR	ETF	17.7199	17.77	17.7	17.7	7129.0
2025-01-17	AETH	ETF	32.79	32.79	32.72	32.7401	2980.0
2025-01-17	AFIF	ETF	9.1535	9.2	9.1535	9.2	41677.0
2025-01-17	AFIX	ETF	24.52	24.52	24.505	24.505	24012.0
2025-01-17	AFK	ETF	16.2	16.2	16.0	16.18	3675.0
2025-01-17	AFLG	ETF	35.34	35.44	35.34	35.34	222887.0
2025-01-17	AFMC	ETF	33.22	33.23	32.8387	32.93	52577.0
2025-01-17	AFSM	ETF	30.7523	30.76	30.64	30.75	7155.0
2025-01-17	AGG	ETF	97.07	97.095	96.87	96.92	4960223.0
2025-01-17	AGGH	ETF	20.76	20.76	20.6007	20.73	72690.0

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

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