PREVIEW / etf_daily / 2019-11-11

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-11.parquet
  size:    71 KB
  rows:    1,866

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
2019-11-11	SPY	ETF	307.42	308.54	307.27	308.35	35797300.0
2019-11-11	QQQ	ETF	200.23	201.0363	199.94	200.96	10187222.0
2019-11-11	IWM	ETF	158.03	158.9	157.88	158.78	10508700.0
2019-11-11	DIA	ETF	275.79	277.41	275.39	277.16	1729000.0
2019-11-11	GLD	ETF	137.61	137.79	136.44	137.06	7037300.0
2019-11-11	TLT	ETF	135.38	135.39	134.64	135.0	4577000.0
2019-11-11	AAAU	ETF	14.58	14.59	14.46	14.52	40300.0
2019-11-11	AADR	ETF	49.52	49.85	49.52	49.8	3800.0
2019-11-11	AAXJ	ETF	70.52	70.85	70.35	70.82	1079700.0
2019-11-11	ACES	ETF	31.43	31.674	31.43	31.645	6400.0
2019-11-11	ACIO	ETF	25.12	25.22	25.12	25.172	9100.0
2019-11-11	ACSI	ETF	34.51	34.7644	34.51	34.7212	1833.0
2019-11-11	ACTX	ETF	10.6791	10.6791	8.8501	9.9841	383.0
2019-11-11	ACWF	ETF	30.25	30.3975	30.22	30.3359	22787.0
2019-11-11	ACWI	ETF	76.69	76.99	76.6	76.99	1012200.0
2019-11-11	ACWV	ETF	94.73	94.94	94.68	94.87	307900.0
2019-11-11	ACWX	ETF	48.02	48.225	47.99	48.19	672541.0
2019-11-11	ADME	ETF	30.085	30.14	30.085	30.123	36500.0
2019-11-11	ADRE	ETF	41.2177	41.3798	41.1616	41.3517	2636.0
2019-11-11	AFIF	ETF	9.79	9.79	9.785	9.785	2241.0
2019-11-11	AFK	ETF	20.6	20.77	20.55	20.75	12949.0
2019-11-11	AFTY	ETF	17.74	17.79	17.67	17.79	5000.0
2019-11-11	AGG	ETF	111.96	111.96	111.78	111.83	1559900.0
2019-11-11	AGGY	ETF	51.87	51.87	51.78	51.83	129400.0
2019-11-11	AGNG	ETF	22.84	22.91	22.84	22.86	800.0
2019-11-11	AGQ	ETF	28.4	28.68	27.87	28.53	198000.0
2019-11-11	AGZ	ETF	115.42	115.4294	115.32	115.4065	24834.0
2019-11-11	AGZD	ETF	24.005	24.005	23.955	23.98	3200.0
2019-11-11	AIA	ETF	62.24	62.6	62.07	62.54	16388.0
2019-11-11	AIEQ	ETF	26.81	26.9	26.791	26.85	22800.0
2019-11-11	AIQ	ETF	16.9	16.9	16.77	16.85	20709.0
2019-11-11	AIRR	ETF	28.71	28.82	28.71	28.78	2900.0
2019-11-11	AIVI	ETF	41.9	42.09	41.9	42.07	14600.0
2019-11-11	ALTY	ETF	14.76	14.76	14.71	14.71	5500.0
2019-11-11	AMJ	ETF	21.28	21.45	21.08	21.13	1388423.0
2019-11-11	AMLP	ETF	41.55	41.7	41.2	41.2	2918680.0
2019-11-11	AMUB	ETF	13.2808	13.2808	13.2808	13.2808	0.0
2019-11-11	AMZA	ETF	43.8	43.8	43.0	43.0	46540.0
2019-11-11	ANGL	ETF	29.21	29.21	29.16	29.19	221900.0
2019-11-11	AOA	ETF	56.41	56.53	56.33	56.52	33000.0
2019-11-11	AOK	ETF	35.78	35.82	35.7	35.82	72297.0
2019-11-11	AOM	ETF	39.56	39.56	39.45	39.51	122626.0
2019-11-11	AOR	ETF	46.82	46.8889	46.69	46.87	101753.0
2019-11-11	ARGT	ETF	21.72	21.93	21.72	21.9	6600.0
2019-11-11	ARKF	ETF	22.67	22.908	22.67	22.89	5500.0
2019-11-11	ARKG	ETF	30.55	30.858	30.2	30.85	72200.0
2019-11-11	ARKK	ETF	45.55	46.385	45.5	46.32	136100.0
2019-11-11	ARKQ	ETF	35.11	35.27	35.1	35.18	11600.0
2019-11-11	ARKW	ETF	52.57	53.549	52.57	53.44	107700.0
2019-11-11	ASEA	ETF	16.23	16.24	16.12	16.12	5100.0

> showing 50 of 1,866 rows — these rows as CSV

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