PREVIEW / etf_daily / 2016-11-09

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-09.parquet
  size:    54 KB
  rows:    1,345

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-11-09	SPY	ETF	212.37	217.1	212.34	216.38	258429000.0
2016-11-09	QQQ	ETF	115.71	117.84	115.6	117.65	70234393.0
2016-11-09	IWM	ETF	118.08	122.83	118.05	122.54	77416800.0
2016-11-09	DIA	ETF	181.93	186.55	181.75	185.96	8363900.0
2016-11-09	GLD	ETF	124.3	124.35	121.11	121.56	18236500.0
2016-11-09	TLT	ETF	127.22	127.37	124.22	124.57	31233500.0
2016-11-09	AADR	ETF	41.58	41.58	41.44	41.44	900.0
2016-11-09	AAXJ	ETF	57.81	58.4	57.64	57.72	1971400.0
2016-11-09	ACSI	ETF	25.12	25.43	25.12	25.43	18654.0
2016-11-09	ACTX	ETF	15.9301	16.5201	12.9801	14.1601	2978.0
2016-11-09	ACWF	ETF	23.704	23.704	23.704	23.704	312.0
2016-11-09	ACWI	ETF	57.57	58.57	57.5	58.4	2258000.0
2016-11-09	ACWV	ETF	73.65	74.15	73.35	73.92	178300.0
2016-11-09	ACWX	ETF	40.16	40.67	40.16	40.47	736712.0
2016-11-09	ADRE	ETF	34.32	34.5	34.265	34.36	7142.0
2016-11-09	AFK	ETF	19.89	20.152	19.88	20.152	6323.0
2016-11-09	AFTY	ETF	13.33	13.649	13.33	13.628	12500.0
2016-11-09	AGG	ETF	110.53	110.57	109.78	109.9	3657200.0
2016-11-09	AGGY	ETF	51.06	51.06	50.67	50.67	25100.0
2016-11-09	AGQ	ETF	45.92	45.94	43.45	43.74	371400.0
2016-11-09	AGZ	ETF	114.74	114.79	114.11	114.12	21867.0
2016-11-09	AGZD	ETF	23.91	23.915	23.85	23.86	19000.0
2016-11-09	AIA	ETF	48.33	48.57	47.8801	48.08	69917.0
2016-11-09	AIQ	ETF	7.6	7.6614	7.3	7.35	32762.0
2016-11-09	AIRR	ETF	19.57	20.81	19.57	20.74	220900.0
2016-11-09	AIVI	ETF	37.05	37.54	37.04	37.41	29100.0
2016-11-09	ALTY	ETF	14.33	14.779	14.33	14.664	4200.0
2016-11-09	AMJ	ETF	29.45	30.3	28.55	30.11	3096367.0
2016-11-09	AMLP	ETF	59.35	60.75	59.05	60.4	2475280.0
2016-11-09	AMZA	ETF	103.0	108.6	103.0	107.4	40560.0
2016-11-09	ANGL	ETF	28.45	28.72	28.45	28.66	117600.0
2016-11-09	AOA	ETF	46.3	46.82	46.14	46.73	72100.0
2016-11-09	AOK	ETF	32.6	32.91	32.59	32.66	250803.0
2016-11-09	AOM	ETF	35.1	35.3879	35.0797	35.3	100480.0
2016-11-09	AOR	ETF	40.2	40.38	40.07	40.3	154635.0
2016-11-09	ARGT	ETF	23.2	23.89	22.9	23.69	67200.0
2016-11-09	ARKG	ETF	17.57	18.212	17.57	18.204	8700.0
2016-11-09	ARKK	ETF	19.75	20.045	19.75	20.045	1900.0
2016-11-09	ARKQ	ETF	20.65	20.7	20.48	20.7	18800.0
2016-11-09	ARKW	ETF	23.99	24.626	23.891	24.575	22100.0
2016-11-09	ASEA	ETF	13.37	13.54	13.37	13.4	5800.0
2016-11-09	ASHR	ETF	24.8	24.99	24.8	24.9	1556800.0
2016-11-09	ASHS	ETF	34.81	34.81	34.59	34.69	8600.0
2016-11-09	ASHX	ETF	23.19	23.19	23.1	23.12	4600.0
2016-11-09	ATMP	ETF	22.43	22.68	22.24	22.63	52800.0
2016-11-09	BAB	ETF	30.3	30.3633	29.86	29.9	636789.0
2016-11-09	BAL	ETF	45.43	45.78	44.93	45.13	12666.0
2016-11-09	BBC	ETF	19.71	20.2178	19.22	20.2	96403.0
2016-11-09	BBH	ETF	113.95	116.42	110.65	114.15	372000.0
2016-11-09	BBP	ETF	30.0	33.87	30.0	33.73	252400.0

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

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