PREVIEW / etf_daily / 2017-08-25

all etf daily files

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

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-25	SPY	ETF	244.9	245.61	244.39	244.56	64445900.0
2017-08-25	QQQ	ETF	142.8	143.18	141.78	141.97	26380436.0
2017-08-25	IWM	ETF	136.88	137.31	136.42	136.88	17163000.0
2017-08-25	DIA	ETF	218.26	218.93	218.0	218.04	2373300.0
2017-08-25	GLD	ETF	122.77	123.02	121.29	122.74	12398200.0
2017-08-25	TLT	ETF	127.02	127.45	126.87	127.32	7303300.0
2017-08-25	AADR	ETF	52.4	52.4	51.52	51.58	13700.0
2017-08-25	AAXJ	ETF	72.22	72.31	72.0	72.08	2213900.0
2017-08-25	ACSI	ETF	28.82	28.82	28.75	28.78	11395.0
2017-08-25	ACTX	ETF	73.7507	78.4707	73.7507	76.7007	436.0
2017-08-25	ACWF	ETF	28.08	28.08	27.95	27.95	2308.0
2017-08-25	ACWI	ETF	67.01	67.25	67.0	67.05	989200.0
2017-08-25	ACWV	ETF	80.77	81.0	80.77	80.86	44700.0
2017-08-25	ACWX	ETF	47.24	47.425	47.23	47.33	334885.0
2017-08-25	ADRE	ETF	42.75	42.7682	42.52	42.5784	6764.0
2017-08-25	AFK	ETF	23.61	23.794	23.0345	23.5906	11553.0
2017-08-25	AFTY	ETF	16.85	16.95	16.85	16.94	2600.0
2017-08-25	AGG	ETF	110.05	110.19	110.01	110.12	2326800.0
2017-08-25	AGGY	ETF	50.79	50.86	50.79	50.84	7700.0
2017-08-25	AGNG	ETF	18.68	18.71	18.639	18.65	3100.0
2017-08-25	AGQ	ETF	35.44	35.46	33.71	34.99	134100.0
2017-08-25	AGZ	ETF	114.2	114.25	114.15	114.22	11460.0
2017-08-25	AGZD	ETF	23.905	23.915	23.905	23.915	1400.0
2017-08-25	AIA	ETF	61.38	61.44	61.16	61.21	38211.0
2017-08-25	AIRR	ETF	22.71	22.904	22.69	22.83	41500.0
2017-08-25	AIVI	ETF	41.81	41.97	41.72	41.88	6400.0
2017-08-25	ALTY	ETF	15.81	15.81	15.57	15.58	13900.0
2017-08-25	AMJ	ETF	27.42	27.6399	27.42	27.49	1384444.0
2017-08-25	AMLP	ETF	54.45	55.0	54.35	54.55	1995420.0
2017-08-25	AMZA	ETF	89.1	90.2	89.1	89.8	68620.0
2017-08-25	ANGL	ETF	29.9	29.93	29.82	29.91	381300.0
2017-08-25	AOA	ETF	52.35	52.47	52.33	52.36	155500.0
2017-08-25	AOK	ETF	34.25	34.28	34.2001	34.2205	98351.0
2017-08-25	AOM	ETF	37.57	37.599	37.4669	37.56	73712.0
2017-08-25	AOR	ETF	44.07	44.12	44.01	44.06	64004.0
2017-08-25	ARGT	ETF	29.75	29.83	29.65	29.76	25200.0
2017-08-25	ARKG	ETF	22.98	23.17	22.64	22.75	12700.0
2017-08-25	ARKK	ETF	32.09	32.09	31.635	31.657	46700.0
2017-08-25	ARKQ	ETF	29.45	29.45	29.205	29.225	15500.0
2017-08-25	ARKW	ETF	39.51	39.65	39.132	39.17	101900.0
2017-08-25	ASEA	ETF	15.39	15.41	15.36	15.39	1900.0
2017-08-25	ASET	ETF	28.075	28.075	28.04	28.05	1053.0
2017-08-25	ASHR	ETF	28.94	29.11	28.87	29.05	1157600.0
2017-08-25	ASHS	ETF	35.0	35.0	34.83	34.88	3900.0
2017-08-25	ASHX	ETF	21.5664	21.5676	21.56	21.5676	1000.0
2017-08-25	ATMP	ETF	20.75	20.91	20.75	20.83	21100.0
2017-08-25	BAB	ETF	30.48	30.5699	30.431	30.54	59700.0
2017-08-25	BAL	ETF	45.7	45.9121	44.73	44.86	24049.0
2017-08-25	BBC	ETF	25.45	25.502	25.197	25.197	2773.0
2017-08-25	BBH	ETF	127.85	128.13	127.0	127.0	9200.0

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

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