PREVIEW / etf_daily / 2021-12-29

all etf daily files

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

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-29	SPY	ETF	476.98	478.56	475.92	477.48	54503000.0
2021-12-29	QQQ	ETF	401.75	403.05	399.11	401.55	32248484.0
2021-12-29	IWM	ETF	222.72	223.49	221.26	222.99	19444400.0
2021-12-29	DIA	ETF	363.9	365.64	363.79	364.84	3012200.0
2021-12-29	GLD	ETF	167.36	168.69	167.28	168.59	5889700.0
2021-12-29	TLT	ETF	146.91	147.31	146.41	146.67	11771200.0
2021-12-29	AAA	ETF	25.0	25.01	25.0	25.01	434.0
2021-12-29	AAAU	ETF	17.8	17.95	17.8	17.93	272000.0
2021-12-29	AADR	ETF	63.68	64.13	63.68	64.13	1900.0
2021-12-29	AAXJ	ETF	82.39	82.47	81.76	82.16	1222900.0
2021-12-29	ABEQ	ETF	28.49	28.49	28.45	28.48	1800.0
2021-12-29	ACES	ETF	63.83	63.83	62.26	62.87	356200.0
2021-12-29	ACIO	ETF	32.51	32.83	32.51	32.78	47700.0
2021-12-29	ACSI	ETF	53.3	53.38	53.3	53.38	273.0
2021-12-29	ACT	ETF	20.12	20.5	20.12	20.38	67259.0
2021-12-29	ACTV	ETF	36.53	36.7	36.53	36.5888	25963.0
2021-12-29	ACTX	ETF	1.34	1.34	1.34	1.34	580.0
2021-12-29	ACVF	ETF	35.64	35.837	35.64	35.808	3200.0
2021-12-29	ACWF	ETF	39.24	39.34	39.18	39.26	10384.0
2021-12-29	ACWI	ETF	106.13	106.32	105.78	106.15	7856400.0
2021-12-29	ACWV	ETF	108.06	108.43	107.9	108.23	166200.0
2021-12-29	ACWX	ETF	55.71	55.73	55.53	55.66	1327182.0
2021-12-29	ADFI	ETF	9.599	9.6	9.575	9.575	3800.0
2021-12-29	ADIV	ETF	16.435	16.453	16.4	16.453	300.0
2021-12-29	ADME	ETF	43.464	43.49	43.32	43.47	12700.0
2021-12-29	ADRE	ETF	45.01	45.01	44.3819	44.506	15471.0
2021-12-29	AEMB	ETF	48.304	48.304	48.304	48.304	100.0
2021-12-29	AESR	ETF	14.03	14.08	14.0	14.08	17900.0
2021-12-29	AFIF	ETF	9.5419	9.55	9.53	9.55	3192.0
2021-12-29	AFK	ETF	19.78	20.04	19.78	19.96	15924.0
2021-12-29	AFLG	ETF	28.16	28.218	28.16	28.218	600.0
2021-12-29	AFMC	ETF	26.65	26.702	26.65	26.702	300.0
2021-12-29	AFSM	ETF	27.791	27.82	27.791	27.82	300.0
2021-12-29	AFTY	ETF	20.72	20.72	20.57	20.646	9600.0
2021-12-29	AGG	ETF	113.99	114.05	113.81	113.87	5933800.0
2021-12-29	AGGY	ETF	51.6	51.66	51.512	51.52	140900.0
2021-12-29	AGNG	ETF	29.01	29.135	28.98	29.128	2100.0
2021-12-29	AGOV	ETF	98.18	98.18	98.0141	98.0141	482.0
2021-12-29	AGOX	ETF	25.381	25.47	25.38	25.42	14700.0
2021-12-29	AGQ	ETF	32.7	33.48	32.61	33.38	590300.0
2021-12-29	AGZ	ETF	117.08	117.18	117.07	117.17	53203.0
2021-12-29	AGZD	ETF	23.36	23.385	23.335	23.365	153400.0
2021-12-29	AHHX	ETF	10.25	10.3597	10.24	10.3597	282.0
2021-12-29	AHYB	ETF	50.15	50.2	50.15	50.2	1500.0
2021-12-29	AIA	ETF	76.06	76.2965	75.571	75.96	109881.0
2021-12-29	AIEQ	ETF	41.85	41.98	41.62	41.93	43600.0
2021-12-29	AIQ	ETF	31.93	31.95	31.73	31.94	14175.0
2021-12-29	AIRR	ETF	45.05	45.29	44.94	45.2	19600.0
2021-12-29	AIVI	ETF	41.99	42.12	41.97	42.02	5700.0
2021-12-29	ALTL	ETF	46.25	46.31	45.97	46.11	43958.0

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

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