PREVIEW / etf_daily / 2016-07-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-13.parquet
  size:    52 KB
  rows:    1,291

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-13	SPY	ETF	215.44	215.45	214.35	214.92	87324100.0
2016-07-13	QQQ	ETF	111.79	111.82	111.21	111.22	21107762.0
2016-07-13	IWM	ETF	120.33	120.39	118.95	119.25	28050200.0
2016-07-13	DIA	ETF	183.68	183.8	183.05	183.6	2390500.0
2016-07-13	GLD	ETF	128.0	128.43	127.61	128.32	7377700.0
2016-07-13	TLT	ETF	141.37	141.77	140.95	141.65	8181700.0
2016-07-13	AADR	ETF	39.87	39.88	39.45	39.78	2900.0
2016-07-13	AAXJ	ETF	56.23	56.26	55.93	56.19	688000.0
2016-07-13	ACTX	ETF	3.54	3.54	3.54	3.54	406.0
2016-07-13	ACWF	ETF	23.22	23.24	23.21	23.23	2851.0
2016-07-13	ACWI	ETF	57.64	57.7	57.34	57.48	1393100.0
2016-07-13	ACWV	ETF	77.54	77.57	77.38	77.52	203600.0
2016-07-13	ACWX	ETF	39.88	39.95	39.69	39.79	547493.0
2016-07-13	ADRE	ETF	32.24	32.24	32.042	32.13	6565.0
2016-07-13	AFK	ETF	20.69	21.038	20.51	20.65	23277.0
2016-07-13	AFTY	ETF	13.119	13.13	13.104	13.13	700.0
2016-07-13	AGG	ETF	112.82	112.88	112.74	112.77	2363300.0
2016-07-13	AGGY	ETF	52.15	52.22	52.15	52.185	4000.0
2016-07-13	AGQ	ETF	55.44	55.83	54.48	55.7	275200.0
2016-07-13	AGZ	ETF	115.81	115.8699	115.4601	115.69	21652.0
2016-07-13	AIA	ETF	45.83	45.83	45.54	45.69	36720.0
2016-07-13	AIQ	ETF	6.18	6.4	6.1	6.11	87844.0
2016-07-13	AIRR	ETF	19.435	19.435	19.435	19.435	100.0
2016-07-13	AIVI	ETF	38.74	38.75	38.48	38.56	30200.0
2016-07-13	ALTY	ETF	15.26	15.35	15.16	15.32	3100.0
2016-07-13	AMJ	ETF	32.27	32.53	31.78	32.03	3883370.0
2016-07-13	AMLP	ETF	64.85	65.1	63.85	64.0	1137600.0
2016-07-13	AMZA	ETF	112.8	112.93	110.1	111.2	7530.0
2016-07-13	ANGL	ETF	28.24	28.24	27.98	28.07	285900.0
2016-07-13	AOA	ETF	46.55	46.55	46.27	46.44	41100.0
2016-07-13	AOK	ETF	33.11	33.2	32.97	33.16	44033.0
2016-07-13	AOM	ETF	35.67	35.67	35.558	35.61	59008.0
2016-07-13	AOR	ETF	40.51	40.51	40.255	40.44	53176.0
2016-07-13	ARGT	ETF	23.03	23.05	22.72	22.93	37000.0
2016-07-13	ARKG	ETF	18.18	18.18	17.75	17.752	1300.0
2016-07-13	ARKK	ETF	20.62	20.62	20.48	20.48	500.0
2016-07-13	ARKQ	ETF	20.38	20.38	20.25	20.276	1300.0
2016-07-13	ARKW	ETF	23.388	23.388	23.388	23.388	100.0
2016-07-13	ASEA	ETF	13.99	13.99	13.87	13.91	8300.0
2016-07-13	ASHR	ETF	24.87	24.88	24.7	24.81	1707600.0
2016-07-13	ASHS	ETF	35.48	35.69	35.42	35.69	64900.0
2016-07-13	ASHX	ETF	22.671	22.671	22.671	22.671	209.0
2016-07-13	ATMP	ETF	22.7	22.74	22.44	22.54	59900.0
2016-07-13	BAB	ETF	31.71	31.8	31.6577	31.78	414103.0
2016-07-13	BAL	ETF	48.3	48.9399	48.17	48.847	29892.0
2016-07-13	BBC	ETF	19.3	19.3723	18.672	18.68	14928.0
2016-07-13	BBH	ETF	108.87	108.94	106.9	106.9	68800.0
2016-07-13	BBP	ETF	28.687	28.687	28.04	28.04	2700.0
2016-07-13	BCM	ETF	27.32	27.32	26.9541	27.05	54023.0
2016-07-13	BFOR	ETF	7.9325	7.9425	7.8725	7.9	110800.0

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

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