PREVIEW / etf_daily / 2020-09-30

all etf daily files

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

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-30	SPY	ETF	333.09	338.29	332.88	334.89	104081100.0
2020-09-30	QQQ	ETF	276.09	281.09	275.8717	277.84	49380802.0
2020-09-30	IWM	ETF	149.9	151.97	148.49	149.79	29073700.0
2020-09-30	DIA	ETF	275.0	280.17	275.0	277.5	4028500.0
2020-09-30	GLD	ETF	177.71	178.61	176.66	177.12	8371800.0
2020-09-30	TLT	ETF	164.0	164.0	162.55	163.26	12971000.0
2020-09-30	AAA	ETF	24.96	24.97	24.96	24.96	5552.0
2020-09-30	AAAU	ETF	18.86	18.95	18.75	18.8	537100.0
2020-09-30	AADR	ETF	55.46	55.68	55.15	55.27	5800.0
2020-09-30	AAXJ	ETF	76.5	77.39	76.49	77.17	848100.0
2020-09-30	ABEQ	ETF	23.42	23.45	23.31	23.41	6300.0
2020-09-30	ACES	ETF	54.76	55.89	54.54	55.43	73900.0
2020-09-30	ACIO	ETF	26.63	26.77	26.52	26.65	43100.0
2020-09-30	ACSI	ETF	37.4786	37.4786	37.4786	37.4786	100.0
2020-09-30	ACTX	ETF	1.36	2.3836	1.36	1.77	104.0
2020-09-30	ACWF	ETF	29.59	29.79	29.58	29.6966	64292.0
2020-09-30	ACWI	ETF	79.63	80.52	79.53	79.92	11550500.0
2020-09-30	ACWV	ETF	91.71	92.36	91.5	91.91	434700.0
2020-09-30	ACWX	ETF	45.94	46.28	45.9001	45.99	1528602.0
2020-09-30	ADFI	ETF	9.97	9.97	9.966	9.966	70600.0
2020-09-30	ADME	ETF	33.75	33.87	33.5	33.66	15600.0
2020-09-30	ADRE	ETF	46.32	46.99	46.32	46.725	26410.0
2020-09-30	AESR	ETF	10.92	10.968	10.91	10.94	3700.0
2020-09-30	AFIF	ETF	9.82	9.82	9.79	9.805	16291.0
2020-09-30	AFK	ETF	17.58	17.635	17.39	17.4526	5076.0
2020-09-30	AFLG	ETF	20.0	20.38	20.0	20.252	177600.0
2020-09-30	AFSM	ETF	18.006	18.006	18.006	18.006	100.0
2020-09-30	AFTY	ETF	19.21	19.351	19.21	19.351	3700.0
2020-09-30	AGG	ETF	118.26	118.26	117.95	118.06	6090800.0
2020-09-30	AGGY	ETF	53.86	53.87	53.72	53.82	235000.0
2020-09-30	AGNG	ETF	25.715	25.81	25.663	25.7	1100.0
2020-09-30	AGQ	ETF	44.32	44.82	41.33	41.77	2726400.0
2020-09-30	AGZ	ETF	121.26	121.26	121.05	121.08	47305.0
2020-09-30	AGZD	ETF	23.375	23.4	23.34	23.395	24000.0
2020-09-30	AIA	ETF	71.2	71.97	71.19	71.82	113439.0
2020-09-30	AIEQ	ETF	30.51	30.97	30.501	30.746	9100.0
2020-09-30	AIQ	ETF	23.41	23.6382	23.35	23.5044	19880.0
2020-09-30	AIRR	ETF	25.89	26.133	25.53	25.708	7600.0
2020-09-30	AIVI	ETF	36.04	36.11	35.98	35.98	4900.0
2020-09-30	ALTL	ETF	25.0	25.145	25.0	25.0456	12135.0
2020-09-30	ALTY	ETF	10.62	10.62	10.53	10.57	20800.0
2020-09-30	AMJ	ETF	11.02	11.21	10.7	10.78	1025397.0
2020-09-30	AMLP	ETF	20.42	20.77	19.8	19.98	2863900.0
2020-09-30	AMNA	ETF	21.709	21.709	21.709	21.709	0.0
2020-09-30	AMND	ETF	22.7556	22.7556	22.7556	22.7556	0.0
2020-09-30	AMOM	ETF	35.592	35.687	35.592	35.687	500.0
2020-09-30	AMUB	ETF	6.89	6.94	6.75	6.79	14018.0
2020-09-30	AMZA	ETF	13.86	14.18	13.35	13.52	106800.0
2020-09-30	ANGL	ETF	29.6	29.77	29.6	29.74	640600.0
2020-09-30	AOA	ETF	57.74	58.3	57.69	58.0	32700.0

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

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