PREVIEW / etf_daily / 2014-04-30

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-30.parquet
  size:    43 KB
  rows:    1,075

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-30	SPY	ETF	187.44	188.5	187.18	188.31	101508000.0
2014-04-30	QQQ	ETF	86.79	87.48	86.54	87.39	38689408.0
2014-04-30	IWM	ETF	110.88	112.06	109.95	111.98	43929700.0
2014-04-30	DIA	ETF	164.92	165.6	164.83	165.45	4958500.0
2014-04-30	GLD	ETF	124.19	125.05	123.82	124.22	10352900.0
2014-04-30	TLT	ETF	110.72	111.26	110.38	111.1	7721400.0
2014-04-30	AADR	ETF	37.72	37.73	37.67	37.73	2300.0
2014-04-30	AAXJ	ETF	59.35	59.65	59.34	59.62	255800.0
2014-04-30	ACWI	ETF	58.62	58.86	58.47	58.83	721700.0
2014-04-30	ACWV	ETF	64.89	65.39	64.89	65.36	25800.0
2014-04-30	ACWX	ETF	47.15	47.364	47.1	47.35	182231.0
2014-04-30	ADRE	ETF	37.06	37.27	37.06	37.27	22796.0
2014-04-30	AFK	ETF	32.83	32.9	32.38	32.773	107398.0
2014-04-30	AGG	ETF	108.46	108.61	108.38	108.59	1313000.0
2014-04-30	AGQ	ETF	59.8	60.55	59.08	59.95	637200.0
2014-04-30	AGZ	ETF	111.87	112.17	111.87	112.15	12761.0
2014-04-30	AIA	ETF	46.53	46.53	46.32	46.42	9573.0
2014-04-30	AIQ	ETF	28.73	29.07	28.03	28.46	29779.0
2014-04-30	AIRR	ETF	19.04	19.178	19.01	19.17	8800.0
2014-04-30	AIVI	ETF	50.09	50.34	49.95	50.31	8200.0
2014-04-30	ALTL	ETF	33.85	33.85	33.85	33.85	420.0
2014-04-30	AMJ	ETF	48.51	48.5899	48.24	48.48	927516.0
2014-04-30	AMLP	ETF	90.8	90.8	90.3	90.55	451560.0
2014-04-30	ANGL	ETF	27.69	27.82	27.67	27.72	2300.0
2014-04-30	AOA	ETF	45.26	45.4	45.17	45.4	11300.0
2014-04-30	AOK	ETF	32.46	32.5	32.4	32.47	26406.0
2014-04-30	AOM	ETF	34.7	34.88	34.7	34.88	12317.0
2014-04-30	AOR	ETF	39.11	39.1999	39.02	39.1904	35437.0
2014-04-30	ARGT	ETF	20.17	20.17	19.9	19.91	800.0
2014-04-30	ASEA	ETF	16.48	16.53	16.41	16.53	20400.0
2014-04-30	ASHR	ETF	21.86	21.98	21.84	21.95	70800.0
2014-04-30	ATMP	ETF	28.98	28.98	28.78	28.9	23200.0
2014-04-30	AVIV	ETF	25.9	26.55	25.81	26.39	559188.0
2014-04-30	AWAY	ETF	32.97	32.97	31.86	32.62	2132974.0
2014-04-30	BAB	ETF	29.0	29.05	28.9142	29.02	121767.0
2014-04-30	BAL	ETF	58.35	58.43	58.18	58.4	10160.0
2014-04-30	BALT	ETF	5.9	6.03	5.71	5.99	1870017.0
2014-04-30	BBH	ETF	86.89	87.41	85.53	87.38	106300.0
2014-04-30	BCHP	ETF	20.06	20.13	20.01	20.13	2330.0
2014-04-30	BCM	ETF	41.33	41.33	41.24	41.24	1500.0
2014-04-30	BFOR	ETF	7.405	7.4625	7.3675	7.4575	350400.0
2014-04-30	BIB	ETF	36.485	37.395	35.725	37.27	639696.0
2014-04-30	BICK	ETF	24.39	24.46	24.353	24.39	1845.0
2014-04-30	BIL	ETF	91.54	91.56	91.54	91.54	230600.0
2014-04-30	BIS	ETF	736.0	756.8	724.004	724.4	22017.0
2014-04-30	BIV	ETF	83.82	83.95	83.69	83.92	190100.0
2014-04-30	BIZD	ETF	19.81	19.92	19.75	19.88	29300.0
2014-04-30	BJK	ETF	49.85	49.95	49.62	49.95	8000.0
2014-04-30	BKF	ETF	35.74	35.91	35.74	35.91	33816.0
2014-04-30	BKLN	ETF	24.7	24.75	24.68	24.74	4254700.0

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

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