PREVIEW / etf_daily / 2014-01-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-28.parquet
  size:    43 KB
  rows:    1,072

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-01-28	SPY	ETF	178.14	179.3	178.12	179.07	110463200.0
2014-01-28	QQQ	ETF	85.42	85.94	85.31	85.85	44439554.0
2014-01-28	IWM	ETF	111.93	112.99	111.79	112.97	43722200.0
2014-01-28	DIA	ETF	158.47	159.17	158.28	158.94	8308000.0
2014-01-28	GLD	ETF	121.32	121.4	120.41	120.95	5149500.0
2014-01-28	TLT	ETF	106.91	106.99	106.55	106.99	5661500.0
2014-01-28	AADR	ETF	35.45	35.98	35.45	35.98	12500.0
2014-01-28	AAXJ	ETF	56.1	56.34	55.99	56.13	2484800.0
2014-01-28	ACWI	ETF	55.37	55.66	55.32	55.62	985700.0
2014-01-28	ACWV	ETF	61.16	61.53	61.16	61.49	28600.0
2014-01-28	ACWX	ETF	44.5	44.6999	44.47	44.67	119969.0
2014-01-28	ADRE	ETF	34.01	34.22	34.0	34.11	49602.0
2014-01-28	AFK	ETF	30.01	30.4399	30.01	30.3	8312.0
2014-01-28	AGG	ETF	107.46	107.56	107.39	107.53	1306400.0
2014-01-28	AGQ	ETF	64.46	64.5	62.6	63.51	461100.0
2014-01-28	AGZ	ETF	111.3	111.38	111.2701	111.3101	35870.0
2014-01-28	AGZD	ETF	25.005	25.005	24.995	25.0	1400.0
2014-01-28	AIA	ETF	44.21	44.44	44.21	44.41	23178.0
2014-01-28	AIQ	ETF	27.74	28.72	27.65	27.77	28136.0
2014-01-28	AIVI	ETF	46.22	46.56	46.22	46.49	25700.0
2014-01-28	AMJ	ETF	45.62	46.18	45.61	45.9	2461757.0
2014-01-28	AMLP	ETF	88.05	88.45	87.85	88.1	474500.0
2014-01-28	ANGL	ETF	27.1	27.1	27.1	27.1	1000.0
2014-01-28	AOA	ETF	43.38	43.58	43.38	43.53	27900.0
2014-01-28	AOK	ETF	31.74	31.86	31.74	31.84	27384.0
2014-01-28	AOM	ETF	33.84	34.0	33.84	34.0	29500.0
2014-01-28	AOR	ETF	37.7	37.9199	37.7	37.88	32242.0
2014-01-28	ARGT	ETF	17.54	17.81	17.51	17.6	20300.0
2014-01-28	ASEA	ETF	14.78	14.8	14.68	14.79	10200.0
2014-01-28	ASHR	ETF	23.13	23.39	23.13	23.36	295200.0
2014-01-28	ATMP	ETF	26.99	27.11	26.95	27.06	34400.0
2014-01-28	AVIV	ETF	23.97	24.57	23.88	24.55	74979.0
2014-01-28	AWAY	ETF	39.95	40.66	39.65	40.62	1144927.0
2014-01-28	BAB	ETF	28.01	28.04	27.97	27.97	131886.0
2014-01-28	BAL	ETF	53.01	53.16	52.85	52.922	8677.0
2014-01-28	BALT	ETF	5.17	5.4499	5.12	5.35	1030915.0
2014-01-28	BBH	ETF	94.68	96.21	94.68	95.86	189400.0
2014-01-28	BCM	ETF	38.97	39.04	38.9664	38.98	143519.0
2014-01-28	BFOR	ETF	7.1475	7.215	7.125	7.2125	320400.0
2014-01-28	BIB	ETF	41.225	43.67	41.225	43.425	723450.0
2014-01-28	BICK	ETF	22.81	22.83	22.78	22.83	7270.0
2014-01-28	BIL	ETF	91.56	91.56	91.54	91.54	480150.0
2014-01-28	BIS	ETF	716.4	726.0	699.6	707.6	1895.0
2014-01-28	BIV	ETF	83.09	83.14	82.95	83.14	219500.0
2014-01-28	BIZD	ETF	20.77	21.03	20.77	21.01	31700.0
2014-01-28	BJK	ETF	51.01	51.24	50.74	51.16	12600.0
2014-01-28	BKF	ETF	34.45	34.6699	34.395	34.46	96613.0
2014-01-28	BKLN	ETF	24.9	24.92	24.86	24.88	4210900.0
2014-01-28	BLNG	ETF	35.18	35.18	35.14	35.14	300.0
2014-01-28	BLV	ETF	84.79	84.87	84.5	84.87	104500.0

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

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