PREVIEW / etf_daily / 2025-07-30

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-30.parquet
  size:    162 KB
  rows:    4,236

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-07-30	SPY	ETF	635.92	637.68	631.54	634.46	80385873.0
2025-07-30	QQQ	ETF	568.18	570.62	565.05	568.02	43433777.0
2025-07-30	IWM	ETF	223.66	224.931	220.12	221.56	48891877.0
2025-07-30	DIA	ETF	446.71	447.38	442.61	444.76	3762765.0
2025-07-30	GLD	ETF	304.42	304.65	300.955	300.96	13462875.0
2025-07-30	TLT	ETF	86.77	86.96	86.56	86.87	40662162.0
2025-07-30	AAA	ETF	24.98	25.13	24.97	25.025	18358.0
2025-07-30	AAAU	ETF	32.63	32.67	32.27	32.29	2972663.0
2025-07-30	AADR	ETF	77.89	78.61	77.89	78.115	2430.0
2025-07-30	AAPB	ETF	21.37	21.37	20.48	20.76	301405.0
2025-07-30	AAPD	ETF	17.04	17.3801	17.02	17.2828	1506422.0
2025-07-30	AAPR	ETF	27.46	27.49	27.46	27.4639	1619.0
2025-07-30	AAPU	ETF	23.22	23.28	22.27	22.57	3259148.0
2025-07-30	AAPW	ETF	35.34	35.34	34.54	34.761	49283.0
2025-07-30	AAPX	ETF	19.98	20.09	19.24	19.46	192339.0
2025-07-30	AAPY	ETF	21.73	21.73	21.61	21.684	812.0
2025-07-30	AAVM	ETF	26.8975	26.8975	26.77	26.77	311.0
2025-07-30	AAXJ	ETF	84.61	84.83	84.14	84.32	327234.0
2025-07-30	ABCS	ETF	29.21	29.315	28.99	29.0601	3319.0
2025-07-30	ABEQ	ETF	34.43	34.46	34.165	34.2014	23697.0
2025-07-30	ABFL	ETF	70.46	70.65	70.13	70.3017	15994.0
2025-07-30	ABLD	ETF	28.98	29.0399	28.72	28.82	9803.0
2025-07-30	ABLG	ETF	29.8486	29.8486	29.8486	29.8486	42.0
2025-07-30	ABNY	ETF	57.35	57.3895	56.05	56.3175	2552.0
2025-07-30	ABOT	ETF	39.23	39.23	39.0835	39.0835	205.0
2025-07-30	ABXB	ETF	19.4827	19.4827	19.4827	19.4827	6.0
2025-07-30	ACES	ETF	27.71	27.72	27.24	27.3754	10128.0
2025-07-30	ACGR	ETF	61.78	61.82	61.54	61.7	1115.0
2025-07-30	ACIO	ETF	42.06	42.095	41.8102	41.94	115270.0
2025-07-30	ACLC	ETF	74.02	74.07	73.541	73.77	3264.0
2025-07-30	ACSI	ETF	64.05	64.05	64.05	64.05	418.0
2025-07-30	ACTV	ETF	32.44	32.44	32.2501	32.2675	4462.0
2025-07-30	ACVF	ETF	48.32	48.32	48.015	48.0676	3578.0
2025-07-30	ACVT	ETF	26.42	26.42	26.42	26.42	141.0
2025-07-30	ACWI	ETF	131.03	131.335	130.1	130.61	4467998.0
2025-07-30	ACWV	ETF	117.58	117.76	116.86	117.21	338041.0
2025-07-30	ACWX	ETF	61.11	61.2	60.61	60.82	977203.0
2025-07-30	ADBG	ETF	12.6	12.6	12.05	12.0938	53072.0
2025-07-30	ADFI	ETF	8.48	8.51	8.45	8.5	45771.0
2025-07-30	ADIV	ETF	17.99	18.01	17.85	17.91	2063.0
2025-07-30	ADME	ETF	49.12	49.1492	48.8208	48.9999	12028.0
2025-07-30	ADPV	ETF	39.74	40.0667	39.62	39.82	12715.0
2025-07-30	ADVE	ETF	36.25	36.25	36.0891	36.0891	822.0
2025-07-30	AESR	ETF	19.4	19.46	19.28	19.32	37213.0
2025-07-30	AETH	ETF	51.23	52.135	50.36	51.3198	4073.0
2025-07-30	AFIF	ETF	9.34	9.44	9.33	9.345	13446.0
2025-07-30	AFIX	ETF	24.84	24.8438	24.84	24.8438	1661.0
2025-07-30	AFK	ETF	21.43	21.43	21.0	21.0	12640.0
2025-07-30	AFLG	ETF	36.9399	37.0299	36.685	36.81	39553.0
2025-07-30	AFMC	ETF	32.565	32.71	32.27	32.3742	9053.0

> showing 50 of 4,236 rows — these rows as CSV

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