PREVIEW / etf_daily / 2017-01-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-13.parquet
  size:    54 KB
  rows:    1,355

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-01-13	SPY	ETF	226.73	227.4	226.69	227.05	62717900.0
2017-01-13	QQQ	ETF	122.81	123.37	122.8	123.16	16930803.0
2017-01-13	IWM	ETF	135.65	136.97	135.65	136.26	27784500.0
2017-01-13	DIA	ETF	198.91	199.35	198.32	198.7	3468900.0
2017-01-13	GLD	ETF	113.65	114.31	113.19	114.21	7261500.0
2017-01-13	TLT	ETF	121.33	121.75	120.62	121.31	9820000.0
2017-01-13	AADR	ETF	43.05	43.45	43.05	43.42	2300.0
2017-01-13	AAXJ	ETF	57.7	57.82	57.61	57.77	670200.0
2017-01-13	ACSI	ETF	27.28	27.28	27.21	27.25	5015.0
2017-01-13	ACTX	ETF	35.1053	44.2504	30.6803	41.3004	5620.0
2017-01-13	ACWF	ETF	24.7918	24.98	24.75	24.95	2591.0
2017-01-13	ACWI	ETF	60.54	60.74	60.53	60.7	2432300.0
2017-01-13	ACWV	ETF	73.66	73.72	73.54	73.67	141900.0
2017-01-13	ACWX	ETF	41.52	41.64	41.47	41.61	875357.0
2017-01-13	ADRE	ETF	34.27	34.27	34.1107	34.1107	1933.0
2017-01-13	AFK	ETF	21.0	21.36	21.0	21.01	15079.0
2017-01-13	AFTY	ETF	13.32	13.44	13.32	13.44	4300.0
2017-01-13	AGG	ETF	108.5	108.55	108.26	108.42	3293600.0
2017-01-13	AGGY	ETF	49.72	49.79	49.72	49.79	1200.0
2017-01-13	AGQ	ETF	35.15	35.77	34.78	35.69	181900.0
2017-01-13	AGZ	ETF	112.89	112.9884	112.76	112.82	16003.0
2017-01-13	AGZD	ETF	24.125	24.165	24.085	24.16	19000.0
2017-01-13	AIA	ETF	48.62	48.7356	48.61	48.72	21234.0
2017-01-13	AIQ	ETF	9.75	9.75	9.7	9.7	7199.0
2017-01-13	AIRR	ETF	23.6	23.79	23.6	23.69	150000.0
2017-01-13	AIVI	ETF	38.43	38.56	38.41	38.53	24300.0
2017-01-13	AMJ	ETF	31.66	32.5	31.2077	31.93	1407254.0
2017-01-13	AMLP	ETF	63.6	63.9	63.4	63.75	1283800.0
2017-01-13	AMZA	ETF	108.9	109.3	108.5	108.8	56830.0
2017-01-13	ANGL	ETF	29.17	29.21	29.16	29.19	137800.0
2017-01-13	AOA	ETF	48.04	48.12	48.03	48.1	127400.0
2017-01-13	AOK	ETF	32.7689	32.857	32.7234	32.75	67092.0
2017-01-13	AOM	ETF	35.6	35.62	35.52	35.62	255362.0
2017-01-13	AOR	ETF	41.08	41.1488	41.04	41.13	361250.0
2017-01-13	ARGT	ETF	24.92	25.19	24.92	25.13	111800.0
2017-01-13	ARKG	ETF	18.328	18.328	18.328	18.328	100.0
2017-01-13	ARKK	ETF	22.011	22.081	21.98	22.06	2100.0
2017-01-13	ARKQ	ETF	23.06	23.235	23.06	23.21	1200.0
2017-01-13	ARKW	ETF	26.99	27.1	26.99	27.084	2700.0
2017-01-13	ASEA	ETF	13.25	13.31	13.25	13.29	1000.0
2017-01-13	ASET	ETF	25.9397	25.9397	25.9397	25.9397	204.0
2017-01-13	ASHR	ETF	24.09	24.3	24.09	24.28	891300.0
2017-01-13	ASHS	ETF	32.84	32.84	32.56	32.72	7900.0
2017-01-13	ATMP	ETF	23.61	23.75	23.59	23.65	81500.0
2017-01-13	BAB	ETF	29.27	29.29	29.19	29.23	303566.0
2017-01-13	BAL	ETF	47.71	47.785	47.5347	47.605	11587.0
2017-01-13	BBC	ETF	19.64	20.239	19.64	19.9701	6687.0
2017-01-13	BBH	ETF	113.44	114.76	113.44	113.8	111600.0
2017-01-13	BBP	ETF	35.747	36.096	35.55	35.64	5300.0
2017-01-13	BCM	ETF	27.73	27.73	27.6645	27.71	2766.0

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

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