PREVIEW / etf_daily / 2020-04-28

all etf daily files

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

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-28	SPY	ETF	291.02	291.4	285.4	285.73	105270000.0
2020-04-28	QQQ	ETF	217.27	217.32	211.21	211.5	46862816.0
2020-04-28	IWM	ETF	131.12	131.46	127.28	129.11	47292700.0
2020-04-28	DIA	ETF	245.01	245.16	240.36	241.09	4709900.0
2020-04-28	GLD	ETF	160.89	160.98	159.16	160.84	10383000.0
2020-04-28	TLT	ETF	168.55	169.85	168.45	169.59	9905400.0
2020-04-28	AAAU	ETF	17.06	17.07	16.88	17.03	207900.0
2020-04-28	AADR	ETF	46.05	46.05	45.48	45.69	9000.0
2020-04-28	AAXJ	ETF	64.66	64.67	63.71	63.71	1952700.0
2020-04-28	ABEQ	ETF	22.03	22.17	22.03	22.061	2400.0
2020-04-28	ACES	ETF	33.41	33.71	32.871	33.2	26400.0
2020-04-28	ACIO	ETF	24.09	24.09	23.932	23.932	300.0
2020-04-28	ACSI	ETF	30.9222	30.9222	30.9222	30.9222	154.0
2020-04-28	ACTX	ETF	5.8263	5.8263	4.72	5.015	556.0
2020-04-28	ACWF	ETF	26.63	26.66	26.35	26.35	7453.0
2020-04-28	ACWI	ETF	68.97	69.09	67.89	68.0	2974300.0
2020-04-28	ACWV	ETF	88.19	88.19	87.06	87.15	357900.0
2020-04-28	ACWX	ETF	40.27	40.285	39.82	39.83	2978764.0
2020-04-28	ADME	ETF	30.15	30.26	29.79	29.79	1500.0
2020-04-28	ADRE	ETF	36.2	36.2	35.67	35.76	9328.0
2020-04-28	AESR	ETF	9.2	9.24	9.114	9.114	164000.0
2020-04-28	AFIF	ETF	9.8	9.88	9.78	9.825	890761.0
2020-04-28	AFK	ETF	14.61	14.61	14.43	14.55	17305.0
2020-04-28	AFLG	ETF	17.74	17.74	17.607	17.607	600.0
2020-04-28	AFSM	ETF	15.46	15.46	15.36	15.414	600.0
2020-04-28	AFTY	ETF	15.9	15.9	15.817	15.817	2200.0
2020-04-28	AGG	ETF	117.27	117.45	117.12	117.28	5889800.0
2020-04-28	AGGY	ETF	52.98	53.08	52.98	53.08	109600.0
2020-04-28	AGNG	ETF	22.636	22.75	22.594	22.594	1600.0
2020-04-28	AGQ	ETF	21.1	21.1	20.49	20.74	304800.0
2020-04-28	AGZ	ETF	120.64	120.98	120.4701	120.91	125683.0
2020-04-28	AGZD	ETF	23.265	23.395	22.42	23.195	60800.0
2020-04-28	AIA	ETF	60.3	60.3	59.47	59.49	254228.0
2020-04-28	AIEQ	ETF	26.16	26.16	25.38	25.4	16300.0
2020-04-28	AIQ	ETF	17.83	17.83	17.35	17.49	27675.0
2020-04-28	AIRR	ETF	22.05	22.27	21.95	22.088	10800.0
2020-04-28	AIVI	ETF	33.44	33.44	33.05	33.12	15200.0
2020-04-28	ALTY	ETF	9.84	9.96	9.78	9.85	4100.0
2020-04-28	AMJ	ETF	12.48	12.9	12.44	12.72	2015783.0
2020-04-28	AMLP	ETF	23.75	24.25	23.3	24.0	6161480.0
2020-04-28	AMOM	ETF	25.46	25.5	25.283	25.283	700.0
2020-04-28	AMUB	ETF	8.05	8.06	7.85	8.039	7652.0
2020-04-28	AMZA	ETF	15.8	16.68	15.8	16.42	72100.0
2020-04-28	ANGL	ETF	26.75	26.75	26.51	26.67	653900.0
2020-04-28	AOA	ETF	51.33	51.53	50.81	50.86	93000.0
2020-04-28	AOK	ETF	35.12	35.35	35.0	35.06	310728.0
2020-04-28	AOM	ETF	38.25	38.39	38.05	38.16	240950.0
2020-04-28	AOR	ETF	44.03	44.18	43.6199	43.7	158617.0
2020-04-28	ARGT	ETF	17.67	18.13	17.51	18.05	19700.0
2020-04-28	ARKF	ETF	24.15	24.16	23.414	23.483	80000.0

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

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