PREVIEW / etf_daily / 2021-12-31

all etf daily files

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

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-31	SPY	ETF	475.64	476.86	474.67	474.96	65237400.0
2021-12-31	QQQ	ETF	399.66	401.0589	397.34	397.85	34752884.0
2021-12-31	IWM	ETF	222.49	224.12	222.39	222.45	23997400.0
2021-12-31	DIA	ETF	363.51	364.74	362.91	363.32	3133800.0
2021-12-31	GLD	ETF	170.53	171.04	170.04	170.96	7039300.0
2021-12-31	TLT	ETF	147.81	149.03	147.43	148.19	13402300.0
2021-12-31	AAA	ETF	25.02	25.02	25.02	25.02	5.0
2021-12-31	AAAU	ETF	18.14	18.19	18.09	18.18	141200.0
2021-12-31	AADR	ETF	64.15	64.34	64.15	64.25	2400.0
2021-12-31	AAXJ	ETF	83.09	83.5	82.68	82.7	702800.0
2021-12-31	ABEQ	ETF	28.45	28.48	28.447	28.448	4900.0
2021-12-31	ACES	ETF	64.01	65.06	64.01	64.15	93400.0
2021-12-31	ACIO	ETF	32.6	33.931	32.6	32.62	23800.0
2021-12-31	ACSI	ETF	53.05	53.27	53.05	53.15	1721.0
2021-12-31	ACT	ETF	20.45	20.8	20.405	20.67	67176.0
2021-12-31	ACTV	ETF	36.4601	36.51	36.38	36.45	52780.0
2021-12-31	ACVF	ETF	35.66	35.725	35.61	35.618	4700.0
2021-12-31	ACWF	ETF	39.2	39.3399	39.1823	39.1823	3052.0
2021-12-31	ACWI	ETF	105.95	106.21	105.72	105.78	5529600.0
2021-12-31	ACWV	ETF	108.08	108.6	108.08	108.28	68000.0
2021-12-31	ACWX	ETF	55.69	55.88	55.585	55.6	2516745.0
2021-12-31	ADFI	ETF	9.61	9.7	9.555	9.56	36900.0
2021-12-31	ADIV	ETF	16.5	16.53	16.46	16.46	1700.0
2021-12-31	ADME	ETF	42.83	43.39	42.83	43.25	22600.0
2021-12-31	ADRE	ETF	46.09	46.21	45.72	45.72	13156.0
2021-12-31	AEMB	ETF	48.504	48.504	48.504	48.504	100.0
2021-12-31	AESR	ETF	14.0	14.03	13.98	13.98	38300.0
2021-12-31	AFIF	ETF	9.57	9.58	9.57	9.57	9272.0
2021-12-31	AFK	ETF	20.08	20.165	20.08	20.12	5198.0
2021-12-31	AFLG	ETF	28.08	28.08	28.08	28.08	400.0
2021-12-31	AFMC	ETF	26.74	26.74	26.64	26.64	200.0
2021-12-31	AFSM	ETF	27.85	27.85	27.767	27.767	100.0
2021-12-31	AFTY	ETF	20.89	20.94	20.88	20.88	1400.0
2021-12-31	AGG	ETF	114.15	114.31	114.06	114.08	7989500.0
2021-12-31	AGGY	ETF	51.67	51.79	51.623	51.68	59400.0
2021-12-31	AGNG	ETF	28.94	28.94	28.807	28.807	600.0
2021-12-31	AGOV	ETF	98.25	98.25	98.06	98.06	311.0
2021-12-31	AGOX	ETF	26.61	26.99	25.22	25.42	115200.0
2021-12-31	AGQ	ETF	34.67	34.92	34.23	34.74	649100.0
2021-12-31	AGZ	ETF	117.2273	117.33	117.17	117.17	26545.0
2021-12-31	AGZD	ETF	23.365	23.435	23.325	23.34	62800.0
2021-12-31	AHHX	ETF	10.42	10.44	10.3348	10.3348	24887.0
2021-12-31	AHYB	ETF	50.151	50.2	50.151	50.185	600.0
2021-12-31	AIA	ETF	76.87	77.28	76.44	76.56	49143.0
2021-12-31	AIEQ	ETF	41.9	42.011	41.77	41.87	16400.0
2021-12-31	AIQ	ETF	32.0	32.05	31.75	31.7996	23198.0
2021-12-31	AIRR	ETF	44.87	45.17	44.77	45.116	8800.0
2021-12-31	AIVI	ETF	41.78	42.03	41.68	41.85	6600.0
2021-12-31	ALTL	ETF	45.98	46.1278	45.85	45.85	37991.0
2021-12-31	ALTY	ETF	13.41	13.43	13.36	13.418	13800.0

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

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