PREVIEW / etf_daily / 2023-09-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-22.parquet
  size:    109 KB
  rows:    3,031

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-09-22	SPY	ETF	432.45	434.1	429.99	430.42	100829700.0
2023-09-22	QQQ	ETF	359.63	361.8	357.59	357.91	51589689.0
2023-09-22	IWM	ETF	177.56	178.37	176.56	176.67	23164700.0
2023-09-22	DIA	ETF	340.69	341.43	339.32	339.58	3376400.0
2023-09-22	GLD	ETF	178.65	178.95	178.51	178.62	3634800.0
2023-09-22	TLT	ETF	90.81	91.61	90.67	91.43	29524500.0
2023-09-22	AAA	ETF	24.876	24.876	24.87	24.87	1500.0
2023-09-22	AAAU	ETF	19.08	19.11	19.07	19.08	753400.0
2023-09-22	AADR	ETF	49.65	49.72	49.39	49.49	700.0
2023-09-22	AAPB	ETF	23.72	24.3	23.65	23.8	21554.0
2023-09-22	AAPD	ETF	22.23	22.295	21.92	22.22	207227.0
2023-09-22	AAPU	ETF	24.32	24.79	24.2	24.32	135854.0
2023-09-22	AAXJ	ETF	64.71	64.73	64.35	64.42	297700.0
2023-09-22	ABEQ	ETF	27.94	27.96	27.85	27.88	19600.0
2023-09-22	ACES	ETF	38.74	38.74	37.73	37.76	243300.0
2023-09-22	ACIO	ETF	30.63	30.8	30.63	30.68	115700.0
2023-09-22	ACSI	ETF	44.594	44.594	44.594	44.594	100.0
2023-09-22	ACT	ETF	27.71	27.97	27.59	27.62	135489.0
2023-09-22	ACTV	ETF	30.82	30.84	30.63	30.634	67900.0
2023-09-22	ACVF	ETF	33.79	33.79	33.24	33.244	3900.0
2023-09-22	ACWF	ETF	34.73	34.7713	34.6496	34.6496	967.0
2023-09-22	ACWI	ETF	93.71	93.97	93.21	93.26	1521300.0
2023-09-22	ACWV	ETF	97.34	97.45	96.98	97.05	243100.0
2023-09-22	ACWX	ETF	47.92	48.07	47.68	47.68	2638300.0
2023-09-22	ADFI	ETF	8.29	8.29	8.285	8.285	4500.0
2023-09-22	ADIV	ETF	13.54	13.54	13.54	13.54	100.0
2023-09-22	ADME	ETF	35.61	35.73	35.43	35.45	28700.0
2023-09-22	ADPV	ETF	23.96	23.9605	23.84	23.8424	31257.0
2023-09-22	ADVE	ETF	30.42	30.42	30.2597	30.2597	52812.0
2023-09-22	AEMB	ETF	36.41	36.41	36.41	36.41	100.0
2023-09-22	AESR	ETF	12.3	12.35	12.24	12.24	14200.0
2023-09-22	AFIF	ETF	8.89	8.93	8.89	8.92	27800.0
2023-09-22	AFK	ETF	14.67	14.67	14.2	14.23	3400.0
2023-09-22	AFMC	ETF	23.84	23.84	23.724	23.724	700.0
2023-09-22	AFSM	ETF	23.73	23.73	23.73	23.73	100.0
2023-09-22	AFTY	ETF	14.95	14.99	14.95	14.99	1300.0
2023-09-22	AGG	ETF	94.78	95.09	94.73	95.05	7294200.0
2023-09-22	AGGH	ETF	21.79	21.83	21.76	21.76	8424.0
2023-09-22	AGGY	ETF	41.86	42.055	41.86	42.04	189700.0
2023-09-22	AGNG	ETF	26.35	26.35	26.289	26.289	1500.0
2023-09-22	AGOV	ETF	73.992	73.992	73.992	73.992	110.0
2023-09-22	AGOX	ETF	22.84	22.88	22.67	22.67	34900.0
2023-09-22	AGQ	ETF	28.1	28.33	27.82	27.9	571900.0
2023-09-22	AGZ	ETF	106.05	106.11	105.89	106.05	15000.0
2023-09-22	AGZD	ETF	22.32	22.48	22.27	22.27	17600.0
2023-09-22	AHLT	ETF	25.97	25.97	25.9185	25.9185	212.0
2023-09-22	AHYB	ETF	43.7	43.7	43.6	43.61	800.0
2023-09-22	AIA	ETF	56.55	56.61	56.2	56.27	27200.0
2023-09-22	AIEQ	ETF	30.18	30.18	29.97	29.97	9700.0
2023-09-22	AIQ	ETF	27.2	27.21	26.91	26.95	337100.0

> showing 50 of 3,031 rows — these rows as CSV

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