PREVIEW / etf_daily / 2014-05-08

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-08.parquet
  size:    44 KB
  rows:    1,093

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-08	SPY	ETF	187.71	189.05	187.08	187.68	93618000.0
2014-05-08	QQQ	ETF	86.26	87.53	86.05	86.48	46556871.0
2014-05-08	IWM	ETF	110.03	111.24	108.69	109.03	58520300.0
2014-05-08	DIA	ETF	165.02	166.07	164.86	165.35	5997900.0
2014-05-08	GLD	ETF	124.19	124.47	123.89	124.17	3695500.0
2014-05-08	TLT	ETF	112.34	112.76	111.46	111.6	10878800.0
2014-05-08	AADR	ETF	37.79	37.79	37.79	37.79	300.0
2014-05-08	AAXJ	ETF	59.46	59.75	59.37	59.44	196300.0
2014-05-08	ACWI	ETF	58.81	59.07	58.59	58.69	775800.0
2014-05-08	ACWV	ETF	65.08	65.59	65.08	65.21	92100.0
2014-05-08	ACWX	ETF	47.42	47.62	47.35	47.39	108146.0
2014-05-08	ADRE	ETF	38.09	38.25	37.9496	37.9501	6342.0
2014-05-08	AFK	ETF	33.11	33.35	32.97	33.07	87642.0
2014-05-08	AGG	ETF	108.78	108.9	108.68	108.79	2023400.0
2014-05-08	AGQ	ETF	60.1	60.47	59.4	59.68	190300.0
2014-05-08	AGZ	ETF	112.23	112.2699	112.1708	112.1901	7995.0
2014-05-08	AGZD	ETF	25.065	25.115	25.065	25.08	5000.0
2014-05-08	AIA	ETF	46.7	46.8265	46.61	46.61	16091.0
2014-05-08	AIQ	ETF	28.4	31.97	28.4	29.83	32114.0
2014-05-08	AIRR	ETF	18.7	18.77	18.35	18.43	20600.0
2014-05-08	AIVI	ETF	50.65	50.84	50.57	50.57	10200.0
2014-05-08	AMJ	ETF	49.8	49.8	48.82	49.04	599289.0
2014-05-08	AMLP	ETF	91.1	91.2	89.9	90.25	761660.0
2014-05-08	ANGL	ETF	27.81	27.87	27.65	27.69	3700.0
2014-05-08	AOA	ETF	45.5	45.7	45.34	45.39	13000.0
2014-05-08	AOK	ETF	32.52	32.58	32.45	32.51	18603.0
2014-05-08	AOM	ETF	34.95	35.0	34.8512	34.89	55488.0
2014-05-08	AOR	ETF	39.28	39.4	39.164	39.21	24864.0
2014-05-08	ARGT	ETF	20.23	20.23	20.1	20.1	1200.0
2014-05-08	ASEA	ETF	16.59	16.59	16.53	16.53	2500.0
2014-05-08	ASHR	ETF	21.91	21.91	21.81	21.81	67700.0
2014-05-08	ATMP	ETF	29.98	29.98	29.45	29.49	154700.0
2014-05-08	AVIV	ETF	27.18	27.64	26.83	27.1	255773.0
2014-05-08	AWAY	ETF	30.68	31.52	30.27	30.67	1126139.0
2014-05-08	BAB	ETF	29.2	29.2999	29.152	29.17	86639.0
2014-05-08	BAL	ETF	57.59	58.01	57.31	57.31	6151.0
2014-05-08	BALT	ETF	5.85	5.95	5.56	5.93	1302382.0
2014-05-08	BBH	ETF	86.11	87.96	85.07	85.21	151800.0
2014-05-08	BCHP	ETF	20.23	20.25	20.08	20.08	9048.0
2014-05-08	BCM	ETF	41.11	41.22	41.11	41.18	2458.0
2014-05-08	BFOR	ETF	7.4075	7.48	7.365	7.3825	218000.0
2014-05-08	BIB	ETF	35.685	37.6525	34.98	35.165	921356.0
2014-05-08	BICK	ETF	24.54	24.72	24.54	24.72	1231.0
2014-05-08	BIL	ETF	91.54	91.54	91.52	91.52	125300.0
2014-05-08	BIS	ETF	744.4	768.8	714.8	764.4	18784.0
2014-05-08	BIV	ETF	84.15	84.27	84.05	84.17	309100.0
2014-05-08	BIZD	ETF	19.62	19.62	19.42	19.42	17600.0
2014-05-08	BJK	ETF	48.14	49.15	47.88	48.27	56100.0
2014-05-08	BKF	ETF	36.557	36.557	36.29	36.29	43743.0
2014-05-08	BKLN	ETF	24.84	24.84	24.82	24.84	2347400.0

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

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