PREVIEW / etf_daily / 2016-11-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-08.parquet
  size:    52 KB
  rows:    1,320

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-08	SPY	ETF	212.69	214.77	212.38	214.11	106772100.0
2016-11-08	QQQ	ETF	116.21	117.64	115.96	117.11	20777919.0
2016-11-08	IWM	ETF	118.3	119.46	117.71	118.88	26196800.0
2016-11-08	DIA	ETF	182.2	184.04	182.02	183.38	3437500.0
2016-11-08	GLD	ETF	122.12	123.09	121.36	121.64	9480600.0
2016-11-08	TLT	ETF	131.02	131.21	129.71	130.09	7576500.0
2016-11-08	AADR	ETF	41.47	41.66	41.47	41.6	1600.0
2016-11-08	AAXJ	ETF	58.8	59.64	58.77	59.39	602500.0
2016-11-08	ACSI	ETF	27.01	27.01	25.01	25.1999	22513.0
2016-11-08	ACTX	ETF	15.3401	15.9301	14.7501	15.3401	2729.0
2016-11-08	ACWF	ETF	23.91	23.91	23.91	23.91	135.0
2016-11-08	ACWI	ETF	57.78	58.35	57.7	58.22	1872400.0
2016-11-08	ACWV	ETF	73.6	74.23	73.6	74.03	297000.0
2016-11-08	ACWX	ETF	40.47	40.83	40.38	40.71	849916.0
2016-11-08	ADRE	ETF	35.09	35.09	35.09	35.09	2219.0
2016-11-08	AFK	ETF	20.17	20.17	20.031	20.1	1509.0
2016-11-08	AFTY	ETF	13.73	13.75	13.66	13.67	6600.0
2016-11-08	AGG	ETF	111.13	111.16	110.87	110.93	2107400.0
2016-11-08	AGGY	ETF	51.35	51.42	51.21	51.21	20600.0
2016-11-08	AGQ	ETF	43.32	45.45	43.29	43.55	203300.0
2016-11-08	AGZ	ETF	115.17	115.1824	114.75	114.91	14569.0
2016-11-08	AGZD	ETF	23.9	23.965	23.9	23.95	6200.0
2016-11-08	AIA	ETF	48.94	49.56	48.86	49.4	16674.0
2016-11-08	AIQ	ETF	7.6	7.75	7.6	7.7	9729.0
2016-11-08	AIRR	ETF	19.53	19.669	19.53	19.562	7900.0
2016-11-08	AIVI	ETF	37.25	37.56	37.22	37.49	13400.0
2016-11-08	ALTY	ETF	14.69	14.7	14.69	14.7	500.0
2016-11-08	AMJ	ETF	29.16	29.62	29.16	29.26	1438150.0
2016-11-08	AMLP	ETF	59.7	60.4	59.5	59.9	1057280.0
2016-11-08	AMZA	ETF	103.1	104.1	102.7	102.8	13070.0
2016-11-08	ANGL	ETF	28.62	28.73	28.62	28.7	115000.0
2016-11-08	AOA	ETF	46.49	46.79	46.38	46.58	62000.0
2016-11-08	AOK	ETF	32.83	32.9093	32.805	32.87	44145.0
2016-11-08	AOM	ETF	35.43	35.4899	35.35	35.39	78672.0
2016-11-08	AOR	ETF	40.22	40.46	40.1896	40.3	57710.0
2016-11-08	ARGT	ETF	23.53	23.68	23.24	23.61	28500.0
2016-11-08	ARKK	ETF	19.81	20.07	19.81	19.99	500.0
2016-11-08	ARKQ	ETF	20.544	20.613	20.544	20.613	200.0
2016-11-08	ARKW	ETF	24.81	24.81	24.52	24.741	1700.0
2016-11-08	ASEA	ETF	13.57	13.57	13.57	13.57	200.0
2016-11-08	ASHR	ETF	24.88	25.06	24.84	24.98	913900.0
2016-11-08	ASHS	ETF	34.75	34.94	34.75	34.94	1700.0
2016-11-08	ATMP	ETF	21.85	22.07	21.83	21.84	64500.0
2016-11-08	BAB	ETF	30.75	30.7999	30.61	30.61	78695.0
2016-11-08	BAL	ETF	45.56	46.4399	45.5	45.5	6758.0
2016-11-08	BBC	ETF	18.16	18.35	17.8066	18.25	27754.0
2016-11-08	BBH	ETF	104.34	106.72	104.12	105.51	163400.0
2016-11-08	BBP	ETF	29.969	30.79	29.969	30.403	4100.0
2016-11-08	BFOR	ETF	7.8275	7.885	7.805	7.85	100800.0
2016-11-08	BIB	ETF	38.48	40.28	38.29	39.27	728495.0

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

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