PREVIEW / etf_daily / 2025-01-30

all etf daily files

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

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-30	SPY	ETF	603.96	606.6	600.715	605.04	39024407.0
2025-01-30	QQQ	ETF	523.71	526.095	518.21	523.05	27431302.0
2025-01-30	IWM	ETF	228.52	230.05	226.92	228.53	25251589.0
2025-01-30	DIA	ETF	446.54	450.11	446.35	448.82	2264879.0
2025-01-30	GLD	ETF	257.2	258.29	256.45	258.05	13936258.0
2025-01-30	TLT	ETF	88.41	88.705	88.17	88.34	25065945.0
2025-01-30	AAA	ETF	25.11	25.14	25.08	25.08	27061.0
2025-01-30	AAAU	ETF	27.55	27.66	27.47	27.635	1215985.0
2025-01-30	AADR	ETF	75.271	75.88	75.271	75.32	5738.0
2025-01-30	AAPB	ETF	30.23	30.81	29.92	29.98	298828.0
2025-01-30	AAPD	ETF	16.0	16.0999	15.86	16.08	2224001.0
2025-01-30	AAPR	ETF	26.67	26.67	26.61	26.635	1753.0
2025-01-30	AAPU	ETF	33.69	34.26	33.26	33.39	2595603.0
2025-01-30	AAPX	ETF	28.82	29.25	28.565	28.59	84088.0
2025-01-30	AAPY	ETF	25.72	25.795	25.6	25.64	11176.0
2025-01-30	AAXJ	ETF	72.81	73.63	72.77	73.38	857372.0
2025-01-30	ABCS	ETF	29.95	30.13	29.92	29.92	4097.0
2025-01-30	ABEQ	ETF	32.7438	32.93	32.73	32.93	2310.0
2025-01-30	ABFL	ETF	69.63	69.7622	69.41	69.5689	10418.0
2025-01-30	ABHY	ETF	19.1871	19.1871	19.17	19.1818	1829.0
2025-01-30	ABLD	ETF	29.13	29.3329	29.1	29.3329	821.0
2025-01-30	ABLG	ETF	30.0	30.35	30.0	30.2664	4814.0
2025-01-30	ABNY	ETF	74.45	74.45	73.2505	74.05	2048.0
2025-01-30	ABOT	ETF	37.6179	37.6179	37.6179	37.6179	19.0
2025-01-30	ACES	ETF	25.66	26.0	25.57	25.76	85739.0
2025-01-30	ACGR	ETF	58.64	58.7487	58.64	58.7487	680.0
2025-01-30	ACIO	ETF	41.14	41.14	40.8302	41.07	326467.0
2025-01-30	ACLC	ETF	72.12	72.6785	72.12	72.5293	3935.0
2025-01-30	ACSI	ETF	64.0686	64.0686	63.9	63.9762	1140.0
2025-01-30	ACT	ETF	34.23	34.28	33.82	33.96	178421.0
2025-01-30	ACTV	ETF	32.69	33.04	32.69	32.9338	14353.0
2025-01-30	ACVF	ETF	44.83	45.16	44.83	45.13	14803.0
2025-01-30	ACWI	ETF	121.66	122.405	121.42	121.97	2621656.0
2025-01-30	ACWV	ETF	112.22	112.97	112.22	112.82	83062.0
2025-01-30	ACWX	ETF	54.48	54.79	54.33	54.58	892763.0
2025-01-30	ADFI	ETF	8.47	8.479	8.46	8.479	9757.0
2025-01-30	ADIV	ETF	15.71	15.7392	15.71	15.725	1402.0
2025-01-30	ADME	ETF	48.0424	48.075	47.7532	48.0269	5770.0
2025-01-30	ADPV	ETF	38.81	39.11	38.64	39.0564	74341.0
2025-01-30	ADVE	ETF	32.4621	32.4621	32.4621	32.4621	0.0
2025-01-30	AESR	ETF	17.92	17.99	17.86	17.9558	11012.0
2025-01-30	AETH	ETF	32.74	32.78	32.74	32.765	1322.0
2025-01-30	AFIF	ETF	9.2	9.23	9.18	9.19	30947.0
2025-01-30	AFIX	ETF	24.67	24.67	24.63	24.6551	219608.0
2025-01-30	AFK	ETF	16.71	16.76	16.6	16.76	11452.0
2025-01-30	AFLG	ETF	35.72	35.84	35.61	35.77	169137.0
2025-01-30	AFMC	ETF	33.35	33.51	33.15	33.33	15408.0
2025-01-30	AFSM	ETF	31.14	31.34	30.95	31.1478	8186.0
2025-01-30	AGG	ETF	97.62	97.725	97.5198	97.6	6802322.0
2025-01-30	AGGH	ETF	20.68	20.75	20.6301	20.72	42604.0

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

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