PREVIEW / etf_daily / 2016-07-29

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-29.parquet
  size:    51 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-07-29	SPY	ETF	216.46	217.54	216.13	217.12	79519400.0
2016-07-29	QQQ	ETF	115.24	115.54	114.87	115.23	22385320.0
2016-07-29	IWM	ETF	120.71	121.76	120.05	121.07	30267900.0
2016-07-29	DIA	ETF	183.85	184.5	183.54	184.13	4207300.0
2016-07-29	GLD	ETF	128.42	129.41	127.88	128.98	13708200.0
2016-07-29	TLT	ETF	140.45	141.68	140.22	141.56	8766700.0
2016-07-29	AADR	ETF	40.41	40.91	40.41	40.59	600.0
2016-07-29	AAXJ	ETF	57.41	57.71	57.25	57.64	1096800.0
2016-07-29	ACTX	ETF	3.54	3.54	2.95	3.54	233.0
2016-07-29	ACWI	ETF	58.12	58.42	58.02	58.35	1040900.0
2016-07-29	ACWV	ETF	77.52	77.92	77.44	77.76	235800.0
2016-07-29	ACWX	ETF	40.45	40.63	40.32	40.58	419945.0
2016-07-29	ADRE	ETF	32.83	32.83	32.6144	32.8285	7381.0
2016-07-29	AFK	ETF	20.47	20.8899	20.4001	20.85	8840.0
2016-07-29	AFTY	ETF	13.08	13.13	13.08	13.12	3800.0
2016-07-29	AGG	ETF	112.88	113.03	112.76	113.02	3671000.0
2016-07-29	AGGY	ETF	52.11	52.26	52.05	52.26	9600.0
2016-07-29	AGQ	ETF	54.75	55.46	53.67	55.21	314100.0
2016-07-29	AGZ	ETF	115.86	116.2386	115.7	115.95	16068.0
2016-07-29	AGZD	ETF	23.845	23.845	23.845	23.845	400.0
2016-07-29	AIA	ETF	47.0	47.24	46.86	47.18	71847.0
2016-07-29	AIQ	ETF	5.97	6.4	5.8901	5.96	17416.0
2016-07-29	AIRR	ETF	19.46	19.46	19.25	19.33	587200.0
2016-07-29	AIVI	ETF	38.69	38.91	38.54	38.88	13300.0
2016-07-29	ALTY	ETF	15.56	15.68	15.534	15.67	7200.0
2016-07-29	AMJ	ETF	31.55	31.95	31.35	31.91	1058816.0
2016-07-29	AMLP	ETF	63.35	64.15	63.2	64.15	618740.0
2016-07-29	AMZA	ETF	111.5	112.8	110.8	112.8	5090.0
2016-07-29	ANGL	ETF	28.21	28.22	28.09	28.16	134900.0
2016-07-29	AOA	ETF	46.82	47.13	46.81	47.08	16800.0
2016-07-29	AOK	ETF	33.2	33.4099	33.2	33.36	87872.0
2016-07-29	AOM	ETF	35.81	35.99	35.72	35.92	147350.0
2016-07-29	AOR	ETF	40.67	40.869	40.6504	40.86	40834.0
2016-07-29	ARGT	ETF	22.26	22.65	22.26	22.59	15900.0
2016-07-29	ARKG	ETF	18.68	18.73	18.38	18.73	1700.0
2016-07-29	ARKK	ETF	20.586	20.59	20.586	20.59	500.0
2016-07-29	ARKQ	ETF	20.73	20.73	20.73	20.73	300.0
2016-07-29	ARKW	ETF	24.081	24.081	24.081	24.081	400.0
2016-07-29	ASEA	ETF	13.96	14.06	13.96	14.02	4200.0
2016-07-29	ASHR	ETF	24.18	24.34	24.17	24.29	671500.0
2016-07-29	ASHS	ETF	34.19	34.25	34.12	34.25	13600.0
2016-07-29	ATMP	ETF	22.21	22.51	22.15	22.51	14100.0
2016-07-29	BAB	ETF	31.76	31.86	31.7301	31.8589	216792.0
2016-07-29	BAL	ETF	48.06	49.439	48.03	49.39	59605.0
2016-07-29	BBC	ETF	19.83	19.9912	19.49	19.9	4672.0
2016-07-29	BBH	ETF	114.05	115.4	113.64	115.35	114100.0
2016-07-29	BBP	ETF	30.61	30.965	30.35	30.965	4000.0
2016-07-29	BCM	ETF	25.775	25.89	25.721	25.86	32849.0
2016-07-29	BFIT	ETF	15.96	15.96	15.96	15.96	100.0
2016-07-29	BFOR	ETF	7.975	8.005	7.975	8.0	30800.0

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

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