PREVIEW / etf_daily / 2020-09-17

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-17.parquet
  size:    79 KB
  rows:    2,079

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-09-17	SPY	ETF	333.56	337.7	332.99	335.84	91523300.0
2020-09-17	QQQ	ETF	267.52	274.3955	266.68	270.32	81570844.0
2020-09-17	IWM	ETF	152.62	154.4	151.75	153.69	20002900.0
2020-09-17	DIA	ETF	277.69	281.15	277.09	279.57	3305300.0
2020-09-17	GLD	ETF	181.92	183.09	181.48	182.96	8836200.0
2020-09-17	TLT	ETF	164.9	164.96	163.8	164.08	7813900.0
2020-09-17	AAA	ETF	24.99	25.0	24.98	24.98	15275.0
2020-09-17	AAAU	ETF	19.29	19.42	19.26	19.42	683100.0
2020-09-17	AADR	ETF	55.4	56.24	55.4	56.24	1300.0
2020-09-17	AAXJ	ETF	77.46	78.08	77.46	77.95	1542000.0
2020-09-17	ABEQ	ETF	23.839	23.85	23.74	23.833	6000.0
2020-09-17	ACES	ETF	51.51	51.93	51.01	51.6	33400.0
2020-09-17	ACIO	ETF	26.51	26.525	26.365	26.49	12700.0
2020-09-17	ACSI	ETF	36.6	36.7888	36.6	36.7888	480.0
2020-09-17	ACTX	ETF	2.242	2.7081	2.1358	2.2538	664.0
2020-09-17	ACWF	ETF	29.8159	30.0689	29.8159	29.9417	2126.0
2020-09-17	ACWI	ETF	80.01	80.89	79.97	80.66	1413500.0
2020-09-17	ACWV	ETF	92.13	92.81	92.12	92.67	185100.0
2020-09-17	ACWX	ETF	46.87	47.22	46.79	47.2	1046988.0
2020-09-17	ADME	ETF	32.98	33.39	32.98	33.231	29700.0
2020-09-17	ADRE	ETF	46.81	47.0844	46.81	46.9451	2548.0
2020-09-17	AESR	ETF	10.82	10.82	10.75	10.778	5500.0
2020-09-17	AFIF	ETF	9.82	9.84	9.81	9.825	6355.0
2020-09-17	AFK	ETF	18.16	18.16	18.06	18.0701	2603.0
2020-09-17	AFLG	ETF	20.129	20.129	20.129	20.129	100.0
2020-09-17	AFTY	ETF	19.45	19.555	19.45	19.527	1900.0
2020-09-17	AGG	ETF	118.5	118.52	118.33	118.36	4882200.0
2020-09-17	AGGY	ETF	54.07	54.14	54.025	54.05	110300.0
2020-09-17	AGNG	ETF	25.83	25.84	25.797	25.84	1100.0
2020-09-17	AGQ	ETF	55.32	58.32	54.67	58.31	1101700.0
2020-09-17	AGZ	ETF	121.39	121.39	121.11	121.16	70511.0
2020-09-17	AGZD	ETF	23.545	23.545	23.5	23.525	20000.0
2020-09-17	AIA	ETF	72.51	73.15	72.505	72.8	191853.0
2020-09-17	AIEQ	ETF	29.62	29.97	29.555	29.81	8900.0
2020-09-17	AIQ	ETF	22.62	22.977	22.6	22.85	18270.0
2020-09-17	AIRR	ETF	26.06	26.615	26.006	26.466	11000.0
2020-09-17	AIVI	ETF	37.37	37.5	37.31	37.49	9400.0
2020-09-17	ALTL	ETF	24.95	25.055	24.865	24.9859	2103.0
2020-09-17	ALTY	ETF	10.877	10.89	10.81	10.837	15800.0
2020-09-17	AMJ	ETF	11.84	11.845	11.515	11.68	1359895.0
2020-09-17	AMLP	ETF	21.52	21.83	21.21	21.58	1984000.0
2020-09-17	AMNA	ETF	23.34	23.41	23.24	23.3933	1500.0
2020-09-17	AMND	ETF	24.3915	24.3915	24.3915	24.3915	0.0
2020-09-17	AMOM	ETF	34.14	34.14	34.14	34.14	500.0
2020-09-17	AMUB	ETF	7.36	7.36	7.31	7.35	4483.0
2020-09-17	AMZA	ETF	15.15	15.4	14.8	15.15	68000.0
2020-09-17	ANGL	ETF	30.01	30.16	29.91	30.11	1046200.0
2020-09-17	AOA	ETF	58.22	58.75	58.2	58.59	33000.0
2020-09-17	AOK	ETF	37.42	37.5	37.35	37.44	91697.0
2020-09-17	AOM	ETF	41.3	41.43	41.18	41.38	238984.0

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

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