PREVIEW / etf_daily / 2013-06-27

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-27.parquet
  size:    41 KB
  rows:    1,006

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-06-27	SPY	ETF	161.1	161.82	160.95	161.08	129483700.0
2013-06-27	QQQ	ETF	71.22	71.62	71.13	71.17	23546417.0
2013-06-27	IWM	ETF	96.65	97.74	96.61	97.56	40852300.0
2013-06-27	DIA	ETF	149.69	150.42	149.55	149.9	6584600.0
2013-06-27	GLD	ETF	119.1	119.51	115.65	115.94	30001900.0
2013-06-27	TLT	ETF	109.54	109.97	108.95	109.69	12026000.0
2013-06-27	AADR	ETF	32.42	32.52	32.42	32.52	2000.0
2013-06-27	AAXJ	ETF	54.05	54.59	54.05	54.45	381400.0
2013-06-27	ACTV	ETF	7.04	7.27	6.979	7.27	513828.0
2013-06-27	ACWI	ETF	50.09	50.29	50.03	50.13	1849100.0
2013-06-27	ACWV	ETF	59.61	59.77	59.48	59.66	29700.0
2013-06-27	ACWX	ETF	40.57	40.79	40.545	40.68	224060.0
2013-06-27	ADRE	ETF	33.87	34.18	33.87	34.14	37367.0
2013-06-27	AFK	ETF	26.98	26.98	26.74	26.91	78843.0
2013-06-27	AGEM	ETF	20.2	20.43	20.2	20.4128	1800.0
2013-06-27	AGG	ETF	106.98	107.2	106.9	107.2	1333700.0
2013-06-27	AGQ	ETF	62.6	63.32	60.04	60.68	770625.0
2013-06-27	AGZ	ETF	110.7	110.86	110.6	110.69	31870.0
2013-06-27	AIA	ETF	42.05	42.32	42.05	42.25	29593.0
2013-06-27	AIQ	ETF	15.99	16.0	15.53	15.66	26639.0
2013-06-27	AIVI	ETF	40.08	40.42	40.08	40.29	75300.0
2013-06-27	ALTL	ETF	28.31	28.39	28.3	28.39	1848.0
2013-06-27	AMJ	ETF	47.08	47.86	46.42	47.77	2130889.0
2013-06-27	AMLP	ETF	88.6	89.35	88.5	89.2	802020.0
2013-06-27	ANGL	ETF	26.53	26.63	26.46	26.46	5900.0
2013-06-27	AOA	ETF	39.86	40.03	39.86	39.97	15000.0
2013-06-27	AOK	ETF	30.76	30.7959	30.7301	30.76	44483.0
2013-06-27	AOM	ETF	32.4	32.4899	32.4	32.41	26123.0
2013-06-27	AOR	ETF	35.48	35.5899	35.47	35.49	54024.0
2013-06-27	ARB	ETF	45.95	46.31	45.89	46.23	511824.0
2013-06-27	ARGT	ETF	15.85	16.14	15.85	16.14	300.0
2013-06-27	ASEA	ETF	16.84	16.92	16.8	16.87	92400.0
2013-06-27	ATMP	ETF	25.85	25.98	25.84	25.95	105600.0
2013-06-27	AVIV	ETF	24.84	25.46	24.84	25.3	252855.0
2013-06-27	AWAY	ETF	32.41	32.9	30.31	32.53	1478971.0
2013-06-27	BAB	ETF	28.14	28.36	28.101	28.21	289207.0
2013-06-27	BAL	ETF	53.58	53.828	53.45	53.8001	5643.0
2013-06-27	BALT	ETF	3.51	3.7	3.5001	3.62	76280.0
2013-06-27	BBH	ETF	69.05	69.25	68.27	68.73	145100.0
2013-06-27	BCM	ETF	38.81	38.81	38.5101	38.5101	2531.0
2013-06-27	BFOR	ETF	6.17	6.2175	6.17	6.2125	364000.0
2013-06-27	BIB	ETF	23.075	23.1247	22.5903	22.95	142576.0
2013-06-27	BICK	ETF	20.85	21.01	20.85	20.93	13566.0
2013-06-27	BIL	ETF	91.62	91.62	91.6	91.6	185250.0
2013-06-27	BIS	ETF	1520.0	1531.68	1506.8	1523.24	100.0
2013-06-27	BIV	ETF	83.42	83.56	83.28	83.52	482400.0
2013-06-27	BIZD	ETF	19.65	19.88	19.61	19.8	15600.0
2013-06-27	BJK	ETF	40.34	40.4	40.21	40.34	27100.0
2013-06-27	BKF	ETF	33.63	34.059	33.6	33.93	57376.0
2013-06-27	BKLN	ETF	24.71	24.74	24.69	24.74	5090700.0

> showing 50 of 1,006 rows — these rows as CSV

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