PREVIEW / etf_daily / 2011-11-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-29.parquet
  size:    37 KB
  rows:    887

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-29	SPY	ETF	120.05	121.0	119.61	120.05	199241500.0
2011-11-29	QQQ	ETF	54.65	55.1	54.22	54.38	52056611.0
2011-11-29	IWM	ETF	69.84	70.18	69.12	69.66	58157100.0
2011-11-29	DIA	ETF	115.32	116.18	115.11	115.56	5325400.0
2011-11-29	GLD	ETF	166.4	167.33	166.08	166.88	9198900.0
2011-11-29	TLT	ETF	120.03	120.92	119.08	119.75	8952800.0
2011-11-29	AAXJ	ETF	49.98	50.54	49.87	49.97	262500.0
2011-11-29	ACTV	ETF	12.91	13.0	12.56	12.75	578866.0
2011-11-29	ACWI	ETF	41.07	41.31	40.86	41.08	458500.0
2011-11-29	ACWV	ETF	49.28	49.28	49.28	49.28	200.0
2011-11-29	ACWX	ETF	36.16	36.49	36.12	36.33	258964.0
2011-11-29	ADRE	ETF	37.97	38.36	37.9	37.9	22703.0
2011-11-29	AFK	ETF	26.34	26.49	26.2789	26.2789	8720.0
2011-11-29	AGEM	ETF	20.78	21.05	20.78	20.97	10230.0
2011-11-29	AGG	ETF	109.49	109.71	109.27	109.66	1718500.0
2011-11-29	AGQ	ETF	228.56	233.04	226.64	228.92	396025.0
2011-11-29	AGZ	ETF	112.2932	112.62	112.15	112.31	109598.0
2011-11-29	AIA	ETF	39.59	39.8	39.3012	39.35	8985.0
2011-11-29	AIQ	ETF	5.7	5.95	5.7	5.75	17579.0
2011-11-29	AIS	ETF	2.62	2.63	2.55	2.58	946261.0
2011-11-29	AIVI	ETF	38.84	39.22	38.61	38.99	86700.0
2011-11-29	AMJ	ETF	36.73	36.87	36.56	36.77	895389.0
2011-11-29	AMLP	ETF	79.8	79.85	79.45	79.7	188000.0
2011-11-29	AOA	ETF	31.86	31.93	31.76	31.87	12300.0
2011-11-29	AOK	ETF	29.01	29.04	28.978	29.02	13518.0
2011-11-29	AOM	ETF	29.44	29.53	29.43	29.5	14669.0
2011-11-29	AOR	ETF	30.43	30.5	30.37	30.42	27623.0
2011-11-29	ARB	ETF	37.5	37.95	35.95	36.34	166847.0
2011-11-29	ARGT	ETF	21.78	21.78	21.78	21.78	250.0
2011-11-29	ASEA	ETF	14.46	14.59	14.39	14.4	7500.0
2011-11-29	AWAY	ETF	25.59	25.92	25.11	25.57	598176.0
2011-11-29	BAB	ETF	28.67	28.79	28.53	28.62	141324.0
2011-11-29	BAL	ETF	56.02	57.49	54.73	57.03	50101.0
2011-11-29	BALT	ETF	4.63	4.63	4.42	4.52	54696.0
2011-11-29	BBH	ETF	34.24	34.36	34.1167	34.15	40200.0
2011-11-29	BCM	ETF	43.994	43.994	43.82	43.87	625.0
2011-11-29	BIB	ETF	7.8187	7.8438	7.7475	7.8075	6400.0
2011-11-29	BICK	ETF	23.49	23.64	23.4	23.4799	4133.0
2011-11-29	BIL	ETF	91.68	91.7	91.66	91.66	537700.0
2011-11-29	BIS	ETF	5913.6	5913.6	5905.6	5905.6	2.81
2011-11-29	BITS	ETF	21.8	21.8	21.48	21.6	4000.0
2011-11-29	BIV	ETF	87.19	87.4	86.97	87.24	131300.0
2011-11-29	BJK	ETF	30.18	30.52	29.94	30.04	13600.0
2011-11-29	BKF	ETF	36.62	36.8288	36.16	36.19	1856237.0
2011-11-29	BKLN	ETF	23.79	23.97	23.68	23.71	61500.0
2011-11-29	BLV	ETF	91.29	91.76	90.71	90.85	190500.0
2011-11-29	BMVP	ETF	13.1033	13.18	13.08	13.1717	4717.0
2011-11-29	BND	ETF	83.55	83.7	83.39	83.54	744300.0
2011-11-29	BNO	ETF	38.21	38.45	38.125	38.375	81200.0
2011-11-29	BOIL	ETF	3015000.0	3078000.0	3007000.0	3076000.0	0.4

> showing 50 of 887 rows — these rows as CSV

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