PREVIEW / etf_daily / 2016-07-28

all etf daily files

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

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-07-28	SPY	ETF	216.29	217.11	215.75	216.77	65035700.0
2016-07-28	QQQ	ETF	114.76	115.11	114.4	114.98	16939662.0
2016-07-28	IWM	ETF	120.88	121.24	120.53	120.83	16540100.0
2016-07-28	DIA	ETF	184.28	184.66	183.52	184.38	2906300.0
2016-07-28	GLD	ETF	128.09	128.2	127.21	127.66	9261800.0
2016-07-28	TLT	ETF	139.8	140.84	139.71	140.39	7336100.0
2016-07-28	AADR	ETF	40.9	41.0	40.69	40.69	1500.0
2016-07-28	AAXJ	ETF	57.59	57.62	57.35	57.56	504700.0
2016-07-28	ACTX	ETF	3.54	3.54	2.95	3.54	1091.0
2016-07-28	ACWF	ETF	23.78	23.78	23.71	23.78	500.0
2016-07-28	ACWI	ETF	58.0	58.09	57.77	58.02	1370500.0
2016-07-28	ACWV	ETF	77.24	77.49	77.05	77.41	85300.0
2016-07-28	ACWX	ETF	40.18	40.25	40.01	40.2	321137.0
2016-07-28	ADRE	ETF	33.0	33.0	32.681	32.824	8705.0
2016-07-28	AFK	ETF	20.3	20.6	20.22	20.4299	4815.0
2016-07-28	AFTY	ETF	13.06	13.11	13.06	13.1	9300.0
2016-07-28	AGG	ETF	112.64	112.76	112.56	112.72	2640600.0
2016-07-28	AGGY	ETF	52.02	52.16	51.985	52.08	19500.0
2016-07-28	AGQ	ETF	54.98	55.2	53.85	54.51	305800.0
2016-07-28	AGZ	ETF	115.55	115.81	115.44	115.62	7836.0
2016-07-28	AGZD	ETF	23.84	23.84	23.84	23.84	400.0
2016-07-28	AIA	ETF	47.13	47.13	46.98	47.09	16960.0
2016-07-28	AIQ	ETF	5.96	6.05	5.85	5.97	23273.0
2016-07-28	AIRR	ETF	19.33	19.44	19.32	19.44	5200.0
2016-07-28	AIVI	ETF	38.75	38.75	38.44	38.65	17200.0
2016-07-28	AMJ	ETF	31.71	31.73	31.3741	31.55	1500177.0
2016-07-28	AMLP	ETF	63.5	63.8	63.25	63.55	733520.0
2016-07-28	AMZA	ETF	111.5	112.2	111.27	111.77	4170.0
2016-07-28	ANGL	ETF	28.2	28.21	28.15	28.18	84800.0
2016-07-28	AOA	ETF	46.95	46.95	46.58	46.82	21100.0
2016-07-28	AOK	ETF	33.08	33.289	33.08	33.22	73670.0
2016-07-28	AOM	ETF	35.8	35.81	35.611	35.73	58515.0
2016-07-28	AOR	ETF	40.54	40.691	40.471	40.69	89089.0
2016-07-28	ARGT	ETF	22.4	22.4	22.18	22.32	32500.0
2016-07-28	ARKG	ETF	18.9	18.945	18.9	18.945	600.0
2016-07-28	ARKK	ETF	20.7	20.7	20.7	20.7	200.0
2016-07-28	ARKQ	ETF	20.61	20.61	20.61	20.61	100.0
2016-07-28	ARKW	ETF	24.085	24.14	23.985	24.123	1200.0
2016-07-28	ASEA	ETF	13.88	13.97	13.88	13.96	2100.0
2016-07-28	ASET	ETF	27.2	27.2	27.2	27.2	100.0
2016-07-28	ASHR	ETF	24.23	24.35	24.23	24.33	375700.0
2016-07-28	ASHS	ETF	34.38	34.47	34.31	34.32	14800.0
2016-07-28	ATMP	ETF	22.23	22.36	22.07	22.3	66800.0
2016-07-28	BAB	ETF	31.66	31.75	31.6301	31.71	146934.0
2016-07-28	BAL	ETF	48.18	48.669	48.0513	48.669	10213.0
2016-07-28	BBC	ETF	20.001	20.0024	19.801	20.0024	3541.0
2016-07-28	BBH	ETF	113.99	114.4	112.85	114.13	97600.0
2016-07-28	BBP	ETF	30.5	30.7	30.382	30.64	7500.0
2016-07-28	BCM	ETF	25.98	25.98	25.57	25.62	25416.0
2016-07-28	BFIT	ETF	15.785	15.785	15.785	15.785	113.0

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

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