PREVIEW / etf_daily / 2017-05-30

all etf daily files

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

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-30	SPY	ETF	241.34	241.79	241.16	241.5	35201900.0
2017-05-30	QQQ	ETF	141.13	141.505	141.06	141.34	20306409.0
2017-05-30	IWM	ETF	137.12	137.44	136.22	136.46	25544100.0
2017-05-30	DIA	ETF	210.21	210.52	209.97	210.21	1066600.0
2017-05-30	GLD	ETF	120.24	120.33	119.95	120.14	4507500.0
2017-05-30	TLT	ETF	124.03	124.14	123.74	124.09	4819400.0
2017-05-30	AADR	ETF	47.91	47.91	47.54	47.58	6400.0
2017-05-30	AAXJ	ETF	67.02	67.15	66.91	67.05	702800.0
2017-05-30	ACSI	ETF	28.59	28.62	28.59	28.6	969.0
2017-05-30	ACTX	ETF	53.1005	53.6905	44.8404	47.7904	497.0
2017-05-30	ACWF	ETF	27.01	27.09	27.01	27.0899	750.0
2017-05-30	ACWI	ETF	65.66	65.8	65.66	65.8	1226700.0
2017-05-30	ACWV	ETF	79.8	79.99	79.75	79.99	115200.0
2017-05-30	ACWX	ETF	45.95	46.02	45.92	45.99	271213.0
2017-05-30	ADRE	ETF	38.41	38.41	38.221	38.3	4147.0
2017-05-30	AFK	ETF	21.61	21.7212	21.58	21.7	20531.0
2017-05-30	AFTY	ETF	14.662	14.71	14.64	14.71	9200.0
2017-05-30	AGG	ETF	109.58	109.66	109.54	109.65	2093200.0
2017-05-30	AGGY	ETF	50.5	50.53	50.48	50.53	9700.0
2017-05-30	AGQ	ETF	36.89	37.5	36.89	37.32	159500.0
2017-05-30	AGZ	ETF	113.6096	113.92	113.6	113.86	15616.0
2017-05-30	AGZD	ETF	23.915	23.94	23.915	23.94	800.0
2017-05-30	AIA	ETF	56.36	56.49	56.1772	56.44	25419.0
2017-05-30	AIQ	ETF	13.25	13.3	13.2	13.2	40445.0
2017-05-30	AIRR	ETF	22.93	23.013	22.89	22.89	64100.0
2017-05-30	AIVI	ETF	41.75	41.84	41.75	41.83	31400.0
2017-05-30	ALTY	ETF	15.51	15.52	15.51	15.52	900.0
2017-05-30	AMJ	ETF	30.41	30.44	30.03	30.09	2037856.0
2017-05-30	AMLP	ETF	60.6	60.75	60.1	60.1	1258740.0
2017-05-30	AMZA	ETF	103.6	103.6	101.3	101.5	79450.0
2017-05-30	ANGL	ETF	29.76	29.79	29.7	29.75	979700.0
2017-05-30	AOA	ETF	51.47	51.53	51.39	51.51	38800.0
2017-05-30	AOK	ETF	33.93	33.965	33.92	33.96	87961.0
2017-05-30	AOM	ETF	37.09	37.21	37.0801	37.1	66227.0
2017-05-30	AOR	ETF	43.47	43.4806	43.3928	43.43	110285.0
2017-05-30	ARCM	ETF	100.1	100.1	100.1	100.1	20.0
2017-05-30	ARGT	ETF	30.85	30.98	30.47	30.52	206400.0
2017-05-30	ARKG	ETF	20.54	20.56	20.05	20.205	13800.0
2017-05-30	ARKK	ETF	28.33	28.33	28.03	28.14	80500.0
2017-05-30	ARKQ	ETF	28.74	28.87	28.683	28.71	48600.0
2017-05-30	ARKW	ETF	35.04	35.1	34.74	35.02	90900.0
2017-05-30	ASEA	ETF	14.98	14.98	14.91	14.92	1200.0
2017-05-30	ASET	ETF	27.395	27.395	27.395	27.395	339.0
2017-05-30	ASHR	ETF	25.47	25.61	25.41	25.61	809700.0
2017-05-30	ASHS	ETF	30.7	31.11	30.7	31.11	17500.0
2017-05-30	ASHX	ETF	19.65	19.65	19.65	19.65	500.0
2017-05-30	ATMP	ETF	22.46	22.46	22.15	22.22	87100.0
2017-05-30	BAB	ETF	29.96	30.0	29.8774	29.98	89875.0
2017-05-30	BAL	ETF	49.08	49.37	49.0	49.1	19880.0
2017-05-30	BBC	ETF	21.3933	21.3933	21.02	21.03	10091.0

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

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