PREVIEW / etf_daily / 2020-11-30

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-30.parquet
  size:    81 KB
  rows:    2,153

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-11-30	SPY	ETF	362.83	363.12	359.17	362.06	83872700.0
2020-11-30	QQQ	ETF	299.3	299.97	294.78	299.62	27836232.0
2020-11-30	IWM	ETF	183.82	184.32	180.32	181.02	25481600.0
2020-11-30	DIA	ETF	297.52	297.8	294.75	296.62	4159300.0
2020-11-30	GLD	ETF	166.68	167.43	166.03	166.67	13210000.0
2020-11-30	TLT	ETF	160.03	160.53	159.76	160.02	13071600.0
2020-11-30	AAA	ETF	25.05	25.05	25.04	25.05	2706.0
2020-11-30	AAAU	ETF	17.68	17.77	17.62	17.69	505300.0
2020-11-30	AADR	ETF	57.73	57.95	57.62	57.72	2800.0
2020-11-30	AAXJ	ETF	85.8	85.93	84.87	84.96	1177300.0
2020-11-30	ABEQ	ETF	24.8	24.85	24.735	24.83	5000.0
2020-11-30	ACES	ETF	72.12	72.4	69.023	70.2	117500.0
2020-11-30	ACIO	ETF	27.395	27.395	27.25	27.39	14100.0
2020-11-30	ACSI	ETF	42.19	42.19	42.06	42.18	1857.0
2020-11-30	ACTV	ETF	29.0664	29.11	28.8666	28.8666	4654.0
2020-11-30	ACTX	ETF	2.95	3.08	2.65	2.9	3428.0
2020-11-30	ACVF	ETF	26.93	26.93	26.75	26.808	2200.0
2020-11-30	ACWF	ETF	32.24	32.305	32.09	32.09	3591.0
2020-11-30	ACWI	ETF	88.15	88.15	87.1	87.33	10556400.0
2020-11-30	ACWV	ETF	95.62	95.62	94.88	95.22	364900.0
2020-11-30	ACWX	ETF	51.49	51.52	50.68	50.73	4122367.0
2020-11-30	ADME	ETF	34.95	34.95	34.83	34.92	6900.0
2020-11-30	ADRE	ETF	54.05	54.05	53.01	53.34	22990.0
2020-11-30	AESR	ETF	11.51	11.583	11.51	11.583	500.0
2020-11-30	AFIF	ETF	9.78	9.82	9.78	9.82	19883.0
2020-11-30	AFK	ETF	19.84	19.9427	19.6019	19.6347	8244.0
2020-11-30	AFLG	ETF	21.55	21.555	21.55	21.555	700.0
2020-11-30	AFMC	ETF	20.173	20.173	20.173	20.173	100.0
2020-11-30	AFSM	ETF	20.392	20.392	20.392	20.392	100.0
2020-11-30	AFTY	ETF	21.88	21.95	21.78	21.784	2800.0
2020-11-30	AGG	ETF	118.32	118.45	118.25	118.42	8688500.0
2020-11-30	AGGY	ETF	53.82	53.94	53.82	53.93	72400.0
2020-11-30	AGNG	ETF	27.02	27.02	26.845	26.845	6400.0
2020-11-30	AGQ	ETF	36.62	38.11	36.31	37.92	1746600.0
2020-11-30	AGZ	ETF	120.99	121.0	120.88	120.9	167022.0
2020-11-30	AGZD	ETF	23.495	23.55	23.49	23.53	23000.0
2020-11-30	AIA	ETF	82.17	82.36	81.58	81.71	207619.0
2020-11-30	AIEQ	ETF	33.96	34.0	33.27	33.84	18200.0
2020-11-30	AIQ	ETF	26.02	26.02	25.595	25.96	55410.0
2020-11-30	AIRR	ETF	32.008	32.008	31.351	31.351	14500.0
2020-11-30	AIVI	ETF	39.46	39.49	38.91	38.91	5500.0
2020-11-30	ALTL	ETF	30.245	30.245	29.93	29.93	778.0
2020-11-30	ALTY	ETF	11.67	11.67	11.48	11.49	26200.0
2020-11-30	AMJ	ETF	13.98	14.18	13.49	13.51	1775519.0
2020-11-30	AMLP	ETF	25.94	26.29	24.92	24.99	4615100.0
2020-11-30	AMNA	ETF	25.35	25.36	25.17	25.1803	3650.0
2020-11-30	AMND	ETF	26.7054	26.7054	26.7054	26.7054	2.0
2020-11-30	AMOM	ETF	38.423	38.423	38.423	38.423	500.0
2020-11-30	AMTR	ETF	28.89	28.89	28.36	28.3608	23089.0
2020-11-30	AMUB	ETF	8.75	8.75	8.48	8.48	34102.0

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

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