PREVIEW / etf_daily / 2023-05-23

all etf daily files

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

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-23	SPY	ETF	417.08	418.72	413.68	414.09	86383500.0
2023-05-23	QQQ	ETF	335.89	337.06	333.0	333.36	48216663.0
2023-05-23	IWM	ETF	177.91	180.53	177.38	177.42	32708900.0
2023-05-23	DIA	ETF	331.76	333.1	330.08	330.61	2526200.0
2023-05-23	GLD	ETF	182.78	183.76	182.48	183.43	6345000.0
2023-05-23	TLT	ETF	100.43	101.25	100.28	101.03	21749500.0
2023-05-23	AAA	ETF	24.57	24.57	24.57	24.57	2.0
2023-05-23	AAAU	ETF	19.53	19.61	19.48	19.58	686000.0
2023-05-23	AADR	ETF	47.5	47.5	46.75	46.75	1100.0
2023-05-23	AAPB	ETF	24.2303	24.34	23.93	23.99	12625.0
2023-05-23	AAPD	ETF	22.6	22.7901	22.57	22.7754	90506.0
2023-05-23	AAPU	ETF	24.88	24.8905	24.52	24.54	122356.0
2023-05-23	AAXJ	ETF	66.19	66.21	65.59	65.59	752200.0
2023-05-23	ABEQ	ETF	28.23	28.46	28.23	28.275	10000.0
2023-05-23	ACES	ETF	43.18	44.5	43.18	43.6	47000.0
2023-05-23	ACIO	ETF	30.21	30.23	30.044	30.068	21200.0
2023-05-23	ACSI	ETF	43.9351	43.9351	43.9351	43.9351	23.0
2023-05-23	ACT	ETF	24.18	24.52	24.17	24.37	1263549.0
2023-05-23	ACTV	ETF	29.92	30.2401	29.8978	29.8978	4451.0
2023-05-23	ACVF	ETF	31.52	31.615	31.354	31.354	1100.0
2023-05-23	ACWF	ETF	34.15	34.21	33.94	33.94	4223.0
2023-05-23	ACWI	ETF	92.63	92.75	91.91	91.94	3814000.0
2023-05-23	ACWV	ETF	98.57	98.58	98.02	98.09	582500.0
2023-05-23	ACWX	ETF	49.35	49.37	48.99	49.0	1746973.0
2023-05-23	ADFI	ETF	8.4	8.41	8.39	8.405	17600.0
2023-05-23	ADIV	ETF	13.38	13.38	13.38	13.38	100.0
2023-05-23	ADME	ETF	34.78	34.95	34.71	34.71	27700.0
2023-05-23	ADPV	ETF	23.12	23.17	22.7857	22.7857	7364.0
2023-05-23	AEMB	ETF	37.04	37.04	37.04	37.04	100.0
2023-05-23	AESR	ETF	12.06	12.09	11.98	12.01	20700.0
2023-05-23	AFIF	ETF	8.76	8.7799	8.76	8.7654	38303.0
2023-05-23	AFK	ETF	15.21	15.21	14.92	14.92	3330.0
2023-05-23	AFLG	ETF	23.96	23.96	23.828	23.828	200.0
2023-05-23	AFMC	ETF	22.82	22.82	22.766	22.766	900.0
2023-05-23	AFSM	ETF	22.96	22.96	22.96	22.96	100.0
2023-05-23	AFTY	ETF	15.395	15.395	15.395	15.395	100.0
2023-05-23	AGG	ETF	97.92	98.21	97.81	98.1	7641200.0
2023-05-23	AGGH	ETF	22.7701	22.8757	22.77	22.8757	4806.0
2023-05-23	AGGY	ETF	43.08	43.21	43.059	43.18	98300.0
2023-05-23	AGNG	ETF	28.0	28.0	27.814	27.814	2600.0
2023-05-23	AGOV	ETF	76.86	77.4113	76.4	77.4113	718.0
2023-05-23	AGOX	ETF	22.08	22.11	21.84	21.84	27100.0
2023-05-23	AGQ	ETF	29.08	29.48	28.85	28.96	698600.0
2023-05-23	AGZ	ETF	107.66	107.75	107.56	107.7026	28994.0
2023-05-23	AGZD	ETF	21.82	21.85	21.76	21.845	18200.0
2023-05-23	AHYB	ETF	43.64	43.64	43.49	43.49	1000.0
2023-05-23	AIA	ETF	58.96	59.1015	58.38	58.38	26872.0
2023-05-23	AIEQ	ETF	29.11	29.81	29.01	29.01	15500.0
2023-05-23	AIQ	ETF	25.17	25.27	24.85	24.9	233711.0
2023-05-23	AIRR	ETF	48.66	49.24	48.4	48.577	47000.0

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

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