PREVIEW / etf_daily / 2014-02-14

all etf daily files

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

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-14	SPY	ETF	182.84	184.36	182.67	184.02	96498400.0
2014-02-14	QQQ	ETF	89.56	90.01	89.33	89.81	34086390.0
2014-02-14	IWM	ETF	113.64	114.21	113.14	114.06	32428200.0
2014-02-14	DIA	ETF	160.08	161.83	159.9	161.59	5824400.0
2014-02-14	GLD	ETF	126.99	127.38	126.75	127.15	11147900.0
2014-02-14	TLT	ETF	106.57	106.64	106.27	106.58	4989100.0
2014-02-14	AADR	ETF	37.22	37.24	37.2	37.2	800.0
2014-02-14	AAXJ	ETF	57.47	58.01	57.47	57.82	784900.0
2014-02-14	ACWI	ETF	56.68	57.15	56.68	57.04	3758300.0
2014-02-14	ACWV	ETF	62.45	62.71	62.23	62.57	7900.0
2014-02-14	ACWX	ETF	45.51	45.88	45.51	45.81	74740.0
2014-02-14	ADRE	ETF	34.69	35.08	34.69	34.98	178271.0
2014-02-14	AFK	ETF	30.08	30.49	30.08	30.2201	7194.0
2014-02-14	AGG	ETF	107.75	107.78	107.66	107.77	708800.0
2014-02-14	AGQ	ETF	73.92	75.98	73.78	75.98	1101700.0
2014-02-14	AGZ	ETF	111.79	111.79	111.55	111.55	26734.0
2014-02-14	AIA	ETF	45.04	45.44	45.04	45.36	26199.0
2014-02-14	AIQ	ETF	28.67	29.0	27.53	28.77	28453.0
2014-02-14	AIVI	ETF	47.76	48.24	47.76	48.24	11900.0
2014-02-14	AMJ	ETF	47.38	47.61	46.811	47.33	458976.0
2014-02-14	AMLP	ETF	88.65	88.95	88.35	88.6	507500.0
2014-02-14	ANGL	ETF	27.19	27.31	27.19	27.29	2300.0
2014-02-14	AOA	ETF	44.33	44.56	44.28	44.52	17800.0
2014-02-14	AOK	ETF	32.03	32.121	32.03	32.1	11868.0
2014-02-14	AOM	ETF	34.35	34.44	34.3273	34.43	33071.0
2014-02-14	AOR	ETF	38.43	38.58	38.35	38.55	37066.0
2014-02-14	ARGT	ETF	18.69	19.34	18.69	19.34	3000.0
2014-02-14	ASEA	ETF	15.27	15.42	15.27	15.42	5700.0
2014-02-14	ASHR	ETF	24.01	24.14	23.99	24.12	107100.0
2014-02-14	ATMP	ETF	27.87	27.87	27.71	27.75	14100.0
2014-02-14	AVIV	ETF	23.95	23.99	23.74	23.92	41086.0
2014-02-14	AWAY	ETF	42.0	42.18	41.08	41.75	887301.0
2014-02-14	BAB	ETF	28.11	28.21	28.11	28.21	180706.0
2014-02-14	BAL	ETF	55.41	55.798	55.41	55.68	4206.0
2014-02-14	BALT	ETF	6.59	6.595	6.43	6.52	520360.0
2014-02-14	BBH	ETF	102.79	102.79	100.98	101.51	211700.0
2014-02-14	BCM	ETF	40.67	40.67	40.2304	40.41	37142.0
2014-02-14	BFOR	ETF	7.3225	7.3675	7.3175	7.3525	140800.0
2014-02-14	BIB	ETF	49.125	49.36	47.545	48.123	615066.0
2014-02-14	BICK	ETF	22.97	22.97	22.97	22.97	1763.0
2014-02-14	BIL	ETF	91.54	91.56	91.54	91.56	139650.0
2014-02-14	BIS	ETF	608.8	626.8	606.0	619.6	3594.0
2014-02-14	BIV	ETF	83.48	83.48	83.36	83.45	134400.0
2014-02-14	BIZD	ETF	21.6	21.6	21.2	21.2	4400.0
2014-02-14	BJK	ETF	52.65	52.91	52.49	52.85	13800.0
2014-02-14	BKF	ETF	35.15	35.46	35.0	35.35	313747.0
2014-02-14	BKLN	ETF	24.83	24.83	24.8	24.83	2901700.0
2014-02-14	BLNG	ETF	37.43	37.43	37.43	37.43	102.0
2014-02-14	BLV	ETF	84.93	85.0	84.81	84.95	56800.0
2014-02-14	BMVP	ETF	22.43	22.68	22.43	22.61	11584.0

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

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