PREVIEW / etf_daily / 2021-12-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-20.parquet
  size:    98 KB
  rows:    2,620

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-12-20	SPY	ETF	454.48	455.4	451.14	454.98	107134800.0
2021-12-20	QQQ	ETF	379.565	381.5	377.47	380.69	65336827.0
2021-12-20	IWM	ETF	212.09	212.94	208.76	212.12	49993000.0
2021-12-20	DIA	ETF	349.38	349.64	346.54	349.27	7303400.0
2021-12-20	GLD	ETF	167.88	168.0	167.06	167.09	6973000.0
2021-12-20	TLT	ETF	150.75	151.02	149.6	149.7	17147300.0
2021-12-20	AAA	ETF	25.03	25.03	25.03	25.03	42.0
2021-12-20	AAAU	ETF	17.87	17.87	17.78	17.79	266900.0
2021-12-20	AADR	ETF	61.23	61.46	60.82	61.46	4400.0
2021-12-20	AAXJ	ETF	80.12	80.39	79.8	80.18	957400.0
2021-12-20	ABEQ	ETF	27.66	27.738	27.56	27.738	3900.0
2021-12-20	ACES	ETF	62.5	62.5	61.17	61.41	120700.0
2021-12-20	ACIO	ETF	31.62	32.86	31.49	32.86	54100.0
2021-12-20	ACSI	ETF	50.66	50.85	50.66	50.85	354.0
2021-12-20	ACT	ETF	19.52	19.72	19.05	19.35	305726.0
2021-12-20	ACTV	ETF	37.41	37.41	36.81	37.2831	4224.0
2021-12-20	ACTX	ETF	1.15	1.15	1.12	1.12	2679.0
2021-12-20	ACVF	ETF	34.4	34.4	33.561	34.112	21100.0
2021-12-20	ACWF	ETF	37.3556	37.47	37.0865	37.45	45688.0
2021-12-20	ACWI	ETF	101.58	101.86	101.03	101.8	4003800.0
2021-12-20	ACWV	ETF	105.15	105.72	104.96	105.66	333800.0
2021-12-20	ACWX	ETF	53.85	53.94	53.6041	53.94	3890409.0
2021-12-20	ADFI	ETF	9.58	9.6	9.579	9.579	4300.0
2021-12-20	ADIV	ETF	15.84	15.87	15.79	15.87	8300.0
2021-12-20	ADME	ETF	42.41	42.41	41.4	41.66	24600.0
2021-12-20	ADRE	ETF	44.06	44.06	43.3001	43.55	9697.0
2021-12-20	AEMB	ETF	47.976	47.976	47.976	47.976	100.0
2021-12-20	AESR	ETF	13.42	13.42	13.27	13.374	8400.0
2021-12-20	AFIF	ETF	9.54	9.57	9.54	9.5498	20655.0
2021-12-20	AFK	ETF	19.53	19.53	19.22	19.405	15542.0
2021-12-20	AFLG	ETF	27.063	27.063	27.063	27.063	100.0
2021-12-20	AFMC	ETF	24.97	25.27	24.97	25.27	100.0
2021-12-20	AFSM	ETF	25.82	26.186	25.82	26.186	1500.0
2021-12-20	AFTY	ETF	21.288	21.33	21.288	21.33	600.0
2021-12-20	AGG	ETF	114.57	114.61	114.32	114.33	7382600.0
2021-12-20	AGGY	ETF	52.0	52.0	51.84	51.84	271400.0
2021-12-20	AGNG	ETF	27.96	27.96	27.74	27.89	9700.0
2021-12-20	AGOV	ETF	98.31	98.3603	98.238	98.3603	591.0
2021-12-20	AGOX	ETF	24.17	24.24	24.005	24.22	41600.0
2021-12-20	AGQ	ETF	31.71	31.91	31.48	31.69	455600.0
2021-12-20	AGZ	ETF	117.59	117.69	117.48	117.53	19378.0
2021-12-20	AGZD	ETF	23.3	23.425	23.3	23.42	901800.0
2021-12-20	AHHX	ETF	10.42	10.45	10.18	10.3127	4399.0
2021-12-20	AHYB	ETF	49.69	49.69	49.69	49.69	100.0
2021-12-20	AIA	ETF	74.36	74.54	73.906	74.19	113158.0
2021-12-20	AIEQ	ETF	40.32	40.39	40.015	40.39	14300.0
2021-12-20	AIQ	ETF	30.51	30.606	30.27	30.49	32851.0
2021-12-20	AIRR	ETF	42.84	42.84	41.562	42.2	159600.0
2021-12-20	AIVI	ETF	41.17	41.22	41.05	41.2	7900.0
2021-12-20	ALTL	ETF	43.08	43.24	42.59	43.04	463987.0

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

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