PREVIEW / etf_daily / 2014-06-23

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-23.parquet
  size:    44 KB
  rows:    1,101

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-06-23	SPY	ETF	195.99	196.05	195.52	195.88	70611000.0
2014-06-23	QQQ	ETF	92.735	92.82	92.51	92.79	20837926.0
2014-06-23	IWM	ETF	118.5	118.55	117.69	118.02	21388700.0
2014-06-23	DIA	ETF	169.06	169.12	168.58	168.91	2729200.0
2014-06-23	GLD	ETF	126.65	126.94	126.37	126.85	5142800.0
2014-06-23	TLT	ETF	112.08	112.18	111.41	111.45	5821700.0
2014-06-23	AADR	ETF	38.9	39.06	38.84	38.99	22700.0
2014-06-23	AAXJ	ETF	62.36	62.39	62.21	62.32	144300.0
2014-06-23	ACWI	ETF	61.16	61.26	60.96	61.15	657700.0
2014-06-23	ACWV	ETF	67.03	67.35	67.01	67.28	103300.0
2014-06-23	ACWX	ETF	48.93	49.02	48.8	49.02	968133.0
2014-06-23	ADRE	ETF	38.82	38.9399	38.67	38.85	17389.0
2014-06-23	AFK	ETF	32.96	32.96	32.65	32.79	14474.0
2014-06-23	AGG	ETF	108.99	109.02	108.84	108.84	559700.0
2014-06-23	AGQ	ETF	70.19	70.55	69.65	70.3	259500.0
2014-06-23	AGZ	ETF	112.42	112.49	112.2501	112.2501	4657.0
2014-06-23	AIA	ETF	47.878	48.0	47.8772	47.93	5884.0
2014-06-23	AIQ	ETF	28.31	28.67	26.82	27.95	56362.0
2014-06-23	AIRR	ETF	19.52	19.52	19.21	19.27	21700.0
2014-06-23	AIVI	ETF	50.97	51.05	50.76	51.05	29900.0
2014-06-23	AMJ	ETF	50.74	51.39	50.61	51.35	441026.0
2014-06-23	AMLP	ETF	92.8	93.6	92.5	93.55	561000.0
2014-06-23	ANGL	ETF	28.2	28.2	28.2	28.2	500.0
2014-06-23	AOA	ETF	47.2	47.2	47.04	47.13	25300.0
2014-06-23	AOK	ETF	33.07	33.07	33.0	33.02	34554.0
2014-06-23	AOM	ETF	35.72	35.72	35.625	35.67	33458.0
2014-06-23	AOR	ETF	40.46	40.49	40.354	40.4	24465.0
2014-06-23	ARGT	ETF	21.97	22.45	21.89	22.45	44400.0
2014-06-23	ASEA	ETF	16.61	16.69	16.61	16.69	9400.0
2014-06-23	ASHR	ETF	22.04	22.12	21.94	21.97	199300.0
2014-06-23	ASHS	ETF	25.72	25.72	25.34	25.35	6300.0
2014-06-23	ATMP	ETF	30.95	31.01	30.7	31.0	55300.0
2014-06-23	AVIV	ETF	29.03	29.25	28.9	28.99	289432.0
2014-06-23	AWAY	ETF	32.72	33.33	32.55	33.23	920933.0
2014-06-23	BAB	ETF	29.1	29.17	28.94	29.02	266640.0
2014-06-23	BAL	ETF	52.32	52.74	52.15	52.72	20753.0
2014-06-23	BALT	ETF	6.74	6.76	6.49	6.56	692503.0
2014-06-23	BBH	ETF	94.85	95.3	93.63	93.81	55600.0
2014-06-23	BCHP	ETF	20.6116	20.64	20.56	20.62	7300.0
2014-06-23	BFOR	ETF	7.83	7.84	7.8075	7.8175	48000.0
2014-06-23	BIB	ETF	45.82	46.24	44.7499	44.9	466790.0
2014-06-23	BICK	ETF	26.6	26.6	26.56	26.56	450.0
2014-06-23	BIL	ETF	91.52	91.54	91.52	91.54	143400.0
2014-06-23	BIS	ETF	574.8	590.4	573.2	590.0	7361.0
2014-06-23	BIV	ETF	84.35	84.35	84.21	84.23	135300.0
2014-06-23	BIZD	ETF	20.25	20.37	20.25	20.35	8200.0
2014-06-23	BJK	ETF	48.97	48.97	48.65	48.7	25500.0
2014-06-23	BKF	ETF	38.93	38.95	38.7101	38.9399	29383.0
2014-06-23	BKLN	ETF	24.85	24.86	24.84	24.85	2003700.0
2014-06-23	BLV	ETF	88.79	88.96	88.51	88.51	108600.0

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

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