PREVIEW / etf_daily / 2015-02-04

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-04.parquet
  size:    47 KB
  rows:    1,165

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
2015-02-04	SPY	ETF	203.92	205.38	203.51	204.06	134306700.0
2015-02-04	QQQ	ETF	102.54	103.55	102.31	102.87	34073211.0
2015-02-04	IWM	ETF	118.42	119.24	118.1	118.41	28597100.0
2015-02-04	DIA	ETF	175.8	177.57	175.78	176.53	5935900.0
2015-02-04	GLD	ETF	121.63	122.22	120.92	121.58	5386700.0
2015-02-04	TLT	ETF	133.49	134.99	133.12	134.8	11360400.0
2015-02-04	AADR	ETF	37.5	37.5	37.45	37.45	2800.0
2015-02-04	AAXJ	ETF	64.0	64.08	63.45	63.62	4902200.0
2015-02-04	ACWI	ETF	59.21	59.43	58.97	59.04	1254300.0
2015-02-04	ACWV	ETF	70.97	71.38	70.74	70.89	82900.0
2015-02-04	ACWX	ETF	43.97	44.1299	43.78	43.79	706199.0
2015-02-04	ADRE	ETF	36.38	36.7	36.38	36.47	4810.0
2015-02-04	AFK	ETF	26.65	26.65	26.2	26.41	101536.0
2015-02-04	AGG	ETF	111.64	111.95	111.5	111.94	1953000.0
2015-02-04	AGQ	ETF	46.26	47.55	45.91	45.91	216800.0
2015-02-04	AGZ	ETF	114.67	114.9851	114.53	114.6976	12492.0
2015-02-04	AGZD	ETF	24.485	24.505	24.405	24.45	5400.0
2015-02-04	AIA	ETF	49.51	49.51	49.2	49.26	44194.0
2015-02-04	AIQ	ETF	22.96	23.67	22.96	23.46	11611.0
2015-02-04	AIRR	ETF	17.64	17.64	17.32	17.35	24800.0
2015-02-04	AIVI	ETF	44.47	44.61	44.19	44.31	17800.0
2015-02-04	AMJ	ETF	45.49	45.8	44.95	45.38	1725727.0
2015-02-04	AMLP	ETF	86.45	87.0	85.95	86.6	1255200.0
2015-02-04	AMZA	ETF	220.5	220.5	217.5	220.0	140.0
2015-02-04	ANGL	ETF	26.92	26.98	26.63	26.91	4500.0
2015-02-04	AOA	ETF	46.6	46.78	46.51	46.52	28900.0
2015-02-04	AOK	ETF	32.6	32.8	32.6	32.77	38570.0
2015-02-04	AOM	ETF	35.21	35.36	35.2	35.26	62438.0
2015-02-04	AOR	ETF	40.13	40.39	40.13	40.2575	94122.0
2015-02-04	ARGT	ETF	19.01	19.14	18.87	18.91	36100.0
2015-02-04	ARKG	ETF	22.12	22.14	22.12	22.14	600.0
2015-02-04	ARKK	ETF	20.43	20.46	20.42	20.46	500.0
2015-02-04	ARKQ	ETF	19.07	19.07	19.07	19.07	100.0
2015-02-04	ARKW	ETF	20.965	20.98	20.965	20.98	300.0
2015-02-04	ASEA	ETF	15.78	15.92	15.78	15.85	6300.0
2015-02-04	ASHR	ETF	36.79	36.79	36.11	36.33	2523900.0
2015-02-04	ASHS	ETF	38.27	38.77	38.18	38.48	10600.0
2015-02-04	ATMP	ETF	29.97	30.24	29.73	30.02	17100.0
2015-02-04	AVIV	ETF	38.06	38.57	37.87	38.4	588896.0
2015-02-04	AWAY	ETF	25.31	26.15	25.3	25.75	1946371.0
2015-02-04	BAB	ETF	30.9	31.04	30.82	31.01	102319.0
2015-02-04	BAL	ETF	41.92	42.09	41.68	41.78	15320.0
2015-02-04	BALT	ETF	1.7	1.73	1.62	1.68	968094.0
2015-02-04	BBC	ETF	27.16	27.5199	26.8	27.3966	8224.0
2015-02-04	BBH	ETF	118.88	119.78	115.91	118.97	312300.0
2015-02-04	BBP	ETF	27.0	27.46	26.82	27.27	3300.0
2015-02-04	BCHP	ETF	18.7101	18.7101	18.7101	18.7101	125.0
2015-02-04	BCM	ETF	31.67	31.75	31.36	31.41	64232.0
2015-02-04	BFOR	ETF	7.83	7.895	7.815	7.8425	217200.0
2015-02-04	BIB	ETF	65.505	67.04	62.855	66.085	1251464.0

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

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