PREVIEW / etf_daily / 2016-11-17

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-17.parquet
  size:    53 KB
  rows:    1,337

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-17	SPY	ETF	218.05	219.06	217.92	218.99	69797200.0
2016-11-17	QQQ	ETF	116.86	117.78	116.61	117.76	20598553.0
2016-11-17	IWM	ETF	129.95	130.83	129.75	130.3	42576900.0
2016-11-17	DIA	ETF	189.09	189.33	188.74	189.3	4211200.0
2016-11-17	GLD	ETF	116.91	117.22	115.44	116.17	10342300.0
2016-11-17	TLT	ETF	121.95	122.11	120.99	121.2	11221600.0
2016-11-17	AADR	ETF	39.36	39.48	39.1	39.14	2600.0
2016-11-17	AAXJ	ETF	55.82	56.12	55.78	55.84	2473100.0
2016-11-17	ACSI	ETF	26.1308	26.23	26.11	26.23	12509.0
2016-11-17	ACTX	ETF	21.8302	21.8302	19.4702	21.2402	2162.0
2016-11-17	ACWF	ETF	23.9844	24.02	23.8567	24.0026	2093.0
2016-11-17	ACWI	ETF	58.09	58.39	58.09	58.3	2361300.0
2016-11-17	ACWV	ETF	72.61	72.87	72.51	72.71	1126200.0
2016-11-17	ACWX	ETF	39.71	39.85	39.6526	39.74	855296.0
2016-11-17	ADRE	ETF	32.92	32.98	32.7001	32.75	17633.0
2016-11-17	AFK	ETF	19.68	19.979	19.4	19.6196	7690.0
2016-11-17	AGG	ETF	109.01	109.02	108.67	108.72	1903700.0
2016-11-17	AGGY	ETF	50.234	50.28	50.14	50.18	15600.0
2016-11-17	AGQ	ETF	36.96	37.26	35.22	35.74	256900.0
2016-11-17	AGZ	ETF	113.44	113.629	113.28	113.41	8753.0
2016-11-17	AGZD	ETF	24.08	24.08	24.06	24.06	1600.0
2016-11-17	AIA	ETF	46.76	47.05	46.76	46.86	9959.0
2016-11-17	AIQ	ETF	7.55	7.75	7.5113	7.75	8735.0
2016-11-17	AIRR	ETF	22.63	22.69	22.43	22.5	127200.0
2016-11-17	AIVI	ETF	36.37	36.44	36.22	36.26	31600.0
2016-11-17	ALTY	ETF	14.734	14.734	14.14	14.63	22400.0
2016-11-17	AMJ	ETF	30.55	30.77	30.34	30.39	2370792.0
2016-11-17	AMLP	ETF	61.6	61.6	60.85	61.2	1842980.0
2016-11-17	AMZA	ETF	108.7	110.52	108.7	109.3	14980.0
2016-11-17	ANGL	ETF	28.48	28.48	28.36	28.37	106500.0
2016-11-17	AOA	ETF	46.49	46.65	46.45	46.57	101600.0
2016-11-17	AOK	ETF	32.41	32.51	32.35	32.43	325640.0
2016-11-17	AOM	ETF	35.04	35.16	34.9701	35.05	298456.0
2016-11-17	AOR	ETF	40.08	40.2	40.06	40.15	101893.0
2016-11-17	ARGT	ETF	22.86	22.87	22.69	22.69	16100.0
2016-11-17	ARKG	ETF	18.82	19.48	18.6	18.782	2500.0
2016-11-17	ARKK	ETF	20.5	20.735	20.5	20.72	3300.0
2016-11-17	ARKQ	ETF	21.75	21.76	21.75	21.76	400.0
2016-11-17	ARKW	ETF	25.57	25.82	25.57	25.82	3400.0
2016-11-17	ASEA	ETF	12.97	12.97	12.97	12.97	200.0
2016-11-17	ASHR	ETF	24.99	25.1	24.91	25.08	263800.0
2016-11-17	ASHS	ETF	35.13	35.16	35.05	35.1	6600.0
2016-11-17	ASHX	ETF	23.48	23.6	23.47	23.54	7858.0
2016-11-17	ATMP	ETF	23.08	23.08	22.7	22.85	397500.0
2016-11-17	BAB	ETF	29.55	29.61	29.3854	29.43	163155.0
2016-11-17	BAL	ETF	47.03	47.9489	47.03	47.92	17147.0
2016-11-17	BBC	ETF	21.47	21.7	21.3831	21.6036	6093.0
2016-11-17	BBH	ETF	112.09	113.6	111.7	113.55	89300.0
2016-11-17	BBP	ETF	35.03	35.799	34.882	35.596	15300.0
2016-11-17	BCM	ETF	25.77	25.78	25.753	25.753	1810.0

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

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