PREVIEW / etf_daily / 2014-08-20

all etf daily files

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

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-20	SPY	ETF	198.12	199.16	198.08	198.92	72763000.0
2014-08-20	QQQ	ETF	98.61	98.9	98.53	98.7	23435596.0
2014-08-20	IWM	ETF	114.85	115.22	114.41	114.95	26266900.0
2014-08-20	DIA	ETF	168.72	169.74	168.72	169.6	3108800.0
2014-08-20	GLD	ETF	124.82	124.82	123.88	124.22	4395600.0
2014-08-20	TLT	ETF	116.04	116.11	115.57	115.99	7275600.0
2014-08-20	AADR	ETF	38.38	38.41	38.25	38.36	19500.0
2014-08-20	AAXJ	ETF	65.75	66.21	65.75	66.05	796300.0
2014-08-20	ACWI	ETF	60.31	60.55	60.29	60.5	1666400.0
2014-08-20	ACWV	ETF	67.7	68.01	67.7	68.0	18300.0
2014-08-20	ACWX	ETF	47.47	47.6245	47.4201	47.57	184912.0
2014-08-20	ADRE	ETF	42.68	42.82	42.561	42.81	17641.0
2014-08-20	AFK	ETF	33.49	33.62	33.3501	33.5	17570.0
2014-08-20	AGG	ETF	109.54	109.54	109.36	109.39	929500.0
2014-08-20	AGQ	ETF	61.18	61.4	60.42	60.87	79300.0
2014-08-20	AGZ	ETF	112.6	113.08	112.6	112.801	7761.0
2014-08-20	AGZD	ETF	24.905	24.915	24.815	24.85	28200.0
2014-08-20	AIA	ETF	51.11	51.22	51.02	51.14	49587.0
2014-08-20	AIQ	ETF	28.48	28.97	27.98	28.47	15184.0
2014-08-20	AIRR	ETF	19.09	19.09	18.96	19.02	16900.0
2014-08-20	AIVI	ETF	49.41	49.68	49.41	49.63	17100.0
2014-08-20	ALTL	ETF	35.68	35.68	35.68	35.68	303.0
2014-08-20	AMJ	ETF	53.25	53.7192	53.12	53.6	802782.0
2014-08-20	AMLP	ETF	94.85	95.45	94.75	95.4	535160.0
2014-08-20	ANGL	ETF	28.0	28.24	27.97	28.2	9400.0
2014-08-20	AOA	ETF	46.76	46.87	46.69	46.86	25800.0
2014-08-20	AOK	ETF	32.82	32.8702	32.81	32.85	13311.0
2014-08-20	AOM	ETF	35.458	35.5099	35.44	35.5	18305.0
2014-08-20	AOR	ETF	40.23	40.2899	40.194	40.26	18901.0
2014-08-20	ARGT	ETF	21.23	21.23	20.87	20.98	20900.0
2014-08-20	ASEA	ETF	17.44	17.49	17.44	17.49	11400.0
2014-08-20	ASHR	ETF	25.05	25.08	25.0	25.0	308300.0
2014-08-20	ASHS	ETF	30.73	30.84	30.66	30.68	7800.0
2014-08-20	ATMP	ETF	32.64	32.64	31.85	32.61	43300.0
2014-08-20	AVIV	ETF	28.25	28.49	28.06	28.49	91081.0
2014-08-20	AWAY	ETF	32.7	33.1	32.7	32.97	631371.0
2014-08-20	BAB	ETF	29.57	29.63	29.52	29.52	76440.0
2014-08-20	BAL	ETF	43.2299	44.4669	43.18	44.2628	18368.0
2014-08-20	BALT	ETF	5.84	5.93	5.69	5.78	340131.0
2014-08-20	BBH	ETF	103.2	103.87	102.74	103.1	50400.0
2014-08-20	BCHP	ETF	20.25	20.29	20.25	20.29	2084.0
2014-08-20	BCM	ETF	39.19	39.19	39.18	39.18	775.0
2014-08-20	BFOR	ETF	7.81	7.83	7.785	7.82	40000.0
2014-08-20	BIB	ETF	49.43	50.34	49.34	49.69	403774.0
2014-08-20	BICK	ETF	27.34	27.34	27.34	27.34	203.0
2014-08-20	BIL	ETF	91.5	91.52	91.5	91.5	63650.0
2014-08-20	BIS	ETF	516.8	520.0	507.2	515.6	8052.5
2014-08-20	BIV	ETF	85.0	85.0	84.8	84.87	265800.0
2014-08-20	BIZD	ETF	20.47	20.49	20.41	20.45	8300.0
2014-08-20	BJK	ETF	49.09	49.25	49.09	49.17	12500.0

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

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