PREVIEW / etf_daily / 2016-06-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-20.parquet
  size:    51 KB
  rows:    1,276

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-06-20	SPY	ETF	208.82	209.61	207.75	207.85	82789600.0
2016-06-20	QQQ	ETF	107.73	108.24	107.08	107.16	20562769.0
2016-06-20	IWM	ETF	115.8	116.45	115.3	115.3	28219800.0
2016-06-20	DIA	ETF	178.4	179.23	177.76	177.8	2958400.0
2016-06-20	GLD	ETF	122.26	123.33	122.13	123.21	11866200.0
2016-06-20	TLT	ETF	134.24	134.55	134.01	134.16	7365900.0
2016-06-20	AADR	ETF	39.21	39.21	37.79	38.32	1200.0
2016-06-20	AAXJ	ETF	53.9	54.17	53.79	53.84	415400.0
2016-06-20	ACTX	ETF	4.13	4.13	4.012	4.13	22.0
2016-06-20	ACWF	ETF	23.25	23.25	23.25	23.25	240.0
2016-06-20	ACWI	ETF	57.08	57.26	56.84	56.88	1194200.0
2016-06-20	ACWV	ETF	74.99	75.15	74.71	74.79	163800.0
2016-06-20	ACWX	ETF	40.15	40.205	39.95	39.97	593881.0
2016-06-20	ADRE	ETF	30.44	30.6913	30.44	30.46	2866.0
2016-06-20	AFK	ETF	20.05	20.62	19.68	19.68	92280.0
2016-06-20	AFTY	ETF	12.39	12.39	12.38	12.38	400.0
2016-06-20	AGG	ETF	111.57	111.58	111.45	111.48	2043800.0
2016-06-20	AGGY	ETF	51.03	51.16	51.03	51.108	1200.0
2016-06-20	AGQ	ETF	40.87	41.78	40.82	41.59	183600.0
2016-06-20	AGZ	ETF	115.38	115.4175	115.0774	115.17	11640.0
2016-06-20	AGZD	ETF	23.785	23.785	23.76	23.76	6600.0
2016-06-20	AIA	ETF	44.02	44.02	43.79	43.82	25991.0
2016-06-20	AIQ	ETF	6.38	6.53	6.26	6.33	22004.0
2016-06-20	AIRR	ETF	18.589	18.605	18.57	18.59	2700.0
2016-06-20	AIVI	ETF	38.19	38.19	37.89	37.93	47700.0
2016-06-20	ALTY	ETF	14.86	14.87	14.819	14.819	800.0
2016-06-20	AMJ	ETF	31.06	31.44	30.87	31.04	4665244.0
2016-06-20	AMLP	ETF	63.55	63.75	62.55	62.75	1426360.0
2016-06-20	AMZA	ETF	115.0	115.0	111.3	111.6	9070.0
2016-06-20	ANGL	ETF	27.34	27.39	27.12	27.3	135200.0
2016-06-20	AOA	ETF	46.09	46.1	45.76	45.84	11900.0
2016-06-20	AOK	ETF	32.7	32.7699	32.6106	32.65	43763.0
2016-06-20	AOM	ETF	35.22	35.414	35.09	35.19	137648.0
2016-06-20	AOR	ETF	40.0	40.0899	39.81	39.89	89056.0
2016-06-20	ARGT	ETF	22.04	22.32	22.0	22.2	37600.0
2016-06-20	ARKG	ETF	16.998	17.3	16.998	17.3	600.0
2016-06-20	ARKK	ETF	19.68	19.91	19.67	19.67	9800.0
2016-06-20	ARKQ	ETF	19.86	19.86	19.86	19.86	200.0
2016-06-20	ARKW	ETF	22.82	22.84	22.71	22.71	1900.0
2016-06-20	ASEA	ETF	13.25	13.3	13.22	13.22	6500.0
2016-06-20	ASET	ETF	26.42	26.42	26.42	26.42	100.0
2016-06-20	ASHR	ETF	23.43	23.62	23.43	23.47	1267200.0
2016-06-20	ASHS	ETF	33.34	33.48	33.31	33.35	73600.0
2016-06-20	ASHX	ETF	21.76	21.76	21.76	21.76	120.0
2016-06-20	ATMP	ETF	21.53	21.73	21.53	21.69	19000.0
2016-06-20	BAB	ETF	31.02	31.102	31.0	31.01	125982.0
2016-06-20	BAL	ETF	44.0202	44.0202	43.3001	43.53	4130.0
2016-06-20	BBC	ETF	18.59	19.0033	18.5	18.7	8770.0
2016-06-20	BBH	ETF	102.61	103.5	102.03	102.2	64500.0
2016-06-20	BBP	ETF	26.42	26.99	26.42	26.69	43000.0

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

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