PREVIEW / etf_daily / 2020-12-02

all etf daily files

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

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-02	SPY	ETF	364.82	366.96	364.2	366.79	45927000.0
2020-12-02	QQQ	ETF	302.22	304.195	300.35	303.85	23620003.0
2020-12-02	IWM	ETF	181.95	183.48	180.76	182.89	20142800.0
2020-12-02	DIA	ETF	297.1	299.34	296.35	299.18	2481700.0
2020-12-02	GLD	ETF	170.57	171.76	170.15	171.46	9199700.0
2020-12-02	TLT	ETF	156.88	156.93	155.48	156.25	12114300.0
2020-12-02	AAA	ETF	25.02	25.0317	25.02	25.03	2518.0
2020-12-02	AAAU	ETF	18.12	18.23	18.07	18.2	289300.0
2020-12-02	AADR	ETF	58.31	58.68	57.95	58.44	8700.0
2020-12-02	AAXJ	ETF	86.26	86.46	85.8	86.33	726800.0
2020-12-02	ABEQ	ETF	25.52	25.52	24.975	25.08	6400.0
2020-12-02	ACES	ETF	68.63	68.63	66.78	68.17	105900.0
2020-12-02	ACIO	ETF	27.71	27.71	27.47	27.47	66000.0
2020-12-02	ACSI	ETF	42.4	42.8076	42.4	42.8076	1312.0
2020-12-02	ACTV	ETF	29.31	29.59	29.3	29.3738	31818.0
2020-12-02	ACTX	ETF	2.65	3.0	2.65	3.0	715.0
2020-12-02	ACVF	ETF	27.14	27.179	27.14	27.179	300.0
2020-12-02	ACWF	ETF	32.55	32.65	32.55	32.5906	36290.0
2020-12-02	ACWI	ETF	88.23	88.75	88.1	88.75	2767100.0
2020-12-02	ACWV	ETF	95.84	96.1	95.69	95.88	400000.0
2020-12-02	ACWX	ETF	51.57	51.8699	51.48	51.79	1042624.0
2020-12-02	ADFI	ETF	9.96	9.96	9.96	9.96	100.0
2020-12-02	ADME	ETF	35.39	35.39	35.192	35.25	38000.0
2020-12-02	ADRE	ETF	54.06	54.26	53.656	54.26	11154.0
2020-12-02	AESR	ETF	11.73	11.743	11.73	11.743	6800.0
2020-12-02	AFIF	ETF	9.8	9.8	9.785	9.785	18244.0
2020-12-02	AFK	ETF	20.15	20.33	19.62	20.3083	9606.0
2020-12-02	AFLG	ETF	21.78	21.78	21.755	21.755	600.0
2020-12-02	AFMC	ETF	20.324	20.324	20.324	20.324	100.0
2020-12-02	AFSM	ETF	20.51	20.53	20.51	20.53	100.0
2020-12-02	AFTY	ETF	22.43	22.455	22.41	22.43	1300.0
2020-12-02	AGG	ETF	117.81	117.81	117.54	117.71	6121000.0
2020-12-02	AGGY	ETF	53.73	53.73	53.58	53.69	116500.0
2020-12-02	AGNG	ETF	26.88	26.97	26.88	26.948	6100.0
2020-12-02	AGQ	ETF	41.81	42.9	41.34	42.76	1040900.0
2020-12-02	AGZ	ETF	119.45	119.45	119.29	119.42	35922.0
2020-12-02	AGZD	ETF	23.565	23.625	23.54	23.6	24000.0
2020-12-02	AIA	ETF	83.07	83.2806	82.81	83.08	389155.0
2020-12-02	AIEQ	ETF	33.73	33.99	33.51	33.9	26200.0
2020-12-02	AIQ	ETF	26.01	26.2	25.88	26.2	65806.0
2020-12-02	AIRR	ETF	31.61	31.79	31.445	31.647	9200.0
2020-12-02	AIVI	ETF	39.44	39.74	39.44	39.71	13600.0
2020-12-02	ALTL	ETF	30.76	30.8623	30.72	30.8581	4558.0
2020-12-02	ALTY	ETF	11.67	11.76	11.64	11.74	20500.0
2020-12-02	AMJ	ETF	13.57	14.24	13.57	14.09	2053730.0
2020-12-02	AMLP	ETF	25.19	26.37	25.12	26.19	3895700.0
2020-12-02	AMNA	ETF	25.7873	25.7873	25.7873	25.7873	18.0
2020-12-02	AMND	ETF	27.5	27.5016	27.5	27.5016	1803.0
2020-12-02	AMOM	ETF	38.75	38.75	38.26	38.282	1300.0
2020-12-02	AMTR	ETF	29.0857	29.0857	29.0857	29.0857	2.0

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

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