PREVIEW / etf_daily / 2016-06-23

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-23.parquet
  size:    50 KB
  rows:    1,262

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-23	SPY	ETF	209.81	210.87	209.27	210.81	102731400.0
2016-06-23	QQQ	ETF	108.09	108.79	107.62	108.77	18714227.0
2016-06-23	IWM	ETF	115.82	116.91	115.73	116.82	30240300.0
2016-06-23	DIA	ETF	179.02	179.83	178.67	179.81	2949100.0
2016-06-23	GLD	ETF	120.49	121.03	120.06	120.11	10704900.0
2016-06-23	TLT	ETF	132.61	133.32	132.08	132.23	9029100.0
2016-06-23	AADR	ETF	39.17	39.59	39.17	39.44	1300.0
2016-06-23	AAXJ	ETF	54.56	55.08	54.44	55.05	1001100.0
2016-06-23	ACTX	ETF	4.13	4.13	3.54	3.54	380.0
2016-06-23	ACWF	ETF	23.34	23.41	23.34	23.41	6500.0
2016-06-23	ACWI	ETF	57.01	57.41	56.84	57.39	1142900.0
2016-06-23	ACWV	ETF	74.81	75.0	74.56	75.0	117300.0
2016-06-23	ACWX	ETF	40.21	40.6	40.05	40.57	429968.0
2016-06-23	ADRE	ETF	30.97	31.0968	30.97	31.05	6023.0
2016-06-23	AFK	ETF	20.16	20.54	19.9844	20.54	42167.0
2016-06-23	AFTY	ETF	12.435	12.435	12.435	12.435	100.0
2016-06-23	AGG	ETF	111.33	111.43	111.25	111.28	1721100.0
2016-06-23	AGGY	ETF	51.15	51.15	51.03	51.09	3100.0
2016-06-23	AGQ	ETF	40.51	40.91	40.5	40.73	60800.0
2016-06-23	AGZ	ETF	115.0	115.2199	114.9601	115.01	8632.0
2016-06-23	AGZD	ETF	23.94	23.94	23.835	23.835	600.0
2016-06-23	AIA	ETF	44.5	44.88	44.5	44.88	18249.0
2016-06-23	AIQ	ETF	6.29	6.39	6.15	6.19	23617.0
2016-06-23	AIRR	ETF	18.645	18.85	18.645	18.8	12900.0
2016-06-23	AIVI	ETF	39.0	39.24	38.6	39.14	137400.0
2016-06-23	ALTY	ETF	15.07	15.16	14.982	15.109	18900.0
2016-06-23	AMJ	ETF	31.98	32.26	31.59	32.25	2996115.0
2016-06-23	AMLP	ETF	64.6	64.65	63.6	64.55	1383580.0
2016-06-23	AMZA	ETF	115.9	117.1	114.1	117.1	13120.0
2016-06-23	ANGL	ETF	27.67	27.75	27.54	27.65	77200.0
2016-06-23	AOA	ETF	46.37	46.65	46.2	46.65	19400.0
2016-06-23	AOK	ETF	32.83	32.83	32.69	32.83	39549.0
2016-06-23	AOM	ETF	35.47	35.49	35.2925	35.49	102344.0
2016-06-23	AOR	ETF	40.25	40.39	40.15	40.39	62947.0
2016-06-23	ARGT	ETF	22.43	22.56	22.28	22.34	54900.0
2016-06-23	ARKG	ETF	17.59	17.59	17.2	17.267	1800.0
2016-06-23	ARKK	ETF	19.47	19.68	19.47	19.62	6800.0
2016-06-23	ARKQ	ETF	19.64	19.87	19.64	19.87	5600.0
2016-06-23	ARKW	ETF	22.53	22.53	22.53	22.53	500.0
2016-06-23	ASEA	ETF	13.35	13.51	13.35	13.5	5100.0
2016-06-23	ASHR	ETF	23.59	23.79	23.55	23.78	933600.0
2016-06-23	ASHS	ETF	33.5	33.78	33.38	33.66	38000.0
2016-06-23	ATMP	ETF	22.28	22.38	22.23	22.38	5600.0
2016-06-23	BAB	ETF	30.84	30.864	30.68	30.75	121757.0
2016-06-23	BAL	ETF	43.4992	43.5602	43.1888	43.3316	4119.0
2016-06-23	BBC	ETF	18.43	18.8199	18.43	18.8199	9342.0
2016-06-23	BBH	ETF	102.69	103.75	102.12	103.66	42800.0
2016-06-23	BBP	ETF	26.88	26.88	26.875	26.88	1000.0
2016-06-23	BCM	ETF	27.3655	27.4499	27.365	27.366	4553.0
2016-06-23	BFOR	ETF	7.6075	7.72	7.6075	7.72	40000.0

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

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