PREVIEW / etf_daily / 2013-02-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-25.parquet
  size:    40 KB
  rows:    983

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
2013-02-25	SPY	ETF	152.63	152.86	149.0	149.0	245824800.0
2013-02-25	QQQ	ETF	67.6	67.81	66.25	66.31	40927523.0
2013-02-25	IWM	ETF	91.5	91.53	88.97	89.02	53492800.0
2013-02-25	DIA	ETF	140.33	140.59	137.6	137.66	10031600.0
2013-02-25	GLD	ETF	153.52	154.56	153.31	154.34	9488200.0
2013-02-25	TLT	ETF	116.35	119.35	116.29	119.33	15948700.0
2013-02-25	AADR	ETF	33.1	33.1	33.1	33.1	100.0
2013-02-25	AAXJ	ETF	60.4	60.45	59.11	59.16	556600.0
2013-02-25	ACTV	ETF	4.85	5.01	4.755	4.81	543070.0
2013-02-25	ACWI	ETF	50.24	50.31	49.01	49.03	1300200.0
2013-02-25	ACWV	ETF	59.24	59.24	58.45	58.45	36000.0
2013-02-25	ACWX	ETF	43.02	43.03	41.791	41.81	253899.0
2013-02-25	ADRE	ETF	39.56	39.75	38.91	38.91	35510.0
2013-02-25	AFK	ETF	31.08	31.08	30.24	30.24	30554.0
2013-02-25	AGEM	ETF	22.97	22.97	22.64	22.64	2081.0
2013-02-25	AGG	ETF	110.29	110.78	110.2	110.73	1181500.0
2013-02-25	AGQ	ETF	158.4	160.48	157.96	159.16	274750.0
2013-02-25	AGZ	ETF	113.17	113.33	113.13	113.33	17005.0
2013-02-25	AIA	ETF	47.47	47.51	46.56	46.59	34027.0
2013-02-25	AIQ	ETF	6.98	7.049	6.89	6.9	3848.0
2013-02-25	AIVI	ETF	42.61	42.62	41.2	41.21	74000.0
2013-02-25	AMJ	ETF	43.46	43.61	42.89	42.99	2529807.0
2013-02-25	AMLP	ETF	85.4	85.55	84.45	84.5	511000.0
2013-02-25	ANGL	ETF	26.92	27.04	26.92	27.02	400.0
2013-02-25	AOA	ETF	39.03	39.03	38.24	38.24	22200.0
2013-02-25	AOK	ETF	30.93	30.93	30.76	30.76	7395.0
2013-02-25	AOM	ETF	32.39	32.42	32.14	32.16	13439.0
2013-02-25	AOR	ETF	35.19	35.19	34.68	34.7	25741.0
2013-02-25	ARB	ETF	47.0	47.0	46.85	46.85	280976.0
2013-02-25	ARGT	ETF	17.58	17.68	17.14	17.14	2850.0
2013-02-25	ASEA	ETF	17.21	17.26	16.98	16.98	18100.0
2013-02-25	AWAY	ETF	28.08	29.44	27.74	27.81	2433688.0
2013-02-25	BAB	ETF	30.13	30.48	30.09	30.44	275780.0
2013-02-25	BAL	ETF	53.25	53.41	52.51	52.6	22359.0
2013-02-25	BALT	ETF	3.48	3.51	3.45	3.46	48522.0
2013-02-25	BBH	ETF	58.79	59.19	58.0	58.12	240700.0
2013-02-25	BCM	ETF	43.32	43.34	43.32	43.3399	4858.0
2013-02-25	BIB	ETF	16.38	16.555	15.9225	15.9225	69848.0
2013-02-25	BICK	ETF	24.67	25.129	24.67	24.67	932.0
2013-02-25	BIL	ETF	91.62	91.62	91.6	91.6	125400.0
2013-02-25	BIS	ETF	2280.0	2359.2	2273.2	2359.2	43.25
2013-02-25	BIV	ETF	87.35	87.92	87.32	87.9	242900.0
2013-02-25	BIZD	ETF	20.48	20.48	20.0	20.01	11000.0
2013-02-25	BJK	ETF	38.4	38.56	37.57	37.57	28100.0
2013-02-25	BKF	ETF	40.25	40.35	39.4	39.46	86116.0
2013-02-25	BKLN	ETF	25.0	25.02	24.98	24.98	5806800.0
2013-02-25	BLNG	ETF	46.6	46.96	46.6	46.96	450.0
2013-02-25	BLV	ETF	90.96	92.75	90.96	92.74	56600.0
2013-02-25	BMVP	ETF	17.82	17.82	17.37	17.37	12702.0
2013-02-25	BND	ETF	83.36	83.71	83.31	83.67	1017700.0

> showing 50 of 983 rows — these rows as CSV

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