PREVIEW / etf_daily / 2012-11-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-13.parquet
  size:    39 KB
  rows:    953

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-11-13	SPY	ETF	137.54	139.25	137.36	137.79	123018300.0
2012-11-13	QQQ	ETF	62.92	63.58	62.7801	62.98	43287627.0
2012-11-13	IWM	ETF	78.79	79.56	78.58	78.7	34408200.0
2012-11-13	DIA	ETF	127.41	128.92	127.33	127.53	5407200.0
2012-11-13	GLD	ETF	166.66	167.94	166.63	167.1	6463300.0
2012-11-13	TLT	ETF	126.8	126.82	125.99	126.61	2863800.0
2012-11-13	AAXJ	ETF	55.86	56.39	55.86	56.09	272400.0
2012-11-13	ACTV	ETF	5.35	5.51	5.275	5.3	1100469.0
2012-11-13	ACWI	ETF	45.36	45.93	45.36	45.55	398500.0
2012-11-13	ACWV	ETF	55.48	55.62	55.44	55.47	6000.0
2012-11-13	ACWX	ETF	38.83	39.13	38.72	38.9	183451.0
2012-11-13	ADRE	ETF	37.95	38.202	37.8302	37.94	42466.0
2012-11-13	AFK	ETF	31.23	31.41	31.18	31.2	70559.0
2012-11-13	AGEM	ETF	21.72	22.03	21.72	22.03	972.0
2012-11-13	AGG	ETF	112.28	112.33	112.11	112.25	3355800.0
2012-11-13	AGQ	ETF	201.04	208.96	200.84	203.76	211075.0
2012-11-13	AGZ	ETF	113.91	113.985	113.82	113.82	28630.0
2012-11-13	AIA	ETF	44.2	44.4499	44.04	44.2	25908.0
2012-11-13	AIQ	ETF	7.1	7.3	7.05	7.05	8228.0
2012-11-13	AIVI	ETF	38.59	38.93	38.51	38.72	42500.0
2012-11-13	AMJ	ETF	38.6	38.94	38.19	38.76	1864299.0
2012-11-13	AMLP	ETF	78.75	79.45	78.45	79.2	824100.0
2012-11-13	ANGL	ETF	26.72	26.73	26.62	26.62	5300.0
2012-11-13	AOA	ETF	35.67	35.99	35.67	35.7	13400.0
2012-11-13	AOK	ETF	30.26	30.31	30.21	30.2545	8348.0
2012-11-13	AOM	ETF	31.19	31.3	31.19	31.2	18740.0
2012-11-13	AOR	ETF	33.02	33.2	32.97	33.03	22527.0
2012-11-13	ARB	ETF	36.0	36.58	35.79	35.91	70835.0
2012-11-13	ARGT	ETF	15.96	15.96	15.8	15.8	1150.0
2012-11-13	ASEA	ETF	16.6	16.66	16.54	16.6	15200.0
2012-11-13	AWAY	ETF	21.0	21.5445	20.51	20.59	645605.0
2012-11-13	BAB	ETF	30.61	30.7	30.61	30.66	125390.0
2012-11-13	BAL	ETF	46.04	46.18	45.96	46.01	122304.0
2012-11-13	BALT	ETF	3.32	3.36	3.27	3.3	33614.0
2012-11-13	BBH	ETF	51.96	52.44	51.8	52.03	47400.0
2012-11-13	BCM	ETF	43.93	43.93	43.91	43.91	3318.0
2012-11-13	BIB	ETF	13.35	13.71	13.35	13.493	29176.0
2012-11-13	BICK	ETF	23.32	23.3242	23.2387	23.28	2243.0
2012-11-13	BIL	ETF	91.62	91.64	91.62	91.64	2435000.0
2012-11-13	BIS	ETF	2890.8	2890.8	2890.8	2890.8	10.0
2012-11-13	BIV	ETF	90.54	90.54	90.38	90.54	282500.0
2012-11-13	BJK	ETF	33.97	34.27	33.91	33.91	16900.0
2012-11-13	BKF	ETF	37.4	37.669	37.31	37.45	127814.0
2012-11-13	BKLN	ETF	24.73	24.81	24.7	24.72	5663800.0
2012-11-13	BLV	ETF	97.88	97.92	97.45	97.88	58000.0
2012-11-13	BMVP	ETF	15.645	15.645	15.5033	15.5033	3258.0
2012-11-13	BND	ETF	85.0	85.1	84.96	85.02	3720600.0
2012-11-13	BNO	ETF	39.105	39.46	39.04	39.215	87600.0
2012-11-13	BOIL	ETF	1042000.0	1074200.0	1037400.0	1070800.0	11.0
2012-11-13	BOND	ETF	110.03	110.1	109.8901	109.96	557357.0

> showing 50 of 953 rows — these rows as CSV

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