PREVIEW / etf_daily / 2017-02-21

all etf daily files

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

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-21	SPY	ETF	235.52	236.69	235.51	236.49	88946100.0
2017-02-21	QQQ	ETF	130.03	130.53	129.99	130.45	18479628.0
2017-02-21	IWM	ETF	139.38	140.32	139.38	140.2	21353500.0
2017-02-21	DIA	ETF	206.56	207.3	206.42	207.07	3076400.0
2017-02-21	GLD	ETF	117.04	118.0	116.77	117.75	6166900.0
2017-02-21	TLT	ETF	119.68	120.61	119.6	120.11	8703800.0
2017-02-21	AADR	ETF	45.78	46.19	45.66	46.05	8100.0
2017-02-21	AAXJ	ETF	60.92	61.13	60.81	61.06	323200.0
2017-02-21	ACSI	ETF	28.0088	28.12	28.0088	28.12	2600.0
2017-02-21	ACTX	ETF	133.6362	140.4213	119.1811	132.7512	6015.0
2017-02-21	ACWF	ETF	25.61	25.63	25.58	25.63	6900.0
2017-02-21	ACWI	ETF	62.58	62.76	62.5	62.69	2893700.0
2017-02-21	ACWV	ETF	75.55	75.95	75.55	75.81	185600.0
2017-02-21	ACWX	ETF	42.65	42.8	42.62	42.78	397425.0
2017-02-21	ADRE	ETF	36.58	36.7	36.4672	36.6808	3599.0
2017-02-21	AFK	ETF	21.63	21.93	21.53	21.63	24280.0
2017-02-21	AFTY	ETF	14.1	14.148	14.091	14.1	8500.0
2017-02-21	AGG	ETF	108.24	108.45	108.22	108.35	1980300.0
2017-02-21	AGGY	ETF	49.57	49.83	49.57	49.73	25100.0
2017-02-21	AGNG	ETF	16.56	16.56	16.56	16.56	200.0
2017-02-21	AGQ	ETF	40.14	41.04	39.93	40.53	138000.0
2017-02-21	AGZ	ETF	112.77	112.94	112.77	112.83	10410.0
2017-02-21	AGZD	ETF	24.0	24.085	24.0	24.055	4200.0
2017-02-21	AIA	ETF	51.09	51.4175	51.09	51.4	12457.0
2017-02-21	AIQ	ETF	10.3968	10.45	10.3	10.35	7143.0
2017-02-21	AIRR	ETF	24.24	24.56	24.24	24.56	101300.0
2017-02-21	AIVI	ETF	38.77	39.01	38.77	39.01	20800.0
2017-02-21	ALTY	ETF	15.41	15.62	15.41	15.594	32300.0
2017-02-21	AMJ	ETF	33.96	34.205	33.94	34.02	3073535.0
2017-02-21	AMLP	ETF	65.5	65.55	65.1	65.3	2342460.0
2017-02-21	AMZA	ETF	114.2	114.3	113.4	114.0	46600.0
2017-02-21	ANGL	ETF	29.49	29.53	29.42	29.53	646900.0
2017-02-21	AOA	ETF	49.42	49.51	49.32	49.48	74500.0
2017-02-21	AOK	ETF	33.09	33.14	33.0305	33.08	77628.0
2017-02-21	AOM	ETF	36.17	36.18	36.03	36.18	63249.0
2017-02-21	AOR	ETF	41.95	42.07	41.8965	42.07	50716.0
2017-02-21	ARGT	ETF	26.87	27.05	26.83	27.0	77600.0
2017-02-21	ARKG	ETF	19.47	19.47	19.139	19.23	4400.0
2017-02-21	ARKK	ETF	23.27	23.34	23.2	23.2	2200.0
2017-02-21	ARKQ	ETF	24.7	24.7	24.573	24.592	6500.0
2017-02-21	ARKW	ETF	28.61	28.71	28.534	28.67	10100.0
2017-02-21	ASEA	ETF	13.56	13.6	13.52	13.6	3300.0
2017-02-21	ASET	ETF	26.31	26.45	26.31	26.45	4786.0
2017-02-21	ASHR	ETF	25.26	25.44	25.26	25.44	964800.0
2017-02-21	ASHS	ETF	33.93	34.2	33.93	34.2	5700.0
2017-02-21	ATMP	ETF	24.8	24.83	24.61	24.8	18200.0
2017-02-21	BAB	ETF	29.36	29.4099	29.31	29.39	111437.0
2017-02-21	BAL	ETF	49.0	49.24	48.96	49.05	24808.0
2017-02-21	BBC	ETF	21.83	21.83	21.165	21.181	8007.0
2017-02-21	BBH	ETF	120.06	120.06	118.61	119.02	26500.0

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

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