PREVIEW / etf_daily / 2025-06-18

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-18.parquet
  size:    158 KB
  rows:    4,157

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-06-18	SPY	ETF	598.44	601.22	596.47	597.44	78695978.0
2025-06-18	QQQ	ETF	530.1	532.55	527.4	528.99	43983522.0
2025-06-18	IWM	ETF	208.44	211.39	207.78	209.65	42991867.0
2025-06-18	DIA	ETF	423.67	426.21	422.23	422.84	2784570.0
2025-06-18	GLD	ETF	312.89	312.98	309.86	310.26	9363473.0
2025-06-18	TLT	ETF	86.88	87.09	86.35	86.65	38879304.0
2025-06-18	AAA	ETF	24.96	25.0108	24.96	25.01	1915.0
2025-06-18	AAAU	ETF	33.54	33.55	33.23	33.26	2746888.0
2025-06-18	AADR	ETF	76.54	77.83	76.54	76.82	3828.0
2025-06-18	AAPB	ETF	18.47	18.74	18.31	18.53	153920.0
2025-06-18	AAPD	ETF	18.47	18.53	18.3098	18.42	1021386.0
2025-06-18	AAPR	ETF	26.96	26.97	26.92	26.9301	3064.0
2025-06-18	AAPU	ETF	20.175	20.5051	20.0	20.24	2297652.0
2025-06-18	AAPW	ETF	34.39	34.61	34.2	34.4856	10826.0
2025-06-18	AAPX	ETF	17.39	17.64	17.22	17.44	116228.0
2025-06-18	AAPY	ETF	20.54	20.635	20.51	20.6158	1999.0
2025-06-18	AAVM	ETF	26.47	26.47	26.42	26.42	256.0
2025-06-18	AAXJ	ETF	80.21	80.43	80.01	80.13	250897.0
2025-06-18	ABCS	ETF	28.11	28.245	28.0973	28.0973	4789.0
2025-06-18	ABEQ	ETF	34.42	34.42	34.315	34.315	15595.0
2025-06-18	ABFL	ETF	69.11	69.2	68.6819	68.6819	10283.0
2025-06-18	ABLD	ETF	28.583	28.583	28.4756	28.4756	6878.0
2025-06-18	ABLG	ETF	30.63	30.63	30.5489	30.5489	177.0
2025-06-18	ABNY	ETF	59.106	59.7	58.85	59.25	973.0
2025-06-18	ABOT	ETF	37.44	37.44	37.3318	37.3318	616.0
2025-06-18	ABXB	ETF	19.582	19.582	19.582	19.582	106.0
2025-06-18	ACES	ETF	25.11	25.48	25.11	25.305	44462.0
2025-06-18	ACGR	ETF	57.57	57.57	57.1759	57.1759	147.0
2025-06-18	ACIO	ETF	40.61	40.7	40.46	40.47	144522.0
2025-06-18	ACLC	ETF	70.3	70.3	69.61	69.61	7969.0
2025-06-18	ACSI	ETF	61.5484	61.5484	61.5484	61.5484	77.0
2025-06-18	ACT	ETF	35.02	36.085	35.02	35.87	719779.0
2025-06-18	ACTV	ETF	31.01	31.01	30.9161	30.9161	602.0
2025-06-18	ACVF	ETF	45.56	45.72	45.5424	45.5424	4014.0
2025-06-18	ACVT	ETF	25.75	25.83	25.7499	25.82	1301.0
2025-06-18	ACWI	ETF	124.46	124.96	124.06	124.29	4645700.0
2025-06-18	ACWV	ETF	116.48	116.58	116.03	116.1	241724.0
2025-06-18	ACWX	ETF	59.45	59.56	59.14	59.27	1269639.0
2025-06-18	ADBG	ETF	13.68	13.74	13.23	13.23	82015.0
2025-06-18	ADFI	ETF	8.43	8.45	8.43	8.4305	16414.0
2025-06-18	ADIV	ETF	17.31	17.45	17.2164	17.23	4172.0
2025-06-18	ADME	ETF	46.9878	46.9878	46.72	46.7338	8114.0
2025-06-18	ADPV	ETF	35.16	35.5	35.16	35.43	6314.0
2025-06-18	ADVE	ETF	35.0576	35.0576	35.0576	35.0576	107.0
2025-06-18	AESR	ETF	18.21	18.32	18.21	18.2411	18878.0
2025-06-18	AETH	ETF	35.61	35.61	35.61	35.61	477.0
2025-06-18	AFIF	ETF	9.28	9.28	9.25	9.259	149959.0
2025-06-18	AFIX	ETF	24.7888	24.7888	24.7888	24.7888	30.0
2025-06-18	AFK	ETF	19.49	19.6999	19.3811	19.531	11449.0
2025-06-18	AFLG	ETF	35.27	35.3862	35.177	35.177	20807.0

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

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