PREVIEW / etf_daily / 2014-04-17

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-17.parquet
  size:    44 KB
  rows:    1,079

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-04-17	SPY	ETF	185.88	186.91	185.56	186.39	105255000.0
2014-04-17	QQQ	ETF	85.89	86.63	85.63	86.2	53719454.0
2014-04-17	IWM	ETF	111.99	113.41	111.72	112.92	50275100.0
2014-04-17	DIA	ETF	163.61	164.19	163.33	163.75	5790700.0
2014-04-17	GLD	ETF	125.38	125.53	124.57	124.75	5901900.0
2014-04-17	TLT	ETF	111.37	111.45	109.7	110.05	8622500.0
2014-04-17	AADR	ETF	37.89	37.93	37.66	37.75	2900.0
2014-04-17	AAXJ	ETF	60.74	61.07	60.67	60.87	149700.0
2014-04-17	ACWI	ETF	58.15	58.42	58.03	58.3	292500.0
2014-04-17	ACWV	ETF	64.78	64.82	64.57	64.75	43700.0
2014-04-17	ACWX	ETF	46.77	47.1	46.77	47.025	188581.0
2014-04-17	ADRE	ETF	37.29	37.739	37.25	37.679	102959.0
2014-04-17	AFK	ETF	31.994	32.22	31.91	31.97	5804.0
2014-04-17	AGG	ETF	108.53	108.53	108.1	108.19	1262900.0
2014-04-17	AGQ	ETF	63.11	63.17	62.44	62.88	165900.0
2014-04-17	AGZ	ETF	111.91	112.0299	111.7	111.74	10118.0
2014-04-17	AIA	ETF	47.39	47.5601	47.2201	47.49	5724.0
2014-04-17	AIQ	ETF	28.53	29.51	28.065	29.24	52986.0
2014-04-17	AIRR	ETF	19.19	19.37	19.14	19.33	77500.0
2014-04-17	AIVI	ETF	49.54	49.66	49.25	49.51	19100.0
2014-04-17	ALTL	ETF	33.51	33.523	33.51	33.523	1048.0
2014-04-17	AMJ	ETF	48.14	48.35	47.82	48.19	349594.0
2014-04-17	AMLP	ETF	90.0	90.5	89.75	90.35	637880.0
2014-04-17	ANGL	ETF	27.69	27.7	27.65	27.7	4400.0
2014-04-17	AOA	ETF	45.07	45.23	44.96	45.17	75500.0
2014-04-17	AOK	ETF	32.39	32.39	32.33	32.33	18395.0
2014-04-17	AOM	ETF	34.73	34.7699	34.684	34.75	33725.0
2014-04-17	AOR	ETF	38.98	39.06	38.922	39.03	65479.0
2014-04-17	ARGT	ETF	19.77	19.77	19.6	19.6	5300.0
2014-04-17	ASEA	ETF	16.46	16.55	16.35	16.52	58800.0
2014-04-17	ASHR	ETF	22.73	22.78	22.61	22.64	21400.0
2014-04-17	ATMP	ETF	28.73	28.89	28.67	28.82	116300.0
2014-04-17	AVIV	ETF	25.69	25.75	25.27	25.29	636275.0
2014-04-17	AWAY	ETF	35.46	36.59	35.11	36.15	2515731.0
2014-04-17	BAB	ETF	28.93	28.939	28.72	28.72	78899.0
2014-04-17	BAL	ETF	57.01	57.38	56.913	57.05	18813.0
2014-04-17	BALT	ETF	6.32	6.45	6.25	6.42	421532.0
2014-04-17	BBH	ETF	85.68	87.1	84.9	85.37	123900.0
2014-04-17	BCM	ETF	41.56	41.56	41.52	41.54	722.0
2014-04-17	BFOR	ETF	7.445	7.51	7.4275	7.5	214800.0
2014-04-17	BIB	ETF	34.67	36.3	34.4051	34.91	883952.0
2014-04-17	BICK	ETF	24.7	24.95	24.65	24.95	660.0
2014-04-17	BIL	ETF	91.56	91.56	91.54	91.56	136850.0
2014-04-17	BIS	ETF	782.4	798.0	755.204	782.0	15622.5
2014-04-17	BIV	ETF	83.81	83.81	83.42	83.45	1261200.0
2014-04-17	BIZD	ETF	19.96	20.02	19.96	19.98	7400.0
2014-04-17	BJK	ETF	50.85	51.17	50.79	50.91	8600.0
2014-04-17	BKF	ETF	36.33	37.02	36.24	36.92	34781.0
2014-04-17	BKLN	ETF	24.67	24.67	24.64	24.66	3016000.0
2014-04-17	BLV	ETF	88.25	88.29	87.31	87.6	85000.0

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

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