PREVIEW / etf_daily / 2014-02-19

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-19.parquet
  size:    43 KB
  rows:    1,069

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-02-19	SPY	ETF	183.76	184.95	182.87	183.02	126524300.0
2014-02-19	QQQ	ETF	90.07	90.285	89.45	89.63	41775267.0
2014-02-19	IWM	ETF	114.9	115.64	113.98	114.07	44024300.0
2014-02-19	DIA	ETF	161.02	162.34	160.38	160.52	8245400.0
2014-02-19	GLD	ETF	127.26	127.45	126.16	126.27	9384100.0
2014-02-19	TLT	ETF	107.18	107.18	106.3	106.37	5522500.0
2014-02-19	AADR	ETF	37.65	37.65	37.51	37.51	1700.0
2014-02-19	AAXJ	ETF	57.47	57.81	57.32	57.52	456200.0
2014-02-19	ACWI	ETF	57.2	57.4	56.86	56.91	1450100.0
2014-02-19	ACWV	ETF	62.82	63.04	62.64	62.64	134000.0
2014-02-19	ACWX	ETF	46.01	46.14	45.71	45.76	164585.0
2014-02-19	ADRE	ETF	34.81	35.057	34.81	34.873	10606.0
2014-02-19	AFK	ETF	30.67	30.91	30.35	30.61	13233.0
2014-02-19	AGG	ETF	107.97	108.06	107.73	107.76	902600.0
2014-02-19	AGQ	ETF	78.59	78.96	75.25	76.0	809300.0
2014-02-19	AGZ	ETF	111.82	111.9	111.76	111.76	51363.0
2014-02-19	AGZD	ETF	25.04	25.04	25.04	25.04	600.0
2014-02-19	AIA	ETF	44.92	45.15	44.81	44.85	12173.0
2014-02-19	AIQ	ETF	29.81	32.416	29.81	30.34	50535.0
2014-02-19	AIVI	ETF	48.43	48.65	48.18	48.18	13200.0
2014-02-19	AMJ	ETF	47.36	47.72	46.805	46.84	641516.0
2014-02-19	AMLP	ETF	88.5	88.6	87.7	87.85	574580.0
2014-02-19	ANGL	ETF	27.42	27.46	27.39	27.46	2900.0
2014-02-19	AOA	ETF	44.64	44.78	44.41	44.42	38600.0
2014-02-19	AOK	ETF	32.14	32.24	32.07	32.07	23074.0
2014-02-19	AOM	ETF	34.41	34.53	34.3401	34.39	25465.0
2014-02-19	AOR	ETF	38.65	38.73	38.46	38.47	14468.0
2014-02-19	ARGT	ETF	19.0	19.14	18.33	18.33	4800.0
2014-02-19	ASEA	ETF	15.44	15.49	15.4	15.41	4300.0
2014-02-19	ASHR	ETF	23.97	24.09	23.92	24.0	132200.0
2014-02-19	ATMP	ETF	27.95	27.95	27.57	27.57	18600.0
2014-02-19	AVIV	ETF	23.84	24.15	23.81	23.97	79560.0
2014-02-19	AWAY	ETF	42.18	43.44	42.18	42.96	2586964.0
2014-02-19	BAB	ETF	28.36	28.37	28.225	28.28	133061.0
2014-02-19	BAL	ETF	55.697	55.87	54.7	54.83	11844.0
2014-02-19	BALT	ETF	6.37	6.39	6.04	6.04	463319.0
2014-02-19	BBH	ETF	103.67	103.73	101.89	102.09	425700.0
2014-02-19	BCM	ETF	40.918	40.918	40.918	40.918	315.0
2014-02-19	BFOR	ETF	7.415	7.4525	7.3575	7.3575	272000.0
2014-02-19	BIB	ETF	50.75	50.95	49.285	49.475	557838.0
2014-02-19	BICK	ETF	22.97	22.97	22.97	22.97	1763.0
2014-02-19	BIL	ETF	91.56	91.56	91.54	91.56	140100.0
2014-02-19	BIS	ETF	594.0	603.2	582.8	601.6	2426.5
2014-02-19	BIV	ETF	83.73	83.73	83.41	83.46	210500.0
2014-02-19	BIZD	ETF	21.46	21.49	21.18	21.21	20800.0
2014-02-19	BJK	ETF	52.15	52.32	51.76	51.82	18000.0
2014-02-19	BKF	ETF	34.75	35.1	34.75	34.92	57559.0
2014-02-19	BKLN	ETF	24.82	24.83	24.81	24.82	3282400.0
2014-02-19	BLV	ETF	85.38	85.38	84.7	84.85	199000.0
2014-02-19	BMVP	ETF	22.8633	22.8633	22.6467	22.6478	4630.0

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

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