PREVIEW / etf_daily / 2020-12-17

all etf daily files

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

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-17	SPY	ETF	371.94	372.46	371.05	372.24	64119500.0
2020-12-17	QQQ	ETF	310.63	311.24	309.39	311.0	23730524.0
2020-12-17	IWM	ETF	194.73	196.38	194.06	196.29	23834200.0
2020-12-17	DIA	ETF	303.22	303.71	302.85	303.49	3002900.0
2020-12-17	GLD	ETF	177.15	177.87	176.58	176.74	9475800.0
2020-12-17	TLT	ETF	158.13	158.46	156.43	156.8	9422700.0
2020-12-17	AAA	ETF	25.07	25.0899	25.07	25.07	1572.0
2020-12-17	AAAU	ETF	18.82	18.88	18.75	18.76	644800.0
2020-12-17	AADR	ETF	59.52	60.16	59.52	59.94	49000.0
2020-12-17	AAXJ	ETF	88.0	88.07	87.73	88.07	976100.0
2020-12-17	ABEQ	ETF	25.355	25.405	25.355	25.405	2600.0
2020-12-17	ACES	ETF	73.24	74.28	72.97	74.28	126500.0
2020-12-17	ACIO	ETF	27.74	27.83	27.55	27.61	26300.0
2020-12-17	ACSI	ETF	43.4525	43.4525	43.4525	43.4525	120.0
2020-12-17	ACTV	ETF	30.68	31.2721	30.68	31.2721	3224.0
2020-12-17	ACTX	ETF	2.53	2.75	2.53	2.75	695.0
2020-12-17	ACVF	ETF	27.77	27.77	27.531	27.61	1300.0
2020-12-17	ACWF	ETF	33.2064	33.27	33.1807	33.23	2028.0
2020-12-17	ACWI	ETF	90.13	90.2	89.96	90.19	3016300.0
2020-12-17	ACWV	ETF	96.27	96.66	96.27	96.57	164700.0
2020-12-17	ACWX	ETF	52.94	53.0	52.845	52.92	858092.0
2020-12-17	ADFI	ETF	9.95	9.95	9.95	9.95	100.0
2020-12-17	ADME	ETF	35.78	35.78	35.68	35.76	13500.0
2020-12-17	ADRE	ETF	56.16	56.33	55.95	56.2165	19715.0
2020-12-17	AESR	ETF	11.86	11.88	11.85	11.864	22800.0
2020-12-17	AFIF	ETF	9.79	9.79	9.7621	9.775	178872.0
2020-12-17	AFK	ETF	21.46	21.87	21.3	21.68	58544.0
2020-12-17	AFLG	ETF	22.271	22.271	22.271	22.271	100.0
2020-12-17	AFMC	ETF	21.373	21.373	21.373	21.373	100.0
2020-12-17	AFSM	ETF	22.07	22.07	22.07	22.07	100.0
2020-12-17	AFTY	ETF	22.4	22.4	22.4	22.4	100.0
2020-12-17	AGG	ETF	118.01	118.06	117.73	117.85	6610400.0
2020-12-17	AGGY	ETF	53.69	53.7	53.555	53.56	82800.0
2020-12-17	AGNG	ETF	27.686	27.89	27.66	27.807	6600.0
2020-12-17	AGQ	ETF	49.69	50.41	49.18	49.92	1892000.0
2020-12-17	AGZ	ETF	119.63	119.74	119.53	119.65	85349.0
2020-12-17	AGZD	ETF	23.575	23.59	23.535	23.57	6200.0
2020-12-17	AIA	ETF	84.54	84.54	84.23	84.36	220627.0
2020-12-17	AIEQ	ETF	35.96	36.07	35.77	36.07	32700.0
2020-12-17	AIQ	ETF	27.08	27.185	27.01	27.1	53887.0
2020-12-17	AIRR	ETF	33.79	33.79	33.34	33.51	15100.0
2020-12-17	AIVI	ETF	40.96	41.05	40.95	40.95	5200.0
2020-12-17	ALTL	ETF	31.9599	32.0201	31.9599	32.0201	2293.0
2020-12-17	ALTY	ETF	11.94	11.94	11.88	11.92	15200.0
2020-12-17	AMJ	ETF	15.03	15.03	14.58	14.67	1465626.0
2020-12-17	AMLP	ETF	27.54	27.58	27.02	27.22	2569800.0
2020-12-17	AMNA	ETF	26.6427	26.6427	26.6427	26.6427	3.0
2020-12-17	AMND	ETF	28.4	28.4702	28.4	28.4702	113.0
2020-12-17	AMOM	ETF	39.6	39.722	39.6	39.722	700.0
2020-12-17	AMTR	ETF	30.44	30.47	29.94	30.08	84156.0

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

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