PREVIEW / etf_daily / 2016-11-03

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-03.parquet
  size:    52 KB
  rows:    1,318

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-03	SPY	ETF	209.99	210.24	208.46	208.78	88939300.0
2016-11-03	QQQ	ETF	115.02	115.37	113.92	114.05	36205193.0
2016-11-03	IWM	ETF	115.91	116.24	114.88	115.0	22717500.0
2016-11-03	DIA	ETF	179.7	179.89	178.84	179.11	1966900.0
2016-11-03	GLD	ETF	123.36	124.33	123.35	124.3	10093100.0
2016-11-03	TLT	ETF	130.75	131.05	130.44	130.57	6085400.0
2016-11-03	AADR	ETF	40.8	40.8	40.61	40.61	1200.0
2016-11-03	AAXJ	ETF	58.31	58.36	57.95	58.12	657200.0
2016-11-03	ACSI	ETF	24.69	24.69	24.53	24.53	19658.0
2016-11-03	ACTX	ETF	11.8001	12.9801	10.6201	10.6201	2235.0
2016-11-03	ACWF	ETF	23.625	23.625	23.625	23.625	100.0
2016-11-03	ACWI	ETF	57.35	57.38	56.95	57.03	3168000.0
2016-11-03	ACWV	ETF	73.44	73.5	73.06	73.16	449900.0
2016-11-03	ACWX	ETF	40.34	40.385	40.11	40.19	601494.0
2016-11-03	ADRE	ETF	34.47	34.56	34.1601	34.17	6747.0
2016-11-03	AFK	ETF	20.57	20.57	20.25	20.2601	3780.0
2016-11-03	AGG	ETF	111.03	111.16	111.01	111.01	3254500.0
2016-11-03	AGGY	ETF	51.35	51.39	51.265	51.34	13200.0
2016-11-03	AGNG	ETF	14.907	14.907	14.907	14.907	500.0
2016-11-03	AGQ	ETF	42.8	44.0	42.73	43.6	337800.0
2016-11-03	AGZ	ETF	114.96	115.1506	114.935	115.03	8114.0
2016-11-03	AGZD	ETF	23.945	23.945	23.875	23.875	1000.0
2016-11-03	AIA	ETF	48.54	48.5717	48.25	48.35	23079.0
2016-11-03	AIQ	ETF	8.25	8.7587	8.15	8.7	17934.0
2016-11-03	AIRR	ETF	19.05	19.12	18.94	18.99	16800.0
2016-11-03	AIVI	ETF	37.26	37.34	37.14	37.14	14400.0
2016-11-03	ALTY	ETF	14.638	14.638	14.55	14.55	1500.0
2016-11-03	AMJ	ETF	29.44	29.52	29.22	29.36	1947118.0
2016-11-03	AMLP	ETF	60.1	60.25	59.55	59.75	2184880.0
2016-11-03	AMZA	ETF	103.6	103.69	102.6	102.7	20290.0
2016-11-03	ANGL	ETF	28.4	28.5	28.33	28.36	183700.0
2016-11-03	AOA	ETF	46.13	46.21	45.94	45.98	38500.0
2016-11-03	AOK	ETF	32.63	32.779	32.581	32.65	50470.0
2016-11-03	AOM	ETF	35.3	35.304	35.15	35.15	47090.0
2016-11-03	AOR	ETF	40.15	40.15	39.9	39.91	61882.0
2016-11-03	ARGT	ETF	23.14	23.21	22.9	23.13	37900.0
2016-11-03	ARKG	ETF	16.1	16.1	15.85	15.85	27600.0
2016-11-03	ARKK	ETF	19.23	19.23	19.2	19.2	2000.0
2016-11-03	ARKQ	ETF	20.242	20.242	20.226	20.226	300.0
2016-11-03	ARKW	ETF	24.039	24.055	23.85	23.85	1700.0
2016-11-03	ASEA	ETF	13.46	13.46	13.39	13.39	48600.0
2016-11-03	ASHR	ETF	24.76	24.91	24.76	24.9	714400.0
2016-11-03	ASHS	ETF	34.81	34.85	34.56	34.76	3100.0
2016-11-03	ATMP	ETF	21.89	21.89	21.54	21.56	83700.0
2016-11-03	BAB	ETF	30.68	30.775	30.65	30.71	130500.0
2016-11-03	BAL	ETF	45.24	45.35	44.95	44.9572	1559.0
2016-11-03	BBC	ETF	17.48	17.48	16.33	16.33	12375.0
2016-11-03	BBH	ETF	102.08	102.42	99.65	99.8	314500.0
2016-11-03	BBP	ETF	28.532	28.74	28.09	28.09	11300.0
2016-11-03	BCM	ETF	25.938	25.938	25.938	25.938	461.0

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

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