PREVIEW / etf_daily / 2017-04-27

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-27.parquet
  size:    55 KB
  rows:    1,390

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
2017-04-27	SPY	ETF	238.77	238.95	237.98	238.6	57410300.0
2017-04-27	QQQ	ETF	135.28	135.75	135.19	135.75	16136538.0
2017-04-27	IWM	ETF	141.34	141.8	140.48	140.95	23004300.0
2017-04-27	DIA	ETF	209.73	209.77	209.06	209.56	1951700.0
2017-04-27	GLD	ETF	120.42	120.6	119.97	120.39	8267000.0
2017-04-27	TLT	ETF	121.75	122.35	121.58	122.08	4978300.0
2017-04-27	AADR	ETF	48.1	48.1	47.0	47.06	19200.0
2017-04-27	AAXJ	ETF	64.38	64.38	64.08	64.24	694300.0
2017-04-27	ACSI	ETF	28.33	28.4999	28.33	28.45	756.0
2017-04-27	ACTX	ETF	90.2708	90.2708	78.4707	79.6507	1368.0
2017-04-27	ACWF	ETF	26.38	26.38	26.2376	26.2552	751.0
2017-04-27	ACWI	ETF	64.39	64.41	64.15	64.3	1897300.0
2017-04-27	ACWV	ETF	78.1	78.22	77.95	78.05	173700.0
2017-04-27	ACWX	ETF	44.63	44.63	44.4444	44.565	753997.0
2017-04-27	ADRE	ETF	37.037	37.037	36.8326	36.9516	4490.0
2017-04-27	AFK	ETF	21.3	21.3	21.09	21.1	6569.0
2017-04-27	AFTY	ETF	13.68	13.7	13.68	13.7	6300.0
2017-04-27	AGG	ETF	108.94	109.1	108.91	109.06	1660900.0
2017-04-27	AGGY	ETF	50.08	50.15	50.043	50.14	5500.0
2017-04-27	AGNG	ETF	17.61	17.65	17.59	17.65	900.0
2017-04-27	AGQ	ETF	37.56	37.56	36.95	37.02	182300.0
2017-04-27	AGZ	ETF	113.3448	113.53	113.3214	113.53	11604.0
2017-04-27	AGZD	ETF	23.96	23.96	23.96	23.96	1800.0
2017-04-27	AIA	ETF	53.73	53.73	53.55	53.6	20311.0
2017-04-27	AIQ	ETF	13.1	13.15	13.075	13.1	24133.0
2017-04-27	AIRR	ETF	24.97	25.006	24.715	24.8	25900.0
2017-04-27	AIVI	ETF	39.9	39.94	39.75	39.87	9300.0
2017-04-27	ALTY	ETF	15.749	15.808	15.749	15.805	1400.0
2017-04-27	AMJ	ETF	32.04	32.17	31.7424	31.81	1321336.0
2017-04-27	AMLP	ETF	63.15	63.45	62.75	62.75	2119720.0
2017-04-27	AMZA	ETF	106.3	106.4	105.0	105.4	67900.0
2017-04-27	ANGL	ETF	29.64	29.66	29.58	29.64	168000.0
2017-04-27	AOA	ETF	50.62	50.66	50.51	50.65	45700.0
2017-04-27	AOK	ETF	33.59	33.63	33.558	33.63	68062.0
2017-04-27	AOM	ETF	36.64	36.72	36.64	36.65	88296.0
2017-04-27	AOR	ETF	42.87	42.87	42.75	42.85	46220.0
2017-04-27	ARCM	ETF	100.0	100.0	100.0	100.0	240.0
2017-04-27	ARGT	ETF	28.82	28.82	28.51	28.63	29700.0
2017-04-27	ARKG	ETF	20.94	20.94	20.82	20.84	5400.0
2017-04-27	ARKK	ETF	25.44	25.64	25.44	25.58	33400.0
2017-04-27	ARKQ	ETF	26.39	26.56	26.39	26.48	16200.0
2017-04-27	ARKW	ETF	30.48	30.77	30.469	30.76	19200.0
2017-04-27	ASEA	ETF	14.33	14.34	14.33	14.34	1600.0
2017-04-27	ASET	ETF	26.98	27.01	26.929	26.96	2517.0
2017-04-27	ASHR	ETF	24.84	24.85	24.81	24.84	325700.0
2017-04-27	ASHS	ETF	32.41	32.42	32.36	32.37	2800.0
2017-04-27	ASHX	ETF	19.3199	19.32	19.3199	19.32	663.0
2017-04-27	ATMP	ETF	23.45	23.65	23.42	23.48	29200.0
2017-04-27	BAB	ETF	29.44	29.49	29.38	29.46	132383.0
2017-04-27	BAL	ETF	50.06	50.1447	49.54	49.54	4686.0

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

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