PREVIEW / etf_daily / 2016-11-15

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-15.parquet
  size:    53 KB
  rows:    1,326

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-11-15	SPY	ETF	217.04	218.28	216.8	218.28	91652600.0
2016-11-15	QQQ	ETF	115.47	116.62	115.33	116.22	31796602.0
2016-11-15	IWM	ETF	128.85	129.89	128.3	129.55	38704500.0
2016-11-15	DIA	ETF	188.76	189.35	188.14	189.34	3750000.0
2016-11-15	GLD	ETF	116.46	117.24	116.29	117.12	9348600.0
2016-11-15	TLT	ETF	122.22	122.81	121.78	121.91	11963700.0
2016-11-15	AADR	ETF	39.09	39.38	39.01	39.38	4100.0
2016-11-15	AAXJ	ETF	55.6	56.15	55.56	56.15	2057700.0
2016-11-15	ACSI	ETF	25.96	26.12	25.96	26.12	20523.0
2016-11-15	ACTX	ETF	15.3401	20.0602	15.3401	19.4112	3565.0
2016-11-15	ACWI	ETF	57.62	58.26	57.62	58.26	2139200.0
2016-11-15	ACWV	ETF	72.21	72.59	72.21	72.52	197300.0
2016-11-15	ACWX	ETF	39.56	39.88	39.5301	39.87	681550.0
2016-11-15	ADRE	ETF	32.6	32.9355	32.53	32.82	17650.0
2016-11-15	AFK	ETF	19.42	19.63	18.81	19.49	11659.0
2016-11-15	AFTY	ETF	13.51	13.522	13.49	13.51	9800.0
2016-11-15	AGG	ETF	109.0	109.07	108.87	108.89	2252200.0
2016-11-15	AGGY	ETF	50.31	50.366	50.23	50.302	44000.0
2016-11-15	AGQ	ETF	36.75	37.68	36.55	37.49	168300.0
2016-11-15	AGZ	ETF	113.63	113.94	113.421	113.7	17677.0
2016-11-15	AGZD	ETF	24.05	24.05	24.015	24.015	2600.0
2016-11-15	AIA	ETF	46.71	47.08	46.7	47.08	49836.0
2016-11-15	AIQ	ETF	7.8	7.815	7.5875	7.6999	14359.0
2016-11-15	AIRR	ETF	22.63	22.69	22.43	22.66	808400.0
2016-11-15	AIVI	ETF	36.31	36.53	36.26	36.52	13700.0
2016-11-15	ALTY	ETF	14.483	14.584	14.483	14.584	1900.0
2016-11-15	AMJ	ETF	30.87	30.94	30.56	30.78	2472944.0
2016-11-15	AMLP	ETF	61.75	61.8	61.15	61.5	1686360.0
2016-11-15	AMZA	ETF	110.0	111.05	109.52	110.6	28740.0
2016-11-15	ANGL	ETF	28.12	28.47	28.12	28.42	81400.0
2016-11-15	AOA	ETF	46.28	46.62	46.28	46.52	77400.0
2016-11-15	AOK	ETF	32.34	32.52	32.2701	32.46	69290.0
2016-11-15	AOM	ETF	34.98	35.15	34.916	35.1	74440.0
2016-11-15	AOR	ETF	40.03	40.18	39.952	40.14	52367.0
2016-11-15	ARGT	ETF	22.3	22.98	22.28	22.85	22900.0
2016-11-15	ARKG	ETF	19.18	19.45	19.18	19.42	7100.0
2016-11-15	ARKK	ETF	20.595	20.595	20.595	20.595	500.0
2016-11-15	ARKQ	ETF	21.27	21.36	21.23	21.36	1300.0
2016-11-15	ARKW	ETF	25.16	25.3	25.16	25.3	800.0
2016-11-15	ASEA	ETF	12.99	13.08	12.97	13.03	4000.0
2016-11-15	ASET	ETF	24.8352	24.87	24.8352	24.87	1040.0
2016-11-15	ASHR	ETF	25.03	25.08	25.0	25.07	434800.0
2016-11-15	ASHS	ETF	35.13	35.15	35.12	35.14	6400.0
2016-11-15	ATMP	ETF	22.82	23.05	22.79	22.97	60100.0
2016-11-15	BAB	ETF	29.32	29.6898	29.32	29.57	404486.0
2016-11-15	BAL	ETF	45.797	46.26	45.797	46.25	3589.0
2016-11-15	BBC	ETF	22.21	22.27	21.79	22.1	5723.0
2016-11-15	BBH	ETF	114.0	114.0	111.95	113.76	82400.0
2016-11-15	BBP	ETF	36.34	36.34	35.537	35.99	19400.0
2016-11-15	BFOR	ETF	8.4025	8.4675	8.36	8.45	100000.0

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

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