PREVIEW / etf_daily / 2017-05-02

all etf daily files

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

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-05-02	SPY	ETF	238.84	238.98	238.3	238.77	57375700.0
2017-05-02	QQQ	ETF	137.38	137.49	137.02	137.43	18345071.0
2017-05-02	IWM	ETF	139.98	140.34	138.69	139.15	17993900.0
2017-05-02	DIA	ETF	209.1	209.3	208.75	209.13	1359700.0
2017-05-02	GLD	ETF	119.3	119.65	119.24	119.65	4900800.0
2017-05-02	TLT	ETF	120.97	121.78	120.94	121.7	6727800.0
2017-05-02	AADR	ETF	47.48	47.84	47.43	47.84	17200.0
2017-05-02	AAXJ	ETF	64.72	64.94	64.69	64.84	590700.0
2017-05-02	ACSI	ETF	28.4	28.45	28.38	28.45	1482.0
2017-05-02	ACTX	ETF	79.6507	85.5508	76.1107	83.1908	1153.0
2017-05-02	ACWF	ETF	26.43	26.43	26.43	26.43	200.0
2017-05-02	ACWI	ETF	64.6	64.65	64.47	64.64	3350200.0
2017-05-02	ACWV	ETF	78.06	78.08	77.9	78.03	117800.0
2017-05-02	ACWX	ETF	44.86	44.97	44.82	44.94	502232.0
2017-05-02	ADRE	ETF	37.23	37.442	37.23	37.442	6959.0
2017-05-02	AFK	ETF	21.33	21.51	21.18	21.3995	9133.0
2017-05-02	AFTY	ETF	13.67	13.67	13.67	13.67	1100.0
2017-05-02	AGG	ETF	108.68	108.94	108.68	108.88	2841400.0
2017-05-02	AGGY	ETF	50.07	50.19	50.04	50.19	21000.0
2017-05-02	AGNG	ETF	17.92	17.92	17.7	17.72	3300.0
2017-05-02	AGQ	ETF	35.2	35.23	34.84	35.04	115200.0
2017-05-02	AGZ	ETF	113.19	113.42	113.19	113.4	16579.0
2017-05-02	AGZD	ETF	23.96	23.975	23.96	23.975	1000.0
2017-05-02	AIA	ETF	54.38	54.5	54.3	54.49	10502.0
2017-05-02	AIQ	ETF	13.15	13.2	13.1	13.1	5618.0
2017-05-02	AIRR	ETF	24.59	24.59	24.351	24.44	37000.0
2017-05-02	AIVI	ETF	40.08	40.26	40.08	40.26	34400.0
2017-05-02	ALTY	ETF	15.69	15.72	15.69	15.7	3800.0
2017-05-02	AMJ	ETF	32.01	32.08	31.72	31.77	2913473.0
2017-05-02	AMLP	ETF	63.2	63.25	62.85	62.9	2352800.0
2017-05-02	AMZA	ETF	105.5	105.9	104.6	105.0	46480.0
2017-05-02	ANGL	ETF	29.59	29.6	29.54	29.59	871800.0
2017-05-02	AOA	ETF	50.71	50.81	50.69	50.77	48400.0
2017-05-02	AOK	ETF	33.58	33.645	33.55	33.62	126893.0
2017-05-02	AOM	ETF	36.75	36.8	36.7005	36.8	65864.0
2017-05-02	AOR	ETF	42.88	42.95	42.8401	42.93	72107.0
2017-05-02	ARCM	ETF	100.05	100.05	100.05	100.05	4000.0
2017-05-02	ARGT	ETF	28.92	29.1	28.75	29.08	22100.0
2017-05-02	ARKG	ETF	20.72	20.72	20.449	20.53	5100.0
2017-05-02	ARKK	ETF	25.75	25.75	25.57	25.68	21700.0
2017-05-02	ARKQ	ETF	26.85	26.85	26.637	26.73	29000.0
2017-05-02	ARKW	ETF	31.05	31.05	30.732	30.86	33900.0
2017-05-02	ASEA	ETF	14.47	14.6	14.47	14.6	7000.0
2017-05-02	ASET	ETF	26.9098	26.9506	26.9098	26.9506	610.0
2017-05-02	ASHR	ETF	24.75	24.8	24.72	24.73	249900.0
2017-05-02	ASHS	ETF	32.51	32.59	32.51	32.55	2300.0
2017-05-02	ATMP	ETF	23.59	23.61	23.41	23.48	91700.0
2017-05-02	BAB	ETF	29.4	29.5	29.35	29.5	72808.0
2017-05-02	BAL	ETF	50.23	50.54	50.12	50.401	1265.0
2017-05-02	BBC	ETF	22.41	22.4392	22.17	22.23	1771.0

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

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