PREVIEW / etf_daily / 2013-07-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-03.parquet
  size:    40 KB
  rows:    994

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-07-03	SPY	ETF	160.48	161.77	160.22	161.28	75216400.0
2013-07-03	QQQ	ETF	71.48	72.37	71.42	72.031	18847424.0
2013-07-03	IWM	ETF	97.73	98.64	97.59	98.28	19153600.0
2013-07-03	DIA	ETF	148.42	149.98	148.25	149.54	2589400.0
2013-07-03	GLD	ETF	120.7	121.77	120.54	120.74	6750300.0
2013-07-03	TLT	ETF	110.31	110.65	110.01	110.01	3839000.0
2013-07-03	AAXJ	ETF	53.61	54.13	53.51	53.84	299800.0
2013-07-03	ACTV	ETF	7.8	8.13	7.79	8.08	337800.0
2013-07-03	ACWI	ETF	49.89	50.24	49.73	50.11	613700.0
2013-07-03	ACWV	ETF	59.88	60.13	59.59	59.98	66000.0
2013-07-03	ACWX	ETF	40.51	40.79	40.3801	40.67	97135.0
2013-07-03	ADRE	ETF	33.5	33.8	33.5	33.646	90420.0
2013-07-03	AFK	ETF	27.26	27.53	27.2	27.5	24963.0
2013-07-03	AGEM	ETF	20.2	20.25	20.135	20.19	1327.0
2013-07-03	AGG	ETF	107.22	107.28	107.01	107.01	442600.0
2013-07-03	AGQ	ETF	68.2	69.8	67.84	68.48	361100.0
2013-07-03	AGZ	ETF	111.01	111.3599	111.01	111.051	11066.0
2013-07-03	AIA	ETF	41.62	41.854	41.48	41.74	9913.0
2013-07-03	AIQ	ETF	15.96	16.14	15.7	15.89	23951.0
2013-07-03	AIVI	ETF	39.69	40.05	39.51	39.95	17100.0
2013-07-03	AMJ	ETF	46.8	47.2	46.16	46.33	455649.0
2013-07-03	AMLP	ETF	89.55	89.65	88.8	89.3	306940.0
2013-07-03	ANGL	ETF	26.04	26.25	25.94	25.94	300.0
2013-07-03	AOA	ETF	39.77	39.77	39.49	39.71	19700.0
2013-07-03	AOK	ETF	30.64	30.69	30.6363	30.69	15404.0
2013-07-03	AOM	ETF	32.37	32.37	32.16	32.3099	12115.0
2013-07-03	AOR	ETF	35.31	35.34	35.17	35.34	20358.0
2013-07-03	ARB	ETF	46.35	46.4	46.35	46.38	308114.0
2013-07-03	ARGT	ETF	16.34	16.34	16.34	16.34	600.0
2013-07-03	ASEA	ETF	16.55	16.73	16.5	16.72	13800.0
2013-07-03	ATMP	ETF	25.95	26.03	25.85	26.02	7000.0
2013-07-03	AVIV	ETF	24.94	25.1	24.5	24.71	60063.0
2013-07-03	AWAY	ETF	31.56	32.0	31.07	31.56	475306.0
2013-07-03	BAB	ETF	28.196	28.35	28.18	28.29	177951.0
2013-07-03	BAL	ETF	54.48	54.849	54.48	54.78	10698.0
2013-07-03	BALT	ETF	3.6	3.67	3.6	3.6	46007.0
2013-07-03	BBH	ETF	71.47	71.96	71.1	71.6	41100.0
2013-07-03	BCM	ETF	39.18	39.27	39.18	39.242	6150.0
2013-07-03	BFOR	ETF	6.215	6.265	6.215	6.235	144000.0
2013-07-03	BIB	ETF	23.625	24.15	23.5	24.0388	23792.0
2013-07-03	BICK	ETF	20.54	20.67	20.49	20.67	1438.0
2013-07-03	BIL	ETF	91.62	91.62	91.6	91.62	208100.0
2013-07-03	BIS	ETF	1458.64	1468.32	1450.0	1450.0	19.3
2013-07-03	BIV	ETF	83.52	83.65	83.37	83.38	215200.0
2013-07-03	BJK	ETF	40.34	40.34	40.34	40.34	100.0
2013-07-03	BKF	ETF	33.0	33.33	32.84	33.14	149812.0
2013-07-03	BKLN	ETF	24.74	24.77	24.72	24.76	1070200.0
2013-07-03	BLV	ETF	85.52	85.62	85.23	85.44	31700.0
2013-07-03	BMVP	ETF	18.5629	18.75	18.5629	18.75	838.0
2013-07-03	BND	ETF	80.88	80.96	80.8	80.81	562300.0

> showing 50 of 994 rows — these rows as CSV

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