PREVIEW / etf_daily / 2017-05-31

all etf daily files

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

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-31	SPY	ETF	241.84	241.88	240.64	241.44	91796000.0
2017-05-31	QQQ	ETF	141.8	141.84	140.57	141.29	33229404.0
2017-05-31	IWM	ETF	136.84	136.92	134.64	136.32	34345400.0
2017-05-31	DIA	ETF	210.41	210.41	209.32	210.0	1577500.0
2017-05-31	GLD	ETF	120.31	121.23	120.26	120.62	10360700.0
2017-05-31	TLT	ETF	124.05	124.65	124.03	124.4	8000200.0
2017-05-31	AADR	ETF	47.83	47.83	47.38	47.46	14700.0
2017-05-31	AAXJ	ETF	67.08	67.08	66.67	66.76	877200.0
2017-05-31	ACSI	ETF	28.51	28.58	28.51	28.5647	1811.0
2017-05-31	ACTX	ETF	46.9054	47.7904	44.2504	44.2504	446.0
2017-05-31	ACWF	ETF	27.04	27.07	27.04	27.0599	1968.0
2017-05-31	ACWI	ETF	65.91	65.92	65.59	65.7	1130400.0
2017-05-31	ACWV	ETF	80.13	80.29	80.07	80.25	214400.0
2017-05-31	ACWX	ETF	46.17	46.17	45.93	45.93	329676.0
2017-05-31	ADRE	ETF	38.2	38.24	38.0252	38.0472	4383.0
2017-05-31	AFK	ETF	21.83	21.83	21.55	21.55	13313.0
2017-05-31	AFTY	ETF	14.83	14.83	14.77	14.77	15200.0
2017-05-31	AGG	ETF	109.64	109.81	109.64	109.76	2416500.0
2017-05-31	AGGY	ETF	50.513	50.6	50.5	50.553	9300.0
2017-05-31	AGNG	ETF	18.23	18.23	17.87	17.87	1500.0
2017-05-31	AGQ	ETF	36.68	37.32	36.62	36.91	138400.0
2017-05-31	AGZ	ETF	113.968	113.99	113.7801	113.99	7925.0
2017-05-31	AGZD	ETF	24.025	24.025	23.92	23.92	6400.0
2017-05-31	AIA	ETF	56.47	56.47	56.07	56.08	26137.0
2017-05-31	AIQ	ETF	13.25	13.3	13.2	13.25	12514.0
2017-05-31	AIRR	ETF	22.94	22.94	22.463	22.9	64500.0
2017-05-31	AIVI	ETF	42.03	42.09	41.86	41.91	10400.0
2017-05-31	ALTY	ETF	15.35	15.52	15.35	15.464	900.0
2017-05-31	AMJ	ETF	29.88	30.07	29.7	29.91	2820360.0
2017-05-31	AMLP	ETF	59.8	60.1	59.55	60.0	1842480.0
2017-05-31	AMZA	ETF	101.0	101.2	99.5	100.8	137020.0
2017-05-31	ANGL	ETF	29.76	29.8	29.71	29.74	255400.0
2017-05-31	AOA	ETF	51.58	51.6	51.39	51.51	66000.0
2017-05-31	AOK	ETF	33.97	33.99	33.9164	33.96	133727.0
2017-05-31	AOM	ETF	37.2	37.2	37.0937	37.19	45727.0
2017-05-31	AOR	ETF	43.54	43.54	43.37	43.47	92296.0
2017-05-31	ARCM	ETF	100.05	100.05	100.05	100.05	2000.0
2017-05-31	ARGT	ETF	30.47	30.52	30.27	30.31	107100.0
2017-05-31	ARKG	ETF	20.21	20.21	19.973	20.16	16400.0
2017-05-31	ARKK	ETF	28.29	28.37	27.84	28.35	127900.0
2017-05-31	ARKQ	ETF	28.71	28.89	28.385	28.7	30800.0
2017-05-31	ARKW	ETF	35.17	35.24	34.75	35.22	57500.0
2017-05-31	ASEA	ETF	14.9	14.9	14.9	14.9	500.0
2017-05-31	ASET	ETF	27.48	27.48	27.41	27.4101	2210.0
2017-05-31	ASHR	ETF	25.72	25.76	25.69	25.74	650800.0
2017-05-31	ASHS	ETF	31.01	31.2	31.0	31.17	13600.0
2017-05-31	ATMP	ETF	22.12	22.19	21.94	22.12	20900.0
2017-05-31	BAB	ETF	30.0	30.07	29.95	30.05	139612.0
2017-05-31	BAL	ETF	48.9	48.94	48.79	48.79	37557.0
2017-05-31	BBC	ETF	21.26	21.26	20.62	20.9624	8050.0

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

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