PREVIEW / etf_daily / 2016-11-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-14.parquet
  size:    53 KB
  rows:    1,325

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-11-14	SPY	ETF	217.03	217.27	215.72	216.59	94580000.0
2016-11-14	QQQ	ETF	115.84	115.94	114.03	114.63	35905979.0
2016-11-14	IWM	ETF	128.95	130.26	128.39	129.15	83119400.0
2016-11-14	DIA	ETF	189.11	189.39	188.2	188.77	4796400.0
2016-11-14	GLD	ETF	116.12	117.14	115.49	116.11	20729400.0
2016-11-14	TLT	ETF	121.28	122.66	120.73	121.31	21174400.0
2016-11-14	AADR	ETF	38.78	38.78	38.27	38.5	1900.0
2016-11-14	AAXJ	ETF	55.29	55.63	54.97	55.29	2079800.0
2016-11-14	ACSI	ETF	25.92	25.94	25.836	25.94	22696.0
2016-11-14	ACTX	ETF	12.9801	15.3401	12.9801	15.3401	2602.0
2016-11-14	ACWI	ETF	57.9	57.9	57.54	57.76	1586500.0
2016-11-14	ACWV	ETF	72.21	72.31	71.95	72.15	290800.0
2016-11-14	ACWX	ETF	39.53	39.56	39.37	39.53	746877.0
2016-11-14	ADRE	ETF	32.53	32.53	32.0002	32.22	11565.0
2016-11-14	AFK	ETF	18.91	19.3125	18.81	18.82	13826.0
2016-11-14	AFTY	ETF	13.61	13.61	13.61	13.61	400.0
2016-11-14	AGG	ETF	108.64	109.06	108.64	108.81	3054900.0
2016-11-14	AGGY	ETF	50.16	50.28	50.104	50.24	7000.0
2016-11-14	AGNG	ETF	15.48	15.57	15.41	15.57	500.0
2016-11-14	AGQ	ETF	37.28	37.49	35.55	36.44	411500.0
2016-11-14	AGZ	ETF	113.59	113.91	113.24	113.66	15017.0
2016-11-14	AGZD	ETF	23.94	23.965	23.94	23.965	12400.0
2016-11-14	AIA	ETF	46.52	46.67	46.31	46.47	39034.0
2016-11-14	AIQ	ETF	7.45	7.7	7.45	7.5	3938.0
2016-11-14	AIRR	ETF	22.71	22.71	22.325	22.54	453400.0
2016-11-14	AIVI	ETF	36.4	36.42	36.25	36.4	14700.0
2016-11-14	ALTY	ETF	14.05	14.478	14.05	14.379	9900.0
2016-11-14	AMJ	ETF	29.95	30.51	29.93	30.43	3018933.0
2016-11-14	AMLP	ETF	60.3	61.1	60.05	60.95	2747600.0
2016-11-14	AMZA	ETF	108.5	109.5	107.68	109.4	23860.0
2016-11-14	ANGL	ETF	27.75	28.28	27.39	28.11	817900.0
2016-11-14	AOA	ETF	46.41	46.41	46.15	46.23	53800.0
2016-11-14	AOK	ETF	32.4	32.4002	32.0501	32.34	119741.0
2016-11-14	AOM	ETF	35.1	35.1	34.8218	34.98	116591.0
2016-11-14	AOR	ETF	39.99	40.03	39.8501	39.96	125154.0
2016-11-14	ARGT	ETF	22.14	22.41	22.01	22.41	353300.0
2016-11-14	ARKG	ETF	19.112	19.41	19.01	19.41	4200.0
2016-11-14	ARKK	ETF	20.68	20.68	20.658	20.68	1400.0
2016-11-14	ARKQ	ETF	21.68	21.68	21.318	21.36	900.0
2016-11-14	ARKW	ETF	24.97	24.99	24.941	24.99	800.0
2016-11-14	ASEA	ETF	12.71	12.71	12.71	12.71	800.0
2016-11-14	ASET	ETF	24.58	24.58	24.58	24.58	200.0
2016-11-14	ASHR	ETF	25.12	25.13	25.01	25.03	490500.0
2016-11-14	ASHS	ETF	34.84	35.11	34.84	35.1	2800.0
2016-11-14	ASHX	ETF	23.46	23.47	23.46	23.47	2200.0
2016-11-14	ATMP	ETF	22.51	22.68	22.26	22.61	39600.0
2016-11-14	BAB	ETF	29.31	29.4	29.11	29.12	488208.0
2016-11-14	BAL	ETF	45.0953	45.5756	45.05	45.5429	8297.0
2016-11-14	BBC	ETF	22.23	22.26	21.4922	22.14	21120.0
2016-11-14	BBH	ETF	113.93	114.75	112.61	114.58	118700.0

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

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