PREVIEW / etf_daily / 2011-11-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-28.parquet
  size:    37 KB
  rows:    899

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-28	SPY	ETF	119.54	120.18	118.82	119.71	210686000.0
2011-11-28	QQQ	ETF	54.16	54.79	54.14	54.72	46710682.0
2011-11-28	IWM	ETF	69.09	69.92	68.91	69.79	59167100.0
2011-11-28	DIA	ETF	114.78	115.48	114.31	115.1	6666100.0
2011-11-28	GLD	ETF	166.93	167.14	165.98	166.63	12004000.0
2011-11-28	TLT	ETF	118.63	121.15	118.58	120.74	7661900.0
2011-11-28	AADR	ETF	27.23	27.23	27.23	27.23	400.0
2011-11-28	AAXJ	ETF	49.86	50.08	49.62	49.94	427600.0
2011-11-28	ACTV	ETF	12.99	13.0	12.5	12.95	877300.0
2011-11-28	ACWI	ETF	41.02	41.08	40.65	40.92	586200.0
2011-11-28	ACWV	ETF	49.0	49.0	49.0	49.0	200.0
2011-11-28	ACWX	ETF	36.15	36.191	35.89	36.14	233226.0
2011-11-28	ADRE	ETF	38.12	38.25	37.77	38.2	67015.0
2011-11-28	AFK	ETF	26.59	26.59	26.08	26.28	13870.0
2011-11-28	AGEM	ETF	20.82	20.9755	20.82	20.8223	6830.0
2011-11-28	AGG	ETF	109.37	109.67	109.24	109.62	1726100.0
2011-11-28	AGQ	ETF	232.52	235.0	230.0	232.08	524275.0
2011-11-28	AGZ	ETF	112.3	112.548	112.2818	112.5	46620.0
2011-11-28	AIA	ETF	39.6	39.6	39.12	39.29	17618.0
2011-11-28	AIQ	ETF	5.75	6.0	5.6	5.7	30615.0
2011-11-28	AIS	ETF	2.6	2.63	2.53	2.62	1772092.0
2011-11-28	AIVI	ETF	38.78	38.82	38.31	38.54	75500.0
2011-11-28	AMJ	ETF	36.79	36.86	36.24	36.63	1196572.0
2011-11-28	AMLP	ETF	79.6	80.0	79.4	79.5	199320.0
2011-11-28	AOA	ETF	31.74	31.88	31.61	31.8	9600.0
2011-11-28	AOK	ETF	28.96	28.99	28.92	28.99	41350.0
2011-11-28	AOM	ETF	29.42	29.45	29.3799	29.45	15472.0
2011-11-28	AOR	ETF	30.32	30.38	30.27	30.38	27164.0
2011-11-28	ARB	ETF	37.29	37.5	36.705	37.07	271653.0
2011-11-28	ARGT	ETF	21.66	21.72	21.5	21.5	1150.0
2011-11-28	ASEA	ETF	14.36	14.46	14.33	14.42	9300.0
2011-11-28	AWAY	ETF	27.35	27.5	25.57	25.68	480925.0
2011-11-28	BAB	ETF	28.67	28.888	28.352	28.77	336418.0
2011-11-28	BAL	ETF	56.92	57.27	56.156	56.17	15053.0
2011-11-28	BALT	ETF	4.58	4.7	4.55	4.63	163852.0
2011-11-28	BBH	ETF	33.99	34.29	33.97	34.24	66900.0
2011-11-28	BCM	ETF	43.52	43.57	43.52	43.57	2572.0
2011-11-28	BIB	ETF	7.515	7.7688	7.515	7.7425	36376.0
2011-11-28	BICK	ETF	23.54	23.54	23.35	23.47	10613.0
2011-11-28	BIL	ETF	91.68	91.7	91.68	91.7	467550.0
2011-11-28	BIS	ETF	6126.4	6126.4	5953.6	5953.6	8.1
2011-11-28	BITS	ETF	21.88	21.88	21.36	21.6	16100.0
2011-11-28	BIV	ETF	86.96	87.49	86.77	87.4	150800.0
2011-11-28	BJK	ETF	29.79	30.0	29.69	29.82	36500.0
2011-11-28	BKF	ETF	36.51	36.8	36.42	36.8	259790.0
2011-11-28	BKLN	ETF	23.74	23.91	23.71	23.8	271300.0
2011-11-28	BLNG	ETF	52.15	52.15	52.1499	52.1499	300.0
2011-11-28	BLV	ETF	90.68	92.05	90.42	91.72	88600.0
2011-11-28	BMVP	ETF	13.0167	13.1264	12.99	13.0333	10043.0
2011-11-28	BND	ETF	83.35	83.73	83.28	83.66	1550300.0

> showing 50 of 899 rows — these rows as CSV

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