PREVIEW / etf_daily / 2016-09-14

all etf daily files

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

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-14	SPY	ETF	213.29	214.7	212.5	213.15	134185500.0
2016-09-14	QQQ	ETF	115.43	116.47	115.38	115.84	28221762.0
2016-09-14	IWM	ETF	120.77	121.47	120.29	120.6	30545500.0
2016-09-14	DIA	ETF	180.84	181.74	180.01	180.43	2990400.0
2016-09-14	GLD	ETF	126.1	126.54	126.03	126.18	5820700.0
2016-09-14	TLT	ETF	134.05	134.91	134.05	134.25	7037700.0
2016-09-14	AADR	ETF	39.2	39.2	39.06	39.06	500.0
2016-09-14	AAXJ	ETF	58.56	59.09	58.55	58.61	1051400.0
2016-09-14	ACTX	ETF	4.13	4.13	3.835	4.012	937.0
2016-09-14	ACWI	ETF	57.65	58.05	57.52	57.64	2454400.0
2016-09-14	ACWV	ETF	74.61	75.06	74.47	74.64	222300.0
2016-09-14	ACWX	ETF	40.46	40.69	40.38	40.46	416370.0
2016-09-14	ADRE	ETF	33.81	34.1	33.81	33.96	2213.0
2016-09-14	AFK	ETF	19.98	20.12	19.885	20.016	9615.0
2016-09-14	AFTY	ETF	13.35	13.35	13.35	13.35	600.0
2016-09-14	AGG	ETF	111.47	111.75	111.47	111.65	2089700.0
2016-09-14	AGGY	ETF	51.48	51.7	51.48	51.636	17900.0
2016-09-14	AGQ	ETF	47.35	47.87	47.1	47.32	87800.0
2016-09-14	AGZ	ETF	115.27	115.344	114.81	115.18	58773.0
2016-09-14	AIA	ETF	48.19	48.53	48.19	48.26	111975.0
2016-09-14	AIQ	ETF	6.56	6.56	6.35	6.42	10386.0
2016-09-14	AIRR	ETF	19.288	19.288	19.06	19.1	2200.0
2016-09-14	AIVI	ETF	38.09	38.2	38.03	38.11	13400.0
2016-09-14	ALTY	ETF	15.16	15.31	15.16	15.172	1200.0
2016-09-14	AMJ	ETF	29.75	30.47	29.59	29.98	3105027.0
2016-09-14	AMLP	ETF	60.35	61.65	60.35	60.7	1767880.0
2016-09-14	AMZA	ETF	110.5	113.4	110.2	111.2	10990.0
2016-09-14	ANGL	ETF	28.32	28.34	28.18	28.24	1269300.0
2016-09-14	AOA	ETF	46.48	46.74	46.48	46.56	26100.0
2016-09-14	AOK	ETF	32.85	33.02	32.85	32.92	20389.0
2016-09-14	AOM	ETF	35.57	35.6499	35.4201	35.55	59043.0
2016-09-14	AOR	ETF	40.34	40.5699	40.31	40.31	51472.0
2016-09-14	ARGT	ETF	22.19	22.49	22.19	22.26	18400.0
2016-09-14	ARKK	ETF	20.72	20.72	20.72	20.72	200.0
2016-09-14	ARKQ	ETF	20.62	20.75	20.62	20.75	400.0
2016-09-14	ARKW	ETF	24.148	24.148	24.07	24.07	1100.0
2016-09-14	ASEA	ETF	13.71	13.71	13.71	13.71	600.0
2016-09-14	ASHR	ETF	24.37	24.45	24.34	24.35	612700.0
2016-09-14	ASHS	ETF	34.27	34.37	34.27	34.31	2500.0
2016-09-14	ATMP	ETF	22.15	22.59	22.15	22.22	31900.0
2016-09-14	BAB	ETF	31.09	31.2367	31.09	31.19	88486.0
2016-09-14	BAL	ETF	44.311	44.95	44.31	44.88	11257.0
2016-09-14	BBC	ETF	20.88	21.5	20.88	21.39	10817.0
2016-09-14	BBH	ETF	114.64	116.26	114.48	114.9	44600.0
2016-09-14	BBP	ETF	31.58	32.37	31.58	32.15	6400.0
2016-09-14	BCM	ETF	25.62	25.62	25.55	25.5561	2636.0
2016-09-14	BFIT	ETF	15.6699	15.6699	15.6699	15.6699	200.0
2016-09-14	BFOR	ETF	7.9425	7.96	7.91	7.9175	25200.0
2016-09-14	BIB	ETF	46.68	48.59	46.68	47.39	654872.0
2016-09-14	BICK	ETF	22.4216	22.4399	22.4216	22.4399	401.0

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

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