PREVIEW / etf_daily / 2016-01-28

all etf daily files

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

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-28	SPY	ETF	189.96	190.2	187.16	189.11	143798800.0
2016-01-28	QQQ	ETF	102.19	102.29	100.26	102.0	47641532.0
2016-01-28	IWM	ETF	100.55	100.95	99.22	99.69	41951100.0
2016-01-28	DIA	ETF	160.68	160.9	158.47	160.51	8613400.0
2016-01-28	GLD	ETF	106.55	106.86	106.48	106.54	5914200.0
2016-01-28	TLT	ETF	125.54	126.41	125.46	126.23	10575400.0
2016-01-28	AADR	ETF	35.75	35.76	35.46	35.76	800.0
2016-01-28	AAXJ	ETF	48.63	48.83	48.12	48.37	1727600.0
2016-01-28	ACTX	ETF	5.9591	6.4901	5.605	6.4311	598.0
2016-01-28	ACWF	ETF	21.14	21.14	21.13	21.13	1099.0
2016-01-28	ACWI	ETF	52.03	52.06	51.26	51.75	2022000.0
2016-01-28	ACWV	ETF	67.07	67.07	66.41	66.83	360800.0
2016-01-28	ACWX	ETF	36.82	36.91	36.34	36.63	2202761.0
2016-01-28	ADRE	ETF	26.66	26.6999	26.174	26.2	4740.0
2016-01-28	AFK	ETF	15.94	16.17	15.865	16.12	27861.0
2016-01-28	AFTY	ETF	11.48	11.49	11.408	11.408	6900.0
2016-01-28	AGG	ETF	108.99	109.1	108.82	109.03	2390600.0
2016-01-28	AGGY	ETF	49.45	49.563	49.392	49.563	22500.0
2016-01-28	AGQ	ETF	28.39	28.64	28.32	28.5	286000.0
2016-01-28	AGZ	ETF	113.75	114.02	113.5901	113.74	23416.0
2016-01-28	AGZD	ETF	23.64	23.64	23.64	23.64	600.0
2016-01-28	AIA	ETF	38.23	38.24	37.8399	38.0	23650.0
2016-01-28	AIQ	ETF	7.23	7.34	6.99	7.0	6560.0
2016-01-28	AIRR	ETF	14.21	14.68	14.21	14.56	11300.0
2016-01-28	AIVI	ETF	36.69	36.69	36.09	36.41	19400.0
2016-01-28	AMJ	ETF	25.26	26.18	24.84	25.39	5233544.0
2016-01-28	AMLP	ETF	53.25	53.25	50.2	51.45	6943620.0
2016-01-28	AMUB	ETF	16.04	16.07	15.9	15.9	700.0
2016-01-28	AMZA	ETF	86.9	89.89	84.9	87.3	19410.0
2016-01-28	ANGL	ETF	23.95	23.95	23.75	23.86	24500.0
2016-01-28	AOA	ETF	42.29	42.37	41.93	42.24	269500.0
2016-01-28	AOK	ETF	30.9944	31.0799	30.945	31.02	25719.0
2016-01-28	AOM	ETF	33.09	33.2	33.02	33.16	251319.0
2016-01-28	AOR	ETF	37.26	37.2958	36.9999	37.16	307688.0
2016-01-28	ARGT	ETF	16.77	16.87	16.7	16.76	7400.0
2016-01-28	ARKG	ETF	17.08	17.08	16.52	16.52	800.0
2016-01-28	ARKK	ETF	16.48	16.48	16.48	16.48	200.0
2016-01-28	ARKQ	ETF	15.89	15.909	15.83	15.83	600.0
2016-01-28	ARKW	ETF	18.762	18.762	18.644	18.644	300.0
2016-01-28	ASEA	ETF	11.69	11.69	11.62	11.65	9100.0
2016-01-28	ASHR	ETF	21.45	21.51	21.14	21.28	2056400.0
2016-01-28	ASHS	ETF	28.89	28.95	28.58	28.75	57100.0
2016-01-28	ATMP	ETF	17.1	17.1	16.56	16.79	109000.0
2016-01-28	BAB	ETF	29.62	29.72	29.601	29.69	242974.0
2016-01-28	BAL	ETF	40.39	40.73	40.39	40.64	11754.0
2016-01-28	BBC	ETF	19.7501	19.7878	18.74	18.75	16584.0
2016-01-28	BBH	ETF	105.1	105.1	99.29	100.9	195100.0
2016-01-28	BBP	ETF	24.67	24.67	23.58	23.59	8700.0
2016-01-28	BCM	ETF	23.18	23.18	23.04	23.08	1806.0
2016-01-28	BFOR	ETF	6.805	6.805	6.74	6.7525	65600.0

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

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