PREVIEW / etf_daily / 2020-12-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-08.parquet
  size:    82 KB
  rows:    2,168

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-08	SPY	ETF	367.72	370.78	367.67	370.17	42458900.0
2020-12-08	QQQ	ETF	306.76	308.6	304.95	308.29	18341464.0
2020-12-08	IWM	ETF	187.12	190.98	187.08	190.8	20165600.0
2020-12-08	DIA	ETF	300.01	302.87	299.98	302.2	2205400.0
2020-12-08	GLD	ETF	175.51	175.93	174.72	175.5	6348400.0
2020-12-08	TLT	ETF	157.57	158.07	157.2	157.34	7397200.0
2020-12-08	AAA	ETF	25.05	25.0582	25.05	25.05	3102.0
2020-12-08	AAAU	ETF	18.62	18.68	18.55	18.63	234800.0
2020-12-08	AADR	ETF	58.44	58.93	58.44	58.79	2500.0
2020-12-08	AAXJ	ETF	87.74	87.95	87.45	87.94	1016400.0
2020-12-08	ABEQ	ETF	25.329	25.33	25.276	25.28	4800.0
2020-12-08	ACES	ETF	68.66	71.53	68.61	71.41	72800.0
2020-12-08	ACIO	ETF	27.75	27.75	27.49	27.6	11800.0
2020-12-08	ACSI	ETF	43.1728	43.1728	43.1728	43.1728	107.0
2020-12-08	ACTV	ETF	30.56	30.6985	30.56	30.6985	1952.0
2020-12-08	ACTX	ETF	2.9	2.9	2.9	2.9	373.0
2020-12-08	ACVF	ETF	27.3	27.46	27.3	27.46	900.0
2020-12-08	ACWF	ETF	32.99	33.1282	32.99	33.1282	7668.0
2020-12-08	ACWI	ETF	89.19	89.86	89.19	89.78	898100.0
2020-12-08	ACWV	ETF	95.81	96.48	95.81	96.42	163400.0
2020-12-08	ACWX	ETF	52.21	52.43	52.17	52.41	644934.0
2020-12-08	ADFI	ETF	9.985	9.985	9.985	9.985	100.0
2020-12-08	ADME	ETF	35.56	35.56	35.29	35.44	7100.0
2020-12-08	ADRE	ETF	55.7	55.78	55.27	55.3959	24616.0
2020-12-08	AESR	ETF	11.79	11.86	11.77	11.845	4500.0
2020-12-08	AFIF	ETF	9.82	9.82	9.79	9.79	6093.0
2020-12-08	AFK	ETF	20.57	20.725	20.57	20.605	14073.0
2020-12-08	AFLG	ETF	21.9	22.0	21.9	22.0	600.0
2020-12-08	AFTY	ETF	22.225	22.25	22.214	22.226	1700.0
2020-12-08	AGG	ETF	117.88	117.96	117.75	117.78	6807000.0
2020-12-08	AGGY	ETF	53.5	53.54	53.44	53.47	117100.0
2020-12-08	AGNG	ETF	27.14	27.23	27.0	27.23	58600.0
2020-12-08	AGQ	ETF	44.94	45.8	44.32	44.76	906500.0
2020-12-08	AGZ	ETF	119.61	119.62	119.52	119.56	61839.0
2020-12-08	AGZD	ETF	23.57	23.62	23.55	23.59	8800.0
2020-12-08	AIA	ETF	84.86	84.94	84.49	84.94	235699.0
2020-12-08	AIEQ	ETF	34.99	35.38	34.9	35.2	14900.0
2020-12-08	AIQ	ETF	26.72	26.78	26.57	26.73	59419.0
2020-12-08	AIRR	ETF	32.66	33.23	32.66	33.211	6900.0
2020-12-08	AIVI	ETF	39.95	40.18	39.95	40.14	3700.0
2020-12-08	ALTL	ETF	32.33	32.3436	32.2406	32.3436	6186.0
2020-12-08	ALTY	ETF	11.7	11.782	11.7	11.765	14600.0
2020-12-08	AMJ	ETF	14.92	15.3	14.8602	14.98	2135685.0
2020-12-08	AMLP	ETF	27.66	28.42	27.64	27.91	2869200.0
2020-12-08	AMNA	ETF	26.9796	26.9796	26.9796	26.9796	0.0
2020-12-08	AMND	ETF	28.8666	28.8666	28.8666	28.8666	0.0
2020-12-08	AMOM	ETF	38.991	38.991	38.991	38.991	200.0
2020-12-08	AMTR	ETF	30.4	30.458	30.4	30.458	10652.0
2020-12-08	AMUB	ETF	9.465	9.6	9.465	9.4682	8123.0
2020-12-08	AMZA	ETF	20.8	21.34	20.7	21.0	97100.0

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

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