PREVIEW / etf_daily / 2017-03-08

all etf daily files

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

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-03-08	SPY	ETF	237.34	237.64	236.4	236.56	78168800.0
2017-03-08	QQQ	ETF	130.57	131.15	130.46	130.74	15776027.0
2017-03-08	IWM	ETF	137.28	137.62	135.78	135.9	34115100.0
2017-03-08	DIA	ETF	209.58	209.61	208.43	208.61	3173100.0
2017-03-08	GLD	ETF	114.99	115.36	114.95	115.06	7620900.0
2017-03-08	TLT	ETF	117.31	117.95	117.23	117.78	11336300.0
2017-03-08	AADR	ETF	45.3	45.3	44.57	44.73	13300.0
2017-03-08	AAXJ	ETF	60.71	60.75	60.4	60.42	519900.0
2017-03-08	ACSI	ETF	27.84	27.87	27.784	27.784	9818.0
2017-03-08	ACTX	ETF	95.2859	100.3009	92.9848	97.3509	1112.0
2017-03-08	ACWI	ETF	62.63	62.69	62.35	62.4	1612400.0
2017-03-08	ACWV	ETF	76.06	76.06	75.81	75.88	220000.0
2017-03-08	ACWX	ETF	42.45	42.47	42.22	42.23	348860.0
2017-03-08	ADRE	ETF	35.77	35.79	35.565	35.565	1318.0
2017-03-08	AFK	ETF	20.27	20.4132	20.27	20.3062	1163.0
2017-03-08	AFTY	ETF	13.83	13.84	13.83	13.84	800.0
2017-03-08	AGG	ETF	107.39	107.5	107.34	107.47	2834700.0
2017-03-08	AGGY	ETF	49.31	49.36	49.3	49.307	9100.0
2017-03-08	AGQ	ETF	37.52	37.6	37.02	37.1	265900.0
2017-03-08	AGZ	ETF	112.2005	112.38	112.111	112.38	22972.0
2017-03-08	AGZD	ETF	24.085	24.125	24.045	24.12	7800.0
2017-03-08	AIA	ETF	50.94	50.94	50.62	50.62	11723.0
2017-03-08	AIQ	ETF	9.8	9.9	9.315	9.9	31003.0
2017-03-08	AIRR	ETF	24.1	24.205	23.72	23.75	70000.0
2017-03-08	AIVI	ETF	38.7	38.7	38.5	38.5	8300.0
2017-03-08	ALTY	ETF	15.37	15.41	15.21	15.21	31200.0
2017-03-08	AMJ	ETF	32.77	33.09	32.25	32.29	1581461.0
2017-03-08	AMLP	ETF	64.55	64.7	63.75	63.85	1630960.0
2017-03-08	AMZA	ETF	113.2	113.2	111.2	111.25	81290.0
2017-03-08	ANGL	ETF	29.2	29.2	28.95	29.0	946000.0
2017-03-08	AOA	ETF	49.35	49.37	49.18	49.2	76000.0
2017-03-08	AOK	ETF	33.01	33.01	32.9	32.9	58927.0
2017-03-08	AOM	ETF	36.0	36.081	35.92	35.95	150922.0
2017-03-08	AOR	ETF	41.91	41.915	41.7764	41.7764	37801.0
2017-03-08	ARGT	ETF	26.39	26.61	26.33	26.4	23100.0
2017-03-08	ARKG	ETF	20.27	20.45	20.22	20.302	7800.0
2017-03-08	ARKK	ETF	23.31	23.32	23.202	23.239	4300.0
2017-03-08	ARKQ	ETF	23.75	23.78	23.62	23.67	12800.0
2017-03-08	ARKW	ETF	28.35	28.35	28.16	28.16	4900.0
2017-03-08	ASET	ETF	26.14	26.14	25.8552	25.8599	1450.0
2017-03-08	ASHR	ETF	24.9	24.92	24.79	24.81	262600.0
2017-03-08	ASHS	ETF	34.27	34.27	34.05	34.08	3700.0
2017-03-08	ASHX	ETF	19.385	19.4	19.38	19.38	1200.0
2017-03-08	ATMP	ETF	24.12	24.23	23.71	23.81	41500.0
2017-03-08	BAB	ETF	28.98	29.15	28.92	29.11	690955.0
2017-03-08	BAL	ETF	50.64	50.87	50.64	50.75	13964.0
2017-03-08	BBC	ETF	22.76	23.25	22.74	22.92	30938.0
2017-03-08	BBH	ETF	119.96	121.58	119.96	120.89	50200.0
2017-03-08	BBP	ETF	37.5	38.45	37.5	37.98	5300.0
2017-03-08	BCM	ETF	27.22	27.22	26.9	26.9	2368.0

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

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