PREVIEW / etf_daily / 2016-06-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-08.parquet
  size:    51 KB
  rows:    1,276

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-06-08	SPY	ETF	211.84	212.52	211.69	212.37	66170900.0
2016-06-08	QQQ	ETF	110.37	110.6	109.96	110.37	14568699.0
2016-06-08	IWM	ETF	117.66	118.64	117.65	118.43	27999900.0
2016-06-08	DIA	ETF	179.67	180.18	179.54	180.06	1713500.0
2016-06-08	GLD	ETF	120.3	120.78	120.23	120.58	11661700.0
2016-06-08	TLT	ETF	132.87	133.43	132.71	133.27	5313200.0
2016-06-08	AAXJ	ETF	55.25	55.38	55.14	55.26	592800.0
2016-06-08	ACTX	ETF	4.72	4.72	4.602	4.72	198.0
2016-06-08	ACWI	ETF	58.04	58.2	57.98	58.14	919100.0
2016-06-08	ACWV	ETF	75.34	75.53	75.24	75.42	117700.0
2016-06-08	ACWX	ETF	41.17	41.27	41.12	41.17	403794.0
2016-06-08	ADRE	ETF	31.43	31.545	31.43	31.53	4734.0
2016-06-08	AFK	ETF	21.05	21.3199	20.8401	21.3199	19982.0
2016-06-08	AFTY	ETF	12.57	12.57	12.565	12.57	1000.0
2016-06-08	AGG	ETF	111.3	111.34	111.22	111.29	2148000.0
2016-06-08	AGGY	ETF	51.15	51.288	51.05	51.247	3300.0
2016-06-08	AGQ	ETF	39.23	39.72	39.0	39.57	395600.0
2016-06-08	AGZ	ETF	115.05	115.2399	114.87	114.96	106834.0
2016-06-08	AIA	ETF	44.7	44.84	44.7	44.78	20598.0
2016-06-08	AIQ	ETF	6.66	6.69	6.52	6.55	38011.0
2016-06-08	AIRR	ETF	18.75	19.03	18.75	19.002	12200.0
2016-06-08	AIVI	ETF	39.52	39.67	39.46	39.5	11700.0
2016-06-08	ALTY	ETF	14.9	14.9	14.89	14.89	500.0
2016-06-08	AMJ	ETF	32.12	32.25	31.66	31.78	1802534.0
2016-06-08	AMLP	ETF	64.75	64.8	63.65	64.0	2128140.0
2016-06-08	AMZA	ETF	118.9	118.9	115.1	115.5	26060.0
2016-06-08	ANGL	ETF	27.32	27.49	27.31	27.44	103200.0
2016-06-08	AOA	ETF	46.61	46.68	46.53	46.61	56300.0
2016-06-08	AOK	ETF	32.83	32.8899	32.756	32.84	35992.0
2016-06-08	AOM	ETF	35.38	35.5	35.3401	35.49	50003.0
2016-06-08	AOR	ETF	40.43	40.4899	40.31	40.37	56124.0
2016-06-08	ARGT	ETF	22.23	22.43	22.2	22.24	149200.0
2016-06-08	ARKG	ETF	18.18	18.18	18.18	18.18	200.0
2016-06-08	ARKK	ETF	19.89	19.92	19.89	19.92	300.0
2016-06-08	ARKQ	ETF	19.76	19.76	19.76	19.76	100.0
2016-06-08	ARKW	ETF	22.45	22.45	22.37	22.37	500.0
2016-06-08	ASEA	ETF	13.57	13.57	13.44	13.44	800.0
2016-06-08	ASHR	ETF	23.93	23.98	23.86	23.91	974000.0
2016-06-08	ASHS	ETF	33.61	33.89	33.61	33.88	34200.0
2016-06-08	ATMP	ETF	22.13	22.6	21.93	22.0	22400.0
2016-06-08	BAB	ETF	31.03	31.03	30.9	30.92	137230.0
2016-06-08	BAL	ETF	43.8912	44.22	43.56	43.59	7305.0
2016-06-08	BBC	ETF	21.021	21.2099	21.021	21.1342	21184.0
2016-06-08	BBH	ETF	109.55	109.74	108.67	109.41	60200.0
2016-06-08	BBP	ETF	27.73	28.118	27.728	28.1	32900.0
2016-06-08	BCM	ETF	27.898	27.94	27.898	27.94	9423.0
2016-06-08	BFIT	ETF	15.3546	15.3546	15.3546	15.3546	100.0
2016-06-08	BFOR	ETF	7.8125	7.835	7.8125	7.835	21200.0
2016-06-08	BIB	ETF	46.07	46.31	45.19	45.87	262144.0
2016-06-08	BICK	ETF	20.67	20.7872	20.67	20.75	1500.0

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

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