PREVIEW / etf_daily / 2017-02-23

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-23.parquet
  size:    54 KB
  rows:    1,376

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
2017-02-23	SPY	ETF	236.88	236.9	235.56	236.44	74615900.0
2017-02-23	QQQ	ETF	130.7	130.7	129.49	130.01	17489023.0
2017-02-23	IWM	ETF	139.96	140.01	137.69	138.75	24596200.0
2017-02-23	DIA	ETF	208.06	208.15	207.21	207.82	3179900.0
2017-02-23	GLD	ETF	118.76	119.16	118.68	118.94	7523300.0
2017-02-23	TLT	ETF	120.57	120.74	120.33	120.67	5330800.0
2017-02-23	AADR	ETF	46.44	46.67	45.57	45.82	12500.0
2017-02-23	AAXJ	ETF	61.45	61.57	61.32	61.39	512700.0
2017-02-23	ACSI	ETF	28.04	28.0525	28.01	28.01	3065.0
2017-02-23	ACTX	ETF	123.3111	123.3111	94.4008	94.4008	7191.0
2017-02-23	ACWF	ETF	25.68	25.7195	25.59	25.64	13612.0
2017-02-23	ACWI	ETF	62.93	62.93	62.6	62.74	3967300.0
2017-02-23	ACWV	ETF	76.18	76.45	76.15	76.35	111400.0
2017-02-23	ACWX	ETF	43.01	43.02	42.8199	42.87	641205.0
2017-02-23	ADRE	ETF	37.04	37.0599	36.46	36.62	15987.0
2017-02-23	AFK	ETF	21.73	21.89	21.47	21.89	6083.0
2017-02-23	AFTY	ETF	14.02	14.135	14.02	14.09	2800.0
2017-02-23	AGG	ETF	108.56	108.65	108.53	108.6	2169000.0
2017-02-23	AGGY	ETF	49.81	49.87	49.787	49.87	4400.0
2017-02-23	AGQ	ETF	41.48	41.65	40.95	41.46	150500.0
2017-02-23	AGZ	ETF	112.89	113.09	112.89	113.0308	10270.0
2017-02-23	AGZD	ETF	24.11	24.11	23.955	23.955	10400.0
2017-02-23	AIA	ETF	51.82	51.82	51.55	51.55	135447.0
2017-02-23	AIQ	ETF	10.35	10.4502	10.3	10.35	15553.0
2017-02-23	AIRR	ETF	24.5	24.512	23.739	23.86	74400.0
2017-02-23	AIVI	ETF	39.14	39.17	39.01	39.06	25500.0
2017-02-23	ALTY	ETF	15.625	15.65	15.51	15.57	36700.0
2017-02-23	AMJ	ETF	33.9	33.9	33.22	33.44	3951606.0
2017-02-23	AMLP	ETF	65.2	65.3	64.25	64.6	2713080.0
2017-02-23	AMZA	ETF	113.7	113.8	111.7	112.2	37170.0
2017-02-23	ANGL	ETF	29.62	29.62	29.53	29.59	239400.0
2017-02-23	AOA	ETF	49.61	49.61	49.38	49.51	105200.0
2017-02-23	AOK	ETF	33.22	33.22	33.1316	33.21	30456.0
2017-02-23	AOM	ETF	36.16	36.22	36.13	36.19	125374.0
2017-02-23	AOR	ETF	42.08	42.14	41.984	42.06	120540.0
2017-02-23	ARGT	ETF	27.09	27.09	26.54	26.59	72100.0
2017-02-23	ARKG	ETF	19.06	19.06	18.9	18.9	600.0
2017-02-23	ARKK	ETF	23.31	23.43	22.88	22.97	5300.0
2017-02-23	ARKQ	ETF	24.6	24.6	24.07	24.09	12600.0
2017-02-23	ARKW	ETF	28.98	28.98	28.41	28.52	8800.0
2017-02-23	ASEA	ETF	13.7	13.7	13.68	13.7	3100.0
2017-02-23	ASET	ETF	26.375	26.41	26.375	26.41	1017.0
2017-02-23	ASHR	ETF	25.43	25.43	25.37	25.4	349500.0
2017-02-23	ASHS	ETF	34.14	34.37	34.09	34.31	14700.0
2017-02-23	ATMP	ETF	24.65	24.67	24.18	24.33	25300.0
2017-02-23	BAB	ETF	29.4	29.44	29.3	29.32	280404.0
2017-02-23	BAL	ETF	49.3	49.508	49.3	49.3601	4504.0
2017-02-23	BBC	ETF	20.69	20.72	20.395	20.55	6821.0
2017-02-23	BBH	ETF	118.69	118.69	117.31	118.17	26500.0
2017-02-23	BBP	ETF	37.4	37.4	36.52	36.723	14300.0

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

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