PREVIEW / etf_daily / 2016-11-30

all etf daily files

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

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-30	SPY	ETF	221.63	221.82	220.31	220.38	113291800.0
2016-11-30	QQQ	ETF	119.06	119.1335	117.46	117.5	30405342.0
2016-11-30	IWM	ETF	132.92	133.09	131.5	131.61	32491200.0
2016-11-30	DIA	ETF	191.97	192.25	191.34	191.4	4774600.0
2016-11-30	GLD	ETF	112.69	112.79	111.5	111.75	10925500.0
2016-11-30	TLT	ETF	119.97	121.01	119.48	120.24	21163500.0
2016-11-30	AADR	ETF	41.18	41.18	40.68	40.68	2800.0
2016-11-30	AAXJ	ETF	57.2	57.26	57.02	57.08	823600.0
2016-11-30	ACSI	ETF	28.03	28.03	26.5	26.5	9947.0
2016-11-30	ACTX	ETF	33.0403	33.6303	27.1402	27.1402	1653.0
2016-11-30	ACWI	ETF	58.84	58.93	58.57	58.57	1617000.0
2016-11-30	ACWV	ETF	73.3	73.3	72.54	72.54	117600.0
2016-11-30	ACWX	ETF	40.07	40.09	39.895	39.92	1533584.0
2016-11-30	ADRE	ETF	33.51	33.51	33.3801	33.4	4279.0
2016-11-30	AFK	ETF	19.44	19.62	19.05	19.43	6060.0
2016-11-30	AFTY	ETF	14.07	14.08	14.06	14.08	700.0
2016-11-30	AGG	ETF	108.23	108.43	108.13	108.24	4627500.0
2016-11-30	AGGY	ETF	49.718	49.825	49.62	49.76	21300.0
2016-11-30	AGQ	ETF	35.38	35.52	34.5	34.78	317600.0
2016-11-30	AGZ	ETF	113.1	113.3339	112.86	112.92	14662.0
2016-11-30	AGZD	ETF	24.065	24.065	24.03	24.045	4800.0
2016-11-30	AIA	ETF	48.54	48.54	48.25	48.37	120214.0
2016-11-30	AIQ	ETF	7.4	7.6	7.35	7.6	14536.0
2016-11-30	AIRR	ETF	23.05	23.29	22.85	22.92	168000.0
2016-11-30	AIVI	ETF	36.45	36.54	36.2	36.34	40100.0
2016-11-30	ALTY	ETF	14.795	14.795	14.782	14.782	800.0
2016-11-30	AMJ	ETF	30.03	30.62	29.92	30.22	5417505.0
2016-11-30	AMLP	ETF	61.2	62.0	61.0	61.8	2502140.0
2016-11-30	AMZA	ETF	109.9	110.41	108.7	109.3	34940.0
2016-11-30	ANGL	ETF	28.63	28.68	28.56	28.66	229800.0
2016-11-30	AOA	ETF	47.08	47.08	46.75	46.8	209400.0
2016-11-30	AOK	ETF	32.56	32.56	32.33	32.45	86783.0
2016-11-30	AOM	ETF	35.18	35.1937	35.08	35.08	228003.0
2016-11-30	AOR	ETF	40.26	40.4	40.21	40.22	272228.0
2016-11-30	ARGT	ETF	23.05	23.21	22.97	23.11	46400.0
2016-11-30	ARKG	ETF	18.31	18.31	17.85	17.86	2900.0
2016-11-30	ARKK	ETF	20.3	20.35	20.11	20.11	2000.0
2016-11-30	ARKQ	ETF	21.547	21.547	21.547	21.547	200.0
2016-11-30	ARKW	ETF	25.332	25.332	25.32	25.32	900.0
2016-11-30	ASEA	ETF	13.1	13.1	12.93	12.94	3300.0
2016-11-30	ASET	ETF	25.2753	25.2753	25.2753	25.2753	200.0
2016-11-30	ASHR	ETF	25.93	25.93	25.83	25.88	1093000.0
2016-11-30	ASHS	ETF	34.65	34.68	34.64	34.68	6900.0
2016-11-30	ATMP	ETF	22.6	22.96	22.6	22.74	40300.0
2016-11-30	BAB	ETF	29.27	29.34	29.2	29.31	328741.0
2016-11-30	BAL	ETF	46.85	47.17	46.85	47.07	4118.0
2016-11-30	BBC	ETF	20.72	20.72	19.8	19.8364	13846.0
2016-11-30	BBH	ETF	111.59	111.59	108.81	108.82	48900.0
2016-11-30	BBP	ETF	34.91	34.91	33.944	34.03	8000.0
2016-11-30	BCM	ETF	26.58	26.888	26.58	26.71	6603.0

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

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