PREVIEW / etf_daily / 2016-10-10

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-10.parquet
  size:    51 KB
  rows:    1,289

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-10-10	SPY	ETF	216.16	216.7	215.99	216.16	51855000.0
2016-10-10	QQQ	ETF	119.06	119.48	119.03	119.22	19687341.0
2016-10-10	IWM	ETF	122.83	124.74	122.83	124.3	21481700.0
2016-10-10	DIA	ETF	182.22	183.85	182.22	183.12	1879100.0
2016-10-10	GLD	ETF	119.74	120.42	119.74	120.16	4514400.0
2016-10-10	TLT	ETF	132.85	133.16	132.51	133.13	6089100.0
2016-10-10	AADR	ETF	40.41	40.57	40.41	40.41	1100.0
2016-10-10	AAXJ	ETF	60.95	61.37	60.95	61.22	525400.0
2016-10-10	ACTX	ETF	8.2601	8.8501	6.4901	7.6701	1622.0
2016-10-10	ACWI	ETF	59.01	59.2	59.0	59.04	636900.0
2016-10-10	ACWV	ETF	74.73	74.95	74.73	74.85	67300.0
2016-10-10	ACWX	ETF	41.34	41.53	41.32	41.43	214640.0
2016-10-10	ADRE	ETF	35.6	36.05	35.6	35.95	9679.0
2016-10-10	AFK	ETF	20.45	20.64	20.45	20.55	1825.0
2016-10-10	AFTY	ETF	13.69	13.69	13.51	13.51	900.0
2016-10-10	AGG	ETF	111.58	111.58	111.39	111.53	1295400.0
2016-10-10	AGGY	ETF	51.59	51.66	51.53	51.62	8500.0
2016-10-10	AGQ	ETF	40.48	40.92	40.35	40.44	138600.0
2016-10-10	AGZ	ETF	115.01	115.17	114.788	114.88	9853.0
2016-10-10	AGZD	ETF	23.995	24.105	23.995	24.105	13400.0
2016-10-10	AIA	ETF	50.82	51.02	50.82	50.95	44884.0
2016-10-10	AIQ	ETF	7.41	7.4489	7.21	7.41	19939.0
2016-10-10	AIRR	ETF	20.42	20.42	20.34	20.34	1500.0
2016-10-10	AIVI	ETF	38.46	38.71	38.46	38.6	13300.0
2016-10-10	ALTY	ETF	15.231	15.33	15.221	15.32	9900.0
2016-10-10	AMJ	ETF	30.88	31.365	30.78	31.28	889603.0
2016-10-10	AMLP	ETF	62.95	63.25	62.8	63.25	1301540.0
2016-10-10	AMZA	ETF	108.9	109.4	108.5	109.4	14600.0
2016-10-10	ANGL	ETF	29.03	29.08	28.97	29.05	239600.0
2016-10-10	AOA	ETF	47.16	47.34	47.16	47.23	15400.0
2016-10-10	AOK	ETF	33.15	33.1597	33.08	33.14	27339.0
2016-10-10	AOM	ETF	35.8	35.8519	35.6401	35.72	63808.0
2016-10-10	AOR	ETF	40.93	40.93	40.7587	40.81	42908.0
2016-10-10	ARGT	ETF	24.39	24.66	24.39	24.43	64300.0
2016-10-10	ARKG	ETF	19.401	19.54	19.401	19.524	500.0
2016-10-10	ARKK	ETF	21.9	21.9	21.9	21.9	100.0
2016-10-10	ARKQ	ETF	22.25	22.25	22.177	22.177	600.0
2016-10-10	ARKW	ETF	25.561	25.561	25.561	25.561	200.0
2016-10-10	ASEA	ETF	13.91	13.92	13.86	13.9	3500.0
2016-10-10	ASET	ETF	25.8347	25.86	25.8347	25.8357	1884.0
2016-10-10	ASHR	ETF	24.78	24.81	24.7	24.75	567800.0
2016-10-10	ASHS	ETF	34.8	35.19	34.8	35.1	9300.0
2016-10-10	ASHX	ETF	22.72	22.77	22.72	22.77	10000.0
2016-10-10	ATMP	ETF	23.16	23.2	23.16	23.2	3500.0
2016-10-10	BAB	ETF	30.94	30.998	30.92	30.98	86702.0
2016-10-10	BAL	ETF	44.76	45.0	44.5436	44.5436	21237.0
2016-10-10	BBC	ETF	22.1134	22.46	22.1134	22.444	12032.0
2016-10-10	BBH	ETF	113.86	114.61	113.86	114.08	44000.0
2016-10-10	BBP	ETF	33.49	33.848	33.49	33.66	5500.0
2016-10-10	BFOR	ETF	8.0725	8.13	8.0725	8.095	30800.0

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

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