PREVIEW / etf_daily / 2016-09-09

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-09.parquet
  size:    52 KB
  rows:    1,309

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-09	SPY	ETF	216.97	217.03	213.25	213.28	221589100.0
2016-09-09	QQQ	ETF	116.23	116.51	114.26	114.28	50813287.0
2016-09-09	IWM	ETF	124.18	124.21	121.21	121.25	54239000.0
2016-09-09	DIA	ETF	183.57	183.75	180.91	180.91	8242600.0
2016-09-09	GLD	ETF	127.24	127.51	126.7	126.75	12485600.0
2016-09-09	TLT	ETF	136.07	136.12	135.41	135.52	13347700.0
2016-09-09	AADR	ETF	40.57	40.59	39.58	39.65	14700.0
2016-09-09	AAXJ	ETF	60.26	60.26	59.34	59.34	984700.0
2016-09-09	ACTX	ETF	2.95	4.13	2.95	3.481	868.0
2016-09-09	ACWI	ETF	59.03	59.04	58.06	58.08	1894100.0
2016-09-09	ACWV	ETF	76.23	76.23	74.96	74.97	281900.0
2016-09-09	ACWX	ETF	41.55	41.55	41.0	41.01	779546.0
2016-09-09	ADRE	ETF	35.2	35.2	34.27	34.28	15558.0
2016-09-09	AFK	ETF	20.6	20.6	20.15	20.2	7158.0
2016-09-09	AFTY	ETF	13.56	13.56	13.56	13.56	100.0
2016-09-09	AGG	ETF	111.96	111.99	111.73	111.73	2763900.0
2016-09-09	AGGY	ETF	51.75	51.8	51.671	51.76	10700.0
2016-09-09	AGNG	ETF	16.49	16.49	16.34	16.34	1000.0
2016-09-09	AGQ	ETF	50.0	50.0	47.79	47.79	287600.0
2016-09-09	AGZ	ETF	115.52	115.52	115.19	115.36	12234.0
2016-09-09	AGZD	ETF	23.97	23.97	23.97	23.97	600.0
2016-09-09	AIA	ETF	49.88	49.88	49.1	49.1	59635.0
2016-09-09	AIQ	ETF	6.18	6.65	6.18	6.29	87504.0
2016-09-09	AIRR	ETF	20.02	20.02	19.55	19.55	5300.0
2016-09-09	AIVI	ETF	39.2	39.2	38.81	38.85	26900.0
2016-09-09	ALTY	ETF	15.71	15.71	15.58	15.58	9300.0
2016-09-09	AMJ	ETF	31.51	31.71	31.0	31.0	1672217.0
2016-09-09	AMLP	ETF	63.4	63.5	62.6	62.65	2542760.0
2016-09-09	AMZA	ETF	117.1	117.4	114.5	114.5	21090.0
2016-09-09	ANGL	ETF	28.68	28.68	28.41	28.43	190500.0
2016-09-09	AOA	ETF	47.46	47.46	46.75	46.75	62100.0
2016-09-09	AOK	ETF	33.33	33.33	33.04	33.07	37194.0
2016-09-09	AOM	ETF	36.03	36.03	35.62	35.73	140357.0
2016-09-09	AOR	ETF	40.99	40.99	40.6	40.6	45402.0
2016-09-09	ARGT	ETF	22.99	22.99	22.46	22.5	36000.0
2016-09-09	ARKG	ETF	18.9	18.91	18.68	18.68	1900.0
2016-09-09	ARKK	ETF	20.97	20.98	20.97	20.98	1200.0
2016-09-09	ARKQ	ETF	21.27	21.27	20.82	20.82	3800.0
2016-09-09	ARKW	ETF	24.46	24.62	24.46	24.62	800.0
2016-09-09	ASEA	ETF	13.93	13.93	13.73	13.73	2100.0
2016-09-09	ASET	ETF	26.91	26.91	26.91	26.91	100.0
2016-09-09	ASHR	ETF	24.98	25.15	24.71	24.73	1621100.0
2016-09-09	ASHS	ETF	35.19	35.19	34.9	34.91	22500.0
2016-09-09	ATMP	ETF	23.43	23.47	23.08	23.12	23800.0
2016-09-09	BAB	ETF	31.43	31.43	31.28	31.34	546211.0
2016-09-09	BAL	ETF	45.6	45.91	45.481	45.85	23065.0
2016-09-09	BBC	ETF	20.8572	20.8572	20.5001	20.5001	1783.0
2016-09-09	BBH	ETF	115.28	115.35	113.14	113.14	58400.0
2016-09-09	BBP	ETF	31.597	31.597	30.95	30.95	4200.0
2016-09-09	BCM	ETF	26.028	26.0439	26.02	26.024	1386.0

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

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