PREVIEW / etf_daily / 2017-05-23

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-23.parquet
  size:    55 KB
  rows:    1,394

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-23	SPY	ETF	239.95	240.24	239.51	240.05	48341700.0
2017-05-23	QQQ	ETF	139.42	139.42	138.7801	139.14	19687534.0
2017-05-23	IWM	ETF	137.29	137.69	136.35	137.4	16681400.0
2017-05-23	DIA	ETF	209.1	209.35	208.69	209.12	3457500.0
2017-05-23	GLD	ETF	120.13	120.19	118.98	119.14	8305400.0
2017-05-23	TLT	ETF	123.51	123.62	122.48	122.54	7901300.0
2017-05-23	AADR	ETF	47.3	47.49	47.06	47.49	30700.0
2017-05-23	AAXJ	ETF	66.5	66.51	66.28	66.29	727300.0
2017-05-23	ACSI	ETF	28.38	28.42	28.35	28.42	2205.0
2017-05-23	ACTX	ETF	56.6405	58.4105	47.2004	54.2805	482.0
2017-05-23	ACWF	ETF	26.8399	26.8399	26.8399	26.8399	610.0
2017-05-23	ACWI	ETF	65.53	65.63	65.48	65.54	1682500.0
2017-05-23	ACWV	ETF	79.3	79.39	79.17	79.23	254100.0
2017-05-23	ACWX	ETF	46.12	46.135	45.9634	46.0	309977.0
2017-05-23	ADRE	ETF	38.14	38.26	38.01	38.1187	8788.0
2017-05-23	AFK	ETF	21.63	21.7	21.58	21.62	11855.0
2017-05-23	AFTY	ETF	14.16	14.199	14.14	14.14	4300.0
2017-05-23	AGG	ETF	109.5	109.53	109.21	109.24	1334500.0
2017-05-23	AGGY	ETF	50.48	50.48	50.23	50.28	36200.0
2017-05-23	AGNG	ETF	17.817	17.817	17.817	17.817	600.0
2017-05-23	AGQ	ETF	36.77	36.9	35.78	35.96	199500.0
2017-05-23	AGZ	ETF	113.56	113.68	113.48	113.545	7888.0
2017-05-23	AGZD	ETF	24.0	24.0	24.0	24.0	400.0
2017-05-23	AIA	ETF	56.22	56.22	56.0908	56.18	20712.0
2017-05-23	AIQ	ETF	13.2	13.25	13.15	13.25	9088.0
2017-05-23	AIRR	ETF	23.31	23.49	23.13	23.42	18900.0
2017-05-23	AIVI	ETF	42.18	42.24	42.08	42.11	6400.0
2017-05-23	ALTY	ETF	15.5	15.5	15.455	15.455	4700.0
2017-05-23	AMJ	ETF	31.64	31.81	31.52	31.78	3125379.0
2017-05-23	AMLP	ETF	61.6	61.75	61.35	61.75	1282400.0
2017-05-23	AMZA	ETF	104.8	105.4	104.4	105.1	36800.0
2017-05-23	ANGL	ETF	29.73	29.8	29.7	29.73	811300.0
2017-05-23	AOA	ETF	51.43	51.45	51.3	51.3	51500.0
2017-05-23	AOK	ETF	33.89	33.91	33.7601	33.78	52399.0
2017-05-23	AOM	ETF	37.1	37.1	36.98	36.99	166737.0
2017-05-23	AOR	ETF	43.4	43.409	43.2804	43.33	63313.0
2017-05-23	ARCM	ETF	100.05	100.05	100.05	100.05	200.0
2017-05-23	ARGT	ETF	30.03	30.25	30.03	30.11	79800.0
2017-05-23	ARKG	ETF	20.86	20.86	20.7	20.81	3000.0
2017-05-23	ARKK	ETF	27.53	27.53	27.187	27.44	36900.0
2017-05-23	ARKQ	ETF	28.79	28.81	28.31	28.39	93600.0
2017-05-23	ARKW	ETF	33.47	33.52	33.149	33.51	20700.0
2017-05-23	ASEA	ETF	15.21	15.21	15.13	15.13	700.0
2017-05-23	ASET	ETF	27.2876	27.3532	27.2876	27.3	2684.0
2017-05-23	ASHR	ETF	24.71	24.8	24.69	24.76	611400.0
2017-05-23	ASHS	ETF	30.31	30.36	30.24	30.31	14100.0
2017-05-23	ASHX	ETF	19.151	19.151	19.151	19.151	317.0
2017-05-23	ATMP	ETF	23.25	23.33	23.2	23.29	127300.0
2017-05-23	BAB	ETF	29.87	29.87	29.77	29.8	218727.0
2017-05-23	BAL	ETF	49.44	49.66	49.03	49.03	9839.0

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

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