PREVIEW / etf_daily / 2016-05-31

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-31.parquet
  size:    51 KB
  rows:    1,283

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-05-31	SPY	ETF	210.56	210.69	209.18	209.84	109879400.0
2016-05-31	QQQ	ETF	110.28	110.51	109.7837	110.34	24366106.0
2016-05-31	IWM	ETF	114.82	115.54	114.5	115.0	32764400.0
2016-05-31	DIA	ETF	178.98	178.98	177.13	177.65	2395400.0
2016-05-31	GLD	ETF	115.76	116.4	115.5	116.06	8187600.0
2016-05-31	TLT	ETF	129.02	130.44	128.98	130.16	8344300.0
2016-05-31	AADR	ETF	38.23	38.84	38.23	38.62	1500.0
2016-05-31	AAXJ	ETF	53.21	53.45	53.05	53.31	661200.0
2016-05-31	ACTX	ETF	4.425	4.72	4.13	4.661	1896.0
2016-05-31	ACWF	ETF	23.29	23.29	23.17	23.17	900.0
2016-05-31	ACWI	ETF	57.27	57.35	56.85	57.0	1429900.0
2016-05-31	ACWV	ETF	73.98	73.98	73.55	73.74	265800.0
2016-05-31	ACWX	ETF	40.27	40.35	39.9	39.99	464894.0
2016-05-31	ADRE	ETF	30.61	30.61	30.371	30.44	4172.0
2016-05-31	AFK	ETF	20.11	20.2643	19.06	19.7699	70393.0
2016-05-31	AFTY	ETF	12.66	12.73	12.64	12.73	6800.0
2016-05-31	AGG	ETF	110.41	110.76	110.36	110.7	3368800.0
2016-05-31	AGGY	ETF	50.7	50.776	50.666	50.763	5600.0
2016-05-31	AGNG	ETF	15.707	15.707	15.707	15.707	100.0
2016-05-31	AGQ	ETF	35.1	35.3	34.66	34.76	218300.0
2016-05-31	AGZ	ETF	114.5399	114.868	114.4499	114.7008	42780.0
2016-05-31	AIA	ETF	42.65	42.82	42.52	42.81	36585.0
2016-05-31	AIQ	ETF	7.12	7.46	7.12	7.25	37119.0
2016-05-31	AIRR	ETF	18.261	18.261	18.261	18.261	200.0
2016-05-31	AIVI	ETF	38.82	38.82	38.24	38.46	14700.0
2016-05-31	ALTY	ETF	14.69	14.72	14.67	14.67	400.0
2016-05-31	AMJ	ETF	30.22	30.67	30.04	30.21	3675599.0
2016-05-31	AMLP	ETF	61.45	62.2	60.85	61.05	1735860.0
2016-05-31	AMZA	ETF	109.5	112.1	108.6	109.7	18130.0
2016-05-31	ANGL	ETF	27.08	27.08	26.98	27.01	87900.0
2016-05-31	AOA	ETF	45.91	46.02	45.73	45.89	40500.0
2016-05-31	AOK	ETF	32.54	32.685	32.44	32.51	31555.0
2016-05-31	AOM	ETF	35.14	35.1599	34.91	35.05	97459.0
2016-05-31	AOR	ETF	40.0	40.0	39.7301	39.84	84558.0
2016-05-31	ARGT	ETF	20.89	20.95	20.79	20.8	82600.0
2016-05-31	ARKG	ETF	17.93	17.93	17.93	17.93	300.0
2016-05-31	ARKK	ETF	19.46	19.54	19.4	19.49	3100.0
2016-05-31	ARKQ	ETF	19.38	19.39	19.38	19.39	500.0
2016-05-31	ARKW	ETF	22.0	22.023	21.948	21.948	700.0
2016-05-31	ASEA	ETF	12.87	12.87	12.85	12.85	400.0
2016-05-31	ASET	ETF	25.91	25.91	25.91	25.91	100.0
2016-05-31	ASHR	ETF	24.04	24.22	23.94	24.22	3555800.0
2016-05-31	ASHS	ETF	33.19	33.7	33.19	33.33	62400.0
2016-05-31	ASHX	ETF	21.41	21.8	21.41	21.8	3200.0
2016-05-31	ATMP	ETF	21.06	21.08	20.69	20.75	24600.0
2016-05-31	BAB	ETF	30.53	30.64	30.46	30.6	134204.0
2016-05-31	BAL	ETF	42.22	42.48	42.01	42.4	4448.0
2016-05-31	BBC	ETF	20.38	20.9999	20.38	20.94	15472.0
2016-05-31	BBH	ETF	109.76	110.93	109.76	110.47	107500.0
2016-05-31	BBP	ETF	27.65	28.1	27.65	27.97	31300.0

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

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