PREVIEW / etf_daily / 2020-12-22

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-22.parquet
  size:    83 KB
  rows:    2,190

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-12-22	SPY	ETF	368.21	368.33	366.03	367.24	47949000.0
2020-12-22	QQQ	ETF	309.85	310.7105	306.845	309.76	26378343.0
2020-12-22	IWM	ETF	195.99	197.72	195.39	197.46	21919700.0
2020-12-22	DIA	ETF	301.84	301.88	299.86	300.07	2698200.0
2020-12-22	GLD	ETF	176.2	176.34	174.34	174.49	9442400.0
2020-12-22	TLT	ETF	157.56	157.83	157.08	157.76	7370800.0
2020-12-22	AAA	ETF	25.08	25.08	25.08	25.08	1377.0
2020-12-22	AAAU	ETF	18.7	18.71	18.51	18.53	433200.0
2020-12-22	AADR	ETF	60.24	60.46	60.08	60.26	4200.0
2020-12-22	AAXJ	ETF	86.64	86.7	86.02	86.24	1103100.0
2020-12-22	ABEQ	ETF	24.97	25.21	24.97	25.169	3200.0
2020-12-22	ACES	ETF	77.6	79.64	77.26	79.55	223600.0
2020-12-22	ACIO	ETF	27.74	27.74	27.4	27.45	17800.0
2020-12-22	ACSI	ETF	43.1799	43.18	43.1501	43.1501	356.0
2020-12-22	ACTV	ETF	31.06	31.16	30.8	31.09	6624.0
2020-12-22	ACTX	ETF	2.89	2.89	2.89	2.89	203.0
2020-12-22	ACVF	ETF	27.57	27.57	27.35	27.392	4100.0
2020-12-22	ACWF	ETF	32.93	33.0	32.93	32.95	1402.0
2020-12-22	ACWI	ETF	89.2	89.25	88.75	89.06	2627300.0
2020-12-22	ACWV	ETF	95.31	95.33	94.99	95.06	282000.0
2020-12-22	ACWX	ETF	51.91	51.91	51.685	51.83	1081429.0
2020-12-22	ADFI	ETF	9.95	9.95	9.95	9.95	100.0
2020-12-22	ADME	ETF	35.65	35.73	35.535	35.633	14800.0
2020-12-22	ADRE	ETF	55.72	55.72	54.9	55.29	17610.0
2020-12-22	AESR	ETF	11.763	11.763	11.763	11.763	100.0
2020-12-22	AFIF	ETF	9.7899	9.8	9.7748	9.8	10312.0
2020-12-22	AFK	ETF	20.44	20.48	20.001	20.07	29594.0
2020-12-22	AFLG	ETF	22.22	22.22	22.182	22.182	600.0
2020-12-22	AFTY	ETF	21.805	21.845	21.805	21.82	1000.0
2020-12-22	AGG	ETF	117.88	117.98	117.83	117.96	4516500.0
2020-12-22	AGGY	ETF	53.54	53.56	53.462	53.56	80600.0
2020-12-22	AGNG	ETF	27.85	27.87	27.62	27.81	41000.0
2020-12-22	AGQ	ETF	49.38	49.79	46.33	46.75	2285000.0
2020-12-22	AGZ	ETF	119.61	119.71	119.59	119.6	62959.0
2020-12-22	AGZD	ETF	23.59	23.595	23.49	23.535	28400.0
2020-12-22	AIA	ETF	83.11	83.11	82.68	82.76	121267.0
2020-12-22	AIEQ	ETF	36.25	36.43	36.0	36.43	13500.0
2020-12-22	AIQ	ETF	27.05	27.2	26.95	27.18	47403.0
2020-12-22	AIRR	ETF	33.456	33.53	33.212	33.468	11800.0
2020-12-22	AIVI	ETF	39.79	39.85	39.7	39.84	5800.0
2020-12-22	ALTL	ETF	31.0899	31.13	30.91	30.94	12709.0
2020-12-22	ALTY	ETF	11.715	11.72	11.66	11.685	7600.0
2020-12-22	AMJ	ETF	14.09	14.395	14.02	14.13	1106984.0
2020-12-22	AMLP	ETF	26.24	26.64	25.92	26.26	3180500.0
2020-12-22	AMNA	ETF	25.65	25.65	25.533	25.533	201.0
2020-12-22	AMND	ETF	27.2993	27.2993	27.2993	27.2993	0.0
2020-12-22	AMOM	ETF	39.476	39.701	39.476	39.701	900.0
2020-12-22	AMTR	ETF	28.93	28.93	28.78	28.79	10360.0
2020-12-22	AMUB	ETF	8.14	9.04	8.14	8.92	73813.0
2020-12-22	AMZA	ETF	19.63	19.94	19.42	19.57	69600.0

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

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