PREVIEW / etf_daily / 2016-07-08

all etf daily files

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

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-08	SPY	ETF	211.05	212.94	210.78	212.65	133971000.0
2016-07-08	QQQ	ETF	109.17	110.36	109.02	110.3	29457871.0
2016-07-08	IWM	ETF	115.25	117.09	115.15	116.79	37964800.0
2016-07-08	DIA	ETF	180.01	181.56	179.98	181.3	5177300.0
2016-07-08	GLD	ETF	129.85	130.52	128.97	130.52	17634200.0
2016-07-08	TLT	ETF	142.92	143.62	142.36	143.6	10355300.0
2016-07-08	AADR	ETF	39.57	39.57	38.95	39.19	3100.0
2016-07-08	AAXJ	ETF	54.58	55.06	54.51	54.99	644400.0
2016-07-08	ACTX	ETF	3.54	3.54	3.54	3.54	707.0
2016-07-08	ACWI	ETF	56.09	56.53	56.07	56.46	1191200.0
2016-07-08	ACWV	ETF	76.9	77.37	76.72	77.37	231900.0
2016-07-08	ACWX	ETF	38.61	38.81	38.53	38.77	475527.0
2016-07-08	ADRE	ETF	31.12	31.4	31.12	31.4	4061.0
2016-07-08	AFK	ETF	19.3001	20.3899	19.3001	20.27	27119.0
2016-07-08	AFTY	ETF	12.82	12.85	12.8	12.824	4500.0
2016-07-08	AGG	ETF	113.08	113.27	113.0	113.25	2910500.0
2016-07-08	AGGY	ETF	52.239	52.28	52.239	52.28	6200.0
2016-07-08	AGNG	ETF	15.41	15.41	15.41	15.41	100.0
2016-07-08	AGQ	ETF	52.86	54.84	52.0	54.84	559100.0
2016-07-08	AGZ	ETF	115.98	116.27	115.7	115.79	55081.0
2016-07-08	AGZD	ETF	23.705	23.845	23.66	23.845	1400.0
2016-07-08	AIA	ETF	44.5	44.85	44.5	44.82	33508.0
2016-07-08	AIQ	ETF	6.02	6.04	5.98	6.02	6123.0
2016-07-08	AIRR	ETF	18.801	18.95	18.73	18.95	2100.0
2016-07-08	AIVI	ETF	37.47	37.58	37.42	37.57	15600.0
2016-07-08	ALTY	ETF	15.16	15.16	15.155	15.155	400.0
2016-07-08	AMJ	ETF	31.44	31.69	31.12	31.53	1198813.0
2016-07-08	AMLP	ETF	63.3	63.8	63.05	63.6	1186920.0
2016-07-08	AMZA	ETF	108.9	109.7	107.1	108.9	19330.0
2016-07-08	ANGL	ETF	27.82	28.0	27.79	27.99	401100.0
2016-07-08	AOA	ETF	45.42	45.81	45.42	45.71	28900.0
2016-07-08	AOK	ETF	32.94	33.05	32.894	33.02	84547.0
2016-07-08	AOM	ETF	35.24	35.4199	35.24	35.41	54789.0
2016-07-08	AOR	ETF	39.84	40.03	39.751	39.98	66335.0
2016-07-08	ARGT	ETF	22.29	22.69	22.29	22.59	18700.0
2016-07-08	ARKG	ETF	17.805	17.805	17.76	17.76	400.0
2016-07-08	ARKK	ETF	20.03	20.03	20.03	20.03	200.0
2016-07-08	ARKQ	ETF	19.51	19.77	19.51	19.77	1300.0
2016-07-08	ARKW	ETF	22.85	22.92	22.85	22.92	4000.0
2016-07-08	ASEA	ETF	13.68	13.7	13.68	13.7	1800.0
2016-07-08	ASHR	ETF	23.97	24.13	23.97	24.11	792600.0
2016-07-08	ASHS	ETF	34.69	34.87	34.69	34.82	3200.0
2016-07-08	ATMP	ETF	22.13	22.21	21.95	22.09	15300.0
2016-07-08	BAB	ETF	31.86	31.8999	31.76	31.8664	385722.0
2016-07-08	BAL	ETF	43.66	44.0934	43.47	43.471	7478.0
2016-07-08	BBC	ETF	18.96	19.35	18.89	19.28	14255.0
2016-07-08	BBH	ETF	106.59	108.69	106.59	108.48	42500.0
2016-07-08	BBP	ETF	28.351	28.81	28.351	28.661	9000.0
2016-07-08	BCM	ETF	26.782	26.85	26.67	26.83	131446.0
2016-07-08	BFIT	ETF	15.29	15.46	15.29	15.46	2094.0

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

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