PREVIEW / etf_daily / 2014-02-13

all etf daily files

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

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-13	SPY	ETF	180.84	183.2	180.83	183.01	100542200.0
2014-02-13	QQQ	ETF	88.31	89.7	88.3	89.63	40492842.0
2014-02-13	IWM	ETF	111.38	114.07	111.36	113.9	42082400.0
2014-02-13	DIA	ETF	158.66	160.47	158.61	160.29	5085000.0
2014-02-13	GLD	ETF	124.7	125.6	124.66	125.49	9167900.0
2014-02-13	TLT	ETF	106.59	106.73	106.3	106.52	6874600.0
2014-02-13	AADR	ETF	36.66	36.75	36.66	36.75	800.0
2014-02-13	AAXJ	ETF	56.61	57.28	56.57	57.13	431100.0
2014-02-13	ACWI	ETF	56.21	56.84	56.09	56.81	527300.0
2014-02-13	ACWV	ETF	61.79	62.41	61.79	62.38	17300.0
2014-02-13	ACWX	ETF	44.94	45.56	44.94	45.53	110833.0
2014-02-13	ADRE	ETF	34.01	34.62	33.97	34.57	11149.0
2014-02-13	AFK	ETF	30.11	30.2499	29.87	30.19	32941.0
2014-02-13	AGG	ETF	107.75	107.82	107.69	107.77	777400.0
2014-02-13	AGQ	ETF	67.74	69.63	67.64	69.54	525700.0
2014-02-13	AGZ	ETF	111.69	111.73	111.54	111.6971	8804.0
2014-02-13	AIA	ETF	44.3	44.8756	44.3	44.82	21763.0
2014-02-13	AIQ	ETF	27.6	28.71	27.55	28.71	17924.0
2014-02-13	AIVI	ETF	47.23	47.79	47.21	47.79	15800.0
2014-02-13	AMJ	ETF	47.35	47.72	46.4001	47.28	358887.0
2014-02-13	AMLP	ETF	88.45	89.15	88.1	88.5	520760.0
2014-02-13	AOA	ETF	43.86	44.36	43.86	44.33	41400.0
2014-02-13	AOK	ETF	31.95	32.0899	31.87	32.06	25371.0
2014-02-13	AOM	ETF	34.15	34.35	34.1499	34.34	27930.0
2014-02-13	AOR	ETF	38.12	38.439	38.062	38.43	24499.0
2014-02-13	ARGT	ETF	18.25	18.56	18.15	18.56	3200.0
2014-02-13	ASEA	ETF	15.05	15.2	15.05	15.2	3800.0
2014-02-13	ASHR	ETF	23.78	23.86	23.7	23.83	66100.0
2014-02-13	ATMP	ETF	27.96	28.01	27.79	27.81	16000.0
2014-02-13	AVIV	ETF	23.72	24.02	23.54	23.91	82523.0
2014-02-13	AWAY	ETF	41.38	42.09	40.96	41.91	833181.0
2014-02-13	BAB	ETF	28.21	28.31	28.1912	28.24	141596.0
2014-02-13	BAL	ETF	55.16	56.08	55.131	55.43	8814.0
2014-02-13	BALT	ETF	6.4	6.68	6.4	6.55	731700.0
2014-02-13	BBH	ETF	100.04	102.47	100.04	102.46	208400.0
2014-02-13	BCM	ETF	39.91	40.11	39.9	40.07	26936.0
2014-02-13	BFOR	ETF	7.2325	7.345	7.2325	7.3425	156400.0
2014-02-13	BIB	ETF	46.57	48.97	46.0	48.97	467542.0
2014-02-13	BICK	ETF	22.97	22.97	22.97	22.97	1763.0
2014-02-13	BIL	ETF	91.54	91.56	91.54	91.56	471650.0
2014-02-13	BIS	ETF	646.0	646.0	609.604	610.0	4057.0
2014-02-13	BIV	ETF	83.34	83.44	83.29	83.38	161300.0
2014-02-13	BIZD	ETF	21.13	21.21	20.94	21.2	2700.0
2014-02-13	BJK	ETF	51.91	52.28	51.68	52.24	56800.0
2014-02-13	BKF	ETF	34.42	35.0299	34.35	34.99	52907.0
2014-02-13	BKLN	ETF	24.91	24.92	24.88	24.9	2480100.0
2014-02-13	BLV	ETF	84.81	84.9	84.69	84.83	64500.0
2014-02-13	BMVP	ETF	22.27	22.52	22.27	22.52	4312.0
2014-02-13	BND	ETF	81.02	81.1	81.01	81.09	3466300.0
2014-02-13	BNDX	ETF	50.27	50.34	50.16	50.32	131400.0

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

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