PREVIEW / etf_daily / 2019-11-19

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-19.parquet
  size:    72 KB
  rows:    1,889

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-19	SPY	ETF	312.68	312.69	311.22	311.93	67804700.0
2019-11-19	QQQ	ETF	203.84	203.84	202.59	203.37	16997568.0
2019-11-19	IWM	ETF	159.11	159.7	158.31	159.11	15203700.0
2019-11-19	DIA	ETF	280.83	280.84	278.87	279.33	1928300.0
2019-11-19	GLD	ETF	138.13	138.97	138.13	138.69	4824400.0
2019-11-19	TLT	ETF	138.37	139.24	138.37	139.16	7893100.0
2019-11-19	AAAU	ETF	14.63	14.71	14.63	14.68	18000.0
2019-11-19	AADR	ETF	50.3	50.3	50.0	50.1	3400.0
2019-11-19	AAXJ	ETF	70.8	70.8	70.45	70.57	615900.0
2019-11-19	ACES	ETF	32.18	32.18	31.84	32.035	15300.0
2019-11-19	ACIO	ETF	25.24	25.25	25.234	25.234	26200.0
2019-11-19	ACSI	ETF	34.9228	34.93	34.7	34.7839	1782.0
2019-11-19	ACTX	ETF	7.8176	8.7911	6.496	6.7851	1518.0
2019-11-19	ACWF	ETF	30.58	30.6086	30.44	30.5432	14212.0
2019-11-19	ACWI	ETF	77.65	77.75	77.25	77.37	2816200.0
2019-11-19	ACWV	ETF	95.8	95.83	95.6	95.75	290500.0
2019-11-19	ACWX	ETF	48.38	48.45	48.1	48.15	1621217.0
2019-11-19	ADME	ETF	30.36	30.36	30.33	30.33	48200.0
2019-11-19	ADRE	ETF	41.21	41.21	40.9393	40.97	4304.0
2019-11-19	AFIF	ETF	9.77	9.77	9.75	9.765	8514.0
2019-11-19	AFK	ETF	20.63	20.87	20.63	20.725	5028.0
2019-11-19	AFTY	ETF	17.644	17.653	17.606	17.64	11600.0
2019-11-19	AGG	ETF	112.63	112.76	112.6	112.7	2210700.0
2019-11-19	AGGY	ETF	52.15	52.21	52.12	52.2	88800.0
2019-11-19	AGNG	ETF	23.25	23.3	23.238	23.238	2300.0
2019-11-19	AGQ	ETF	28.99	29.62	28.99	29.5	102200.0
2019-11-19	AGZ	ETF	115.96	116.15	115.96	116.08	60175.0
2019-11-19	AGZD	ETF	24.04	24.04	23.95	23.98	10000.0
2019-11-19	AIA	ETF	63.08	63.0851	62.8314	62.96	14491.0
2019-11-19	AIEQ	ETF	27.45	27.56	27.382	27.56	15300.0
2019-11-19	AIQ	ETF	17.13	17.14	17.06	17.1302	12735.0
2019-11-19	AIRR	ETF	28.584	28.607	28.45	28.49	2700.0
2019-11-19	AIVI	ETF	42.04	42.08	41.96	41.99	3700.0
2019-11-19	ALTY	ETF	14.7	14.719	14.68	14.685	6700.0
2019-11-19	AMJ	ETF	20.57	20.61	20.21	20.25	2621241.0
2019-11-19	AMLP	ETF	39.25	39.35	38.45	38.55	6609440.0
2019-11-19	AMUB	ETF	12.7432	12.7432	12.7432	12.7432	0.0
2019-11-19	AMZA	ETF	41.7	41.8	40.7	40.8	130590.0
2019-11-19	ANGL	ETF	29.25	29.25	29.17	29.2	267100.0
2019-11-19	AOA	ETF	56.97	56.99	56.75	56.87	151900.0
2019-11-19	AOK	ETF	36.0	36.03	35.98	36.0	89931.0
2019-11-19	AOM	ETF	39.76	39.839	39.72	39.72	293857.0
2019-11-19	AOR	ETF	47.22	47.22	47.11	47.13	167200.0
2019-11-19	ARGT	ETF	22.01	22.07	21.57	22.02	31500.0
2019-11-19	ARKF	ETF	23.42	23.43	23.2	23.285	15200.0
2019-11-19	ARKG	ETF	32.0	33.284	32.0	32.83	137400.0
2019-11-19	ARKK	ETF	47.71	48.702	47.71	48.45	232900.0
2019-11-19	ARKQ	ETF	34.7	34.93	34.46	34.52	12300.0
2019-11-19	ARKW	ETF	54.56	54.81	54.06	54.69	74500.0
2019-11-19	ASEA	ETF	16.12	16.14	16.02	16.02	1900.0

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

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