PREVIEW / etf_daily / 2014-07-15

all etf daily files

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

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-15	SPY	ETF	197.72	198.1	196.36	197.23	111307000.0
2014-07-15	QQQ	ETF	95.98	96.13	94.83	95.51	39480119.0
2014-07-15	IWM	ETF	115.56	116.0	113.87	114.55	49534700.0
2014-07-15	DIA	ETF	170.51	170.91	169.78	170.38	5168100.0
2014-07-15	GLD	ETF	125.89	126.32	124.36	124.53	10541700.0
2014-07-15	TLT	ETF	112.83	113.47	112.5	112.86	7720000.0
2014-07-15	AADR	ETF	38.91	38.96	38.78	38.8	7300.0
2014-07-15	AAXJ	ETF	63.92	63.97	63.54	63.83	215000.0
2014-07-15	ACWI	ETF	60.65	60.73	60.23	60.46	614400.0
2014-07-15	ACWV	ETF	67.26	67.34	66.96	67.04	183700.0
2014-07-15	ACWX	ETF	48.06	48.1599	47.77	47.97	316610.0
2014-07-15	ADRE	ETF	40.4	40.471	40.15	40.46	12743.0
2014-07-15	AFK	ETF	33.25	33.41	33.07	33.07	31118.0
2014-07-15	AGG	ETF	108.99	109.16	108.9	108.93	660200.0
2014-07-15	AGQ	ETF	70.35	71.42	68.43	68.94	552900.0
2014-07-15	AGZ	ETF	112.3201	112.43	112.3201	112.3301	16069.0
2014-07-15	AGZD	ETF	24.975	25.065	24.97	25.065	20200.0
2014-07-15	AIA	ETF	48.88	49.02	48.7275	48.8535	24274.0
2014-07-15	AIQ	ETF	28.54	29.39	28.4	28.86	50662.0
2014-07-15	AIRR	ETF	19.1	19.1	18.73	18.78	10200.0
2014-07-15	AIVI	ETF	50.43	50.5	50.09	50.3	35400.0
2014-07-15	ALTL	ETF	35.69	35.69	35.69	35.69	1396.0
2014-07-15	AMJ	ETF	51.46	51.56	51.2901	51.5	528335.0
2014-07-15	AMLP	ETF	93.95	94.05	93.5	93.95	393660.0
2014-07-15	ANGL	ETF	28.12	28.12	28.08	28.12	800.0
2014-07-15	AOA	ETF	46.87	46.87	46.55	46.7	74700.0
2014-07-15	AOK	ETF	32.85	32.91	32.8	32.85	37258.0
2014-07-15	AOM	ETF	35.49	35.5	35.34	35.4	41647.0
2014-07-15	AOR	ETF	40.24	40.24	40.01	40.11	28296.0
2014-07-15	ARGT	ETF	23.34	23.34	22.54	22.55	31800.0
2014-07-15	ASEA	ETF	17.29	17.29	17.17	17.24	12000.0
2014-07-15	ASHR	ETF	22.74	22.74	22.65	22.69	99100.0
2014-07-15	ASHS	ETF	27.47	27.48	27.46	27.48	5800.0
2014-07-15	ATMP	ETF	31.15	31.2	31.06	31.19	14500.0
2014-07-15	AVIV	ETF	27.9	28.08	27.78	28.07	294789.0
2014-07-15	AWAY	ETF	33.07	33.11	32.15	32.47	877060.0
2014-07-15	BAB	ETF	29.29	29.3499	29.2	29.24	117766.0
2014-07-15	BAL	ETF	45.8	45.938	45.5	45.8	6369.0
2014-07-15	BALT	ETF	5.32	5.32	5.13	5.2	502374.0
2014-07-15	BBH	ETF	97.3	97.53	94.75	95.02	74100.0
2014-07-15	BCHP	ETF	20.65	20.65	20.6199	20.6199	640.0
2014-07-15	BCM	ETF	40.25	40.38	40.191	40.3799	2352.0
2014-07-15	BFOR	ETF	7.8325	7.8325	7.74	7.78	43200.0
2014-07-15	BIB	ETF	46.905	47.0	44.165	44.65	686892.0
2014-07-15	BICK	ETF	26.32	26.33	26.29	26.31	1556.0
2014-07-15	BIL	ETF	91.5	91.52	91.5	91.52	122150.0
2014-07-15	BIS	ETF	560.4	591.16	558.24	586.8	20683.0
2014-07-15	BIV	ETF	84.42	84.6	84.31	84.44	244100.0
2014-07-15	BIZD	ETF	20.53	20.59	20.53	20.55	4100.0
2014-07-15	BJK	ETF	50.01	50.01	49.76	49.76	3100.0

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

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