PREVIEW / etf_daily / 2016-05-16

all etf daily files

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

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-16	SPY	ETF	204.96	207.34	204.89	206.78	77486800.0
2016-05-16	QQQ	ETF	105.67	107.21	105.56	106.82	18311860.0
2016-05-16	IWM	ETF	109.92	111.52	109.87	111.03	27337000.0
2016-05-16	DIA	ETF	175.69	177.7	175.58	177.26	2393500.0
2016-05-16	GLD	ETF	122.93	122.97	121.38	121.8	7103000.0
2016-05-16	TLT	ETF	131.64	131.66	130.98	131.14	5137000.0
2016-05-16	AADR	ETF	37.99	38.32	37.99	38.09	5500.0
2016-05-16	AAXJ	ETF	51.69	52.06	51.69	51.91	380200.0
2016-05-16	ACTX	ETF	3.54	4.72	3.54	4.72	496.0
2016-05-16	ACWF	ETF	22.76	22.88	22.76	22.88	3590.0
2016-05-16	ACWI	ETF	55.83	56.39	55.74	56.27	4366600.0
2016-05-16	ACWV	ETF	73.7	74.21	73.57	74.11	93900.0
2016-05-16	ACWX	ETF	39.26	39.63	39.26	39.6	421437.0
2016-05-16	ADRE	ETF	29.84	30.275	29.84	30.19	10994.0
2016-05-16	AFK	ETF	20.213	20.52	20.21	20.326	43656.0
2016-05-16	AFTY	ETF	12.32	12.352	12.3	12.34	1900.0
2016-05-16	AGG	ETF	111.19	111.19	110.98	111.01	3134400.0
2016-05-16	AGGY	ETF	50.93	51.07	50.93	51.07	3500.0
2016-05-16	AGQ	ETF	41.1	41.31	39.96	40.11	181900.0
2016-05-16	AGZ	ETF	115.35	115.35	114.9301	114.9301	19377.0
2016-05-16	AGZD	ETF	23.96	23.96	23.96	23.96	1200.0
2016-05-16	AIA	ETF	40.8	41.12	40.8	41.0	11751.0
2016-05-16	AIQ	ETF	7.93	7.93	7.4	7.49	48110.0
2016-05-16	AIRR	ETF	17.38	17.74	17.38	17.72	1900.0
2016-05-16	AIVI	ETF	38.09	38.49	38.09	38.39	20800.0
2016-05-16	ALTY	ETF	14.76	14.76	14.74	14.75	400.0
2016-05-16	AMJ	ETF	30.18	30.61	30.15	30.53	1719976.0
2016-05-16	AMLP	ETF	60.25	61.4	60.1	61.3	2193660.0
2016-05-16	AMZA	ETF	106.1	108.2	106.0	107.9	24440.0
2016-05-16	ANGL	ETF	26.89	26.89	26.69	26.82	107400.0
2016-05-16	AOA	ETF	44.92	45.42	44.92	45.35	24100.0
2016-05-16	AOK	ETF	32.28	32.43	32.28	32.43	60645.0
2016-05-16	AOM	ETF	34.8	34.92	34.725	34.88	54695.0
2016-05-16	AOR	ETF	39.34	39.509	39.2568	39.47	52038.0
2016-05-16	ARGT	ETF	20.73	20.75	20.42	20.42	232000.0
2016-05-16	ARKG	ETF	16.61	16.61	16.61	16.61	100.0
2016-05-16	ARKK	ETF	18.28	18.28	18.28	18.28	100.0
2016-05-16	ARKQ	ETF	18.23	18.27	18.23	18.23	1000.0
2016-05-16	ARKW	ETF	20.592	20.656	20.592	20.656	900.0
2016-05-16	ASEA	ETF	12.8	12.85	12.8	12.8	2600.0
2016-05-16	ASHR	ETF	23.04	23.26	23.04	23.23	1657100.0
2016-05-16	ASHS	ETF	32.06	32.19	31.96	32.09	73300.0
2016-05-16	ATMP	ETF	20.88	21.08	20.85	21.08	39800.0
2016-05-16	BAB	ETF	30.65	30.65	30.51	30.52	123555.0
2016-05-16	BAL	ETF	40.569	40.59	40.25	40.25	3441.0
2016-05-16	BBC	ETF	17.74	18.13	17.74	17.93	3272.0
2016-05-16	BBH	ETF	103.26	105.03	103.1	104.8	80000.0
2016-05-16	BBP	ETF	24.04	25.12	24.04	25.12	900.0
2016-05-16	BCM	ETF	26.63	26.72	26.63	26.72	11421.0
2016-05-16	BDCZ	ETF	20.3783	20.3783	20.3783	20.3783	150.0

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

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