PREVIEW / etf_daily / 2014-05-16

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-16.parquet
  size:    43 KB
  rows:    1,076

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-05-16	SPY	ETF	187.51	188.13	186.72	188.05	97458000.0
2014-05-16	QQQ	ETF	87.24	87.76	86.64	87.71	66807315.0
2014-05-16	IWM	ETF	108.93	109.62	108.03	109.57	44666200.0
2014-05-16	DIA	ETF	164.16	164.64	163.77	164.61	5115000.0
2014-05-16	GLD	ETF	124.35	124.77	124.29	124.5	4052100.0
2014-05-16	TLT	ETF	113.61	114.0	113.42	113.54	5019200.0
2014-05-16	AADR	ETF	37.64	37.64	37.6	37.6	700.0
2014-05-16	AAXJ	ETF	61.21	61.79	61.21	61.77	303400.0
2014-05-16	ACWI	ETF	58.98	59.04	58.69	59.04	289600.0
2014-05-16	ACWV	ETF	65.62	65.88	65.35	65.88	50400.0
2014-05-16	ACWX	ETF	47.55	47.8	47.52	47.8	1718207.0
2014-05-16	ADRE	ETF	38.68	38.75	38.5199	38.628	5264.0
2014-05-16	AFK	ETF	33.2	33.2	32.9	33.065	15284.0
2014-05-16	AGG	ETF	109.22	109.35	109.17	109.2	558700.0
2014-05-16	AGQ	ETF	60.65	61.08	60.25	60.89	190700.0
2014-05-16	AGZ	ETF	112.1	112.47	111.981	112.41	13130.0
2014-05-16	AIA	ETF	47.73	47.989	47.73	47.989	2836.0
2014-05-16	AIQ	ETF	29.83	29.83	28.9101	29.47	20231.0
2014-05-16	AIRR	ETF	18.63	18.63	18.23	18.52	30400.0
2014-05-16	AIVI	ETF	50.97	50.97	50.7	50.95	31800.0
2014-05-16	ALTL	ETF	33.71	33.919	33.71	33.919	263.0
2014-05-16	AMJ	ETF	49.2	49.55	49.2	49.49	380654.0
2014-05-16	AMLP	ETF	90.5	90.7	90.3	90.55	491800.0
2014-05-16	ANGL	ETF	27.96	28.09	27.96	28.09	6000.0
2014-05-16	AOA	ETF	45.52	45.61	45.34	45.61	14300.0
2014-05-16	AOK	ETF	32.58	32.59	32.5	32.5799	6671.0
2014-05-16	AOM	ETF	34.91	35.03	34.906	35.03	43727.0
2014-05-16	AOR	ETF	39.31	39.37	39.22	39.36	33618.0
2014-05-16	ARGT	ETF	19.35	19.35	19.11	19.32	3600.0
2014-05-16	ASEA	ETF	16.7	16.83	16.7	16.83	5600.0
2014-05-16	ASHR	ETF	21.85	22.13	21.85	22.12	120100.0
2014-05-16	ATMP	ETF	29.69	29.72	29.64	29.68	26600.0
2014-05-16	AVIV	ETF	27.44	27.76	27.346	27.76	111823.0
2014-05-16	AWAY	ETF	31.1	31.1	30.24	30.65	932301.0
2014-05-16	BAB	ETF	29.34	29.34	29.1618	29.31	61172.0
2014-05-16	BAL	ETF	55.72	55.7319	55.31	55.31	4625.0
2014-05-16	BALT	ETF	6.2	6.34	6.17	6.32	318827.0
2014-05-16	BBH	ETF	87.8	87.8	86.31	87.45	54800.0
2014-05-16	BFOR	ETF	7.35	7.385	7.2975	7.3775	213200.0
2014-05-16	BIB	ETF	36.855	37.1112	35.705	36.665	378672.0
2014-05-16	BICK	ETF	25.39	25.5	25.39	25.49	1173.0
2014-05-16	BIL	ETF	91.52	91.54	91.52	91.54	62550.0
2014-05-16	BIS	ETF	727.96	748.8	727.008	729.2	10179.0
2014-05-16	BIV	ETF	84.63	84.72	84.57	84.62	181800.0
2014-05-16	BIZD	ETF	19.49	19.49	19.3	19.3	10600.0
2014-05-16	BJK	ETF	48.33	48.53	48.14	48.4	45900.0
2014-05-16	BKF	ETF	37.57	37.88	37.53	37.86	91876.0
2014-05-16	BKLN	ETF	24.76	24.78	24.75	24.77	1027100.0
2014-05-16	BLV	ETF	89.73	89.9	89.58	89.68	46800.0
2014-05-16	BMVP	ETF	23.31	23.3433	23.2234	23.3	5901.0

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

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