PREVIEW / etf_daily / 2013-01-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-28.parquet
  size:    40 KB
  rows:    972

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-01-28	SPY	ETF	150.29	150.33	149.51	150.07	113357700.0
2013-01-28	QQQ	ETF	67.01	67.38	66.93	67.15	32933927.0
2013-01-28	IWM	ETF	90.01	90.23	89.38	90.0	42633600.0
2013-01-28	DIA	ETF	138.85	138.88	138.3	138.65	3167700.0
2013-01-28	GLD	ETF	160.24	160.73	160.02	160.29	8491600.0
2013-01-28	TLT	ETF	117.02	117.72	117.0	117.6	6059900.0
2013-01-28	AADR	ETF	32.7	32.98	32.56	32.75	4100.0
2013-01-28	AAXJ	ETF	60.12	60.12	59.75	59.9	952000.0
2013-01-28	ACTV	ETF	5.57	5.71	5.5	5.65	425174.0
2013-01-28	ACWI	ETF	50.04	50.04	49.73	49.88	1063700.0
2013-01-28	ACWV	ETF	57.75	57.8	57.4	57.63	409900.0
2013-01-28	ACWX	ETF	43.08	43.08	42.85	42.91	235961.0
2013-01-28	ADRE	ETF	40.91	40.98	40.69	40.79	19378.0
2013-01-28	AFK	ETF	31.18	31.18	30.75	30.89	63995.0
2013-01-28	AGEM	ETF	23.72	23.77	23.5901	23.7651	4062.0
2013-01-28	AGG	ETF	110.28	110.42	110.27	110.41	1067500.0
2013-01-28	AGQ	ETF	182.04	183.28	179.4	180.84	222725.0
2013-01-28	AGZ	ETF	113.06	113.15	112.98	113.08	18468.0
2013-01-28	AIA	ETF	47.02	47.02	46.6501	46.85	53992.0
2013-01-28	AIQ	ETF	6.45	6.45	6.25	6.31	57419.0
2013-01-28	AIVI	ETF	43.19	43.19	43.0	43.16	46500.0
2013-01-28	AMJ	ETF	42.42	42.69	42.34	42.63	985695.0
2013-01-28	AMLP	ETF	84.95	85.5	84.8	85.5	728500.0
2013-01-28	ANGL	ETF	27.53	27.53	27.2	27.24	6200.0
2013-01-28	AOA	ETF	38.78	38.78	38.61	38.71	34800.0
2013-01-28	AOK	ETF	30.92	30.92	30.858	30.8898	14528.0
2013-01-28	AOM	ETF	32.38	32.38	32.22	32.25	40952.0
2013-01-28	AOR	ETF	34.91	34.939	34.8102	34.919	35640.0
2013-01-28	ARB	ETF	47.09	47.1	46.98	47.0	124990.0
2013-01-28	ARGT	ETF	18.38	18.38	18.08	18.1	5950.0
2013-01-28	ASEA	ETF	16.96	16.99	16.82	16.88	111700.0
2013-01-28	AWAY	ETF	23.33	23.33	22.96	23.31	240909.0
2013-01-28	BAB	ETF	29.95	30.05	29.94	29.99	414294.0
2013-01-28	BAL	ETF	52.96	53.25	52.8001	53.139	18226.0
2013-01-28	BALT	ETF	3.39	3.39	3.31	3.32	27313.0
2013-01-28	BBH	ETF	58.07	58.07	57.4	57.63	21000.0
2013-01-28	BCM	ETF	44.45	44.45	44.45	44.45	100.0
2013-01-28	BIB	ETF	16.4725	16.565	16.2462	16.315	75368.0
2013-01-28	BICK	ETF	25.53	25.6	25.5018	25.5356	529481.0
2013-01-28	BIL	ETF	91.6	91.62	91.6	91.6	285500.0
2013-01-28	BIS	ETF	2311.6	2343.52	2311.6	2341.6	16.4
2013-01-28	BIV	ETF	87.36	87.5	87.31	87.48	457500.0
2013-01-28	BJK	ETF	38.23	38.23	38.02	38.07	13100.0
2013-01-28	BKF	ETF	42.03	42.03	41.59	41.68	88156.0
2013-01-28	BKLN	ETF	25.23	25.25	25.22	25.22	1588400.0
2013-01-28	BLV	ETF	91.7	92.22	91.53	92.16	260600.0
2013-01-28	BMVP	ETF	17.54	17.55	17.46	17.53	20077.0
2013-01-28	BND	ETF	83.4	83.52	83.37	83.48	1427100.0
2013-01-28	BNO	ETF	42.325	42.325	42.01	42.25	23400.0
2013-01-28	BOIL	ETF	754400.0	762400.0	741200.0	742600.0	20.2

> showing 50 of 972 rows — these rows as CSV

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