PREVIEW / etf_daily / 2014-08-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-07.parquet
  size:    45 KB
  rows:    1,111

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-08-07	SPY	ETF	192.94	193.13	190.55	191.03	135733000.0
2014-08-07	QQQ	ETF	94.95	95.139	93.885	94.22	33274669.0
2014-08-07	IWM	ETF	112.09	112.52	110.77	111.19	40852200.0
2014-08-07	DIA	ETF	164.85	164.89	163.13	163.55	4962400.0
2014-08-07	GLD	ETF	125.47	126.51	125.37	126.18	7298900.0
2014-08-07	TLT	ETF	114.84	115.77	114.57	115.77	9745500.0
2014-08-07	AAXJ	ETF	64.34	64.43	63.81	63.95	229500.0
2014-08-07	ACWI	ETF	58.91	59.0	58.26	58.42	1773100.0
2014-08-07	ACWV	ETF	65.95	66.09	65.53	65.69	31700.0
2014-08-07	ACWX	ETF	46.78	46.78	46.17	46.27	103723.0
2014-08-07	ADRE	ETF	41.0	41.17	40.3955	40.486	10324.0
2014-08-07	AFK	ETF	33.41	33.56	33.179	33.27	32542.0
2014-08-07	AGG	ETF	109.19	109.4	109.1	109.34	1246500.0
2014-08-07	AGQ	ETF	63.59	64.19	63.36	63.92	127000.0
2014-08-07	AGZ	ETF	112.5684	112.72	112.44	112.61	7396.0
2014-08-07	AGZD	ETF	24.865	24.9	24.79	24.885	17000.0
2014-08-07	AIA	ETF	49.51	49.52	49.35	49.5	70228.0
2014-08-07	AIQ	ETF	28.39	28.61	27.55	27.55	27536.0
2014-08-07	AIRR	ETF	18.38	18.38	18.09	18.17	239000.0
2014-08-07	AIVI	ETF	48.85	48.85	48.21	48.4	67000.0
2014-08-07	AMJ	ETF	50.15	50.548	49.835	50.09	521060.0
2014-08-07	AMLP	ETF	90.6	91.1	90.2	90.55	490020.0
2014-08-07	ANGL	ETF	27.53	27.85	27.53	27.62	3300.0
2014-08-07	AOA	ETF	46.18	46.18	45.29	45.37	30000.0
2014-08-07	AOK	ETF	32.5	32.55	32.41	32.43	17638.0
2014-08-07	AOM	ETF	35.17	35.17	34.83	34.83	39252.0
2014-08-07	AOR	ETF	39.56	39.64	39.2397	39.3	34794.0
2014-08-07	ARGT	ETF	21.5	21.54	21.16	21.2	24500.0
2014-08-07	ASEA	ETF	17.29	17.29	17.15	17.15	2900.0
2014-08-07	ASHR	ETF	24.53	24.55	24.29	24.41	306200.0
2014-08-07	ASHS	ETF	29.16	29.18	29.07	29.07	2100.0
2014-08-07	ATMP	ETF	30.69	30.69	30.29	30.32	12300.0
2014-08-07	AVIV	ETF	27.13	27.45	27.07	27.36	112148.0
2014-08-07	AWAY	ETF	33.28	33.61	32.86	33.29	902805.0
2014-08-07	BAB	ETF	29.46	29.595	29.45	29.56	54463.0
2014-08-07	BAL	ETF	43.06	43.14	42.9899	43.0	2811.0
2014-08-07	BALT	ETF	5.2	5.2	4.98	5.08	347020.0
2014-08-07	BBH	ETF	97.53	97.53	95.83	96.08	42000.0
2014-08-07	BCHP	ETF	19.93	19.93	19.7599	19.76	1112.0
2014-08-07	BCM	ETF	40.03	40.03	40.03	40.03	937.0
2014-08-07	BFOR	ETF	7.6	7.6075	7.51	7.53	48800.0
2014-08-07	BIB	ETF	44.915	44.935	42.755	43.09	298990.0
2014-08-07	BICK	ETF	26.57	26.57	26.53	26.57	320.0
2014-08-07	BIL	ETF	91.5	91.52	91.5	91.52	115550.0
2014-08-07	BIS	ETF	573.6	601.112	573.6	596.8	6773.5
2014-08-07	BIV	ETF	84.59	84.84	84.51	84.8	253400.0
2014-08-07	BIZD	ETF	20.04	20.17	20.04	20.13	7400.0
2014-08-07	BJK	ETF	48.23	48.23	47.39	47.46	55800.0
2014-08-07	BKF	ETF	39.52	39.52	38.9808	39.13	84605.0
2014-08-07	BKLN	ETF	24.61	24.61	24.57	24.58	1702800.0

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

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