PREVIEW / etf_daily / 2014-08-25

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-25.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-25	SPY	ETF	200.14	200.59	199.15	200.2	63855000.0
2014-08-25	QQQ	ETF	99.52	99.68	99.16	99.4	24124718.0
2014-08-25	IWM	ETF	115.96	116.41	115.32	115.75	27808600.0
2014-08-25	DIA	ETF	170.56	171.06	170.44	170.62	2588500.0
2014-08-25	GLD	ETF	122.92	123.04	122.72	122.74	5012400.0
2014-08-25	TLT	ETF	117.45	117.78	117.21	117.73	5760700.0
2014-08-25	AADR	ETF	38.28	38.43	38.28	38.36	7600.0
2014-08-25	AAXJ	ETF	65.82	65.95	65.78	65.93	125200.0
2014-08-25	ACWI	ETF	60.66	60.9	60.66	60.82	567000.0
2014-08-25	ACWV	ETF	67.93	68.13	67.88	68.07	17400.0
2014-08-25	ACWX	ETF	47.66	47.885	47.63	47.81	406368.0
2014-08-25	ADRE	ETF	42.77	42.77	42.54	42.72	26025.0
2014-08-25	AFK	ETF	33.21	33.39	33.21	33.34	13846.0
2014-08-25	AGG	ETF	109.69	109.69	109.52	109.65	3473800.0
2014-08-25	AGQ	ETF	60.26	60.34	59.7	59.95	123700.0
2014-08-25	AGZ	ETF	112.79	112.85	112.62	112.77	7033.0
2014-08-25	AGZD	ETF	24.85	25.14	24.825	24.895	47400.0
2014-08-25	AIA	ETF	50.9845	50.99	50.8938	50.8962	10980.0
2014-08-25	AIQ	ETF	28.44	29.18	28.29	28.47	23242.0
2014-08-25	AIRR	ETF	19.22	19.32	19.16	19.22	24900.0
2014-08-25	AIVI	ETF	49.64	49.92	49.64	49.85	8200.0
2014-08-25	ALTL	ETF	36.18	36.18	36.1	36.1	8158.0
2014-08-25	AMJ	ETF	53.39	53.74	53.16	53.68	364860.0
2014-08-25	AMLP	ETF	95.1	95.45	94.6	95.45	480080.0
2014-08-25	ANGL	ETF	28.07	28.07	28.05	28.05	1500.0
2014-08-25	AOA	ETF	47.03	47.08	46.99	47.0	14500.0
2014-08-25	AOK	ETF	32.98	32.98	32.93	32.96	16611.0
2014-08-25	AOM	ETF	35.54	35.6	35.53	35.5763	43147.0
2014-08-25	AOR	ETF	40.36	40.43	40.34	40.35	42820.0
2014-08-25	ARGT	ETF	20.96	21.14	20.92	21.03	14900.0
2014-08-25	ASEA	ETF	17.47	17.5	17.44	17.5	3300.0
2014-08-25	ASHR	ETF	24.75	24.79	24.65	24.71	614600.0
2014-08-25	ASHS	ETF	30.82	30.82	30.59	30.61	12900.0
2014-08-25	ATMP	ETF	32.62	32.62	32.31	32.53	22200.0
2014-08-25	AVIV	ETF	28.47	28.47	27.9	28.08	131199.0
2014-08-25	AWAY	ETF	33.18	33.685	32.79	33.65	1283107.0
2014-08-25	BAB	ETF	29.73	29.7849	29.66	29.75	90647.0
2014-08-25	BAL	ETF	44.49	44.63	43.74	44.63	62197.0
2014-08-25	BALT	ETF	5.9	6.0	5.76	5.8	288669.0
2014-08-25	BAR	ETF	3.598	3.601	3.585	3.589	21560.0
2014-08-25	BBH	ETF	103.97	105.34	103.95	105.28	194200.0
2014-08-25	BCHP	ETF	20.4026	20.4026	20.352	20.352	300.0
2014-08-25	BCM	ETF	39.191	39.2	39.16	39.16	2508.0
2014-08-25	BFOR	ETF	7.87	7.8875	7.8575	7.8725	70800.0
2014-08-25	BIB	ETF	50.545	51.9	50.4	51.79	549388.0
2014-08-25	BICK	ETF	27.125	27.1948	27.125	27.154	876.0
2014-08-25	BIL	ETF	91.5	91.52	91.5	91.52	587300.0
2014-08-25	BIS	ETF	510.4	510.4	490.8	492.0	15871.5
2014-08-25	BIV	ETF	84.94	85.0	84.84	84.93	348500.0
2014-08-25	BIZD	ETF	20.45	20.54	20.44	20.49	4700.0

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

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