PREVIEW / etf_daily / 2016-10-27

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-27.parquet
  size:    52 KB
  rows:    1,311

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-10-27	SPY	ETF	214.58	214.62	213.08	213.17	77220200.0
2016-10-27	QQQ	ETF	118.9	118.99	117.67	117.84	19099790.0
2016-10-27	IWM	ETF	120.12	120.14	118.09	118.36	29525700.0
2016-10-27	DIA	ETF	182.3	182.35	181.23	181.53	2027100.0
2016-10-27	GLD	ETF	121.11	121.18	120.75	121.01	4336000.0
2016-10-27	TLT	ETF	131.07	131.07	130.06	130.74	10044700.0
2016-10-27	AADR	ETF	41.82	41.84	41.71	41.84	1800.0
2016-10-27	AAXJ	ETF	59.51	59.56	59.08	59.12	1381300.0
2016-10-27	ACTX	ETF	12.3901	14.1601	10.0301	10.0301	1751.0
2016-10-27	ACWF	ETF	23.86	23.87	23.86	23.87	337.0
2016-10-27	ACWI	ETF	58.42	58.46	58.11	58.14	798200.0
2016-10-27	ACWV	ETF	73.95	73.95	73.47	73.47	113100.0
2016-10-27	ACWX	ETF	40.92	40.92	40.72	40.73	565002.0
2016-10-27	ADRE	ETF	35.79	35.79	35.3801	35.49	2409.0
2016-10-27	AFK	ETF	20.6412	20.8699	20.6	20.635	914.0
2016-10-27	AFTY	ETF	13.545	13.545	13.545	13.545	800.0
2016-10-27	AGG	ETF	111.28	111.28	111.04	111.16	2330700.0
2016-10-27	AGGY	ETF	51.4	51.4	51.263	51.33	9000.0
2016-10-27	AGNG	ETF	15.305	15.305	15.305	15.305	200.0
2016-10-27	AGQ	ETF	40.45	40.5	40.1	40.35	75900.0
2016-10-27	AGZ	ETF	115.01	115.01	114.65	114.78	15337.0
2016-10-27	AGZD	ETF	23.955	23.98	23.955	23.98	1000.0
2016-10-27	AIA	ETF	49.45	49.45	48.99	48.99	27465.0
2016-10-27	AIQ	ETF	9.2	9.2	8.85	8.95	14995.0
2016-10-27	AIRR	ETF	19.41	19.43	19.24	19.26	10200.0
2016-10-27	AIVI	ETF	37.73	37.76	37.66	37.68	13300.0
2016-10-27	ALTY	ETF	15.12	15.12	15.011	15.083	2900.0
2016-10-27	AMJ	ETF	31.01	31.18	30.74	30.76	1275805.0
2016-10-27	AMLP	ETF	62.75	63.05	62.4	62.4	1139840.0
2016-10-27	AMZA	ETF	108.6	109.56	107.7	108.1	32630.0
2016-10-27	ANGL	ETF	29.25	29.25	29.0	29.0	115200.0
2016-10-27	AOA	ETF	46.94	46.94	46.57	46.59	67000.0
2016-10-27	AOK	ETF	33.05	33.05	32.8178	32.87	40075.0
2016-10-27	AOM	ETF	35.56	35.56	35.36	35.43	57549.0
2016-10-27	AOR	ETF	40.7	40.7	40.31	40.31	67125.0
2016-10-27	ARGT	ETF	24.18	24.19	23.94	23.94	52400.0
2016-10-27	ARKG	ETF	17.225	17.225	17.0	17.0	1500.0
2016-10-27	ARKK	ETF	20.315	20.315	20.166	20.166	300.0
2016-10-27	ARKQ	ETF	21.3	21.3	21.0	21.0	700.0
2016-10-27	ARKW	ETF	24.94	24.94	24.8	24.8	1400.0
2016-10-27	ASEA	ETF	13.62	13.66	13.57	13.57	900.0
2016-10-27	ASHR	ETF	24.77	24.78	24.67	24.67	321100.0
2016-10-27	ASHS	ETF	35.0	35.1	34.86	34.99	10500.0
2016-10-27	ASHX	ETF	23.3	23.3	22.98	23.0	2343.0
2016-10-27	ATMP	ETF	22.94	23.06	22.72	22.72	12600.0
2016-10-27	BAB	ETF	30.76	30.76	30.6	30.72	300310.0
2016-10-27	BAL	ETF	45.85	46.35	45.8	46.2108	6400.0
2016-10-27	BBC	ETF	19.41	19.46	18.81	18.8166	9126.0
2016-10-27	BBH	ETF	106.86	107.88	106.28	106.39	93100.0
2016-10-27	BBP	ETF	29.94	29.94	29.295	29.295	3800.0

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

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