PREVIEW / etf_daily / 2017-08-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-28.parquet
  size:    56 KB
  rows:    1,433

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-08-28	SPY	ETF	245.17	245.2	244.09	244.57	40565600.0
2017-08-28	QQQ	ETF	142.41	142.74	141.9501	142.41	15362141.0
2017-08-28	IWM	ETF	137.37	137.61	136.77	137.46	16333300.0
2017-08-28	DIA	ETF	218.5	218.58	217.53	217.94	1425000.0
2017-08-28	GLD	ETF	123.33	124.73	123.33	124.69	11578300.0
2017-08-28	TLT	ETF	126.92	127.39	126.73	127.24	4448500.0
2017-08-28	AADR	ETF	51.58	51.76	51.41	51.75	29300.0
2017-08-28	AAXJ	ETF	72.05	72.07	71.7	71.79	1874800.0
2017-08-28	ACSI	ETF	28.75	28.75	28.677	28.709	1817.0
2017-08-28	ACTX	ETF	76.7007	77.8807	73.7507	73.7507	378.0
2017-08-28	ACWF	ETF	28.07	28.07	27.97	27.97	2311.0
2017-08-28	ACWI	ETF	67.11	67.17	66.93	66.99	748900.0
2017-08-28	ACWV	ETF	81.03	81.03	80.73	80.84	70200.0
2017-08-28	ACWX	ETF	47.36	47.38	47.24	47.27	143165.0
2017-08-28	ADRE	ETF	42.6	42.6	42.08	42.254	7737.0
2017-08-28	AFK	ETF	23.7	23.79	23.645	23.68	5637.0
2017-08-28	AFTY	ETF	17.14	17.19	17.14	17.19	16300.0
2017-08-28	AGG	ETF	110.17	110.24	110.1	110.16	4476000.0
2017-08-28	AGGY	ETF	50.83	50.88	50.8	50.88	13700.0
2017-08-28	AGNG	ETF	18.75	18.8	18.75	18.8	300.0
2017-08-28	AGQ	ETF	35.59	36.81	35.5	36.72	225900.0
2017-08-28	AGZ	ETF	114.11	114.2004	114.1	114.2	8793.0
2017-08-28	AGZD	ETF	23.915	23.915	23.905	23.91	5400.0
2017-08-28	AIA	ETF	61.09	61.09	60.79	60.86	30685.0
2017-08-28	AIRR	ETF	23.0	23.056	22.91	23.02	23500.0
2017-08-28	AIVI	ETF	41.89	41.96	41.88	41.9	5200.0
2017-08-28	ALTY	ETF	15.85	15.85	15.51	15.58	7400.0
2017-08-28	AMJ	ETF	27.49	27.625	27.21	27.28	1963342.0
2017-08-28	AMLP	ETF	54.6	54.9	54.15	54.3	1588760.0
2017-08-28	AMZA	ETF	90.2	90.5	88.45	88.8	157000.0
2017-08-28	ANGL	ETF	29.92	29.94	29.85	29.93	242600.0
2017-08-28	AOA	ETF	52.45	52.45	52.29	52.32	31300.0
2017-08-28	AOK	ETF	34.24	34.2763	34.1868	34.27	55207.0
2017-08-28	AOM	ETF	37.59	37.6999	37.5	37.58	56211.0
2017-08-28	AOR	ETF	44.13	44.15	44.0064	44.09	62038.0
2017-08-28	ARCM	ETF	100.4	100.45	100.315	100.35	620.0
2017-08-28	ARGT	ETF	29.82	29.9	29.6	29.7	67000.0
2017-08-28	ARKG	ETF	23.25	23.987	23.25	23.964	41200.0
2017-08-28	ARKK	ETF	32.16	32.33	32.003	32.31	72700.0
2017-08-28	ARKQ	ETF	29.27	29.27	29.09	29.24	20000.0
2017-08-28	ARKW	ETF	39.34	39.34	38.97	39.13	20800.0
2017-08-28	ASEA	ETF	15.48	15.48	15.38	15.46	1100.0
2017-08-28	ASET	ETF	28.03	28.03	27.969	28.0	1141.0
2017-08-28	ASHR	ETF	29.42	29.58	29.42	29.53	1381400.0
2017-08-28	ASHS	ETF	35.54	35.54	35.38	35.47	6900.0
2017-08-28	ASHX	ETF	21.77	21.7881	21.77	21.7881	1610.0
2017-08-28	ATMP	ETF	20.9	20.92	20.6	20.63	150300.0
2017-08-28	BAB	ETF	30.48	30.58	30.48	30.56	87349.0
2017-08-28	BAL	ETF	46.02	46.1699	45.7901	46.159	21501.0
2017-08-28	BBC	ETF	25.36	26.23	25.36	26.2151	23563.0

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

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