PREVIEW / etf_daily / 2016-06-07

all etf daily files

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

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-07	SPY	ETF	211.53	212.34	211.5	211.68	60974800.0
2016-06-07	QQQ	ETF	110.53	110.63	110.13	110.18	12184296.0
2016-06-07	IWM	ETF	117.29	117.98	116.96	117.56	21038500.0
2016-06-07	DIA	ETF	179.46	179.99	179.34	179.38	1572300.0
2016-06-07	GLD	ETF	118.5	119.02	118.41	118.82	4602900.0
2016-06-07	TLT	ETF	132.64	132.98	132.54	132.56	4680200.0
2016-06-07	AADR	ETF	39.07	39.07	39.07	39.07	300.0
2016-06-07	AAXJ	ETF	55.01	55.21	55.01	55.11	593300.0
2016-06-07	ACTX	ETF	4.72	4.72	4.13	4.13	442.0
2016-06-07	ACWF	ETF	23.62	23.645	23.61	23.6262	9677.0
2016-06-07	ACWI	ETF	57.86	58.08	57.86	57.92	1449800.0
2016-06-07	ACWV	ETF	75.14	75.31	75.1	75.17	163700.0
2016-06-07	ACWX	ETF	40.99	41.12	40.9899	41.03	1225007.0
2016-06-07	ADRE	ETF	30.95	31.2375	30.95	31.181	2498.0
2016-06-07	AFK	ETF	20.92	21.25	20.7521	21.04	54036.0
2016-06-07	AFTY	ETF	12.63	12.71	12.63	12.63	3500.0
2016-06-07	AGG	ETF	111.24	111.31	111.2	111.25	2157100.0
2016-06-07	AGGY	ETF	50.94	51.25	50.94	51.19	4400.0
2016-06-07	AGNG	ETF	15.98	15.98	15.97	15.97	1100.0
2016-06-07	AGQ	ETF	36.48	36.91	36.26	36.63	258100.0
2016-06-07	AGZ	ETF	115.27	115.27	115.11	115.12	14942.0
2016-06-07	AGZD	ETF	23.915	23.915	23.915	23.915	600.0
2016-06-07	AIA	ETF	44.49	44.71	44.49	44.59	52545.0
2016-06-07	AIQ	ETF	6.77	6.82	6.62	6.7	14738.0
2016-06-07	AIRR	ETF	18.55	18.72	18.55	18.706	5500.0
2016-06-07	AIVI	ETF	39.39	39.44	39.2	39.28	42400.0
2016-06-07	AMJ	ETF	31.99	32.06	31.81	31.93	1827856.0
2016-06-07	AMLP	ETF	64.0	64.75	64.0	64.2	1389020.0
2016-06-07	AMZA	ETF	116.7	117.9	116.7	117.3	22830.0
2016-06-07	ANGL	ETF	27.17	27.29	27.11	27.27	39900.0
2016-06-07	AOA	ETF	46.44	46.61	46.44	46.48	63600.0
2016-06-07	AOK	ETF	32.7534	32.848	32.7201	32.78	39306.0
2016-06-07	AOM	ETF	35.31	35.46	35.27	35.42	125512.0
2016-06-07	AOR	ETF	40.33	40.39	40.2416	40.3	64921.0
2016-06-07	ARGT	ETF	21.75	22.17	21.67	22.14	51600.0
2016-06-07	ARKG	ETF	18.32	18.32	18.146	18.26	4000.0
2016-06-07	ARKK	ETF	19.99	20.01	19.85	19.93	7000.0
2016-06-07	ARKQ	ETF	19.75	19.75	19.665	19.726	1300.0
2016-06-07	ARKW	ETF	22.334	22.483	22.334	22.473	1300.0
2016-06-07	ASEA	ETF	13.54	13.54	13.43	13.44	4000.0
2016-06-07	ASHR	ETF	24.15	24.18	24.08	24.08	1218500.0
2016-06-07	ASHS	ETF	33.88	33.93	33.82	33.84	19500.0
2016-06-07	ATMP	ETF	22.09	22.15	22.0	22.1	20700.0
2016-06-07	BAB	ETF	31.03	31.03	30.9	30.94	173381.0
2016-06-07	BAL	ETF	43.74	43.95	43.4769	43.7201	16519.0
2016-06-07	BBC	ETF	21.37	21.43	21.1699	21.17	3504.0
2016-06-07	BBH	ETF	110.3	111.0	109.09	109.51	71000.0
2016-06-07	BBP	ETF	28.25	28.25	28.0	28.04	4100.0
2016-06-07	BCM	ETF	27.32	27.48	27.23	27.45	14671.0
2016-06-07	BDCZ	ETF	20.499	20.499	20.43	20.43	750.0

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

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