PREVIEW / etf_daily / 2020-06-02

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-02.parquet
  size:    75 KB
  rows:    1,972

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-06-02	SPY	ETF	306.55	308.13	305.1	308.08	74267200.0
2020-06-02	QQQ	ETF	234.42	235.69	232.01	235.63	33383415.0
2020-06-02	IWM	ETF	141.07	141.85	139.56	141.39	24666200.0
2020-06-02	DIA	ETF	256.55	257.92	255.71	257.85	3045800.0
2020-06-02	GLD	ETF	163.89	164.08	161.86	162.6	10388900.0
2020-06-02	TLT	ETF	161.67	162.09	161.25	161.69	11517100.0
2020-06-02	AAAU	ETF	17.39	17.4	17.17	17.24	166100.0
2020-06-02	AADR	ETF	49.85	50.18	49.85	50.1	2500.0
2020-06-02	AAXJ	ETF	66.9	67.77	66.87	67.66	1072300.0
2020-06-02	ABEQ	ETF	22.549	22.65	22.51	22.616	21100.0
2020-06-02	ACES	ETF	37.11	37.2	36.65	36.93	35200.0
2020-06-02	ACIO	ETF	24.655	24.8	24.653	24.8	11100.0
2020-06-02	ACSI	ETF	32.9713	33.1766	32.9713	33.1766	492.0
2020-06-02	ACTX	ETF	4.251	5.015	4.251	4.6315	314.0
2020-06-02	ACWF	ETF	27.905	28.1085	27.8601	28.1085	10440.0
2020-06-02	ACWI	ETF	73.46	73.94	73.3	73.94	4202900.0
2020-06-02	ACWV	ETF	89.47	89.76	89.28	89.76	738400.0
2020-06-02	ACWX	ETF	43.15	43.46	43.09	43.41	1896585.0
2020-06-02	ADME	ETF	31.79	31.96	31.79	31.92	11900.0
2020-06-02	ADRE	ETF	37.73	38.445	37.73	38.445	5278.0
2020-06-02	AESR	ETF	9.71	9.774	9.71	9.774	8500.0
2020-06-02	AFIF	ETF	9.835	9.835	9.8101	9.82	4277.0
2020-06-02	AFK	ETF	15.75	16.07	15.71	15.89	10460.0
2020-06-02	AFSM	ETF	16.73	16.737	16.73	16.737	600.0
2020-06-02	AFTY	ETF	16.34	16.35	16.34	16.346	2000.0
2020-06-02	AGG	ETF	117.38	117.47	117.31	117.47	4286800.0
2020-06-02	AGGY	ETF	53.47	53.52	53.41	53.46	131500.0
2020-06-02	AGNG	ETF	24.32	24.48	24.196	24.452	1900.0
2020-06-02	AGQ	ETF	30.83	30.83	28.7	29.57	680700.0
2020-06-02	AGZ	ETF	120.97	120.9978	120.8319	120.94	37190.0
2020-06-02	AGZD	ETF	23.365	23.405	23.365	23.385	4000.0
2020-06-02	AIA	ETF	61.34	61.97	61.34	61.95	84286.0
2020-06-02	AIEQ	ETF	27.71	27.71	27.321	27.64	12300.0
2020-06-02	AIQ	ETF	19.72	19.77	19.535	19.75	8507.0
2020-06-02	AIRR	ETF	23.3	23.614	23.3	23.559	3000.0
2020-06-02	AIVI	ETF	35.8	35.94	35.78	35.94	7000.0
2020-06-02	ALTY	ETF	11.06	11.1	11.013	11.061	14600.0
2020-06-02	AMJ	ETF	14.4	14.74	14.4	14.71	3528697.0
2020-06-02	AMLP	ETF	26.82	27.42	26.82	27.37	3593500.0
2020-06-02	AMOM	ETF	28.565	28.592	28.565	28.592	300.0
2020-06-02	AMUB	ETF	8.86	9.2632	8.86	9.2632	8755.0
2020-06-02	AMZA	ETF	20.45	20.95	20.375	20.85	50300.0
2020-06-02	ANGL	ETF	28.22	28.45	28.15	28.37	1658500.0
2020-06-02	AOA	ETF	54.15	54.49	54.15	54.49	33600.0
2020-06-02	AOK	ETF	36.06	36.14	36.0276	36.13	204635.0
2020-06-02	AOM	ETF	39.51	39.66	39.45	39.66	239498.0
2020-06-02	AOR	ETF	45.86	46.0723	45.86	46.07	92118.0
2020-06-02	APRT	ETF	25.16	25.1955	25.16	25.1955	269.0
2020-06-02	APRW	ETF	25.1038	25.1038	25.1038	25.1038	21.0
2020-06-02	ARB	ETF	24.68	24.7	24.48	24.48	4132.0

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

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