PREVIEW / etf_daily / 2016-07-26

all etf daily files

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

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-26	SPY	ETF	216.53	217.17	215.76	216.75	70080500.0
2016-07-26	QQQ	ETF	113.63	114.2	113.22	113.79	21223845.0
2016-07-26	IWM	ETF	120.2	120.97	119.92	120.8	19551100.0
2016-07-26	DIA	ETF	184.61	185.02	183.7	184.6	4744400.0
2016-07-26	GLD	ETF	126.09	126.14	125.75	126.0	7613200.0
2016-07-26	TLT	ETF	139.52	139.52	138.46	138.92	5243400.0
2016-07-26	AADR	ETF	40.9	40.95	40.9	40.95	300.0
2016-07-26	AAXJ	ETF	57.2	57.47	57.15	57.38	427500.0
2016-07-26	ACTX	ETF	2.95	3.54	2.95	3.54	694.0
2016-07-26	ACWI	ETF	57.94	58.08	57.72	57.91	1013000.0
2016-07-26	ACWV	ETF	77.69	77.89	77.44	77.61	369400.0
2016-07-26	ACWX	ETF	40.02	40.18	39.935	40.09	286939.0
2016-07-26	ADRE	ETF	32.85	33.06	32.85	33.04	7231.0
2016-07-26	AFK	ETF	19.93	20.09	19.88	20.03	21307.0
2016-07-26	AFTY	ETF	13.07	13.14	13.07	13.14	3000.0
2016-07-26	AGG	ETF	112.58	112.58	112.31	112.4	3540000.0
2016-07-26	AGGY	ETF	51.97	51.97	51.84	51.884	3400.0
2016-07-26	AGQ	ETF	51.73	51.78	51.32	51.56	310400.0
2016-07-26	AGZ	ETF	115.67	115.7249	115.39	115.45	72170.0
2016-07-26	AGZD	ETF	23.83	23.83	23.83	23.83	1600.0
2016-07-26	AIA	ETF	47.19	47.21	46.96	47.17	24259.0
2016-07-26	AIQ	ETF	5.9	6.08	5.85	6.02	29388.0
2016-07-26	AIRR	ETF	19.315	19.37	19.23	19.37	3300.0
2016-07-26	AIVI	ETF	38.42	38.48	38.2	38.47	14500.0
2016-07-26	ALTY	ETF	15.6	15.6	15.6	15.6	500.0
2016-07-26	AMJ	ETF	32.05	32.17	31.69	31.82	2174724.0
2016-07-26	AMLP	ETF	64.0	64.5	63.75	63.8	1016340.0
2016-07-26	AMZA	ETF	112.0	113.2	111.9	112.19	5900.0
2016-07-26	ANGL	ETF	28.29	28.29	28.17	28.17	208600.0
2016-07-26	AOA	ETF	46.73	46.76	46.5	46.69	39500.0
2016-07-26	AOK	ETF	33.13	33.1999	33.06	33.06	41234.0
2016-07-26	AOM	ETF	35.62	35.73	35.5501	35.61	55772.0
2016-07-26	AOR	ETF	40.46	40.63	40.43	40.54	54057.0
2016-07-26	ARGT	ETF	22.55	22.63	22.37	22.52	7400.0
2016-07-26	ARKG	ETF	18.4	18.4	18.4	18.4	100.0
2016-07-26	ARKK	ETF	20.34	20.34	20.34	20.34	100.0
2016-07-26	ARKQ	ETF	20.58	20.58	20.58	20.58	200.0
2016-07-26	ARKW	ETF	23.93	24.06	23.81	24.008	3300.0
2016-07-26	ASEA	ETF	13.88	13.88	13.83	13.87	900.0
2016-07-26	ASHR	ETF	24.67	24.78	24.6	24.72	1300000.0
2016-07-26	ASHS	ETF	35.71	35.8	35.71	35.76	16500.0
2016-07-26	ATMP	ETF	22.5	22.55	22.45	22.49	30700.0
2016-07-26	BAB	ETF	31.58	31.5899	31.47	31.56	111354.0
2016-07-26	BAL	ETF	48.6122	49.51	48.612	49.47	25570.0
2016-07-26	BBC	ETF	19.23	19.509	19.23	19.455	14986.0
2016-07-26	BBH	ETF	111.3	112.01	110.74	111.31	73300.0
2016-07-26	BBP	ETF	29.65	30.159	29.54	29.864	8600.0
2016-07-26	BCM	ETF	25.83	25.91	25.83	25.888	2065.0
2016-07-26	BFOR	ETF	7.9925	8.0075	7.9825	8.0075	76800.0
2016-07-26	BIB	ETF	45.62	46.53	45.24	45.85	678825.0

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

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