PREVIEW / etf_daily / 2021-08-30

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-30.parquet
  size:    92 KB
  rows:    2,452

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-08-30	SPY	ETF	450.97	453.07	450.71	452.23	48357400.0
2021-08-30	QQQ	ETF	376.85	380.76	376.83	380.26	27295665.0
2021-08-30	IWM	ETF	227.25	227.35	224.98	225.48	20733300.0
2021-08-30	DIA	ETF	354.96	355.22	353.88	354.08	2482000.0
2021-08-30	GLD	ETF	169.66	169.84	169.09	169.35	3768600.0
2021-08-30	TLT	ETF	148.99	149.9	148.93	149.85	10596300.0
2021-08-30	AAA	ETF	25.02	25.02	25.02	25.02	59.0
2021-08-30	AAAU	ETF	18.05	18.06	17.99	18.01	168900.0
2021-08-30	AADR	ETF	68.78	68.8	68.46	68.46	900.0
2021-08-30	AAXJ	ETF	87.45	87.6	86.99	87.46	750800.0
2021-08-30	ABEQ	ETF	27.87	27.87	27.805	27.805	600.0
2021-08-30	ACES	ETF	71.0	71.0	70.25	70.52	26800.0
2021-08-30	ACIO	ETF	31.06	31.22	31.06	31.19	21300.0
2021-08-30	ACSI	ETF	51.5111	51.5111	51.5111	51.5111	71.0
2021-08-30	ACTV	ETF	38.6	38.68	38.545	38.545	8245.0
2021-08-30	ACTX	ETF	1.03	1.25	1.0	1.0	4962.0
2021-08-30	ACVF	ETF	33.79	33.79	33.455	33.53	45900.0
2021-08-30	ACWF	ETF	39.01	39.11	38.9324	38.9324	407518.0
2021-08-30	ACWI	ETF	104.15	104.45	103.97	104.26	1856600.0
2021-08-30	ACWV	ETF	106.38	106.84	106.38	106.64	109600.0
2021-08-30	ACWX	ETF	57.2	57.26	57.055	57.2	224324.0
2021-08-30	ADFI	ETF	9.68	9.765	9.68	9.765	2000.0
2021-08-30	ADIV	ETF	17.959	17.959	17.959	17.959	1400.0
2021-08-30	ADME	ETF	41.34	41.46	41.3	41.381	16100.0
2021-08-30	ADRE	ETF	51.16	51.55	50.965	51.5136	13869.0
2021-08-30	AESR	ETF	14.32	14.35	14.29	14.3	12600.0
2021-08-30	AFIF	ETF	9.68	9.7	9.67	9.7	36069.0
2021-08-30	AFK	ETF	21.84	21.84	21.7	21.79	4451.0
2021-08-30	AFLG	ETF	26.764	26.764	26.764	26.764	100.0
2021-08-30	AFMC	ETF	26.219	26.219	26.219	26.219	100.0
2021-08-30	AFSM	ETF	26.76	26.76	26.708	26.708	1200.0
2021-08-30	AFTY	ETF	19.73	19.75	19.73	19.75	1100.0
2021-08-30	AGG	ETF	116.02	116.23	116.0	116.23	3706000.0
2021-08-30	AGGY	ETF	52.62	52.7	52.58	52.7	130400.0
2021-08-30	AGNG	ETF	30.87	30.98	30.83	30.96	4600.0
2021-08-30	AGOV	ETF	100.73	100.83	100.65	100.7778	3331.0
2021-08-30	AGOX	ETF	27.01	27.01	26.661	26.76	78300.0
2021-08-30	AGQ	ETF	38.51	38.58	37.78	38.16	513000.0
2021-08-30	AGZ	ETF	119.1	119.2613	119.1	119.2613	28967.0
2021-08-30	AGZD	ETF	23.44	23.44	23.395	23.4	11200.0
2021-08-30	AIA	ETF	81.33	81.72	81.0401	81.5	70778.0
2021-08-30	AIEQ	ETF	42.93	43.0	42.678	42.98	18500.0
2021-08-30	AIQ	ETF	31.51	31.72	31.44	31.65	13190.0
2021-08-30	AIRR	ETF	42.85	42.85	42.541	42.68	14100.0
2021-08-30	AIVI	ETF	43.32	43.42	43.32	43.32	6500.0
2021-08-30	ALTL	ETF	43.36	43.47	43.2	43.41	24868.0
2021-08-30	ALTY	ETF	13.71	13.75	13.67	13.725	30300.0
2021-08-30	AMJ	ETF	17.82	17.91	17.61	17.61	399982.0
2021-08-30	AMLP	ETF	32.95	33.05	32.46	32.47	1560600.0
2021-08-30	AMNA	ETF	31.9578	31.9578	31.9578	31.9578	60.0

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

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