PREVIEW / etf_daily / 2017-06-01

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-01.parquet
  size:    55 KB
  rows:    1,399

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-06-01	SPY	ETF	241.97	243.38	241.64	243.36	68962000.0
2017-06-01	QQQ	ETF	141.57	141.9	140.98	141.84	20120741.0
2017-06-01	IWM	ETF	136.72	139.0	136.27	138.95	44618600.0
2017-06-01	DIA	ETF	210.27	211.4	209.91	211.4	1827900.0
2017-06-01	GLD	ETF	120.17	120.74	120.06	120.72	8702500.0
2017-06-01	TLT	ETF	123.7	124.19	123.66	124.15	9037300.0
2017-06-01	AADR	ETF	47.55	47.78	47.53	47.78	19700.0
2017-06-01	AAXJ	ETF	67.05	67.39	66.94	67.38	1127400.0
2017-06-01	ACSI	ETF	28.7136	28.85	28.7	28.85	3290.0
2017-06-01	ACTX	ETF	44.2504	47.2004	41.3004	46.0204	225.0
2017-06-01	ACWF	ETF	27.1	27.3	27.1	27.2813	9746.0
2017-06-01	ACWI	ETF	65.87	66.24	65.7	66.24	3266900.0
2017-06-01	ACWV	ETF	80.46	80.79	80.36	80.79	202600.0
2017-06-01	ACWX	ETF	46.15	46.42	46.07	46.42	421498.0
2017-06-01	ADRE	ETF	38.23	38.35	38.1401	38.32	6843.0
2017-06-01	AFK	ETF	21.557	21.628	21.557	21.628	613.0
2017-06-01	AFTY	ETF	14.957	14.99	14.95	14.95	4000.0
2017-06-01	AGG	ETF	109.36	109.5	109.34	109.48	2454500.0
2017-06-01	AGGY	ETF	50.5	50.57	50.5	50.57	13700.0
2017-06-01	AGNG	ETF	18.15	18.2	18.08	18.08	37200.0
2017-06-01	AGQ	ETF	35.96	36.97	35.78	36.89	159700.0
2017-06-01	AGZ	ETF	113.565	113.8	113.5422	113.79	13617.0
2017-06-01	AGZD	ETF	23.96	23.965	23.945	23.965	6600.0
2017-06-01	AIA	ETF	56.55	56.71	56.36	56.71	33347.0
2017-06-01	AIQ	ETF	13.2	13.3	13.2	13.2	5407.0
2017-06-01	AIRR	ETF	22.93	23.37	22.93	23.37	89000.0
2017-06-01	AIVI	ETF	41.96	42.11	41.96	42.11	22100.0
2017-06-01	ALTY	ETF	15.385	15.5	15.37	15.37	2600.0
2017-06-01	AMJ	ETF	30.08	30.31	29.95	30.13	1819403.0
2017-06-01	AMLP	ETF	60.1	60.45	59.95	60.05	1756040.0
2017-06-01	AMZA	ETF	101.3	102.8	101.2	102.0	59470.0
2017-06-01	ANGL	ETF	29.69	29.7	29.61	29.67	237500.0
2017-06-01	AOA	ETF	51.59	51.84	51.55	51.84	46100.0
2017-06-01	AOK	ETF	33.96	34.05	33.96	34.05	33858.0
2017-06-01	AOM	ETF	37.17	37.29	37.1001	37.23	62809.0
2017-06-01	AOR	ETF	43.52	43.69	43.5119	43.69	56735.0
2017-06-01	ARCM	ETF	100.0	100.0	100.0	100.0	2000.0
2017-06-01	ARGT	ETF	30.37	30.9	30.37	30.83	16800.0
2017-06-01	ARKG	ETF	20.355	20.76	20.34	20.74	14600.0
2017-06-01	ARKK	ETF	28.48	28.969	28.48	28.96	105100.0
2017-06-01	ARKQ	ETF	28.7	29.07	28.7	29.07	62600.0
2017-06-01	ARKW	ETF	35.37	35.85	35.37	35.819	131900.0
2017-06-01	ASEA	ETF	14.97	14.97	14.94	14.94	200.0
2017-06-01	ASET	ETF	27.53	27.63	27.53	27.63	1506.0
2017-06-01	ASHR	ETF	25.74	25.79	25.66	25.76	799100.0
2017-06-01	ASHS	ETF	30.58	30.59	30.49	30.58	8300.0
2017-06-01	ATMP	ETF	22.25	22.34	22.19	22.2	19200.0
2017-06-01	BAB	ETF	29.96	30.0	29.94	29.99	102730.0
2017-06-01	BAL	ETF	49.0339	49.33	48.96	49.3	10613.0
2017-06-01	BBC	ETF	20.94	21.68	20.94	21.68	13373.0

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

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