PREVIEW / etf_daily / 2016-03-31

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-31.parquet
  size:    50 KB
  rows:    1,247

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-03-31	SPY	ETF	205.91	206.41	205.33	205.52	94584100.0
2016-03-31	QQQ	ETF	109.3	109.69	109.03	109.2	21447236.0
2016-03-31	IWM	ETF	110.48	111.17	110.34	110.63	28555900.0
2016-03-31	DIA	ETF	176.93	177.3	176.43	176.64	3155400.0
2016-03-31	GLD	ETF	118.16	118.39	117.6	117.64	9348200.0
2016-03-31	TLT	ETF	129.98	130.81	129.79	130.61	7832300.0
2016-03-31	AADR	ETF	38.4	38.41	38.31	38.41	700.0
2016-03-31	AAXJ	ETF	54.91	54.99	54.58	54.63	583100.0
2016-03-31	ACTX	ETF	6.4901	6.4901	5.9001	5.9001	428.0
2016-03-31	ACWF	ETF	23.12	23.12	23.12	23.12	200.0
2016-03-31	ACWI	ETF	56.25	56.35	56.04	56.06	3517600.0
2016-03-31	ACWV	ETF	73.56	73.71	73.44	73.49	236100.0
2016-03-31	ACWX	ETF	39.67	39.78	39.465	39.48	999513.0
2016-03-31	ADRE	ETF	31.22	31.288	30.9675	30.9675	12859.0
2016-03-31	AFK	ETF	19.14	19.37	18.92	18.92	8035.0
2016-03-31	AFTY	ETF	12.985	13.01	12.985	12.99	5300.0
2016-03-31	AGG	ETF	110.52	110.85	110.52	110.83	7003600.0
2016-03-31	AGGY	ETF	50.36	50.59	50.36	50.56	14000.0
2016-03-31	AGQ	ETF	33.0	33.17	32.65	32.82	130600.0
2016-03-31	AGZ	ETF	114.8	114.88	114.578	114.88	14659.0
2016-03-31	AIA	ETF	43.55	43.65	43.35	43.35	12205.0
2016-03-31	AIQ	ETF	7.13	7.4	7.0	7.19	18992.0
2016-03-31	AIRR	ETF	17.68	17.68	17.57	17.57	4500.0
2016-03-31	AIVI	ETF	38.48	38.48	38.28	38.3	165500.0
2016-03-31	ALTY	ETF	14.43	14.43	14.43	14.43	100.0
2016-03-31	AMJ	ETF	26.55	27.17	26.49	27.09	3613761.0
2016-03-31	AMLP	ETF	53.45	54.9	53.15	54.6	1515000.0
2016-03-31	AMZA	ETF	90.6	92.97	89.32	92.4	6560.0
2016-03-31	ANGL	ETF	25.77	25.82	25.7	25.73	43700.0
2016-03-31	AOA	ETF	45.51	45.51	45.25	45.31	40900.0
2016-03-31	AOK	ETF	32.21	32.3399	32.21	32.28	41175.0
2016-03-31	AOM	ETF	34.72	34.8699	34.72	34.8	79457.0
2016-03-31	AOR	ETF	39.46	39.52	39.3701	39.45	76313.0
2016-03-31	ARGT	ETF	19.32	19.44	19.28	19.32	44000.0
2016-03-31	ARKG	ETF	17.545	17.545	17.545	17.545	200.0
2016-03-31	ARKK	ETF	19.144	19.23	19.13	19.13	3000.0
2016-03-31	ARKQ	ETF	18.98	18.98	18.9	18.955	300.0
2016-03-31	ARKW	ETF	20.69	20.69	20.68	20.69	400.0
2016-03-31	ASEA	ETF	13.59	13.6	13.53	13.53	3900.0
2016-03-31	ASHR	ETF	24.66	24.73	24.55	24.55	1465500.0
2016-03-31	ASHS	ETF	34.81	34.86	34.67	34.73	33800.0
2016-03-31	ASHX	ETF	21.8356	21.8699	21.83	21.85	950.0
2016-03-31	ATMP	ETF	17.85	18.18	17.8	18.09	324000.0
2016-03-31	BAB	ETF	30.07	30.209	30.0357	30.19	256671.0
2016-03-31	BAL	ETF	37.54	38.2	37.4613	38.195	8845.0
2016-03-31	BBC	ETF	18.48	19.4	18.48	19.05	14330.0
2016-03-31	BBH	ETF	100.84	104.78	100.84	103.68	101900.0
2016-03-31	BBP	ETF	23.88	24.926	23.88	24.66	5000.0
2016-03-31	BCM	ETF	24.58	24.58	24.38	24.45	3629.0
2016-03-31	BFOR	ETF	7.535	7.59	7.53	7.575	39200.0

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

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