PREVIEW / etf_daily / 2013-04-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-15.parquet
  size:    41 KB
  rows:    993

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-15	SPY	ETF	158.0	158.13	155.1	155.12	217259000.0
2013-04-15	QQQ	ETF	69.68	69.79	68.48	68.56	48795787.0
2013-04-15	IWM	ETF	93.06	93.15	89.79	90.11	100204000.0
2013-04-15	DIA	ETF	147.9	147.93	145.72	145.81	14177400.0
2013-04-15	GLD	ETF	136.0	136.75	130.51	131.31	93804200.0
2013-04-15	TLT	ETF	122.13	123.03	121.87	122.99	12948400.0
2013-04-15	AADR	ETF	32.59	32.65	32.57	32.57	1400.0
2013-04-15	AAXJ	ETF	57.29	57.4	56.57	56.62	685500.0
2013-04-15	ACTV	ETF	4.86	4.865	4.55	4.57	610777.0
2013-04-15	ACWI	ETF	51.02	51.06	50.25	50.26	317000.0
2013-04-15	ACWV	ETF	62.5	62.53	61.77	61.77	123500.0
2013-04-15	ACWX	ETF	42.9	42.9	42.28	42.29	458880.0
2013-04-15	ADRE	ETF	37.62	37.68	36.91	36.91	59614.0
2013-04-15	AFK	ETF	29.69	29.69	28.54	28.62	339336.0
2013-04-15	AGEM	ETF	21.7501	21.7501	21.55	21.55	1200.0
2013-04-15	AGG	ETF	111.16	111.29	111.13	111.25	1521700.0
2013-04-15	AGQ	ETF	103.24	104.28	95.92	95.92	1633000.0
2013-04-15	AGZ	ETF	113.79	113.8	113.6301	113.8	11499.0
2013-04-15	AIA	ETF	44.78	44.83	44.296	44.33	30593.0
2013-04-15	AIQ	ETF	9.6	9.6	9.21	9.37	12524.0
2013-04-15	AIVI	ETF	42.75	42.75	42.16	42.17	17700.0
2013-04-15	AMJ	ETF	45.36	45.4298	44.378	44.69	2082549.0
2013-04-15	AMLP	ETF	87.95	88.0	86.95	87.1	758920.0
2013-04-15	ANGL	ETF	27.5	27.5	27.25	27.26	1700.0
2013-04-15	AOA	ETF	39.87	39.87	39.27	39.3	82100.0
2013-04-15	AOK	ETF	31.33	31.33	31.15	31.15	16581.0
2013-04-15	AOM	ETF	32.84	32.87	32.64	32.64	54444.0
2013-04-15	AOR	ETF	35.82	35.82	35.3862	35.4	37999.0
2013-04-15	ARB	ETF	46.72	46.75	46.63	46.66	409565.0
2013-04-15	ARGT	ETF	17.0	17.0	16.44	16.44	8900.0
2013-04-15	ASEA	ETF	17.61	17.69	17.5	17.5	18400.0
2013-04-15	ATMP	ETF	26.25	26.25	25.46	25.48	10800.0
2013-04-15	AVIV	ETF	23.98	24.19	23.7	23.7	422151.0
2013-04-15	AWAY	ETF	32.93	33.35	32.55	32.96	1110715.0
2013-04-15	BAB	ETF	30.81	30.879	30.71	30.83	247804.0
2013-04-15	BAL	ETF	54.68	54.68	53.99	53.99	62412.0
2013-04-15	BALT	ETF	3.61	3.61	3.55	3.55	34303.0
2013-04-15	BBH	ETF	68.98	69.13	67.0	67.15	250800.0
2013-04-15	BCM	ETF	39.65	39.66	39.65	39.66	800.0
2013-04-15	BIB	ETF	21.935	22.1573	20.2003	20.695	355172.0
2013-04-15	BICK	ETF	22.905	22.966	22.67	22.7011	1248.0
2013-04-15	BIL	ETF	91.6	91.62	91.6	91.62	146050.0
2013-04-15	BIS	ETF	1695.2	1788.8	1692.8	1779.76	127.0
2013-04-15	BIV	ETF	88.37	88.45	88.27	88.44	255600.0
2013-04-15	BIZD	ETF	19.85	19.85	19.43	19.45	4500.0
2013-04-15	BJK	ETF	39.7	39.89	39.01	39.01	8100.0
2013-04-15	BKF	ETF	37.67	37.71	37.08	37.08	68662.0
2013-04-15	BKLN	ETF	25.11	25.11	25.08	25.09	3049600.0
2013-04-15	BLV	ETF	94.08	94.46	93.89	94.37	94400.0
2013-04-15	BMVP	ETF	18.42	18.47	18.15	18.15	5674.0

> showing 50 of 993 rows — these rows as CSV

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