PREVIEW / etf_daily / 2019-11-14

all etf daily files

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

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-14	SPY	ETF	308.79	309.64	308.09	309.55	51219900.0
2019-11-14	QQQ	ETF	200.83	201.56	200.22	201.43	17055686.0
2019-11-14	IWM	ETF	157.93	158.91	157.79	158.1	13054000.0
2019-11-14	DIA	ETF	277.88	278.32	277.09	278.23	1582600.0
2019-11-14	GLD	ETF	138.39	138.94	137.87	138.56	5220500.0
2019-11-14	TLT	ETF	137.8	138.44	137.67	137.91	10213300.0
2019-11-14	AAAU	ETF	14.66	14.72	14.62	14.66	12200.0
2019-11-14	AADR	ETF	49.91	50.11	49.68	50.11	4300.0
2019-11-14	AAXJ	ETF	69.71	69.82	69.41	69.67	2082200.0
2019-11-14	ACES	ETF	31.62	31.78	31.5	31.78	20000.0
2019-11-14	ACIO	ETF	24.2	25.2	24.2	25.176	20800.0
2019-11-14	ACSI	ETF	34.7184	34.762	34.63	34.7039	3829.0
2019-11-14	ACTX	ETF	9.4401	10.5611	7.8176	9.2631	808.0
2019-11-14	ACWF	ETF	30.1944	30.2793	30.1944	30.2793	5817.0
2019-11-14	ACWI	ETF	76.66	76.88	76.55	76.88	1583300.0
2019-11-14	ACWV	ETF	94.83	95.05	94.72	95.03	122600.0
2019-11-14	ACWX	ETF	47.76	47.86	47.69	47.84	721270.0
2019-11-14	ADME	ETF	30.202	30.202	30.13	30.19	99300.0
2019-11-14	ADRE	ETF	40.8	40.8	40.67	40.7055	1685.0
2019-11-14	AFIF	ETF	9.82	9.82	9.805	9.805	7756.0
2019-11-14	AFK	ETF	20.9	20.9	20.6	20.63	7673.0
2019-11-14	AFTY	ETF	17.55	17.583	17.535	17.583	900.0
2019-11-14	AGG	ETF	112.5	112.57	112.43	112.47	2901000.0
2019-11-14	AGGY	ETF	52.09	52.126	52.04	52.11	128700.0
2019-11-14	AGNG	ETF	22.91	22.941	22.67	22.74	8900.0
2019-11-14	AGQ	ETF	28.93	29.29	28.6	29.09	178700.0
2019-11-14	AGZ	ETF	115.9	115.954	115.84	115.91	41922.0
2019-11-14	AGZD	ETF	24.0	24.005	23.955	23.98	4800.0
2019-11-14	AIA	ETF	61.67	61.83	61.57	61.82	21957.0
2019-11-14	AIEQ	ETF	27.04	27.12	26.934	27.05	14900.0
2019-11-14	AIQ	ETF	16.8	16.895	16.8	16.83	11535.0
2019-11-14	AIRR	ETF	28.764	28.764	28.62	28.62	2100.0
2019-11-14	AIVI	ETF	41.8	41.85	41.75	41.85	3300.0
2019-11-14	ALTY	ETF	14.69	14.77	14.682	14.72	9700.0
2019-11-14	AMJ	ETF	20.93	20.99	20.7	20.7	2097878.0
2019-11-14	AMLP	ETF	40.05	40.05	39.6	39.65	4776620.0
2019-11-14	AMUB	ETF	13.0923	13.0923	13.0923	13.0923	0.0
2019-11-14	AMZA	ETF	42.4	42.5	42.0	42.1	125640.0
2019-11-14	ANGL	ETF	29.19	29.23	29.15	29.19	233900.0
2019-11-14	AOA	ETF	56.43	56.54	56.33	56.52	48300.0
2019-11-14	AOK	ETF	35.83	35.9272	35.8116	35.9	68628.0
2019-11-14	AOM	ETF	39.61	39.6481	39.6	39.61	107044.0
2019-11-14	AOR	ETF	46.82	46.91	46.81	46.91	73398.0
2019-11-14	ARGT	ETF	21.8	22.08	21.8	21.99	25900.0
2019-11-14	ARKF	ETF	23.074	23.13	23.06	23.11	6400.0
2019-11-14	ARKG	ETF	31.38	31.38	30.935	31.099	72400.0
2019-11-14	ARKK	ETF	46.31	46.722	46.31	46.56	132000.0
2019-11-14	ARKQ	ETF	34.39	34.606	34.39	34.43	8700.0
2019-11-14	ARKW	ETF	53.26	53.76	53.2	53.65	36800.0
2019-11-14	ASEA	ETF	16.14	16.14	16.02	16.05	1300.0

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

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