PREVIEW / etf_daily / 2020-12-15

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-15.parquet
  size:    83 KB
  rows:    2,180

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-15	SPY	ETF	367.4	369.59	365.92	369.59	63865300.0
2020-12-15	QQQ	ETF	306.37	307.29	304.11	307.29	25790455.0
2020-12-15	IWM	ETF	191.76	194.9	190.73	194.68	26807000.0
2020-12-15	DIA	ETF	300.95	302.94	299.48	302.62	4211500.0
2020-12-15	GLD	ETF	173.43	173.98	173.06	173.94	6840500.0
2020-12-15	TLT	ETF	157.78	158.39	157.31	157.8	6847500.0
2020-12-15	AAA	ETF	25.06	25.0601	25.06	25.06	2043.0
2020-12-15	AAAU	ETF	18.4	18.47	18.38	18.46	473000.0
2020-12-15	AADR	ETF	58.71	58.98	58.65	58.98	9700.0
2020-12-15	AAXJ	ETF	86.82	87.24	86.51	87.23	511800.0
2020-12-15	ABEQ	ETF	25.06	25.2	25.06	25.163	1800.0
2020-12-15	ACES	ETF	70.82	73.44	70.82	73.28	186600.0
2020-12-15	ACIO	ETF	27.24	27.56	27.19	27.49	38300.0
2020-12-15	ACSI	ETF	43.0329	43.0329	43.0329	43.0329	179.0
2020-12-15	ACTV	ETF	30.85	31.1	30.815	31.0963	3292.0
2020-12-15	ACTX	ETF	2.7	2.7	2.7	2.7	873.0
2020-12-15	ACVF	ETF	27.15	27.4	27.15	27.352	1100.0
2020-12-15	ACWF	ETF	32.775	32.925	32.775	32.925	2587.0
2020-12-15	ACWI	ETF	88.83	89.33	88.58	89.33	1538100.0
2020-12-15	ACWV	ETF	95.43	95.86	95.31	95.77	215700.0
2020-12-15	ACWX	ETF	52.03	52.349	51.93	52.34	888760.0
2020-12-15	ADFI	ETF	9.954	9.954	9.954	9.954	100.0
2020-12-15	ADME	ETF	35.34	35.38	35.15	35.37	10900.0
2020-12-15	ADRE	ETF	55.0	55.0509	54.8222	55.0509	12036.0
2020-12-15	AESR	ETF	11.72	11.76	11.67	11.746	1700.0
2020-12-15	AFIF	ETF	9.79	9.79	9.76	9.777	26719.0
2020-12-15	AFK	ETF	20.77	20.8693	20.6901	20.84	10741.0
2020-12-15	AFLG	ETF	21.994	22.076	21.994	22.076	500.0
2020-12-15	AFMC	ETF	21.214	21.214	21.214	21.214	100.0
2020-12-15	AFSM	ETF	21.767	21.767	21.767	21.767	100.0
2020-12-15	AFTY	ETF	22.035	22.106	22.035	22.106	300.0
2020-12-15	AGG	ETF	117.95	118.03	117.9	118.03	4217800.0
2020-12-15	AGGY	ETF	53.58	53.64	53.56	53.64	112300.0
2020-12-15	AGNG	ETF	27.229	27.42	27.191	27.361	4600.0
2020-12-15	AGQ	ETF	43.94	44.57	43.7	44.4	913400.0
2020-12-15	AGZ	ETF	119.72	119.72	119.6	119.71	29243.0
2020-12-15	AGZD	ETF	23.545	23.545	23.52	23.525	22200.0
2020-12-15	AIA	ETF	83.69	84.085	83.35	84.02	139509.0
2020-12-15	AIEQ	ETF	35.45	35.5	35.209	35.5	14400.0
2020-12-15	AIQ	ETF	26.63	26.69	26.48	26.6703	35844.0
2020-12-15	AIRR	ETF	33.41	33.8	33.235	33.765	4900.0
2020-12-15	AIVI	ETF	40.34	40.46	40.27	40.46	2700.0
2020-12-15	ALTL	ETF	31.79	32.1095	31.45	32.091	1708.0
2020-12-15	ALTY	ETF	11.79	11.875	11.79	11.87	5900.0
2020-12-15	AMJ	ETF	14.84	15.13	14.55	14.96	1328506.0
2020-12-15	AMLP	ETF	27.42	28.06	26.95	27.84	5659300.0
2020-12-15	AMNA	ETF	27.2396	27.2396	27.2396	27.2396	0.0
2020-12-15	AMND	ETF	29.09	29.12	29.08	29.1103	934.0
2020-12-15	AMOM	ETF	39.07	39.074	39.02	39.074	3400.0
2020-12-15	AMTR	ETF	30.78	30.81	30.69	30.76	14720.0

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

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