PREVIEW / etf_daily / 2012-07-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-09.parquet
  size:    38 KB
  rows:    932

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
2012-07-09	SPY	ETF	135.38	135.57	134.7	135.32	103780500.0
2012-07-09	QQQ	ETF	64.03	64.26	63.68	64.0	35636978.0
2012-07-09	IWM	ETF	80.42	80.53	79.86	80.22	34636100.0
2012-07-09	DIA	ETF	127.42	127.5	126.71	127.24	4503800.0
2012-07-09	GLD	ETF	153.61	154.58	153.43	154.04	4468500.0
2012-07-09	TLT	ETF	127.38	128.26	127.11	128.18	5647000.0
2012-07-09	AAXJ	ETF	52.25	52.25	51.9	52.16	240200.0
2012-07-09	ACTV	ETF	14.9	14.98	14.745	14.97	151732.0
2012-07-09	ACWI	ETF	43.47	43.58	43.32	43.56	253800.0
2012-07-09	ACWV	ETF	54.95	54.95	54.41	54.58	8400.0
2012-07-09	ACWX	ETF	36.68	36.74	36.52	36.74	153983.0
2012-07-09	ADRE	ETF	37.3	37.36	37.17	37.32	34716.0
2012-07-09	AFK	ETF	28.04	28.04	27.5101	27.598	16062.0
2012-07-09	AGEM	ETF	20.72	20.72	20.68	20.68	940.0
2012-07-09	AGG	ETF	111.67	111.82	111.65	111.8	472600.0
2012-07-09	AGQ	ETF	149.52	152.4	148.92	150.64	196075.0
2012-07-09	AGZ	ETF	113.69	113.74	113.596	113.64	35437.0
2012-07-09	AIA	ETF	40.74	40.74	40.47	40.625	14726.0
2012-07-09	AIQ	ETF	4.8	4.8	4.4	4.5595	19663.0
2012-07-09	AIVI	ETF	37.07	37.23	36.94	37.23	48200.0
2012-07-09	AMJ	ETF	38.71	39.28	38.71	39.1	493301.0
2012-07-09	AMLP	ETF	80.6	81.0	80.45	80.8	344180.0
2012-07-09	ANGL	ETF	25.49	25.49	25.49	25.49	3000.0
2012-07-09	AOA	ETF	34.87	34.87	34.78	34.78	8800.0
2012-07-09	AOK	ETF	29.94	29.94	29.8101	29.88	24353.0
2012-07-09	AOM	ETF	30.68	30.69	30.6106	30.66	18090.0
2012-07-09	AOR	ETF	32.45	32.45	32.34	32.45	16198.0
2012-07-09	ARB	ETF	35.39	35.69	34.79	34.98	103484.0
2012-07-09	ASEA	ETF	15.62	15.62	15.54	15.56	14700.0
2012-07-09	AWAY	ETF	21.02	21.1184	20.21	20.47	132283.0
2012-07-09	BAB	ETF	30.15	30.18	30.02	30.15	142528.0
2012-07-09	BAL	ETF	47.45	47.56	46.5599	46.81	12122.0
2012-07-09	BALT	ETF	3.6	3.67	3.52	3.63	46975.0
2012-07-09	BBH	ETF	47.61	48.04	47.61	47.94	13800.0
2012-07-09	BCM	ETF	42.8	42.81	42.744	42.744	3454.0
2012-07-09	BIB	ETF	13.8012	13.8133	13.6065	13.8	39184.0
2012-07-09	BICK	ETF	22.44	22.44	22.18	22.32	2323.0
2012-07-09	BIL	ETF	91.64	91.64	91.62	91.62	417400.0
2012-07-09	BIS	ETF	3009.6	3019.2	3008.0	3008.0	15.2
2012-07-09	BIV	ETF	89.41	89.5	89.33	89.41	280800.0
2012-07-09	BJK	ETF	31.46	31.46	31.22	31.33	1800.0
2012-07-09	BKF	ETF	35.53	35.56	35.25	35.47	75072.0
2012-07-09	BKLN	ETF	24.49	24.49	24.43	24.49	106700.0
2012-07-09	BLV	ETF	96.22	96.72	96.09	96.62	92800.0
2012-07-09	BMVP	ETF	15.43	15.43	15.31	15.35	28681.0
2012-07-09	BND	ETF	84.63	84.74	84.6	84.73	800000.0
2012-07-09	BNO	ETF	34.85	35.675	34.83	35.29	83800.0
2012-07-09	BOIL	ETF	917400.0	946800.0	914400.0	938400.0	9.0
2012-07-09	BOND	ETF	106.53	106.53	106.3126	106.441	595703.0
2012-07-09	BRF	ETF	36.1	36.15	35.63	35.81	63161.0

> showing 50 of 932 rows — these rows as CSV

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