PREVIEW / etf_daily / 2011-05-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-12.parquet
  size:    36 KB
  rows:    850

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
2011-05-12	SPY	ETF	134.08	135.36	133.39	135.08	171550700.0
2011-05-12	QQQ	ETF	58.56	59.19	58.24	59.11	66128159.0
2011-05-12	IWM	ETF	83.47	84.94	82.98	84.69	80109400.0
2011-05-12	DIA	ETF	125.96	127.16	125.37	126.99	6684200.0
2011-05-12	GLD	ETF	145.88	147.12	144.96	146.59	18730400.0
2011-05-12	TLT	ETF	94.95	95.11	93.91	94.23	8015800.0
2011-05-12	AADR	ETF	31.11	31.42	31.11	31.42	600.0
2011-05-12	AAXJ	ETF	62.8	63.52	62.71	63.38	738000.0
2011-05-12	ACWI	ETF	48.96	49.53	48.75	49.42	156400.0
2011-05-12	ACWX	ETF	45.52	45.9671	45.329	45.84	185171.0
2011-05-12	ADRE	ETF	45.95	46.49	45.68	46.28	63276.0
2011-05-12	AFK	ETF	32.47	32.76	32.17	32.63	36893.0
2011-05-12	AGG	ETF	106.72	106.81	106.53	106.62	767000.0
2011-05-12	AGQ	ETF	324.94	357.06	306.0	331.08	3113900.0
2011-05-12	AGZ	ETF	110.21	110.264	109.95	110.1	5048.0
2011-05-12	AIA	ETF	47.65	48.0936	47.46	48.08	20236.0
2011-05-12	AIQ	ETF	21.6	21.7	21.2	21.45	13198.0
2011-05-12	AIS	ETF	1.8	1.84	1.76	1.8	665673.0
2011-05-12	AIVI	ETF	48.28	48.75	47.97	48.58	20000.0
2011-05-12	AMJ	ETF	36.96	36.96	36.4103	36.8	1134233.0
2011-05-12	AMLP	ETF	79.9	79.9	78.55	79.05	151200.0
2011-05-12	AOA	ETF	36.37	36.69	36.22	36.65	8800.0
2011-05-12	AOK	ETF	29.46	29.49	29.4356	29.4744	18848.0
2011-05-12	AOM	ETF	30.9	30.99	30.839	30.94	10497.0
2011-05-12	AOR	ETF	32.96	33.142	32.87	33.09	16345.0
2011-05-12	ARB	ETF	40.94	42.39	40.6	42.1	100579.0
2011-05-12	ARGT	ETF	29.5	29.74	29.46	29.58	4550.0
2011-05-12	ASEA	ETF	16.35	16.51	16.19	16.51	2700.0
2011-05-12	BAB	ETF	26.35	26.35	26.19	26.25	240638.0
2011-05-12	BAL	ETF	81.34	81.34	78.3709	79.7199	69682.0
2011-05-12	BALT	ETF	6.95	6.96	6.819	6.92	128605.0
2011-05-12	BBH	ETF	34.8933	35.5933	34.8933	35.5733	88500.0
2011-05-12	BIB	ETF	9.8887	10.21	9.75	10.1913	89968.0
2011-05-12	BICK	ETF	32.75	33.01	32.6	32.95	11797.0
2011-05-12	BIL	ETF	91.74	91.74	91.72	91.74	88350.0
2011-05-12	BIS	ETF	5980.8	5980.8	5758.4	5758.4	2.5
2011-05-12	BITS	ETF	23.28	23.92	22.48	22.94	3576.0
2011-05-12	BIV	ETF	83.61	83.77	83.48	83.53	274000.0
2011-05-12	BJK	ETF	34.43	34.63	34.42	34.62	5900.0
2011-05-12	BKF	ETF	47.48	47.93	47.1605	47.71	179689.0
2011-05-12	BKLN	ETF	25.28	25.28	25.25	25.25	71000.0
2011-05-12	BLNG	ETF	46.99	46.99	46.94	46.94	400.0
2011-05-12	BLV	ETF	80.62	80.79	80.07	80.27	38000.0
2011-05-12	BMVP	ETF	15.86	16.02	15.77	16.01	2124.0
2011-05-12	BND	ETF	81.11	81.2	81.0	81.07	994000.0
2011-05-12	BNO	ETF	37.18	37.83	36.69	37.45	126000.0
2011-05-12	BRF	ETF	56.11	57.28	55.71	57.16	205731.0
2011-05-12	BSCE	ETF	21.08	21.14	21.08	21.13	20454.0
2011-05-12	BSV	ETF	80.82	80.82	80.7	80.75	479000.0
2011-05-12	BTF	ETF	82.55	83.6	82.55	83.6	2958.4

> showing 50 of 850 rows — these rows as CSV

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