PREVIEW / etf_daily / 2014-08-15

all etf daily files

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

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-15	SPY	ETF	196.47	196.65	194.31	195.72	139951000.0
2014-08-15	QQQ	ETF	97.46	97.63	96.48	97.4	55205490.0
2014-08-15	IWM	ETF	114.45	114.45	112.26	113.39	53713800.0
2014-08-15	DIA	ETF	167.42	167.46	165.44	166.35	7032500.0
2014-08-15	GLD	ETF	124.52	126.07	124.41	125.48	13070500.0
2014-08-15	TLT	ETF	116.71	118.36	116.69	117.71	17606700.0
2014-08-15	AAXJ	ETF	65.72	65.83	65.16	65.44	595600.0
2014-08-15	ACWI	ETF	59.95	60.11	59.35	59.81	826100.0
2014-08-15	ACWV	ETF	67.46	67.47	66.97	67.27	15300.0
2014-08-15	ACWX	ETF	47.467	47.522	46.92	47.21	725624.0
2014-08-15	ADRE	ETF	41.79	41.9199	41.51	41.87	10762.0
2014-08-15	AFK	ETF	33.72	33.79	33.11	33.24	33037.0
2014-08-15	AGG	ETF	109.7	110.12	109.6	109.89	2593200.0
2014-08-15	AGQ	ETF	61.54	62.53	60.96	61.56	349700.0
2014-08-15	AGZ	ETF	112.75	112.97	112.65	112.865	77744.0
2014-08-15	AGZD	ETF	24.83	24.85	24.83	24.85	1400.0
2014-08-15	AIA	ETF	50.8582	50.88	50.43	50.607	14581.0
2014-08-15	AIQ	ETF	28.85	28.85	27.593	28.55	44161.0
2014-08-15	AIRR	ETF	18.91	18.92	18.59	18.73	60100.0
2014-08-15	AIVI	ETF	49.88	49.88	48.96	49.32	11000.0
2014-08-15	ALTL	ETF	35.3	35.3	35.3	35.3	255.0
2014-08-15	AMJ	ETF	52.76	53.06	52.505	52.94	727163.0
2014-08-15	AMLP	ETF	94.35	94.8	94.1	94.75	616440.0
2014-08-15	ANGL	ETF	28.06	28.06	28.06	28.06	200.0
2014-08-15	AOA	ETF	46.5	46.5	46.08	46.3	23600.0
2014-08-15	AOK	ETF	32.86	32.86	32.7386	32.79	31723.0
2014-08-15	AOM	ETF	35.34	35.402	35.24	35.3	22930.0
2014-08-15	AOR	ETF	40.0	40.06	39.774	39.95	20019.0
2014-08-15	ARGT	ETF	20.99	21.13	20.86	21.11	16800.0
2014-08-15	ASEA	ETF	17.5	17.51	17.44	17.46	18000.0
2014-08-15	ASHR	ETF	24.97	25.06	24.87	24.96	109000.0
2014-08-15	ASHS	ETF	30.37	30.37	30.18	30.22	7100.0
2014-08-15	ATMP	ETF	32.22	32.27	32.11	32.18	6300.0
2014-08-15	AVIV	ETF	27.99	28.08	27.69	27.86	204641.0
2014-08-15	AWAY	ETF	32.85	33.08	32.255	33.02	925223.0
2014-08-15	BAB	ETF	29.67	29.75	29.55	29.7	79323.0
2014-08-15	BAL	ETF	43.49	43.49	43.14	43.2064	5072.0
2014-08-15	BALT	ETF	5.94	6.0	5.71	5.84	237299.0
2014-08-15	BBH	ETF	102.04	102.52	100.43	102.12	74700.0
2014-08-15	BCHP	ETF	20.19	20.19	20.0022	20.0022	2629.0
2014-08-15	BCM	ETF	39.39	39.42	39.39	39.42	562.0
2014-08-15	BFOR	ETF	7.7175	7.7375	7.65	7.695	47600.0
2014-08-15	BIB	ETF	48.0	48.7099	46.7951	48.4	557104.0
2014-08-15	BICK	ETF	26.96	27.0099	26.8801	26.9788	744.0
2014-08-15	BIL	ETF	91.52	91.52	91.5	91.52	223000.0
2014-08-15	BIS	ETF	534.8	546.4	526.4	529.2	14132.5
2014-08-15	BIV	ETF	85.03	85.5	85.03	85.22	302900.0
2014-08-15	BIZD	ETF	20.29	20.32	20.24	20.28	12300.0
2014-08-15	BJK	ETF	48.84	49.05	48.35	48.69	7400.0
2014-08-15	BKF	ETF	40.56	40.63	40.2	40.53	100722.0

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

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