PREVIEW / etf_daily / 2014-04-16

all etf daily files

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

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-16	SPY	ETF	185.47	186.14	184.65	186.13	105197000.0
2014-04-16	QQQ	ETF	85.83	86.18	85.091	86.18	46970899.0
2014-04-16	IWM	ETF	111.93	112.44	111.23	112.36	49353800.0
2014-04-16	DIA	ETF	163.43	164.03	162.93	164.02	5864200.0
2014-04-16	GLD	ETF	125.37	125.57	125.03	125.54	4071300.0
2014-04-16	TLT	ETF	110.43	111.27	110.38	111.27	5523000.0
2014-04-16	AAXJ	ETF	60.56	60.79	60.35	60.74	348300.0
2014-04-16	ACWI	ETF	57.71	58.12	57.71	58.12	1604600.0
2014-04-16	ACWV	ETF	64.42	64.63	64.24	64.49	12500.0
2014-04-16	ACWX	ETF	46.61	46.79	46.48	46.77	84105.0
2014-04-16	ADRE	ETF	37.13	37.3128	37.13	37.2301	3927.0
2014-04-16	AFK	ETF	31.7	32.13	31.7	31.94	7448.0
2014-04-16	AGG	ETF	108.41	108.54	108.34	108.54	2245600.0
2014-04-16	AGQ	ETF	63.0	63.19	62.45	63.19	118700.0
2014-04-16	AGZ	ETF	112.29	112.29	111.895	111.895	53481.0
2014-04-16	AIA	ETF	47.19	47.5765	47.19	47.46	20126.0
2014-04-16	AIQ	ETF	29.52	29.52	27.91	28.71	63904.0
2014-04-16	AIRR	ETF	19.16	19.16	18.97	19.13	15200.0
2014-04-16	AIVI	ETF	49.09	49.28	48.9	49.24	25200.0
2014-04-16	AMJ	ETF	47.73	48.159	47.55	48.03	381377.0
2014-04-16	AMLP	ETF	89.8	90.2	89.5	90.0	597220.0
2014-04-16	ANGL	ETF	27.7	27.7	27.54	27.66	2300.0
2014-04-16	AOA	ETF	44.92	45.04	44.78	45.01	32800.0
2014-04-16	AOK	ETF	32.31	32.35	32.254	32.35	21824.0
2014-04-16	AOM	ETF	34.58	34.72	34.58	34.72	39446.0
2014-04-16	AOR	ETF	38.89	38.97	38.78	38.97	44683.0
2014-04-16	ARGT	ETF	19.7	19.74	19.47	19.74	2200.0
2014-04-16	ASEA	ETF	16.34	16.46	16.32	16.43	30900.0
2014-04-16	ASHR	ETF	22.66	22.8	22.66	22.79	72400.0
2014-04-16	ATMP	ETF	28.34	28.98	28.34	28.66	18500.0
2014-04-16	AVIV	ETF	25.71	25.89	25.48	25.64	319405.0
2014-04-16	AWAY	ETF	34.0	35.25	33.89	35.24	3214315.0
2014-04-16	BAB	ETF	28.89	28.9658	28.81	28.95	98518.0
2014-04-16	BAL	ETF	56.68	57.22	56.58	57.17	10296.0
2014-04-16	BALT	ETF	6.16	6.3	6.16	6.28	423079.0
2014-04-16	BBH	ETF	85.27	85.88	83.95	85.62	170500.0
2014-04-16	BCM	ETF	41.68	41.68	41.4704	41.4704	889.0
2014-04-16	BFOR	ETF	7.4125	7.4525	7.395	7.4525	128400.0
2014-04-16	BIB	ETF	34.425	35.25	33.51	35.08	1362906.0
2014-04-16	BICK	ETF	24.6	24.74	24.585	24.74	13131.0
2014-04-16	BIL	ETF	91.54	91.56	91.54	91.54	88350.0
2014-04-16	BIS	ETF	796.4	822.8	776.0	782.0	28352.0
2014-04-16	BIV	ETF	83.83	83.88	83.74	83.8	193600.0
2014-04-16	BIZD	ETF	19.99	20.01	19.88	20.0	23300.0
2014-04-16	BJK	ETF	50.37	50.61	50.18	50.6	15100.0
2014-04-16	BKF	ETF	36.25	36.4	36.0901	36.37	37713.0
2014-04-16	BKLN	ETF	24.67	24.7	24.65	24.66	3475000.0
2014-04-16	BLNG	ETF	36.24	36.24	36.18	36.18	496.0
2014-04-16	BLV	ETF	87.66	88.22	87.61	88.2	57900.0
2014-04-16	BMVP	ETF	23.0	23.43	23.0	23.43	5462.0

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

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