PREVIEW / etf_daily / 2014-03-03

all etf daily files

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

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-03	SPY	ETF	184.65	185.45	183.75	184.98	167748500.0
2014-03-03	QQQ	ETF	89.48	89.91	88.87	89.67	38946845.0
2014-03-03	IWM	ETF	116.52	117.26	115.58	116.89	50892800.0
2014-03-03	DIA	ETF	161.59	162.19	160.49	161.49	9144400.0
2014-03-03	GLD	ETF	130.0	130.59	129.81	130.29	11741100.0
2014-03-03	TLT	ETF	108.88	109.18	108.64	109.03	11089400.0
2014-03-03	AADR	ETF	38.14	38.14	37.75	37.75	700.0
2014-03-03	AAXJ	ETF	57.62	57.69	57.24	57.63	871000.0
2014-03-03	ACWI	ETF	57.16	57.27	56.76	57.02	1470900.0
2014-03-03	ACWV	ETF	62.82	63.29	62.79	63.03	21300.0
2014-03-03	ACWX	ETF	45.64	45.7	45.3201	45.46	268884.0
2014-03-03	ADRE	ETF	34.64	34.69	34.34	34.66	22009.0
2014-03-03	AFK	ETF	31.36	31.36	30.7101	30.99	10250.0
2014-03-03	AGG	ETF	108.21	108.38	108.15	108.35	2533900.0
2014-03-03	AGQ	ETF	75.94	77.14	75.27	75.57	739600.0
2014-03-03	AGZ	ETF	111.9999	111.9999	111.79	111.8209	7670.0
2014-03-03	AGZD	ETF	24.98	24.98	24.98	24.98	400.0
2014-03-03	AIA	ETF	44.83	45.09	44.66	44.9	28048.0
2014-03-03	AIQ	ETF	30.05	30.35	28.76	30.0	10489.0
2014-03-03	AIVI	ETF	48.34	48.45	48.04	48.14	24000.0
2014-03-03	ALTL	ETF	33.44	33.44	33.44	33.44	274.0
2014-03-03	AMJ	ETF	45.66	46.1255	45.65	45.98	402894.0
2014-03-03	AMLP	ETF	87.05	87.4	86.75	87.15	479160.0
2014-03-03	ANGL	ETF	27.7	27.7	27.45	27.59	2700.0
2014-03-03	AOA	ETF	44.73	44.79	44.48	44.67	30400.0
2014-03-03	AOK	ETF	32.29	32.3	32.2301	32.279	12795.0
2014-03-03	AOM	ETF	34.61	34.61	34.5	34.56	26328.0
2014-03-03	AOR	ETF	38.57	38.7699	38.57	38.72	16012.0
2014-03-03	ARGT	ETF	18.51	19.31	18.5	18.95	6600.0
2014-03-03	ASEA	ETF	15.49	15.5	15.43	15.46	17700.0
2014-03-03	ASHR	ETF	22.43	22.48	22.33	22.46	173300.0
2014-03-03	ATMP	ETF	27.05	27.26	27.05	27.22	16000.0
2014-03-03	AVIV	ETF	25.77	25.77	25.195	25.48	99554.0
2014-03-03	AWAY	ETF	45.32	46.33	44.74	45.86	1439956.0
2014-03-03	BAB	ETF	28.64	28.719	28.62	28.67	96976.0
2014-03-03	BAL	ETF	54.38	55.2486	54.22	55.15	18410.0
2014-03-03	BALT	ETF	6.77	7.04	6.61	6.9	986300.0
2014-03-03	BBH	ETF	99.93	102.31	99.93	101.58	171200.0
2014-03-03	BCM	ETF	41.37	41.55	41.32	41.43	166538.0
2014-03-03	BFOR	ETF	7.605	7.605	7.4775	7.54	423200.0
2014-03-03	BIB	ETF	48.325	50.6099	48.265	50.295	1187212.0
2014-03-03	BICK	ETF	23.1	23.25	23.0818	23.25	634.0
2014-03-03	BIL	ETF	91.54	91.56	91.54	91.56	858450.0
2014-03-03	BIS	ETF	608.0	609.6	580.8	587.2	11688.0
2014-03-03	BIV	ETF	83.9	83.94	83.71	83.92	144900.0
2014-03-03	BIZD	ETF	21.28	21.28	21.07	21.18	7400.0
2014-03-03	BJK	ETF	54.38	54.5	52.85	54.48	18100.0
2014-03-03	BKF	ETF	34.03	34.23	33.82	34.23	250417.0
2014-03-03	BKLN	ETF	24.85	24.87	24.85	24.87	4076000.0
2014-03-03	BLV	ETF	86.12	86.24	85.92	86.21	439600.0

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

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