PREVIEW / etf_daily / 2016-12-16

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-16.parquet
  size:    54 KB
  rows:    1,359

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-16	SPY	ETF	226.01	226.08	224.67	225.04	156420200.0
2016-12-16	QQQ	ETF	120.28	120.5817	119.36	119.6	26283907.0
2016-12-16	IWM	ETF	136.35	137.53	135.63	135.91	39348200.0
2016-12-16	DIA	ETF	198.7	198.97	197.94	198.19	4467700.0
2016-12-16	GLD	ETF	107.95	108.78	107.48	108.05	10602800.0
2016-12-16	TLT	ETF	117.61	117.92	116.8	117.14	14924600.0
2016-12-16	AADR	ETF	41.12	41.12	39.65	39.66	8300.0
2016-12-16	AAXJ	ETF	55.99	56.08	55.68	55.87	1437200.0
2016-12-16	ACSI	ETF	27.43	27.43	27.31	27.31	6675.0
2016-12-16	ACTX	ETF	20.6502	21.2402	18.1132	18.1132	711.0
2016-12-16	ACWI	ETF	60.02	60.06	59.78	59.84	4728800.0
2016-12-16	ACWV	ETF	73.29	73.41	73.15	73.34	774900.0
2016-12-16	ACWX	ETF	40.52	40.66	40.47	40.52	1124161.0
2016-12-16	ADRE	ETF	32.69	32.69	32.23	32.25	9793.0
2016-12-16	AFK	ETF	19.75	19.75	19.3001	19.7	12910.0
2016-12-16	AFTY	ETF	13.32	13.32	13.12	13.12	2000.0
2016-12-16	AGG	ETF	107.16	107.39	107.06	107.23	2981600.0
2016-12-16	AGGY	ETF	49.2	49.212	49.01	49.13	25400.0
2016-12-16	AGQ	ETF	32.71	33.52	32.32	32.91	254300.0
2016-12-16	AGZ	ETF	112.0	112.078	111.87	111.95	18082.0
2016-12-16	AGZD	ETF	24.125	24.125	24.015	24.035	5800.0
2016-12-16	AIA	ETF	47.47	47.51	47.23	47.3	12651.0
2016-12-16	AIQ	ETF	9.55	9.6739	9.4501	9.55	25805.0
2016-12-16	AIRR	ETF	24.2	24.2	23.8	23.83	76100.0
2016-12-16	AIVI	ETF	37.48	37.63	37.43	37.51	43900.0
2016-12-16	ALTY	ETF	14.858	14.95	14.858	14.87	2600.0
2016-12-16	AMJ	ETF	30.09	30.58	30.09	30.48	2064170.0
2016-12-16	AMLP	ETF	61.05	62.05	61.05	62.05	1582800.0
2016-12-16	AMZA	ETF	108.9	109.9	108.18	109.9	17170.0
2016-12-16	ANGL	ETF	28.93	28.93	28.86	28.88	104700.0
2016-12-16	AOA	ETF	47.73	47.73	47.45	47.55	208800.0
2016-12-16	AOK	ETF	32.46	32.549	32.42	32.42	191260.0
2016-12-16	AOM	ETF	35.36	35.37	35.23	35.28	520228.0
2016-12-16	AOR	ETF	40.8	40.8	40.61	40.68	633632.0
2016-12-16	ARGT	ETF	22.84	22.84	22.52	22.59	11700.0
2016-12-16	ARKG	ETF	18.146	18.146	18.055	18.055	900.0
2016-12-16	ARKK	ETF	20.9	20.99	20.779	20.83	2800.0
2016-12-16	ARKQ	ETF	22.38	22.42	22.324	22.35	2700.0
2016-12-16	ARKW	ETF	25.65	25.65	25.62	25.62	700.0
2016-12-16	ASEA	ETF	13.07	13.08	13.07	13.07	800.0
2016-12-16	ASHR	ETF	24.05	24.09	23.95	23.95	2020800.0
2016-12-16	ASHS	ETF	32.68	32.81	32.6	32.61	13500.0
2016-12-16	ATMP	ETF	22.71	22.97	22.64	22.97	72300.0
2016-12-16	BAB	ETF	28.81	28.94	28.7701	28.83	205093.0
2016-12-16	BAL	ETF	46.88	46.88	46.6484	46.699	11221.0
2016-12-16	BBC	ETF	19.07	19.36	19.07	19.15	105552.0
2016-12-16	BBH	ETF	109.88	110.48	108.84	109.04	92100.0
2016-12-16	BBP	ETF	33.96	34.47	33.96	34.093	41900.0
2016-12-16	BCM	ETF	27.14	27.28	27.14	27.26	572.0
2016-12-16	BFOR	ETF	8.8925	8.945	8.805	8.8475	72000.0

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

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