PREVIEW / etf_daily / 2014-12-11

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-11.parquet
  size:    47 KB
  rows:    1,154

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
2014-12-11	SPY	ETF	203.88	206.19	203.71	204.19	159012800.0
2014-12-11	QQQ	ETF	103.61	105.04	103.59	103.8	47576022.0
2014-12-11	IWM	ETF	116.21	117.68	115.87	116.12	36021800.0
2014-12-11	DIA	ETF	175.89	177.66	175.7	176.03	6867300.0
2014-12-11	GLD	ETF	116.98	118.38	116.82	117.69	5214500.0
2014-12-11	TLT	ETF	123.74	124.61	123.29	124.61	7863500.0
2014-12-11	AADR	ETF	37.31	37.31	37.07	37.07	400.0
2014-12-11	AAXJ	ETF	60.73	61.13	60.61	60.84	1333600.0
2014-12-11	ACWI	ETF	58.75	59.31	58.69	58.78	1327400.0
2014-12-11	ACWV	ETF	69.06	69.58	69.06	69.16	63900.0
2014-12-11	ACWX	ETF	43.68	43.96	43.56	43.63	980508.0
2014-12-11	ADRE	ETF	35.7	35.9543	35.6	35.67	15705.0
2014-12-11	AFK	ETF	26.15	26.15	25.63	25.65	87480.0
2014-12-11	AGG	ETF	110.15	110.23	110.02	110.21	1447700.0
2014-12-11	AGQ	ETF	44.87	45.94	44.65	45.08	259100.0
2014-12-11	AGZ	ETF	113.2	113.3199	112.91	113.1	19584.0
2014-12-11	AGZD	ETF	24.615	24.74	24.615	24.73	15600.0
2014-12-11	AIA	ETF	46.88	47.21	46.85	46.88	47556.0
2014-12-11	AIQ	ETF	20.6	21.05	20.44	20.74	16753.0
2014-12-11	AIRR	ETF	17.76	17.93	17.45	17.45	72900.0
2014-12-11	AIVI	ETF	44.26	44.47	44.07	44.08	50700.0
2014-12-11	AMJ	ETF	44.29	45.4142	43.87	44.14	2156158.0
2014-12-11	AMLP	ETF	84.5	86.4	84.0	84.7	1268460.0
2014-12-11	AMZA	ETF	213.9	221.2	213.5	213.5	450.0
2014-12-11	ANGL	ETF	26.69	26.85	26.6	26.81	15000.0
2014-12-11	AOA	ETF	46.24	46.48	46.06	46.12	378800.0
2014-12-11	AOK	ETF	32.65	32.69	32.56	32.59	29058.0
2014-12-11	AOM	ETF	35.16	35.28	35.09	35.1101	110251.0
2014-12-11	AOR	ETF	40.01	40.25	39.93	39.96	253174.0
2014-12-11	ARGT	ETF	19.41	19.43	19.24	19.24	35600.0
2014-12-11	ARKG	ETF	20.91	20.91	20.66	20.66	2400.0
2014-12-11	ARKK	ETF	19.85	19.85	19.77	19.77	900.0
2014-12-11	ARKQ	ETF	19.63	19.63	19.536	19.54	3100.0
2014-12-11	ARKW	ETF	20.06	20.13	20.05	20.06	4800.0
2014-12-11	ASEA	ETF	16.09	16.14	16.09	16.09	11800.0
2014-12-11	ASHR	ETF	33.51	34.26	33.34	34.06	1194600.0
2014-12-11	ASHS	ETF	36.31	37.01	36.31	36.76	18900.0
2014-12-11	ATMP	ETF	29.3	29.77	29.07	29.61	44500.0
2014-12-11	AVIV	ETF	33.44	33.96	33.44	33.85	112242.0
2014-12-11	AWAY	ETF	30.19	30.72	29.77	29.9	1011721.0
2014-12-11	BAB	ETF	30.31	30.31	30.06	30.22	62641.0
2014-12-11	BAL	ETF	41.197	41.6401	41.197	41.4499	8483.0
2014-12-11	BALT	ETF	2.46	2.555	2.42	2.51	776974.0
2014-12-11	BAR	ETF	2.951	3.046	2.951	3.046	53080.0
2014-12-11	BBH	ETF	119.54	121.55	119.24	119.49	97600.0
2014-12-11	BCHP	ETF	18.02	18.13	18.0	18.0101	3100.0
2014-12-11	BCM	ETF	33.6507	33.71	33.52	33.53	161208.0
2014-12-11	BFOR	ETF	7.7625	7.8575	7.7525	7.755	90800.0
2014-12-11	BIB	ETF	66.21	68.25	65.575	65.995	499394.0
2014-12-11	BICK	ETF	23.82	23.95	23.82	23.861	2080.0

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

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