PREVIEW / etf_daily / 2016-08-11

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-11.parquet
  size:    51 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-11	SPY	ETF	218.26	218.94	217.95	218.65	72504300.0
2016-08-11	QQQ	ETF	117.01	117.37	116.78	117.12	12969799.0
2016-08-11	IWM	ETF	122.03	122.4	121.57	122.07	21144600.0
2016-08-11	DIA	ETF	185.7	186.58	185.6	186.3	2188700.0
2016-08-11	GLD	ETF	128.61	129.19	127.48	127.67	9763800.0
2016-08-11	TLT	ETF	140.06	140.08	138.54	138.91	7624600.0
2016-08-11	AADR	ETF	41.03	41.2	41.03	41.2	800.0
2016-08-11	AAXJ	ETF	59.03	59.59	59.03	59.54	733200.0
2016-08-11	ACTX	ETF	3.245	3.54	2.891	2.891	907.0
2016-08-11	ACWF	ETF	24.2	24.2	24.2	24.2	300.0
2016-08-11	ACWI	ETF	59.07	59.27	58.98	59.22	658400.0
2016-08-11	ACWV	ETF	78.12	78.17	77.95	78.1	245700.0
2016-08-11	ACWX	ETF	41.29	41.52	41.29	41.49	173717.0
2016-08-11	ADRE	ETF	33.99	34.2599	33.99	34.23	6139.0
2016-08-11	AFK	ETF	20.99	21.48	20.99	21.19	16986.0
2016-08-11	AFTY	ETF	13.32	13.34	13.3	13.33	6900.0
2016-08-11	AGG	ETF	112.73	112.73	112.31	112.36	1807200.0
2016-08-11	AGGY	ETF	52.23	52.23	51.98	52.03	18800.0
2016-08-11	AGQ	ETF	53.96	54.5	52.73	52.81	240900.0
2016-08-11	AGZ	ETF	115.77	116.05	115.3169	115.38	10171.0
2016-08-11	AGZD	ETF	23.765	23.905	23.765	23.905	4000.0
2016-08-11	AIA	ETF	48.39	48.61	48.2903	48.52	73999.0
2016-08-11	AIQ	ETF	6.11	6.19	6.08	6.14	25767.0
2016-08-11	AIRR	ETF	19.58	19.607	19.552	19.552	500.0
2016-08-11	AIVI	ETF	39.19	39.4	39.19	39.23	8000.0
2016-08-11	ALTY	ETF	15.9	15.9	15.559	15.559	1800.0
2016-08-11	AMJ	ETF	31.65	31.95	31.56	31.77	1487590.0
2016-08-11	AMLP	ETF	63.2	63.2	62.65	63.0	999040.0
2016-08-11	AMZA	ETF	113.5	115.1	113.5	114.8	14800.0
2016-08-11	ANGL	ETF	28.49	28.49	28.41	28.46	270100.0
2016-08-11	AOA	ETF	47.39	47.59	47.35	47.56	21300.0
2016-08-11	AOK	ETF	33.42	33.44	33.3575	33.38	48306.0
2016-08-11	AOM	ETF	35.98	36.1295	35.98	36.03	128461.0
2016-08-11	AOR	ETF	41.03	41.1262	41.0201	41.09	42613.0
2016-08-11	ARGT	ETF	23.25	23.31	22.84	23.27	19900.0
2016-08-11	ARKG	ETF	18.92	18.92	18.91	18.91	200.0
2016-08-11	ARKK	ETF	21.105	21.105	21.105	21.105	100.0
2016-08-11	ARKQ	ETF	21.05	21.33	21.05	21.305	4300.0
2016-08-11	ARKW	ETF	24.541	24.674	24.541	24.674	1500.0
2016-08-11	ASEA	ETF	14.21	14.31	14.21	14.31	900.0
2016-08-11	ASET	ETF	27.2368	27.25	27.2368	27.2387	300.0
2016-08-11	ASHR	ETF	24.53	24.63	24.47	24.57	864600.0
2016-08-11	ASHS	ETF	34.17	34.27	34.12	34.18	27400.0
2016-08-11	ASHX	ETF	22.3	22.3	22.3	22.3	100.0
2016-08-11	ATMP	ETF	22.64	22.99	22.64	22.97	21100.0
2016-08-11	BAB	ETF	31.74	31.75	31.56	31.57	228925.0
2016-08-11	BAL	ETF	47.7	48.079	47.54	47.97	16812.0
2016-08-11	BBC	ETF	20.25	20.3899	20.0	20.2705	5927.0
2016-08-11	BBH	ETF	115.01	115.85	114.47	115.68	40600.0
2016-08-11	BBP	ETF	30.6	30.81	30.353	30.75	7200.0

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

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