PREVIEW / etf_daily / 2017-02-08

all etf daily files

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

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-08	SPY	ETF	228.94	229.39	228.31	229.24	51566200.0
2017-02-08	QQQ	ETF	126.12	126.68	125.88	126.5	12569147.0
2017-02-08	IWM	ETF	135.24	135.24	133.89	135.0	32956900.0
2017-02-08	DIA	ETF	200.5	200.69	200.15	200.51	2291500.0
2017-02-08	GLD	ETF	118.09	118.59	117.81	118.19	9633400.0
2017-02-08	TLT	ETF	121.42	122.27	121.41	122.24	15734200.0
2017-02-08	AADR	ETF	43.94	44.37	43.94	44.37	4500.0
2017-02-08	AAXJ	ETF	59.54	59.83	59.44	59.74	770100.0
2017-02-08	ACSI	ETF	27.08	27.22	27.08	27.22	5326.0
2017-02-08	ACTX	ETF	142.7813	164.6115	134.3442	152.8114	4857.0
2017-02-08	ACWI	ETF	61.01	61.25	60.94	61.23	1950600.0
2017-02-08	ACWV	ETF	74.21	74.59	74.21	74.53	81700.0
2017-02-08	ACWX	ETF	41.79	42.0	41.76	41.99	402905.0
2017-02-08	ADRE	ETF	35.2273	35.5	35.2273	35.4655	3686.0
2017-02-08	AFK	ETF	21.27	21.3978	21.25	21.26	2086.0
2017-02-08	AFTY	ETF	13.73	13.76	13.725	13.76	1000.0
2017-02-08	AGG	ETF	108.61	108.83	108.61	108.74	3873200.0
2017-02-08	AGGY	ETF	50.0	50.0	49.87	49.99	3600.0
2017-02-08	AGNG	ETF	16.06	16.06	16.06	16.06	100.0
2017-02-08	AGQ	ETF	39.86	40.13	39.26	39.67	147600.0
2017-02-08	AGZ	ETF	113.16	113.37	113.01	113.1	8891.0
2017-02-08	AGZD	ETF	24.06	24.065	24.025	24.05	4000.0
2017-02-08	AIA	ETF	49.91	49.97	49.7801	49.94	22437.0
2017-02-08	AIQ	ETF	10.35	10.35	10.245	10.25	25316.0
2017-02-08	AIRR	ETF	24.1	24.1	23.66	23.77	91900.0
2017-02-08	AIVI	ETF	38.1	38.29	38.1	38.29	10700.0
2017-02-08	ALTY	ETF	15.25	15.414	15.245	15.327	1300.0
2017-02-08	AMJ	ETF	33.6	33.8099	33.292	33.72	1525853.0
2017-02-08	AMLP	ETF	64.95	65.1	64.35	64.9	2354240.0
2017-02-08	AMZA	ETF	112.8	112.9	111.43	112.6	19390.0
2017-02-08	ANGL	ETF	29.34	29.38	29.29	29.34	424100.0
2017-02-08	AOA	ETF	48.38	48.5	48.32	48.46	46000.0
2017-02-08	AOK	ETF	32.89	32.96	32.86	32.96	80018.0
2017-02-08	AOM	ETF	35.74	35.84	35.7092	35.84	86176.0
2017-02-08	AOR	ETF	41.36	41.42	41.2801	41.42	41923.0
2017-02-08	ARGT	ETF	26.32	26.32	26.02	26.25	51100.0
2017-02-08	ARKG	ETF	18.39	18.46	18.25	18.447	1600.0
2017-02-08	ARKK	ETF	22.45	22.49	22.45	22.49	400.0
2017-02-08	ARKQ	ETF	23.67	23.85	23.67	23.85	9100.0
2017-02-08	ARKW	ETF	27.808	27.892	27.767	27.892	5100.0
2017-02-08	ASEA	ETF	13.71	13.71	13.65	13.71	600.0
2017-02-08	ASHR	ETF	24.59	24.68	24.57	24.68	553900.0
2017-02-08	ASHS	ETF	33.42	33.48	33.42	33.48	1300.0
2017-02-08	ATMP	ETF	24.53	24.63	24.24	24.52	106000.0
2017-02-08	BAB	ETF	29.35	29.45	29.305	29.42	408406.0
2017-02-08	BAL	ETF	49.64	49.9301	49.64	49.7	10040.0
2017-02-08	BBC	ETF	20.08	20.38	20.08	20.3312	8698.0
2017-02-08	BBH	ETF	114.63	116.23	114.4	115.99	27400.0
2017-02-08	BBP	ETF	36.0	36.744	36.0	36.62	10100.0
2017-02-08	BCM	ETF	27.8	27.81	27.789	27.795	7102.0

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

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