PREVIEW / etf_daily / 2020-11-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-16.parquet
  size:    81 KB
  rows:    2,145

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-16	SPY	ETF	360.98	362.78	359.59	362.57	74541100.0
2020-11-16	QQQ	ETF	290.68	293.51	289.99	293.2	30168361.0
2020-11-16	IWM	ETF	176.49	177.78	175.4	177.63	31812300.0
2020-11-16	DIA	ETF	299.28	300.08	297.57	299.98	4615000.0
2020-11-16	GLD	ETF	177.23	177.91	176.87	177.15	8358500.0
2020-11-16	TLT	ETF	157.73	158.28	157.61	157.78	6310400.0
2020-11-16	AAA	ETF	25.01	25.02	25.01	25.01	5301.0
2020-11-16	AAAU	ETF	18.8	18.88	18.77	18.8	542000.0
2020-11-16	AADR	ETF	57.4	57.58	57.06	57.26	5300.0
2020-11-16	AAXJ	ETF	85.16	85.67	85.08	85.32	1816500.0
2020-11-16	ABEQ	ETF	25.31	25.31	24.85	24.903	2600.0
2020-11-16	ACES	ETF	62.95	63.16	62.48	63.16	99400.0
2020-11-16	ACIO	ETF	27.54	27.54	27.36	27.44	7700.0
2020-11-16	ACSI	ETF	41.5608	41.627	41.5608	41.627	848.0
2020-11-16	ACTV	ETF	28.41	28.41	28.24	28.3324	6193.0
2020-11-16	ACTX	ETF	3.0	3.0	2.77	2.85	820.0
2020-11-16	ACVF	ETF	26.88	26.88	26.75	26.809	10500.0
2020-11-16	ACWF	ETF	32.18	32.225	32.09	32.19	4216.0
2020-11-16	ACWI	ETF	86.83	87.06	86.5	87.06	3428400.0
2020-11-16	ACWV	ETF	97.17	97.17	96.45	96.87	198700.0
2020-11-16	ACWX	ETF	50.57	50.65	50.37	50.65	2495928.0
2020-11-16	ADME	ETF	35.1	35.16	35.0	35.16	16900.0
2020-11-16	ADRE	ETF	53.2	53.784	53.2	53.395	16398.0
2020-11-16	AESR	ETF	11.53	11.558	11.53	11.558	5400.0
2020-11-16	AFIF	ETF	9.78	9.79	9.77	9.79	8716.0
2020-11-16	AFK	ETF	19.66	19.94	19.55	19.71	11709.0
2020-11-16	AFLG	ETF	21.551	21.551	21.551	21.551	100.0
2020-11-16	AFMC	ETF	19.94	20.013	19.94	20.013	200.0
2020-11-16	AFSM	ETF	20.07	20.178	20.07	20.178	200.0
2020-11-16	AFTY	ETF	21.37	21.38	21.369	21.369	800.0
2020-11-16	AGG	ETF	117.61	117.67	117.58	117.63	7951400.0
2020-11-16	AGGY	ETF	53.6	53.66	53.58	53.66	353900.0
2020-11-16	AGNG	ETF	27.12	27.12	26.976	26.99	6400.0
2020-11-16	AGQ	ETF	45.35	46.23	45.07	45.98	696500.0
2020-11-16	AGZ	ETF	120.73	120.73	120.59	120.64	72094.0
2020-11-16	AGZD	ETF	23.49	23.54	23.48	23.53	15600.0
2020-11-16	AIA	ETF	82.22	82.595	82.06	82.41	208435.0
2020-11-16	AIEQ	ETF	32.0	32.098	31.8	32.024	11700.0
2020-11-16	AIQ	ETF	24.975	25.2597	24.97	25.1838	48172.0
2020-11-16	AIRR	ETF	30.9	31.39	30.84	31.24	87400.0
2020-11-16	AIVI	ETF	38.9	38.98	38.76	38.81	27800.0
2020-11-16	ALTL	ETF	28.72	29.01	28.7102	29.01	1449.0
2020-11-16	ALTY	ETF	11.37	11.497	11.35	11.451	14700.0
2020-11-16	AMJ	ETF	13.0	13.51	13.0	13.35	1080981.0
2020-11-16	AMLP	ETF	23.5	24.41	23.5	23.98	3880900.0
2020-11-16	AMNA	ETF	23.814	23.814	23.814	23.814	20.0
2020-11-16	AMND	ETF	25.48	25.48	25.3059	25.3059	200.0
2020-11-16	AMOM	ETF	36.46	36.492	36.37	36.492	1100.0
2020-11-16	AMTR	ETF	26.69	27.23	26.55	26.87	412900.0
2020-11-16	AMUB	ETF	8.24	8.435	8.24	8.35	16425.0

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

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