PREVIEW / etf_daily / 2020-12-24

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-24.parquet
  size:    81 KB
  rows:    2,159

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-24	SPY	ETF	368.08	369.03	367.45	369.0	26457900.0
2020-12-24	QQQ	ETF	308.47	310.02	308.39	309.56	16784997.0
2020-12-24	IWM	ETF	199.93	199.94	198.06	199.01	8904900.0
2020-12-24	DIA	ETF	301.66	302.1	300.93	302.02	1955700.0
2020-12-24	GLD	ETF	175.55	176.37	175.51	176.35	3695400.0
2020-12-24	TLT	ETF	156.9	157.43	156.85	157.29	3117100.0
2020-12-24	AAA	ETF	25.09	25.09	25.09	25.09	1168.0
2020-12-24	AAAU	ETF	18.65	18.72	18.63	18.71	168100.0
2020-12-24	AADR	ETF	60.43	60.43	60.17	60.17	1200.0
2020-12-24	AAXJ	ETF	86.77	87.09	86.23	86.76	633600.0
2020-12-24	ABEQ	ETF	25.36	25.55	25.36	25.55	2600.0
2020-12-24	ACES	ETF	80.65	81.019	79.22	80.13	79500.0
2020-12-24	ACIO	ETF	27.56	27.56	27.45	27.49	3900.0
2020-12-24	ACSI	ETF	42.9752	42.9752	42.9752	42.9752	171.0
2020-12-24	ACTV	ETF	31.29	31.3762	31.285	31.3762	1451.0
2020-12-24	ACTX	ETF	2.5	2.5	2.5	2.5	884.0
2020-12-24	ACVF	ETF	27.471	27.49	27.465	27.478	800.0
2020-12-24	ACWF	ETF	33.25	33.25	33.14	33.1963	7298.0
2020-12-24	ACWI	ETF	89.56	89.63	89.31	89.59	584200.0
2020-12-24	ACWV	ETF	95.33	95.7	95.33	95.66	112000.0
2020-12-24	ACWX	ETF	52.26	52.37	52.1713	52.29	511573.0
2020-12-24	ADME	ETF	35.94	35.94	35.61	35.68	12400.0
2020-12-24	ADRE	ETF	54.29	54.5569	53.8755	54.4299	22170.0
2020-12-24	AESR	ETF	11.78	11.797	11.78	11.797	700.0
2020-12-24	AFIF	ETF	9.8	9.8	9.77	9.785	12363.0
2020-12-24	AFK	ETF	20.59	20.73	20.57	20.59	6724.0
2020-12-24	AFLG	ETF	22.15	22.15	22.15	22.15	100.0
2020-12-24	AFTY	ETF	21.944	21.944	21.944	21.944	200.0
2020-12-24	AGG	ETF	117.94	118.05	117.93	117.99	2214500.0
2020-12-24	AGGY	ETF	53.45	53.56	53.45	53.55	35100.0
2020-12-24	AGNG	ETF	27.84	27.84	27.83	27.83	900.0
2020-12-24	AGQ	ETF	47.8	49.06	47.67	48.87	452800.0
2020-12-24	AGZ	ETF	119.56	119.615	119.56	119.59	13045.0
2020-12-24	AGZD	ETF	23.545	23.55	23.505	23.55	4800.0
2020-12-24	AIA	ETF	84.36	84.45	83.75	84.0	78816.0
2020-12-24	AIEQ	ETF	36.6	36.6	36.23	36.4	26700.0
2020-12-24	AIQ	ETF	27.15	27.196	26.95	27.05	38847.0
2020-12-24	AIRR	ETF	33.88	33.96	33.76	33.95	4100.0
2020-12-24	AIVI	ETF	40.24	40.24	40.11	40.2	2600.0
2020-12-24	ALTL	ETF	31.44	31.54	31.28	31.54	8092.0
2020-12-24	ALTY	ETF	11.65	11.68	11.62	11.68	13000.0
2020-12-24	AMJ	ETF	14.24	14.24	13.96	14.11	459356.0
2020-12-24	AMLP	ETF	26.41	26.41	25.83	26.17	1211900.0
2020-12-24	AMNA	ETF	25.5887	25.5887	25.5887	25.5887	0.0
2020-12-24	AMND	ETF	27.2963	27.2963	27.2963	27.2963	19.0
2020-12-24	AMOM	ETF	39.7	39.7	39.7	39.7	200.0
2020-12-24	AMTR	ETF	28.83	28.854	28.83	28.854	1000.0
2020-12-24	AMUB	ETF	8.81	8.88	8.81	8.88	10162.0
2020-12-24	AMZA	ETF	19.65	19.65	19.21	19.48	113900.0
2020-12-24	ANEW	ETF	42.082	42.1	41.855	41.957	1400.0

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

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