PREVIEW / etf_daily / 2016-12-23

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-23.parquet
  size:    53 KB
  rows:    1,342

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-12-23	SPY	ETF	225.43	225.72	225.21	225.71	36697800.0
2016-12-23	QQQ	ETF	119.96	120.25	119.81	120.2	9007470.0
2016-12-23	IWM	ETF	135.46	136.12	135.27	136.04	17081400.0
2016-12-23	DIA	ETF	198.96	199.06	198.73	199.05	1374200.0
2016-12-23	GLD	ETF	107.84	108.25	107.8	107.93	5012200.0
2016-12-23	TLT	ETF	118.24	118.39	117.95	118.05	4461600.0
2016-12-23	AADR	ETF	39.6	39.8	39.5	39.76	1900.0
2016-12-23	AAXJ	ETF	54.01	54.25	54.01	54.24	593300.0
2016-12-23	ACSI	ETF	27.35	27.35	27.32	27.32	4220.0
2016-12-23	ACTX	ETF	15.9301	17.7002	15.3401	15.9301	1174.0
2016-12-23	ACWI	ETF	59.31	59.38	59.26	59.36	967900.0
2016-12-23	ACWV	ETF	72.25	72.45	72.25	72.45	165000.0
2016-12-23	ACWX	ETF	39.95	40.09	39.95	40.09	989860.0
2016-12-23	ADRE	ETF	31.89	32.07	31.89	32.03	6775.0
2016-12-23	AFK	ETF	19.32	19.4702	19.06	19.13	33922.0
2016-12-23	AFTY	ETF	12.96	12.96	12.96	12.96	300.0
2016-12-23	AGG	ETF	107.54	107.54	107.39	107.42	3821100.0
2016-12-23	AGGY	ETF	49.27	49.39	49.25	49.26	12100.0
2016-12-23	AGQ	ETF	31.58	31.68	31.25	31.36	106300.0
2016-12-23	AGZ	ETF	111.96	112.285	111.96	112.19	28239.0
2016-12-23	AGZD	ETF	23.97	24.01	23.97	24.01	1800.0
2016-12-23	AIA	ETF	45.52	45.68	45.52	45.67	14959.0
2016-12-23	AIQ	ETF	9.5995	9.6	9.55	9.6	15962.0
2016-12-23	AIRR	ETF	24.1	24.144	23.94	24.07	62200.0
2016-12-23	AIVI	ETF	37.17	37.28	37.16	37.21	69700.0
2016-12-23	ALTY	ETF	15.035	15.05	15.026	15.05	1200.0
2016-12-23	AMJ	ETF	31.39	31.79	31.39	31.72	2367406.0
2016-12-23	AMLP	ETF	63.35	63.6	63.05	63.6	1040780.0
2016-12-23	AMZA	ETF	113.2	113.6	112.7	113.6	38120.0
2016-12-23	ANGL	ETF	29.02	29.07	29.0	29.06	429200.0
2016-12-23	AOA	ETF	47.61	47.66	47.49	47.65	154600.0
2016-12-23	AOK	ETF	32.54	32.6	32.52	32.58	107377.0
2016-12-23	AOM	ETF	35.43	35.43	35.32	35.42	341699.0
2016-12-23	AOR	ETF	40.82	40.82	40.6801	40.78	164834.0
2016-12-23	ARGT	ETF	22.57	22.62	22.44	22.58	10300.0
2016-12-23	ARKG	ETF	17.21	17.53	17.21	17.53	700.0
2016-12-23	ARKK	ETF	20.327	20.327	20.31	20.31	200.0
2016-12-23	ARKQ	ETF	22.39	22.39	22.39	22.39	300.0
2016-12-23	ARKW	ETF	25.17	25.19	25.14	25.16	1700.0
2016-12-23	ASEA	ETF	12.88	12.89	12.88	12.89	700.0
2016-12-23	ASHR	ETF	23.59	23.59	23.51	23.52	590800.0
2016-12-23	ASHS	ETF	32.71	32.71	32.47	32.49	2100.0
2016-12-23	ATMP	ETF	23.58	23.8	23.5	23.71	155200.0
2016-12-23	BAB	ETF	28.88	28.95	28.865	28.91	92236.0
2016-12-23	BAL	ETF	46.04	46.04	45.85	45.912	2549.0
2016-12-23	BBC	ETF	18.2	19.3201	18.2	19.32	3749.0
2016-12-23	BBH	ETF	107.2	109.35	107.2	109.25	78300.0
2016-12-23	BBP	ETF	33.303	33.963	33.303	33.963	4600.0
2016-12-23	BCM	ETF	26.8662	26.89	26.86	26.89	4181.0
2016-12-23	BFOR	ETF	8.8225	8.8325	8.815	8.83	8000.0

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

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