PREVIEW / etf_daily / 2014-02-20

all etf daily files

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

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-20	SPY	ETF	183.27	184.52	182.6	184.1	104998100.0
2014-02-20	QQQ	ETF	89.7	90.22	89.31	90.05	41833212.0
2014-02-20	IWM	ETF	114.2	115.54	113.91	115.3	35919600.0
2014-02-20	DIA	ETF	160.56	161.72	160.1	161.31	7035600.0
2014-02-20	GLD	ETF	126.75	127.75	126.4	127.6	10572900.0
2014-02-20	TLT	ETF	106.32	106.63	105.69	106.11	5103200.0
2014-02-20	AADR	ETF	37.42	37.42	37.0	37.0	600.0
2014-02-20	AAXJ	ETF	57.22	57.61	57.03	57.54	372300.0
2014-02-20	ACWI	ETF	56.78	57.25	56.74	57.17	1185400.0
2014-02-20	ACWV	ETF	62.44	63.07	62.44	63.07	7400.0
2014-02-20	ACWX	ETF	45.8	45.987	45.61	45.93	359052.0
2014-02-20	ADRE	ETF	34.93	35.03	34.68	34.98	11922.0
2014-02-20	AFK	ETF	30.46	30.65	30.2901	30.62	8551.0
2014-02-20	AGG	ETF	107.71	107.76	107.57	107.7	894000.0
2014-02-20	AGQ	ETF	77.4	79.07	76.91	78.4	594500.0
2014-02-20	AGZ	ETF	111.78	111.78	111.53	111.59	19190.0
2014-02-20	AIA	ETF	44.67	45.05	44.56	44.952	25922.0
2014-02-20	AIQ	ETF	30.28	30.688	28.56	30.32	31018.0
2014-02-20	AIVI	ETF	48.24	48.65	48.24	48.56	15800.0
2014-02-20	ALTL	ETF	33.03	33.1499	33.03	33.1499	739.0
2014-02-20	AMJ	ETF	46.81	46.964	46.45	46.59	443925.0
2014-02-20	AMLP	ETF	87.9	87.95	87.2	87.45	797300.0
2014-02-20	ANGL	ETF	27.44	27.44	27.44	27.44	900.0
2014-02-20	AOA	ETF	44.44	44.63	44.33	44.62	15200.0
2014-02-20	AOK	ETF	32.105	32.17	32.0724	32.16	11345.0
2014-02-20	AOM	ETF	34.39	34.4604	34.31	34.42	40650.0
2014-02-20	AOR	ETF	38.5	38.62	38.4315	38.62	36127.0
2014-02-20	ARGT	ETF	18.34	18.57	18.34	18.57	1000.0
2014-02-20	ASEA	ETF	15.42	15.47	15.36	15.45	17600.0
2014-02-20	ASHR	ETF	23.82	23.87	23.79	23.83	178300.0
2014-02-20	ATMP	ETF	27.55	27.57	27.35	27.36	22700.0
2014-02-20	AVIV	ETF	24.02	24.78	23.97	24.76	232351.0
2014-02-20	AWAY	ETF	45.98	48.9	44.73	48.36	6272931.0
2014-02-20	BAB	ETF	28.28	28.31	28.2101	28.3	132492.0
2014-02-20	BAL	ETF	54.93	54.9501	54.6	54.6401	9265.0
2014-02-20	BALT	ETF	6.03	6.29	6.03	6.23	563744.0
2014-02-20	BBH	ETF	101.97	103.59	101.44	103.51	97100.0
2014-02-20	BCM	ETF	40.77	40.94	40.77	40.92	19465.0
2014-02-20	BFOR	ETF	7.375	7.45	7.3625	7.4475	79600.0
2014-02-20	BIB	ETF	50.0699	51.09	48.82	51.0	504798.0
2014-02-20	BICK	ETF	23.2599	23.2599	23.2599	23.2599	157.0
2014-02-20	BIL	ETF	91.54	91.56	91.54	91.56	240750.0
2014-02-20	BIS	ETF	599.2	608.0	580.8	580.84	2513.5
2014-02-20	BIV	ETF	83.36	83.48	83.21	83.32	177800.0
2014-02-20	BIZD	ETF	21.33	21.71	21.28	21.46	13400.0
2014-02-20	BJK	ETF	51.91	52.62	51.91	52.58	28500.0
2014-02-20	BKF	ETF	34.85	35.1496	34.64	35.04	69705.0
2014-02-20	BKLN	ETF	24.83	24.84	24.82	24.83	1458100.0
2014-02-20	BLV	ETF	84.8	84.92	84.51	84.72	47400.0
2014-02-20	BMVP	ETF	22.7645	22.9114	22.7645	22.9114	2898.0

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

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