PREVIEW / etf_daily / 2016-11-18

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-18.parquet
  size:    53 KB
  rows:    1,350

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-11-18	SPY	ETF	219.07	219.27	218.29	218.5	86265800.0
2016-11-18	QQQ	ETF	117.83	118.1	117.21	117.32	16428659.0
2016-11-18	IWM	ETF	130.69	131.09	130.3	130.99	41380600.0
2016-11-18	DIA	ETF	188.9	188.96	188.32	188.46	4359200.0
2016-11-18	GLD	ETF	115.52	115.77	114.96	115.15	10444300.0
2016-11-18	TLT	ETF	121.63	121.97	120.34	120.85	13577700.0
2016-11-18	AADR	ETF	39.3	39.55	39.2	39.54	2500.0
2016-11-18	AAXJ	ETF	55.95	56.01	55.63	55.75	849600.0
2016-11-18	ACSI	ETF	26.2799	26.2799	26.2199	26.24	12591.0
2016-11-18	ACTX	ETF	21.2402	23.6002	18.8802	23.0102	3322.0
2016-11-18	ACWI	ETF	58.12	58.2	57.94	58.02	1469100.0
2016-11-18	ACWV	ETF	72.42	72.46	72.19	72.24	856000.0
2016-11-18	ACWX	ETF	39.54	39.55	39.3499	39.39	699972.0
2016-11-18	ADRE	ETF	32.6101	32.73	32.5215	32.62	6035.0
2016-11-18	AFK	ETF	19.45	19.63	19.115	19.63	4727.0
2016-11-18	AFTY	ETF	13.42	13.42	13.4	13.4	2200.0
2016-11-18	AGG	ETF	108.81	108.82	108.36	108.37	2767000.0
2016-11-18	AGGY	ETF	50.09	50.15	49.88	49.88	9300.0
2016-11-18	AGNG	ETF	15.555	15.555	15.555	15.555	200.0
2016-11-18	AGQ	ETF	35.51	35.7	34.64	35.2	150800.0
2016-11-18	AGZ	ETF	113.44	113.5432	113.12	113.25	16840.0
2016-11-18	AGZD	ETF	24.075	24.075	23.955	23.965	51400.0
2016-11-18	AIA	ETF	47.03	47.03	46.8	46.89	19648.0
2016-11-18	AIQ	ETF	7.8	7.95	7.7	7.75	13673.0
2016-11-18	AIRR	ETF	22.53	22.56	22.4	22.46	218600.0
2016-11-18	AIVI	ETF	36.01	36.01	35.79	35.84	27200.0
2016-11-18	ALTY	ETF	14.43	14.43	14.39	14.425	3700.0
2016-11-18	AMJ	ETF	30.6	30.74	30.36	30.72	2270094.0
2016-11-18	AMLP	ETF	61.4	61.45	60.9	61.4	1454440.0
2016-11-18	AMZA	ETF	110.0	110.0	109.0	109.9	13520.0
2016-11-18	ANGL	ETF	28.5	28.5	28.32	28.34	63500.0
2016-11-18	AOA	ETF	46.7	46.7	46.28	46.36	62000.0
2016-11-18	AOK	ETF	32.51	32.51	32.2401	32.31	232436.0
2016-11-18	AOM	ETF	35.18	35.2	34.9	34.99	148780.0
2016-11-18	AOR	ETF	40.23	40.29	39.937	39.95	106678.0
2016-11-18	ARGT	ETF	22.63	22.69	22.57	22.59	12500.0
2016-11-18	ARKG	ETF	18.85	18.89	18.56	18.68	7400.0
2016-11-18	ARKK	ETF	20.6	20.65	20.6	20.65	10100.0
2016-11-18	ARKQ	ETF	21.733	21.74	21.707	21.71	2100.0
2016-11-18	ARKW	ETF	26.0	26.0	25.588	25.663	4200.0
2016-11-18	ASEA	ETF	12.99	12.99	12.97	12.99	900.0
2016-11-18	ASET	ETF	24.71	24.71	24.7099	24.7099	1130.0
2016-11-18	ASHR	ETF	24.92	24.92	24.82	24.83	447100.0
2016-11-18	ASHS	ETF	34.95	34.98	34.76	34.76	13300.0
2016-11-18	ASHX	ETF	22.96	23.3841	22.96	23.375	770.0
2016-11-18	ATMP	ETF	22.98	23.07	22.74	23.07	96400.0
2016-11-18	BAB	ETF	29.4	29.562	29.26	29.28	550307.0
2016-11-18	BAL	ETF	47.78	47.79	47.41	47.4871	5960.0
2016-11-18	BBC	ETF	21.74	21.74	21.3201	21.63	6297.0
2016-11-18	BBH	ETF	113.84	113.84	111.82	111.91	76800.0

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

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