PREVIEW / etf_daily / 2016-09-19

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-19.parquet
  size:    52 KB
  rows:    1,305

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-09-19	SPY	ETF	214.13	214.88	213.03	213.41	80250500.0
2016-09-19	QQQ	ETF	117.57	117.95	116.55	116.78	16222870.0
2016-09-19	IWM	ETF	122.32	123.55	121.99	122.67	22807000.0
2016-09-19	DIA	ETF	181.88	182.32	180.67	180.98	2260400.0
2016-09-19	GLD	ETF	125.61	125.62	125.25	125.32	4959600.0
2016-09-19	TLT	ETF	134.52	134.87	134.25	134.31	7105900.0
2016-09-19	AAXJ	ETF	59.9	60.09	59.61	59.69	803600.0
2016-09-19	ACTX	ETF	6.4901	8.8501	5.9001	7.6701	1327.0
2016-09-19	ACWF	ETF	23.952	23.952	23.952	23.952	245.0
2016-09-19	ACWI	ETF	58.26	58.37	57.91	57.98	1073900.0
2016-09-19	ACWV	ETF	75.4	75.55	75.16	75.28	104200.0
2016-09-19	ACWX	ETF	40.75	40.87	40.6	40.64	208941.0
2016-09-19	ADRE	ETF	34.31	34.4065	34.03	34.156	10336.0
2016-09-19	AFK	ETF	20.47	20.5	20.026	20.026	3047.0
2016-09-19	AFTY	ETF	13.53	13.53	13.45	13.45	1100.0
2016-09-19	AGG	ETF	111.73	111.85	111.69	111.71	2026900.0
2016-09-19	AGGY	ETF	51.69	51.71	51.57	51.68	10700.0
2016-09-19	AGNG	ETF	16.68	16.68	16.54	16.58	400.0
2016-09-19	AGQ	ETF	48.49	48.81	48.1	48.22	162100.0
2016-09-19	AGZ	ETF	115.12	115.2099	115.055	115.09	7580.0
2016-09-19	AIA	ETF	49.28	49.4595	49.05	49.06	170678.0
2016-09-19	AIQ	ETF	6.32	6.54	6.32	6.43	14983.0
2016-09-19	AIRR	ETF	19.603	19.7	19.55	19.62	7100.0
2016-09-19	AIVI	ETF	38.06	38.15	37.92	37.94	6400.0
2016-09-19	ALTY	ETF	15.38	15.51	15.38	15.43	1100.0
2016-09-19	AMJ	ETF	30.11	30.52	30.05	30.33	2057120.0
2016-09-19	AMLP	ETF	60.9	61.7	60.9	61.45	1167220.0
2016-09-19	AMZA	ETF	112.8	113.1	111.9	112.6	19960.0
2016-09-19	ANGL	ETF	28.35	28.46	28.33	28.4	228500.0
2016-09-19	AOA	ETF	46.92	47.0	46.71	46.79	21400.0
2016-09-19	AOK	ETF	33.02	33.13	32.96	32.96	52423.0
2016-09-19	AOM	ETF	35.71	35.768	35.59	35.67	59197.0
2016-09-19	AOR	ETF	40.5	40.7299	40.5	40.56	49215.0
2016-09-19	ARGT	ETF	22.69	22.89	22.62	22.76	131300.0
2016-09-19	ARKG	ETF	19.7	19.717	19.7	19.717	500.0
2016-09-19	ARKK	ETF	21.38	21.38	21.38	21.38	100.0
2016-09-19	ARKQ	ETF	21.3	21.37	21.3	21.37	2300.0
2016-09-19	ARKW	ETF	24.58	24.8	24.54	24.59	2900.0
2016-09-19	ASEA	ETF	13.77	13.89	13.77	13.89	500.0
2016-09-19	ASHR	ETF	24.83	24.83	24.65	24.69	421500.0
2016-09-19	ASHS	ETF	34.71	34.91	34.71	34.79	34400.0
2016-09-19	ATMP	ETF	22.58	22.59	22.41	22.48	10600.0
2016-09-19	BAB	ETF	31.12	31.16	31.03	31.09	115623.0
2016-09-19	BAL	ETF	45.38	45.5	44.5401	45.2369	3916.0
2016-09-19	BBC	ETF	21.9	22.683	21.9	22.25	45421.0
2016-09-19	BBH	ETF	117.24	117.82	116.51	116.66	82200.0
2016-09-19	BBP	ETF	33.36	33.412	33.02	33.04	15100.0
2016-09-19	BCM	ETF	25.7199	25.7199	25.6921	25.6921	1133.0
2016-09-19	BFOR	ETF	7.975	8.035	7.9575	7.9825	17600.0
2016-09-19	BIB	ETF	49.81	50.44	48.95	49.36	690975.0

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

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