PREVIEW / etf_daily / 2020-12-09

all etf daily files

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

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-09	SPY	ETF	370.88	371.05	365.95	366.85	74098300.0
2020-12-09	QQQ	ETF	308.07	308.36	300.21	301.31	48839306.0
2020-12-09	IWM	ETF	192.02	192.81	187.9	189.41	29507600.0
2020-12-09	DIA	ETF	303.22	303.6	299.97	300.88	3074500.0
2020-12-09	GLD	ETF	173.92	174.04	171.24	172.5	10743200.0
2020-12-09	TLT	ETF	156.55	157.32	156.01	156.82	7750100.0
2020-12-09	AAA	ETF	25.06	25.06	25.06	25.06	113.0
2020-12-09	AAAU	ETF	18.47	18.48	18.18	18.31	538200.0
2020-12-09	AADR	ETF	58.12	58.13	57.54	57.69	3400.0
2020-12-09	AAXJ	ETF	88.38	88.38	86.88	87.26	1507600.0
2020-12-09	ABEQ	ETF	25.33	25.4	25.28	25.38	3900.0
2020-12-09	ACES	ETF	71.82	71.91	68.01	68.77	141700.0
2020-12-09	ACIO	ETF	27.491	27.504	27.35	27.37	20800.0
2020-12-09	ACSI	ETF	42.729	42.729	42.729	42.729	152.0
2020-12-09	ACTV	ETF	30.98	30.99	30.59	30.7344	3200.0
2020-12-09	ACVF	ETF	27.5	27.5	27.274	27.274	1500.0
2020-12-09	ACWF	ETF	33.27	33.27	32.8	32.93	15787.0
2020-12-09	ACWI	ETF	90.1	90.1	88.77	89.15	1321200.0
2020-12-09	ACWV	ETF	96.69	96.69	95.77	96.06	240600.0
2020-12-09	ACWX	ETF	52.6769	52.71	52.02	52.31	764659.0
2020-12-09	ADME	ETF	35.7	35.7	34.99	35.14	16500.0
2020-12-09	ADRE	ETF	55.83	55.83	54.535	54.69	12108.0
2020-12-09	AESR	ETF	11.765	11.765	11.741	11.741	400.0
2020-12-09	AFIF	ETF	9.7959	9.8	9.7931	9.8	14307.0
2020-12-09	AFK	ETF	20.61	20.768	20.29	20.36	154688.0
2020-12-09	AFMC	ETF	20.8	20.8	20.79	20.79	800.0
2020-12-09	AFSM	ETF	21.18	21.18	21.18	21.18	100.0
2020-12-09	AFTY	ETF	22.0	22.062	21.86	21.882	2200.0
2020-12-09	AGG	ETF	117.73	117.78	117.52	117.61	6975700.0
2020-12-09	AGGY	ETF	53.36	53.415	53.33	53.37	137900.0
2020-12-09	AGNG	ETF	27.23	27.28	26.97	27.07	6300.0
2020-12-09	AGQ	ETF	43.42	43.6	41.05	42.13	2063800.0
2020-12-09	AGZ	ETF	119.5	119.5	119.3709	119.42	28720.0
2020-12-09	AGZD	ETF	23.61	23.625	23.525	23.585	191800.0
2020-12-09	AIA	ETF	85.4	85.48	84.11	84.49	153808.0
2020-12-09	AIEQ	ETF	35.47	35.5	34.45	34.672	24500.0
2020-12-09	AIQ	ETF	26.73	26.79	26.18	26.28	46261.0
2020-12-09	AIRR	ETF	33.62	33.64	33.428	33.567	3900.0
2020-12-09	AIVI	ETF	40.3	40.3	40.09	40.22	3900.0
2020-12-09	ALTL	ETF	32.7102	32.7102	32.08	32.2755	9797.0
2020-12-09	ALTY	ETF	11.82	11.825	11.702	11.76	8200.0
2020-12-09	AMJ	ETF	15.18	15.43	14.56	14.79	1557599.0
2020-12-09	AMLP	ETF	28.19	28.67	27.0	27.42	4772900.0
2020-12-09	AMNA	ETF	26.8132	26.8132	26.8132	26.8132	0.0
2020-12-09	AMND	ETF	28.6	28.6349	28.6	28.6349	2000.0
2020-12-09	AMOM	ETF	38.61	38.61	38.483	38.483	400.0
2020-12-09	AMTR	ETF	30.43	30.43	30.05	30.2603	2300.0
2020-12-09	AMUB	ETF	9.68	9.68	9.21	9.3018	11892.0
2020-12-09	AMZA	ETF	21.26	21.593	20.15	20.63	135000.0
2020-12-09	ANEW	ETF	41.12	41.12	40.46	40.562	16300.0

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

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