PREVIEW / etf_daily / 2020-09-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-28.parquet
  size:    79 KB
  rows:    2,096

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
2020-09-28	SPY	ETF	333.22	334.96	332.15	334.19	64584600.0
2020-09-28	QQQ	ETF	276.615	277.2	271.674	277.2	58438286.0
2020-09-28	IWM	ETF	148.37	150.44	146.4	150.02	17600900.0
2020-09-28	DIA	ETF	275.26	277.12	274.72	275.9	2790200.0
2020-09-28	GLD	ETF	175.83	176.81	175.09	176.7	7109700.0
2020-09-28	TLT	ETF	164.87	164.9	164.37	164.65	4470100.0
2020-09-28	AAA	ETF	24.96	24.97	24.955	24.955	6303.0
2020-09-28	AAAU	ETF	18.64	18.76	18.58	18.75	319700.0
2020-09-28	AADR	ETF	54.99	55.11	54.8	54.99	7300.0
2020-09-28	AAXJ	ETF	76.02	76.14	75.69	76.06	396800.0
2020-09-28	ABEQ	ETF	23.45	23.54	23.45	23.54	14100.0
2020-09-28	ACES	ETF	52.83	53.68	52.656	53.63	37200.0
2020-09-28	ACIO	ETF	26.57	26.63	26.51	26.58	17700.0
2020-09-28	ACSI	ETF	37.3533	37.3533	37.3533	37.3533	100.0
2020-09-28	ACTX	ETF	2.1299	2.36	1.8467	1.8467	2668.0
2020-09-28	ACWF	ETF	29.54	29.64	29.54	29.6258	3505.0
2020-09-28	ACWI	ETF	79.69	79.93	79.45	79.84	2842900.0
2020-09-28	ACWV	ETF	91.34	91.95	91.14	91.76	304200.0
2020-09-28	ACWX	ETF	45.97	46.05	45.86	46.04	733174.0
2020-09-28	ADFI	ETF	9.97	9.97	9.97	9.97	100.0
2020-09-28	ADME	ETF	33.87	33.87	33.34	33.42	17800.0
2020-09-28	ADRE	ETF	46.12	46.12	45.743	45.9282	4091.0
2020-09-28	AESR	ETF	10.815	10.851	10.815	10.851	4900.0
2020-09-28	AFIF	ETF	9.815	9.83	9.815	9.815	20685.0
2020-09-28	AFK	ETF	17.2	17.525	17.2	17.29	8725.0
2020-09-28	AFLG	ETF	20.08	20.119	20.07	20.119	15600.0
2020-09-28	AFMC	ETF	17.671	17.671	17.671	17.671	100.0
2020-09-28	AFSM	ETF	17.898	17.898	17.898	17.898	100.0
2020-09-28	AFTY	ETF	19.23	19.312	19.23	19.312	3400.0
2020-09-28	AGG	ETF	118.18	118.23	118.11	118.23	5830400.0
2020-09-28	AGGY	ETF	53.8	53.83	53.76	53.78	108300.0
2020-09-28	AGNG	ETF	25.43	25.47	25.39	25.47	3800.0
2020-09-28	AGQ	ETF	42.26	43.68	41.46	43.45	2027700.0
2020-09-28	AGZ	ETF	121.14	121.29	121.13	121.17	32004.0
2020-09-28	AGZD	ETF	23.465	23.465	23.4	23.41	6800.0
2020-09-28	AIA	ETF	70.98	70.98	70.71	70.94	48656.0
2020-09-28	AIEQ	ETF	30.43	30.61	30.35	30.61	44600.0
2020-09-28	AIQ	ETF	23.17	23.26	23.055	23.2255	12289.0
2020-09-28	AIRR	ETF	25.5	26.034	25.5	25.96	17600.0
2020-09-28	AIVI	ETF	35.91	36.04	35.87	36.02	9400.0
2020-09-28	ALTL	ETF	24.91	25.02	24.9079	24.9079	7101.0
2020-09-28	ALTY	ETF	10.47	10.6	10.47	10.56	6100.0
2020-09-28	AMJ	ETF	10.71	10.94	10.57	10.85	1095422.0
2020-09-28	AMLP	ETF	19.8	20.22	19.52	20.11	2648800.0
2020-09-28	AMNA	ETF	22.2213	22.2213	22.2213	22.2213	0.0
2020-09-28	AMND	ETF	23.1996	23.1996	23.1996	23.1996	0.0
2020-09-28	AMOM	ETF	35.0	35.28	35.0	35.122	1100.0
2020-09-28	AMUB	ETF	6.69	6.8393	6.69	6.8393	5274.0
2020-09-28	AMZA	ETF	13.14	13.554	12.97	13.43	98400.0
2020-09-28	ANGL	ETF	29.5	29.61	29.46	29.57	397300.0

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

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