PREVIEW / etf_daily / 2017-05-26

all etf daily files

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

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-26	SPY	ETF	241.54	241.9	241.45	241.71	46629900.0
2017-05-26	QQQ	ETF	141.0	141.28	140.81	141.22	13851582.0
2017-05-26	IWM	ETF	137.38	137.79	136.78	137.54	20047300.0
2017-05-26	DIA	ETF	210.54	210.72	210.32	210.54	1152200.0
2017-05-26	GLD	ETF	120.49	120.79	120.33	120.54	6791600.0
2017-05-26	TLT	ETF	123.55	123.74	123.25	123.48	2963800.0
2017-05-26	AADR	ETF	47.69	49.25	47.69	48.01	20400.0
2017-05-26	AAXJ	ETF	67.16	67.29	67.13	67.22	1670500.0
2017-05-26	ACSI	ETF	28.6462	28.6462	28.6175	28.6175	1461.0
2017-05-26	ACTX	ETF	82.0107	82.0107	44.2504	50.9175	788.0
2017-05-26	ACWF	ETF	27.07	27.07	27.0397	27.0397	1746.0
2017-05-26	ACWI	ETF	65.78	65.84	65.73	65.83	1248600.0
2017-05-26	ACWV	ETF	79.82	79.89	79.77	79.81	181000.0
2017-05-26	ACWX	ETF	46.02	46.07	45.97	46.06	311169.0
2017-05-26	ADRE	ETF	38.34	38.485	38.2901	38.48	17269.0
2017-05-26	AFK	ETF	21.73	21.9399	21.73	21.9	3608.0
2017-05-26	AFTY	ETF	14.63	14.67	14.63	14.63	6600.0
2017-05-26	AGG	ETF	109.46	109.54	109.44	109.44	955300.0
2017-05-26	AGGY	ETF	50.44	50.45	50.388	50.45	13300.0
2017-05-26	AGNG	ETF	18.2	18.2	18.13	18.14	1400.0
2017-05-26	AGQ	ETF	36.95	37.2	36.6	36.95	189000.0
2017-05-26	AGZ	ETF	113.77	113.86	113.54	113.7	16398.0
2017-05-26	AGZD	ETF	23.935	23.975	23.935	23.975	2000.0
2017-05-26	AIA	ETF	56.81	56.82	56.73	56.8	14467.0
2017-05-26	AIQ	ETF	13.1999	13.25	13.1999	13.25	13733.0
2017-05-26	AIRR	ETF	23.0	23.107	22.92	23.05	38800.0
2017-05-26	AIVI	ETF	41.74	41.9	41.74	41.9	49100.0
2017-05-26	ALTY	ETF	15.51	15.58	15.49	15.503	9300.0
2017-05-26	AMJ	ETF	30.73	30.79	30.48	30.56	1192941.0
2017-05-26	AMLP	ETF	61.0	61.1	60.65	60.95	1335900.0
2017-05-26	AMZA	ETF	104.1	104.2	103.39	103.6	33490.0
2017-05-26	ANGL	ETF	29.75	29.77	29.73	29.76	181700.0
2017-05-26	AOA	ETF	51.51	51.61	51.41	51.48	102900.0
2017-05-26	AOK	ETF	33.9293	33.95	33.799	33.93	88804.0
2017-05-26	AOM	ETF	37.1	37.1699	37.0621	37.08	82043.0
2017-05-26	AOR	ETF	43.41	43.48	43.3944	43.47	159776.0
2017-05-26	ARCM	ETF	100.1	100.1	100.1	100.1	200.0
2017-05-26	ARGT	ETF	30.75	30.97	30.72	30.88	93400.0
2017-05-26	ARKG	ETF	20.8	20.81	20.57	20.57	7800.0
2017-05-26	ARKK	ETF	28.67	28.67	28.05	28.25	105500.0
2017-05-26	ARKQ	ETF	28.75	28.79	28.52	28.76	160300.0
2017-05-26	ARKW	ETF	35.38	35.38	34.727	34.92	57700.0
2017-05-26	ASEA	ETF	15.05	15.05	14.93	14.94	5500.0
2017-05-26	ASET	ETF	27.3698	27.3698	27.3698	27.3698	761.0
2017-05-26	ASHR	ETF	25.44	25.58	25.44	25.47	577900.0
2017-05-26	ASHS	ETF	30.98	31.0	30.94	30.95	3900.0
2017-05-26	ASHX	ETF	19.65	19.65	19.6499	19.6499	978.0
2017-05-26	ATMP	ETF	22.8	22.8	22.53	22.67	228500.0
2017-05-26	BAB	ETF	29.87	29.9	29.8	29.84	62893.0
2017-05-26	BAL	ETF	49.3489	49.3489	49.0	49.04	2146.0

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

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