PREVIEW / etf_daily / 2013-04-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-30.parquet
  size:    40 KB
  rows:    990

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-30	SPY	ETF	159.27	159.72	158.61	159.68	116010700.0
2013-04-30	QQQ	ETF	70.29	70.73	70.04	70.72	30146326.0
2013-04-30	IWM	ETF	93.58	94.14	93.17	94.1	30488500.0
2013-04-30	DIA	ETF	147.87	148.11	147.05	148.02	8065800.0
2013-04-30	GLD	ETF	142.27	142.83	141.55	142.77	11284400.0
2013-04-30	TLT	ETF	123.26	123.69	122.67	123.01	4477400.0
2013-04-30	AADR	ETF	33.61	33.61	33.61	33.61	100.0
2013-04-30	AAXJ	ETF	59.97	60.46	59.73	60.42	589000.0
2013-04-30	ACTV	ETF	5.16	5.16	5.0	5.03	449312.0
2013-04-30	ACWI	ETF	52.01	52.27	51.87	52.19	1774700.0
2013-04-30	ACWV	ETF	63.65	63.88	63.38	63.87	57300.0
2013-04-30	ACWX	ETF	44.24	44.38	44.05	44.36	352804.0
2013-04-30	ADRE	ETF	38.47	39.19	38.4301	39.17	44879.0
2013-04-30	AFK	ETF	29.47	29.75	29.35	29.75	21001.0
2013-04-30	AGEM	ETF	22.36	22.55	22.25	22.55	4900.0
2013-04-30	AGG	ETF	111.59	111.68	111.48	111.54	1853100.0
2013-04-30	AGQ	ETF	107.2	107.2	104.76	106.88	362800.0
2013-04-30	AGZ	ETF	113.8254	113.84	113.75	113.8	13623.0
2013-04-30	AIA	ETF	46.87	47.0	46.6351	47.0	8459.0
2013-04-30	AIQ	ETF	12.37	12.92	12.36	12.75	55742.0
2013-04-30	AIVI	ETF	43.96	44.1	43.96	44.1	20500.0
2013-04-30	AMJ	ETF	46.5	46.862	46.25	46.37	597007.0
2013-04-30	AMLP	ETF	88.85	89.0	88.55	89.0	485680.0
2013-04-30	ANGL	ETF	27.96	27.96	27.69	27.7	2600.0
2013-04-30	AOA	ETF	40.41	40.52	40.3	40.52	31400.0
2013-04-30	AOK	ETF	31.57	31.58	31.5024	31.58	27473.0
2013-04-30	AOM	ETF	33.13	33.23	33.11	33.23	12058.0
2013-04-30	AOR	ETF	36.17	36.22	36.06	36.22	25318.0
2013-04-30	ARB	ETF	46.6	46.69	46.6	46.69	117452.0
2013-04-30	ARGT	ETF	17.32	17.36	17.24	17.34	1500.0
2013-04-30	ASEA	ETF	18.41	18.47	18.27	18.42	30300.0
2013-04-30	ATMP	ETF	26.31	26.37	26.28	26.35	16900.0
2013-04-30	AVIV	ETF	25.18	25.79	25.16	25.69	197998.0
2013-04-30	AWAY	ETF	30.79	31.07	30.25	30.55	885395.0
2013-04-30	BAB	ETF	30.96	31.05	30.9	30.91	207299.0
2013-04-30	BAL	ETF	54.38	55.35	53.52	55.35	58415.0
2013-04-30	BALT	ETF	3.41	3.56	3.41	3.47	22604.0
2013-04-30	BBH	ETF	70.49	70.49	69.05	69.81	164200.0
2013-04-30	BCM	ETF	40.85	40.87	40.76	40.76	4107.0
2013-04-30	BIB	ETF	22.9275	22.9275	22.1253	22.5765	139688.0
2013-04-30	BICK	ETF	23.95	24.26	23.95	24.25	5910.0
2013-04-30	BIL	ETF	91.62	91.62	91.6	91.6	184450.0
2013-04-30	BIS	ETF	1592.0	1632.8	1592.0	1619.6	291.0
2013-04-30	BIV	ETF	88.74	88.88	88.66	88.72	268700.0
2013-04-30	BIZD	ETF	20.88	20.88	20.62	20.76	22700.0
2013-04-30	BJK	ETF	42.01	42.21	41.94	42.21	10700.0
2013-04-30	BKF	ETF	38.95	39.5379	38.88	39.5	92291.0
2013-04-30	BKLN	ETF	25.18	25.19	25.16	25.19	2037300.0
2013-04-30	BLNG	ETF	43.18	43.18	41.52	41.52	2970.0
2013-04-30	BLV	ETF	95.07	95.09	94.54	94.74	103000.0

> showing 50 of 990 rows — these rows as CSV

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