PREVIEW / etf_daily / 2017-05-22

all etf daily files

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

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-22	SPY	ETF	238.9	239.71	238.82	239.52	61010600.0
2017-05-22	QQQ	ETF	138.14	139.075	138.0967	139.0	19509659.0
2017-05-22	IWM	ETF	136.26	137.2	136.16	136.95	20062700.0
2017-05-22	DIA	ETF	208.32	208.87	208.32	208.65	2246200.0
2017-05-22	GLD	ETF	119.63	120.14	119.58	119.9	5132500.0
2017-05-22	TLT	ETF	123.41	123.56	123.26	123.37	4062900.0
2017-05-22	AADR	ETF	48.4	48.4	46.99	47.32	21700.0
2017-05-22	AAXJ	ETF	66.58	66.71	66.49	66.62	710300.0
2017-05-22	ACSI	ETF	28.2914	28.33	28.2914	28.33	1206.0
2017-05-22	ACTX	ETF	58.4105	60.7705	53.1005	58.4105	387.0
2017-05-22	ACWF	ETF	26.82	26.85	26.82	26.84	1248.0
2017-05-22	ACWI	ETF	65.36	65.54	65.36	65.51	1498800.0
2017-05-22	ACWV	ETF	79.07	79.35	79.04	79.28	306200.0
2017-05-22	ACWX	ETF	46.04	46.095	45.97	46.05	338782.0
2017-05-22	ADRE	ETF	38.05	38.219	38.0	38.15	6629.0
2017-05-22	AFK	ETF	21.62	21.64	21.45	21.52	16239.0
2017-05-22	AFTY	ETF	13.96	13.995	13.94	13.96	1400.0
2017-05-22	AGG	ETF	109.43	109.48	109.4	109.45	1642700.0
2017-05-22	AGGY	ETF	50.42	50.55	50.4	50.43	36400.0
2017-05-22	AGQ	ETF	35.8	36.48	35.68	36.25	209100.0
2017-05-22	AGZ	ETF	113.73	113.73	113.4901	113.66	10112.0
2017-05-22	AGZD	ETF	24.015	24.04	24.015	24.04	1200.0
2017-05-22	AIA	ETF	56.11	56.38	56.11	56.33	18506.0
2017-05-22	AIQ	ETF	13.15	13.25	13.15	13.2	18760.0
2017-05-22	AIRR	ETF	23.41	23.41	23.17	23.28	41500.0
2017-05-22	AIVI	ETF	42.0	42.11	41.96	42.05	22100.0
2017-05-22	ALTY	ETF	15.415	15.421	15.4	15.412	2300.0
2017-05-22	AMJ	ETF	31.57	31.66	31.28	31.59	2109949.0
2017-05-22	AMLP	ETF	61.6	61.65	61.1	61.45	1190080.0
2017-05-22	AMZA	ETF	105.6	105.6	103.8	104.7	53660.0
2017-05-22	ANGL	ETF	29.75	29.75	29.65	29.7	160900.0
2017-05-22	AOA	ETF	51.28	51.35	51.2	51.26	45400.0
2017-05-22	AOK	ETF	33.87	33.88	33.8	33.88	38468.0
2017-05-22	AOM	ETF	37.04	37.06	36.97	37.06	37415.0
2017-05-22	AOR	ETF	43.28	43.3542	43.2477	43.32	64603.0
2017-05-22	ARCM	ETF	100.05	100.05	100.05	100.05	200.0
2017-05-22	ARGT	ETF	30.19	30.31	30.04	30.07	256600.0
2017-05-22	ARKG	ETF	20.649	20.8	20.521	20.659	17300.0
2017-05-22	ARKK	ETF	27.13	27.36	27.1	27.35	88200.0
2017-05-22	ARKQ	ETF	28.53	28.65	28.36	28.64	110900.0
2017-05-22	ARKW	ETF	32.93	33.37	32.879	33.26	58600.0
2017-05-22	ASEA	ETF	15.09	15.09	15.0	15.0	1500.0
2017-05-22	ASET	ETF	27.21	27.2798	27.21	27.2798	439.0
2017-05-22	ASHR	ETF	24.68	24.69	24.63	24.63	354700.0
2017-05-22	ASHS	ETF	31.0	31.01	30.85	30.95	5700.0
2017-05-22	ASHX	ETF	19.11	19.1199	19.0586	19.1199	1060.0
2017-05-22	ATMP	ETF	23.1	23.25	23.05	23.2	31200.0
2017-05-22	BAB	ETF	29.8	29.86	29.75	29.84	119867.0
2017-05-22	BAL	ETF	50.19	50.232	49.94	50.025	8762.0
2017-05-22	BBC	ETF	22.43	22.43	21.7601	22.1	9673.0

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

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