PREVIEW / etf_daily / 2017-04-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-28.parquet
  size:    54 KB
  rows:    1,378

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-04-28	SPY	ETF	238.9	238.93	237.93	238.08	63532800.0
2017-04-28	QQQ	ETF	136.28	136.34	135.77	135.99	22771946.0
2017-04-28	IWM	ETF	141.03	141.17	139.04	139.06	31113900.0
2017-04-28	DIA	ETF	209.63	209.63	208.97	209.08	1934000.0
2017-04-28	GLD	ETF	120.34	120.77	120.27	120.77	9134200.0
2017-04-28	TLT	ETF	121.6	122.44	121.55	122.35	8166300.0
2017-04-28	AADR	ETF	47.12	47.34	47.05	47.34	23000.0
2017-04-28	AAXJ	ETF	64.3	64.3	64.1	64.21	1659300.0
2017-04-28	ACSI	ETF	28.3399	28.3399	28.3399	28.3399	200.0
2017-04-28	ACTX	ETF	79.6507	79.6507	71.3906	78.4707	1365.0
2017-04-28	ACWI	ETF	64.34	64.41	64.21	64.28	1511700.0
2017-04-28	ACWV	ETF	77.98	78.05	77.86	77.97	487800.0
2017-04-28	ACWX	ETF	44.59	44.6	44.53	44.56	238372.0
2017-04-28	ADRE	ETF	36.97	36.97	36.7101	36.8421	3420.0
2017-04-28	AFK	ETF	21.54	21.5489	21.15	21.1501	2127.0
2017-04-28	AFTY	ETF	13.68	13.68	13.68	13.68	200.0
2017-04-28	AGG	ETF	108.98	109.25	108.91	109.25	5774800.0
2017-04-28	AGGY	ETF	50.06	50.179	50.05	50.156	9700.0
2017-04-28	AGNG	ETF	17.52	17.624	17.52	17.624	500.0
2017-04-28	AGQ	ETF	36.75	37.02	36.47	36.71	117500.0
2017-04-28	AGZ	ETF	113.31	113.56	113.31	113.56	15852.0
2017-04-28	AGZD	ETF	23.995	23.995	23.995	23.995	1400.0
2017-04-28	AIA	ETF	53.83	53.83	53.66	53.75	10499.0
2017-04-28	AIQ	ETF	13.15	13.2	13.1	13.1	12313.0
2017-04-28	AIRR	ETF	24.85	24.85	24.35	24.35	53800.0
2017-04-28	AIVI	ETF	39.83	39.89	39.8	39.84	15900.0
2017-04-28	ALTY	ETF	15.8	15.8	15.646	15.78	6400.0
2017-04-28	AMJ	ETF	31.87	32.09	31.82	31.85	955939.0
2017-04-28	AMLP	ETF	63.15	63.25	62.85	63.0	1763920.0
2017-04-28	AMZA	ETF	105.9	105.9	105.2	105.5	30310.0
2017-04-28	ANGL	ETF	29.69	29.7	29.6	29.69	191700.0
2017-04-28	AOA	ETF	50.65	50.65	50.51	50.59	44800.0
2017-04-28	AOK	ETF	33.57	33.63	33.54	33.63	50270.0
2017-04-28	AOM	ETF	36.68	36.7099	36.61	36.64	63587.0
2017-04-28	AOR	ETF	42.85	42.85	42.7421	42.82	72460.0
2017-04-28	ARCM	ETF	100.0	100.0	100.0	100.0	200.0
2017-04-28	ARGT	ETF	28.69	28.71	28.57	28.68	40100.0
2017-04-28	ARKG	ETF	20.8	20.8	20.435	20.49	120500.0
2017-04-28	ARKK	ETF	25.65	25.65	25.102	25.17	13900.0
2017-04-28	ARKQ	ETF	26.73	26.73	26.46	26.501	202300.0
2017-04-28	ARKW	ETF	30.67	30.67	30.23	30.3	12400.0
2017-04-28	ASEA	ETF	14.58	14.58	14.39	14.42	5600.0
2017-04-28	ASET	ETF	26.86	26.86	26.839	26.839	3230.0
2017-04-28	ASHR	ETF	24.84	24.85	24.75	24.82	750200.0
2017-04-28	ASHS	ETF	32.45	32.62	32.44	32.55	18500.0
2017-04-28	ASHX	ETF	19.2804	19.3	19.2804	19.3	283.0
2017-04-28	ATMP	ETF	23.73	23.73	23.43	23.59	65600.0
2017-04-28	BAB	ETF	29.39	29.48	29.3605	29.48	335943.0
2017-04-28	BAL	ETF	49.5	50.1765	49.5	50.1745	827.0
2017-04-28	BBC	ETF	22.67	22.8576	22.56	22.63	7198.0

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

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