PREVIEW / etf_daily / 2021-08-27

all etf daily files

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

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-27	SPY	ETF	447.12	450.65	447.06	450.25	77235100.0
2021-08-27	QQQ	ETF	373.07	376.56	372.57	376.04	27104749.0
2021-08-27	IWM	ETF	220.65	227.03	220.57	226.41	33998500.0
2021-08-27	DIA	ETF	352.65	354.85	352.65	354.57	3163700.0
2021-08-27	GLD	ETF	167.58	170.19	166.87	170.19	10036400.0
2021-08-27	TLT	ETF	148.57	149.49	148.33	149.46	15384700.0
2021-08-27	AAA	ETF	25.01	25.015	25.01	25.015	100.0
2021-08-27	AAAU	ETF	17.82	18.1	17.75	18.1	258800.0
2021-08-27	AADR	ETF	68.62	68.73	68.62	68.73	600.0
2021-08-27	AAXJ	ETF	86.65	87.29	86.65	87.25	470800.0
2021-08-27	ABEQ	ETF	27.85	27.921	27.85	27.921	500.0
2021-08-27	ACES	ETF	69.99	70.865	69.56	70.54	48600.0
2021-08-27	ACIO	ETF	31.05	31.08	30.99	31.07	71900.0
2021-08-27	ACSI	ETF	51.4626	51.4626	51.4626	51.4626	25.0
2021-08-27	ACTV	ETF	38.54	38.59	38.511	38.5349	2869.0
2021-08-27	ACTX	ETF	1.24	1.24	1.06	1.1	3251.0
2021-08-27	ACVF	ETF	33.38	33.49	33.27	33.45	9100.0
2021-08-27	ACWF	ETF	38.53	38.9192	38.53	38.8894	2438.0
2021-08-27	ACWI	ETF	103.17	104.04	103.17	103.98	2517600.0
2021-08-27	ACWV	ETF	105.83	106.46	105.79	106.37	66800.0
2021-08-27	ACWX	ETF	56.69	57.195	56.66	57.18	739813.0
2021-08-27	ADFI	ETF	9.731	9.79	9.73	9.772	16200.0
2021-08-27	ADIV	ETF	18.047	18.047	18.047	18.047	100.0
2021-08-27	ADME	ETF	40.945	41.21	40.913	41.2	53900.0
2021-08-27	ADRE	ETF	50.98	51.3262	50.96	51.19	71632.0
2021-08-27	AESR	ETF	14.25	14.27	14.24	14.262	9300.0
2021-08-27	AFIF	ETF	9.67	9.7006	9.67	9.6948	23854.0
2021-08-27	AFK	ETF	21.72	21.8	21.63	21.8	3248.0
2021-08-27	AFLG	ETF	26.57	26.657	26.57	26.657	200.0
2021-08-27	AFMC	ETF	26.28	26.28	26.239	26.239	200.0
2021-08-27	AFSM	ETF	26.85	26.85	26.781	26.781	100.0
2021-08-27	AFTY	ETF	20.06	20.105	20.06	20.105	1300.0
2021-08-27	AGG	ETF	115.81	116.1	115.71	116.1	5545600.0
2021-08-27	AGGY	ETF	52.48	52.62	52.437	52.62	42400.0
2021-08-27	AGNG	ETF	30.62	30.855	30.62	30.731	2500.0
2021-08-27	AGOV	ETF	100.38	100.67	100.305	100.4697	3420.0
2021-08-27	AGOX	ETF	26.28	26.76	26.28	26.65	156600.0
2021-08-27	AGQ	ETF	36.27	38.52	35.96	38.44	1269800.0
2021-08-27	AGZ	ETF	118.96	119.22	118.92	119.13	13460.0
2021-08-27	AGZD	ETF	23.405	23.465	23.4	23.41	23600.0
2021-08-27	AIA	ETF	81.23	81.71	81.16	81.64	37669.0
2021-08-27	AIEQ	ETF	42.09	42.77	42.09	42.73	22400.0
2021-08-27	AIQ	ETF	31.06	31.4591	31.05	31.435	12404.0
2021-08-27	AIRR	ETF	41.95	42.91	41.9	42.83	11500.0
2021-08-27	AIVI	ETF	42.83	43.23	42.83	43.23	3700.0
2021-08-27	ALTL	ETF	43.12	43.33	43.08	43.22	95508.0
2021-08-27	ALTY	ETF	13.651	13.76	13.64	13.74	15400.0
2021-08-27	AMJ	ETF	17.5	17.91	17.49	17.78	407135.0
2021-08-27	AMLP	ETF	32.07	32.96	32.07	32.82	1903200.0
2021-08-27	AMNA	ETF	32.1487	32.1487	32.1487	32.1487	0.0

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

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