PREVIEW / etf_daily / 2016-12-30

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-30.parquet
  size:    54 KB
  rows:    1,377

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-12-30	SPY	ETF	224.73	224.83	222.73	223.53	108998300.0
2016-12-30	QQQ	ETF	119.93	119.95	118.14	118.48	41749028.0
2016-12-30	IWM	ETF	135.6	135.63	134.4	134.85	28399300.0
2016-12-30	DIA	ETF	198.25	198.27	196.92	197.51	4277400.0
2016-12-30	GLD	ETF	110.38	110.62	109.53	109.61	8873700.0
2016-12-30	TLT	ETF	118.78	119.65	118.72	119.13	10613900.0
2016-12-30	AADR	ETF	40.28	40.39	40.04	40.18	3800.0
2016-12-30	AAXJ	ETF	55.28	55.33	54.84	54.93	891600.0
2016-12-30	ACSI	ETF	27.13	27.13	26.97	26.97	4430.0
2016-12-30	ACTX	ETF	18.2902	21.8302	18.2902	19.4702	788.0
2016-12-30	ACWF	ETF	24.1	24.1	24.1	24.1	433.0
2016-12-30	ACWI	ETF	59.47	59.48	59.02	59.17	3025900.0
2016-12-30	ACWV	ETF	72.94	72.94	72.44	72.61	159700.0
2016-12-30	ACWX	ETF	40.48	40.48	40.18	40.27	1030911.0
2016-12-30	ADRE	ETF	32.5	32.5	32.111	32.25	10411.0
2016-12-30	AFK	ETF	19.84	19.84	19.4	19.79	34242.0
2016-12-30	AFTY	ETF	12.977	12.977	12.95	12.95	200.0
2016-12-30	AGG	ETF	107.88	108.12	107.85	108.06	3690100.0
2016-12-30	AGGY	ETF	49.482	49.6	49.458	49.58	17100.0
2016-12-30	AGQ	ETF	33.32	33.46	31.76	32.09	273400.0
2016-12-30	AGZ	ETF	112.34	112.9249	112.34	112.62	16458.0
2016-12-30	AGZD	ETF	24.1	24.15	24.01	24.14	8200.0
2016-12-30	AIA	ETF	46.53	46.53	46.135	46.24	21231.0
2016-12-30	AIQ	ETF	9.575	9.6	9.55	9.6	6310.0
2016-12-30	AIRR	ETF	24.05	24.05	23.619	23.65	58500.0
2016-12-30	AIVI	ETF	37.54	37.54	37.29	37.37	84900.0
2016-12-30	ALTY	ETF	14.95	14.95	14.87	14.87	2900.0
2016-12-30	AMJ	ETF	31.31	31.61	31.27	31.61	1400857.0
2016-12-30	AMLP	ETF	63.0	63.2	62.85	63.0	1098780.0
2016-12-30	AMUB	ETF	19.79	19.9	19.79	19.9	350.0
2016-12-30	AMZA	ETF	113.1	113.4	112.5	113.3	60900.0
2016-12-30	ANGL	ETF	28.85	28.85	28.7	28.78	623400.0
2016-12-30	AOA	ETF	47.37	47.37	47.08	47.22	107500.0
2016-12-30	AOK	ETF	32.59	32.59	32.47	32.53	284670.0
2016-12-30	AOM	ETF	35.29	35.29	35.15	35.23	276693.0
2016-12-30	AOR	ETF	40.64	40.68	40.43	40.58	317187.0
2016-12-30	ARGT	ETF	22.93	23.1	22.93	23.06	3600.0
2016-12-30	ARKG	ETF	17.092	17.092	16.91	16.927	23600.0
2016-12-30	ARKK	ETF	20.063	20.07	20.036	20.05	1000.0
2016-12-30	ARKQ	ETF	22.13	22.13	21.963	21.963	22800.0
2016-12-30	ARKW	ETF	25.081	25.095	25.081	25.095	500.0
2016-12-30	ASEA	ETF	12.79	12.84	12.76	12.79	16800.0
2016-12-30	ASET	ETF	25.52	25.52	25.5042	25.5051	2200.0
2016-12-30	ASHR	ETF	23.58	23.58	23.45	23.45	473100.0
2016-12-30	ASHS	ETF	32.31	32.31	32.27	32.29	3300.0
2016-12-30	ASHX	ETF	18.86	18.86	18.829	18.83	531.0
2016-12-30	ATMP	ETF	23.79	23.79	23.37	23.55	144500.0
2016-12-30	BAB	ETF	29.1	29.19	29.04	29.09	231431.0
2016-12-30	BAL	ETF	46.8384	47.3	46.441	46.46	7394.0
2016-12-30	BBC	ETF	18.45	18.53	18.2783	18.41	3630.0

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

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