PREVIEW / etf_daily / 2016-08-19

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-19.parquet
  size:    51 KB
  rows:    1,288

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-19	SPY	ETF	218.31	218.75	217.74	218.54	75443000.0
2016-08-19	QQQ	ETF	117.1	117.52	116.76	117.26	18742961.0
2016-08-19	IWM	ETF	122.77	123.07	122.28	122.94	17379500.0
2016-08-19	DIA	ETF	185.3	185.65	184.72	185.32	2368500.0
2016-08-19	GLD	ETF	128.08	128.67	127.86	127.97	10660100.0
2016-08-19	TLT	ETF	138.64	139.05	138.1	138.71	5516300.0
2016-08-19	AADR	ETF	40.97	41.08	40.85	40.85	2700.0
2016-08-19	AAXJ	ETF	59.26	59.54	59.03	59.47	506700.0
2016-08-19	ACTX	ETF	3.54	4.13	2.95	3.481	1001.0
2016-08-19	ACWI	ETF	59.02	59.23	58.91	59.17	768000.0
2016-08-19	ACWV	ETF	77.17	77.19	76.9	77.14	80900.0
2016-08-19	ACWX	ETF	41.27	41.4066	41.15	41.37	304917.0
2016-08-19	ADRE	ETF	34.5	34.59	34.46	34.55	2964.0
2016-08-19	AFK	ETF	21.0849	21.37	20.9101	21.37	7579.0
2016-08-19	AFTY	ETF	13.648	13.66	13.648	13.66	600.0
2016-08-19	AGG	ETF	112.53	112.62	112.39	112.48	3287600.0
2016-08-19	AGGY	ETF	52.122	52.15	52.08	52.13	8300.0
2016-08-19	AGQ	ETF	49.69	50.04	49.23	49.32	180800.0
2016-08-19	AGZ	ETF	115.46	115.65	115.34	115.5	35691.0
2016-08-19	AGZD	ETF	23.955	23.995	23.875	23.995	4200.0
2016-08-19	AIA	ETF	48.51	48.63	48.32	48.61	30531.0
2016-08-19	AIQ	ETF	6.215	6.215	6.15	6.19	11449.0
2016-08-19	AIRR	ETF	19.62	19.67	19.62	19.65	1000.0
2016-08-19	AIVI	ETF	39.12	39.23	39.01	39.23	28000.0
2016-08-19	ALTY	ETF	15.78	15.78	15.66	15.698	2300.0
2016-08-19	AMJ	ETF	32.33	32.385	31.98	32.03	1617529.0
2016-08-19	AMLP	ETF	64.05	64.1	63.45	63.55	1070240.0
2016-08-19	AMZA	ETF	117.1	117.7	116.3	116.9	11570.0
2016-08-19	ANGL	ETF	28.68	28.72	28.65	28.7	159400.0
2016-08-19	AOA	ETF	47.32	47.75	47.31	47.5	25800.0
2016-08-19	AOK	ETF	33.41	33.4699	33.15	33.41	32560.0
2016-08-19	AOM	ETF	36.07	36.105	35.92	36.06	78693.0
2016-08-19	AOR	ETF	40.97	41.1199	40.95	41.09	35150.0
2016-08-19	ARGT	ETF	23.02	23.06	22.88	22.92	13900.0
2016-08-19	ARKG	ETF	18.73	18.73	18.73	18.73	100.0
2016-08-19	ARKK	ETF	21.08	21.08	21.08	21.08	100.0
2016-08-19	ARKQ	ETF	21.41	21.48	21.41	21.48	1600.0
2016-08-19	ARKW	ETF	24.4	24.571	24.4	24.571	1800.0
2016-08-19	ASEA	ETF	14.24	14.25	14.22	14.22	700.0
2016-08-19	ASHR	ETF	25.47	25.58	25.44	25.51	906000.0
2016-08-19	ASHS	ETF	35.62	35.68	35.58	35.62	18000.0
2016-08-19	ATMP	ETF	23.46	23.46	23.28	23.4	47500.0
2016-08-19	BAB	ETF	31.61	31.62	31.51	31.54	269020.0
2016-08-19	BAL	ETF	45.15	45.28	44.98	44.98	7667.0
2016-08-19	BBC	ETF	20.53	20.53	20.44	20.44	3318.0
2016-08-19	BBH	ETF	115.28	115.9	114.9	115.26	23700.0
2016-08-19	BBP	ETF	30.83	30.93	30.72	30.78	7600.0
2016-08-19	BCM	ETF	26.93	27.03	26.9	27.03	20958.0
2016-08-19	BFOR	ETF	8.0025	8.0625	8.0025	8.0575	48400.0
2016-08-19	BIB	ETF	49.33	49.66	48.76	49.18	343507.0

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

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