PREVIEW / etf_daily / 2025-07-18

all etf daily files

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

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-18	SPY	ETF	629.3	629.47	626.46	627.58	67638939.0
2025-07-18	QQQ	ETF	563.12	564.7262	559.98	561.26	50484704.0
2025-07-18	IWM	ETF	225.29	225.36	221.98	222.33	49590863.0
2025-07-18	DIA	ETF	445.73	445.78	442.12	443.26	3899648.0
2025-07-18	GLD	ETF	309.24	309.37	308.32	308.39	5565674.0
2025-07-18	TLT	ETF	85.43	85.46	85.1	85.24	27532229.0
2025-07-18	AAA	ETF	24.95	24.99	24.9301	24.99	3131.0
2025-07-18	AAAU	ETF	33.16	33.1702	33.06	33.07	1862195.0
2025-07-18	AADR	ETF	79.5	79.5	78.79	78.79	816.0
2025-07-18	AAPB	ETF	21.1	21.3	20.92	21.21	341465.0
2025-07-18	AAPD	ETF	17.11	17.1901	17.0297	17.08	648272.0
2025-07-18	AAPR	ETF	27.36	27.375	27.36	27.37	718.0
2025-07-18	AAPU	ETF	23.03	23.225	22.7704	23.1	2805096.0
2025-07-18	AAPW	ETF	36.09	36.1095	35.7	36.01	68500.0
2025-07-18	AAPX	ETF	19.89	20.04	19.67	19.95	135413.0
2025-07-18	AAPY	ETF	21.64	21.7916	21.64	21.7744	2849.0
2025-07-18	AAVM	ETF	26.67	26.68	26.64	26.68	1283.0
2025-07-18	AAXJ	ETF	85.02	85.08	84.58	84.61	712027.0
2025-07-18	ABCS	ETF	29.18	29.18	28.9984	28.9984	2582.0
2025-07-18	ABEQ	ETF	34.36	34.37	34.19	34.2674	4857.0
2025-07-18	ABFL	ETF	69.92	69.931	69.7899	69.931	10427.0
2025-07-18	ABLD	ETF	28.97	28.97	28.8374	28.92	3483.0
2025-07-18	ABLG	ETF	30.5052	30.5052	30.5052	30.5052	91.0
2025-07-18	ABNY	ETF	61.05	61.05	60.25	60.6	1004.0
2025-07-18	ABOT	ETF	38.69	38.7239	38.69	38.7239	106.0
2025-07-18	ABXB	ETF	19.48	19.48	19.48	19.48	12.0
2025-07-18	ACES	ETF	28.18	28.61	28.11	28.43	52481.0
2025-07-18	ACGR	ETF	60.67	60.8686	60.67	60.8686	1050.0
2025-07-18	ACIO	ETF	41.69	41.695	41.53	41.59	208485.0
2025-07-18	ACLC	ETF	73.24	73.25	73.065	73.122	1343.0
2025-07-18	ACSI	ETF	63.4565	63.4565	63.4565	63.4565	35.0
2025-07-18	ACTV	ETF	32.18	32.18	31.985	32.0561	7573.0
2025-07-18	ACVF	ETF	47.97	47.97	47.6	47.6285	3304.0
2025-07-18	ACWI	ETF	130.33	130.37	129.635	129.76	1764851.0
2025-07-18	ACWV	ETF	117.33	117.7	117.06	117.08	114540.0
2025-07-18	ACWX	ETF	61.29	61.29	60.83	60.86	729966.0
2025-07-18	ADBG	ETF	12.39	12.39	12.1204	12.2131	16617.0
2025-07-18	ADFI	ETF	8.431	8.46	8.4001	8.4546	23963.0
2025-07-18	ADIV	ETF	18.07	18.07	17.97	17.9713	7226.0
2025-07-18	ADME	ETF	48.56	48.56	48.43	48.47	11086.0
2025-07-18	ADPV	ETF	40.5	40.61	40.192	40.6034	16432.0
2025-07-18	ADVE	ETF	35.9807	35.9807	35.9807	35.9807	4.0
2025-07-18	AESR	ETF	19.37	19.37	19.24	19.32	37720.0
2025-07-18	AETH	ETF	49.74	50.32	48.4101	48.5936	4449.0
2025-07-18	AFIF	ETF	9.325	9.325	9.3	9.31	43798.0
2025-07-18	AFIX	ETF	24.84	24.84	24.82	24.825	340.0
2025-07-18	AFK	ETF	20.55	20.93	20.55	20.93	8218.0
2025-07-18	AFLG	ETF	36.66	36.66	36.4531	36.54	523556.0
2025-07-18	AFMC	ETF	32.63	32.63	32.29	32.3569	2849.0
2025-07-18	AFSC	ETF	28.87	28.9	28.83	28.86	1203.0

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

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