PREVIEW / etf_daily / 2016-07-27

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-27.parquet
  size:    51 KB
  rows:    1,286

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
2016-07-27	SPY	ETF	217.19	217.27	215.62	216.52	84083900.0
2016-07-27	QQQ	ETF	114.76	114.88	114.1	114.58	27646113.0
2016-07-27	IWM	ETF	121.0	121.47	120.35	121.14	21064700.0
2016-07-27	DIA	ETF	185.14	185.28	184.11	184.58	4146700.0
2016-07-27	GLD	ETF	126.79	128.12	126.04	128.03	17066400.0
2016-07-27	TLT	ETF	139.55	140.65	139.4	140.65	8508100.0
2016-07-27	AADR	ETF	41.02	41.03	40.65	40.96	1600.0
2016-07-27	AAXJ	ETF	57.52	57.68	57.12	57.51	1104000.0
2016-07-27	ACTX	ETF	3.54	3.54	2.95	2.95	18.0
2016-07-27	ACWI	ETF	58.11	58.15	57.66	57.99	2361500.0
2016-07-27	ACWV	ETF	77.59	77.59	76.81	77.18	245300.0
2016-07-27	ACWX	ETF	40.25	40.32	39.91	40.2	354070.0
2016-07-27	ADRE	ETF	33.24	33.24	32.9378	33.1142	4390.0
2016-07-27	AFK	ETF	20.23	20.34	20.0	20.06	14901.0
2016-07-27	AFTY	ETF	13.04	13.13	13.02	13.11	6300.0
2016-07-27	AGG	ETF	112.52	112.74	112.44	112.73	3047200.0
2016-07-27	AGGY	ETF	51.95	53.14	51.9	52.08	10200.0
2016-07-27	AGQ	ETF	53.45	55.58	52.25	55.34	629500.0
2016-07-27	AGZ	ETF	115.97	115.97	115.41	115.5901	33469.0
2016-07-27	AGZD	ETF	23.96	23.96	23.96	23.96	800.0
2016-07-27	AIA	ETF	47.33	47.3785	47.01	47.23	23633.0
2016-07-27	AIQ	ETF	6.02	6.23	5.91	5.91	13942.0
2016-07-27	AIRR	ETF	19.5	19.5	19.38	19.45	8900.0
2016-07-27	AIVI	ETF	38.64	38.81	38.35	38.71	15400.0
2016-07-27	ALTY	ETF	15.61	15.61	15.56	15.56	3600.0
2016-07-27	AMJ	ETF	31.89	32.18	31.51	31.56	2724422.0
2016-07-27	AMLP	ETF	63.8	64.5	63.55	63.6	969300.0
2016-07-27	AMZA	ETF	112.8	113.5	111.5	111.6	9780.0
2016-07-27	ANGL	ETF	28.25	28.27	28.18	28.23	94400.0
2016-07-27	AOA	ETF	46.75	46.86	46.56	46.8	47700.0
2016-07-27	AOK	ETF	33.12	33.2699	33.071	33.18	39346.0
2016-07-27	AOM	ETF	35.72	35.84	35.57	35.71	98935.0
2016-07-27	AOR	ETF	40.53	40.65	40.41	40.62	39382.0
2016-07-27	ARGT	ETF	22.39	22.49	22.17	22.39	15400.0
2016-07-27	ARKG	ETF	18.74	18.74	18.72	18.72	200.0
2016-07-27	ARKK	ETF	20.44	20.517	20.44	20.517	500.0
2016-07-27	ARKQ	ETF	20.79	20.85	20.79	20.85	300.0
2016-07-27	ARKW	ETF	23.85	23.85	23.85	23.85	100.0
2016-07-27	ASEA	ETF	13.95	13.95	13.95	13.95	1500.0
2016-07-27	ASET	ETF	27.21	27.21	27.0164	27.17	1578.0
2016-07-27	ASHR	ETF	24.25	24.28	24.16	24.22	1531900.0
2016-07-27	ASHS	ETF	34.32	34.44	34.1	34.31	81700.0
2016-07-27	ATMP	ETF	22.7	22.7	22.25	22.27	9500.0
2016-07-27	BAB	ETF	31.55	31.73	31.5101	31.71	321444.0
2016-07-27	BAL	ETF	49.7141	49.91	48.95	49.1001	17884.0
2016-07-27	BBC	ETF	19.46	20.23	19.46	20.23	51854.0
2016-07-27	BBH	ETF	111.48	113.93	111.48	113.78	111900.0
2016-07-27	BBP	ETF	30.269	30.636	30.23	30.636	9200.0
2016-07-27	BCM	ETF	26.12	26.12	25.7	25.74	2757.0
2016-07-27	BFOR	ETF	7.9975	8.0025	7.975	7.9975	32000.0

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

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