PREVIEW / etf_daily / 2014-11-26

all etf daily files

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

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-26	SPY	ETF	207.29	207.76	207.03	207.64	62167800.0
2014-11-26	QQQ	ETF	104.94	105.58	104.834	105.52	18973804.0
2014-11-26	IWM	ETF	118.07	118.5	117.84	118.45	14640700.0
2014-11-26	DIA	ETF	177.96	178.09	177.65	178.01	3005600.0
2014-11-26	GLD	ETF	115.25	115.34	114.98	115.16	3184000.0
2014-11-26	TLT	ETF	121.64	121.87	121.47	121.53	4339100.0
2014-11-26	AADR	ETF	38.89	38.89	38.38	38.38	600.0
2014-11-26	AAXJ	ETF	63.12	63.48	63.12	63.45	866600.0
2014-11-26	ACWI	ETF	60.67	60.82	60.62	60.8	720400.0
2014-11-26	ACWV	ETF	69.9	70.11	69.88	70.11	68600.0
2014-11-26	ACWX	ETF	45.78	45.88	45.7	45.88	172652.0
2014-11-26	ADRE	ETF	39.74	39.94	39.74	39.84	6074.0
2014-11-26	AFK	ETF	29.15	29.2	29.04	29.1655	11794.0
2014-11-26	AGG	ETF	110.33	110.34	110.24	110.27	1205700.0
2014-11-26	AGQ	ETF	43.0	43.37	42.63	42.78	81300.0
2014-11-26	AGZ	ETF	113.0	113.46	113.0	113.25	12490.0
2014-11-26	AGZD	ETF	24.765	24.77	24.695	24.76	9800.0
2014-11-26	AIA	ETF	48.11	48.425	48.11	48.358	12558.0
2014-11-26	AIQ	ETF	22.5	22.65	22.31	22.59	7004.0
2014-11-26	AIRR	ETF	19.26	19.26	18.995	19.05	152800.0
2014-11-26	AIVI	ETF	46.28	46.54	46.28	46.54	8900.0
2014-11-26	AMJ	ETF	50.97	51.4	50.48	51.33	1440991.0
2014-11-26	AMLP	ETF	93.15	93.7	92.45	93.7	727120.0
2014-11-26	AMZA	ETF	249.1	250.5	249.1	250.5	180.0
2014-11-26	ANGL	ETF	27.68	27.68	27.43	27.63	2400.0
2014-11-26	AOA	ETF	47.23	47.27	47.13	47.27	20000.0
2014-11-26	AOK	ETF	33.0	33.0	32.9401	33.0	42379.0
2014-11-26	AOM	ETF	35.5947	35.66	35.5947	35.66	55111.0
2014-11-26	AOR	ETF	40.62	40.71	40.62	40.69	269915.0
2014-11-26	ARGT	ETF	21.34	21.57	21.34	21.55	27600.0
2014-11-26	ARKG	ETF	20.21	20.21	20.21	20.21	500.0
2014-11-26	ARKK	ETF	20.53	20.56	20.53	20.56	900.0
2014-11-26	ARKQ	ETF	20.46	20.46	20.46	20.46	300.0
2014-11-26	ARKW	ETF	20.6	20.62	20.6	20.602	7100.0
2014-11-26	ASEA	ETF	16.99	17.06	16.92	17.02	12300.0
2014-11-26	ASHR	ETF	30.45	30.65	29.32	29.59	2202700.0
2014-11-26	ASHS	ETF	35.53	35.95	35.53	35.83	18800.0
2014-11-26	ATMP	ETF	31.82	32.33	31.77	32.22	19700.0
2014-11-26	AVIV	ETF	33.22	33.39	33.13	33.3	940849.0
2014-11-26	AWAY	ETF	31.16	31.81	31.01	31.58	797303.0
2014-11-26	BAB	ETF	30.05	30.0699	29.88	30.0	103083.0
2014-11-26	BAL	ETF	40.81	41.1801	40.75	40.89	6288.0
2014-11-26	BALT	ETF	3.45	3.48	3.35	3.48	351700.0
2014-11-26	BAR	ETF	2.917	2.917	2.863	2.863	10870.0
2014-11-26	BBH	ETF	115.87	116.85	115.78	116.77	62900.0
2014-11-26	BCHP	ETF	19.1	19.13	19.02	19.13	30150.0
2014-11-26	BCM	ETF	35.353	35.353	35.353	35.353	1837.0
2014-11-26	BFOR	ETF	7.9825	7.9925	7.975	7.99	20400.0
2014-11-26	BIB	ETF	61.985	63.445	61.7	63.44	298192.0
2014-11-26	BICK	ETF	25.43	25.43	25.43	25.43	408.0

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

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