PREVIEW / etf_daily / 2012-07-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-11.parquet
  size:    38 KB
  rows:    920

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-11	SPY	ETF	134.21	134.6	133.38	134.16	141733400.0
2012-07-11	QQQ	ETF	63.29	63.46	62.5	63.02	43431952.0
2012-07-11	IWM	ETF	79.39	79.65	78.55	79.06	40171300.0
2012-07-11	DIA	ETF	126.43	126.49	125.19	125.91	6839500.0
2012-07-11	GLD	ETF	152.58	153.45	152.02	152.99	6838500.0
2012-07-11	TLT	ETF	128.59	129.47	128.26	128.6	5960900.0
2012-07-11	AAXJ	ETF	52.09	52.31	51.72	52.0	332700.0
2012-07-11	ACTV	ETF	14.93	15.02	14.83	14.88	192766.0
2012-07-11	ACWI	ETF	43.42	43.48	43.1	43.32	2074800.0
2012-07-11	ACWV	ETF	54.79	54.79	54.35	54.61	1800.0
2012-07-11	ACWX	ETF	36.63	36.73	36.41	36.62	205230.0
2012-07-11	ADRE	ETF	36.95	37.23	36.781	36.98	12444.0
2012-07-11	AFK	ETF	27.62	27.78	27.51	27.78	54121.0
2012-07-11	AGEM	ETF	20.7146	20.7146	20.6445	20.6445	785.0
2012-07-11	AGG	ETF	111.86	112.0	111.81	111.84	566400.0
2012-07-11	AGQ	ETF	146.76	149.64	144.68	147.56	258250.0
2012-07-11	AGZ	ETF	113.76	113.83	113.61	113.64	24818.0
2012-07-11	AIA	ETF	40.65	40.65	40.24	40.48	6888.0
2012-07-11	AIQ	ETF	4.45	4.55	4.36	4.55	15976.0
2012-07-11	AIVI	ETF	37.14	37.38	36.98	37.24	44200.0
2012-07-11	AMJ	ETF	39.01	39.2799	38.82	39.15	1029092.0
2012-07-11	AMLP	ETF	81.05	81.25	80.6	81.25	313040.0
2012-07-11	ANGL	ETF	25.35	25.49	25.27	25.27	1500.0
2012-07-11	AOA	ETF	34.67	34.68	34.54	34.54	4200.0
2012-07-11	AOK	ETF	29.81	29.86	29.81	29.84	7688.0
2012-07-11	AOM	ETF	30.63	30.63	30.55	30.6289	11736.0
2012-07-11	AOR	ETF	32.3474	32.36	32.2399	32.31	8310.0
2012-07-11	ARB	ETF	34.51	34.83	34.1	34.56	102191.0
2012-07-11	ARGT	ETF	15.84	15.84	15.78	15.8	400.0
2012-07-11	ASEA	ETF	15.78	15.82	15.71	15.71	11700.0
2012-07-11	AWAY	ETF	20.47	21.21	20.3	20.89	792567.0
2012-07-11	BAB	ETF	30.18	30.282	30.15	30.2	149757.0
2012-07-11	BAL	ETF	46.95	47.28	46.29	46.93	6319.0
2012-07-11	BALT	ETF	3.5	3.73	3.46	3.55	55628.0
2012-07-11	BBH	ETF	47.87	47.87	46.94	47.25	21200.0
2012-07-11	BIB	ETF	13.0144	13.2462	12.8613	13.0575	43808.0
2012-07-11	BICK	ETF	22.09	22.18	22.0	22.0782	2202.0
2012-07-11	BIL	ETF	91.62	91.64	91.62	91.62	124950.0
2012-07-11	BIS	ETF	3054.4	3204.8	3054.4	3174.4	48.45
2012-07-11	BIV	ETF	89.58	89.64	89.5	89.5	193400.0
2012-07-11	BJK	ETF	31.42	31.44	31.05	31.18	30700.0
2012-07-11	BKF	ETF	35.16	35.39	34.951	35.16	70156.0
2012-07-11	BKLN	ETF	24.6	24.61	24.48	24.48	191000.0
2012-07-11	BLV	ETF	97.02	97.35	96.79	96.87	72300.0
2012-07-11	BMVP	ETF	15.2379	15.2397	15.1533	15.1533	731.0
2012-07-11	BND	ETF	84.75	84.88	84.68	84.69	1357600.0
2012-07-11	BNO	ETF	35.04	35.625	34.985	35.62	56600.0
2012-07-11	BOIL	ETF	865400.0	908800.0	855600.0	904000.0	8.0
2012-07-11	BOND	ETF	106.5	106.58	106.48	106.48	650736.0
2012-07-11	BRF	ETF	35.4	35.67	35.0	35.13	87148.0

> showing 50 of 920 rows — these rows as CSV

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