PREVIEW / etf_daily / 2020-08-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-18.parquet
  size:    78 KB
  rows:    2,068

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-18	SPY	ETF	338.34	339.1	336.61	338.64	38733900.0
2020-08-18	QQQ	ETF	276.41	278.465	274.91	277.97	23529498.0
2020-08-18	IWM	ETF	157.85	157.85	155.71	156.39	14670400.0
2020-08-18	DIA	ETF	279.1	279.37	277.11	278.2	1678300.0
2020-08-18	GLD	ETF	189.18	189.4	185.63	188.18	16291600.0
2020-08-18	TLT	ETF	164.36	164.87	164.09	164.76	8140600.0
2020-08-18	AAAU	ETF	20.07	20.1	19.71	19.97	527500.0
2020-08-18	AADR	ETF	58.21	58.39	58.21	58.26	4800.0
2020-08-18	AAXJ	ETF	77.61	77.74	77.08	77.62	560900.0
2020-08-18	ABEQ	ETF	23.608	23.699	23.608	23.651	4600.0
2020-08-18	ACES	ETF	51.86	51.86	50.685	50.99	91600.0
2020-08-18	ACIO	ETF	26.72	26.865	26.72	26.84	22700.0
2020-08-18	ACSI	ETF	37.64	37.6411	37.64	37.6411	732.0
2020-08-18	ACTX	ETF	2.3541	2.7465	2.3541	2.7465	292.0
2020-08-18	ACWF	ETF	30.39	30.4	30.3414	30.3414	3829.0
2020-08-18	ACWI	ETF	80.92	81.07	80.45	80.85	930600.0
2020-08-18	ACWV	ETF	93.29	93.44	92.85	93.21	201900.0
2020-08-18	ACWX	ETF	47.14	47.22	46.835	47.03	858943.0
2020-08-18	ADFI	ETF	10.03	10.03	10.0203	10.0203	163016.0
2020-08-18	ADME	ETF	34.03	34.25	34.03	34.185	19100.0
2020-08-18	ADRE	ETF	46.43	46.75	46.34	46.46	5494.0
2020-08-18	AESR	ETF	10.875	10.96	10.875	10.938	6200.0
2020-08-18	AFIF	ETF	9.8499	9.85	9.82	9.8393	215040.0
2020-08-18	AFK	ETF	17.54	18.19	17.25	17.518	17718.0
2020-08-18	AFLG	ETF	20.51	20.551	20.51	20.551	200.0
2020-08-18	AFSM	ETF	18.48	18.48	18.459	18.459	200.0
2020-08-18	AFTY	ETF	19.48	19.48	19.39	19.458	8900.0
2020-08-18	AGG	ETF	118.43	118.6	118.42	118.53	4765800.0
2020-08-18	AGGY	ETF	54.06	54.15	54.06	54.11	105200.0
2020-08-18	AGNG	ETF	25.86	25.86	25.64	25.779	3600.0
2020-08-18	AGQ	ETF	64.62	64.98	58.95	62.11	3817400.0
2020-08-18	AGZ	ETF	121.29	121.36	121.21	121.36	83929.0
2020-08-18	AGZD	ETF	23.56	23.615	23.52	23.565	380400.0
2020-08-18	AIA	ETF	72.24	72.24	71.78	72.12	44192.0
2020-08-18	AIEQ	ETF	30.96	31.15	30.83	30.98	46500.0
2020-08-18	AIQ	ETF	22.68	22.8	22.605	22.775	25929.0
2020-08-18	AIRR	ETF	27.16	27.183	26.921	26.921	1800.0
2020-08-18	AIVI	ETF	37.78	37.82	37.6	37.63	3600.0
2020-08-18	ALTL	ETF	25.29	25.73	25.15	25.3745	84149.0
2020-08-18	ALTY	ETF	11.18	11.18	10.99	11.015	10600.0
2020-08-18	AMJ	ETF	13.81	13.87	13.54	13.57	571445.0
2020-08-18	AMLP	ETF	24.9	24.95	24.3	24.4	1849300.0
2020-08-18	AMNA	ETF	25.61	25.61	25.2554	25.2554	1200.0
2020-08-18	AMND	ETF	26.62	26.6257	26.62	26.6257	1002.0
2020-08-18	AMOM	ETF	36.0	36.0	35.182	35.182	1900.0
2020-08-18	AMUB	ETF	8.77	8.77	8.51	8.52	15354.0
2020-08-18	AMZA	ETF	18.71	18.735	18.05	18.15	116600.0
2020-08-18	ANGL	ETF	30.34	30.39	30.19	30.26	414200.0
2020-08-18	AOA	ETF	58.81	58.86	58.52	58.72	30400.0
2020-08-18	AOK	ETF	37.54	37.5589	37.4229	37.43	63634.0

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

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