PREVIEW / etf_daily / 2020-11-17

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-17.parquet
  size:    80 KB
  rows:    2,132

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-11-17	SPY	ETF	359.97	361.92	358.34	360.62	66111000.0
2020-11-17	QQQ	ETF	293.4	293.74	291.61	292.27	21843463.0
2020-11-17	IWM	ETF	176.04	178.8	174.28	178.46	26154500.0
2020-11-17	DIA	ETF	297.31	299.15	295.6	298.31	4049200.0
2020-11-17	GLD	ETF	177.25	177.44	176.09	176.5	8229100.0
2020-11-17	TLT	ETF	158.77	159.16	158.59	158.81	7444600.0
2020-11-17	AAA	ETF	25.01	25.01	25.0	25.005	4621.0
2020-11-17	AAAU	ETF	18.81	18.84	18.7	18.74	842600.0
2020-11-17	AADR	ETF	57.03	57.08	56.7	56.7	27000.0
2020-11-17	AAXJ	ETF	84.91	85.41	84.76	85.18	2080000.0
2020-11-17	ABEQ	ETF	24.5	24.95	24.5	24.84	4200.0
2020-11-17	ACES	ETF	63.01	63.72	62.25	63.61	80500.0
2020-11-17	ACIO	ETF	27.287	27.55	27.287	27.37	20300.0
2020-11-17	ACSI	ETF	41.6495	41.8799	41.6495	41.7493	1421.0
2020-11-17	ACTV	ETF	28.13	28.47	28.13	28.3909	6543.0
2020-11-17	ACTX	ETF	2.85	2.85	2.85	2.85	224.0
2020-11-17	ACVF	ETF	26.93	26.93	26.63	26.747	7500.0
2020-11-17	ACWF	ETF	32.08	32.1713	32.08	32.1216	1723.0
2020-11-17	ACWI	ETF	86.55	87.08	86.31	86.85	2094300.0
2020-11-17	ACWV	ETF	96.49	96.73	96.29	96.39	245700.0
2020-11-17	ACWX	ETF	50.42	50.6889	50.3	50.57	1718681.0
2020-11-17	ADFI	ETF	9.97	9.97	9.97	9.97	100.0
2020-11-17	ADME	ETF	34.926	35.053	34.914	34.96	19700.0
2020-11-17	ADRE	ETF	53.19	53.23	52.98	53.045	10698.0
2020-11-17	AESR	ETF	11.5	11.54	11.5	11.523	1000.0
2020-11-17	AFIF	ETF	9.9	9.9	9.77	9.7946	35671.0
2020-11-17	AFK	ETF	19.74	19.829	19.69	19.72	8996.0
2020-11-17	AFLG	ETF	21.546	21.546	21.487	21.487	400.0
2020-11-17	AFTY	ETF	21.41	21.49	21.41	21.465	3100.0
2020-11-17	AGG	ETF	117.75	117.9	117.75	117.87	4650100.0
2020-11-17	AGGY	ETF	53.65	53.74	53.65	53.69	107800.0
2020-11-17	AGNG	ETF	26.81	26.81	26.55	26.8	3600.0
2020-11-17	AGQ	ETF	45.25	45.38	44.47	44.88	922600.0
2020-11-17	AGZ	ETF	120.81	120.81	120.6508	120.75	39113.0
2020-11-17	AGZD	ETF	23.57	23.57	23.53	23.555	11000.0
2020-11-17	AIA	ETF	81.81	82.28	81.62	81.96	168343.0
2020-11-17	AIEQ	ETF	32.04	32.285	31.96	32.185	6600.0
2020-11-17	AIQ	ETF	25.06	25.24	25.0	25.17	34924.0
2020-11-17	AIRR	ETF	31.06	31.289	30.74	31.2	14700.0
2020-11-17	AIVI	ETF	38.81	38.99	38.76	38.9	7300.0
2020-11-17	ALTL	ETF	28.71	29.19	28.48	29.1263	7574.0
2020-11-17	ALTY	ETF	11.41	11.51	11.4	11.48	12100.0
2020-11-17	AMJ	ETF	13.15	13.59	13.025	13.59	738395.0
2020-11-17	AMLP	ETF	23.79	24.53	23.46	24.52	2788600.0
2020-11-17	AMNA	ETF	24.2872	24.2872	24.2872	24.2872	2.0
2020-11-17	AMND	ETF	25.8163	25.8163	25.8163	25.8163	0.0
2020-11-17	AMOM	ETF	36.78	36.78	36.65	36.687	2300.0
2020-11-17	AMTR	ETF	26.64	27.41	26.43	27.34	405500.0
2020-11-17	AMUB	ETF	8.25	8.53	8.2	8.53	53928.0
2020-11-17	AMZA	ETF	17.35	17.915	17.0	17.88	115100.0

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

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