PREVIEW / etf_daily / 2016-08-23

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-23.parquet
  size:    51 KB
  rows:    1,295

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-08-23	SPY	ETF	219.25	219.6	218.9	218.97	53399200.0
2016-08-23	QQQ	ETF	117.79	118.0095	117.51	117.56	11997927.0
2016-08-23	IWM	ETF	123.61	124.46	123.61	124.08	21539400.0
2016-08-23	DIA	ETF	185.7	186.13	185.25	185.3	1647900.0
2016-08-23	GLD	ETF	128.14	128.22	127.61	127.76	9038500.0
2016-08-23	TLT	ETF	140.27	140.59	139.67	140.03	6841400.0
2016-08-23	AADR	ETF	41.19	41.29	40.69	41.0	15500.0
2016-08-23	AAXJ	ETF	59.38	59.48	58.99	58.99	529200.0
2016-08-23	ACTX	ETF	2.95	2.95	2.891	2.891	922.0
2016-08-23	ACWI	ETF	59.44	59.51	59.22	59.22	2054700.0
2016-08-23	ACWV	ETF	77.48	77.59	77.18	77.21	333400.0
2016-08-23	ACWX	ETF	41.59	41.65	41.3899	41.4	187704.0
2016-08-23	ADRE	ETF	34.37	34.4099	34.1628	34.1849	5925.0
2016-08-23	AFK	ETF	21.12	21.57	20.86	20.89	12624.0
2016-08-23	AFTY	ETF	13.651	13.651	13.64	13.65	700.0
2016-08-23	AGG	ETF	112.78	112.83	112.63	112.68	2583000.0
2016-08-23	AGGY	ETF	52.1	52.24	52.07	52.08	23300.0
2016-08-23	AGQ	ETF	47.84	47.97	47.05	47.12	209800.0
2016-08-23	AGZ	ETF	115.86	115.86	115.5699	115.64	12276.0
2016-08-23	AIA	ETF	48.78	48.949	48.55	48.55	57711.0
2016-08-23	AIQ	ETF	6.201	6.23	6.15	6.2	16402.0
2016-08-23	AIRR	ETF	19.86	19.93	19.85	19.85	22000.0
2016-08-23	AIVI	ETF	39.4	39.51	39.34	39.4	26900.0
2016-08-23	ALTY	ETF	15.79	15.82	15.724	15.82	4600.0
2016-08-23	AMJ	ETF	31.77	31.86	31.54	31.73	2419403.0
2016-08-23	AMLP	ETF	63.0	63.2	62.9	63.15	1122700.0
2016-08-23	AMZA	ETF	115.2	116.0	114.8	115.8	10260.0
2016-08-23	ANGL	ETF	28.74	28.78	28.72	28.76	98900.0
2016-08-23	AOA	ETF	47.59	47.76	47.53	47.58	28900.0
2016-08-23	AOK	ETF	33.442	33.5699	33.4001	33.41	55960.0
2016-08-23	AOM	ETF	36.15	36.17	36.0219	36.07	42977.0
2016-08-23	AOR	ETF	41.27	41.27	41.09	41.09	68977.0
2016-08-23	ARGT	ETF	23.0	23.14	22.88	22.93	17100.0
2016-08-23	ARKG	ETF	19.22	19.22	19.13	19.13	900.0
2016-08-23	ARKK	ETF	21.35	21.35	21.268	21.268	2300.0
2016-08-23	ARKQ	ETF	21.47	21.67	21.47	21.67	1100.0
2016-08-23	ARKW	ETF	24.66	24.82	24.66	24.73	4500.0
2016-08-23	ASEA	ETF	14.19	14.19	14.15	14.15	700.0
2016-08-23	ASHR	ETF	25.5	25.53	25.37	25.37	410400.0
2016-08-23	ASHS	ETF	35.3	35.42	35.3	35.39	5100.0
2016-08-23	ASHX	ETF	23.15	23.15	23.15	23.15	355.0
2016-08-23	ATMP	ETF	23.18	23.21	22.97	23.18	176600.0
2016-08-23	BAB	ETF	31.74	31.769	31.695	31.74	95854.0
2016-08-23	BAL	ETF	45.452	45.7	45.45	45.4503	6266.0
2016-08-23	BBC	ETF	21.13	21.2	20.93	21.1301	5374.0
2016-08-23	BBH	ETF	118.84	119.41	118.56	118.69	53100.0
2016-08-23	BBP	ETF	31.72	31.72	31.53	31.576	11300.0
2016-08-23	BCM	ETF	26.53	26.8	26.53	26.78	5914.0
2016-08-23	BFOR	ETF	8.085	8.15	8.085	8.1375	58000.0
2016-08-23	BIB	ETF	51.47	51.76	50.91	51.13	459180.0

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

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