PREVIEW / etf_daily / 2014-07-17

all etf daily files

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

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-07-17	SPY	ETF	197.35	198.1	195.43	195.71	145398000.0
2014-07-17	QQQ	ETF	95.63	95.97	94.32	94.619	43111514.0
2014-07-17	IWM	ETF	113.52	114.27	112.2	112.48	62221500.0
2014-07-17	DIA	ETF	170.81	171.32	169.46	169.61	6149300.0
2014-07-17	GLD	ETF	125.52	127.55	125.11	127.09	11423900.0
2014-07-17	TLT	ETF	114.23	115.05	113.94	114.89	10901000.0
2014-07-17	AADR	ETF	38.61	38.65	38.42	38.42	3100.0
2014-07-17	AAXJ	ETF	63.55	63.87	63.07	63.11	375100.0
2014-07-17	ACWI	ETF	60.53	60.71	59.95	60.01	391000.0
2014-07-17	ACWV	ETF	67.29	67.44	66.86	66.96	30000.0
2014-07-17	ACWX	ETF	48.02	48.12	47.56	47.62	260601.0
2014-07-17	ADRE	ETF	40.22	40.22	39.75	39.75	8659.0
2014-07-17	AFK	ETF	33.44	33.66	33.26	33.31	26663.0
2014-07-17	AGG	ETF	109.22	109.38	109.12	109.34	1158400.0
2014-07-17	AGQ	ETF	69.76	72.41	69.2	71.85	441300.0
2014-07-17	AGZ	ETF	112.49	112.56	112.0801	112.54	6627.0
2014-07-17	AGZD	ETF	25.0	25.0	24.825	24.865	31800.0
2014-07-17	AIA	ETF	48.81	48.82	48.3	48.3	6180.0
2014-07-17	AIQ	ETF	28.69	28.98	27.74	28.05	27635.0
2014-07-17	AIRR	ETF	18.78	18.78	18.396	18.48	43300.0
2014-07-17	AIVI	ETF	50.38	50.54	50.01	50.01	10300.0
2014-07-17	ALTL	ETF	35.3999	35.3999	35.3999	35.3999	402.0
2014-07-17	AMJ	ETF	51.76	52.13	51.71	51.88	263939.0
2014-07-17	AMLP	ETF	94.45	94.85	94.25	94.6	653720.0
2014-07-17	ANGL	ETF	28.0	28.25	28.0	28.04	3700.0
2014-07-17	AOA	ETF	46.69	46.78	46.27	46.33	40300.0
2014-07-17	AOK	ETF	32.79	32.8799	32.76	32.76	20847.0
2014-07-17	AOM	ETF	35.43	35.43	35.24	35.25	36837.0
2014-07-17	AOR	ETF	40.05	40.17	39.877	39.88	37154.0
2014-07-17	ARGT	ETF	22.78	22.82	22.39	22.42	407900.0
2014-07-17	ASEA	ETF	17.21	17.27	17.13	17.13	11400.0
2014-07-17	ASHR	ETF	22.6	22.6	22.41	22.42	56900.0
2014-07-17	ASHS	ETF	27.16	27.22	27.12	27.12	4800.0
2014-07-17	ATMP	ETF	31.27	31.5	31.27	31.42	11800.0
2014-07-17	AVIV	ETF	28.09	28.2	28.01	28.11	109953.0
2014-07-17	AWAY	ETF	32.02	32.884	31.83	31.96	741929.0
2014-07-17	BAB	ETF	29.4	29.438	29.3	29.415	94230.0
2014-07-17	BAL	ETF	45.75	45.7699	45.37	45.65	6369.0
2014-07-17	BALT	ETF	5.35	5.395	5.26	5.27	459403.0
2014-07-17	BBH	ETF	93.27	94.18	91.45	91.67	137000.0
2014-07-17	BCHP	ETF	20.64	20.64	20.37	20.37	13075.0
2014-07-17	BCM	ETF	40.54	40.7656	40.47	40.61	32724.0
2014-07-17	BFOR	ETF	7.7425	7.8075	7.675	7.6825	116400.0
2014-07-17	BIB	ETF	42.46	43.655	41.1827	41.475	660188.0
2014-07-17	BICK	ETF	26.31	26.38	26.17	26.17	2908.0
2014-07-17	BIL	ETF	91.5	91.52	91.5	91.52	69450.0
2014-07-17	BIS	ETF	616.8	632.0	598.2	629.2	21633.0
2014-07-17	BIV	ETF	84.65	84.84	84.54	84.82	185900.0
2014-07-17	BIZD	ETF	20.47	20.48	20.27	20.29	15700.0
2014-07-17	BJK	ETF	49.53	49.75	49.02	49.14	72400.0

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

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