PREVIEW / etf_daily / 2021-07-21

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-21.parquet
  size:    91 KB
  rows:    2,420

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-07-21	SPY	ETF	432.34	434.7	431.01	434.55	64724400.0
2021-07-21	QQQ	ETF	358.35	361.56	358.12	361.56	30259860.0
2021-07-21	IWM	ETF	219.45	222.22	219.36	222.06	28278700.0
2021-07-21	DIA	ETF	346.97	348.15	346.37	347.99	3056800.0
2021-07-21	GLD	ETF	168.33	169.0	168.14	168.76	4622600.0
2021-07-21	TLT	ETF	148.18	148.5	146.67	148.1	19988900.0
2021-07-21	AAA	ETF	25.0187	25.0187	25.0001	25.015	1400.0
2021-07-21	AAAU	ETF	17.9	17.97	17.88	17.95	274900.0
2021-07-21	AADR	ETF	63.59	65.85	63.59	65.85	5500.0
2021-07-21	AAXJ	ETF	90.36	91.13	89.98	91.11	403900.0
2021-07-21	ABEQ	ETF	27.29	27.38	27.29	27.328	5000.0
2021-07-21	ACES	ETF	69.62	71.65	69.62	71.57	37700.0
2021-07-21	ACIO	ETF	30.83	30.83	30.63	30.68	26000.0
2021-07-21	ACSI	ETF	50.7408	50.87	50.7408	50.7934	1392.0
2021-07-21	ACTV	ETF	38.02	38.19	38.02	38.1627	6373.0
2021-07-21	ACVF	ETF	32.08	32.147	32.04	32.147	1700.0
2021-07-21	ACWF	ETF	37.85	37.946	37.83	37.946	13311.0
2021-07-21	ACWI	ETF	100.91	101.61	100.83	101.6	2447700.0
2021-07-21	ACWV	ETF	104.0	104.21	103.87	104.12	84100.0
2021-07-21	ACWX	ETF	56.19	56.685	56.125	56.67	570953.0
2021-07-21	ADFI	ETF	9.77	9.77	9.73	9.749	1000.0
2021-07-21	ADIV	ETF	18.246	18.246	18.246	18.246	100.0
2021-07-21	ADME	ETF	40.55	40.55	40.287	40.52	23000.0
2021-07-21	ADRE	ETF	54.3114	55.13	54.3114	55.13	5504.0
2021-07-21	AEMB	ETF	50.11	50.12	50.03	50.03	400.0
2021-07-21	AESR	ETF	13.75	13.794	13.75	13.794	5600.0
2021-07-21	AFIF	ETF	9.68	9.68	9.6404	9.6618	7375.0
2021-07-21	AFK	ETF	21.25	21.55	21.24	21.55	5075.0
2021-07-21	AFLG	ETF	25.65	25.652	25.65	25.652	400.0
2021-07-21	AFTY	ETF	22.25	22.3	22.17	22.27	14300.0
2021-07-21	AGG	ETF	116.08	116.15	115.92	116.02	9686100.0
2021-07-21	AGGY	ETF	52.75	52.78	52.694	52.719	113300.0
2021-07-21	AGNG	ETF	30.3	30.43	30.3	30.405	2200.0
2021-07-21	AGOX	ETF	26.06	26.06	25.62	26.003	6100.0
2021-07-21	AGQ	ETF	41.98	42.98	41.98	42.85	657300.0
2021-07-21	AGZ	ETF	119.12	119.12	119.01	119.07	150502.0
2021-07-21	AGZD	ETF	23.455	23.54	23.45	23.48	30200.0
2021-07-21	AIA	ETF	86.92	87.8	86.83	87.75	94710.0
2021-07-21	AIEQ	ETF	40.41	40.788	40.286	40.777	11400.0
2021-07-21	AIQ	ETF	30.26	30.59	30.26	30.54	17401.0
2021-07-21	AIRR	ETF	39.96	40.676	39.96	40.35	30800.0
2021-07-21	AIVI	ETF	43.14	43.36	43.12	43.36	2400.0
2021-07-21	ALTL	ETF	42.4	42.43	42.11	42.11	66872.0
2021-07-21	ALTY	ETF	13.51	13.58	13.491	13.5	12400.0
2021-07-21	AMJ	ETF	18.45	18.79	18.21	18.21	1057846.0
2021-07-21	AMLP	ETF	34.3	34.85	33.71	33.71	4495100.0
2021-07-21	AMNA	ETF	32.3114	32.3114	32.3114	32.3114	0.0
2021-07-21	AMND	ETF	33.9256	33.9256	33.9256	33.9256	2.0
2021-07-21	AMOM	ETF	36.39	36.61	36.385	36.56	12500.0
2021-07-21	AMPS	ETF	9.98	10.0	9.95	9.95	391771.0

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

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