PREVIEW / etf_daily / 2013-04-26

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-26.parquet
  size:    40 KB
  rows:    985

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
2013-04-26	SPY	ETF	158.33	158.6	157.73	158.24	95918800.0
2013-04-26	QQQ	ETF	69.62	69.77	69.27	69.57	24083912.0
2013-04-26	IWM	ETF	93.09	93.36	92.5	92.9	32405600.0
2013-04-26	DIA	ETF	146.55	147.15	146.52	146.88	3242600.0
2013-04-26	GLD	ETF	142.3	143.43	140.04	140.91	19307800.0
2013-04-26	TLT	ETF	123.2	123.51	123.01	123.39	4898800.0
2013-04-26	AAXJ	ETF	59.16	59.27	58.92	59.11	312100.0
2013-04-26	ACTV	ETF	5.12	5.12	5.0	5.11	219229.0
2013-04-26	ACWI	ETF	51.51	51.61	51.38	51.52	1032200.0
2013-04-26	ACWV	ETF	63.19	63.22	62.91	63.14	33500.0
2013-04-26	ACWX	ETF	43.52	43.64	43.4951	43.61	146462.0
2013-04-26	ADRE	ETF	38.44	38.52	38.0745	38.13	27023.0
2013-04-26	AFK	ETF	29.54	29.54	29.24	29.37	42513.0
2013-04-26	AGG	ETF	111.37	111.53	111.35	111.49	678500.0
2013-04-26	AGQ	ETF	107.24	109.12	101.24	103.64	652875.0
2013-04-26	AGZ	ETF	113.66	113.8	113.66	113.74	5582.0
2013-04-26	AIA	ETF	46.18	46.21	46.06	46.16	8129.0
2013-04-26	AIQ	ETF	11.37	11.58	10.75	11.48	22829.0
2013-04-26	AIVI	ETF	43.42	43.49	43.34	43.47	16200.0
2013-04-26	ALTL	ETF	29.3799	29.38	29.3799	29.38	400.0
2013-04-26	AMJ	ETF	47.14	47.33	46.05	47.0	706490.0
2013-04-26	AMLP	ETF	89.25	89.55	88.0	88.75	653400.0
2013-04-26	AOA	ETF	40.18	40.18	40.01	40.07	3800.0
2013-04-26	AOK	ETF	31.46	31.46	31.41	31.44	17392.0
2013-04-26	AOM	ETF	33.06	33.06	32.996	33.05	22377.0
2013-04-26	AOR	ETF	35.96	35.97	35.8522	35.96	37219.0
2013-04-26	ARB	ETF	46.69	46.73	46.5899	46.62	165765.0
2013-04-26	ARGT	ETF	17.16	17.16	17.1	17.1	750.0
2013-04-26	ASEA	ETF	18.18	18.2	18.1	18.18	22300.0
2013-04-26	ATMP	ETF	26.61	26.61	26.0	26.34	24200.0
2013-04-26	AVIV	ETF	25.3	25.37	24.58	25.16	311797.0
2013-04-26	AWAY	ETF	31.84	31.97	30.03	30.76	2479151.0
2013-04-26	BAB	ETF	30.9	31.04	30.9	31.03	213315.0
2013-04-26	BAL	ETF	52.7	53.2	52.67	53.16	35289.0
2013-04-26	BALT	ETF	3.33	3.45	3.3	3.37	38878.0
2013-04-26	BBH	ETF	70.2	70.95	69.99	70.27	107700.0
2013-04-26	BCM	ETF	40.6899	40.6899	40.38	40.45	2230.0
2013-04-26	BIB	ETF	22.87	23.2048	22.5375	22.81	170124.0
2013-04-26	BICK	ETF	23.73	23.731	23.701	23.701	864.0
2013-04-26	BIL	ETF	91.6	91.62	91.6	91.6	81500.0
2013-04-26	BIS	ETF	1632.796	1632.796	1571.2	1600.0	52.0
2013-04-26	BIV	ETF	88.61	88.71	88.58	88.68	248900.0
2013-04-26	BIZD	ETF	20.5	20.5	20.23	20.37	15500.0
2013-04-26	BJK	ETF	41.8	41.89	41.7	41.8	8600.0
2013-04-26	BKF	ETF	38.66	38.77	38.301	38.5	87560.0
2013-04-26	BKLN	ETF	25.15	25.15	25.12	25.12	2675900.0
2013-04-26	BLV	ETF	94.76	94.96	94.68	94.88	39700.0
2013-04-26	BMVP	ETF	18.74	18.7533	18.62	18.6922	9007.0
2013-04-26	BND	ETF	84.08	84.16	84.06	84.11	732500.0
2013-04-26	BNO	ETF	39.03	39.115	38.875	39.015	17800.0

> showing 50 of 985 rows — these rows as CSV

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