PREVIEW / etf_daily / 2023-05-24

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-24.parquet
  size:    110 KB
  rows:    2,972

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
2023-05-24	SPY	ETF	412.42	412.82	409.88	411.09	89213700.0
2023-05-24	QQQ	ETF	331.37	332.905	329.56	331.65	62891169.0
2023-05-24	IWM	ETF	176.55	176.74	174.67	175.54	28744200.0
2023-05-24	DIA	ETF	330.0	330.24	327.48	328.01	2978300.0
2023-05-24	GLD	ETF	183.54	183.54	181.77	181.95	6732900.0
2023-05-24	TLT	ETF	101.28	101.36	100.53	100.53	18473400.0
2023-05-24	AAA	ETF	24.56	24.56	24.56	24.56	242.0
2023-05-24	AAAU	ETF	19.59	19.6	19.4	19.42	1623700.0
2023-05-24	AADR	ETF	46.49	46.52	46.22	46.52	2600.0
2023-05-24	AAPB	ETF	24.021	24.05	23.81	24.05	6304.0
2023-05-24	AAPD	ETF	22.86	22.9118	22.681	22.74	143819.0
2023-05-24	AAPU	ETF	24.38	24.7	24.3608	24.63	61722.0
2023-05-24	AAXJ	ETF	65.39	65.46	65.0	65.05	588500.0
2023-05-24	ABEQ	ETF	28.15	28.15	28.01	28.06	8600.0
2023-05-24	ACES	ETF	43.16	43.22	42.607	42.99	30900.0
2023-05-24	ACIO	ETF	29.91	29.97	29.861	29.92	63400.0
2023-05-24	ACSI	ETF	43.6409	43.6409	43.6409	43.6409	77.0
2023-05-24	ACT	ETF	24.35	24.43	24.13	24.36	252294.0
2023-05-24	ACTV	ETF	29.39	29.5	29.31	29.3946	4683.0
2023-05-24	ACVF	ETF	31.07	31.08	31.05	31.077	1300.0
2023-05-24	ACWF	ETF	33.71	33.71	33.53	33.5963	21946.0
2023-05-24	ACWI	ETF	91.42	91.42	90.91	91.09	1917200.0
2023-05-24	ACWV	ETF	97.78	97.89	97.31	97.41	142100.0
2023-05-24	ACWX	ETF	48.62	48.68	48.34	48.36	1249461.0
2023-05-24	ADFI	ETF	8.39	8.39	8.372	8.385	22800.0
2023-05-24	ADME	ETF	34.467	34.56	34.43	34.5	27000.0
2023-05-24	ADPV	ETF	22.34	22.43	22.31	22.4273	11155.0
2023-05-24	AEMB	ETF	37.029	37.029	37.029	37.029	100.0
2023-05-24	AESR	ETF	11.93	11.96	11.9	11.928	16800.0
2023-05-24	AFIF	ETF	8.8	8.8	8.75	8.7801	99745.0
2023-05-24	AFK	ETF	14.86	15.14	14.82	14.82	6365.0
2023-05-24	AFLG	ETF	23.64	23.64	23.62	23.62	1600.0
2023-05-24	AFMC	ETF	22.66	22.66	22.51	22.54	2000.0
2023-05-24	AFSM	ETF	22.736	22.736	22.736	22.736	100.0
2023-05-24	AFTY	ETF	15.26	15.26	15.154	15.154	200.0
2023-05-24	AGG	ETF	98.17	98.19	97.82	97.85	7719200.0
2023-05-24	AGGH	ETF	22.85	22.85	22.83	22.83	2445.0
2023-05-24	AGGY	ETF	43.05	43.06	42.9	42.92	82400.0
2023-05-24	AGNG	ETF	27.72	27.72	27.52	27.52	1600.0
2023-05-24	AGOV	ETF	74.4701	76.2994	74.4701	76.2994	200.0
2023-05-24	AGOX	ETF	21.61	21.725	21.6	21.65	14900.0
2023-05-24	AGQ	ETF	28.65	28.73	27.89	27.95	745400.0
2023-05-24	AGZ	ETF	107.73	107.74	107.52	107.5905	23283.0
2023-05-24	AGZD	ETF	21.77	21.79	21.695	21.79	11800.0
2023-05-24	AHOY	ETF	19.11	19.12	19.04	19.0507	1604.0
2023-05-24	AHYB	ETF	43.233	43.233	43.233	43.233	100.0
2023-05-24	AIA	ETF	58.23	58.29	57.8501	57.88	11686.0
2023-05-24	AIEQ	ETF	28.79	28.79	28.4	28.616	30800.0
2023-05-24	AIQ	ETF	24.74	24.8	24.5	24.75	113635.0
2023-05-24	AIRR	ETF	48.39	48.398	47.66	47.74	15500.0

> showing 50 of 2,972 rows — these rows as CSV

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