PREVIEW / etf_daily / 2015-08-28

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-28.parquet
  size:    49 KB
  rows:    1,218

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-08-28	SPY	ETF	198.5	199.84	197.92	199.28	160414400.0
2015-08-28	QQQ	ETF	105.08	106.0	104.85	105.62	49919628.0
2015-08-28	IWM	ETF	114.36	115.7	114.21	115.62	41601400.0
2015-08-28	DIA	ETF	165.72	166.62	165.24	166.33	8115700.0
2015-08-28	GLD	ETF	108.17	109.3	108.12	108.7	7558900.0
2015-08-28	TLT	ETF	123.15	123.47	122.23	122.36	9946200.0
2015-08-28	AADR	ETF	37.57	37.57	37.56	37.56	300.0
2015-08-28	AAXJ	ETF	53.56	53.86	53.38	53.62	4956900.0
2015-08-28	ACTX	ETF	1.18	1.475	1.18	1.475	448.0
2015-08-28	ACWI	ETF	56.05	56.4	56.02	56.3	3318000.0
2015-08-28	ACWV	ETF	67.81	68.21	67.57	67.97	872100.0
2015-08-28	ACWX	ETF	40.82	41.1	40.815	41.04	966636.0
2015-08-28	ADRE	ETF	30.19	30.3	30.02	30.1	15138.0
2015-08-28	AFK	ETF	20.06	20.22	19.9101	20.07	9121.0
2015-08-28	AFTY	ETF	14.86	15.08	14.86	15.06	36700.0
2015-08-28	AGG	ETF	109.34	109.37	108.93	109.0	4774600.0
2015-08-28	AGQ	ETF	30.49	31.36	30.41	30.9	153000.0
2015-08-28	AGZ	ETF	113.92	113.9289	113.48	113.82	153943.0
2015-08-28	AGZD	ETF	23.99	24.055	23.925	23.945	57200.0
2015-08-28	AIA	ETF	42.18	42.426	42.11	42.26	32963.0
2015-08-28	AIQ	ETF	13.49	14.41	13.4	14.35	9714.0
2015-08-28	AIRR	ETF	16.28	16.42	16.28	16.39	2700.0
2015-08-28	AIVI	ETF	40.2	40.55	40.2	40.47	19400.0
2015-08-28	ALTY	ETF	14.437	14.45	14.437	14.44	600.0
2015-08-28	AMJ	ETF	35.37	36.42	35.26	35.99	3529030.0
2015-08-28	AMLP	ETF	71.95	73.2	71.8	72.7	1665180.0
2015-08-28	AMZA	ETF	172.0	172.0	166.5	172.0	2060.0
2015-08-28	ANGL	ETF	26.45	26.64	25.57	26.44	11900.0
2015-08-28	AOA	ETF	44.99	45.09	44.89	45.07	128300.0
2015-08-28	AOK	ETF	31.75	31.89	31.75	31.88	29480.0
2015-08-28	AOM	ETF	34.31	34.3724	34.22	34.33	54072.0
2015-08-28	AOR	ETF	39.0	39.0699	38.93	39.06	116075.0
2015-08-28	ARGT	ETF	17.59	18.06	17.59	17.95	6900.0
2015-08-28	ARKG	ETF	20.87	21.19	20.87	21.101	1100.0
2015-08-28	ARKK	ETF	20.2	20.35	20.2	20.24	2700.0
2015-08-28	ARKQ	ETF	18.37	18.39	18.3	18.3	1200.0
2015-08-28	ARKW	ETF	22.32	22.32	22.3	22.3	400.0
2015-08-28	ASEA	ETF	12.89	12.93	12.83	12.85	11300.0
2015-08-28	ASHR	ETF	32.52	32.87	32.41	32.7	4958800.0
2015-08-28	ASHS	ETF	39.05	39.85	39.05	39.53	157300.0
2015-08-28	ATMP	ETF	23.75	24.68	23.75	24.4	78100.0
2015-08-28	AWAY	ETF	28.86	29.24	28.7	29.19	714197.0
2015-08-28	BAB	ETF	29.17	29.25	29.0	29.1799	48645.0
2015-08-28	BAL	ETF	42.44	42.47	42.0912	42.17	7659.0
2015-08-28	BBC	ETF	31.16	32.02	30.7876	32.02	14191.0
2015-08-28	BBH	ETF	128.82	130.38	128.68	130.35	60400.0
2015-08-28	BBP	ETF	33.18	33.54	32.26	33.49	19300.0
2015-08-28	BCM	ETF	27.25	27.26	27.215	27.2499	1814.0
2015-08-28	BFOR	ETF	7.74	7.83	7.74	7.7975	97600.0
2015-08-28	BIB	ETF	79.0	81.19	78.66	81.17	986053.0

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

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