PREVIEW / etf_daily / 2014-05-06

all etf daily files

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

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-05-06	SPY	ETF	188.0	188.13	186.74	186.78	85454000.0
2014-05-06	QQQ	ETF	87.83	87.86	86.77	86.81	33698549.0
2014-05-06	IWM	ETF	111.41	111.71	109.99	110.07	45354700.0
2014-05-06	DIA	ETF	164.66	164.68	163.68	163.73	5281500.0
2014-05-06	GLD	ETF	126.02	126.11	125.63	125.98	3488000.0
2014-05-06	TLT	ETF	112.11	112.7	112.04	112.48	6522600.0
2014-05-06	AADR	ETF	37.78	37.78	37.69	37.69	900.0
2014-05-06	AAXJ	ETF	59.47	59.92	59.47	59.67	176300.0
2014-05-06	ACWI	ETF	58.69	58.79	58.49	58.5	501700.0
2014-05-06	ACWV	ETF	65.41	65.45	65.03	65.12	36200.0
2014-05-06	ACWX	ETF	47.28	47.43	47.27	47.28	240618.0
2014-05-06	ADRE	ETF	37.54	38.0	37.54	37.87	11768.0
2014-05-06	AFK	ETF	33.24	33.26	32.87	33.089	9635.0
2014-05-06	AGG	ETF	108.69	108.73	108.62	108.72	786800.0
2014-05-06	AGQ	ETF	62.82	62.84	62.05	62.21	140500.0
2014-05-06	AGZ	ETF	112.08	112.16	111.987	112.11	12285.0
2014-05-06	AGZD	ETF	25.1	25.1	25.1	25.1	400.0
2014-05-06	AIA	ETF	46.5	46.68	46.48	46.61	7880.0
2014-05-06	AIQ	ETF	28.73	29.24	28.11	28.5	35983.0
2014-05-06	AIRR	ETF	18.9	18.93	18.67	18.72	22200.0
2014-05-06	AIVI	ETF	50.51	50.51	50.09	50.28	20800.0
2014-05-06	ALTL	ETF	33.768	33.768	33.71	33.71	284.0
2014-05-06	AMJ	ETF	49.45	49.6	49.01	49.24	1590225.0
2014-05-06	AMLP	ETF	90.75	90.9	90.1	90.4	538440.0
2014-05-06	ANGL	ETF	27.63	27.63	27.63	27.63	300.0
2014-05-06	AOA	ETF	45.3	45.46	45.24	45.28	16100.0
2014-05-06	AOK	ETF	32.52	32.52	32.418	32.418	8574.0
2014-05-06	AOM	ETF	34.89	34.91	34.8	34.8	25796.0
2014-05-06	AOR	ETF	39.08	39.24	39.08	39.11	24460.0
2014-05-06	ARGT	ETF	20.12	20.17	19.98	20.02	19800.0
2014-05-06	ASEA	ETF	16.52	16.55	16.48	16.49	2000.0
2014-05-06	ASHR	ETF	21.95	22.08	21.91	21.99	32400.0
2014-05-06	ATMP	ETF	29.55	32.33	29.38	32.33	68900.0
2014-05-06	AVIV	ETF	26.84	27.1161	26.636	26.86	253025.0
2014-05-06	AWAY	ETF	32.94	33.31	31.68	31.78	1602131.0
2014-05-06	BAB	ETF	29.24	29.3	29.15	29.2602	89939.0
2014-05-06	BAL	ETF	58.15	58.27	58.0101	58.02	4147.0
2014-05-06	BALT	ETF	6.17	6.28	5.99	6.01	461750.0
2014-05-06	BBH	ETF	88.31	88.75	87.27	87.29	49000.0
2014-05-06	BCHP	ETF	20.11	20.11	20.07	20.07	6535.0
2014-05-06	BCM	ETF	41.34	41.34	41.3	41.31	700.0
2014-05-06	BFOR	ETF	7.48	7.485	7.3975	7.4075	108800.0
2014-05-06	BIB	ETF	37.835	38.48	36.975	37.065	407272.0
2014-05-06	BICK	ETF	24.6799	24.725	24.585	24.725	1223.0
2014-05-06	BIL	ETF	91.54	91.54	91.52	91.52	74800.0
2014-05-06	BIS	ETF	705.6	728.776	701.08	726.8	8126.5
2014-05-06	BIV	ETF	83.92	84.0	83.87	83.99	204100.0
2014-05-06	BIZD	ETF	19.78	19.78	19.59	19.66	23300.0
2014-05-06	BJK	ETF	50.63	50.69	50.16	50.34	8600.0
2014-05-06	BKF	ETF	36.07	36.48	36.07	36.3	63154.0

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

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