PREVIEW / etf_daily / 2014-11-25

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-25.parquet
  size:    46 KB
  rows:    1,140

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-11-25	SPY	ETF	207.54	207.79	206.8	207.11	79108300.0
2014-11-25	QQQ	ETF	104.84	105.15	104.57	104.84	17525991.0
2014-11-25	IWM	ETF	118.22	118.78	117.53	118.06	26745900.0
2014-11-25	DIA	ETF	178.16	178.19	177.56	177.96	5510400.0
2014-11-25	GLD	ETF	115.1	115.47	114.9	115.38	9051800.0
2014-11-25	TLT	ETF	120.37	121.27	120.31	121.2	6770000.0
2014-11-25	AADR	ETF	38.75	38.81	38.24	38.24	1500.0
2014-11-25	AAXJ	ETF	62.86	62.98	62.54	62.58	1584600.0
2014-11-25	ACWI	ETF	60.72	60.75	60.5	60.56	1771500.0
2014-11-25	ACWV	ETF	69.89	69.93	69.68	69.79	100900.0
2014-11-25	ACWX	ETF	45.59	45.73	45.55	45.62	398917.0
2014-11-25	ADRE	ETF	39.87	39.91	39.5206	39.5206	11008.0
2014-11-25	AFK	ETF	29.05	29.1	28.91	29.02	19932.0
2014-11-25	AGG	ETF	109.96	110.22	109.96	110.18	3187700.0
2014-11-25	AGQ	ETF	43.07	43.46	42.5	43.45	188400.0
2014-11-25	AGZ	ETF	112.91	113.37	112.91	113.37	16228.0
2014-11-25	AGZD	ETF	24.705	24.765	24.695	24.695	18400.0
2014-11-25	AIA	ETF	47.83	47.895	47.6301	47.6301	26400.0
2014-11-25	AIQ	ETF	23.56	23.56	22.85	23.0	9097.0
2014-11-25	AIRR	ETF	19.01	19.1	18.94	19.1	481500.0
2014-11-25	AIVI	ETF	46.12	46.39	46.12	46.33	18200.0
2014-11-25	AMJ	ETF	51.8	52.06	51.33	51.46	1455508.0
2014-11-25	AMLP	ETF	93.5	93.7	92.8	92.85	654600.0
2014-11-25	AMZA	ETF	249.6	249.6	249.0	249.0	230.0
2014-11-25	ANGL	ETF	27.37	27.58	27.36	27.41	1500.0
2014-11-25	AOA	ETF	47.22	47.22	47.04	47.12	40400.0
2014-11-25	AOK	ETF	32.89	32.95	32.8854	32.9402	34228.0
2014-11-25	AOM	ETF	35.63	35.63	35.516	35.59	88297.0
2014-11-25	AOR	ETF	40.65	40.65	40.53	40.6	157257.0
2014-11-25	ARGT	ETF	21.25	21.25	21.25	21.25	1400.0
2014-11-25	ARKG	ETF	20.22	20.22	20.22	20.22	700.0
2014-11-25	ARKK	ETF	20.52	20.52	20.52	20.52	600.0
2014-11-25	ARKQ	ETF	20.46	20.46	20.46	20.46	300.0
2014-11-25	ARKW	ETF	20.58	20.58	20.5	20.55	1200.0
2014-11-25	ASEA	ETF	16.9	17.03	16.86	16.94	9800.0
2014-11-25	ASHR	ETF	29.84	30.1	29.39	29.67	1226300.0
2014-11-25	ASHS	ETF	35.17	35.46	35.17	35.37	28900.0
2014-11-25	ATMP	ETF	32.58	32.58	32.27	32.31	16400.0
2014-11-25	AVIV	ETF	32.61	33.21	32.61	33.13	589976.0
2014-11-25	AWAY	ETF	30.63	31.12	30.316	31.11	1024806.0
2014-11-25	BAB	ETF	29.9	30.05	29.828	29.9892	661678.0
2014-11-25	BAL	ETF	40.16	40.5899	40.16	40.5399	4329.0
2014-11-25	BALT	ETF	3.68	3.725	3.435	3.45	400464.0
2014-11-25	BAR	ETF	2.888	2.9082	2.875	2.898	38900.0
2014-11-25	BBH	ETF	116.8	116.81	114.9	115.86	50900.0
2014-11-25	BCHP	ETF	19.1	19.1	18.972	19.0	44065.0
2014-11-25	BCM	ETF	35.34	35.38	35.34	35.34	848.0
2014-11-25	BFOR	ETF	8.0125	8.0375	7.9825	7.985	39200.0
2014-11-25	BIB	ETF	62.5	62.5	60.684	61.77	387774.0
2014-11-25	BICK	ETF	25.221	25.2407	25.221	25.2407	3069.0

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

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