PREVIEW / etf_daily / 2014-07-09

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-09.parquet
  size:    44 KB
  rows:    1,098

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-07-09	SPY	ETF	196.73	197.3	196.31	197.12	72992000.0
2014-07-09	QQQ	ETF	94.51	95.065	94.24	94.96	29928322.0
2014-07-09	IWM	ETF	116.67	117.09	116.02	116.49	27891700.0
2014-07-09	DIA	ETF	169.18	169.73	168.86	169.58	3543800.0
2014-07-09	GLD	ETF	127.54	128.26	127.18	127.84	8362700.0
2014-07-09	TLT	ETF	112.66	113.14	112.38	112.83	6395200.0
2014-07-09	AADR	ETF	38.88	38.88	38.82	38.87	4700.0
2014-07-09	AAXJ	ETF	63.69	63.88	63.48	63.86	247300.0
2014-07-09	ACWI	ETF	60.47	60.64	60.37	60.61	940700.0
2014-07-09	ACWV	ETF	67.05	67.38	67.05	67.25	26900.0
2014-07-09	ACWX	ETF	48.0	48.2286	47.95	48.22	406867.0
2014-07-09	ADRE	ETF	39.43	39.7601	39.43	39.76	11335.0
2014-07-09	AFK	ETF	33.44	33.44	33.01	33.35	9576.0
2014-07-09	AGG	ETF	108.88	109.04	108.78	108.96	785500.0
2014-07-09	AGQ	ETF	71.86	72.51	70.86	71.74	387200.0
2014-07-09	AGZ	ETF	112.29	112.4	112.2401	112.2501	5997.0
2014-07-09	AGZD	ETF	25.005	25.03	24.925	25.03	26800.0
2014-07-09	AIA	ETF	48.52	48.82	48.47	48.71	12882.0
2014-07-09	AIQ	ETF	28.08	29.1	28.056	28.74	53554.0
2014-07-09	AIRR	ETF	19.27	19.31	19.12	19.12	29800.0
2014-07-09	AIVI	ETF	50.38	50.56	50.24	50.41	14500.0
2014-07-09	AMJ	ETF	51.29	51.65	50.53	51.65	832384.0
2014-07-09	AMLP	ETF	93.1	93.8	92.8	93.8	695100.0
2014-07-09	ANGL	ETF	28.32	28.32	28.04	28.26	2100.0
2014-07-09	AOA	ETF	46.77	46.85	46.63	46.85	28300.0
2014-07-09	AOK	ETF	32.9	32.91	32.82	32.89	22286.0
2014-07-09	AOM	ETF	35.44	35.48	35.37	35.47	59008.0
2014-07-09	AOR	ETF	40.17	40.21	40.08	40.19	37048.0
2014-07-09	ARGT	ETF	22.62	23.44	22.62	23.44	33500.0
2014-07-09	ASEA	ETF	17.19	17.33	17.16	17.32	5300.0
2014-07-09	ASHR	ETF	22.43	22.47	22.28	22.34	156800.0
2014-07-09	ASHS	ETF	26.7	26.78	26.65	26.74	9700.0
2014-07-09	ATMP	ETF	30.76	31.13	30.76	31.1	17900.0
2014-07-09	AVIV	ETF	27.85	28.06	27.73	27.92	298061.0
2014-07-09	AWAY	ETF	32.09	32.97	31.58	32.92	838424.0
2014-07-09	BAB	ETF	29.2	29.33	29.19	29.26	53027.0
2014-07-09	BAL	ETF	47.3	47.54	46.82	47.038	14766.0
2014-07-09	BALT	ETF	5.47	5.51	5.3	5.36	465756.0
2014-07-09	BBH	ETF	95.83	96.96	94.65	96.77	112700.0
2014-07-09	BCHP	ETF	20.7301	20.8565	20.7301	20.8565	1454.0
2014-07-09	BFOR	ETF	7.855	7.8625	7.83	7.8525	58400.0
2014-07-09	BIB	ETF	45.22	46.285	44.04	46.16	692560.0
2014-07-09	BICK	ETF	26.38	26.39	26.36	26.36	1502.0
2014-07-09	BIL	ETF	91.54	91.54	91.52	91.52	84150.0
2014-07-09	BIS	ETF	585.2	595.2	566.004	569.2	14491.0
2014-07-09	BIV	ETF	84.3	84.46	84.1	84.34	238100.0
2014-07-09	BIZD	ETF	20.44	20.65	20.44	20.62	8500.0
2014-07-09	BJK	ETF	50.03	50.34	49.9	50.21	10500.0
2014-07-09	BKF	ETF	39.04	39.3977	39.04	39.3306	18001.0
2014-07-09	BKLN	ETF	24.88	24.9	24.87	24.9	1552000.0

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

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