PREVIEW / etf_daily / 2017-05-05

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-05.parquet
  size:    54 KB
  rows:    1,384

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-05	SPY	ETF	239.19	239.72	238.68	239.7	62001300.0
2017-05-05	QQQ	ETF	137.39	137.54	136.88	137.54	19330652.0
2017-05-05	IWM	ETF	138.69	138.99	137.53	138.99	23806500.0
2017-05-05	DIA	ETF	209.07	209.78	208.76	209.77	1673800.0
2017-05-05	GLD	ETF	116.86	117.07	116.68	117.01	7127200.0
2017-05-05	TLT	ETF	121.38	121.47	120.89	121.29	5605400.0
2017-05-05	AADR	ETF	47.45	47.82	47.45	47.81	9000.0
2017-05-05	AAXJ	ETF	63.97	64.29	63.95	64.27	1269100.0
2017-05-05	ACSI	ETF	28.51	28.5599	28.49	28.5599	1601.0
2017-05-05	ACTX	ETF	78.4707	80.8307	78.4707	80.2407	260.0
2017-05-05	ACWF	ETF	26.42	26.5202	26.42	26.5202	1440.0
2017-05-05	ACWI	ETF	64.7	65.09	64.64	65.02	1007200.0
2017-05-05	ACWV	ETF	78.22	78.55	78.15	78.55	123000.0
2017-05-05	ACWX	ETF	45.01	45.44	44.97	45.44	481117.0
2017-05-05	ADRE	ETF	36.94	37.1	36.94	37.0989	5671.0
2017-05-05	AFK	ETF	21.06	21.06	20.6828	20.6828	13536.0
2017-05-05	AFTY	ETF	13.535	13.55	13.52	13.52	9300.0
2017-05-05	AGG	ETF	108.72	108.74	108.57	108.7	1421800.0
2017-05-05	AGGY	ETF	50.01	50.07	49.97	50.07	12500.0
2017-05-05	AGNG	ETF	17.51	17.76	17.51	17.76	2200.0
2017-05-05	AGQ	ETF	32.85	33.19	32.55	33.19	192100.0
2017-05-05	AGZ	ETF	113.04	113.26	113.01	113.2	12654.0
2017-05-05	AGZD	ETF	23.965	23.995	23.965	23.995	3000.0
2017-05-05	AIA	ETF	53.97	54.29	53.9699	54.29	14315.0
2017-05-05	AIQ	ETF	13.15	13.2	13.1	13.1	33750.0
2017-05-05	AIRR	ETF	24.25	24.36	24.131	24.36	31400.0
2017-05-05	AIVI	ETF	40.31	40.74	40.31	40.74	11700.0
2017-05-05	ALTY	ETF	15.27	15.57	15.27	15.496	2500.0
2017-05-05	AMJ	ETF	30.62	31.27	30.495	31.17	2407812.0
2017-05-05	AMLP	ETF	61.3	62.2	61.0	62.2	2296780.0
2017-05-05	AMZA	ETF	101.0	103.25	99.9	103.0	74630.0
2017-05-05	ANGL	ETF	29.42	29.43	29.29	29.41	269900.0
2017-05-05	AOA	ETF	50.87	51.08	50.82	51.08	38600.0
2017-05-05	AOK	ETF	33.64	33.68	33.5565	33.68	68456.0
2017-05-05	AOM	ETF	36.78	36.86	36.7	36.86	82788.0
2017-05-05	AOR	ETF	42.97	43.11	42.9	43.11	81967.0
2017-05-05	ARCM	ETF	100.0	100.0	100.0	100.0	2000.0
2017-05-05	ARGT	ETF	29.15	29.97	29.15	29.97	85900.0
2017-05-05	ARKG	ETF	20.65	20.65	20.08	20.19	8300.0
2017-05-05	ARKK	ETF	25.624	25.76	25.5	25.76	13200.0
2017-05-05	ARKQ	ETF	26.59	26.85	26.52	26.85	21600.0
2017-05-05	ARKW	ETF	30.56	30.929	30.56	30.929	10300.0
2017-05-05	ASEA	ETF	14.72	14.73	14.69	14.73	1900.0
2017-05-05	ASET	ETF	26.8798	26.99	26.8798	26.9801	3273.0
2017-05-05	ASHR	ETF	24.45	24.45	24.33	24.34	717200.0
2017-05-05	ASHS	ETF	31.93	31.93	31.75	31.8	7200.0
2017-05-05	ASHX	ETF	18.95	18.95	18.95	18.95	200.0
2017-05-05	ATMP	ETF	22.69	23.11	22.69	23.08	109300.0
2017-05-05	BAB	ETF	29.42	29.4768	29.41	29.43	55555.0
2017-05-05	BAL	ETF	49.933	49.933	49.4401	49.46	12107.0

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

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