PREVIEW / etf_daily / 2016-08-17

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-17.parquet
  size:    51 KB
  rows:    1,291

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-08-17	SPY	ETF	218.0	218.53	217.02	218.37	75134300.0
2016-08-17	QQQ	ETF	117.08	117.3	116.43	117.26	15980334.0
2016-08-17	IWM	ETF	122.44	122.5	121.33	122.04	20632600.0
2016-08-17	DIA	ETF	185.77	186.23	185.09	186.1	2952000.0
2016-08-17	GLD	ETF	128.17	128.99	127.46	128.5	12034800.0
2016-08-17	TLT	ETF	138.63	139.44	138.5	139.22	5002000.0
2016-08-17	AAXJ	ETF	59.24	59.46	58.86	59.38	1700700.0
2016-08-17	ACTX	ETF	3.186	3.186	2.891	2.891	1019.0
2016-08-17	ACWI	ETF	59.0	59.25	58.79	59.18	4967000.0
2016-08-17	ACWV	ETF	77.34	77.52	76.91	77.43	243100.0
2016-08-17	ACWX	ETF	41.32	41.54	41.16	41.46	578987.0
2016-08-17	ADRE	ETF	34.42	34.55	34.315	34.55	6384.0
2016-08-17	AFK	ETF	20.9301	22.01	20.9301	21.5	14971.0
2016-08-17	AFTY	ETF	13.705	13.705	13.64	13.678	3200.0
2016-08-17	AGG	ETF	112.45	112.66	112.36	112.57	5210700.0
2016-08-17	AGGY	ETF	52.1	52.17	52.064	52.165	15100.0
2016-08-17	AGQ	ETF	51.5	51.88	49.5	51.18	295700.0
2016-08-17	AGZ	ETF	115.6055	115.73	115.6	115.6	8199.0
2016-08-17	AIA	ETF	48.14	48.3202	47.85	48.2699	56890.0
2016-08-17	AIQ	ETF	6.17	6.239	6.09	6.13	9560.0
2016-08-17	AIRR	ETF	19.53	19.57	19.46	19.499	3700.0
2016-08-17	AIVI	ETF	39.07	39.27	38.92	39.27	33400.0
2016-08-17	ALTY	ETF	15.7	15.7	15.538	15.6	1500.0
2016-08-17	AMJ	ETF	32.13	32.32	31.92	32.07	1499209.0
2016-08-17	AMLP	ETF	64.1	64.1	63.25	63.4	1498100.0
2016-08-17	AMZA	ETF	117.0	117.18	115.5	115.5	7580.0
2016-08-17	ANGL	ETF	28.61	28.61	28.53	28.6	151000.0
2016-08-17	AOA	ETF	47.39	47.5	47.23	47.42	17500.0
2016-08-17	AOK	ETF	33.34	33.43	33.2001	33.39	52771.0
2016-08-17	AOM	ETF	36.02	36.0599	35.897	36.01	71015.0
2016-08-17	AOR	ETF	40.96	41.12	40.8601	41.07	43785.0
2016-08-17	ARGT	ETF	23.0	23.24	22.84	23.03	8600.0
2016-08-17	ARKG	ETF	18.99	18.99	18.99	18.99	300.0
2016-08-17	ARKK	ETF	21.164	21.164	21.164	21.164	100.0
2016-08-17	ARKQ	ETF	21.38	21.38	21.335	21.335	300.0
2016-08-17	ARKW	ETF	24.61	24.61	24.61	24.61	400.0
2016-08-17	ASEA	ETF	14.18	14.18	14.17	14.17	1200.0
2016-08-17	ASET	ETF	26.99	27.0	26.99	27.0	200.0
2016-08-17	ASHR	ETF	25.74	25.78	25.58	25.65	1600300.0
2016-08-17	ASHS	ETF	35.91	35.91	35.61	35.75	15300.0
2016-08-17	ASHX	ETF	23.28	23.28	23.24	23.25	1335.0
2016-08-17	ATMP	ETF	23.15	23.25	23.08	23.24	36700.0
2016-08-17	BAB	ETF	31.57	31.615	31.5001	31.6	240290.0
2016-08-17	BAL	ETF	45.7	46.15	45.411	45.7499	46609.0
2016-08-17	BBC	ETF	20.68	20.68	20.3974	20.45	6783.0
2016-08-17	BBH	ETF	115.29	115.63	114.61	115.56	43700.0
2016-08-17	BBP	ETF	30.668	30.76	30.52	30.76	4600.0
2016-08-17	BCM	ETF	26.8	26.88	26.7235	26.87	6030.0
2016-08-17	BFOR	ETF	7.9975	8.01	7.9725	8.0025	39200.0
2016-08-17	BIB	ETF	49.41	49.69	48.6	49.33	467777.0

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

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