PREVIEW / etf_daily / 2013-05-10

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-10.parquet
  size:    40 KB
  rows:    984

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-10	SPY	ETF	162.99	163.55	162.51	163.41	103203000.0
2013-05-10	QQQ	ETF	72.73	73.08	72.63	73.05	20663682.0
2013-05-10	IWM	ETF	96.21	96.93	96.07	96.83	39288900.0
2013-05-10	DIA	ETF	150.91	151.1	150.29	151.04	4138200.0
2013-05-10	GLD	ETF	138.22	139.75	137.26	139.6	14650600.0
2013-05-10	TLT	ETF	119.76	119.79	117.85	118.75	11689000.0
2013-05-10	AADR	ETF	35.37	35.37	35.0	35.0	200.0
2013-05-10	AAXJ	ETF	60.75	60.93	60.62	60.91	289400.0
2013-05-10	ACTV	ETF	5.74	6.1	5.74	6.0	619624.0
2013-05-10	ACWI	ETF	52.99	53.13	52.82	53.12	695900.0
2013-05-10	ACWV	ETF	63.58	63.66	63.36	63.66	26200.0
2013-05-10	ACWX	ETF	44.75	44.86	44.594	44.84	135049.0
2013-05-10	ADRE	ETF	39.71	39.73	39.423	39.57	16400.0
2013-05-10	AFK	ETF	30.6	30.6	30.39	30.552	20082.0
2013-05-10	AGEM	ETF	23.0057	23.0057	23.0057	23.0057	276.0
2013-05-10	AGG	ETF	110.69	110.74	110.35	110.48	423100.0
2013-05-10	AGQ	ETF	97.96	102.64	97.12	102.32	461225.0
2013-05-10	AGZ	ETF	113.39	113.39	113.19	113.29	19430.0
2013-05-10	AIA	ETF	47.11	47.264	47.05	47.25	21180.0
2013-05-10	AIQ	ETF	12.63	12.85	10.52	12.7	23146.0
2013-05-10	AIVI	ETF	44.13	44.3	44.01	44.29	22800.0
2013-05-10	ALTL	ETF	29.39	29.39	29.39	29.39	252.0
2013-05-10	AMJ	ETF	47.81	48.13	47.55	47.78	1385764.0
2013-05-10	AMLP	ETF	89.0	89.3	88.65	89.2	389280.0
2013-05-10	ANGL	ETF	27.97	28.02	27.77	27.78	8600.0
2013-05-10	AOA	ETF	41.08	41.15	41.0	41.15	46900.0
2013-05-10	AOK	ETF	31.629	31.629	31.561	31.62	10501.0
2013-05-10	AOM	ETF	33.37	33.4	33.3198	33.37	13185.0
2013-05-10	AOR	ETF	36.58	36.58	36.45	36.54	24152.0
2013-05-10	ARB	ETF	46.79	46.81	46.78	46.8	87141.0
2013-05-10	ARGT	ETF	17.78	17.9	17.78	17.9	2000.0
2013-05-10	ASEA	ETF	18.84	18.89	18.75	18.84	129100.0
2013-05-10	ATMP	ETF	26.84	26.84	26.46	26.6	38500.0
2013-05-10	AVIV	ETF	28.99	29.1	28.72	28.95	158567.0
2013-05-10	AWAY	ETF	29.15	30.12	28.9296	29.54	989589.0
2013-05-10	BAB	ETF	30.64	30.7	30.45	30.58	251536.0
2013-05-10	BAL	ETF	55.01	55.79	53.86	54.65	118143.0
2013-05-10	BALT	ETF	3.62	3.67	3.47	3.51	37457.0
2013-05-10	BBH	ETF	70.78	72.58	70.6	72.41	86400.0
2013-05-10	BCM	ETF	40.63	40.82	40.63	40.82	909.0
2013-05-10	BIB	ETF	23.29	24.6425	23.25	24.5125	206216.0
2013-05-10	BICK	ETF	24.28	24.31	24.17	24.29	2365.0
2013-05-10	BIL	ETF	91.6	91.62	91.6	91.6	77150.0
2013-05-10	BIS	ETF	1547.2	1564.76	1486.4	1486.4	212.0
2013-05-10	BIV	ETF	87.91	87.97	87.55	87.71	189000.0
2013-05-10	BIZD	ETF	20.46	20.46	20.38	20.45	22000.0
2013-05-10	BJK	ETF	43.18	43.33	43.12	43.33	11400.0
2013-05-10	BKF	ETF	40.11	40.13	39.86	40.03	76984.0
2013-05-10	BKLN	ETF	25.32	25.32	25.29	25.32	1944000.0
2013-05-10	BLV	ETF	92.98	93.13	92.0	92.43	32500.0

> showing 50 of 984 rows — these rows as CSV

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