PREVIEW / etf_daily / 2016-08-31

all etf daily files

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

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-31	SPY	ETF	217.61	217.75	216.47	217.38	85269500.0
2016-08-31	QQQ	ETF	116.38	116.56	115.95	116.44	16169794.0
2016-08-31	IWM	ETF	123.78	123.89	122.55	123.23	29236300.0
2016-08-31	DIA	ETF	184.25	184.36	183.27	183.94	1876400.0
2016-08-31	GLD	ETF	124.73	125.11	124.64	124.78	13324100.0
2016-08-31	TLT	ETF	139.66	140.17	139.34	139.87	7349700.0
2016-08-31	AADR	ETF	40.45	40.45	40.06	40.16	19300.0
2016-08-31	AAXJ	ETF	58.94	58.94	58.53	58.68	641400.0
2016-08-31	ACTX	ETF	3.54	3.54	2.95	2.95	711.0
2016-08-31	ACWI	ETF	58.68	58.75	58.35	58.55	2641900.0
2016-08-31	ACWV	ETF	75.85	75.9	75.59	75.84	203900.0
2016-08-31	ACWX	ETF	40.94	41.0	40.73	40.87	175182.0
2016-08-31	ADRE	ETF	34.25	34.25	33.9105	34.01	4060.0
2016-08-31	AFK	ETF	20.04	20.39	20.0	20.24	10390.0
2016-08-31	AGG	ETF	112.64	112.71	112.51	112.57	3025000.0
2016-08-31	AGGY	ETF	52.112	52.24	52.07	52.14	6300.0
2016-08-31	AGQ	ETF	45.79	46.35	45.76	45.91	83200.0
2016-08-31	AGZ	ETF	115.68	115.755	115.4901	115.67	54646.0
2016-08-31	AGZD	ETF	23.915	24.035	23.895	23.975	2200.0
2016-08-31	AIA	ETF	48.41	48.45	48.13	48.29	31421.0
2016-08-31	AIQ	ETF	6.35	6.35	6.3	6.3	24131.0
2016-08-31	AIRR	ETF	19.82	19.82	19.59	19.72	23100.0
2016-08-31	AIVI	ETF	38.72	38.81	38.53	38.62	46000.0
2016-08-31	ALTY	ETF	15.77	15.77	15.71	15.72	3400.0
2016-08-31	AMJ	ETF	30.98	31.04	30.63	31.0	1650599.0
2016-08-31	AMLP	ETF	62.65	62.75	62.15	62.65	848580.0
2016-08-31	AMZA	ETF	115.4	115.4	113.5	114.4	10240.0
2016-08-31	ANGL	ETF	28.83	28.83	28.71	28.73	104800.0
2016-08-31	AOA	ETF	47.26	47.27	47.02	47.2	28100.0
2016-08-31	AOK	ETF	33.3	33.42	33.2601	33.31	64417.0
2016-08-31	AOM	ETF	35.93	36.0499	35.8319	35.96	93657.0
2016-08-31	AOR	ETF	41.1	41.1	40.761	40.89	75439.0
2016-08-31	ARGT	ETF	22.51	22.6	22.36	22.48	131800.0
2016-08-31	ARKG	ETF	18.005	18.005	18.005	18.005	400.0
2016-08-31	ARKK	ETF	20.87	20.87	20.614	20.614	200.0
2016-08-31	ARKQ	ETF	21.5	21.5	21.14	21.14	1000.0
2016-08-31	ARKW	ETF	24.322	24.38	24.322	24.38	500.0
2016-08-31	ASEA	ETF	14.02	14.02	13.95	13.95	3700.0
2016-08-31	ASHR	ETF	25.17	25.18	25.09	25.15	580100.0
2016-08-31	ASHS	ETF	35.13	35.2	35.12	35.17	1300.0
2016-08-31	ATMP	ETF	22.54	22.54	22.31	22.47	12100.0
2016-08-31	BAB	ETF	31.75	31.75	31.59	31.6	274407.0
2016-08-31	BAL	ETF	43.46	43.7753	43.29	43.29	15042.0
2016-08-31	BBC	ETF	20.35	20.35	19.95	20.02	3488.0
2016-08-31	BBH	ETF	114.01	114.35	113.42	113.69	37400.0
2016-08-31	BBP	ETF	30.354	30.45	30.16	30.22	3400.0
2016-08-31	BCM	ETF	26.02	26.02	25.575	25.575	14383.0
2016-08-31	BFOR	ETF	8.1	8.1175	8.0575	8.105	15600.0
2016-08-31	BIB	ETF	46.47	46.72	45.5153	45.88	456003.0
2016-08-31	BIL	ETF	91.44	91.46	91.42	91.44	190000.0

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

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