PREVIEW / etf_daily / 2013-04-09

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-09.parquet
  size:    40 KB
  rows:    981

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-09	SPY	ETF	156.5	157.32	155.98	156.75	101922200.0
2013-04-09	QQQ	ETF	68.42	68.96	68.09	68.68	30931361.0
2013-04-09	IWM	ETF	92.64	92.83	92.04	92.22	36828400.0
2013-04-09	DIA	ETF	146.08	146.96	145.75	146.51	5492300.0
2013-04-09	GLD	ETF	152.32	153.85	152.28	153.34	7042200.0
2013-04-09	TLT	ETF	122.03	122.24	121.38	121.58	7176100.0
2013-04-09	AADR	ETF	32.98	33.13	32.98	33.13	1200.0
2013-04-09	AAXJ	ETF	57.27	57.93	57.2	57.69	498000.0
2013-04-09	ACTV	ETF	4.17	4.18	4.1	4.16	234044.0
2013-04-09	ACWI	ETF	50.62	50.93	50.43	50.74	453300.0
2013-04-09	ACWV	ETF	62.08	62.17	61.71	61.95	298500.0
2013-04-09	ACWX	ETF	42.45	42.8	42.3	42.6532	152830.0
2013-04-09	ADRE	ETF	37.88	38.46	37.88	38.32	42922.0
2013-04-09	AFK	ETF	30.4	30.54	30.09	30.33	18539.0
2013-04-09	AGEM	ETF	22.3132	22.3276	22.31	22.31	1763.0
2013-04-09	AGG	ETF	111.1	111.13	110.95	111.05	1286600.0
2013-04-09	AGQ	ETF	140.56	147.44	140.32	146.36	375925.0
2013-04-09	AGZ	ETF	113.614	113.79	113.614	113.6999	7960.0
2013-04-09	AIA	ETF	44.87	45.3431	44.8402	45.25	4830.0
2013-04-09	AIQ	ETF	8.6	8.98	8.58	8.76	12652.0
2013-04-09	AIVI	ETF	42.35	42.66	42.17	42.55	17300.0
2013-04-09	AMJ	ETF	45.68	46.17	45.54	46.06	1681328.0
2013-04-09	AMLP	ETF	88.15	89.05	88.15	88.6	1099000.0
2013-04-09	ANGL	ETF	27.11	27.11	27.11	27.11	300.0
2013-04-09	AOA	ETF	39.55	39.69	39.41	39.59	104900.0
2013-04-09	AOK	ETF	31.16	31.24	31.16	31.2	28475.0
2013-04-09	AOM	ETF	32.7	32.79	32.671	32.734	14691.0
2013-04-09	AOR	ETF	35.51	35.64	35.458	35.55	22961.0
2013-04-09	ARB	ETF	46.8	46.8	46.68	46.72	126610.0
2013-04-09	ARGT	ETF	17.16	17.48	17.16	17.48	350.0
2013-04-09	ASEA	ETF	17.54	17.71	17.54	17.69	7000.0
2013-04-09	ATMP	ETF	26.03	26.22	26.02	26.11	16000.0
2013-04-09	AVIV	ETF	25.28	25.35	24.9	24.96	183316.0
2013-04-09	AWAY	ETF	30.45	30.83	30.42	30.66	477072.0
2013-04-09	BAB	ETF	30.74	30.79	30.67	30.68	100215.0
2013-04-09	BAL	ETF	55.02	55.18	54.53	54.59	26730.0
2013-04-09	BALT	ETF	3.54	3.7299	3.51	3.61	96664.0
2013-04-09	BBH	ETF	65.37	65.44	64.82	65.12	48400.0
2013-04-09	BCM	ETF	42.119	42.4399	42.119	42.35	750.0
2013-04-09	BIB	ETF	19.665	20.0625	19.6537	19.7875	58064.0
2013-04-09	BICK	ETF	23.14	23.44	23.14	23.354	2920.0
2013-04-09	BIL	ETF	91.62	91.62	91.6	91.62	82300.0
2013-04-09	BIS	ETF	1888.0	1888.0	1872.4	1872.4	15.0
2013-04-09	BIV	ETF	88.22	88.23	88.06	88.08	187700.0
2013-04-09	BIZD	ETF	20.0	20.04	19.94	19.94	14300.0
2013-04-09	BJK	ETF	39.4	39.77	39.37	39.77	4400.0
2013-04-09	BKF	ETF	38.12	38.69	38.06	38.52	75983.0
2013-04-09	BKLN	ETF	25.13	25.13	25.11	25.13	1976900.0
2013-04-09	BLV	ETF	93.96	94.0	93.56	93.71	100300.0
2013-04-09	BMVP	ETF	18.467	18.557	18.437	18.537	6120.0

> showing 50 of 981 rows — these rows as CSV

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