PREVIEW / etf_daily / 2014-05-13

all etf daily files

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

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-13	SPY	ETF	190.04	190.42	189.77	189.96	66454000.0
2014-05-13	QQQ	ETF	88.32	88.61	88.12	88.29	30311862.0
2014-05-13	IWM	ETF	112.38	112.85	111.34	111.43	58122800.0
2014-05-13	DIA	ETF	167.1	167.29	166.95	167.05	4133400.0
2014-05-13	GLD	ETF	124.79	125.1	124.5	124.6	2643500.0
2014-05-13	TLT	ETF	111.44	111.75	111.33	111.75	5501000.0
2014-05-13	AADR	ETF	38.25	38.25	37.82	37.86	2100.0
2014-05-13	AAXJ	ETF	60.61	60.88	60.54	60.76	202100.0
2014-05-13	ACWI	ETF	59.36	59.4	59.28	59.32	2999700.0
2014-05-13	ACWV	ETF	65.57	65.86	65.57	65.86	29500.0
2014-05-13	ACWX	ETF	47.73	47.81	47.7	47.78	153359.0
2014-05-13	ADRE	ETF	38.53	38.73	38.4522	38.56	10350.0
2014-05-13	AFK	ETF	33.06	33.4832	33.01	33.36	49110.0
2014-05-13	AGG	ETF	108.76	108.8	108.72	108.78	577500.0
2014-05-13	AGQ	ETF	62.06	62.36	61.75	61.93	50700.0
2014-05-13	AGZ	ETF	112.08	112.2	112.048	112.11	12086.0
2014-05-13	AGZD	ETF	25.05	25.05	25.04	25.04	3000.0
2014-05-13	AIA	ETF	47.29	47.41	47.14	47.41	25125.0
2014-05-13	AIQ	ETF	30.9	31.15	30.11	30.19	28022.0
2014-05-13	AIRR	ETF	19.16	19.19	18.96	18.99	45700.0
2014-05-13	AIVI	ETF	50.82	50.83	50.59	50.81	11700.0
2014-05-13	AMJ	ETF	49.22	49.4999	48.9	48.98	682598.0
2014-05-13	AMLP	ETF	90.45	90.5	89.9	90.0	727400.0
2014-05-13	ANGL	ETF	27.88	27.9	27.88	27.9	10400.0
2014-05-13	AOA	ETF	45.93	45.93	45.8	45.83	22600.0
2014-05-13	AOK	ETF	32.57	32.629	32.57	32.58	28643.0
2014-05-13	AOM	ETF	35.089	35.11	35.05	35.09	21900.0
2014-05-13	AOR	ETF	39.46	39.5538	39.46	39.5	28660.0
2014-05-13	ARGT	ETF	19.98	19.99	19.89	19.9	7900.0
2014-05-13	ASEA	ETF	16.55	16.58	16.51	16.55	7100.0
2014-05-13	ASHR	ETF	22.31	22.32	22.24	22.31	41400.0
2014-05-13	ATMP	ETF	29.71	29.71	29.3	29.35	17400.0
2014-05-13	AVIV	ETF	27.21	27.44	27.16	27.2	202230.0
2014-05-13	AWAY	ETF	31.98	32.23	31.27	31.97	1525021.0
2014-05-13	BAB	ETF	29.15	29.22	29.1045	29.17	83327.0
2014-05-13	BAL	ETF	55.81	56.24	55.81	56.118	4275.0
2014-05-13	BALT	ETF	6.22	6.28	6.18	6.23	130257.0
2014-05-13	BBH	ETF	89.25	89.5	88.21	88.25	70100.0
2014-05-13	BCHP	ETF	20.2501	20.28	20.2	20.28	1431.0
2014-05-13	BCM	ETF	41.33	41.37	41.28	41.37	1686.0
2014-05-13	BFOR	ETF	7.5375	7.5375	7.47	7.47	147200.0
2014-05-13	BIB	ETF	38.155	38.53	37.325	37.35	600772.0
2014-05-13	BICK	ETF	25.38	25.38	25.17	25.17	2317.0
2014-05-13	BIL	ETF	91.52	91.54	91.52	91.54	173450.0
2014-05-13	BIS	ETF	706.4	717.2	695.204	715.6	8972.0
2014-05-13	BIV	ETF	84.17	84.22	84.1	84.19	172400.0
2014-05-13	BIZD	ETF	19.6	19.6	19.42	19.51	13200.0
2014-05-13	BJK	ETF	48.91	49.16	48.69	48.99	16800.0
2014-05-13	BKF	ETF	37.21	37.466	37.17	37.29	43917.0
2014-05-13	BKLN	ETF	24.86	24.87	24.83	24.83	3952600.0

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

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