PREVIEW / etf_daily / 2014-02-27

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-27.parquet
  size:    43 KB
  rows:    1,061

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-02-27	SPY	ETF	184.58	185.87	184.37	185.82	93880800.0
2014-02-27	QQQ	ETF	89.87	90.53	89.73	90.44	28750313.0
2014-02-27	IWM	ETF	116.96	118.06	116.76	117.99	29906200.0
2014-02-27	DIA	ETF	161.64	162.56	161.37	162.55	5292500.0
2014-02-27	GLD	ETF	128.4	128.8	127.89	128.2	5066500.0
2014-02-27	TLT	ETF	108.28	108.56	108.1	108.51	5394700.0
2014-02-27	AADR	ETF	37.89	37.89	37.81	37.81	600.0
2014-02-27	AAXJ	ETF	58.05	58.47	57.99	58.38	150800.0
2014-02-27	ACWI	ETF	57.22	57.72	57.22	57.69	1176000.0
2014-02-27	ACWV	ETF	63.3	63.45	63.19	63.4	57200.0
2014-02-27	ACWX	ETF	46.12	46.2999	45.99	46.27	1074510.0
2014-02-27	ADRE	ETF	35.03	35.529	35.0	35.48	10340.0
2014-02-27	AFK	ETF	30.98	31.1896	30.8201	31.0	12227.0
2014-02-27	AGG	ETF	108.25	108.37	108.23	108.33	628900.0
2014-02-27	AGQ	ETF	74.52	75.62	73.83	74.48	375800.0
2014-02-27	AGZ	ETF	111.93	112.004	111.91	111.94	9205.0
2014-02-27	AGZD	ETF	24.91	24.91	24.91	24.91	3000.0
2014-02-27	AIA	ETF	45.47	45.7369	45.4	45.66	7252.0
2014-02-27	AIQ	ETF	30.08	31.24	29.74	30.8	10976.0
2014-02-27	AIVI	ETF	48.55	49.0	48.55	48.95	22200.0
2014-02-27	AMJ	ETF	46.23	46.3699	46.001	46.1	527446.0
2014-02-27	AMLP	ETF	87.55	87.75	87.3	87.4	574600.0
2014-02-27	AOA	ETF	44.86	45.03	44.8	45.03	15400.0
2014-02-27	AOK	ETF	32.31	32.37	32.2704	32.37	22507.0
2014-02-27	AOM	ETF	34.55	34.71	34.55	34.71	21844.0
2014-02-27	AOR	ETF	38.752	38.93	38.752	38.93	19861.0
2014-02-27	ARGT	ETF	18.17	18.93	18.13	18.75	2800.0
2014-02-27	ASEA	ETF	15.45	15.61	15.45	15.58	24600.0
2014-02-27	ASHR	ETF	22.3	22.35	22.2	22.26	264700.0
2014-02-27	ATMP	ETF	27.22	27.27	27.17	27.18	15000.0
2014-02-27	AVIV	ETF	24.9	25.15	24.78	25.02	95609.0
2014-02-27	AWAY	ETF	46.51	47.12	45.84	46.73	1572385.0
2014-02-27	BAB	ETF	28.59	28.61	28.528	28.61	85241.0
2014-02-27	BAL	ETF	54.33	55.0002	54.05	54.75	10228.0
2014-02-27	BALT	ETF	6.76	6.76	6.18	6.4	690760.0
2014-02-27	BBH	ETF	104.74	105.45	103.99	104.9	72900.0
2014-02-27	BCM	ETF	41.23	41.23	40.8	40.8	71204.0
2014-02-27	BFOR	ETF	7.56	7.5975	7.545	7.5975	180400.0
2014-02-27	BIB	ETF	52.505	54.115	52.4	53.6	458212.0
2014-02-27	BICK	ETF	23.57	23.78	23.57	23.78	915.0
2014-02-27	BIL	ETF	91.54	91.56	91.54	91.54	95300.0
2014-02-27	BIS	ETF	566.8	566.8	547.6	551.6	4640.0
2014-02-27	BIV	ETF	83.88	83.99	83.86	83.98	123000.0
2014-02-27	BIZD	ETF	21.03	21.16	21.03	21.16	13400.0
2014-02-27	BJK	ETF	54.29	54.84	54.25	54.79	30800.0
2014-02-27	BKF	ETF	34.99	35.369	34.91	35.369	106524.0
2014-02-27	BKLN	ETF	24.86	24.87	24.85	24.87	2503000.0
2014-02-27	BLV	ETF	86.25	86.39	86.15	86.35	40800.0
2014-02-27	BMVP	ETF	23.0667	23.18	23.05	23.1423	10246.0
2014-02-27	BND	ETF	81.56	81.56	81.47	81.56	670700.0

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

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