PREVIEW / etf_daily / 2016-07-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-20.parquet
  size:    51 KB
  rows:    1,286

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
2016-07-20	SPY	ETF	216.19	217.37	216.19	217.09	58159500.0
2016-07-20	QQQ	ETF	112.75	113.65	112.6	113.44	24997929.0
2016-07-20	IWM	ETF	119.55	120.44	118.94	120.08	22390500.0
2016-07-20	DIA	ETF	185.9	186.08	185.39	185.78	2159500.0
2016-07-20	GLD	ETF	125.5	126.12	125.31	125.39	11777700.0
2016-07-20	TLT	ETF	138.23	138.51	137.91	138.28	6942500.0
2016-07-20	AADR	ETF	39.76	40.45	39.76	40.45	500.0
2016-07-20	AAXJ	ETF	56.91	57.06	56.76	57.0	784200.0
2016-07-20	ACTX	ETF	2.95	4.13	2.95	3.54	947.0
2016-07-20	ACWI	ETF	57.82	58.03	57.73	57.95	516800.0
2016-07-20	ACWV	ETF	77.71	77.76	77.54	77.61	153200.0
2016-07-20	ACWX	ETF	40.01	40.145	39.914	40.08	337734.0
2016-07-20	ADRE	ETF	32.575	32.8	32.55	32.7001	3221.0
2016-07-20	AFK	ETF	20.06	20.07	19.8001	19.9701	15604.0
2016-07-20	AFTY	ETF	13.0	13.1	13.0	13.1	7600.0
2016-07-20	AGG	ETF	112.42	112.44	112.3	112.41	1808800.0
2016-07-20	AGGY	ETF	52.02	52.02	51.91	52.02	9200.0
2016-07-20	AGQ	ETF	50.77	51.31	50.14	50.43	351300.0
2016-07-20	AGZ	ETF	115.99	115.99	115.3115	115.49	23905.0
2016-07-20	AGZD	ETF	23.95	23.95	23.93	23.95	6200.0
2016-07-20	AIA	ETF	46.69	46.8062	46.61	46.8	30638.0
2016-07-20	AIQ	ETF	6.23	6.24	6.08	6.105	16385.0
2016-07-20	AIRR	ETF	19.21	19.372	19.148	19.35	4200.0
2016-07-20	AIVI	ETF	38.19	38.34	38.11	38.33	14900.0
2016-07-20	ALTY	ETF	15.44	15.516	15.44	15.516	1100.0
2016-07-20	AMJ	ETF	31.87	32.46	31.78	32.36	1180570.0
2016-07-20	AMLP	ETF	64.2	64.9	63.9	64.75	816400.0
2016-07-20	AMZA	ETF	113.5	114.5	112.0	114.2	7600.0
2016-07-20	ANGL	ETF	28.27	28.3	28.22	28.28	143800.0
2016-07-20	AOA	ETF	46.5	46.74	46.5	46.72	27400.0
2016-07-20	AOK	ETF	33.16	33.16	33.0501	33.12	37793.0
2016-07-20	AOM	ETF	35.65	35.7099	35.571	35.68	106208.0
2016-07-20	AOR	ETF	40.33	40.53	40.33	40.5	49341.0
2016-07-20	ARGT	ETF	22.73	22.77	22.32	22.74	22800.0
2016-07-20	ARKG	ETF	18.17	18.19	18.17	18.19	1900.0
2016-07-20	ARKK	ETF	20.3	20.416	20.3	20.416	200.0
2016-07-20	ARKQ	ETF	20.418	20.5	20.418	20.5	500.0
2016-07-20	ASEA	ETF	13.91	13.97	13.91	13.97	700.0
2016-07-20	ASET	ETF	27.22	27.23	27.205	27.229	2302.0
2016-07-20	ASHR	ETF	24.44	24.53	24.37	24.48	442400.0
2016-07-20	ASHS	ETF	35.3	35.44	35.3	35.44	12300.0
2016-07-20	ASHX	ETF	22.34	22.3799	22.3	22.3799	2288.0
2016-07-20	ATMP	ETF	22.8	23.03	22.8	22.98	21500.0
2016-07-20	BAB	ETF	31.42	31.4399	31.216	31.41	144817.0
2016-07-20	BAL	ETF	48.21	48.435	47.87	48.18	22096.0
2016-07-20	BBC	ETF	18.41	19.05	18.41	19.0367	7639.0
2016-07-20	BBH	ETF	108.11	110.48	108.11	110.24	60300.0
2016-07-20	BBP	ETF	28.685	29.21	28.685	29.165	4100.0
2016-07-20	BCM	ETF	26.64	26.67	26.39	26.49	26600.0
2016-07-20	BFOR	ETF	7.91	7.99	7.91	7.975	72400.0

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

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