PREVIEW / etf_daily / 2020-05-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-01.parquet
  size:    74 KB
  rows:    1,952

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-05-01	SPY	ETF	285.31	290.66	281.52	282.79	125180000.0
2020-05-01	QQQ	ETF	214.54	216.67	211.68	212.74	48794968.0
2020-05-01	IWM	ETF	127.15	127.46	123.29	125.14	43352000.0
2020-05-01	DIA	ETF	239.58	240.33	236.5	237.28	4723500.0
2020-05-01	GLD	ETF	158.0	160.45	157.8	159.78	10914300.0
2020-05-01	TLT	ETF	167.5	168.11	166.44	167.95	10209400.0
2020-05-01	AAAU	ETF	16.72	17.14	16.72	16.96	642400.0
2020-05-01	AADR	ETF	46.04	46.04	45.08	45.21	900.0
2020-05-01	AAXJ	ETF	62.62	62.66	61.66	61.8	934600.0
2020-05-01	ABEQ	ETF	21.59	21.59	21.42	21.462	1300.0
2020-05-01	ACES	ETF	33.0	33.28	31.832	32.02	33600.0
2020-05-01	ACIO	ETF	23.756	23.756	23.67	23.75	9300.0
2020-05-01	ACSI	ETF	30.0515	30.0515	30.0515	30.0515	106.0
2020-05-01	ACTX	ETF	5.9001	5.9001	4.248	4.3011	213.0
2020-05-01	ACWF	ETF	25.7699	25.7699	25.4601	25.5435	9994.0
2020-05-01	ACWI	ETF	67.56	67.67	66.67	66.91	3467500.0
2020-05-01	ACWV	ETF	85.27	85.42	84.67	85.01	521900.0
2020-05-01	ACWX	ETF	39.35	39.43	38.87	39.04	3704767.0
2020-05-01	ADME	ETF	29.86	29.9	29.7	29.728	12800.0
2020-05-01	ADRE	ETF	35.35	35.35	34.78	34.8325	7463.0
2020-05-01	AESR	ETF	9.06	9.06	9.01	9.016	45600.0
2020-05-01	AFIF	ETF	9.78	9.82	9.77	9.8	439151.0
2020-05-01	AFK	ETF	14.43	14.43	14.2573	14.3154	5431.0
2020-05-01	AFLG	ETF	17.29	17.29	17.288	17.288	100.0
2020-05-01	AFSM	ETF	14.97	14.97	14.969	14.969	500.0
2020-05-01	AFTY	ETF	15.32	15.33	15.09	15.107	4800.0
2020-05-01	AGG	ETF	116.97	117.1	116.68	116.87	6099500.0
2020-05-01	AGGY	ETF	52.96	53.35	52.96	53.01	263500.0
2020-05-01	AGNG	ETF	22.2	22.2	21.9	22.085	2000.0
2020-05-01	AGQ	ETF	19.97	20.21	19.54	20.04	236300.0
2020-05-01	AGZ	ETF	120.37	120.645	120.37	120.6	39911.0
2020-05-01	AGZD	ETF	23.47	23.75	23.345	23.495	10800.0
2020-05-01	AIA	ETF	58.37	58.38	57.38	57.5	165863.0
2020-05-01	AIEQ	ETF	25.12	25.408	24.901	25.01	24500.0
2020-05-01	AIQ	ETF	17.46	17.52	17.2	17.2737	8374.0
2020-05-01	AIRR	ETF	21.577	21.577	20.85	21.073	9100.0
2020-05-01	AIVI	ETF	32.77	32.89	32.54	32.75	46000.0
2020-05-01	ALTY	ETF	10.05	10.05	9.74	9.77	6900.0
2020-05-01	AMJ	ETF	13.23	13.45	12.87	13.01	2427871.0
2020-05-01	AMLP	ETF	25.25	25.25	24.1	24.35	5332360.0
2020-05-01	AMUB	ETF	8.21	8.32	8.09	8.18	9478.0
2020-05-01	AMZA	ETF	17.75	17.75	16.596	16.7	136900.0
2020-05-01	ANGL	ETF	26.79	26.89	26.51	26.6	1300400.0
2020-05-01	AOA	ETF	50.69	50.69	50.07	50.26	104600.0
2020-05-01	AOK	ETF	34.95	35.08	34.8	34.9	748085.0
2020-05-01	AOM	ETF	38.11	38.11	37.66	37.79	490603.0
2020-05-01	AOR	ETF	43.4	43.44	43.06	43.16	190425.0
2020-05-01	ARCM	ETF	100.78	100.78	100.42	100.42	400.0
2020-05-01	ARGT	ETF	17.77	17.77	17.6	17.72	29500.0
2020-05-01	ARKF	ETF	23.57	23.81	23.42	23.62	58100.0

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

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