PREVIEW / etf_daily / 2013-05-09

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-09.parquet
  size:    40 KB
  rows:    991

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-05-09	SPY	ETF	163.27	163.7	162.47	162.88	106738600.0
2013-05-09	QQQ	ETF	72.55	73.099	72.47	72.6065	29344426.0
2013-05-09	IWM	ETF	96.3	96.51	95.75	96.1	32331100.0
2013-05-09	DIA	ETF	150.9	151.37	150.39	150.84	3948500.0
2013-05-09	GLD	ETF	141.33	142.36	140.51	140.81	8263000.0
2013-05-09	TLT	ETF	120.51	121.32	119.98	120.04	7527000.0
2013-05-09	AAXJ	ETF	61.34	61.47	61.0	61.22	419300.0
2013-05-09	ACTV	ETF	5.84	5.87	5.73	5.74	389295.0
2013-05-09	ACWI	ETF	53.31	53.31	52.88	53.02	460600.0
2013-05-09	ACWV	ETF	64.11	64.11	63.62	63.65	76500.0
2013-05-09	ACWX	ETF	45.05	45.13	44.73	44.89	1129555.0
2013-05-09	ADRE	ETF	39.87	40.1	39.71	39.75	17898.0
2013-05-09	AFK	ETF	30.73	30.849	30.6001	30.68	40726.0
2013-05-09	AGEM	ETF	23.2378	23.2378	22.9338	22.9338	670.0
2013-05-09	AGG	ETF	110.85	110.95	110.7	110.7	537900.0
2013-05-09	AGQ	ETF	102.52	104.04	100.28	101.32	288225.0
2013-05-09	AGZ	ETF	113.41	113.56	113.37	113.37	5548.0
2013-05-09	AIA	ETF	47.74	47.82	47.55	47.62	12554.0
2013-05-09	AIQ	ETF	13.03	13.11	12.5	12.83	7789.0
2013-05-09	AIVI	ETF	44.41	44.48	44.08	44.15	64400.0
2013-05-09	AMJ	ETF	47.55	48.19	47.1299	48.08	1564895.0
2013-05-09	AMLP	ETF	88.4	88.85	88.25	88.75	629780.0
2013-05-09	ANGL	ETF	27.86	27.98	27.38	27.91	6900.0
2013-05-09	AOA	ETF	41.2	41.22	40.97	41.01	62000.0
2013-05-09	AOK	ETF	31.7	31.7	31.6	31.6	20498.0
2013-05-09	AOM	ETF	33.49	33.4999	33.35	33.37	18054.0
2013-05-09	AOR	ETF	36.64	36.64	36.518	36.53	18796.0
2013-05-09	ARB	ETF	46.75	46.8	46.735	46.79	187665.0
2013-05-09	ARGT	ETF	18.04	18.18	18.0	18.0	2700.0
2013-05-09	ASEA	ETF	18.97	18.97	18.8	18.84	422900.0
2013-05-09	ATMP	ETF	26.47	26.54	26.43	26.49	49200.0
2013-05-09	AVIV	ETF	29.75	29.75	28.68	28.72	402612.0
2013-05-09	AWAY	ETF	28.71	29.22	28.561	29.12	851837.0
2013-05-09	BAB	ETF	30.71	30.839	30.68	30.73	222564.0
2013-05-09	BAL	ETF	55.11	55.77	54.88	55.14	47992.0
2013-05-09	BALT	ETF	3.46	3.66	3.41	3.59	405803.0
2013-05-09	BBH	ETF	70.82	71.18	70.54	70.64	50600.0
2013-05-09	BCM	ETF	41.072	41.162	40.994	40.994	954.0
2013-05-09	BIB	ETF	23.405	23.5	23.125	23.1625	175472.0
2013-05-09	BICK	ETF	24.57	24.6215	24.4	24.4	2094.0
2013-05-09	BIL	ETF	91.6	91.62	91.6	91.62	59800.0
2013-05-09	BIS	ETF	1559.6	1562.4	1540.0	1555.6	163.0
2013-05-09	BIV	ETF	88.16	88.23	88.06	88.1	171100.0
2013-05-09	BIZD	ETF	20.88	20.88	20.42	20.42	11800.0
2013-05-09	BJK	ETF	43.3	43.4	43.1	43.24	8500.0
2013-05-09	BKF	ETF	40.28	40.4065	39.97	40.08	141095.0
2013-05-09	BKLN	ETF	25.31	25.31	25.29	25.3	2824500.0
2013-05-09	BLV	ETF	93.49	93.79	93.2	93.21	42900.0
2013-05-09	BMVP	ETF	19.134	19.134	19.134	19.134	100.0
2013-05-09	BND	ETF	83.74	83.8	83.63	83.64	830200.0

> showing 50 of 991 rows — these rows as CSV

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