PREVIEW / etf_daily / 2020-12-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-18.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-18	SPY	ETF	370.97	371.15	367.02	369.18	136542300.0
2020-12-18	QQQ	ETF	311.66	311.98	307.61	310.06	41173392.0
2020-12-18	IWM	ETF	196.61	197.83	194.8	195.34	37033400.0
2020-12-18	DIA	ETF	303.07	303.14	300.23	301.9	4442100.0
2020-12-18	GLD	ETF	176.65	176.98	176.1	176.44	6789900.0
2020-12-18	TLT	ETF	157.12	157.38	156.18	156.33	6505000.0
2020-12-18	AAA	ETF	25.07	25.08	25.07	25.08	4044.0
2020-12-18	AAAU	ETF	18.76	18.78	18.7	18.72	363700.0
2020-12-18	AADR	ETF	60.48	60.88	60.48	60.78	5800.0
2020-12-18	AAXJ	ETF	87.89	87.94	87.58	87.85	1062400.0
2020-12-18	ABEQ	ETF	25.43	25.46	25.326	25.46	29600.0
2020-12-18	ACES	ETF	74.92	76.52	74.56	75.2	142600.0
2020-12-18	ACIO	ETF	27.5	27.61	27.46	27.61	62400.0
2020-12-18	ACSI	ETF	43.208	43.208	43.208	43.208	235.0
2020-12-18	ACTV	ETF	31.23	31.34	30.95	31.0901	8483.0
2020-12-18	ACVF	ETF	27.6	27.6	27.478	27.516	900.0
2020-12-18	ACWF	ETF	33.32	33.38	33.19	33.2378	28843.0
2020-12-18	ACWI	ETF	90.21	90.21	89.44	89.78	3019900.0
2020-12-18	ACWV	ETF	96.82	96.82	96.22	96.52	146800.0
2020-12-18	ACWX	ETF	52.86	52.86	52.57	52.65	877623.0
2020-12-18	ADFI	ETF	9.921	9.945	9.921	9.945	100.0
2020-12-18	ADME	ETF	35.61	35.77	35.53	35.77	35100.0
2020-12-18	ADRE	ETF	56.28	56.28	56.05	56.1293	33042.0
2020-12-18	AESR	ETF	11.84	11.845	11.83	11.845	5400.0
2020-12-18	AFIF	ETF	9.78	9.79	9.75	9.765	27279.0
2020-12-18	AFK	ETF	21.68	21.89	21.68	21.76	50335.0
2020-12-18	AFLG	ETF	22.24	22.25	22.24	22.25	700.0
2020-12-18	AFMC	ETF	21.346	21.346	21.346	21.346	100.0
2020-12-18	AFSM	ETF	22.119	22.119	22.119	22.119	100.0
2020-12-18	AFTY	ETF	22.31	22.4	22.21	22.251	2800.0
2020-12-18	AGG	ETF	117.97	117.97	117.76	117.79	3874700.0
2020-12-18	AGGY	ETF	53.57	53.64	53.551	53.59	91200.0
2020-12-18	AGNG	ETF	28.0	28.0	27.765	27.95	57500.0
2020-12-18	AGQ	ETF	49.45	49.84	48.85	49.14	1061700.0
2020-12-18	AGZ	ETF	119.6	119.63	119.56	119.58	45396.0
2020-12-18	AGZD	ETF	23.585	23.595	23.54	23.57	11400.0
2020-12-18	AIA	ETF	84.01	84.15	83.77	84.04	427311.0
2020-12-18	AIEQ	ETF	36.32	36.32	35.883	36.028	13300.0
2020-12-18	AIQ	ETF	27.212	27.212	27.04	27.1576	31803.0
2020-12-18	AIRR	ETF	33.8	33.85	33.36	33.406	16300.0
2020-12-18	AIVI	ETF	41.01	41.01	40.79	40.82	80300.0
2020-12-18	ALTL	ETF	31.91	31.975	31.43	31.6734	21517.0
2020-12-18	ALTY	ETF	11.97	11.97	11.845	11.845	15700.0
2020-12-18	AMJ	ETF	14.75	14.75	14.47	14.57	1386576.0
2020-12-18	AMLP	ETF	27.24	27.31	26.78	27.07	2619700.0
2020-12-18	AMNA	ETF	26.46	26.46	26.3194	26.3194	400.0
2020-12-18	AMND	ETF	28.03	28.1425	28.03	28.1425	200.0
2020-12-18	AMOM	ETF	39.57	39.813	39.57	39.813	1100.0
2020-12-18	AMTR	ETF	29.93	30.14	29.5	29.65	511815.0
2020-12-18	AMUB	ETF	9.215	9.24	9.14	9.1715	127373.0

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

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