PREVIEW / etf_daily / 2015-12-31

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-31.parquet
  size:    50 KB
  rows:    1,248

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-12-31	SPY	ETF	205.13	205.89	203.87	203.87	114877900.0
2015-12-31	QQQ	ETF	112.87	113.08	111.84	111.86	29886849.0
2015-12-31	IWM	ETF	113.56	113.97	112.51	112.62	39517700.0
2015-12-31	DIA	ETF	175.09	175.65	173.97	173.99	5773400.0
2015-12-31	GLD	ETF	101.48	101.72	101.31	101.46	3823600.0
2015-12-31	TLT	ETF	120.57	120.86	120.25	120.58	7897700.0
2015-12-31	AADR	ETF	38.53	38.53	38.53	38.53	300.0
2015-12-31	AAXJ	ETF	53.53	53.75	53.39	53.41	464200.0
2015-12-31	ACTX	ETF	7.6701	7.6701	7.0801	7.6111	143.0
2015-12-31	ACWF	ETF	23.4101	23.4101	23.4101	23.4101	200.0
2015-12-31	ACWI	ETF	56.04	56.29	55.82	55.82	2744300.0
2015-12-31	ACWV	ETF	69.73	69.77	69.27	69.27	421700.0
2015-12-31	ACWX	ETF	39.83	39.96	39.6	39.61	4126941.0
2015-12-31	ADRE	ETF	29.24	29.3	28.98	29.07	20632.0
2015-12-31	AFK	ETF	17.82	17.98	17.6901	17.79	32791.0
2015-12-31	AFTY	ETF	14.33	14.33	14.21	14.23	26000.0
2015-12-31	AGG	ETF	107.87	108.03	107.82	108.01	3406100.0
2015-12-31	AGQ	ETF	27.06	27.36	27.04	27.08	124800.0
2015-12-31	AGZ	ETF	112.884	113.15	112.72	113.15	15732.0
2015-12-31	AGZD	ETF	23.93	24.05	23.915	24.05	7400.0
2015-12-31	AIA	ETF	42.31	42.5	42.2	42.27	50885.0
2015-12-31	AIQ	ETF	8.74	9.35	8.74	9.18	29179.0
2015-12-31	AIRR	ETF	16.66	16.66	16.51	16.51	22500.0
2015-12-31	AIVI	ETF	38.31	38.4	38.04	38.04	54600.0
2015-12-31	AMJ	ETF	27.56	29.18	27.5	28.97	8654237.0
2015-12-31	AMLP	ETF	57.5	60.5	56.85	60.25	4886060.0
2015-12-31	AMZA	ETF	105.7	113.5	102.1	111.5	1740.0
2015-12-31	ANGL	ETF	24.37	24.56	24.28	24.33	151600.0
2015-12-31	AOA	ETF	45.13	45.19	44.84	44.84	101300.0
2015-12-31	AOK	ETF	31.56	31.71	31.56	31.64	77503.0
2015-12-31	AOM	ETF	34.19	34.209	34.05	34.05	189196.0
2015-12-31	AOR	ETF	39.07	39.07	38.85	38.88	332875.0
2015-12-31	ARGT	ETF	18.13	18.18	17.97	18.08	39300.0
2015-12-31	ARKG	ETF	20.9	20.965	20.9	20.965	600.0
2015-12-31	ARKK	ETF	20.61	20.61	20.46	20.46	700.0
2015-12-31	ARKQ	ETF	19.25	19.286	19.18	19.18	900.0
2015-12-31	ARKW	ETF	23.26	23.31	23.17	23.17	2600.0
2015-12-31	ASEA	ETF	12.2	12.2	12.13	12.13	2200.0
2015-12-31	ASET	ETF	24.3237	24.36	24.3237	24.36	300.0
2015-12-31	ASHR	ETF	28.22	28.37	27.98	27.98	1005300.0
2015-12-31	ASHS	ETF	41.51	41.94	41.42	41.46	66300.0
2015-12-31	ASHX	ETF	25.4259	25.4319	25.42	25.4319	705.0
2015-12-31	ATMP	ETF	18.08	19.64	17.94	18.61	1426200.0
2015-12-31	BAB	ETF	29.02	29.035	28.89	28.99	43076.0
2015-12-31	BAL	ETF	42.06	42.1399	41.95	42.04	1730.0
2015-12-31	BBC	ETF	28.96	29.29	28.8701	29.05	25782.0
2015-12-31	BBH	ETF	127.03	127.94	126.79	126.95	35500.0
2015-12-31	BBP	ETF	30.861	31.07	30.82	30.82	2300.0
2015-12-31	BCM	ETF	23.57	23.7899	23.56	23.7899	3430.0
2015-12-31	BDCZ	ETF	20.33	20.33	20.27	20.27	403.0

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

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