PREVIEW / etf_daily / 2016-08-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-01.parquet
  size:    52 KB
  rows:    1,295

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-08-01	SPY	ETF	217.19	217.65	216.41	216.94	73311400.0
2016-08-01	QQQ	ETF	115.31	118.7799	115.17	115.84	13990077.0
2016-08-01	IWM	ETF	121.2	121.7	120.44	121.17	34771700.0
2016-08-01	DIA	ETF	184.35	184.52	183.38	183.87	3295900.0
2016-08-01	GLD	ETF	128.57	129.34	128.56	129.22	7109900.0
2016-08-01	TLT	ETF	139.78	140.5	139.61	139.77	9809300.0
2016-08-01	AAXJ	ETF	57.99	57.99	57.62	57.67	938800.0
2016-08-01	ACTX	ETF	2.95	3.54	2.95	2.95	916.0
2016-08-01	ACWI	ETF	58.4	58.42	58.08	58.16	2180200.0
2016-08-01	ACWV	ETF	77.93	78.09	77.76	77.81	465100.0
2016-08-01	ACWX	ETF	40.56	40.57	40.3137	40.34	436043.0
2016-08-01	ADRE	ETF	32.82	33.059	32.82	32.9394	6686.0
2016-08-01	AFK	ETF	20.79	20.82	20.35	20.35	8978.0
2016-08-01	AFTY	ETF	12.96	13.03	12.96	12.99	6100.0
2016-08-01	AGG	ETF	112.5	112.68	112.47	112.55	3149300.0
2016-08-01	AGGY	ETF	52.09	52.13	51.07	52.077	14800.0
2016-08-01	AGQ	ETF	55.87	56.34	55.23	55.63	299100.0
2016-08-01	AGZ	ETF	115.57	115.779	115.53	115.7	10590.0
2016-08-01	AGZD	ETF	23.89	23.89	23.89	23.89	400.0
2016-08-01	AIA	ETF	47.4	47.59	47.33	47.393	39215.0
2016-08-01	AIQ	ETF	5.96	5.98	5.85	5.86	62784.0
2016-08-01	AIRR	ETF	19.12	19.27	19.11	19.197	7500.0
2016-08-01	AIVI	ETF	38.59	38.63	38.37	38.39	14800.0
2016-08-01	ALTY	ETF	15.52	15.56	15.52	15.54	4800.0
2016-08-01	AMJ	ETF	31.94	31.96	30.7	30.9	6419340.0
2016-08-01	AMLP	ETF	63.6	64.05	62.5	63.0	1557420.0
2016-08-01	AMZA	ETF	112.7	112.8	107.98	108.0	15910.0
2016-08-01	ANGL	ETF	28.05	28.06	27.89	27.92	212200.0
2016-08-01	AOA	ETF	46.98	47.26	46.81	46.94	33200.0
2016-08-01	AOK	ETF	33.37	33.429	33.2	33.28	59865.0
2016-08-01	AOM	ETF	35.85	35.92	35.7329	35.83	236703.0
2016-08-01	AOR	ETF	40.76	40.84	40.6301	40.73	75537.0
2016-08-01	ARGT	ETF	22.65	22.65	22.22	22.35	28200.0
2016-08-01	ARKG	ETF	19.0	19.07	18.98	19.031	1200.0
2016-08-01	ARKK	ETF	20.71	20.71	20.631	20.631	1200.0
2016-08-01	ARKQ	ETF	20.71	20.776	20.71	20.776	700.0
2016-08-01	ARKW	ETF	24.163	24.254	24.163	24.254	600.0
2016-08-01	ASEA	ETF	14.03	14.05	14.03	14.04	22100.0
2016-08-01	ASHR	ETF	24.0	24.09	23.84	23.85	944800.0
2016-08-01	ASHS	ETF	33.64	33.67	33.51	33.51	18100.0
2016-08-01	ATMP	ETF	22.23	22.23	21.77	21.82	14200.0
2016-08-01	BAB	ETF	31.74	31.779	31.67	31.67	196066.0
2016-08-01	BAL	ETF	49.53	50.0	49.0	49.4901	16625.0
2016-08-01	BBC	ETF	20.03	20.39	20.03	20.2137	52345.0
2016-08-01	BBH	ETF	115.54	118.46	115.54	117.52	157600.0
2016-08-01	BBP	ETF	30.99	31.64	30.99	31.37	4600.0
2016-08-01	BCM	ETF	25.4	25.452	25.4	25.452	785.0
2016-08-01	BFOR	ETF	7.9875	8.025	7.9675	7.99	348000.0
2016-08-01	BIB	ETF	49.09	51.45	49.09	50.53	1232998.0
2016-08-01	BIL	ETF	91.42	91.44	91.42	91.42	97000.0

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

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