PREVIEW / etf_daily / 2014-07-22

all etf daily files

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

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-22	SPY	ETF	198.01	198.56	197.87	198.2	67678000.0
2014-07-22	QQQ	ETF	96.44	96.76	96.345	96.61	25770404.0
2014-07-22	IWM	ETF	114.47	115.25	114.19	114.73	31326500.0
2014-07-22	DIA	ETF	170.56	170.96	170.43	170.74	3798200.0
2014-07-22	GLD	ETF	126.33	126.43	125.47	125.74	3882000.0
2014-07-22	TLT	ETF	115.09	115.46	114.65	115.33	5753200.0
2014-07-22	AADR	ETF	38.98	39.0	38.9	39.0	3200.0
2014-07-22	AAXJ	ETF	64.77	64.91	64.74	64.78	800400.0
2014-07-22	ACWI	ETF	60.76	60.86	60.69	60.75	2210600.0
2014-07-22	ACWV	ETF	67.42	67.57	67.36	67.53	81700.0
2014-07-22	ACWX	ETF	48.19	48.29	48.19	48.23	73824.0
2014-07-22	ADRE	ETF	41.19	41.3836	41.1801	41.35	20440.0
2014-07-22	AFK	ETF	33.52	33.71	33.42	33.6	50367.0
2014-07-22	AGG	ETF	109.38	109.45	109.28	109.44	724700.0
2014-07-22	AGQ	ETF	70.46	71.19	69.69	70.39	154400.0
2014-07-22	AGZ	ETF	112.4	112.55	112.4	112.438	5391.0
2014-07-22	AGZD	ETF	26.34	26.34	24.975	24.975	1400.0
2014-07-22	AIA	ETF	49.53	49.7	49.53	49.65	32826.0
2014-07-22	AIQ	ETF	28.7	29.15	28.18	28.52	52646.0
2014-07-22	AIRR	ETF	18.665	18.802	18.66	18.75	23600.0
2014-07-22	AIVI	ETF	50.77	50.79	50.52	50.52	114400.0
2014-07-22	ALTL	ETF	35.85	35.85	35.75	35.75	4325.0
2014-07-22	AMJ	ETF	52.22	52.54	52.22	52.47	489733.0
2014-07-22	AMLP	ETF	94.85	95.35	94.8	95.15	406060.0
2014-07-22	ANGL	ETF	28.23	28.23	28.0	28.08	5400.0
2014-07-22	AOA	ETF	46.89	46.95	46.84	46.89	26900.0
2014-07-22	AOK	ETF	32.94	32.94	32.8848	32.93	39440.0
2014-07-22	AOM	ETF	35.77	35.77	35.48	35.5	48527.0
2014-07-22	AOR	ETF	40.25	40.29	40.23	40.27	15409.0
2014-07-22	ARGT	ETF	22.54	22.64	22.14	22.3	16300.0
2014-07-22	ASEA	ETF	17.49	17.51	17.44	17.47	18700.0
2014-07-22	ASHR	ETF	22.96	23.15	22.94	23.12	396200.0
2014-07-22	ASHS	ETF	27.67	27.82	27.67	27.81	7100.0
2014-07-22	ATMP	ETF	31.87	31.87	31.74	31.84	71900.0
2014-07-22	AVIV	ETF	28.76	29.1	28.68	29.04	598473.0
2014-07-22	AWAY	ETF	32.77	33.455	32.56	33.13	947506.0
2014-07-22	BAB	ETF	29.55	29.605	29.44	29.59	73264.0
2014-07-22	BAL	ETF	46.06	46.1195	45.71	45.71	16280.0
2014-07-22	BALT	ETF	5.49	5.72	5.49	5.61	517268.0
2014-07-22	BBH	ETF	95.05	96.0	95.05	95.73	54800.0
2014-07-22	BCHP	ETF	20.81	20.86	20.786	20.86	1449.0
2014-07-22	BFOR	ETF	7.77	7.8275	7.77	7.8075	77600.0
2014-07-22	BIB	ETF	44.71	45.465	44.625	45.005	405704.0
2014-07-22	BICK	ETF	26.93	27.17	26.93	27.17	900.0
2014-07-22	BIL	ETF	91.52	91.52	91.5	91.5	347500.0
2014-07-22	BIS	ETF	581.2	581.2	569.6	575.6	9590.5
2014-07-22	BIV	ETF	84.79	84.81	84.63	84.81	155800.0
2014-07-22	BIZD	ETF	20.52	20.52	20.33	20.33	7600.0
2014-07-22	BJK	ETF	50.54	50.61	50.31	50.52	29100.0
2014-07-22	BKF	ETF	40.19	40.3599	40.0896	40.31	214356.0

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

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