PREVIEW / etf_daily / 2016-05-20

all etf daily files

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

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-05-20	SPY	ETF	204.92	206.1	204.86	205.49	104990400.0
2016-05-20	QQQ	ETF	105.74	106.9	105.67	106.47	29549578.0
2016-05-20	IWM	ETF	109.29	110.79	109.23	110.79	37404500.0
2016-05-20	DIA	ETF	174.72	175.54	174.51	174.76	2749700.0
2016-05-20	GLD	ETF	120.19	120.32	119.31	119.71	10379400.0
2016-05-20	TLT	ETF	129.65	130.4	129.55	130.15	5348900.0
2016-05-20	AADR	ETF	38.44	38.44	38.44	38.44	300.0
2016-05-20	AAXJ	ETF	51.35	51.48	51.27	51.33	1889700.0
2016-05-20	ACTX	ETF	5.31	5.9001	4.72	5.9001	482.0
2016-05-20	ACWF	ETF	22.73	22.77	22.73	22.77	1036.0
2016-05-20	ACWI	ETF	55.8	56.01	55.77	55.89	969200.0
2016-05-20	ACWV	ETF	72.98	73.04	72.75	72.92	125400.0
2016-05-20	ACWX	ETF	39.25	39.36	39.2	39.27	967614.0
2016-05-20	ADRE	ETF	29.75	29.91	29.75	29.83	5378.0
2016-05-20	AFK	ETF	20.79	21.08	19.9852	20.13	55880.0
2016-05-20	AFTY	ETF	12.27	12.329	12.27	12.32	600.0
2016-05-20	AGG	ETF	110.54	110.62	110.44	110.54	2655700.0
2016-05-20	AGGY	ETF	50.76	50.77	50.635	50.682	5300.0
2016-05-20	AGQ	ETF	37.9	37.9	36.73	37.23	134500.0
2016-05-20	AGZ	ETF	114.516	114.7599	114.51	114.7	26438.0
2016-05-20	AGZD	ETF	23.99	23.99	23.99	23.99	1600.0
2016-05-20	AIA	ETF	40.85	40.95	40.85	40.8801	10208.0
2016-05-20	AIQ	ETF	7.38	7.706	7.26	7.26	10744.0
2016-05-20	AIRR	ETF	17.54	17.54	17.54	17.54	200.0
2016-05-20	AIVI	ETF	38.0	38.09	37.91	38.04	29300.0
2016-05-20	ALTY	ETF	14.5	14.5	14.5	14.5	600.0
2016-05-20	AMJ	ETF	30.83	31.18	30.51	31.02	1943407.0
2016-05-20	AMLP	ETF	61.7	62.55	60.95	62.1	1785820.0
2016-05-20	AMZA	ETF	110.3	111.1	108.0	110.8	40740.0
2016-05-20	ANGL	ETF	26.82	26.96	26.69	26.77	58900.0
2016-05-20	AOA	ETF	44.96	45.16	44.96	45.06	41000.0
2016-05-20	AOK	ETF	32.29	32.3	32.1501	32.28	59039.0
2016-05-20	AOM	ETF	34.63	34.7499	34.5101	34.65	82401.0
2016-05-20	AOR	ETF	39.17	39.3299	39.14	39.28	264153.0
2016-05-20	ARGT	ETF	20.37	20.47	20.18	20.42	22900.0
2016-05-20	ARKG	ETF	16.702	16.78	16.702	16.78	400.0
2016-05-20	ARKK	ETF	18.214	18.214	18.195	18.2	3000.0
2016-05-20	ARKQ	ETF	18.356	18.356	18.356	18.356	200.0
2016-05-20	ARKW	ETF	20.66	20.88	20.66	20.853	1200.0
2016-05-20	ASEA	ETF	12.76	12.77	12.72	12.72	7900.0
2016-05-20	ASHR	ETF	23.09	23.17	22.99	23.11	1168000.0
2016-05-20	ASHS	ETF	31.76	31.76	31.48	31.56	77700.0
2016-05-20	ATMP	ETF	21.11	21.47	21.06	21.32	168900.0
2016-05-20	BAB	ETF	30.45	30.49	30.3401	30.46	179857.0
2016-05-20	BAL	ETF	40.991	41.005	40.79	40.79	20750.0
2016-05-20	BBC	ETF	18.32	18.95	18.32	18.95	24808.0
2016-05-20	BBH	ETF	103.91	105.53	103.71	105.1	67000.0
2016-05-20	BBP	ETF	25.15	25.96	25.15	25.906	35800.0
2016-05-20	BFOR	ETF	7.435	7.48	7.435	7.4675	22400.0
2016-05-20	BIB	ETF	40.34	41.69	39.97	41.38	509519.0

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

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