PREVIEW / etf_daily / 2014-04-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-10.parquet
  size:    44 KB
  rows:    1,085

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-04-10	SPY	ETF	187.08	187.17	182.93	183.16	172959000.0
2014-04-10	QQQ	ETF	87.87	87.88	84.86	85.1	73659615.0
2014-04-10	IWM	ETF	115.1	115.11	111.4	111.96	74860200.0
2014-04-10	DIA	ETF	164.12	164.31	161.27	161.47	9981500.0
2014-04-10	GLD	ETF	126.95	127.37	126.82	127.01	5003200.0
2014-04-10	TLT	ETF	108.92	110.22	108.9	109.84	12706400.0
2014-04-10	AADR	ETF	37.85	37.85	37.64	37.64	600.0
2014-04-10	AAXJ	ETF	61.28	61.42	60.67	60.8	1664400.0
2014-04-10	ACWI	ETF	58.43	58.54	57.43	57.48	1258900.0
2014-04-10	ACWV	ETF	64.84	64.84	63.91	64.02	58900.0
2014-04-10	ACWX	ETF	47.18	47.18	46.51	46.54	372518.0
2014-04-10	ADRE	ETF	37.87	37.94	37.3296	37.4	23855.0
2014-04-10	AFK	ETF	32.15	32.19	31.6	31.77	76194.0
2014-04-10	AGG	ETF	108.17	108.49	108.15	108.33	1033300.0
2014-04-10	AGQ	ETF	66.41	66.85	65.5	65.6	327400.0
2014-04-10	AGZ	ETF	111.9725	112.2	111.9725	112.152	5582.0
2014-04-10	AIA	ETF	47.78	47.9	47.2937	47.43	11895.0
2014-04-10	AIQ	ETF	33.2	33.2	30.96	31.19	38466.0
2014-04-10	AIRR	ETF	19.43	19.45	18.964	19.05	67300.0
2014-04-10	AIVI	ETF	49.54	49.64	48.83	48.84	23800.0
2014-04-10	ALTL	ETF	33.71	33.71	33.6951	33.6951	522.0
2014-04-10	AMJ	ETF	47.54	47.7199	46.89	47.09	245701.0
2014-04-10	AMLP	ETF	89.35	89.75	88.6	88.8	419880.0
2014-04-10	ANGL	ETF	27.53	27.53	27.53	27.53	900.0
2014-04-10	AOA	ETF	45.4	45.4	44.6	44.69	22000.0
2014-04-10	AOK	ETF	32.45	32.45	32.2354	32.2354	11441.0
2014-04-10	AOM	ETF	34.761	34.8095	34.5001	34.53	141160.0
2014-04-10	AOR	ETF	39.0792	39.097	38.641	38.68	16885.0
2014-04-10	ARGT	ETF	20.5	20.71	19.97	19.97	26800.0
2014-04-10	ASEA	ETF	16.27	16.28	16.17	16.19	17100.0
2014-04-10	ASHR	ETF	23.24	23.5	23.18	23.19	201800.0
2014-04-10	ATMP	ETF	28.43	28.53	28.12	28.16	22900.0
2014-04-10	AVIV	ETF	24.79	25.1	24.64	24.83	4817252.0
2014-04-10	AWAY	ETF	35.52	35.62	33.32	33.69	2358093.0
2014-04-10	BAB	ETF	28.83	28.9699	28.78	28.93	88428.0
2014-04-10	BAL	ETF	56.14	56.34	55.74	55.78	27071.0
2014-04-10	BALT	ETF	6.22	6.3299	6.05	6.07	846236.0
2014-04-10	BBH	ETF	90.23	90.23	84.09	84.93	344700.0
2014-04-10	BFOR	ETF	7.5625	7.5625	7.3525	7.385	324000.0
2014-04-10	BIB	ETF	38.975	39.17	34.25	34.9	1356186.0
2014-04-10	BICK	ETF	25.2	25.33	24.9801	24.9801	1565.0
2014-04-10	BIL	ETF	91.54	91.56	91.54	91.54	66000.0
2014-04-10	BIS	ETF	711.2	806.0	711.2	792.8	26290.5
2014-04-10	BIV	ETF	83.68	83.99	83.63	83.88	246000.0
2014-04-10	BIZD	ETF	20.21	20.21	19.91	19.93	18200.0
2014-04-10	BJK	ETF	52.4	52.77	51.34	51.48	14900.0
2014-04-10	BKF	ETF	37.34	37.5374	36.94	37.04	64040.0
2014-04-10	BKLN	ETF	24.81	24.83	24.79	24.79	3846000.0
2014-04-10	BLV	ETF	86.85	87.38	86.73	87.17	61800.0
2014-04-10	BMVP	ETF	23.53	23.6066	23.0847	23.118	3710.0

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

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