PREVIEW / etf_daily / 2020-11-09

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-09.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-09	SPY	ETF	363.97	364.38	354.06	354.56	172304200.0
2020-11-09	QQQ	ETF	297.31	299.14	288.12	288.59	86537071.0
2020-11-09	IWM	ETF	176.95	178.1	169.33	169.55	55052700.0
2020-11-09	DIA	ETF	298.61	299.49	291.39	291.72	10839300.0
2020-11-09	GLD	ETF	176.42	176.45	173.64	175.08	29800700.0
2020-11-09	TLT	ETF	155.97	156.15	154.63	156.06	23245000.0
2020-11-09	AAA	ETF	24.9299	24.94	24.9299	24.93	4764.0
2020-11-09	AAAU	ETF	18.73	18.73	18.43	18.59	2382800.0
2020-11-09	AADR	ETF	60.4	60.4	57.01	57.01	20500.0
2020-11-09	AAXJ	ETF	86.4	86.4	84.16	84.21	1971400.0
2020-11-09	ABEQ	ETF	24.67	24.715	24.523	24.523	3800.0
2020-11-09	ACES	ETF	66.31	66.31	61.5	61.56	144400.0
2020-11-09	ACIO	ETF	27.81	28.06	27.39	27.85	54900.0
2020-11-09	ACSI	ETF	40.422	40.422	40.422	40.422	102.0
2020-11-09	ACTV	ETF	28.07	28.07	27.02	27.23	368967.0
2020-11-09	ACTX	ETF	2.7	2.93	1.75	1.75	1743.0
2020-11-09	ACVF	ETF	26.8	26.8	26.323	26.323	100.0
2020-11-09	ACWF	ETF	32.5	32.5	31.5024	31.5024	8968.0
2020-11-09	ACWI	ETF	87.44	87.48	85.09	85.15	9397600.0
2020-11-09	ACWV	ETF	97.33	97.33	94.93	94.97	464700.0
2020-11-09	ACWX	ETF	50.35	50.3742	49.41	49.43	1988402.0
2020-11-09	ADFI	ETF	9.915	9.915	9.915	9.915	100.0
2020-11-09	ADME	ETF	35.6	35.6	34.8	34.8	38300.0
2020-11-09	ADRE	ETF	53.63	53.69	52.1798	52.1798	26114.0
2020-11-09	AESR	ETF	11.588	11.588	11.381	11.381	900.0
2020-11-09	AFIF	ETF	9.8	9.8	9.73	9.74	10661.0
2020-11-09	AFK	ETF	19.35	19.68	19.31	19.31	8158.0
2020-11-09	AFMC	ETF	19.293	19.293	19.293	19.293	100.0
2020-11-09	AFSM	ETF	19.454	19.454	19.454	19.454	100.0
2020-11-09	AFTY	ETF	22.1	22.1	21.56	21.6	6200.0
2020-11-09	AGG	ETF	117.4	117.47	117.06	117.25	6625300.0
2020-11-09	AGGY	ETF	53.53	53.53	53.34	53.43	252400.0
2020-11-09	AGNG	ETF	26.98	27.153	26.85	26.85	8200.0
2020-11-09	AGQ	ETF	45.25	45.27	41.64	43.8	3772900.0
2020-11-09	AGZ	ETF	120.52	120.52	120.34	120.42	32396.0
2020-11-09	AGZD	ETF	23.62	23.62	23.395	23.49	30600.0
2020-11-09	AIA	ETF	82.08	82.08	80.0101	80.16	536704.0
2020-11-09	AIEQ	ETF	32.79	32.79	31.359	31.359	27100.0
2020-11-09	AIQ	ETF	26.01	26.01	25.02	25.03	184013.0
2020-11-09	AIRR	ETF	29.8	30.2	29.572	29.572	21400.0
2020-11-09	AIVI	ETF	38.26	38.26	37.64	37.64	18200.0
2020-11-09	ALTL	ETF	27.54	28.4	27.54	27.9508	3265.0
2020-11-09	ALTY	ETF	10.85	11.13	10.85	11.018	46000.0
2020-11-09	AMJ	ETF	12.1	12.635	12.02	12.43	1889175.0
2020-11-09	AMLP	ETF	22.5	23.41	22.25	22.87	6067500.0
2020-11-09	AMNA	ETF	22.63	22.63	22.5895	22.5895	240.0
2020-11-09	AMND	ETF	23.37	24.0201	23.37	24.0201	3100.0
2020-11-09	AMOM	ETF	39.13	39.13	36.162	36.162	2800.0
2020-11-09	AMTR	ETF	24.97	25.75	24.97	25.4296	16664.0
2020-11-09	AMUB	ETF	7.52	7.94	7.51	7.78	141334.0

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

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