PREVIEW / etf_daily / 2014-12-05

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-05.parquet
  size:    46 KB
  rows:    1,145

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-05	SPY	ETF	207.87	208.47	207.55	208.0	91025500.0
2014-12-05	QQQ	ETF	105.54	105.7	105.145	105.38	25622236.0
2014-12-05	IWM	ETF	117.25	117.98	116.96	117.69	30261400.0
2014-12-05	DIA	ETF	179.28	179.82	178.99	179.51	4269400.0
2014-12-05	GLD	ETF	115.16	115.18	114.24	114.43	6331000.0
2014-12-05	TLT	ETF	121.57	121.6	120.52	121.09	8030700.0
2014-12-05	AADR	ETF	38.27	38.27	38.27	38.27	700.0
2014-12-05	AAXJ	ETF	62.68	62.8	62.47	62.77	1074800.0
2014-12-05	ACWI	ETF	60.49	60.51	60.28	60.39	1440100.0
2014-12-05	ACWV	ETF	69.98	69.99	69.76	69.91	26300.0
2014-12-05	ACWX	ETF	45.12	45.22	44.97	45.12	428172.0
2014-12-05	ADRE	ETF	37.59	37.6606	37.41	37.63	16235.0
2014-12-05	AFK	ETF	27.41	27.5	27.27	27.38	11145.0
2014-12-05	AGG	ETF	109.87	109.94	109.61	109.62	3477700.0
2014-12-05	AGQ	ETF	41.67	41.69	40.91	41.25	132100.0
2014-12-05	AGZ	ETF	112.8501	113.09	112.32	112.32	117678.0
2014-12-05	AGZD	ETF	24.725	24.825	24.72	24.785	22800.0
2014-12-05	AIA	ETF	48.05	48.19	47.93	48.14	27065.0
2014-12-05	AIQ	ETF	21.91	22.08	21.33	21.81	23759.0
2014-12-05	AIRR	ETF	18.45	18.509	18.29	18.41	95200.0
2014-12-05	AIVI	ETF	45.6	45.76	45.56	45.66	17300.0
2014-12-05	AMJ	ETF	48.64	48.687	47.82	47.89	672342.0
2014-12-05	AMLP	ETF	90.7	91.0	89.7	89.85	768860.0
2014-12-05	AMZA	ETF	240.7	240.7	237.8	237.8	640.0
2014-12-05	ANGL	ETF	27.1	27.48	27.04	27.04	9000.0
2014-12-05	AOA	ETF	47.03	47.08	46.92	47.0	33400.0
2014-12-05	AOK	ETF	32.79	32.849	32.79	32.82	46362.0
2014-12-05	AOM	ETF	35.55	35.55	35.45	35.5	162354.0
2014-12-05	AOR	ETF	40.45	40.5399	40.446	40.51	74284.0
2014-12-05	ARGT	ETF	20.21	20.52	20.21	20.38	6400.0
2014-12-05	ARKG	ETF	20.5	20.51	20.5	20.51	1100.0
2014-12-05	ARKK	ETF	20.19	20.19	20.1	20.11	7400.0
2014-12-05	ARKQ	ETF	20.18	20.18	20.1	20.1	800.0
2014-12-05	ARKW	ETF	20.34	20.34	20.33	20.34	1800.0
2014-12-05	ASEA	ETF	16.24	16.24	16.15	16.19	1700.0
2014-12-05	ASHR	ETF	34.49	34.75	34.02	34.49	1797200.0
2014-12-05	ASHS	ETF	36.38	36.38	35.93	36.28	100500.0
2014-12-05	ATMP	ETF	31.35	31.35	31.02	31.03	18500.0
2014-12-05	AVIV	ETF	34.09	34.09	33.32	33.86	240625.0
2014-12-05	AWAY	ETF	32.0	32.3	31.69	31.92	903206.0
2014-12-05	BAB	ETF	29.94	29.94	29.7603	29.89	102621.0
2014-12-05	BAL	ETF	41.34	41.53	40.608	40.69	11115.0
2014-12-05	BALT	ETF	2.82	2.97	2.82	2.87	540140.0
2014-12-05	BAR	ETF	2.801	2.801	2.782	2.789	18040.0
2014-12-05	BBH	ETF	118.22	119.16	118.15	119.06	53700.0
2014-12-05	BCM	ETF	33.811	33.97	33.811	33.97	11933.0
2014-12-05	BFOR	ETF	7.9125	7.9525	7.9125	7.925	67600.0
2014-12-05	BIB	ETF	64.46	65.625	64.46	65.5	279978.0
2014-12-05	BICK	ETF	24.72	24.8199	24.72	24.8199	632.0
2014-12-05	BIL	ETF	91.48	91.5	91.46	91.5	540700.0

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

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