PREVIEW / etf_daily / 2016-05-09

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-09.parquet
  size:    50 KB
  rows:    1,265

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-05-09	SPY	ETF	205.57	206.4	205.36	205.89	74374900.0
2016-05-09	QQQ	ETF	105.61	106.37	105.54	105.88	19289615.0
2016-05-09	IWM	ETF	110.92	111.89	110.63	111.23	23427000.0
2016-05-09	DIA	ETF	177.25	177.76	176.62	176.98	1921700.0
2016-05-09	GLD	ETF	121.2	121.29	120.59	120.65	9236200.0
2016-05-09	TLT	ETF	130.46	130.89	130.32	130.86	4950800.0
2016-05-09	AADR	ETF	37.72	37.97	37.72	37.97	700.0
2016-05-09	AAXJ	ETF	52.13	52.13	51.64	51.68	513100.0
2016-05-09	ACTX	ETF	4.72	4.72	4.071	4.13	73.0
2016-05-09	ACWI	ETF	55.96	56.1	55.76	55.85	889100.0
2016-05-09	ACWV	ETF	73.68	73.89	73.64	73.77	150500.0
2016-05-09	ACWX	ETF	39.5	39.56	39.2442	39.29	325550.0
2016-05-09	ADRE	ETF	30.08	30.08	29.6	29.91	12424.0
2016-05-09	AFK	ETF	20.17	20.47	19.7699	19.95	50916.0
2016-05-09	AFTY	ETF	12.22	12.246	12.16	12.16	1700.0
2016-05-09	AGG	ETF	111.11	111.14	111.01	111.04	2173500.0
2016-05-09	AGGY	ETF	50.996	51.13	50.94	50.95	22700.0
2016-05-09	AGQ	ETF	40.1	40.1	39.2	39.36	206900.0
2016-05-09	AGZ	ETF	114.9	115.0	114.76	114.94	10240.0
2016-05-09	AGZD	ETF	23.98	23.98	23.945	23.945	1000.0
2016-05-09	AIA	ETF	41.49	41.53	41.19	41.19	12290.0
2016-05-09	AIQ	ETF	6.74	6.74	6.5001	6.55	29800.0
2016-05-09	AIVI	ETF	38.55	38.55	38.29	38.29	11600.0
2016-05-09	ALTY	ETF	14.549	14.562	14.549	14.562	500.0
2016-05-09	AMJ	ETF	29.39	29.628	28.55	29.18	4755703.0
2016-05-09	AMLP	ETF	60.05	60.4	58.1	59.55	3857900.0
2016-05-09	AMZA	ETF	105.0	105.0	98.1	101.4	18460.0
2016-05-09	ANGL	ETF	26.72	26.72	26.56	26.58	69300.0
2016-05-09	AOA	ETF	45.17	45.28	45.01	45.13	33700.0
2016-05-09	AOK	ETF	32.38	32.386	32.27	32.34	39542.0
2016-05-09	AOM	ETF	34.84	34.8599	34.72	34.78	71802.0
2016-05-09	AOR	ETF	39.28	39.4399	39.28	39.32	55213.0
2016-05-09	ARGT	ETF	20.36	20.43	20.1	20.21	82200.0
2016-05-09	ARKG	ETF	17.16	17.16	17.16	17.16	100.0
2016-05-09	ARKK	ETF	18.31	18.31	18.252	18.3	800.0
2016-05-09	ARKQ	ETF	18.48	18.48	18.02	18.02	600.0
2016-05-09	ARKW	ETF	20.448	20.453	20.41	20.41	2700.0
2016-05-09	ASEA	ETF	12.82	12.82	12.64	12.68	142300.0
2016-05-09	ASHR	ETF	22.91	22.91	22.65	22.72	3221300.0
2016-05-09	ASHS	ETF	31.67	31.7	31.22	31.5	49300.0
2016-05-09	ASHX	ETF	20.22	20.22	20.22	20.22	130.0
2016-05-09	ATMP	ETF	20.03	20.13	19.79	20.13	24900.0
2016-05-09	BAB	ETF	30.39	30.4	30.35	30.37	144430.0
2016-05-09	BAL	ETF	40.7	40.74	40.53	40.6601	4495.0
2016-05-09	BBC	ETF	17.82	18.5399	17.82	18.53	9316.0
2016-05-09	BBH	ETF	103.28	106.27	103.28	105.55	71100.0
2016-05-09	BBP	ETF	24.44	25.405	24.44	25.405	2900.0
2016-05-09	BCM	ETF	25.48	25.4899	25.42	25.42	5650.0
2016-05-09	BDCZ	ETF	19.97	19.97	19.97	19.97	200.0
2016-05-09	BFOR	ETF	7.4625	7.5375	7.4625	7.5075	42800.0

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

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