PREVIEW / etf_daily / 2016-10-26

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-26.parquet
  size:    52 KB
  rows:    1,303

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-10-26	SPY	ETF	213.21	214.42	212.93	213.74	75705500.0
2016-10-26	QQQ	ETF	118.41	119.03	118.03	118.38	20463696.0
2016-10-26	IWM	ETF	120.11	121.0	119.46	119.73	24975300.0
2016-10-26	DIA	ETF	180.6	182.12	180.35	181.77	5375400.0
2016-10-26	GLD	ETF	121.37	121.53	120.61	120.79	3905900.0
2016-10-26	TLT	ETF	132.46	132.8	131.99	132.18	5842500.0
2016-10-26	AADR	ETF	42.12	42.12	41.74	41.76	2600.0
2016-10-26	AAXJ	ETF	59.68	59.86	59.5	59.63	306400.0
2016-10-26	ACTX	ETF	14.7501	15.3401	10.6201	12.3901	3704.0
2016-10-26	ACWF	ETF	23.79	23.9	23.79	23.9	4409.0
2016-10-26	ACWI	ETF	58.29	58.45	58.12	58.26	1111600.0
2016-10-26	ACWV	ETF	73.92	74.08	73.78	73.91	75900.0
2016-10-26	ACWX	ETF	40.81	40.97	40.75	40.81	449796.0
2016-10-26	ADRE	ETF	35.81	35.8764	35.6	35.6648	6504.0
2016-10-26	AFK	ETF	20.23	20.8	20.23	20.49	2366.0
2016-10-26	AFTY	ETF	13.72	13.72	13.55	13.59	1400.0
2016-10-26	AGG	ETF	111.57	111.57	111.43	111.44	2684000.0
2016-10-26	AGGY	ETF	51.53	51.54	51.42	51.52	27900.0
2016-10-26	AGQ	ETF	40.84	40.95	40.1	40.3	102900.0
2016-10-26	AGZ	ETF	115.08	115.085	115.0001	115.055	12127.0
2016-10-26	AGZD	ETF	24.02	24.02	23.905	23.905	2600.0
2016-10-26	AIA	ETF	49.61	49.7621	49.435	49.48	15759.0
2016-10-26	AIQ	ETF	8.75	9.0999	8.7499	9.0	36458.0
2016-10-26	AIRR	ETF	19.4	19.58	19.387	19.387	25800.0
2016-10-26	AIVI	ETF	37.69	37.89	37.65	37.77	19200.0
2016-10-26	AMJ	ETF	30.65	30.93	30.51	30.89	1559132.0
2016-10-26	AMLP	ETF	62.45	62.65	61.85	62.55	1361300.0
2016-10-26	AMZA	ETF	108.0	108.8	107.3	108.6	31460.0
2016-10-26	ANGL	ETF	29.24	29.27	29.16	29.18	127200.0
2016-10-26	AOA	ETF	46.74	46.87	46.6	46.75	28900.0
2016-10-26	AOK	ETF	33.03	33.03	32.89	32.9766	27578.0
2016-10-26	AOM	ETF	35.56	35.6299	35.44	35.55	79271.0
2016-10-26	AOR	ETF	40.61	40.61	40.4	40.48	74197.0
2016-10-26	ARGT	ETF	24.29	24.29	23.95	24.08	51100.0
2016-10-26	ARKG	ETF	17.4	17.4	17.25	17.25	300.0
2016-10-26	ARKK	ETF	20.33	20.33	20.33	20.33	100.0
2016-10-26	ARKQ	ETF	21.283	21.283	21.283	21.283	200.0
2016-10-26	ARKW	ETF	24.96	25.01	24.928	24.928	600.0
2016-10-26	ASEA	ETF	13.73	13.73	13.73	13.73	300.0
2016-10-26	ASET	ETF	25.7	25.7499	25.7	25.7499	200.0
2016-10-26	ASHR	ETF	24.82	24.88	24.76	24.8	424800.0
2016-10-26	ASHS	ETF	35.01	35.09	34.98	34.98	4500.0
2016-10-26	ATMP	ETF	22.79	22.88	22.57	22.8	55100.0
2016-10-26	BAB	ETF	30.9	30.919	30.83	30.86	81711.0
2016-10-26	BAL	ETF	45.4399	46.1	45.4399	45.91	2935.0
2016-10-26	BBC	ETF	19.34	19.5	19.34	19.39	1922.0
2016-10-26	BBH	ETF	105.74	106.9	105.28	105.82	42600.0
2016-10-26	BBP	ETF	30.19	30.19	29.671	29.865	3700.0
2016-10-26	BFIT	ETF	15.1459	15.1459	15.1459	15.1459	100.0
2016-10-26	BFOR	ETF	7.8875	7.9025	7.8525	7.8525	21200.0

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

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