PREVIEW / etf_daily / 2016-05-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-13.parquet
  size:    51 KB
  rows:    1,284

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-13	SPY	ETF	206.21	206.86	204.38	204.76	96474600.0
2016-05-13	QQQ	ETF	105.85	106.449	105.29	105.5	21059255.0
2016-05-13	IWM	ETF	110.06	110.94	109.36	109.64	24510300.0
2016-05-13	DIA	ETF	176.9	177.52	175.26	175.48	3336800.0
2016-05-13	GLD	ETF	121.09	121.86	120.66	121.71	7672800.0
2016-05-13	TLT	ETF	131.48	132.32	131.23	132.28	8707300.0
2016-05-13	AADR	ETF	37.92	37.92	37.9	37.92	1500.0
2016-05-13	AAXJ	ETF	51.55	51.75	51.12	51.21	893300.0
2016-05-13	ACTX	ETF	4.13	4.72	4.13	4.13	260.0
2016-05-13	ACWF	ETF	22.84	22.84	22.72	22.72	535.0
2016-05-13	ACWI	ETF	55.9	56.12	55.52	55.6	1168400.0
2016-05-13	ACWV	ETF	73.9	74.04	73.46	73.59	116400.0
2016-05-13	ACWX	ETF	39.27	39.44	39.04	39.1	374912.0
2016-05-13	ADRE	ETF	29.95	29.95	29.61	29.61	2023.0
2016-05-13	AFK	ETF	20.4705	20.4705	19.86	19.87	78036.0
2016-05-13	AGG	ETF	111.08	111.23	111.03	111.2	1511400.0
2016-05-13	AGGY	ETF	51.003	51.18	51.003	51.16	6400.0
2016-05-13	AGQ	ETF	39.48	40.03	39.04	39.93	112900.0
2016-05-13	AGZ	ETF	115.5	115.5	114.7701	115.05	17168.0
2016-05-13	AGZD	ETF	23.92	23.92	23.92	23.92	200.0
2016-05-13	AIA	ETF	40.8	40.8	40.4	40.46	17068.0
2016-05-13	AIQ	ETF	6.83	7.94	6.83	7.83	37244.0
2016-05-13	AIRR	ETF	17.67	17.67	17.42	17.44	1400.0
2016-05-13	AIVI	ETF	38.05	38.22	37.92	38.06	31900.0
2016-05-13	ALTY	ETF	14.682	14.682	14.682	14.682	100.0
2016-05-13	AMJ	ETF	29.65	30.19	29.65	29.76	1236772.0
2016-05-13	AMLP	ETF	59.5	60.45	59.2	59.5	1308060.0
2016-05-13	AMZA	ETF	104.3	105.7	103.0	103.8	7490.0
2016-05-13	ANGL	ETF	26.85	26.85	26.67	26.67	56200.0
2016-05-13	AOA	ETF	45.28	45.28	44.84	44.97	38900.0
2016-05-13	AOK	ETF	32.3	32.39	32.25	32.35	123801.0
2016-05-13	AOM	ETF	34.81	34.84	34.6843	34.75	75991.0
2016-05-13	AOR	ETF	39.33	39.425	39.2	39.25	33572.0
2016-05-13	ARGT	ETF	20.8	20.93	20.5	20.5	50900.0
2016-05-13	ARKG	ETF	16.565	16.565	16.565	16.565	300.0
2016-05-13	ARKK	ETF	18.12	18.12	18.11	18.11	700.0
2016-05-13	ARKQ	ETF	18.07	18.07	18.07	18.07	100.0
2016-05-13	ARKW	ETF	20.44	20.44	20.363	20.363	2400.0
2016-05-13	ASEA	ETF	12.78	12.78	12.78	12.78	800.0
2016-05-13	ASHR	ETF	22.94	23.01	22.78	22.8	1220600.0
2016-05-13	ASHS	ETF	31.49	31.55	31.09	31.2	71300.0
2016-05-13	ASHX	ETF	20.5892	20.5892	20.5892	20.5892	250.0
2016-05-13	ATMP	ETF	20.61	21.06	20.37	20.55	18300.0
2016-05-13	BAB	ETF	30.56	30.59	30.48	30.59	85664.0
2016-05-13	BAL	ETF	40.076	40.28	39.8542	40.2282	4954.0
2016-05-13	BBC	ETF	17.54	17.7534	17.406	17.406	2863.0
2016-05-13	BBH	ETF	101.79	103.75	101.79	102.83	76600.0
2016-05-13	BBP	ETF	24.02	24.51	24.02	24.51	2000.0
2016-05-13	BCM	ETF	26.38	26.38	26.38	26.38	700.0
2016-05-13	BFOR	ETF	7.4425	7.4675	7.3775	7.3975	270000.0

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

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