PREVIEW / etf_daily / 2023-08-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-22.parquet
  size:    108 KB
  rows:    3,004

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-08-22	SPY	ETF	441.18	441.18	437.57	438.15	65062900.0
2023-08-22	QQQ	ETF	366.55	366.56	362.68	363.38	44613509.0
2023-08-22	IWM	ETF	185.04	185.55	183.22	183.83	21335800.0
2023-08-22	DIA	ETF	344.79	345.14	342.57	342.96	2817000.0
2023-08-22	GLD	ETF	175.83	176.25	175.31	176.1	5892500.0
2023-08-22	TLT	ETF	92.64	93.28	92.46	93.23	21323100.0
2023-08-22	AAA	ETF	24.8	24.85	24.8	24.83	1900.0
2023-08-22	AAAU	ETF	18.77	18.82	18.72	18.81	1360000.0
2023-08-22	AADR	ETF	50.84	50.94	50.64	50.94	800.0
2023-08-22	AAPB	ETF	24.54	24.77	24.4604	24.69	29858.0
2023-08-22	AAPD	ETF	22.07	22.17	22.0	22.06	83690.0
2023-08-22	AAPU	ETF	24.99	25.27	24.98	25.18	133267.0
2023-08-22	AAXJ	ETF	64.41	64.41	63.84	64.0	1786000.0
2023-08-22	ABEQ	ETF	27.83	27.83	27.72	27.75	8500.0
2023-08-22	ACES	ETF	40.53	40.53	39.58	39.86	13100.0
2023-08-22	ACIO	ETF	31.1	31.1	30.87	30.94	41900.0
2023-08-22	ACSI	ETF	45.46	45.477	45.415	45.415	1600.0
2023-08-22	ACT	ETF	28.51	28.6	28.32	28.47	164547.0
2023-08-22	ACTV	ETF	31.56	31.56	31.21	31.229	9600.0
2023-08-22	ACVF	ETF	34.08	34.08	33.72	33.75	5200.0
2023-08-22	ACWF	ETF	35.0	35.0	34.71	34.7784	7788.0
2023-08-22	ACWI	ETF	94.66	94.66	93.91	94.01	1550800.0
2023-08-22	ACWV	ETF	96.86	97.06	96.39	96.44	104400.0
2023-08-22	ACWX	ETF	48.0	48.0	47.65	47.69	704400.0
2023-08-22	ADFI	ETF	8.31	8.33	8.28	8.305	18800.0
2023-08-22	ADIV	ETF	13.19	13.19	13.19	13.19	100.0
2023-08-22	ADME	ETF	36.03	36.054	35.89	35.953	11200.0
2023-08-22	ADPV	ETF	24.27	24.32	24.24	24.288	18080.0
2023-08-22	AEMB	ETF	36.62	36.62	36.62	36.62	200.0
2023-08-22	AESR	ETF	12.57	12.6	12.52	12.56	25700.0
2023-08-22	AFIF	ETF	8.88	8.89	8.86	8.87	3600.0
2023-08-22	AFK	ETF	14.45	14.76	14.45	14.55	3600.0
2023-08-22	AFLG	ETF	25.35	25.35	25.093	25.093	1000.0
2023-08-22	AFMC	ETF	24.37	24.45	24.37	24.377	3600.0
2023-08-22	AFSM	ETF	24.71	24.71	24.458	24.458	400.0
2023-08-22	AFTY	ETF	14.676	14.676	14.676	14.676	600.0
2023-08-22	AGG	ETF	95.17	95.32	95.06	95.24	6156200.0
2023-08-22	AGGH	ETF	21.9001	21.97	21.9	21.94	457104.0
2023-08-22	AGGY	ETF	42.07	42.14	42.035	42.11	207200.0
2023-08-22	AGNG	ETF	26.99	27.05	26.966	27.0	4300.0
2023-08-22	AGOV	ETF	74.26	75.665	74.26	75.665	1120.0
2023-08-22	AGOX	ETF	22.9	23.18	22.9	23.06	17700.0
2023-08-22	AGQ	ETF	27.63	27.92	27.4	27.85	481500.0
2023-08-22	AGRH	ETF	25.68	25.68	25.68	25.68	100.0
2023-08-22	AGZ	ETF	106.11	106.19	106.06	106.06	9100.0
2023-08-22	AGZD	ETF	22.21	22.27	22.16	22.19	7200.0
2023-08-22	AHYB	ETF	43.592	43.636	43.592	43.636	400.0
2023-08-22	AIA	ETF	56.54	56.54	56.06	56.13	20900.0
2023-08-22	AIEQ	ETF	30.81	30.81	30.47	30.494	10900.0
2023-08-22	AIQ	ETF	27.49	27.49	27.17	27.25	262800.0

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

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