PREVIEW / etf_daily / 2011-11-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-08.parquet
  size:    37 KB
  rows:    892

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-11-08	SPY	ETF	126.92	128.02	125.71	127.88	224426300.0
2011-11-08	QQQ	ETF	58.63	58.98	57.97	58.88	62906879.0
2011-11-08	IWM	ETF	75.14	75.64	73.46	75.54	72278500.0
2011-11-08	DIA	ETF	121.01	121.75	119.9	121.59	7383200.0
2011-11-08	GLD	ETF	174.35	175.46	172.9	173.53	16054200.0
2011-11-08	TLT	ETF	116.75	117.54	115.5	115.72	7539400.0
2011-11-08	AADR	ETF	28.72	29.03	28.72	29.02	1000.0
2011-11-08	AAXJ	ETF	54.46	55.1	54.03	55.0	241000.0
2011-11-08	ACTV	ETF	13.11	13.32	12.9	13.29	84087.0
2011-11-08	ACWI	ETF	43.8	44.37	43.47	44.23	340500.0
2011-11-08	ACWV	ETF	51.48	51.48	51.48	51.48	100.0
2011-11-08	ACWX	ETF	39.13	39.4301	38.744	39.36	299979.0
2011-11-08	ADRE	ETF	41.79	42.0371	41.37	41.9796	28770.0
2011-11-08	AFK	ETF	29.22	29.42	29.06	29.42	6257.0
2011-11-08	AGEM	ETF	23.2	23.3335	22.9672	23.3335	2439.0
2011-11-08	AGG	ETF	109.95	110.18	109.85	109.94	949300.0
2011-11-08	AGQ	ETF	276.8	283.72	272.2	277.24	483000.0
2011-11-08	AGZ	ETF	112.3301	112.73	112.26	112.26	36028.0
2011-11-08	AIA	ETF	42.26	42.6804	42.01	42.6804	23978.0
2011-11-08	AIQ	ETF	6.2	6.25	5.85	6.15	24770.0
2011-11-08	AIS	ETF	2.33	2.4	2.32	2.4	499973.0
2011-11-08	AIVI	ETF	41.79	42.16	41.33	42.12	130900.0
2011-11-08	AMJ	ETF	37.73	37.93	37.024	37.29	1137773.0
2011-11-08	AMLP	ETF	80.0	80.2	78.75	79.1	196300.0
2011-11-08	AOA	ETF	33.8	34.0	33.42	34.0	3600.0
2011-11-08	AOK	ETF	29.44	29.5	29.44	29.5	25214.0
2011-11-08	AOM	ETF	30.27	30.3184	30.159	30.31	41063.0
2011-11-08	AOR	ETF	31.57	31.72	31.4648	31.72	29818.0
2011-11-08	ARB	ETF	42.55	42.69	41.0	42.52	238758.0
2011-11-08	ARGT	ETF	23.46	23.52	23.38	23.42	5350.0
2011-11-08	ASEA	ETF	15.36	15.5	15.24	15.46	3800.0
2011-11-08	AWAY	ETF	33.56	34.57	33.44	34.03	36385.0
2011-11-08	BAB	ETF	28.42	28.4649	28.259	28.35	146114.0
2011-11-08	BAL	ETF	59.63	60.73	59.46	60.7	36144.0
2011-11-08	BALT	ETF	5.35	5.56	5.25	5.49	84497.0
2011-11-08	BBH	ETF	35.6767	35.6833	35.2533	35.5733	21300.0
2011-11-08	BCM	ETF	45.41	45.5999	45.41	45.5999	339.0
2011-11-08	BIB	ETF	7.4475	7.5	7.2056	7.405	19376.0
2011-11-08	BICK	ETF	26.55	26.83	26.21	26.83	9319.0
2011-11-08	BIL	ETF	91.68	91.7	91.68	91.7	537300.0
2011-11-08	BIS	ETF	6358.4	6358.4	6358.4	6358.4	0.625
2011-11-08	BITS	ETF	22.16	22.4	21.556	22.36	2200.0
2011-11-08	BIV	ETF	87.95	88.03	87.58	87.65	136300.0
2011-11-08	BJK	ETF	32.82	33.02	32.37	33.02	10100.0
2011-11-08	BKF	ETF	41.15	41.73	40.72	41.57	1840372.0
2011-11-08	BKLN	ETF	24.2	24.2	24.0	24.02	100000.0
2011-11-08	BLNG	ETF	55.0	55.11	54.44	54.54	2500.0
2011-11-08	BLV	ETF	91.38	91.9	90.53	90.71	88200.0
2011-11-08	BMVP	ETF	14.063	14.131	13.867	14.131	21158.0
2011-11-08	BND	ETF	83.88	83.95	83.63	83.65	1891400.0

> showing 50 of 892 rows — these rows as CSV

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