PREVIEW / etf_daily / 2016-04-04

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-04.parquet
  size:    50 KB
  rows:    1,252

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-04-04	SPY	ETF	206.83	207.07	205.89	206.25	63497000.0
2016-04-04	QQQ	ETF	110.31	110.435	109.68	109.94	17162988.0
2016-04-04	IWM	ETF	110.91	111.32	110.1	110.19	21529400.0
2016-04-04	DIA	ETF	177.63	177.88	176.88	177.12	2318900.0
2016-04-04	GLD	ETF	116.67	116.73	116.07	116.15	7643700.0
2016-04-04	TLT	ETF	130.79	130.97	130.27	130.76	5145100.0
2016-04-04	AADR	ETF	38.4	38.4	38.28	38.29	2200.0
2016-04-04	AAXJ	ETF	54.34	54.35	53.86	53.93	1810600.0
2016-04-04	ACTX	ETF	6.4901	6.4901	5.9001	6.4901	378.0
2016-04-04	ACWI	ETF	56.05	56.13	55.72	55.82	1094600.0
2016-04-04	ACWV	ETF	73.66	73.68	73.3	73.42	57000.0
2016-04-04	ACWX	ETF	39.19	39.24	38.93	38.97	331593.0
2016-04-04	ADRE	ETF	30.98	31.0	30.57	30.62	5024.0
2016-04-04	AFK	ETF	19.19	19.25	18.64	18.67	53875.0
2016-04-04	AFTY	ETF	13.031	13.031	13.02	13.02	500.0
2016-04-04	AGG	ETF	110.6	110.67	110.51	110.62	3176200.0
2016-04-04	AGGY	ETF	50.58	50.6	50.53	50.571	4200.0
2016-04-04	AGQ	ETF	31.28	31.43	30.78	30.79	134200.0
2016-04-04	AGZ	ETF	114.63	114.65	114.269	114.41	523650.0
2016-04-04	AGZD	ETF	23.755	23.855	23.735	23.805	18600.0
2016-04-04	AIA	ETF	42.96	42.96	42.59	42.6	11063.0
2016-04-04	AIQ	ETF	7.1	7.1	6.94	7.07	14110.0
2016-04-04	AIRR	ETF	17.57	17.57	17.494	17.494	1600.0
2016-04-04	AIVI	ETF	37.97	37.99	37.71	37.73	9000.0
2016-04-04	ALTY	ETF	14.381	14.381	14.167	14.167	1100.0
2016-04-04	AMJ	ETF	26.52	26.7	25.83	25.87	1015822.0
2016-04-04	AMLP	ETF	52.9	53.75	51.8	51.95	1090480.0
2016-04-04	AMZA	ETF	89.2	90.5	86.4	87.8	15910.0
2016-04-04	ANGL	ETF	25.71	25.72	25.56	25.67	66800.0
2016-04-04	AOA	ETF	45.14	45.14	44.88	44.97	94300.0
2016-04-04	AOK	ETF	32.27	32.29	32.147	32.2	28177.0
2016-04-04	AOM	ETF	34.6	34.6564	34.534	34.6	71582.0
2016-04-04	AOR	ETF	39.38	39.38	39.11	39.19	115334.0
2016-04-04	ARGT	ETF	19.29	19.29	19.0	19.09	60600.0
2016-04-04	ARKG	ETF	18.38	18.38	18.38	18.38	500.0
2016-04-04	ARKK	ETF	19.53	19.53	19.53	19.53	1000.0
2016-04-04	ARKQ	ETF	19.04	19.1	19.04	19.087	1300.0
2016-04-04	ARKW	ETF	20.81	20.86	20.71	20.807	2100.0
2016-04-04	ASET	ETF	25.4497	25.45	25.4497	25.45	609.0
2016-04-04	ASHR	ETF	24.58	24.77	24.47	24.49	847600.0
2016-04-04	ASHS	ETF	34.73	34.74	34.48	34.5	36800.0
2016-04-04	ATMP	ETF	17.56	17.8	17.26	17.31	34200.0
2016-04-04	BAB	ETF	30.18	30.2684	30.0511	30.07	264011.0
2016-04-04	BAL	ETF	38.91	38.91	38.5	38.54	16119.0
2016-04-04	BBC	ETF	19.69	20.48	19.69	19.98	41103.0
2016-04-04	BBH	ETF	106.61	108.34	106.34	106.96	180200.0
2016-04-04	BBP	ETF	25.15	25.65	25.15	25.23	7200.0
2016-04-04	BCM	ETF	23.864	23.864	23.752	23.752	1869.0
2016-04-04	BDCZ	ETF	20.55	20.55	20.55	20.55	500.0
2016-04-04	BFOR	ETF	7.58	7.585	7.525	7.525	103200.0

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

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