PREVIEW / etf_daily / 2016-07-19

all etf daily files

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

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-07-19	SPY	ETF	215.92	216.23	215.63	216.19	54345700.0
2016-07-19	QQQ	ETF	112.17	112.48	111.93	112.13	18936702.0
2016-07-19	IWM	ETF	119.76	119.97	118.93	119.3	19734100.0
2016-07-19	DIA	ETF	185.01	185.42	184.82	185.42	2046300.0
2016-07-19	GLD	ETF	126.95	127.35	126.82	127.21	5170700.0
2016-07-19	TLT	ETF	138.94	139.31	138.4	139.04	8073900.0
2016-07-19	AADR	ETF	40.32	40.32	39.81	40.29	3300.0
2016-07-19	AAXJ	ETF	56.77	56.8	56.49	56.58	639200.0
2016-07-19	ACTX	ETF	4.13	4.13	3.54	4.13	160.0
2016-07-19	ACWF	ETF	23.75	23.75	23.47	23.5545	2455.0
2016-07-19	ACWI	ETF	57.64	57.69	57.49	57.62	1353300.0
2016-07-19	ACWV	ETF	77.36	77.49	77.25	77.47	209400.0
2016-07-19	ACWX	ETF	39.81	39.87	39.7	39.77	492376.0
2016-07-19	ADRE	ETF	32.57	32.59	32.46	32.5799	4316.0
2016-07-19	AFK	ETF	20.1731	20.5455	20.03	20.04	2324.0
2016-07-19	AFTY	ETF	12.97	13.12	12.97	13.01	8900.0
2016-07-19	AGG	ETF	112.48	112.52	112.37	112.51	1786900.0
2016-07-19	AGGY	ETF	52.02	52.08	52.0	52.06	4700.0
2016-07-19	AGQ	ETF	53.0	53.6	52.9	53.05	177300.0
2016-07-19	AGZ	ETF	115.4	115.6699	115.341	115.55	14174.0
2016-07-19	AGZD	ETF	23.87	23.915	23.86	23.895	18000.0
2016-07-19	AIA	ETF	46.51	46.51	46.3135	46.41	26453.0
2016-07-19	AIQ	ETF	6.32	6.32	6.15	6.15	11170.0
2016-07-19	AIRR	ETF	19.509	19.509	19.2	19.2	1500.0
2016-07-19	AIVI	ETF	38.14	38.21	38.03	38.1	46100.0
2016-07-19	ALTY	ETF	15.398	15.47	15.398	15.47	4200.0
2016-07-19	AMJ	ETF	32.14	32.28	31.83	32.14	753404.0
2016-07-19	AMLP	ETF	64.3	64.6	64.1	64.3	880920.0
2016-07-19	AMZA	ETF	112.8	113.5	112.0	113.49	5840.0
2016-07-19	ANGL	ETF	28.22	28.27	28.13	28.21	648100.0
2016-07-19	AOA	ETF	46.58	46.58	46.32	46.43	19100.0
2016-07-19	AOK	ETF	33.01	33.0699	33.007	33.06	46635.0
2016-07-19	AOM	ETF	35.63	35.6843	35.5	35.6	129525.0
2016-07-19	AOR	ETF	40.38	40.4099	40.29	40.38	83028.0
2016-07-19	ARGT	ETF	22.91	22.95	22.68	22.8	18000.0
2016-07-19	ARKG	ETF	17.82	17.82	17.82	17.82	100.0
2016-07-19	ARKK	ETF	20.09	20.09	20.09	20.09	100.0
2016-07-19	ARKQ	ETF	20.241	20.241	20.241	20.241	100.0
2016-07-19	ARKW	ETF	23.58	23.58	23.58	23.58	200.0
2016-07-19	ASEA	ETF	13.94	13.94	13.87	13.93	1900.0
2016-07-19	ASET	ETF	27.05	27.05	27.05	27.05	205.0
2016-07-19	ASHR	ETF	24.4	24.4	24.28	24.28	394500.0
2016-07-19	ASHS	ETF	35.05	35.33	35.05	35.17	53400.0
2016-07-19	ATMP	ETF	23.02	23.02	22.79	22.89	38500.0
2016-07-19	BAB	ETF	31.44	31.489	31.3301	31.46	69229.0
2016-07-19	BAL	ETF	49.3889	49.3889	48.51	48.965	8551.0
2016-07-19	BBC	ETF	18.5899	18.689	18.389	18.41	5174.0
2016-07-19	BBH	ETF	108.63	109.59	107.88	108.02	40400.0
2016-07-19	BBP	ETF	28.9	28.9	28.225	28.225	900.0
2016-07-19	BCM	ETF	26.73	26.73	26.656	26.7	25907.0

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

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