PREVIEW / etf_daily / 2014-11-13

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-13.parquet
  size:    46 KB
  rows:    1,140

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-11-13	SPY	ETF	204.16	204.83	203.21	204.19	85357900.0
2014-11-13	QQQ	ETF	102.65	103.28	102.42	102.9	28027776.0
2014-11-13	IWM	ETF	117.94	118.25	116.62	116.9	25135200.0
2014-11-13	DIA	ETF	176.25	176.98	175.79	176.44	6508400.0
2014-11-13	GLD	ETF	111.89	112.26	111.22	111.67	4874600.0
2014-11-13	TLT	ETF	118.7	119.18	118.44	118.91	4475900.0
2014-11-13	AAXJ	ETF	62.54	62.59	62.27	62.43	316600.0
2014-11-13	ACWI	ETF	59.67	59.82	59.39	59.63	1042200.0
2014-11-13	ACWV	ETF	69.44	69.68	69.31	69.46	96200.0
2014-11-13	ACWX	ETF	44.8	45.01	44.7	44.86	329858.0
2014-11-13	ADRE	ETF	38.75	38.75	38.2751	38.39	5419.0
2014-11-13	AFK	ETF	29.35	29.35	28.8301	28.8301	22172.0
2014-11-13	AGG	ETF	109.75	109.8	109.66	109.76	860800.0
2014-11-13	AGQ	ETF	38.72	38.82	38.01	38.18	129900.0
2014-11-13	AGZ	ETF	112.81	113.0	112.46	112.75	8718.0
2014-11-13	AGZD	ETF	24.725	24.8	24.72	24.72	9200.0
2014-11-13	AIA	ETF	47.98	47.995	47.8301	47.93	14073.0
2014-11-13	AIQ	ETF	22.05	22.275	21.89	21.96	17442.0
2014-11-13	AIRR	ETF	19.2	19.2	18.79	18.792	27700.0
2014-11-13	AIVI	ETF	45.7	45.76	45.5	45.61	12000.0
2014-11-13	AMJ	ETF	50.64	50.93	49.76	50.01	1745318.0
2014-11-13	AMLP	ETF	91.95	92.25	90.9	91.25	776780.0
2014-11-13	AMZA	ETF	246.7	246.7	241.4	241.55	800.0
2014-11-13	ANGL	ETF	27.74	27.91	27.68	27.74	8900.0
2014-11-13	AOA	ETF	46.43	46.67	46.39	46.52	51900.0
2014-11-13	AOK	ETF	32.7615	32.78	32.7	32.73	59386.0
2014-11-13	AOM	ETF	35.3	35.38	35.24	35.27	66656.0
2014-11-13	AOR	ETF	40.31	40.31	40.09	40.18	44520.0
2014-11-13	ARGT	ETF	20.87	20.87	20.6	20.67	19400.0
2014-11-13	ARKG	ETF	20.07	20.07	19.95	19.99	2500.0
2014-11-13	ARKK	ETF	20.4	20.42	20.3	20.34	11900.0
2014-11-13	ARKQ	ETF	20.149	20.149	20.084	20.084	1800.0
2014-11-13	ARKW	ETF	20.47	20.47	20.412	20.412	1500.0
2014-11-13	ASEA	ETF	16.68	16.74	16.68	16.73	9500.0
2014-11-13	ASHR	ETF	27.44	27.47	27.31	27.35	988400.0
2014-11-13	ASHS	ETF	34.03	34.03	33.6	33.66	11800.0
2014-11-13	ATMP	ETF	31.66	31.72	31.27	31.35	24500.0
2014-11-13	AVIV	ETF	33.3	33.66	33.3	33.31	522390.0
2014-11-13	AWAY	ETF	30.98	31.47	30.56	30.97	1796725.0
2014-11-13	BAB	ETF	29.82	29.96	29.81	29.9	64358.0
2014-11-13	BAL	ETF	40.999	41.0	39.921	40.0976	24328.0
2014-11-13	BALT	ETF	3.35	3.38	3.15	3.16	690103.0
2014-11-13	BAR	ETF	2.625	2.625	2.625	2.625	13450.0
2014-11-13	BBH	ETF	116.15	116.41	114.43	115.14	55700.0
2014-11-13	BCHP	ETF	18.4707	18.4707	18.42	18.45	1336.0
2014-11-13	BFOR	ETF	7.975	7.975	7.8875	7.9025	62800.0
2014-11-13	BIB	ETF	60.385	61.25	59.0	59.52	532096.0
2014-11-13	BICK	ETF	24.794	24.794	24.75	24.75	4424.0
2014-11-13	BIL	ETF	91.5	91.5	91.48	91.48	245250.0
2014-11-13	BIS	ETF	399.76	408.88	393.84	405.1488	21501.5

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

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