PREVIEW / etf_daily / 2016-06-17

all etf daily files

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

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-17	SPY	ETF	207.17	207.2	205.75	206.52	117055700.0
2016-06-17	QQQ	ETF	107.53	107.6819	106.24	106.49	29208832.0
2016-06-17	IWM	ETF	114.41	114.92	113.68	114.06	30096400.0
2016-06-17	DIA	ETF	177.15	177.15	175.77	176.52	2748000.0
2016-06-17	GLD	ETF	123.26	124.1	122.69	123.95	15573800.0
2016-06-17	TLT	ETF	136.2	136.27	135.26	135.61	8489900.0
2016-06-17	AADR	ETF	37.24	37.73	37.24	37.73	700.0
2016-06-17	AAXJ	ETF	53.12	53.17	52.73	53.06	643100.0
2016-06-17	ACTX	ETF	4.13	4.13	3.54	3.54	570.0
2016-06-17	ACWI	ETF	56.08	56.21	55.74	56.09	2178700.0
2016-06-17	ACWV	ETF	74.37	74.37	73.78	74.18	403500.0
2016-06-17	ACWX	ETF	38.87	39.17	38.74	39.09	1346554.0
2016-06-17	ADRE	ETF	29.99	30.0199	29.79	29.885	3628.0
2016-06-17	AFK	ETF	19.5757	19.9499	19.5757	19.9499	8095.0
2016-06-17	AFTY	ETF	12.36	12.36	12.34	12.349	900.0
2016-06-17	AGG	ETF	111.86	111.87	111.66	111.79	2730900.0
2016-06-17	AGGY	ETF	51.262	51.38	51.25	51.38	3200.0
2016-06-17	AGNG	ETF	15.3	15.3	15.3	15.3	200.0
2016-06-17	AGQ	ETF	41.16	41.43	40.35	41.39	216500.0
2016-06-17	AGZ	ETF	115.43	115.6199	115.354	115.48	6983.0
2016-06-17	AGZD	ETF	23.895	23.895	23.865	23.865	800.0
2016-06-17	AIA	ETF	42.94	43.05	42.84	43.0104	15943.0
2016-06-17	AIQ	ETF	6.31	6.5	6.23	6.28	46654.0
2016-06-17	AIRR	ETF	18.293	18.31	18.17	18.17	1400.0
2016-06-17	AIVI	ETF	37.42	37.79	37.33	37.79	12500.0
2016-06-17	AMJ	ETF	30.85	30.91	30.51	30.77	5915435.0
2016-06-17	AMLP	ETF	62.55	62.95	62.05	62.45	2907240.0
2016-06-17	AMZA	ETF	111.4	113.6	110.4	111.3	9210.0
2016-06-17	ANGL	ETF	27.15	27.27	27.13	27.16	89200.0
2016-06-17	AOA	ETF	45.31	45.41	45.07	45.28	17200.0
2016-06-17	AOK	ETF	32.62	32.62	32.4701	32.57	31415.0
2016-06-17	AOM	ETF	35.09	35.09	34.8501	35.01	191186.0
2016-06-17	AOR	ETF	39.68	39.68	39.4305	39.57	48909.0
2016-06-17	ARGT	ETF	21.62	21.97	21.62	21.96	41500.0
2016-06-17	ARKG	ETF	16.87	16.87	16.87	16.87	100.0
2016-06-17	ARKK	ETF	19.5	19.57	19.5	19.57	1500.0
2016-06-17	ARKQ	ETF	19.501	19.501	19.501	19.501	100.0
2016-06-17	ARKW	ETF	22.43	22.47	22.32	22.38	700.0
2016-06-17	ASEA	ETF	12.99	13.03	12.94	12.99	700.0
2016-06-17	ASET	ETF	25.99	26.025	25.95	25.95	415.0
2016-06-17	ASHR	ETF	23.28	23.46	23.24	23.43	1154000.0
2016-06-17	ASHS	ETF	33.04	33.07	32.92	33.05	37400.0
2016-06-17	ATMP	ETF	21.5	21.5	21.31	21.33	16500.0
2016-06-17	BAB	ETF	31.14	31.244	31.051	31.07	106273.0
2016-06-17	BAL	ETF	43.96	44.102	43.6	43.67	6128.0
2016-06-17	BBC	ETF	19.1	19.242	18.3928	18.3928	7462.0
2016-06-17	BBH	ETF	103.59	103.59	101.48	101.51	72200.0
2016-06-17	BBP	ETF	26.98	26.98	26.28	26.28	12100.0
2016-06-17	BCM	ETF	27.136	27.425	27.136	27.415	11042.0
2016-06-17	BFOR	ETF	7.53	7.5675	7.52	7.525	20000.0

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

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