PREVIEW / etf_daily / 2014-02-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-10.parquet
  size:    43 KB
  rows:    1,067

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
2014-02-10	SPY	ETF	179.7	180.07	179.21	180.01	92218800.0
2014-02-10	QQQ	ETF	87.23	87.84	87.21	87.8	30225157.0
2014-02-10	IWM	ETF	110.79	111.09	109.96	111.04	38211600.0
2014-02-10	DIA	ETF	157.76	157.82	157.13	157.75	4790700.0
2014-02-10	GLD	ETF	122.8	123.16	122.72	122.92	7931200.0
2014-02-10	TLT	ETF	106.61	107.12	106.57	107.09	4370500.0
2014-02-10	AADR	ETF	34.87	36.55	34.86	36.55	2700.0
2014-02-10	AAXJ	ETF	55.96	56.05	55.56	55.77	1033100.0
2014-02-10	ACWI	ETF	55.73	55.73	55.55	55.72	658200.0
2014-02-10	ACWV	ETF	61.12	61.34	61.12	61.3	27700.0
2014-02-10	ACWX	ETF	44.65	44.65	44.476	44.53	1593923.0
2014-02-10	ADRE	ETF	34.01	34.1	33.93	33.96	8578.0
2014-02-10	AFK	ETF	30.25	30.25	29.89	29.96	14628.0
2014-02-10	AGG	ETF	107.86	107.97	107.81	107.93	1097200.0
2014-02-10	AGQ	ETF	67.67	67.85	66.41	66.52	362700.0
2014-02-10	AGZ	ETF	111.665	111.83	111.665	111.74	17323.0
2014-02-10	AGZD	ETF	24.99	24.99	24.99	24.99	800.0
2014-02-10	AIA	ETF	43.63	43.63	43.38	43.52	11718.0
2014-02-10	AIQ	ETF	28.26	28.36	27.59	27.86	23945.0
2014-02-10	AIVI	ETF	46.64	46.68	46.5	46.64	21700.0
2014-02-10	AMJ	ETF	46.82	47.08	46.48	46.86	1102930.0
2014-02-10	AMLP	ETF	88.2	88.25	87.35	87.85	625500.0
2014-02-10	ANGL	ETF	26.85	27.19	26.85	27.15	10400.0
2014-02-10	AOA	ETF	43.6	43.6	43.43	43.6	19000.0
2014-02-10	AOK	ETF	31.88	31.88	31.84	31.88	6631.0
2014-02-10	AOM	ETF	34.05	34.05	33.96	34.05	25977.0
2014-02-10	AOR	ETF	37.96	37.96	37.89	37.96	29913.0
2014-02-10	ARGT	ETF	17.5	17.72	17.5	17.7	4300.0
2014-02-10	ASEA	ETF	14.96	14.96	14.82	14.85	15500.0
2014-02-10	ASHR	ETF	23.57	23.71	23.54	23.55	222400.0
2014-02-10	ATMP	ETF	29.21	29.25	27.45	28.74	10000.0
2014-02-10	AVIV	ETF	23.56	23.77	23.49	23.71	82523.0
2014-02-10	AWAY	ETF	39.75	40.53	39.75	39.98	605829.0
2014-02-10	BAB	ETF	28.23	28.3	28.195	28.28	131767.0
2014-02-10	BAL	ETF	55.19	55.8585	54.76	54.79	28538.0
2014-02-10	BALT	ETF	6.09	6.12	5.89	5.98	661527.0
2014-02-10	BBH	ETF	97.67	99.03	97.4	99.03	149200.0
2014-02-10	BCM	ETF	39.724	39.7396	39.59	39.59	53440.0
2014-02-10	BFOR	ETF	7.1725	7.1725	7.125	7.16	236400.0
2014-02-10	BIB	ETF	44.62	45.5	43.875	45.5	674364.0
2014-02-10	BICK	ETF	22.7	22.72	22.7	22.72	932.0
2014-02-10	BIL	ETF	91.54	91.56	91.52	91.54	1369150.0
2014-02-10	BIS	ETF	672.0	682.8	657.2	657.2	3200.0
2014-02-10	BIV	ETF	83.48	83.52	83.41	83.51	186600.0
2014-02-10	BIZD	ETF	20.75	20.94	20.75	20.94	6400.0
2014-02-10	BJK	ETF	51.45	51.45	50.95	51.09	16900.0
2014-02-10	BKF	ETF	34.56	34.56	34.1408	34.31	40848.0
2014-02-10	BKLN	ETF	24.91	24.91	24.89	24.9	2187600.0
2014-02-10	BLV	ETF	84.52	85.23	84.52	85.22	201900.0
2014-02-10	BMVP	ETF	22.0205	22.1467	22.0205	22.05	5503.0

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

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