PREVIEW / etf_daily / 2014-06-11

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-11.parquet
  size:    44 KB
  rows:    1,085

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-06-11	SPY	ETF	194.9	195.12	194.48	194.92	68772000.0
2014-06-11	QQQ	ETF	92.59	93.02	92.5	92.89	22884331.0
2014-06-11	IWM	ETF	116.02	116.33	115.4	116.1	30144700.0
2014-06-11	DIA	ETF	168.75	168.81	168.09	168.35	3064100.0
2014-06-11	GLD	ETF	121.51	121.61	121.18	121.41	3572300.0
2014-06-11	TLT	ETF	111.26	111.54	110.85	111.22	5569700.0
2014-06-11	AADR	ETF	38.08	38.43	38.08	38.42	700.0
2014-06-11	AAXJ	ETF	62.92	63.01	62.79	62.93	240400.0
2014-06-11	ACWI	ETF	60.74	60.74	60.51	60.6	1150600.0
2014-06-11	ACWV	ETF	67.0	67.19	66.73	66.77	174500.0
2014-06-11	ACWX	ETF	48.64	48.66	48.54	48.58	206087.0
2014-06-11	ADRE	ETF	39.14	39.25	39.12	39.18	12307.0
2014-06-11	AFK	ETF	33.3999	33.4001	33.0401	33.23	59339.0
2014-06-11	AGG	ETF	108.73	108.78	108.64	108.7	1171200.0
2014-06-11	AGQ	ETF	59.94	59.94	59.36	59.64	116500.0
2014-06-11	AGZ	ETF	112.3	112.3	112.2142	112.25	12394.0
2014-06-11	AGZD	ETF	24.925	25.075	24.925	25.075	3200.0
2014-06-11	AIA	ETF	48.62	48.66	48.55	48.61	6448.0
2014-06-11	AIQ	ETF	29.85	30.46	29.292	29.85	22620.0
2014-06-11	AIRR	ETF	19.6	19.6	19.29	19.33	7700.0
2014-06-11	AIVI	ETF	51.5	51.5	51.25	51.33	15900.0
2014-06-11	AMJ	ETF	50.32	50.43	50.07	50.15	410430.0
2014-06-11	AMLP	ETF	92.4	92.55	92.05	92.3	434820.0
2014-06-11	ANGL	ETF	28.5	28.5	28.26	28.27	9000.0
2014-06-11	AOA	ETF	46.78	46.78	46.64	46.74	24700.0
2014-06-11	AOK	ETF	32.9	32.9	32.83	32.86	23445.0
2014-06-11	AOM	ETF	35.52	35.52	35.42	35.46	54611.0
2014-06-11	AOR	ETF	40.16	40.16	40.08	40.08	23985.0
2014-06-11	ARGT	ETF	21.3	21.46	21.1	21.19	4800.0
2014-06-11	ASEA	ETF	16.75	16.82	16.75	16.82	5200.0
2014-06-11	ASHR	ETF	22.22	22.22	22.13	22.15	77500.0
2014-06-11	ASHS	ETF	25.74	25.74	25.71	25.72	1900.0
2014-06-11	ATMP	ETF	30.18	30.19	29.99	30.05	28700.0
2014-06-11	AVIV	ETF	28.61	28.68	28.49	28.53	276341.0
2014-06-11	AWAY	ETF	29.4	29.82	29.16	29.75	1687485.0
2014-06-11	BAB	ETF	29.18	29.27	29.14	29.21	99763.0
2014-06-11	BAL	ETF	52.67	52.67	52.13	52.49	5072.0
2014-06-11	BALT	ETF	6.48	6.55	6.3	6.47	664908.0
2014-06-11	BBH	ETF	93.19	94.4	92.9	93.55	65900.0
2014-06-11	BCHP	ETF	20.4828	20.56	20.48	20.54	139767.0
2014-06-11	BCM	ETF	40.681	40.694	40.681	40.694	1001.0
2014-06-11	BFOR	ETF	7.7125	7.7325	7.6875	7.7075	165600.0
2014-06-11	BIB	ETF	42.865	44.1195	42.75	43.51	515894.0
2014-06-11	BICK	ETF	26.729	26.729	26.72	26.72	335.0
2014-06-11	BIL	ETF	91.52	91.54	91.52	91.52	64100.0
2014-06-11	BIS	ETF	620.8	620.8	601.6	609.6	7661.0
2014-06-11	BIV	ETF	83.99	84.11	83.95	84.06	172000.0
2014-06-11	BIZD	ETF	20.1	20.23	20.04	20.09	12100.0
2014-06-11	BJK	ETF	48.54	48.68	48.41	48.68	59800.0
2014-06-11	BKF	ETF	39.2	39.3	39.11	39.2135	37272.0

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

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