PREVIEW / etf_daily / 2016-11-16

all etf daily files

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

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-16	SPY	ETF	217.56	218.14	217.42	217.87	65617700.0
2016-11-16	QQQ	ETF	115.7	116.9932	115.67	116.91	16538132.0
2016-11-16	IWM	ETF	129.25	130.0	129.03	129.54	42325500.0
2016-11-16	DIA	ETF	188.79	189.18	188.53	188.98	3459100.0
2016-11-16	GLD	ETF	117.27	117.27	116.58	116.77	5486100.0
2016-11-16	TLT	ETF	122.3	123.14	122.17	123.01	9149500.0
2016-11-16	AADR	ETF	39.48	39.48	39.1	39.1	4400.0
2016-11-16	AAXJ	ETF	55.65	55.71	55.4	55.6	1924100.0
2016-11-16	ACSI	ETF	26.06	26.08	26.01	26.01	19452.0
2016-11-16	ACTX	ETF	20.9452	23.6002	20.6502	22.4202	5571.0
2016-11-16	ACWI	ETF	57.94	58.1	57.9	58.02	9130700.0
2016-11-16	ACWV	ETF	72.36	72.55	72.29	72.53	153000.0
2016-11-16	ACWX	ETF	39.46	39.63	39.46	39.5	665943.0
2016-11-16	ADRE	ETF	32.57	32.92	32.57	32.82	11509.0
2016-11-16	AFK	ETF	19.12	19.49	19.0101	19.4899	3202.0
2016-11-16	AFTY	ETF	13.5	13.5	13.48	13.5	4300.0
2016-11-16	AGG	ETF	109.01	109.13	108.92	109.13	2164800.0
2016-11-16	AGGY	ETF	50.201	50.35	50.201	50.33	9900.0
2016-11-16	AGQ	ETF	37.49	37.49	36.5	36.86	133400.0
2016-11-16	AGZ	ETF	113.39	113.77	113.39	113.56	11950.0
2016-11-16	AGZD	ETF	24.0	24.0	23.96	23.96	1400.0
2016-11-16	AIA	ETF	46.53	46.72	46.53	46.7099	37841.0
2016-11-16	AIQ	ETF	7.65	7.65	7.55	7.6	4085.0
2016-11-16	AIRR	ETF	22.78	22.78	22.39	22.49	177400.0
2016-11-16	AIVI	ETF	36.2	36.26	36.06	36.19	13100.0
2016-11-16	ALTY	ETF	14.31	14.5	14.31	14.46	4200.0
2016-11-16	AMJ	ETF	31.24	31.24	30.22	30.29	2647245.0
2016-11-16	AMLP	ETF	61.45	61.55	60.55	60.6	1600180.0
2016-11-16	AMZA	ETF	111.0	111.0	108.17	108.5	19960.0
2016-11-16	ANGL	ETF	28.31	28.44	28.29	28.42	240100.0
2016-11-16	AOA	ETF	46.45	46.48	46.38	46.44	45700.0
2016-11-16	AOK	ETF	32.39	32.5099	32.35	32.46	88883.0
2016-11-16	AOM	ETF	35.23	35.23	34.99	35.04	172326.0
2016-11-16	AOR	ETF	40.17	40.17	39.94	40.1	173511.0
2016-11-16	ARGT	ETF	22.7	22.76	22.62	22.65	12100.0
2016-11-16	ARKG	ETF	19.22	19.29	18.94	18.94	2700.0
2016-11-16	ARKQ	ETF	21.547	21.55	21.547	21.55	300.0
2016-11-16	ARKW	ETF	25.28	25.46	25.28	25.46	600.0
2016-11-16	ASEA	ETF	12.97	12.97	12.97	12.97	300.0
2016-11-16	ASHR	ETF	24.97	24.97	24.89	24.92	445000.0
2016-11-16	ASHS	ETF	35.02	35.07	34.93	35.02	17200.0
2016-11-16	ASHX	ETF	23.45	23.47	23.45	23.47	2000.0
2016-11-16	ATMP	ETF	23.0	23.0	22.64	22.72	296900.0
2016-11-16	BAB	ETF	29.64	29.68	29.51	29.6	126103.0
2016-11-16	BAL	ETF	46.92	47.34	46.92	47.2311	61557.0
2016-11-16	BBC	ETF	22.13	22.3148	21.4329	21.4329	10034.0
2016-11-16	BBH	ETF	113.62	114.05	112.29	112.32	66300.0
2016-11-16	BBP	ETF	35.66	35.954	34.94	34.972	42600.0
2016-11-16	BCM	ETF	25.82	25.83	25.7968	25.798	3831.0
2016-11-16	BFOR	ETF	8.43	8.45	8.4175	8.4425	196400.0

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

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