PREVIEW / etf_daily / 2016-09-16

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-16.parquet
  size:    51 KB
  rows:    1,291

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-09-16	SPY	ETF	213.48	213.69	212.57	213.37	155236400.0
2016-09-16	QQQ	ETF	117.22	117.412	116.71	117.29	27596527.0
2016-09-16	IWM	ETF	122.04	122.04	121.1	121.86	31940500.0
2016-09-16	DIA	ETF	181.5	181.5	180.44	180.97	2844300.0
2016-09-16	GLD	ETF	124.81	125.25	124.67	125.06	18995100.0
2016-09-16	TLT	ETF	134.58	134.81	134.22	134.75	7507900.0
2016-09-16	AADR	ETF	39.05	39.48	39.05	39.11	1200.0
2016-09-16	AAXJ	ETF	59.28	59.35	58.81	59.22	1003700.0
2016-09-16	ACTX	ETF	5.9001	7.0801	5.31	5.9001	3054.0
2016-09-16	ACWI	ETF	57.94	57.95	57.64	57.83	1087800.0
2016-09-16	ACWV	ETF	74.93	75.07	74.71	74.97	91800.0
2016-09-16	ACWX	ETF	40.46	40.46	40.27	40.38	286987.0
2016-09-16	ADRE	ETF	34.03	34.03	33.8642	33.9535	7011.0
2016-09-16	AFK	ETF	20.11	20.11	20.11	20.11	351.0
2016-09-16	AFTY	ETF	13.525	13.57	13.52	13.57	15100.0
2016-09-16	AGG	ETF	111.75	111.87	111.7	111.8	1701000.0
2016-09-16	AGGY	ETF	51.69	51.7	51.55	51.58	4800.0
2016-09-16	AGNG	ETF	16.52	16.52	16.52	16.52	200.0
2016-09-16	AGQ	ETF	46.09	46.55	45.74	46.35	179800.0
2016-09-16	AGZ	ETF	115.3	115.3099	115.086	115.12	15294.0
2016-09-16	AIA	ETF	48.8	48.821	48.41	48.72	55059.0
2016-09-16	AIQ	ETF	6.26	6.41	6.1654	6.4	14503.0
2016-09-16	AIRR	ETF	19.286	19.41	19.25	19.41	8800.0
2016-09-16	AIVI	ETF	37.73	37.76	37.63	37.72	30200.0
2016-09-16	ALTY	ETF	15.37	15.42	15.253	15.37	4000.0
2016-09-16	AMJ	ETF	29.63	30.0	29.5225	29.95	1672604.0
2016-09-16	AMLP	ETF	60.05	60.75	59.75	60.6	1512480.0
2016-09-16	AMZA	ETF	111.2	111.8	109.95	111.6	20210.0
2016-09-16	ANGL	ETF	28.26	28.38	28.26	28.34	89300.0
2016-09-16	AOA	ETF	46.64	46.73	46.51	46.64	18900.0
2016-09-16	AOK	ETF	32.98	33.05	32.91	32.98	46952.0
2016-09-16	AOM	ETF	35.54	35.6799	35.5001	35.58	35492.0
2016-09-16	AOR	ETF	40.52	40.52	40.3783	40.45	25670.0
2016-09-16	ARGT	ETF	22.57	22.57	22.26	22.43	16600.0
2016-09-16	ARKG	ETF	19.05	19.51	19.05	19.49	2700.0
2016-09-16	ARKQ	ETF	21.22	21.22	21.14	21.14	700.0
2016-09-16	ARKW	ETF	24.55	24.6	24.55	24.6	300.0
2016-09-16	ASEA	ETF	13.81	13.81	13.81	13.81	200.0
2016-09-16	ASET	ETF	26.12	26.12	26.12	26.12	200.0
2016-09-16	ASHR	ETF	24.63	24.69	24.54	24.65	635100.0
2016-09-16	ASHS	ETF	34.52	34.57	34.43	34.52	39000.0
2016-09-16	ATMP	ETF	21.99	22.26	21.92	22.26	68400.0
2016-09-16	BAB	ETF	31.13	31.13	31.0003	31.09	135949.0
2016-09-16	BAL	ETF	44.64	44.7159	44.395	44.57	9974.0
2016-09-16	BBC	ETF	21.4	21.77	21.4	21.77	4964.0
2016-09-16	BBH	ETF	115.7	117.16	115.7	116.97	59600.0
2016-09-16	BBP	ETF	32.785	33.01	32.505	33.01	13600.0
2016-09-16	BCM	ETF	25.548	25.583	25.548	25.583	585.0
2016-09-16	BFOR	ETF	7.985	7.985	7.9425	7.97	57600.0
2016-09-16	BIB	ETF	48.27	49.539	48.03	49.33	461334.0

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

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