PREVIEW / etf_daily / 2020-08-13

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-13.parquet
  size:    77 KB
  rows:    2,048

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-08-13	SPY	ETF	336.61	338.25	335.83	336.83	41816100.0
2020-08-13	QQQ	ETF	272.64	274.83	271.51	272.48	31895717.0
2020-08-13	IWM	ETF	156.99	158.53	156.65	157.19	15799900.0
2020-08-13	DIA	ETF	279.13	280.22	278.23	279.42	1668300.0
2020-08-13	GLD	ETF	181.56	184.7	181.36	183.33	18596800.0
2020-08-13	TLT	ETF	165.31	165.58	163.17	163.82	12744700.0
2020-08-13	AAAU	ETF	19.25	19.6	19.25	19.47	603800.0
2020-08-13	AADR	ETF	57.5	57.95	57.5	57.56	7000.0
2020-08-13	AAXJ	ETF	76.93	77.08	76.55	76.84	514000.0
2020-08-13	ABEQ	ETF	23.525	23.58	23.43	23.47	4300.0
2020-08-13	ACES	ETF	50.11	50.96	49.92	50.5	71500.0
2020-08-13	ACIO	ETF	26.75	26.75	26.64	26.72	22700.0
2020-08-13	ACSI	ETF	37.6907	37.6907	37.6907	37.6907	174.0
2020-08-13	ACTX	ETF	2.3541	3.1654	2.3541	2.8704	1940.0
2020-08-13	ACWF	ETF	30.24	30.27	30.135	30.1831	6540.0
2020-08-13	ACWI	ETF	80.45	80.67	80.1	80.36	2716000.0
2020-08-13	ACWV	ETF	92.46	92.65	92.23	92.52	217000.0
2020-08-13	ACWX	ETF	46.94	47.034	46.675	46.85	569259.0
2020-08-13	ADME	ETF	33.945	34.1	33.94	34.003	12500.0
2020-08-13	ADRE	ETF	45.7542	45.862	45.61	45.7333	4427.0
2020-08-13	AESR	ETF	10.834	10.834	10.834	10.834	100.0
2020-08-13	AFIF	ETF	9.81	9.82	9.78	9.8	9037.0
2020-08-13	AFK	ETF	17.26	17.51	17.26	17.44	4852.0
2020-08-13	AFLG	ETF	20.442	20.442	20.442	20.442	100.0
2020-08-13	AFSM	ETF	18.65	18.67	18.568	18.568	3800.0
2020-08-13	AFTY	ETF	18.88	18.88	18.796	18.808	9900.0
2020-08-13	AGG	ETF	118.78	118.78	118.24	118.31	8023700.0
2020-08-13	AGGY	ETF	54.25	54.25	54.033	54.09	103600.0
2020-08-13	AGNG	ETF	25.69	25.93	25.69	25.815	8800.0
2020-08-13	AGQ	ETF	57.15	62.53	56.86	60.61	5363600.0
2020-08-13	AGZ	ETF	121.32	121.32	120.91	120.94	111605.0
2020-08-13	AGZD	ETF	23.625	23.625	23.625	23.625	2800.0
2020-08-13	AIA	ETF	71.77	71.77	71.34	71.58	64310.0
2020-08-13	AIEQ	ETF	30.32	30.72	30.32	30.59	10200.0
2020-08-13	AIQ	ETF	22.45	22.565	22.37	22.43	51688.0
2020-08-13	AIRR	ETF	27.52	27.545	27.17	27.26	24400.0
2020-08-13	AIVI	ETF	37.8	37.85	37.5	37.57	8200.0
2020-08-13	ALTL	ETF	25.28	25.309	25.21	25.2764	5126.0
2020-08-13	ALTY	ETF	11.19	11.23	11.07	11.105	15800.0
2020-08-13	AMJ	ETF	14.06	14.06	13.77	13.9	431319.0
2020-08-13	AMLP	ETF	25.14	25.28	24.75	24.99	1428100.0
2020-08-13	AMNA	ETF	25.6	25.6	25.28	25.42	15300.0
2020-08-13	AMND	ETF	26.8314	26.8314	26.8314	26.8314	0.0
2020-08-13	AMOM	ETF	34.25	34.54	34.25	34.321	1800.0
2020-08-13	AMUB	ETF	8.76	8.7624	8.68	8.7624	4558.0
2020-08-13	AMZA	ETF	19.02	19.073	18.52	18.85	117400.0
2020-08-13	ANGL	ETF	30.4	30.52	30.2	30.28	2182100.0
2020-08-13	AOA	ETF	58.55	58.75	58.31	58.5	30800.0
2020-08-13	AOK	ETF	37.5	37.54	37.35	37.43	117580.0
2020-08-13	AOM	ETF	41.37	41.45	41.2	41.3	132649.0

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

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