PREVIEW / etf_daily / 2014-03-12

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-12.parquet
  size:    44 KB
  rows:    1,075

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-03-12	SPY	ETF	186.32	187.35	185.9	187.28	104824400.0
2014-03-12	QQQ	ETF	89.82	90.61	89.48	90.56	27997215.0
2014-03-12	IWM	ETF	117.39	118.44	116.92	118.42	37159100.0
2014-03-12	DIA	ETF	162.66	163.57	162.47	163.23	5250800.0
2014-03-12	GLD	ETF	131.56	132.12	131.39	131.76	11094200.0
2014-03-12	TLT	ETF	106.92	107.26	106.78	107.06	6430500.0
2014-03-12	AADR	ETF	37.76	37.99	37.65	37.99	3200.0
2014-03-12	AAXJ	ETF	57.12	57.56	56.99	57.48	1280300.0
2014-03-12	ACWI	ETF	57.26	57.51	57.08	57.5	516000.0
2014-03-12	ACWV	ETF	63.42	63.67	63.3	63.64	6900.0
2014-03-12	ACWX	ETF	45.5	45.71	45.3301	45.71	39135.0
2014-03-12	ADRE	ETF	34.36	34.64	34.28	34.63	16248.0
2014-03-12	AFK	ETF	31.47	31.5099	31.0207	31.5099	11372.0
2014-03-12	AGG	ETF	107.67	107.72	107.6	107.7	943300.0
2014-03-12	AGQ	ETF	72.85	75.35	72.36	74.43	580100.0
2014-03-12	AGZ	ETF	111.49	111.6599	110.61	111.5232	6657.0
2014-03-12	AIA	ETF	44.19	44.55	44.19	44.55	6588.0
2014-03-12	AIQ	ETF	29.55	30.77	28.55	29.89	30298.0
2014-03-12	AIRR	ETF	19.72	19.83	19.72	19.83	1200.0
2014-03-12	AIVI	ETF	48.55	48.89	48.48	48.85	11500.0
2014-03-12	ALTL	ETF	33.64	33.64	33.64	33.64	35805.0
2014-03-12	AMJ	ETF	45.52	45.85	45.51	45.79	432298.0
2014-03-12	AMLP	ETF	87.1	87.4	86.75	87.1	477200.0
2014-03-12	ANGL	ETF	27.55	27.55	27.55	27.55	500.0
2014-03-12	AOA	ETF	44.8	44.97	44.69	44.97	12100.0
2014-03-12	AOK	ETF	32.16	32.27	32.16	32.26	21370.0
2014-03-12	AOM	ETF	34.56	34.64	34.516	34.62	32793.0
2014-03-12	AOR	ETF	38.69	38.92	38.69	38.92	37192.0
2014-03-12	ARGT	ETF	18.95	18.95	18.88	18.88	1900.0
2014-03-12	ASEA	ETF	15.35	15.48	15.35	15.47	17100.0
2014-03-12	ASHR	ETF	21.47	21.7	21.45	21.7	274800.0
2014-03-12	ATMP	ETF	27.07	27.21	27.05	27.2	83100.0
2014-03-12	AVIV	ETF	25.08	25.31	24.98	25.13	89494.0
2014-03-12	AWAY	ETF	44.49	45.42	42.95	44.83	1756489.0
2014-03-12	BAB	ETF	28.55	28.61	28.54	28.6	64846.0
2014-03-12	BAL	ETF	56.7601	58.09	56.7601	57.6399	17293.0
2014-03-12	BALT	ETF	6.94	7.02	6.7799	6.98	821726.0
2014-03-12	BBH	ETF	99.42	101.0	99.22	100.97	214000.0
2014-03-12	BCM	ETF	40.85	41.02	40.81	41.0	38671.0
2014-03-12	BFOR	ETF	7.6175	7.6425	7.5375	7.6425	130800.0
2014-03-12	BIB	ETF	47.505	49.2891	47.2555	49.1125	316938.0
2014-03-12	BICK	ETF	23.17	23.182	23.16	23.17	2048.0
2014-03-12	BIL	ETF	91.54	91.56	91.54	91.54	115050.0
2014-03-12	BIS	ETF	618.4	621.16	592.4	593.6	5945.0
2014-03-12	BIV	ETF	83.35	83.38	83.24	83.33	202000.0
2014-03-12	BIZD	ETF	20.91	20.96	20.7	20.96	52600.0
2014-03-12	BJK	ETF	54.35	54.69	53.81	54.57	10100.0
2014-03-12	BKF	ETF	33.61	33.785	33.51	33.78	39732.0
2014-03-12	BKLN	ETF	24.88	24.88	24.86	24.87	1784900.0
2014-03-12	BLV	ETF	84.99	85.1	84.81	85.05	36400.0

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

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