PREVIEW / etf_daily / 2016-06-09

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-09.parquet
  size:    51 KB
  rows:    1,272

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-06-09	SPY	ETF	211.51	212.22	211.19	212.08	73786900.0
2016-06-09	QQQ	ETF	109.93	110.31	109.71	110.19	17571631.0
2016-06-09	IWM	ETF	117.94	117.94	117.29	117.67	23440700.0
2016-06-09	DIA	ETF	179.37	180.04	179.14	179.88	2141800.0
2016-06-09	GLD	ETF	120.61	121.48	120.55	121.25	12174000.0
2016-06-09	TLT	ETF	134.32	134.54	133.93	134.13	6820300.0
2016-06-09	AADR	ETF	38.67	39.3	38.67	38.76	5500.0
2016-06-09	AAXJ	ETF	54.66	54.84	54.6	54.78	520100.0
2016-06-09	ACTX	ETF	4.72	4.72	4.13	4.13	559.0
2016-06-09	ACWI	ETF	57.69	57.79	57.54	57.72	878200.0
2016-06-09	ACWV	ETF	75.19	75.53	75.19	75.48	294800.0
2016-06-09	ACWX	ETF	40.7	40.76	40.55	40.68	511039.0
2016-06-09	ADRE	ETF	31.28	31.28	30.95	31.0396	11064.0
2016-06-09	AFK	ETF	21.15	21.46	20.75	20.9	27706.0
2016-06-09	AFTY	ETF	12.55	12.55	12.501	12.501	1400.0
2016-06-09	AGG	ETF	111.5	111.5	111.36	111.37	1543600.0
2016-06-09	AGGY	ETF	51.22	51.44	51.21	51.271	9400.0
2016-06-09	AGQ	ETF	39.7	40.81	39.58	40.72	296600.0
2016-06-09	AGZ	ETF	115.15	115.2399	114.7701	115.11	22710.0
2016-06-09	AGZD	ETF	23.935	23.94	23.905	23.94	6400.0
2016-06-09	AIA	ETF	44.39	44.54	44.39	44.54	19609.0
2016-06-09	AIQ	ETF	6.55	6.6	6.36	6.5	56247.0
2016-06-09	AIRR	ETF	18.75	18.78	18.7	18.779	3700.0
2016-06-09	AIVI	ETF	39.08	39.13	38.9	39.05	90000.0
2016-06-09	ALTY	ETF	14.9	14.93	14.835	14.93	1800.0
2016-06-09	AMJ	ETF	31.32	31.75	31.32	31.7	1021812.0
2016-06-09	AMLP	ETF	63.2	64.0	63.0	63.95	1189940.0
2016-06-09	AMZA	ETF	114.9	116.8	114.0	116.4	8920.0
2016-06-09	ANGL	ETF	27.48	27.53	27.39	27.44	78700.0
2016-06-09	AOA	ETF	46.36	46.46	46.28	46.44	29800.0
2016-06-09	AOK	ETF	32.77	32.878	32.74	32.8	50930.0
2016-06-09	AOM	ETF	35.47	35.48	35.2844	35.4	104625.0
2016-06-09	AOR	ETF	40.26	40.31	40.18	40.29	50682.0
2016-06-09	ARGT	ETF	22.03	22.13	21.84	22.07	31100.0
2016-06-09	ARKG	ETF	18.2	18.2	17.737	17.737	500.0
2016-06-09	ARKK	ETF	19.65	19.71	19.63	19.63	5300.0
2016-06-09	ARKQ	ETF	19.63	19.67	19.63	19.67	500.0
2016-06-09	ARKW	ETF	22.28	22.37	22.28	22.32	2900.0
2016-06-09	ASEA	ETF	13.35	13.35	13.32	13.34	3600.0
2016-06-09	ASET	ETF	26.56	26.56	26.56	26.56	452.0
2016-06-09	ASHR	ETF	23.8	23.83	23.61	23.82	736000.0
2016-06-09	ASHS	ETF	33.71	33.71	33.54	33.65	8700.0
2016-06-09	ATMP	ETF	21.84	22.0	21.71	22.0	34500.0
2016-06-09	BAB	ETF	31.12	31.12	30.99	31.01	120100.0
2016-06-09	BAL	ETF	43.19	43.52	43.0	43.3683	25996.0
2016-06-09	BBC	ETF	20.75	20.7715	20.3101	20.36	17239.0
2016-06-09	BBH	ETF	108.74	109.55	107.57	107.58	59200.0
2016-06-09	BBP	ETF	28.09	28.09	27.64	27.7	6000.0
2016-06-09	BCM	ETF	27.795	27.85	27.785	27.85	3755.0
2016-06-09	BFOR	ETF	7.7825	7.795	7.7725	7.79	18400.0

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

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