PREVIEW / etf_daily / 2016-01-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-13.parquet
  size:    50 KB
  rows:    1,247

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
2016-01-13	SPY	ETF	194.45	194.86	188.38	188.83	221168900.0
2016-01-13	QQQ	ETF	106.0	106.23	101.74	101.9	69870673.0
2016-01-13	IWM	ETF	103.91	104.42	99.65	100.38	70591600.0
2016-01-13	DIA	ETF	165.54	165.84	161.07	161.35	16369400.0
2016-01-13	GLD	ETF	103.89	104.82	103.78	104.72	7324200.0
2016-01-13	TLT	ETF	123.53	125.5	123.27	124.99	15577600.0
2016-01-13	AADR	ETF	35.12	35.12	35.12	35.12	200.0
2016-01-13	AAXJ	ETF	49.63	49.76	48.57	48.69	1176300.0
2016-01-13	ACTX	ETF	7.6701	7.6701	7.0801	7.0801	183.0
2016-01-13	ACWF	ETF	21.49	21.49	21.49	21.49	120.0
2016-01-13	ACWI	ETF	52.84	52.99	51.38	51.51	4367600.0
2016-01-13	ACWV	ETF	67.18	67.26	66.04	66.13	238800.0
2016-01-13	ACWX	ETF	37.41	37.41	36.41	36.5	1368147.0
2016-01-13	ADRE	ETF	26.62	26.87	26.101	26.101	9999.0
2016-01-13	AFK	ETF	16.11	16.11	15.62	15.67	54542.0
2016-01-13	AFTY	ETF	12.45	12.47	12.31	12.31	2700.0
2016-01-13	AGG	ETF	108.6	108.93	108.55	108.84	3011500.0
2016-01-13	AGQ	ETF	27.61	28.5	27.51	28.39	209800.0
2016-01-13	AGZ	ETF	113.62	113.7032	113.41	113.63	21451.0
2016-01-13	AGZD	ETF	23.91	23.91	23.845	23.845	2800.0
2016-01-13	AIA	ETF	39.18	39.18	38.33	38.4501	13158.0
2016-01-13	AIQ	ETF	7.43	7.43	6.86	6.92	50381.0
2016-01-13	AIRR	ETF	15.162	15.21	14.62	14.65	21600.0
2016-01-13	AIVI	ETF	36.3	36.3	35.47	35.49	170700.0
2016-01-13	ALTY	ETF	13.11	13.11	13.11	13.11	200.0
2016-01-13	AMJ	ETF	25.42	25.96	23.44	23.85	8381344.0
2016-01-13	AMLP	ETF	52.5	53.25	47.65	48.55	5671320.0
2016-01-13	AMZA	ETF	81.5	86.6	75.6	78.0	8870.0
2016-01-13	ANGL	ETF	24.05	24.14	23.89	24.13	157100.0
2016-01-13	AOA	ETF	43.04	43.04	42.12	42.18	68700.0
2016-01-13	AOK	ETF	31.26	31.27	31.0	31.0199	79442.0
2016-01-13	AOM	ETF	33.54	33.54	33.12	33.12	185985.0
2016-01-13	AOR	ETF	37.74	37.74	37.1198	37.17	124864.0
2016-01-13	ARGT	ETF	17.0	17.0	16.45	16.65	177900.0
2016-01-13	ARKG	ETF	18.43	18.6	17.53	17.53	2400.0
2016-01-13	ARKK	ETF	18.43	18.63	17.803	17.87	2100.0
2016-01-13	ARKQ	ETF	17.29	17.37	16.78	16.82	1500.0
2016-01-13	ARKW	ETF	21.14	21.14	20.9	20.9	500.0
2016-01-13	ASEA	ETF	11.39	11.39	11.37	11.37	4900.0
2016-01-13	ASET	ETF	23.35	23.35	23.04	23.04	1662.0
2016-01-13	ASHR	ETF	23.53	23.53	22.95	22.95	2296400.0
2016-01-13	ASHS	ETF	31.83	31.83	30.94	30.96	119300.0
2016-01-13	ASHX	ETF	21.3275	21.3275	20.91	20.9723	12425.0
2016-01-13	ATMP	ETF	16.4	16.4	15.14	15.38	79900.0
2016-01-13	BAB	ETF	29.57	29.737	29.52	29.72	219766.0
2016-01-13	BAL	ETF	41.3442	41.4005	41.1	41.1115	5748.0
2016-01-13	BBC	ETF	22.99	22.99	20.708	20.78	9970.0
2016-01-13	BBH	ETF	114.12	114.6	107.88	108.09	99800.0
2016-01-13	BBP	ETF	26.51	26.51	24.702	24.702	7300.0
2016-01-13	BCM	ETF	22.43	22.43	22.186	22.21	1185.0

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

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