PREVIEW / etf_daily / 2016-05-17

all etf daily files

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

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-17	SPY	ETF	206.46	206.8	204.23	204.85	114924900.0
2016-05-17	QQQ	ETF	106.74	107.04	105.2	105.48	29932711.0
2016-05-17	IWM	ETF	110.88	111.42	108.77	109.27	46676300.0
2016-05-17	DIA	ETF	176.91	177.24	174.92	175.56	3349500.0
2016-05-17	GLD	ETF	121.58	122.52	121.48	122.22	8619800.0
2016-05-17	TLT	ETF	131.21	131.83	131.21	131.36	4449100.0
2016-05-17	AADR	ETF	38.28	38.28	38.28	38.28	200.0
2016-05-17	AAXJ	ETF	51.9	52.05	51.57	51.71	435000.0
2016-05-17	ACTX	ETF	4.13	4.72	4.13	4.72	749.0
2016-05-17	ACWF	ETF	22.63	22.67	22.6142	22.67	2301.0
2016-05-17	ACWI	ETF	56.31	56.31	55.7	55.84	1333400.0
2016-05-17	ACWV	ETF	74.07	74.07	73.21	73.42	232900.0
2016-05-17	ACWX	ETF	39.54	39.65	39.2833	39.33	377606.0
2016-05-17	ADRE	ETF	30.12	30.24	29.9884	30.07	4899.0
2016-05-17	AFK	ETF	20.05	20.335	19.92	20.25	72172.0
2016-05-17	AFTY	ETF	12.21	12.231	12.21	12.23	400.0
2016-05-17	AGG	ETF	111.03	111.05	110.86	110.86	1769700.0
2016-05-17	AGGY	ETF	50.98	51.059	50.946	51.008	2900.0
2016-05-17	AGNG	ETF	15.26	15.26	15.26	15.26	400.0
2016-05-17	AGQ	ETF	40.18	41.08	40.05	40.55	129400.0
2016-05-17	AGZ	ETF	115.56	115.56	114.84	114.88	18018.0
2016-05-17	AGZD	ETF	23.905	23.93	23.905	23.92	6800.0
2016-05-17	AIA	ETF	41.04	41.0697	40.79	40.94	13740.0
2016-05-17	AIQ	ETF	7.52	7.87	7.32	7.47	14601.0
2016-05-17	AIRR	ETF	17.6	17.74	17.4	17.4	2400.0
2016-05-17	AIVI	ETF	38.35	38.56	38.17	38.22	16300.0
2016-05-17	ALTY	ETF	14.74	14.74	14.68	14.68	700.0
2016-05-17	AMJ	ETF	30.39	31.14	30.32	30.76	2852476.0
2016-05-17	AMLP	ETF	61.45	62.45	60.85	61.8	3350980.0
2016-05-17	AMZA	ETF	108.7	110.4	107.2	108.7	16060.0
2016-05-17	ANGL	ETF	26.86	26.86	26.76	26.79	55100.0
2016-05-17	AOA	ETF	45.33	45.36	44.91	45.04	28100.0
2016-05-17	AOK	ETF	32.4	32.43	32.28	32.31	30709.0
2016-05-17	AOM	ETF	34.85	34.87	34.65	34.74	60629.0
2016-05-17	AOR	ETF	39.39	39.46	39.17	39.29	38250.0
2016-05-17	ARGT	ETF	20.51	20.71	20.45	20.45	125300.0
2016-05-17	ARKG	ETF	16.68	16.68	16.68	16.68	200.0
2016-05-17	ARKK	ETF	18.15	18.15	18.15	18.15	100.0
2016-05-17	ARKQ	ETF	18.31	18.31	18.31	18.31	100.0
2016-05-17	ARKW	ETF	20.661	20.754	20.5	20.5	800.0
2016-05-17	ASEA	ETF	12.8	12.8	12.8	12.8	100.0
2016-05-17	ASHR	ETF	23.06	23.12	22.92	22.94	1058700.0
2016-05-17	ASHS	ETF	31.85	31.9	31.7	31.78	11300.0
2016-05-17	ATMP	ETF	21.12	21.48	21.12	21.26	71000.0
2016-05-17	BAB	ETF	30.6	30.658	30.51	30.62	260863.0
2016-05-17	BAL	ETF	41.22	41.3626	41.04	41.3323	4056.0
2016-05-17	BBC	ETF	18.04	18.5491	17.94	17.99	12557.0
2016-05-17	BBH	ETF	104.52	104.82	103.26	103.65	89000.0
2016-05-17	BBP	ETF	25.35	25.35	25.05	25.05	400.0
2016-05-17	BCM	ETF	26.72	26.82	26.72	26.82	1760.0

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

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