PREVIEW / etf_daily / 2014-05-21

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-21.parquet
  size:    43 KB
  rows:    1,077

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-05-21	SPY	ETF	188.09	189.22	188.06	189.13	89093000.0
2014-05-21	QQQ	ETF	88.16	88.89	88.11	88.84	36837678.0
2014-05-21	IWM	ETF	109.65	110.13	108.55	109.62	55278500.0
2014-05-21	DIA	ETF	163.95	165.15	163.89	164.98	4898700.0
2014-05-21	GLD	ETF	124.25	124.55	123.53	124.39	6846500.0
2014-05-21	TLT	ETF	112.22	112.4	111.87	112.26	8224600.0
2014-05-21	AADR	ETF	37.79	37.97	37.79	37.97	4600.0
2014-05-21	AAXJ	ETF	61.71	61.78	61.58	61.76	1123600.0
2014-05-21	ACWI	ETF	58.83	59.16	58.83	59.14	415000.0
2014-05-21	ACWV	ETF	65.85	65.95	65.72	65.95	38900.0
2014-05-21	ACWX	ETF	47.48	47.7365	47.48	47.71	43193.0
2014-05-21	ADRE	ETF	38.34	38.5965	38.34	38.48	6011.0
2014-05-21	AFK	ETF	32.63	33.259	32.63	32.77	138556.0
2014-05-21	AGG	ETF	109.15	109.18	109.08	109.17	804400.0
2014-05-21	AGQ	ETF	60.58	61.42	60.2	60.96	141900.0
2014-05-21	AGZ	ETF	112.4	112.615	112.3855	112.4001	5099.0
2014-05-21	AGZD	ETF	24.94	25.015	24.94	25.015	2200.0
2014-05-21	AIA	ETF	47.96	48.11	47.96	48.01	30997.0
2014-05-21	AIQ	ETF	28.2	29.84	28.2	29.52	33512.0
2014-05-21	AIRR	ETF	18.47	18.51	18.34	18.49	10500.0
2014-05-21	AIVI	ETF	50.79	50.93	50.76	50.92	33200.0
2014-05-21	AMJ	ETF	49.59	49.69	49.34	49.48	1423173.0
2014-05-21	AMLP	ETF	90.6	90.85	90.4	90.7	561420.0
2014-05-21	ANGL	ETF	28.11	28.11	28.0	28.05	10600.0
2014-05-21	AOA	ETF	45.46	45.62	45.46	45.62	16800.0
2014-05-21	AOK	ETF	32.53	32.6	32.53	32.58	10648.0
2014-05-21	AOM	ETF	35.02	35.04	34.9503	35.04	19426.0
2014-05-21	AOR	ETF	39.36	39.43	39.296	39.41	26665.0
2014-05-21	ARGT	ETF	19.24	19.27	19.24	19.27	700.0
2014-05-21	ASEA	ETF	16.78	16.8	16.73	16.73	131400.0
2014-05-21	ASHR	ETF	21.8	21.92	21.8	21.89	129000.0
2014-05-21	ASHS	ETF	25.42	25.42	24.3	25.2	119050.0
2014-05-21	ATMP	ETF	29.55	29.81	29.55	29.81	36900.0
2014-05-21	AVIV	ETF	27.25	27.38	26.91	27.21	169667.0
2014-05-21	AWAY	ETF	30.8	31.4	30.56	31.22	1281023.0
2014-05-21	BAB	ETF	29.2	29.23	29.14	29.188	73063.0
2014-05-21	BAL	ETF	55.32	55.32	54.924	54.9701	1893.0
2014-05-21	BALT	ETF	6.37	6.59	6.37	6.51	631066.0
2014-05-21	BBH	ETF	87.1	88.1	86.9	87.44	66600.0
2014-05-21	BCM	ETF	41.43	41.43	41.422	41.422	453.0
2014-05-21	BFOR	ETF	7.3675	7.42	7.3575	7.405	64400.0
2014-05-21	BIB	ETF	36.74	37.6437	36.505	37.07	360608.0
2014-05-21	BICK	ETF	25.61	25.61	25.575	25.575	764.0
2014-05-21	BIL	ETF	91.54	91.54	91.52	91.52	65450.0
2014-05-21	BIS	ETF	722.4	730.396	709.6	719.6	6065.0
2014-05-21	BIV	ETF	84.62	84.66	84.5	84.64	302900.0
2014-05-21	BIZD	ETF	19.44	19.53	19.44	19.47	12200.0
2014-05-21	BJK	ETF	48.63	48.99	48.51	48.9	25700.0
2014-05-21	BKF	ETF	37.71	37.92	37.71	37.8	49237.0
2014-05-21	BKLN	ETF	24.77	24.77	24.75	24.77	2440400.0

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

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