PREVIEW / etf_daily / 2014-02-21

all etf daily files

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

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-21	SPY	ETF	184.45	184.89	183.8	183.89	118116400.0
2014-02-21	QQQ	ETF	90.33	90.465	89.82	89.93	31221745.0
2014-02-21	IWM	ETF	115.62	116.11	115.4	115.66	34814100.0
2014-02-21	DIA	ETF	161.08	161.62	160.62	160.81	5268200.0
2014-02-21	GLD	ETF	127.57	128.07	127.15	127.58	7298200.0
2014-02-21	TLT	ETF	105.95	106.68	105.95	106.67	5250700.0
2014-02-21	AAXJ	ETF	57.63	57.91	57.55	57.73	2959600.0
2014-02-21	ACWI	ETF	57.24	57.46	57.2	57.21	1127900.0
2014-02-21	ACWV	ETF	63.07	63.34	63.05	63.07	20100.0
2014-02-21	ACWX	ETF	46.06	46.23	46.02	46.02	354965.0
2014-02-21	ADRE	ETF	35.06	35.218	35.0205	35.08	21794.0
2014-02-21	AFK	ETF	30.6599	30.67	30.65	30.669	6982.0
2014-02-21	AGG	ETF	107.62	107.8	107.61	107.8	395300.0
2014-02-21	AGQ	ETF	78.02	79.52	77.28	78.33	492900.0
2014-02-21	AGZ	ETF	111.4	111.93	111.4	111.661	14053.0
2014-02-21	AGZD	ETF	24.7	24.7	24.7	24.7	200.0
2014-02-21	AIA	ETF	45.02	45.25	45.02	45.19	9513.0
2014-02-21	AIQ	ETF	30.0	30.0	28.55	29.62	34894.0
2014-02-21	AIVI	ETF	48.67	48.92	48.57	48.77	12600.0
2014-02-21	ALTL	ETF	33.31	33.31	33.31	33.31	576.0
2014-02-21	AMJ	ETF	46.61	46.825	46.43	46.58	949312.0
2014-02-21	AMLP	ETF	87.55	87.75	87.2	87.4	503420.0
2014-02-21	ANGL	ETF	27.42	27.42	27.42	27.42	500.0
2014-02-21	AOA	ETF	44.75	44.78	44.6	44.6	32300.0
2014-02-21	AOK	ETF	32.21	32.22	32.18	32.18	51976.0
2014-02-21	AOM	ETF	34.51	34.53	34.44	34.44	24287.0
2014-02-21	AOR	ETF	38.59	38.7199	38.59	38.6	84275.0
2014-02-21	ARGT	ETF	18.54	18.72	18.47	18.47	2800.0
2014-02-21	ASEA	ETF	15.5	15.55	15.5	15.52	18400.0
2014-02-21	ASHR	ETF	23.53	23.57	23.47	23.53	61200.0
2014-02-21	ATMP	ETF	27.4	27.49	27.3	27.3	49300.0
2014-02-21	AVIV	ETF	24.75	24.96	24.5	24.75	136125.0
2014-02-21	AWAY	ETF	48.54	48.619	47.31	47.74	1777488.0
2014-02-21	BAB	ETF	28.18	28.37	28.18	28.36	137973.0
2014-02-21	BAL	ETF	55.24	55.28	54.83	55.138	4772.0
2014-02-21	BALT	ETF	6.28	6.37	6.2201	6.35	325438.0
2014-02-21	BBH	ETF	103.79	105.73	103.77	104.77	178400.0
2014-02-21	BCM	ETF	40.93	41.0	40.82	40.97	215277.0
2014-02-21	BFOR	ETF	7.46	7.4775	7.45	7.4575	91200.0
2014-02-21	BIB	ETF	51.72	53.12	51.005	52.3	491404.0
2014-02-21	BICK	ETF	23.24	23.3899	23.24	23.34	3186.0
2014-02-21	BIL	ETF	91.54	91.56	91.54	91.54	298050.0
2014-02-21	BIS	ETF	580.0	582.392	558.0	568.8	4573.0
2014-02-21	BIV	ETF	83.24	83.44	83.24	83.4	296900.0
2014-02-21	BIZD	ETF	21.56	21.59	21.45	21.45	3200.0
2014-02-21	BJK	ETF	52.89	52.89	52.57	52.75	5700.0
2014-02-21	BKF	ETF	35.11	35.33	35.11	35.3	52150.0
2014-02-21	BKLN	ETF	24.83	24.84	24.8	24.82	2432000.0
2014-02-21	BLV	ETF	84.69	85.13	84.69	85.11	51800.0
2014-02-21	BMVP	ETF	22.92	22.987	22.887	22.9	2021.0

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

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