PREVIEW / etf_daily / 2011-09-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-28.parquet
  size:    36 KB
  rows:    867

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-09-28	SPY	ETF	117.78	118.49	114.97	115.14	286696800.0
2011-09-28	QQQ	ETF	55.57	55.97	54.4	54.53	76757052.0
2011-09-28	IWM	ETF	67.79	68.12	65.1	65.2	85412600.0
2011-09-28	DIA	ETF	112.1	112.96	109.74	109.83	11260200.0
2011-09-28	GLD	ETF	160.73	161.29	155.56	156.22	21776000.0
2011-09-28	TLT	ETF	116.9	117.11	115.76	117.03	12642600.0
2011-09-28	AADR	ETF	26.91	26.91	26.91	26.91	100.0
2011-09-28	AAXJ	ETF	48.94	49.34	48.16	48.18	534400.0
2011-09-28	ACTV	ETF	15.08	15.63	14.41	14.91	74255.0
2011-09-28	ACWI	ETF	40.96	41.1	39.92	39.97	595300.0
2011-09-28	ACWX	ETF	36.62	36.742	35.71	35.72	239644.0
2011-09-28	ADRE	ETF	37.8	37.831	36.82	36.85	38022.0
2011-09-28	AFK	ETF	26.9	26.9	26.09	26.13	13549.0
2011-09-28	AGEM	ETF	20.79	20.79	20.28	20.28	2372.0
2011-09-28	AGG	ETF	109.79	109.8	109.52	109.74	850400.0
2011-09-28	AGQ	ETF	235.48	239.3	205.0	207.2	1173700.0
2011-09-28	AGZ	ETF	112.46	112.51	112.42	112.4865	2752.0
2011-09-28	AIA	ETF	37.91	38.1683	37.16	37.16	48796.0
2011-09-28	AIQ	ETF	6.05	6.05	5.1	5.65	120766.0
2011-09-28	AIS	ETF	2.37	2.42	2.24	2.25	526487.0
2011-09-28	AIVI	ETF	39.4	39.5	38.32	38.39	47300.0
2011-09-28	AMJ	ETF	34.88	34.91	34.06	34.11	339402.0
2011-09-28	AMLP	ETF	76.75	77.25	76.3	76.4	103900.0
2011-09-28	AOA	ETF	31.2	31.21	30.75	30.75	4200.0
2011-09-28	AOK	ETF	28.9	28.9	28.7608	28.77	9742.0
2011-09-28	AOM	ETF	29.2899	29.2899	29.0629	29.13	10124.0
2011-09-28	AOR	ETF	30.16	30.16	29.8036	29.858	3065.0
2011-09-28	ARB	ETF	37.51	37.51	34.97	34.97	126317.0
2011-09-28	ARGT	ETF	20.5	20.5	20.46	20.46	350.0
2011-09-28	ASEA	ETF	14.08	14.1	13.89	13.89	5500.0
2011-09-28	AWAY	ETF	37.03	37.57	33.9	34.26	204432.0
2011-09-28	BAB	ETF	28.26	28.3989	28.19	28.34	184355.0
2011-09-28	BAL	ETF	61.64	62.05	61.15	61.15	42287.0
2011-09-28	BALT	ETF	5.0	5.06	4.72	4.73	124382.0
2011-09-28	BBH	ETF	33.4933	33.67	32.9	32.9	13800.0
2011-09-28	BCM	ETF	43.03	43.1	42.15	42.15	5772.0
2011-09-28	BIB	ETF	7.5187	7.5637	7.185	7.185	23320.0
2011-09-28	BICK	ETF	23.25	23.3573	22.65	22.65	17301.0
2011-09-28	BIL	ETF	91.7	91.7	91.68	91.7	383650.0
2011-09-28	BITS	ETF	22.04	22.4	21.36	22.16	1642.0
2011-09-28	BIV	ETF	87.5	87.51	87.11	87.49	416200.0
2011-09-28	BJK	ETF	30.4	30.59	29.85	29.85	351900.0
2011-09-28	BKF	ETF	35.96	36.34	35.1	35.16	179304.0
2011-09-28	BKLN	ETF	23.24	23.28	23.08	23.16	49000.0
2011-09-28	BLNG	ETF	50.21	50.21	48.63	48.87	1069.0
2011-09-28	BLV	ETF	90.25	90.33	89.36	90.12	60800.0
2011-09-28	BMVP	ETF	12.92	12.95	12.59	12.59	3189.0
2011-09-28	BND	ETF	83.6	83.63	83.4	83.44	2090900.0
2011-09-28	BNO	ETF	35.88	35.995	34.775	34.835	318600.0
2011-09-28	BRF	ETF	41.91	42.08	40.5	40.5	174946.0

> showing 50 of 867 rows — these rows as CSV

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