PREVIEW / etf_daily / 2014-02-26

all etf daily files

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

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-26	SPY	ETF	185.11	185.6	184.33	184.85	98677200.0
2014-02-26	QQQ	ETF	90.57	90.84	89.87	90.23	42968334.0
2014-02-26	IWM	ETF	116.71	118.11	116.43	117.35	40794800.0
2014-02-26	DIA	ETF	161.71	162.26	161.27	161.84	5032900.0
2014-02-26	GLD	ETF	128.49	128.76	127.42	128.11	7052900.0
2014-02-26	TLT	ETF	107.31	107.92	107.24	107.92	7203900.0
2014-02-26	AADR	ETF	37.95	37.95	37.75	37.75	800.0
2014-02-26	AAXJ	ETF	57.69	57.76	57.31	57.39	156500.0
2014-02-26	ACWI	ETF	57.56	57.62	57.24	57.37	1051300.0
2014-02-26	ACWV	ETF	63.03	63.28	63.03	63.15	21200.0
2014-02-26	ACWX	ETF	46.09	46.21	45.9399	46.03	160889.0
2014-02-26	ADRE	ETF	34.93	35.0399	34.78	34.835	9003.0
2014-02-26	AFK	ETF	31.07	31.165	30.8	30.83	10458.0
2014-02-26	AGG	ETF	108.04	108.22	108.0	108.22	617000.0
2014-02-26	AGQ	ETF	76.76	76.87	73.21	74.1	1281500.0
2014-02-26	AGZ	ETF	111.73	111.878	111.73	111.81	14500.0
2014-02-26	AIA	ETF	45.06	45.2684	45.01	45.03	27631.0
2014-02-26	AIQ	ETF	31.17	31.19	29.8	30.26	11832.0
2014-02-26	AIVI	ETF	48.75	48.78	48.51	48.65	18600.0
2014-02-26	AMJ	ETF	46.41	46.98	46.18	46.97	705386.0
2014-02-26	AMLP	ETF	87.1	87.85	86.75	87.7	746860.0
2014-02-26	ANGL	ETF	27.45	27.56	27.45	27.55	8600.0
2014-02-26	AOA	ETF	44.84	44.95	44.78	44.8	22500.0
2014-02-26	AOK	ETF	32.3	32.31	32.2478	32.3	24413.0
2014-02-26	AOM	ETF	34.62	34.6299	34.54	34.58	53183.0
2014-02-26	AOR	ETF	38.73	38.85	38.69	38.79	31140.0
2014-02-26	ARGT	ETF	18.7	18.7	18.51	18.51	7600.0
2014-02-26	ASEA	ETF	15.36	15.37	15.28	15.35	23200.0
2014-02-26	ASHR	ETF	22.22	22.3	22.18	22.2	94000.0
2014-02-26	ATMP	ETF	27.23	27.53	27.23	27.52	8900.0
2014-02-26	AVIV	ETF	25.09	25.18	24.74	24.97	66238.0
2014-02-26	AWAY	ETF	45.69	47.06	44.8	46.51	2585809.0
2014-02-26	BAB	ETF	28.48	28.54	28.425	28.536	177818.0
2014-02-26	BAL	ETF	54.75	54.75	53.82	53.82	4795.0
2014-02-26	BALT	ETF	6.51	6.8	6.4	6.48	1072251.0
2014-02-26	BBH	ETF	106.26	106.26	104.33	104.68	140700.0
2014-02-26	BCM	ETF	41.03	41.09	40.84	40.86	176967.0
2014-02-26	BFOR	ETF	7.5375	7.61	7.5375	7.57	136800.0
2014-02-26	BIB	ETF	54.385	54.415	52.385	52.87	799522.0
2014-02-26	BICK	ETF	23.49	23.49	23.449	23.449	1238.0
2014-02-26	BIL	ETF	91.54	91.56	91.54	91.56	87700.0
2014-02-26	BIS	ETF	548.0	565.6	546.4	561.2	6797.0
2014-02-26	BIV	ETF	83.63	83.82	83.61	83.8	158600.0
2014-02-26	BIZD	ETF	20.84	21.22	20.84	21.12	27900.0
2014-02-26	BJK	ETF	53.8	54.13	53.58	53.83	18100.0
2014-02-26	BKF	ETF	34.75	34.91	34.565	34.64	56340.0
2014-02-26	BKLN	ETF	24.84	24.85	24.83	24.85	1775300.0
2014-02-26	BLV	ETF	85.62	85.96	85.57	85.91	38000.0
2014-02-26	BMVP	ETF	23.123	23.256	23.123	23.25	3143.0
2014-02-26	BND	ETF	81.27	81.47	81.27	81.46	987100.0

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

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