PREVIEW / etf_daily / 2020-11-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-27.parquet
  size:    78 KB
  rows:    2,072

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-11-27	SPY	ETF	363.84	364.18	362.58	363.67	28514100.0
2020-11-27	QQQ	ETF	298.29	300.17	297.9	299.01	17163115.0
2020-11-27	IWM	ETF	183.72	184.49	183.22	184.37	10384400.0
2020-11-27	DIA	ETF	299.44	300.2	298.17	299.24	1518000.0
2020-11-27	GLD	ETF	166.9	167.83	166.78	167.79	10569100.0
2020-11-27	TLT	ETF	159.61	160.27	159.58	160.22	4708200.0
2020-11-27	AAA	ETF	25.05	25.05	25.05	25.05	303.0
2020-11-27	AAAU	ETF	17.73	17.81	17.71	17.8	478100.0
2020-11-27	AADR	ETF	57.5	58.03	57.5	57.89	1400.0
2020-11-27	AAXJ	ETF	87.16	87.43	86.99	87.28	538200.0
2020-11-27	ACES	ETF	71.08	72.45	71.0	71.38	75700.0
2020-11-27	ACIO	ETF	27.405	27.41	27.385	27.39	3300.0
2020-11-27	ACSI	ETF	42.4057	42.4057	42.4057	42.4057	0.0
2020-11-27	ACTV	ETF	29.5198	29.5509	29.42	29.5509	2902.0
2020-11-27	ACTX	ETF	2.8	2.8	2.65	2.65	922.0
2020-11-27	ACVF	ETF	27.04	27.04	26.934	26.934	3400.0
2020-11-27	ACWF	ETF	32.46	32.5	32.44	32.44	2460.0
2020-11-27	ACWI	ETF	88.26	88.46	88.16	88.41	1755400.0
2020-11-27	ACWV	ETF	96.09	96.09	95.8	96.0	95000.0
2020-11-27	ACWX	ETF	51.69	51.88	51.66	51.85	978153.0
2020-11-27	ADME	ETF	35.09	35.09	34.999	35.059	2700.0
2020-11-27	ADRE	ETF	54.86	54.975	54.7033	54.84	14134.0
2020-11-27	AESR	ETF	11.61	11.614	11.605	11.605	1100.0
2020-11-27	AFIF	ETF	9.8	9.83	9.7958	9.83	17361.0
2020-11-27	AFK	ETF	20.09	20.148	19.951	19.955	10127.0
2020-11-27	AFTY	ETF	22.12	22.13	22.107	22.107	800.0
2020-11-27	AGG	ETF	118.25	118.29	118.22	118.26	3436200.0
2020-11-27	AGGY	ETF	53.79	53.86	53.79	53.84	47200.0
2020-11-27	AGNG	ETF	26.752	26.792	26.752	26.792	1000.0
2020-11-27	AGQ	ETF	37.56	38.3	37.43	37.88	1858400.0
2020-11-27	AGZ	ETF	120.85	120.95	120.84	120.95	47072.0
2020-11-27	AGZD	ETF	23.53	23.55	23.485	23.515	8600.0
2020-11-27	AIA	ETF	83.86	84.1635	83.7399	84.06	68844.0
2020-11-27	AIEQ	ETF	33.56	33.82	33.56	33.779	18900.0
2020-11-27	AIQ	ETF	25.94	26.055	25.83	26.02	44353.0
2020-11-27	AIRR	ETF	32.45	32.45	31.98	32.193	9500.0
2020-11-27	AIVI	ETF	39.7	39.77	39.7	39.74	18400.0
2020-11-27	ALTL	ETF	30.91	30.91	30.89	30.89	1826.0
2020-11-27	ALTY	ETF	11.73	11.73	11.634	11.655	10000.0
2020-11-27	AMJ	ETF	14.45	14.45	13.965	13.98	719058.0
2020-11-27	AMLP	ETF	26.62	26.77	25.86	26.02	1723600.0
2020-11-27	AMNA	ETF	25.9097	25.9097	25.9097	25.9097	0.0
2020-11-27	AMND	ETF	27.5237	27.5237	27.5237	27.5237	1.0
2020-11-27	AMTR	ETF	29.2248	29.2248	29.2248	29.2248	1.0
2020-11-27	AMUB	ETF	8.97	8.97	8.81	8.8125	1890.0
2020-11-27	AMZA	ETF	19.61	19.82	19.0	19.07	80600.0
2020-11-27	ANEW	ETF	39.81	40.02	39.81	39.981	5200.0
2020-11-27	ANGL	ETF	31.48	31.5	31.44	31.47	925700.0
2020-11-27	AOA	ETF	62.7	62.9	62.7	62.85	24400.0
2020-11-27	AOK	ETF	38.43	38.6	38.389	38.42	37887.0

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

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