PREVIEW / etf_daily / 2015-10-16

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-16.parquet
  size:    49 KB
  rows:    1,211

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
2015-10-16	SPY	ETF	202.83	203.29	201.92	203.27	114580100.0
2015-10-16	QQQ	ETF	107.9	108.18	107.3794	108.12	27091100.0
2015-10-16	IWM	ETF	115.8	115.8	114.43	115.42	33685600.0
2015-10-16	DIA	ETF	171.44	171.96	170.82	171.88	8353700.0
2015-10-16	GLD	ETF	113.24	113.44	112.43	112.49	7328000.0
2015-10-16	TLT	ETF	124.25	124.47	123.87	123.93	8048300.0
2015-10-16	AADR	ETF	37.92	37.92	37.92	37.92	200.0
2015-10-16	AAXJ	ETF	57.89	58.17	57.72	58.11	476000.0
2015-10-16	ACTX	ETF	13.5701	13.5701	10.9151	11.8001	1478.0
2015-10-16	ACWF	ETF	23.57	23.57	23.57	23.57	300.0
2015-10-16	ACWI	ETF	57.57	57.68	57.37	57.66	1867900.0
2015-10-16	ACWV	ETF	70.23	70.42	70.09	70.41	55000.0
2015-10-16	ACWX	ETF	41.97	42.09	41.8501	42.06	203169.0
2015-10-16	ADRE	ETF	30.32	30.599	30.32	30.599	5917.0
2015-10-16	AFK	ETF	21.24	21.39	21.23	21.26	45593.0
2015-10-16	AFTY	ETF	16.15	16.29	16.101	16.25	16400.0
2015-10-16	AGG	ETF	109.9	109.94	109.77	109.77	1630000.0
2015-10-16	AGQ	ETF	37.28	37.57	36.79	36.83	82000.0
2015-10-16	AGZ	ETF	114.16	114.26	113.96	114.1	13611.0
2015-10-16	AGZD	ETF	23.92	24.005	23.91	24.005	42400.0
2015-10-16	AIA	ETF	46.21	46.45	46.15	46.43	14451.0
2015-10-16	AIQ	ETF	10.54	10.55	9.98	10.01	22733.0
2015-10-16	AIRR	ETF	16.438	16.438	16.07	16.18	10800.0
2015-10-16	AIVI	ETF	41.09	41.24	41.01	41.21	12400.0
2015-10-16	ALTY	ETF	14.6	14.6	14.6	14.6	200.0
2015-10-16	AMJ	ETF	34.35	34.5	34.01	34.48	2005963.0
2015-10-16	AMLP	ETF	70.05	70.45	69.55	70.2	1759680.0
2015-10-16	AMUB	ETF	21.61	21.61	21.61	21.61	200.0
2015-10-16	AMZA	ETF	148.7	151.9	148.27	151.4	3370.0
2015-10-16	ANGL	ETF	26.0	26.09	26.0	26.06	11400.0
2015-10-16	AOA	ETF	45.81	45.87	45.6	45.75	64400.0
2015-10-16	AOK	ETF	32.2	32.21	32.1101	32.1773	154033.0
2015-10-16	AOM	ETF	34.72	34.74	34.6001	34.72	94905.0
2015-10-16	AOR	ETF	39.57	39.6124	39.46	39.56	126780.0
2015-10-16	ARGT	ETF	17.65	17.91	17.63	17.84	8100.0
2015-10-16	ARKG	ETF	19.333	19.44	19.333	19.34	500.0
2015-10-16	ARKK	ETF	19.79	19.9	19.79	19.81	500.0
2015-10-16	ARKQ	ETF	18.52	18.52	18.49	18.49	1300.0
2015-10-16	ARKW	ETF	22.27	22.27	22.27	22.27	300.0
2015-10-16	ASEA	ETF	13.57	13.57	13.57	13.57	500.0
2015-10-16	ASHR	ETF	35.94	36.21	35.73	36.19	3237700.0
2015-10-16	ASHS	ETF	42.54	43.7	42.54	43.49	139400.0
2015-10-16	ATMP	ETF	23.53	23.58	23.35	23.56	18000.0
2015-10-16	AWAY	ETF	29.1	29.31	28.59	29.02	811096.0
2015-10-16	BAB	ETF	29.32	29.32	29.24	29.2599	72722.0
2015-10-16	BAL	ETF	42.2512	42.6	42.23	42.5806	6035.0
2015-10-16	BBC	ETF	28.13	28.4	27.55	27.65	17554.0
2015-10-16	BBH	ETF	119.26	120.0	117.26	118.69	138200.0
2015-10-16	BBP	ETF	30.0	30.18	29.38	29.63	7600.0
2015-10-16	BCHP	ETF	18.53	18.53	18.52	18.52	696.0

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

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