PREVIEW / etf_daily / 2020-04-20

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-20.parquet
  size:    74 KB
  rows:    1,958

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-04-20	SPY	ETF	282.61	286.79	281.35	281.59	100109300.0
2020-04-20	QQQ	ETF	213.27	215.88	212.57	212.74	38249128.0
2020-04-20	IWM	ETF	119.59	122.9	119.04	120.62	36700500.0
2020-04-20	DIA	ETF	238.24	241.11	236.26	236.64	7357400.0
2020-04-20	GLD	ETF	158.62	160.22	158.46	159.7	10688700.0
2020-04-20	TLT	ETF	168.44	169.29	167.96	169.16	6462600.0
2020-04-20	AAAU	ETF	16.91	17.1	16.8	17.03	292100.0
2020-04-20	AADR	ETF	44.16	45.04	44.04	44.62	30400.0
2020-04-20	AAXJ	ETF	63.22	63.72	62.94	63.03	940400.0
2020-04-20	ABEQ	ETF	21.605	21.67	21.46	21.46	75000.0
2020-04-20	ACES	ETF	31.59	31.8	31.221	31.38	22600.0
2020-04-20	ACIO	ETF	23.92	23.92	23.756	23.771	6400.0
2020-04-20	ACSI	ETF	30.55	30.55	30.3168	30.3168	211.0
2020-04-20	ACTX	ETF	4.602	4.72	4.602	4.602	309.0
2020-04-20	ACWF	ETF	25.88	26.0032	25.6726	25.6726	15668.0
2020-04-20	ACWI	ETF	66.81	67.75	66.67	66.82	5004300.0
2020-04-20	ACWV	ETF	86.59	87.1	85.85	85.95	384200.0
2020-04-20	ACWX	ETF	38.92	39.46	38.9	38.93	3514640.0
2020-04-20	ADME	ETF	30.184	30.23	29.99	30.02	12600.0
2020-04-20	ADRE	ETF	35.9003	36.2792	35.7994	35.7994	7034.0
2020-04-20	AESR	ETF	9.2	9.21	9.05	9.064	20300.0
2020-04-20	AFIF	ETF	10.18	10.18	9.74	9.79	360245.0
2020-04-20	AFK	ETF	13.63	13.9023	13.63	13.785	9595.0
2020-04-20	AFLG	ETF	17.297	17.3	17.179	17.179	300.0
2020-04-20	AFTY	ETF	15.55	15.62	15.49	15.516	2400.0
2020-04-20	AGG	ETF	117.15	117.28	116.94	117.08	3847900.0
2020-04-20	AGGY	ETF	53.1	53.296	53.05	53.12	281000.0
2020-04-20	AGNG	ETF	22.32	22.801	22.32	22.597	2100.0
2020-04-20	AGQ	ETF	21.42	22.19	21.42	21.87	185600.0
2020-04-20	AGZ	ETF	120.31	120.49	120.2855	120.49	36221.0
2020-04-20	AGZD	ETF	23.51	23.585	23.4	23.485	17800.0
2020-04-20	AIA	ETF	58.61	59.33	58.51	58.52	57397.0
2020-04-20	AIEQ	ETF	25.02	25.713	25.02	25.38	22100.0
2020-04-20	AIQ	ETF	17.24	17.58	17.23	17.36	38699.0
2020-04-20	AIRR	ETF	20.17	20.55	20.02	20.141	7400.0
2020-04-20	AIVI	ETF	32.18	32.64	32.18	32.2	15900.0
2020-04-20	ALTY	ETF	9.41	9.584	9.27	9.27	10300.0
2020-04-20	AMJ	ETF	10.79	11.62	10.4472	11.06	5458530.0
2020-04-20	AMLP	ETF	19.85	21.95	19.55	20.95	9639280.0
2020-04-20	AMOM	ETF	25.54	25.54	25.179	25.179	100.0
2020-04-20	AMUB	ETF	6.9801	6.9801	6.9801	6.9801	38.0
2020-04-20	AMZA	ETF	13.1	14.282	12.5	13.625	133000.0
2020-04-20	ANGL	ETF	26.96	27.27	26.62	26.89	1083600.0
2020-04-20	AOA	ETF	50.24	50.7	50.0	50.09	178100.0
2020-04-20	AOK	ETF	34.81	34.99	34.7783	34.82	275520.0
2020-04-20	AOM	ETF	37.74	38.0063	37.7	37.72	356767.0
2020-04-20	AOR	ETF	43.14	43.43	43.02	43.07	254803.0
2020-04-20	ARCM	ETF	100.44	100.44	100.275	100.275	700.0
2020-04-20	ARGT	ETF	17.5	18.19	17.5	17.86	29500.0
2020-04-20	ARKF	ETF	22.76	23.4	22.67	23.03	92600.0

> showing 50 of 1,958 rows — these rows as CSV

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