PREVIEW / etf_daily / 2014-02-04

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-04.parquet
  size:    44 KB
  rows:    1,075

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-04	SPY	ETF	174.95	175.84	174.11	175.39	165012400.0
2014-02-04	QQQ	ETF	84.7	85.25	84.46	84.91	37801215.0
2014-02-04	IWM	ETF	109.19	109.95	108.4	109.47	53138100.0
2014-02-04	DIA	ETF	153.95	154.53	153.26	154.08	11853400.0
2014-02-04	GLD	ETF	120.41	121.09	120.39	120.99	7027400.0
2014-02-04	TLT	ETF	108.52	108.67	107.97	108.16	9573500.0
2014-02-04	AADR	ETF	35.99	35.99	35.99	35.99	400.0
2014-02-04	AAXJ	ETF	55.25	55.81	55.24	55.47	1003200.0
2014-02-04	ACWI	ETF	54.22	54.35	53.97	54.29	1608700.0
2014-02-04	ACWV	ETF	60.03	60.42	60.01	60.37	65000.0
2014-02-04	ACWX	ETF	43.28	43.49	43.2	43.43	2557176.0
2014-02-04	ADRE	ETF	33.11	33.56	33.11	33.425	18636.0
2014-02-04	AFK	ETF	29.32	29.87	29.3	29.835	35962.0
2014-02-04	AGG	ETF	107.96	108.08	107.88	107.97	2289000.0
2014-02-04	AGQ	ETF	61.77	63.12	61.77	62.77	495100.0
2014-02-04	AGZ	ETF	111.79	111.92	111.79	111.92	53686.0
2014-02-04	AIA	ETF	43.15	43.64	43.15	43.49	55015.0
2014-02-04	AIQ	ETF	28.13	28.27	27.65	27.95	29974.0
2014-02-04	AIVI	ETF	45.14	45.34	45.0	45.26	47100.0
2014-02-04	ALTL	ETF	31.51	31.51	31.51	31.51	693.0
2014-02-04	AMJ	ETF	46.3	46.45	45.87	46.0	367489.0
2014-02-04	AMLP	ETF	88.75	89.1	88.0	88.15	526300.0
2014-02-04	ANGL	ETF	26.7	26.92	26.7	26.91	3000.0
2014-02-04	AOA	ETF	42.6	42.75	42.43	42.67	21800.0
2014-02-04	AOK	ETF	31.55	31.62	31.54	31.59	57320.0
2014-02-04	AOM	ETF	33.65	33.67	33.562	33.63	34263.0
2014-02-04	AOR	ETF	37.27	37.4	37.2405	37.33	31108.0
2014-02-04	ARGT	ETF	17.07	17.07	16.82	16.9	3100.0
2014-02-04	ASEA	ETF	14.6	14.81	14.6	14.76	31400.0
2014-02-04	ASHR	ETF	22.5	22.9	22.5	22.8	209100.0
2014-02-04	ATMP	ETF	27.09	28.19	26.79	27.14	177900.0
2014-02-04	AVIV	ETF	23.93	24.1	23.69	23.99	315644.0
2014-02-04	AWAY	ETF	39.7	40.78	38.68	39.14	1269561.0
2014-02-04	BAB	ETF	28.2	28.2799	28.1601	28.26	258339.0
2014-02-04	BAL	ETF	53.72	53.8385	53.54	53.54	3143.0
2014-02-04	BALT	ETF	5.51	5.68	5.452	5.62	408629.0
2014-02-04	BBH	ETF	94.84	95.95	94.84	95.59	358700.0
2014-02-04	BCM	ETF	38.9	38.97	38.9	38.97	410526.0
2014-02-04	BFOR	ETF	6.995	7.0375	6.9525	7.0075	226800.0
2014-02-04	BIB	ETF	42.14	42.675	41.325	42.26	463046.0
2014-02-04	BICK	ETF	22.13	22.38	22.13	22.372	3065.0
2014-02-04	BIL	ETF	91.56	91.56	91.54	91.56	1322350.0
2014-02-04	BIS	ETF	720.8	725.6	706.4	714.4	2390.5
2014-02-04	BIV	ETF	83.56	83.64	83.5	83.61	167800.0
2014-02-04	BIZD	ETF	20.57	20.74	20.5	20.56	1800.0
2014-02-04	BJK	ETF	50.2	50.68	50.05	50.55	17000.0
2014-02-04	BKF	ETF	33.65	34.0799	33.61	33.97	62584.0
2014-02-04	BKLN	ETF	24.9	24.9	24.85	24.85	3199700.0
2014-02-04	BLV	ETF	85.78	85.87	85.52	85.74	202500.0
2014-02-04	BMVP	ETF	21.5047	21.6867	21.4603	21.6463	24319.0

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

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