PREVIEW / etf_daily / 2012-07-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-05.parquet
  size:    38 KB
  rows:    940

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-05	SPY	ETF	136.9	137.8	136.29	136.79	126177500.0
2012-07-05	QQQ	ETF	64.78	65.25	64.48	64.93	37025561.0
2012-07-05	IWM	ETF	81.62	81.84	81.03	81.44	42819900.0
2012-07-05	DIA	ETF	128.62	129.41	128.3	128.78	6637500.0
2012-07-05	GLD	ETF	155.44	156.4	154.45	155.68	5359900.0
2012-07-05	TLT	ETF	125.35	126.32	125.25	125.89	5974700.0
2012-07-05	AADR	ETF	28.79	28.87	28.79	28.85	1300.0
2012-07-05	AAXJ	ETF	53.36	53.49	53.04	53.25	336000.0
2012-07-05	ACTV	ETF	15.27	15.57	15.15	15.42	146172.0
2012-07-05	ACWI	ETF	44.11	44.32	44.0	44.16	292300.0
2012-07-05	ACWV	ETF	55.32	55.32	54.8	54.85	107900.0
2012-07-05	ACWX	ETF	37.25	37.45	37.13	37.34	168520.0
2012-07-05	ADRE	ETF	38.04	38.338	37.05	38.13	97569.0
2012-07-05	AFK	ETF	28.46	28.5099	28.31	28.45	20890.0
2012-07-05	AGEM	ETF	21.29	21.36	21.2701	21.2701	4627.0
2012-07-05	AGG	ETF	111.24	111.5	111.24	111.5	740700.0
2012-07-05	AGQ	ETF	153.92	157.16	153.24	154.96	299950.0
2012-07-05	AGZ	ETF	113.53	113.72	113.42	113.45	15888.0
2012-07-05	AIA	ETF	41.82	41.8505	41.62	41.83	12369.0
2012-07-05	AIQ	ETF	5.0	5.07	4.9	5.0	9171.0
2012-07-05	AIVI	ETF	37.73	37.81	37.46	37.68	26500.0
2012-07-05	AMJ	ETF	38.95	39.8	38.85	39.19	1595405.0
2012-07-05	AMLP	ETF	80.55	80.65	80.2	80.55	357100.0
2012-07-05	ANGL	ETF	25.5	25.5	25.5	25.5	400.0
2012-07-05	AOA	ETF	35.22	35.27	35.14	35.27	3500.0
2012-07-05	AOK	ETF	29.94	29.97	29.86	29.96	13412.0
2012-07-05	AOM	ETF	30.81	30.88	30.78	30.808	11160.0
2012-07-05	AOR	ETF	32.78	32.78	32.57	32.69	14018.0
2012-07-05	ARB	ETF	35.85	37.03	35.84	36.51	113016.0
2012-07-05	ARGT	ETF	16.78	16.78	16.44	16.68	2050.0
2012-07-05	ASEA	ETF	15.8	15.8	15.8	15.8	200.0
2012-07-05	AWAY	ETF	21.97	22.25	21.7405	21.85	301888.0
2012-07-05	BAB	ETF	29.81	29.88	29.7701	29.86	119586.0
2012-07-05	BAL	ETF	47.1901	47.29	46.4	46.72	19438.0
2012-07-05	BALT	ETF	3.45	3.73	3.45	3.71	103792.0
2012-07-05	BBH	ETF	48.56	48.63	48.18	48.36	15800.0
2012-07-05	BCM	ETF	42.89	42.92	42.8	42.88	33818.0
2012-07-05	BIB	ETF	14.12	14.12	13.7875	13.9712	58488.0
2012-07-05	BICK	ETF	22.98	22.99	22.8	22.99	2134.0
2012-07-05	BIL	ETF	91.62	91.64	91.62	91.62	1299200.0
2012-07-05	BIS	ETF	3072.0	3073.6	2902.4	2961.6	35.55
2012-07-05	BIV	ETF	88.95	89.1	88.94	89.04	249800.0
2012-07-05	BJK	ETF	31.62	31.86	31.51	31.81	71500.0
2012-07-05	BKF	ETF	36.44	36.67	36.1	36.38	172988.0
2012-07-05	BKLN	ETF	24.45	24.46	24.41	24.45	468200.0
2012-07-05	BLV	ETF	94.99	95.51	94.91	95.33	45200.0
2012-07-05	BMVP	ETF	15.48	15.59	15.48	15.536	13604.0
2012-07-05	BND	ETF	84.33	84.49	84.29	84.49	1283700.0
2012-07-05	BNO	ETF	35.72	35.925	35.465	35.58	101000.0
2012-07-05	BOIL	ETF	983000.0	992400.0	955800.0	984000.0	14.0

> showing 50 of 940 rows — these rows as CSV

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