PREVIEW / etf_daily / 2023-05-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-22.parquet
  size:    109 KB
  rows:    2,962

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-22	SPY	ETF	418.64	420.39	417.35	418.79	60745400.0
2023-05-22	QQQ	ETF	336.25	338.67	336.24	337.64	43015948.0
2023-05-22	IWM	ETF	176.62	179.02	176.04	178.26	28207200.0
2023-05-22	DIA	ETF	334.12	335.15	332.02	332.9	2555100.0
2023-05-22	GLD	ETF	183.22	183.84	182.91	183.21	4834300.0
2023-05-22	TLT	ETF	101.25	101.71	100.67	100.74	20131100.0
2023-05-22	AAA	ETF	24.565	24.565	24.565	24.565	82.0
2023-05-22	AAAU	ETF	19.56	19.63	19.53	19.56	1222500.0
2023-05-22	AADR	ETF	47.73	47.81	47.72	47.72	500.0
2023-05-22	AAPB	ETF	24.64	24.66	24.53	24.5966	10053.0
2023-05-22	AAPD	ETF	22.46	22.53	22.392	22.45	90258.0
2023-05-22	AAPU	ETF	25.09	25.2	24.97	25.13	62998.0
2023-05-22	AAXJ	ETF	66.38	66.96	66.38	66.68	475300.0
2023-05-22	ABEQ	ETF	28.443	28.54	28.443	28.46	15900.0
2023-05-22	ACES	ETF	42.43	43.66	42.43	43.51	110400.0
2023-05-22	ACIO	ETF	30.38	30.38	30.26	30.26	18900.0
2023-05-22	ACSI	ETF	44.17	44.2098	44.17	44.2098	553.0
2023-05-22	ACT	ETF	24.31	24.43	24.12	24.29	351664.0
2023-05-22	ACTV	ETF	29.61	30.06	29.61	29.998	6783.0
2023-05-22	ACTX	ETF	0.285	0.285	0.05	0.05	916.0
2023-05-22	ACVF	ETF	31.7	31.769	31.7	31.705	4800.0
2023-05-22	ACWF	ETF	34.31	34.66	34.31	34.39	52784.0
2023-05-22	ACWI	ETF	93.1	93.38	92.88	93.11	1831400.0
2023-05-22	ACWV	ETF	99.42	99.65	99.05	99.2	150100.0
2023-05-22	ACWX	ETF	49.7	49.815	49.67	49.71	561019.0
2023-05-22	ADFI	ETF	8.42	8.42	8.41	8.415	4100.0
2023-05-22	ADIV	ETF	13.61	13.61	13.61	13.61	100.0
2023-05-22	ADME	ETF	35.12	35.127	35.03	35.03	6500.0
2023-05-22	ADPV	ETF	23.32	23.3401	23.2809	23.2809	2368.0
2023-05-22	AEMB	ETF	37.022	37.022	37.022	37.022	100.0
2023-05-22	AESR	ETF	12.1	12.13	12.09	12.11	6200.0
2023-05-22	AFIF	ETF	8.7993	8.7993	8.73	8.7652	87803.0
2023-05-22	AFK	ETF	15.16	15.4	15.0	15.0	9027.0
2023-05-22	AFLG	ETF	24.06	24.06	24.06	24.06	100.0
2023-05-22	AFMC	ETF	23.088	23.088	22.984	22.984	200.0
2023-05-22	AFSM	ETF	23.068	23.068	23.068	23.068	100.0
2023-05-22	AFTY	ETF	15.72	15.725	15.72	15.725	500.0
2023-05-22	AGG	ETF	98.14	98.33	97.97	97.99	8551100.0
2023-05-22	AGGH	ETF	22.8994	22.93	22.8994	22.93	933.0
2023-05-22	AGGY	ETF	43.15	43.19	43.095	43.14	133300.0
2023-05-22	AGNG	ETF	28.14	28.3	28.14	28.21	1600.0
2023-05-22	AGOV	ETF	77.06	77.8375	76.23	76.23	1188.0
2023-05-22	AGOX	ETF	22.27	22.27	22.1	22.1	19100.0
2023-05-22	AGQ	ETF	29.85	30.13	29.42	29.44	684300.0
2023-05-22	AGZ	ETF	107.8	107.8	107.62	107.67	94534.0
2023-05-22	AGZD	ETF	21.81	21.865	21.75	21.855	59600.0
2023-05-22	AHYB	ETF	43.62	43.74	43.62	43.706	1000.0
2023-05-22	AIA	ETF	59.62	59.94	59.62	59.68	34396.0
2023-05-22	AIEQ	ETF	28.64	29.46	28.62	29.25	15300.0
2023-05-22	AIQ	ETF	25.16	25.43	25.09	25.31	218074.0

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

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