PREVIEW / etf_daily / 2016-01-19

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-19.parquet
  size:    50 KB
  rows:    1,246

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-01-19	SPY	ETF	189.96	190.11	186.2	188.06	195244400.0
2016-01-19	QQQ	ETF	102.2	102.37	99.88	101.06	56563845.0
2016-01-19	IWM	ETF	101.07	101.2	97.74	98.77	51391100.0
2016-01-19	DIA	ETF	161.45	161.62	158.81	160.02	10233800.0
2016-01-19	GLD	ETF	104.06	104.45	103.65	103.98	4588400.0
2016-01-19	TLT	ETF	125.13	126.07	124.95	125.36	8926600.0
2016-01-19	AADR	ETF	35.08	35.29	34.99	35.02	10000.0
2016-01-19	AAXJ	ETF	48.67	48.76	47.93	48.28	762100.0
2016-01-19	ACTX	ETF	7.6701	7.6701	6.4901	6.4901	557.0
2016-01-19	ACWF	ETF	21.29	21.29	21.12	21.13	964.0
2016-01-19	ACWI	ETF	51.44	51.57	50.62	51.08	4676000.0
2016-01-19	ACWV	ETF	66.28	66.28	65.53	65.93	174500.0
2016-01-19	ACWX	ETF	36.26	36.285	35.71	35.97	2969577.0
2016-01-19	ADRE	ETF	26.33	26.474	25.992	26.1	8415.0
2016-01-19	AFK	ETF	15.34	15.344	14.94	15.15	174016.0
2016-01-19	AFTY	ETF	12.62	12.62	12.53	12.57	16700.0
2016-01-19	AGG	ETF	108.85	108.96	108.72	108.82	4209800.0
2016-01-19	AGGY	ETF	49.355	49.356	49.27	49.27	1100.0
2016-01-19	AGQ	ETF	28.21	28.25	27.76	27.98	177100.0
2016-01-19	AGZ	ETF	113.78	113.8599	113.4201	113.73	51263.0
2016-01-19	AGZD	ETF	23.795	23.83	23.765	23.81	10000.0
2016-01-19	AIA	ETF	38.58	38.58	37.86	38.14	298161.0
2016-01-19	AIQ	ETF	6.84	7.0	6.6293	6.86	27398.0
2016-01-19	AIRR	ETF	14.82	14.82	14.206	14.41	3900.0
2016-01-19	AIVI	ETF	35.39	35.39	34.91	35.19	29100.0
2016-01-19	ALTY	ETF	12.59	12.59	12.59	12.59	100.0
2016-01-19	AMJ	ETF	24.17	24.42	22.15	22.67	10211502.0
2016-01-19	AMLP	ETF	49.5	49.75	45.0	46.15	4996800.0
2016-01-19	AMZA	ETF	84.1	84.1	70.5	73.3	6140.0
2016-01-19	ANGL	ETF	23.84	23.84	23.65	23.74	720900.0
2016-01-19	AOA	ETF	42.24	42.24	41.56	41.86	543400.0
2016-01-19	AOK	ETF	31.0	31.0	30.7748	30.9	488449.0
2016-01-19	AOM	ETF	33.14	33.14	32.8501	32.96	645196.0
2016-01-19	AOR	ETF	37.1	37.1	36.7	36.91	1551647.0
2016-01-19	ARGT	ETF	16.12	16.17	15.78	15.93	49200.0
2016-01-19	ARKG	ETF	18.0	18.0	17.604	17.605	1100.0
2016-01-19	ARKK	ETF	17.45	17.5	17.45	17.5	800.0
2016-01-19	ARKQ	ETF	16.75	16.75	16.455	16.455	400.0
2016-01-19	ARKW	ETF	20.15	20.15	19.06	19.062	5100.0
2016-01-19	ASEA	ETF	11.36	11.36	11.29	11.29	1000.0
2016-01-19	ASET	ETF	22.82	22.82	22.6209	22.71	4545.0
2016-01-19	ASHR	ETF	23.73	23.92	23.51	23.83	4228500.0
2016-01-19	ASHS	ETF	32.21	33.4	32.21	33.05	149900.0
2016-01-19	ASHX	ETF	21.18	21.5375	21.18	21.486	888.0
2016-01-19	ATMP	ETF	15.84	15.84	14.53	14.91	110100.0
2016-01-19	BAB	ETF	29.63	29.78	29.61	29.67	306710.0
2016-01-19	BAL	ETF	41.02	41.49	40.9442	41.49	4055.0
2016-01-19	BBC	ETF	21.61	21.61	19.6501	20.02	23559.0
2016-01-19	BBH	ETF	110.44	110.82	105.4	107.05	175800.0
2016-01-19	BBP	ETF	25.54	25.54	23.69	24.16	13400.0

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

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