PREVIEW / etf_daily / 2016-08-16

all etf daily files

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

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-16	SPY	ETF	218.6	218.68	217.96	217.96	53213600.0
2016-08-16	QQQ	ETF	117.47	117.49	117.03	117.05	14161446.0
2016-08-16	IWM	ETF	123.08	123.12	122.26	122.4	20244300.0
2016-08-16	DIA	ETF	186.17	186.37	185.72	185.76	1614100.0
2016-08-16	GLD	ETF	128.12	129.04	128.0	128.47	8678100.0
2016-08-16	TLT	ETF	138.98	139.15	138.23	138.39	6182700.0
2016-08-16	AADR	ETF	40.88	41.35	40.88	41.34	1900.0
2016-08-16	AAXJ	ETF	59.84	59.84	59.53	59.7	3277300.0
2016-08-16	ACTX	ETF	2.95	3.54	2.95	3.54	733.0
2016-08-16	ACWI	ETF	59.24	59.3	59.12	59.12	572100.0
2016-08-16	ACWV	ETF	77.9	77.9	77.43	77.47	1884600.0
2016-08-16	ACWX	ETF	41.52	41.59	41.46	41.49	296288.0
2016-08-16	ADRE	ETF	34.73	34.736	34.6155	34.71	7254.0
2016-08-16	AFK	ETF	21.18	21.58	20.932	21.3301	17561.0
2016-08-16	AFTY	ETF	13.82	13.82	13.76	13.76	300.0
2016-08-16	AGG	ETF	112.49	112.52	112.36	112.36	6250200.0
2016-08-16	AGGY	ETF	52.1	52.12	52.04	52.08	15000.0
2016-08-16	AGQ	ETF	51.77	52.66	51.5	51.92	174400.0
2016-08-16	AGZ	ETF	115.63	115.712	115.52	115.54	14316.0
2016-08-16	AGZD	ETF	23.835	23.92	23.835	23.84	4800.0
2016-08-16	AIA	ETF	48.55	48.6	48.37	48.43	134799.0
2016-08-16	AIQ	ETF	6.24	6.24	6.18	6.19	2454.0
2016-08-16	AIRR	ETF	19.64	19.64	19.53	19.54	9500.0
2016-08-16	AIVI	ETF	39.35	39.36	39.24	39.27	17400.0
2016-08-16	ALTY	ETF	15.66	15.66	15.593	15.65	2100.0
2016-08-16	AMJ	ETF	32.02	32.255	31.68	32.13	2366818.0
2016-08-16	AMLP	ETF	63.6	63.7	63.4	63.65	1274940.0
2016-08-16	AMZA	ETF	116.5	117.5	115.9	116.49	18790.0
2016-08-16	ANGL	ETF	28.56	28.57	28.5	28.55	94000.0
2016-08-16	AOA	ETF	47.51	47.55	47.43	47.46	23100.0
2016-08-16	AOK	ETF	33.52	33.52	33.33	33.37	60521.0
2016-08-16	AOM	ETF	36.12	36.12	35.94	36.05	129925.0
2016-08-16	AOR	ETF	41.16	41.16	41.03	41.05	44107.0
2016-08-16	ARGT	ETF	23.16	23.32	23.13	23.16	21500.0
2016-08-16	ARKG	ETF	19.09	19.09	19.09	19.09	200.0
2016-08-16	ARKK	ETF	21.42	21.42	21.3	21.33	2400.0
2016-08-16	ARKQ	ETF	21.4	21.43	21.4	21.43	2300.0
2016-08-16	ARKW	ETF	25.01	25.01	24.77	24.838	1100.0
2016-08-16	ASEA	ETF	14.26	14.29	14.26	14.29	900.0
2016-08-16	ASHR	ETF	25.95	26.01	25.85	25.91	2366600.0
2016-08-16	ASHS	ETF	35.99	36.01	35.82	35.92	23100.0
2016-08-16	ASHX	ETF	23.06	23.54	23.06	23.48	36965.0
2016-08-16	ATMP	ETF	23.19	23.45	23.14	23.25	20800.0
2016-08-16	BAB	ETF	31.64	31.64	31.5305	31.56	169184.0
2016-08-16	BAL	ETF	45.13	45.6999	44.3	45.63	33290.0
2016-08-16	BBC	ETF	20.7	20.99	20.68	20.68	21333.0
2016-08-16	BBH	ETF	116.24	116.67	115.09	115.18	38900.0
2016-08-16	BBP	ETF	31.18	31.18	30.73	30.73	3900.0
2016-08-16	BCM	ETF	26.58	26.76	26.56	26.76	13734.0
2016-08-16	BFOR	ETF	8.0625	8.07	8.03	8.04	18400.0

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

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