PREVIEW / etf_daily / 2017-02-09

all etf daily files

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

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-09	SPY	ETF	229.24	230.95	229.24	230.6	65955200.0
2017-02-09	QQQ	ETF	126.63	127.24	126.56	126.96	17542726.0
2017-02-09	IWM	ETF	135.0	137.25	135.0	136.9	28267600.0
2017-02-09	DIA	ETF	200.82	202.11	200.77	201.72	3487600.0
2017-02-09	GLD	ETF	118.19	118.58	117.2	117.29	8177200.0
2017-02-09	TLT	ETF	121.41	121.59	120.66	120.83	16890600.0
2017-02-09	AADR	ETF	44.32	44.57	44.29	44.33	3400.0
2017-02-09	AAXJ	ETF	59.97	60.08	59.88	59.96	420600.0
2017-02-09	ACSI	ETF	27.37	27.52	27.3447	27.4788	6003.0
2017-02-09	ACTX	ETF	151.0414	151.6314	120.9511	128.6212	5359.0
2017-02-09	ACWF	ETF	25.3	25.5686	25.3	25.5686	970.0
2017-02-09	ACWI	ETF	61.3	61.59	61.29	61.48	1028000.0
2017-02-09	ACWV	ETF	74.69	74.82	74.6	74.76	66100.0
2017-02-09	ACWX	ETF	42.07	42.1825	42.03	42.14	513289.0
2017-02-09	ADRE	ETF	35.6158	35.66	35.515	35.515	4491.0
2017-02-09	AFK	ETF	21.32	21.95	21.32	21.45	7488.0
2017-02-09	AFTY	ETF	13.82	13.82	13.78	13.78	1300.0
2017-02-09	AGG	ETF	108.61	108.67	108.43	108.48	2736000.0
2017-02-09	AGGY	ETF	49.95	49.95	49.785	49.785	26600.0
2017-02-09	AGNG	ETF	16.11	16.11	16.11	16.11	700.0
2017-02-09	AGQ	ETF	39.99	40.0	39.01	39.22	118600.0
2017-02-09	AGZ	ETF	113.08	113.33	112.89	112.89	19058.0
2017-02-09	AGZD	ETF	23.99	24.1	23.99	24.04	6200.0
2017-02-09	AIA	ETF	50.05	50.15	50.03	50.05	11634.0
2017-02-09	AIQ	ETF	10.35	10.35	10.26	10.35	9975.0
2017-02-09	AIRR	ETF	23.91	24.14	23.855	24.11	60500.0
2017-02-09	AIVI	ETF	38.37	38.48	38.37	38.43	32200.0
2017-02-09	ALTY	ETF	15.5	15.5	15.423	15.423	400.0
2017-02-09	AMJ	ETF	33.97	34.04	33.72	33.89	1837684.0
2017-02-09	AMLP	ETF	65.15	65.3	64.9	64.9	1473120.0
2017-02-09	AMZA	ETF	113.2	113.8	113.0	113.5	45230.0
2017-02-09	ANGL	ETF	29.35	29.36	29.29	29.32	289500.0
2017-02-09	AOA	ETF	48.5	48.71	48.5	48.62	53500.0
2017-02-09	AOK	ETF	32.94	32.96	32.89	32.96	106539.0
2017-02-09	AOM	ETF	35.83	35.8417	35.7651	35.83	45497.0
2017-02-09	AOR	ETF	41.49	41.55	41.4	41.55	57054.0
2017-02-09	ARGT	ETF	26.44	26.61	26.39	26.57	88900.0
2017-02-09	ARKG	ETF	18.39	18.89	18.39	18.857	8700.0
2017-02-09	ARKK	ETF	22.82	22.925	22.82	22.925	700.0
2017-02-09	ARKQ	ETF	24.255	24.409	24.255	24.34	16900.0
2017-02-09	ARKW	ETF	27.937	28.19	27.937	28.154	14800.0
2017-02-09	ASEA	ETF	13.59	13.59	13.59	13.59	600.0
2017-02-09	ASET	ETF	26.05	26.08	26.04	26.079	1753.0
2017-02-09	ASHR	ETF	24.68	24.78	24.68	24.75	516400.0
2017-02-09	ASHS	ETF	33.69	33.69	33.56	33.56	6400.0
2017-02-09	ASHX	ETF	19.23	19.23	19.23	19.23	123.0
2017-02-09	ATMP	ETF	24.76	25.72	24.44	25.72	57800.0
2017-02-09	BAB	ETF	29.32	29.34	29.23	29.24	158785.0
2017-02-09	BAL	ETF	49.9	50.18	49.75	50.01	5336.0
2017-02-09	BBC	ETF	20.6097	20.9	20.6097	20.7999	8045.0

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

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