PREVIEW / etf_daily / 2020-11-13

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-13.parquet
  size:    81 KB
  rows:    2,143

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-13	SPY	ETF	355.27	358.9	354.71	358.1	62892200.0
2020-11-13	QQQ	ETF	290.01	291.57	287.8701	290.93	24880582.0
2020-11-13	IWM	ETF	171.35	174.13	171.31	173.5	25440400.0
2020-11-13	DIA	ETF	292.97	295.92	292.42	295.15	3090400.0
2020-11-13	GLD	ETF	177.65	177.8	176.84	177.16	6469800.0
2020-11-13	TLT	ETF	158.36	158.5	157.91	158.16	7344600.0
2020-11-13	AAA	ETF	25.0	25.01	25.0	25.01	2580.0
2020-11-13	AAAU	ETF	18.86	18.87	18.77	18.8	1133000.0
2020-11-13	AADR	ETF	57.41	57.71	57.41	57.71	4200.0
2020-11-13	AAXJ	ETF	84.41	84.5	83.87	84.33	774900.0
2020-11-13	ABEQ	ETF	24.51	24.56	24.5	24.516	10000.0
2020-11-13	ACES	ETF	62.83	62.855	61.457	61.97	63200.0
2020-11-13	ACIO	ETF	27.285	27.4	27.285	27.4	27600.0
2020-11-13	ACSI	ETF	41.2335	41.2335	41.2335	41.2335	100.0
2020-11-13	ACTV	ETF	27.5	27.6659	27.45	27.6659	3229.0
2020-11-13	ACTX	ETF	2.93	3.11	2.93	3.11	762.0
2020-11-13	ACVF	ETF	26.47	26.572	26.4	26.572	5500.0
2020-11-13	ACWF	ETF	31.71	31.8402	31.71	31.8402	1587.0
2020-11-13	ACWI	ETF	85.5	86.13	85.31	86.0	1692600.0
2020-11-13	ACWV	ETF	95.68	96.43	95.68	96.25	484700.0
2020-11-13	ACWX	ETF	49.72	50.06	49.68	50.02	1939482.0
2020-11-13	ADFI	ETF	9.945	9.945	9.945	9.945	100.0
2020-11-13	ADME	ETF	34.889	34.94	34.79	34.94	15200.0
2020-11-13	ADRE	ETF	52.43	52.85	52.022	52.555	19928.0
2020-11-13	AESR	ETF	11.41	11.489	11.41	11.489	400.0
2020-11-13	AFIF	ETF	9.79	9.79	9.7701	9.78	9473.0
2020-11-13	AFK	ETF	19.2	19.83	19.2	19.55	14664.0
2020-11-13	AFLG	ETF	21.372	21.372	21.372	21.372	100.0
2020-11-13	AFSM	ETF	19.845	19.845	19.845	19.845	100.0
2020-11-13	AFTY	ETF	21.0	21.03	20.89	21.029	1600.0
2020-11-13	AGG	ETF	117.52	117.69	117.52	117.64	5125300.0
2020-11-13	AGGY	ETF	53.63	53.64	53.579	53.59	86000.0
2020-11-13	AGNG	ETF	26.74	26.868	26.715	26.868	1200.0
2020-11-13	AGQ	ETF	46.0	46.24	45.43	45.59	800200.0
2020-11-13	AGZ	ETF	120.66	120.77	120.65	120.65	43497.0
2020-11-13	AGZD	ETF	23.545	23.55	23.5	23.505	18200.0
2020-11-13	AIA	ETF	80.65	80.97	80.5121	80.82	157777.0
2020-11-13	AIEQ	ETF	31.75	31.96	31.695	31.884	10000.0
2020-11-13	AIQ	ETF	24.99	25.029	24.75	24.99	35069.0
2020-11-13	AIRR	ETF	29.9	30.27	29.9	30.27	7000.0
2020-11-13	AIVI	ETF	38.29	38.6	38.29	38.6	12300.0
2020-11-13	ALTL	ETF	27.55	27.87	27.5295	27.87	2899.0
2020-11-13	ALTY	ETF	11.145	11.279	11.145	11.258	8600.0
2020-11-13	AMJ	ETF	12.71	12.92	12.62	12.65	1147974.0
2020-11-13	AMLP	ETF	22.7	23.22	22.61	23.01	3287900.0
2020-11-13	AMNA	ETF	23.1991	23.1991	23.1991	23.1991	0.0
2020-11-13	AMND	ETF	24.6	24.72	24.52	24.6492	1100.0
2020-11-13	AMOM	ETF	36.78	36.78	36.24	36.247	4200.0
2020-11-13	AMTR	ETF	26.09	26.23	26.03	26.13	51200.0
2020-11-13	AMUB	ETF	7.98	8.09	7.97	8.05	18480.0

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

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