PREVIEW / etf_daily / 2016-03-18

all etf daily files

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

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-18	SPY	ETF	204.17	204.78	203.8	204.38	138372400.0
2016-03-18	QQQ	ETF	107.46	107.635	106.8	107.37	37682293.0
2016-03-18	IWM	ETF	108.77	109.95	108.7	109.61	36512600.0
2016-03-18	DIA	ETF	175.27	175.95	175.04	175.69	5112000.0
2016-03-18	GLD	ETF	119.59	120.34	119.51	119.8	16965900.0
2016-03-18	TLT	ETF	129.04	129.51	128.7	129.06	8198600.0
2016-03-18	AADR	ETF	38.42	38.5	38.2	38.42	800.0
2016-03-18	AAXJ	ETF	54.18	54.52	54.18	54.32	628400.0
2016-03-18	ACTX	ETF	7.0801	8.2601	7.0801	7.6701	1192.0
2016-03-18	ACWI	ETF	55.97	56.11	55.86	56.0	1133500.0
2016-03-18	ACWV	ETF	72.94	72.97	72.6	72.79	274800.0
2016-03-18	ACWX	ETF	39.6	39.75	39.545	39.59	1617135.0
2016-03-18	ADRE	ETF	30.64	30.75	30.64	30.71	3282.0
2016-03-18	AFK	ETF	19.75	19.77	19.53	19.68	510384.0
2016-03-18	AFTY	ETF	12.97	12.99	12.925	12.93	18100.0
2016-03-18	AGG	ETF	110.19	110.29	110.12	110.17	1909600.0
2016-03-18	AGGY	ETF	50.37	50.39	50.37	50.39	500.0
2016-03-18	AGQ	ETF	34.99	35.07	34.33	34.61	364800.0
2016-03-18	AGZ	ETF	114.22	114.58	114.05	114.4	87419.0
2016-03-18	AGZD	ETF	23.93	24.07	23.765	23.765	10000.0
2016-03-18	AIA	ETF	43.08	43.26	43.08	43.19	38448.0
2016-03-18	AIQ	ETF	6.93	7.955	6.76	6.96	60164.0
2016-03-18	AIRR	ETF	17.52	17.52	17.375	17.379	1700.0
2016-03-18	AIVI	ETF	38.6	38.76	38.5	38.56	13000.0
2016-03-18	ALTY	ETF	14.23	14.23	14.13	14.13	700.0
2016-03-18	AMJ	ETF	27.53	28.25	27.0732	27.5	6178464.0
2016-03-18	AMLP	ETF	56.5	57.0	54.55	55.6	3521060.0
2016-03-18	AMZA	ETF	94.1	94.7	90.8	92.3	6200.0
2016-03-18	ANGL	ETF	25.96	26.03	25.87	25.98	22200.0
2016-03-18	AOA	ETF	45.19	45.24	45.1	45.18	67400.0
2016-03-18	AOK	ETF	32.11	32.1599	32.1	32.13	13323.0
2016-03-18	AOM	ETF	34.68	34.699	34.5779	34.65	145938.0
2016-03-18	AOR	ETF	39.36	39.36	39.2101	39.29	121435.0
2016-03-18	ARGT	ETF	19.28	19.33	19.08	19.19	48100.0
2016-03-18	ARKG	ETF	16.73	16.95	16.73	16.95	2500.0
2016-03-18	ARKK	ETF	18.48	18.54	18.48	18.508	3900.0
2016-03-18	ARKQ	ETF	18.45	18.52	18.45	18.51	900.0
2016-03-18	ARKW	ETF	20.303	20.303	20.303	20.303	500.0
2016-03-18	ASEA	ETF	13.51	13.54	13.51	13.54	400.0
2016-03-18	ASET	ETF	25.71	25.71	25.7006	25.7006	332.0
2016-03-18	ASHR	ETF	24.54	24.77	24.46	24.69	4189000.0
2016-03-18	ASHS	ETF	33.53	34.28	33.42	34.06	215800.0
2016-03-18	ASHX	ETF	21.8699	21.89	21.8699	21.89	421.0
2016-03-18	ATMP	ETF	18.63	18.64	18.23	18.41	20400.0
2016-03-18	BAB	ETF	29.95	29.95	29.8401	29.87	90122.0
2016-03-18	BAL	ETF	37.8708	37.8708	37.17	37.24	8118.0
2016-03-18	BBC	ETF	17.09	18.07	17.09	18.03	6528.0
2016-03-18	BBH	ETF	98.75	100.54	97.88	100.17	221500.0
2016-03-18	BBP	ETF	22.99	23.649	22.88	23.52	6100.0
2016-03-18	BCM	ETF	25.19	25.19	25.03	25.03	556.0

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

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