PREVIEW / etf_daily / 2016-09-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-13.parquet
  size:    52 KB
  rows:    1,307

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-09-13	SPY	ETF	214.84	215.15	212.5	213.23	182828800.0
2016-09-13	QQQ	ETF	115.73	116.09	114.73	115.29	45863935.0
2016-09-13	IWM	ETF	122.06	122.16	119.88	120.58	47536200.0
2016-09-13	DIA	ETF	182.06	182.32	180.38	180.8	7477500.0
2016-09-13	GLD	ETF	126.47	126.6	125.53	125.75	8866400.0
2016-09-13	TLT	ETF	135.87	136.0	133.36	134.05	15645400.0
2016-09-13	AADR	ETF	39.45	39.45	38.84	39.0	2700.0
2016-09-13	AAXJ	ETF	58.76	58.9	58.04	58.32	1686000.0
2016-09-13	ACTX	ETF	3.54	4.13	3.54	3.54	1418.0
2016-09-13	ACWI	ETF	58.22	58.22	57.46	57.69	1543800.0
2016-09-13	ACWV	ETF	75.16	75.37	74.5	74.72	385700.0
2016-09-13	ACWX	ETF	40.8	40.84	40.29	40.45	631478.0
2016-09-13	ADRE	ETF	34.16	34.16	33.62	33.79	15083.0
2016-09-13	AFK	ETF	20.3	20.3	19.9	19.91	16833.0
2016-09-13	AFTY	ETF	13.38	13.397	13.38	13.397	1300.0
2016-09-13	AGG	ETF	111.93	111.93	111.34	111.51	3005400.0
2016-09-13	AGGY	ETF	51.69	51.8	51.4	51.62	10000.0
2016-09-13	AGQ	ETF	47.72	47.74	46.32	46.61	182500.0
2016-09-13	AGZ	ETF	115.16	115.3099	114.98	115.01	33122.0
2016-09-13	AIA	ETF	48.41	48.41	47.75	48.0	93057.0
2016-09-13	AIQ	ETF	6.57	6.63	6.52	6.53	6686.0
2016-09-13	AIRR	ETF	19.39	19.39	19.17	19.17	30500.0
2016-09-13	AIVI	ETF	38.49	38.49	38.01	38.2	19300.0
2016-09-13	ALTY	ETF	15.37	15.37	15.37	15.37	600.0
2016-09-13	AMJ	ETF	30.7	30.854	29.85	29.96	4808014.0
2016-09-13	AMLP	ETF	62.25	62.25	60.25	60.35	4025980.0
2016-09-13	AMZA	ETF	113.9	113.9	110.1	110.7	36050.0
2016-09-13	ANGL	ETF	28.44	28.44	28.22	28.24	240900.0
2016-09-13	AOA	ETF	46.9	46.9	46.41	46.53	61300.0
2016-09-13	AOK	ETF	33.1	33.1	32.8201	32.9199	75063.0
2016-09-13	AOM	ETF	35.79	35.79	35.4	35.56	75561.0
2016-09-13	AOR	ETF	40.72	40.72	40.26	40.41	51266.0
2016-09-13	ARGT	ETF	22.46	22.71	22.13	22.18	29800.0
2016-09-13	ARKG	ETF	18.7	18.7	18.7	18.7	300.0
2016-09-13	ARKK	ETF	20.58	20.61	20.58	20.607	700.0
2016-09-13	ARKQ	ETF	20.708	20.708	20.696	20.696	400.0
2016-09-13	ARKW	ETF	24.2	24.2	23.85	23.99	1300.0
2016-09-13	ASEA	ETF	13.74	13.74	13.7	13.7	700.0
2016-09-13	ASET	ETF	26.36	26.36	26.36	26.36	100.0
2016-09-13	ASHR	ETF	24.46	24.68	24.35	24.39	1246100.0
2016-09-13	ASHS	ETF	34.37	34.38	34.12	34.12	17500.0
2016-09-13	ATMP	ETF	22.53	22.53	22.18	22.25	27600.0
2016-09-13	BAB	ETF	31.38	31.4	31.04	31.09	641107.0
2016-09-13	BAL	ETF	44.1	44.8399	43.9399	44.36	22368.0
2016-09-13	BBC	ETF	20.68	20.68	20.0845	20.61	2350.0
2016-09-13	BBH	ETF	115.03	115.04	113.11	114.1	47200.0
2016-09-13	BBP	ETF	31.53	31.625	31.08	31.53	5500.0
2016-09-13	BCM	ETF	25.693	25.7	25.66	25.66	1710.0
2016-09-13	BFIT	ETF	15.6299	15.6299	15.6299	15.6299	133.0
2016-09-13	BFOR	ETF	7.9925	7.9925	7.9025	7.9475	34800.0

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

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