PREVIEW / etf_daily / 2016-06-22

all etf daily files

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

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-22	SPY	ETF	208.65	209.5	207.93	208.1	95560500.0
2016-06-22	QQQ	ETF	107.58	108.19	107.15	107.24	22724174.0
2016-06-22	IWM	ETF	115.3	115.88	114.49	114.63	27226100.0
2016-06-22	DIA	ETF	178.23	178.95	177.43	177.57	2966200.0
2016-06-22	GLD	ETF	120.83	121.25	120.68	120.9	7861000.0
2016-06-22	TLT	ETF	133.5	133.99	133.25	133.76	5773700.0
2016-06-22	AAXJ	ETF	54.16	54.38	53.98	53.99	952900.0
2016-06-22	ACTX	ETF	4.13	4.13	3.54	3.54	483.0
2016-06-22	ACWF	ETF	23.0599	23.06	23.0425	23.0599	2500.0
2016-06-22	ACWI	ETF	56.58	56.77	56.32	56.35	1697000.0
2016-06-22	ACWV	ETF	74.38	74.61	74.19	74.29	205900.0
2016-06-22	ACWX	ETF	39.72	39.86	39.53	39.55	614230.0
2016-06-22	ADRE	ETF	30.66	30.87	30.6001	30.64	8248.0
2016-06-22	AFK	ETF	20.0	20.6	19.66	19.68	4290.0
2016-06-22	AFTY	ETF	12.46	12.47	12.41	12.47	1800.0
2016-06-22	AGG	ETF	111.44	111.51	111.35	111.47	1734300.0
2016-06-22	AGGY	ETF	51.16	51.16	51.053	51.053	2000.0
2016-06-22	AGQ	ETF	40.34	40.74	40.26	40.45	69300.0
2016-06-22	AGZ	ETF	115.19	115.4599	115.037	115.2326	13094.0
2016-06-22	AGZD	ETF	23.815	23.855	23.815	23.82	4400.0
2016-06-22	AIA	ETF	44.21	44.3435	44.0301	44.07	14654.0
2016-06-22	AIQ	ETF	6.24	6.47	6.1178	6.23	24612.0
2016-06-22	AIRR	ETF	18.5	18.549	18.4	18.46	2000.0
2016-06-22	AIVI	ETF	38.3	38.53	38.07	38.07	24900.0
2016-06-22	ALTY	ETF	14.87	14.89	14.799	14.87	14900.0
2016-06-22	AMJ	ETF	31.69	31.94	31.34	31.55	3947468.0
2016-06-22	AMLP	ETF	63.55	64.2	63.1	63.65	1229240.0
2016-06-22	AMZA	ETF	116.0	116.3	113.8	114.5	17200.0
2016-06-22	ANGL	ETF	27.55	27.58	27.4	27.46	60000.0
2016-06-22	AOA	ETF	46.08	46.21	45.9	45.98	47300.0
2016-06-22	AOK	ETF	32.76	32.7799	32.6101	32.67	42069.0
2016-06-22	AOM	ETF	35.34	35.34	35.14	35.25	189346.0
2016-06-22	AOR	ETF	40.11	40.1499	39.89	39.89	56896.0
2016-06-22	ARGT	ETF	22.14	22.35	22.09	22.13	78700.0
2016-06-22	ARKG	ETF	17.314	17.314	17.314	17.314	1000.0
2016-06-22	ARKK	ETF	19.438	19.438	19.438	19.438	100.0
2016-06-22	ARKQ	ETF	19.76	19.76	19.76	19.76	600.0
2016-06-22	ARKW	ETF	22.35	22.35	22.35	22.35	400.0
2016-06-22	ASEA	ETF	13.35	13.41	13.3	13.3	2400.0
2016-06-22	ASET	ETF	26.61	26.63	26.5	26.5	509.0
2016-06-22	ASHR	ETF	23.6	23.74	23.59	23.64	1139500.0
2016-06-22	ASHS	ETF	33.69	33.69	33.39	33.51	33000.0
2016-06-22	ATMP	ETF	21.92	22.19	21.91	22.19	30500.0
2016-06-22	BAB	ETF	30.96	30.96	30.86	30.93	115968.0
2016-06-22	BAL	ETF	42.69	42.98	42.48	42.7648	9086.0
2016-06-22	BBC	ETF	18.29	18.7583	18.0	18.2719	10653.0
2016-06-22	BBH	ETF	100.81	103.52	100.4	101.61	99000.0
2016-06-22	BBP	ETF	26.23	26.97	26.072	26.5	4900.0
2016-06-22	BCM	ETF	27.292	27.33	27.292	27.33	357.0
2016-06-22	BFOR	ETF	7.5925	7.64	7.5825	7.5825	30400.0

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

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