PREVIEW / etf_daily / 2025-07-10

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-10.parquet
  size:    159 KB
  rows:    4,195

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-10	SPY	ETF	624.2	626.8701	623.01	625.82	57521314.0
2025-07-10	QQQ	ETF	556.89	557.3	552.75	555.45	34710913.0
2025-07-10	IWM	ETF	223.39	226.05	222.86	224.8	33979401.0
2025-07-10	DIA	ETF	444.38	447.81	443.7	446.5	2264241.0
2025-07-10	GLD	ETF	306.11	306.51	304.82	306.2	7057626.0
2025-07-10	TLT	ETF	86.83	87.06	86.485	86.99	24524548.0
2025-07-10	AAA	ETF	25.0	25.03	24.9464	24.975	12563.0
2025-07-10	AAAU	ETF	32.82	32.855	32.69	32.83	2243887.0
2025-07-10	AADR	ETF	78.3	79.03	78.29	78.29	7340.0
2025-07-10	AAPB	ETF	21.15	21.702	21.085	21.5	230151.0
2025-07-10	AAPD	ETF	17.14	17.14	16.8652	16.95	648661.0
2025-07-10	AAPR	ETF	27.3246	27.335	27.31	27.335	3024.0
2025-07-10	AAPU	ETF	22.98	23.655	22.94	23.42	3641417.0
2025-07-10	AAPW	ETF	36.55	37.25	36.55	36.96	7872.0
2025-07-10	AAPX	ETF	19.83	20.43	19.83	20.22	79531.0
2025-07-10	AAPY	ETF	21.85	22.22	21.85	22.1708	1699.0
2025-07-10	AAVM	ETF	26.92	27.01	26.91	27.01	1270.0
2025-07-10	AAXJ	ETF	82.83	82.9	82.475	82.87	231971.0
2025-07-10	ABCS	ETF	29.31	29.565	29.31	29.444	2506.0
2025-07-10	ABEQ	ETF	34.1901	34.29	34.1901	34.2561	5950.0
2025-07-10	ABFL	ETF	70.35	70.35	69.93	69.96	18849.0
2025-07-10	ABLD	ETF	29.0533	29.31	29.0533	29.1934	7041.0
2025-07-10	ABLG	ETF	30.8931	30.8931	30.8931	30.8931	380.0
2025-07-10	ABNY	ETF	59.2405	59.59	58.55	59.1305	1387.0
2025-07-10	ABOT	ETF	38.4	38.4443	38.4	38.4443	287.0
2025-07-10	ABXB	ETF	19.5199	19.525	19.5199	19.525	468.0
2025-07-10	ACES	ETF	27.57	27.76	27.54	27.66	6450.0
2025-07-10	ACGR	ETF	60.1952	60.1952	60.0857	60.0857	1583.0
2025-07-10	ACIO	ETF	41.54	41.67	41.4701	41.61	154111.0
2025-07-10	ACLC	ETF	72.76	73.2	72.76	73.0665	6762.0
2025-07-10	ACSI	ETF	63.4992	63.4992	63.4992	63.4992	60.0
2025-07-10	ACTV	ETF	32.16	32.2301	32.16	32.203	2518.0
2025-07-10	ACTX	ETF	0.0001	0.0001	0.0001	0.0001	1003.0
2025-07-10	ACVF	ETF	47.71	47.83	47.646	47.6832	8363.0
2025-07-10	ACVT	ETF	26.38	26.3951	26.38	26.3951	3036.0
2025-07-10	ACWI	ETF	129.43	130.005	129.26	129.85	1261961.0
2025-07-10	ACWV	ETF	117.87	118.14	117.62	117.95	196552.0
2025-07-10	ACWX	ETF	61.15	61.27	60.97	61.24	441211.0
2025-07-10	ADBG	ETF	12.82	12.82	12.28	12.72	86631.0
2025-07-10	ADFI	ETF	8.5	8.5299	8.48	8.5299	11345.0
2025-07-10	ADIV	ETF	17.8	17.84	17.77	17.84	685.0
2025-07-10	ADME	ETF	48.31	48.49	48.29	48.44	8489.0
2025-07-10	ADPV	ETF	38.17	38.17	37.6526	38.104	42149.0
2025-07-10	ADVE	ETF	35.71	35.7309	35.71	35.7309	347.0
2025-07-10	AESR	ETF	19.13	19.19	19.096	19.15	14950.0
2025-07-10	AETH	ETF	38.0093	38.4907	37.88	38.4907	1412.0
2025-07-10	AFIF	ETF	9.3093	9.33	9.28	9.3	43362.0
2025-07-10	AFIX	ETF	24.885	24.885	24.885	24.885	314.0
2025-07-10	AFK	ETF	20.51	20.76	20.51	20.73	17600.0
2025-07-10	AFLG	ETF	36.57	36.68	36.495	36.603	35772.0

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

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