PREVIEW / etf_daily / 2014-03-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-14.parquet
  size:    43 KB
  rows:    1,066

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-14	SPY	ETF	184.85	185.8	184.44	184.66	153919600.0
2014-03-14	QQQ	ETF	88.99	89.38	88.63	88.67	38738769.0
2014-03-14	IWM	ETF	116.63	117.87	116.62	117.54	46888100.0
2014-03-14	DIA	ETF	160.73	161.6	160.38	160.65	8603100.0
2014-03-14	GLD	ETF	133.68	133.69	132.35	133.1	11939600.0
2014-03-14	TLT	ETF	108.97	108.98	108.32	108.52	9232800.0
2014-03-14	AADR	ETF	37.46	37.51	37.2	37.51	12900.0
2014-03-14	AAXJ	ETF	56.73	57.16	56.66	56.73	490100.0
2014-03-14	ACWI	ETF	56.45	56.87	56.45	56.51	3722900.0
2014-03-14	ACWV	ETF	62.9	63.31	62.9	63.09	18100.0
2014-03-14	ACWX	ETF	44.81	45.095	44.77	44.89	169665.0
2014-03-14	ADRE	ETF	33.94	34.13	33.91	33.91	6630.0
2014-03-14	AFK	ETF	30.8	31.19	30.8	31.01	75497.0
2014-03-14	AGG	ETF	108.13	108.17	107.93	107.93	741800.0
2014-03-14	AGQ	ETF	77.53	77.6	74.5	75.14	711000.0
2014-03-14	AGZ	ETF	111.2956	111.95	110.606	111.8399	6794.0
2014-03-14	AIA	ETF	43.93	44.15	43.92	43.936	4717.0
2014-03-14	AIQ	ETF	29.64	29.9	28.97	29.71	17587.0
2014-03-14	AIRR	ETF	19.6	19.61	19.525	19.525	1093600.0
2014-03-14	AIVI	ETF	47.64	48.17	47.64	48.03	18500.0
2014-03-14	ALTL	ETF	33.35	33.488	33.35	33.366	2061.0
2014-03-14	AMJ	ETF	45.51	46.0199	45.27	45.85	270899.0
2014-03-14	AMLP	ETF	86.8	87.55	86.8	87.1	541520.0
2014-03-14	ANGL	ETF	27.32	27.55	27.32	27.55	6500.0
2014-03-14	AOA	ETF	44.4	44.64	44.4	44.48	29300.0
2014-03-14	AOK	ETF	32.15	32.18	32.11	32.14	19757.0
2014-03-14	AOM	ETF	34.43	34.51	34.4	34.44	59386.0
2014-03-14	AOR	ETF	38.47	38.68	38.47	38.57	31736.0
2014-03-14	ARGT	ETF	18.77	18.95	18.77	18.78	4400.0
2014-03-14	ASEA	ETF	15.6	15.81	15.6	15.71	43900.0
2014-03-14	ASHR	ETF	21.72	21.85	21.72	21.8	124600.0
2014-03-14	ATMP	ETF	27.27	27.3	27.23	27.27	10600.0
2014-03-14	AVIV	ETF	24.96	25.18	24.81	24.97	96741.0
2014-03-14	AWAY	ETF	43.25	43.656	42.31	42.89	1080266.0
2014-03-14	BAB	ETF	28.67	28.69	28.58	28.65	106935.0
2014-03-14	BAL	ETF	56.79	57.8087	56.79	57.7045	7353.0
2014-03-14	BALT	ETF	6.78	6.87	6.63	6.64	499859.0
2014-03-14	BBH	ETF	97.36	98.94	97.05	97.54	252600.0
2014-03-14	BCM	ETF	41.2	41.54	41.02	41.03	5898.0
2014-03-14	BFOR	ETF	7.525	7.5875	7.525	7.5625	92800.0
2014-03-14	BIB	ETF	46.075	47.495	45.5555	46.415	467232.0
2014-03-14	BICK	ETF	22.87	22.9965	22.86	22.86	1779.0
2014-03-14	BIL	ETF	91.54	91.56	91.54	91.54	1176050.0
2014-03-14	BIS	ETF	636.0	640.0	614.0	632.0	9070.0
2014-03-14	BIV	ETF	83.82	83.83	83.63	83.7	337500.0
2014-03-14	BIZD	ETF	20.85	20.85	20.61	20.64	9000.0
2014-03-14	BJK	ETF	52.81	53.07	52.59	52.99	16900.0
2014-03-14	BKF	ETF	32.94	33.29	32.94	33.14	48754.0
2014-03-14	BKLN	ETF	24.79	24.8	24.75	24.77	3199500.0
2014-03-14	BLV	ETF	86.05	86.12	85.69	85.75	263400.0

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

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