PREVIEW / etf_daily / 2017-02-06

all etf daily files

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

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-06	SPY	ETF	228.87	229.33	228.54	228.93	57790100.0
2017-02-06	QQQ	ETF	125.42	125.85	125.35	125.83	11630139.0
2017-02-06	IWM	ETF	136.4	136.78	135.43	135.84	23691500.0
2017-02-06	DIA	ETF	200.03	200.7	199.78	200.28	2770900.0
2017-02-06	GLD	ETF	117.07	117.74	116.74	117.7	8547800.0
2017-02-06	TLT	ETF	119.76	120.13	119.12	119.72	8433800.0
2017-02-06	AADR	ETF	45.38	45.38	44.15	44.62	7400.0
2017-02-06	AAXJ	ETF	59.51	59.63	59.46	59.54	467100.0
2017-02-06	ACSI	ETF	27.17	27.17	27.0699	27.07	4362.0
2017-02-06	ACTX	ETF	172.5766	194.7018	161.0714	180.5416	13195.0
2017-02-06	ACWI	ETF	61.08	61.15	60.98	61.12	1144100.0
2017-02-06	ACWV	ETF	74.27	74.27	74.1	74.18	364400.0
2017-02-06	ACWX	ETF	41.86	41.93	41.8	41.91	508192.0
2017-02-06	ADRE	ETF	35.2471	35.41	35.174	35.205	4809.0
2017-02-06	AFK	ETF	21.55	21.69	21.12	21.285	30932.0
2017-02-06	AFTY	ETF	13.8	13.825	13.8	13.802	4200.0
2017-02-06	AGG	ETF	108.22	108.38	108.1	108.32	1827000.0
2017-02-06	AGGY	ETF	49.65	49.809	49.6	49.68	106200.0
2017-02-06	AGQ	ETF	39.11	39.64	38.87	39.6	147000.0
2017-02-06	AGZ	ETF	112.81	113.08	112.76	112.97	304126.0
2017-02-06	AGZD	ETF	24.085	24.085	23.98	23.98	8800.0
2017-02-06	AIA	ETF	49.97	50.05	49.96	50.02	22320.0
2017-02-06	AIQ	ETF	10.2	10.4	10.2	10.25	15809.0
2017-02-06	AIRR	ETF	24.48	24.48	24.05	24.09	129800.0
2017-02-06	AIVI	ETF	38.17	38.19	38.05	38.18	27700.0
2017-02-06	ALTY	ETF	15.39	15.405	15.35	15.405	2400.0
2017-02-06	AMJ	ETF	34.03	34.1	33.82	34.02	1297037.0
2017-02-06	AMLP	ETF	66.45	66.55	66.15	66.45	1831180.0
2017-02-06	AMZA	ETF	114.4	114.4	112.99	113.5	36490.0
2017-02-06	ANGL	ETF	29.36	29.39	29.3	29.35	266700.0
2017-02-06	AOA	ETF	48.38	48.44	48.3	48.4	46100.0
2017-02-06	AOK	ETF	32.85	32.85	32.7501	32.83	46400.0
2017-02-06	AOM	ETF	35.72	35.72	35.6301	35.69	54079.0
2017-02-06	AOR	ETF	41.3	41.3199	41.2595	41.31	83219.0
2017-02-06	ARGT	ETF	26.62	26.62	26.28	26.51	78900.0
2017-02-06	ARKG	ETF	18.4	18.4	18.282	18.34	6000.0
2017-02-06	ARKK	ETF	22.4	22.4	22.33	22.39	5500.0
2017-02-06	ARKQ	ETF	23.65	23.72	23.65	23.69	3100.0
2017-02-06	ARKW	ETF	27.67	27.67	27.534	27.592	1800.0
2017-02-06	ASEA	ETF	13.8	13.8	13.71	13.75	17200.0
2017-02-06	ASET	ETF	25.82	25.83	25.7783	25.83	5628.0
2017-02-06	ASHR	ETF	24.77	24.86	24.7	24.74	295200.0
2017-02-06	ASHS	ETF	33.54	33.54	33.47	33.48	7900.0
2017-02-06	ASHX	ETF	18.99	19.24	18.99	19.235	1681.0
2017-02-06	ATMP	ETF	24.85	24.85	24.64	24.81	194700.0
2017-02-06	BAB	ETF	29.09	29.18	29.075	29.14	127195.0
2017-02-06	BAL	ETF	50.19	50.4	49.93	49.9509	5691.0
2017-02-06	BBC	ETF	20.39	20.495	19.951	20.48	2774.0
2017-02-06	BBH	ETF	115.8	116.35	115.14	116.31	42900.0
2017-02-06	BBP	ETF	36.45	36.63	36.256	36.63	9100.0

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

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