PREVIEW / etf_daily / 2014-08-26

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-26.parquet
  size:    45 KB
  rows:    1,116

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-08-26	SPY	ETF	200.33	200.82	200.28	200.33	47298000.0
2014-08-26	QQQ	ETF	99.53	99.61	99.27	99.5	20100350.0
2014-08-26	IWM	ETF	115.88	116.92	115.8	116.8	34831700.0
2014-08-26	DIA	ETF	170.82	171.35	170.78	170.93	3581400.0
2014-08-26	GLD	ETF	123.92	123.97	123.28	123.35	3882300.0
2014-08-26	TLT	ETF	117.94	117.99	117.21	117.35	5487600.0
2014-08-26	AADR	ETF	38.61	38.66	38.43	38.6	6700.0
2014-08-26	AAXJ	ETF	65.98	66.16	65.93	66.12	443900.0
2014-08-26	ACWI	ETF	60.83	61.03	60.83	60.89	692800.0
2014-08-26	ACWV	ETF	68.18	68.18	67.9	67.9	36600.0
2014-08-26	ACWX	ETF	47.81	48.0098	47.81	47.89	161901.0
2014-08-26	ADRE	ETF	42.87	43.1	42.87	43.1	32009.0
2014-08-26	AFK	ETF	33.39	33.44	33.33	33.39	13588.0
2014-08-26	AGG	ETF	109.73	109.73	109.61	109.66	543400.0
2014-08-26	AGQ	ETF	61.27	61.4	60.05	60.11	159100.0
2014-08-26	AGZ	ETF	113.24	113.24	112.3701	112.75	7279.0
2014-08-26	AGZD	ETF	25.09	25.09	25.09	25.09	1400.0
2014-08-26	AIA	ETF	50.9	50.99	50.8701	50.95	18581.0
2014-08-26	AIQ	ETF	28.38	28.41	27.77	27.89	18918.0
2014-08-26	AIRR	ETF	19.22	19.46	19.22	19.43	93000.0
2014-08-26	AIVI	ETF	49.76	49.94	49.76	49.82	68700.0
2014-08-26	ALTL	ETF	36.22	36.22	36.22	36.22	1201.0
2014-08-26	AMJ	ETF	53.08	53.36	53.0	53.21	948639.0
2014-08-26	AMLP	ETF	95.5	95.75	95.3	95.65	472600.0
2014-08-26	ANGL	ETF	28.25	28.26	28.05	28.21	9700.0
2014-08-26	AOA	ETF	47.11	47.2	47.08	47.11	31100.0
2014-08-26	AOK	ETF	32.95	33.01	32.95	32.98	10977.0
2014-08-26	AOM	ETF	35.65	35.66	35.61	35.61	31872.0
2014-08-26	AOR	ETF	40.45	40.4999	40.43	40.46	43601.0
2014-08-26	ARGT	ETF	21.15	21.15	20.86	20.9	21200.0
2014-08-26	ASEA	ETF	17.45	17.53	17.45	17.53	2100.0
2014-08-26	ASHR	ETF	24.54	24.6	24.5	24.58	1200300.0
2014-08-26	ASHS	ETF	30.17	30.18	30.09	30.09	6900.0
2014-08-26	ATMP	ETF	32.33	32.38	32.31	32.31	57400.0
2014-08-26	AVIV	ETF	28.1	28.2	28.02	28.13	122110.0
2014-08-26	AWAY	ETF	33.55	34.42	33.32	34.11	1164479.0
2014-08-26	BAB	ETF	29.8	29.813	29.69	29.71	133853.0
2014-08-26	BAL	ETF	44.47	45.98	44.47	45.7	22645.0
2014-08-26	BALT	ETF	5.86	5.86	5.73	5.82	235861.0
2014-08-26	BAR	ETF	3.592	3.683	3.592	3.657	240320.0
2014-08-26	BBH	ETF	105.68	106.55	105.19	106.4	96400.0
2014-08-26	BCHP	ETF	20.38	20.38	20.37	20.37	1201.0
2014-08-26	BFOR	ETF	7.89	7.9075	7.88	7.8925	60800.0
2014-08-26	BIB	ETF	52.22	53.3	51.765	53.05	443636.0
2014-08-26	BICK	ETF	27.38	27.4583	27.375	27.42	3300.0
2014-08-26	BIL	ETF	91.5	91.52	91.5	91.52	100350.0
2014-08-26	BIS	ETF	488.0	494.4	478.0	479.2	13072.0
2014-08-26	BIV	ETF	85.1	85.1	84.97	85.03	155300.0
2014-08-26	BIZD	ETF	20.51	20.51	20.42	20.49	8100.0
2014-08-26	BJK	ETF	48.9	48.9	48.43	48.48	4500.0

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

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