PREVIEW / etf_daily / 2016-11-21

all etf daily files

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

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-21	SPY	ETF	219.17	220.18	219.0	220.15	72402600.0
2016-11-21	QQQ	ETF	117.6	118.65	117.57	118.54	20268547.0
2016-11-21	IWM	ETF	131.31	132.0	130.61	131.6	32293100.0
2016-11-21	DIA	ETF	188.88	189.41	188.6	189.34	2999100.0
2016-11-21	GLD	ETF	115.72	115.94	115.29	115.58	6654200.0
2016-11-21	TLT	ETF	121.21	121.48	120.89	121.15	6488100.0
2016-11-21	AADR	ETF	40.08	40.16	40.02	40.16	8900.0
2016-11-21	AAXJ	ETF	55.88	56.08	55.78	55.91	568000.0
2016-11-21	ACSI	ETF	26.31	26.36	26.2847	26.34	14464.0
2016-11-21	ACTX	ETF	25.0752	37.7603	24.1902	30.0903	12274.0
2016-11-21	ACWF	ETF	24.31	24.31	24.07	24.07	3570.0
2016-11-21	ACWI	ETF	58.2	58.5	58.2	58.47	1038200.0
2016-11-21	ACWV	ETF	72.5	72.68	72.48	72.65	280500.0
2016-11-21	ACWX	ETF	39.65	39.77	39.6	39.75	612672.0
2016-11-21	ADRE	ETF	32.91	33.03	32.8801	33.0	4680.0
2016-11-21	AFK	ETF	19.64	19.64	19.04	19.4495	7793.0
2016-11-21	AFTY	ETF	13.57	13.59	13.57	13.59	7800.0
2016-11-21	AGG	ETF	108.56	108.57	108.37	108.46	1705600.0
2016-11-21	AGGY	ETF	49.84	49.882	49.818	49.83	11700.0
2016-11-21	AGQ	ETF	35.29	35.78	34.97	35.2	146400.0
2016-11-21	AGZ	ETF	113.4	113.51	113.2288	113.4	15509.0
2016-11-21	AGZD	ETF	23.93	23.985	23.875	23.985	3400.0
2016-11-21	AIA	ETF	47.0	47.15	47.0	47.15	11713.0
2016-11-21	AIQ	ETF	7.8	7.8	7.6	7.65	9819.0
2016-11-21	AIRR	ETF	22.67	22.67	22.422	22.563	89300.0
2016-11-21	AIVI	ETF	36.12	36.14	35.98	36.14	31400.0
2016-11-21	ALTY	ETF	14.67	14.817	14.65	14.79	8700.0
2016-11-21	AMJ	ETF	31.29	31.29	30.56	30.93	2266845.0
2016-11-21	AMLP	ETF	62.25	62.45	61.15	61.4	1856140.0
2016-11-21	AMZA	ETF	110.5	112.3	109.0	110.32	61580.0
2016-11-21	ANGL	ETF	28.27	28.49	28.27	28.49	149600.0
2016-11-21	AOA	ETF	46.72	46.72	46.51	46.69	93100.0
2016-11-21	AOK	ETF	32.42	32.52	32.3001	32.41	68261.0
2016-11-21	AOM	ETF	35.13	35.13	34.89	35.08	108892.0
2016-11-21	AOR	ETF	40.12	40.17	40.0	40.15	231552.0
2016-11-21	ARGT	ETF	22.65	23.15	22.65	23.12	36600.0
2016-11-21	ARKG	ETF	18.79	18.97	18.781	18.97	1000.0
2016-11-21	ARKK	ETF	20.82	20.88	20.82	20.88	6900.0
2016-11-21	ARKQ	ETF	21.62	21.747	21.62	21.73	2000.0
2016-11-21	ARKW	ETF	25.61	25.86	25.61	25.79	2400.0
2016-11-21	ASEA	ETF	13.02	13.05	12.97	12.97	1800.0
2016-11-21	ASET	ETF	24.94	24.94	24.94	24.94	200.0
2016-11-21	ASHR	ETF	25.05	25.14	25.03	25.14	549900.0
2016-11-21	ASHS	ETF	34.81	34.83	34.8	34.83	3500.0
2016-11-21	ASHX	ETF	24.0	24.0	23.62	23.62	420.0
2016-11-21	ATMP	ETF	23.0	23.43	23.0	23.38	317400.0
2016-11-21	BAB	ETF	29.42	29.4707	29.29	29.31	257737.0
2016-11-21	BAL	ETF	47.78	47.84	47.46	47.66	11457.0
2016-11-21	BBC	ETF	22.03	22.03	21.4291	21.65	7619.0
2016-11-21	BBH	ETF	112.07	112.68	111.95	112.55	51200.0

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

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