PREVIEW / etf_daily / 2015-08-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-20.parquet
  size:    49 KB
  rows:    1,212

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
2015-08-20	SPY	ETF	206.51	208.29	203.9	203.97	194327900.0
2015-08-20	QQQ	ETF	109.11	109.46	107.07	107.08	57747349.0
2015-08-20	IWM	ETF	118.34	118.61	116.39	116.39	51879800.0
2015-08-20	DIA	ETF	172.25	172.55	170.22	170.22	12317200.0
2015-08-20	GLD	ETF	109.81	110.61	109.7	110.44	12549000.0
2015-08-20	TLT	ETF	125.37	126.1	125.18	126.02	9078300.0
2015-08-20	AADR	ETF	38.5	38.5	37.61	37.61	2800.0
2015-08-20	AAXJ	ETF	54.13	54.27	53.8	53.83	2665700.0
2015-08-20	ACTX	ETF	1.77	1.77	1.475	1.77	1261.0
2015-08-20	ACWI	ETF	57.98	58.03	57.19	57.19	1190800.0
2015-08-20	ACWV	ETF	70.34	70.49	69.8	69.83	151900.0
2015-08-20	ACWX	ETF	41.96	42.04	41.49	41.52	947673.0
2015-08-20	ADRE	ETF	30.46	30.555	30.2	30.25	15024.0
2015-08-20	AFK	ETF	20.94	21.1599	20.51	20.58	86226.0
2015-08-20	AFTY	ETF	16.84	16.84	16.47	16.47	59300.0
2015-08-20	AGG	ETF	109.58	109.64	109.45	109.57	1075600.0
2015-08-20	AGQ	ETF	35.44	35.5	34.92	35.01	259200.0
2015-08-20	AGZ	ETF	113.6	113.668	113.463	113.5855	4831.0
2015-08-20	AGZD	ETF	24.165	24.19	24.11	24.12	7000.0
2015-08-20	AIA	ETF	43.01	43.085	42.68	42.69	63831.0
2015-08-20	AIQ	ETF	14.71	14.87	14.7	14.7	22482.0
2015-08-20	AIRR	ETF	16.61	16.61	16.39	16.39	5700.0
2015-08-20	AIVI	ETF	41.67	41.67	41.06	41.06	42700.0
2015-08-20	AMJ	ETF	36.36	36.685	35.64	35.76	2769127.0
2015-08-20	AMLP	ETF	72.5	73.0	71.45	71.65	2803320.0
2015-08-20	AMZA	ETF	167.9	167.9	161.3	161.3	3360.0
2015-08-20	ANGL	ETF	26.8	26.97	26.4	26.46	12300.0
2015-08-20	AOA	ETF	46.16	46.25	45.67	45.67	54700.0
2015-08-20	AOK	ETF	32.13	32.2794	32.06	32.06	24944.0
2015-08-20	AOM	ETF	34.79	34.8492	34.56	34.56	104645.0
2015-08-20	AOR	ETF	39.9	39.9	39.52	39.53	34596.0
2015-08-20	ARGT	ETF	18.11	18.11	17.84	17.91	14300.0
2015-08-20	ARKG	ETF	21.27	21.36	20.89	20.89	1700.0
2015-08-20	ARKK	ETF	20.03	20.03	19.89	19.89	1400.0
2015-08-20	ARKQ	ETF	18.517	18.52	18.336	18.336	2400.0
2015-08-20	ARKW	ETF	22.99	23.0	22.28	22.33	9700.0
2015-08-20	ASEA	ETF	12.96	13.04	12.85	12.86	3900.0
2015-08-20	ASHR	ETF	37.01	37.06	36.6	36.66	3253500.0
2015-08-20	ASHS	ETF	47.78	47.78	47.11	47.39	47800.0
2015-08-20	ATMP	ETF	24.87	24.87	24.26	24.26	23400.0
2015-08-20	AWAY	ETF	31.01	31.14	29.95	29.98	1145185.0
2015-08-20	BAB	ETF	29.27	29.349	29.25	29.29	170474.0
2015-08-20	BAL	ETF	44.602	44.89	44.602	44.78	5217.0
2015-08-20	BBC	ETF	31.62	31.9545	30.33	30.44	33973.0
2015-08-20	BBH	ETF	134.27	135.07	130.4	130.46	209800.0
2015-08-20	BBP	ETF	33.59	33.756	32.41	32.45	65100.0
2015-08-20	BCHP	ETF	18.37	18.37	18.37	18.37	100.0
2015-08-20	BCM	ETF	26.77	26.96	26.77	26.85	17336.0
2015-08-20	BFOR	ETF	8.035	8.035	7.9025	7.9025	86400.0
2015-08-20	BIB	ETF	85.79	87.33	80.65	80.79	1301251.0

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

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