PREVIEW / etf_daily / 2021-11-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-16.parquet
  size:    96 KB
  rows:    2,572

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
2021-11-16	SPY	ETF	467.15	470.49	467.07	469.28	48857500.0
2021-11-16	QQQ	ETF	393.86	397.93	393.66	397.42	27872940.0
2021-11-16	IWM	ETF	237.76	239.37	236.95	238.99	21925200.0
2021-11-16	DIA	ETF	361.82	363.54	361.7	361.93	2728600.0
2021-11-16	GLD	ETF	173.97	174.48	172.86	172.92	8667300.0
2021-11-16	TLT	ETF	145.69	146.38	144.85	145.11	12998700.0
2021-11-16	AAA	ETF	25.06	25.06	25.04	25.04	1064.0
2021-11-16	AAAU	ETF	18.52	18.56	18.39	18.4	504200.0
2021-11-16	AADR	ETF	65.33	65.33	65.03	65.11	1300.0
2021-11-16	AAXJ	ETF	88.02	88.18	87.73	88.0	555400.0
2021-11-16	ABEQ	ETF	28.28	28.32	28.215	28.215	5100.0
2021-11-16	ACES	ETF	79.97	79.97	78.69	79.83	54400.0
2021-11-16	ACIO	ETF	32.11	32.166	32.04	32.09	36500.0
2021-11-16	ACSI	ETF	53.3643	53.3643	53.3643	53.3643	16.0
2021-11-16	ACT	ETF	22.99	23.3	22.75	23.24	154256.0
2021-11-16	ACTV	ETF	38.95	39.0991	38.8227	38.8227	3770.0
2021-11-16	ACTX	ETF	1.01	1.43	0.695	1.35	2234.0
2021-11-16	ACVF	ETF	35.2	35.39	35.2	35.353	14300.0
2021-11-16	ACWF	ETF	39.0331	39.26	39.0331	39.1149	7166.0
2021-11-16	ACWI	ETF	106.95	107.46	106.93	107.23	2595900.0
2021-11-16	ACWV	ETF	107.22	107.67	107.22	107.36	332400.0
2021-11-16	ACWX	ETF	57.84	57.89	57.72	57.73	1154738.0
2021-11-16	ADFI	ETF	9.615	9.63	9.6	9.615	5300.0
2021-11-16	ADIV	ETF	17.97	17.97	17.94	17.94	600.0
2021-11-16	ADME	ETF	42.61	42.835	42.61	42.73	22800.0
2021-11-16	ADRE	ETF	51.23	51.23	50.856	50.9801	3151.0
2021-11-16	AEMB	ETF	48.573	48.573	48.573	48.573	100.0
2021-11-16	AESR	ETF	14.79	14.92	14.73	14.81	16600.0
2021-11-16	AFIF	ETF	9.61	9.62	9.58	9.59	19496.0
2021-11-16	AFK	ETF	21.77	21.884	21.52	21.52	4867.0
2021-11-16	AFLG	ETF	27.656	27.656	27.588	27.588	100.0
2021-11-16	AFMC	ETF	27.209	27.209	27.209	27.209	100.0
2021-11-16	AFSM	ETF	29.0	29.0	28.907	28.907	100.0
2021-11-16	AFTY	ETF	20.961	21.078	20.961	21.036	1500.0
2021-11-16	AGG	ETF	113.92	114.11	113.84	113.86	7484000.0
2021-11-16	AGGY	ETF	51.61	51.734	51.605	51.605	84200.0
2021-11-16	AGNG	ETF	29.73	29.73	29.611	29.662	1500.0
2021-11-16	AGOV	ETF	98.69	98.69	98.6	98.605	15527.0
2021-11-16	AGOX	ETF	26.23	26.53	26.23	26.49	32700.0
2021-11-16	AGQ	ETF	40.72	41.21	39.88	40.01	825300.0
2021-11-16	AGZ	ETF	117.7	117.73	117.65	117.68	72746.0
2021-11-16	AGZD	ETF	23.455	23.48	23.43	23.435	22000.0
2021-11-16	AHHX	ETF	10.4	10.53	10.19	10.245	8822.0
2021-11-16	AIA	ETF	82.44	82.49	81.9	82.23	122018.0
2021-11-16	AIEQ	ETF	44.42	44.78	44.3	44.76	21000.0
2021-11-16	AIQ	ETF	33.06	33.45	33.06	33.42	17737.0
2021-11-16	AIRR	ETF	47.27	47.91	47.25	47.78	38000.0
2021-11-16	AIVI	ETF	41.5	41.51	41.41	41.41	2000.0
2021-11-16	ALTL	ETF	45.05	45.15	44.91	44.91	21425.0
2021-11-16	ALTY	ETF	13.61	13.61	13.506	13.52	15300.0

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

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