PREVIEW / etf_daily / 2016-12-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-08.parquet
  size:    54 KB
  rows:    1,358

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-12-08	SPY	ETF	224.57	225.7	224.26	225.15	99714400.0
2016-12-08	QQQ	ETF	118.4	118.87	118.18	118.57	18578433.0
2016-12-08	IWM	ETF	136.25	138.21	135.8	138.04	49048900.0
2016-12-08	DIA	ETF	195.83	196.8	195.41	196.28	7032100.0
2016-12-08	GLD	ETF	111.72	111.87	111.46	111.57	5977800.0
2016-12-08	TLT	ETF	119.15	119.31	118.78	118.98	12041100.0
2016-12-08	AADR	ETF	40.54	40.88	40.54	40.8	7700.0
2016-12-08	AAXJ	ETF	57.59	57.94	57.54	57.86	1754600.0
2016-12-08	ACSI	ETF	27.6	27.6	27.24	27.36	7280.0
2016-12-08	ACTX	ETF	21.2402	21.2402	17.7002	18.2902	1387.0
2016-12-08	ACWF	ETF	24.81	24.81	24.81	24.81	190.0
2016-12-08	ACWI	ETF	59.9	60.14	59.79	60.03	2032300.0
2016-12-08	ACWV	ETF	72.92	73.19	72.85	73.09	137400.0
2016-12-08	ACWX	ETF	40.99	41.066	40.85	41.01	986277.0
2016-12-08	ADRE	ETF	33.52	33.59	33.46	33.59	5693.0
2016-12-08	AFK	ETF	20.04	20.15	19.6	20.1	6045.0
2016-12-08	AFTY	ETF	13.879	13.879	13.877	13.879	500.0
2016-12-08	AGG	ETF	108.18	108.22	108.05	108.17	2822600.0
2016-12-08	AGGY	ETF	49.59	49.64	49.53	49.54	16900.0
2016-12-08	AGQ	ETF	36.97	37.25	36.75	36.92	96800.0
2016-12-08	AGZ	ETF	112.684	113.1599	112.557	112.93	10004.0
2016-12-08	AGZD	ETF	23.96	24.0	23.96	24.0	1000.0
2016-12-08	AIA	ETF	48.73	48.9996	48.73	48.9	18292.0
2016-12-08	AIQ	ETF	8.0	8.15	7.95	8.0	20169.0
2016-12-08	AIRR	ETF	24.05	24.17	23.754	24.12	168500.0
2016-12-08	AIVI	ETF	37.66	37.66	37.45	37.55	18000.0
2016-12-08	ALTY	ETF	15.06	15.06	14.938	14.94	1200.0
2016-12-08	AMJ	ETF	29.85	30.22	29.85	30.14	1545346.0
2016-12-08	AMLP	ETF	61.0	61.4	60.8	61.35	1156460.0
2016-12-08	AMZA	ETF	108.3	108.7	107.59	108.7	13070.0
2016-12-08	ANGL	ETF	28.94	28.97	28.86	28.95	192700.0
2016-12-08	AOA	ETF	47.68	47.81	47.56	47.65	106300.0
2016-12-08	AOK	ETF	32.6	32.65	32.5101	32.61	189623.0
2016-12-08	AOM	ETF	35.39	35.51	35.36	35.46	369599.0
2016-12-08	AOR	ETF	40.86	40.933	40.734	40.86	475376.0
2016-12-08	ARGT	ETF	23.5	23.51	23.18	23.25	14700.0
2016-12-08	ARKG	ETF	17.169	17.169	17.169	17.169	200.0
2016-12-08	ARKK	ETF	20.218	20.326	20.218	20.326	1000.0
2016-12-08	ARKQ	ETF	22.33	22.33	22.31	22.318	800.0
2016-12-08	ARKW	ETF	25.58	25.58	25.37	25.41	3300.0
2016-12-08	ASEA	ETF	13.39	13.43	13.39	13.42	3100.0
2016-12-08	ASET	ETF	25.72	25.72	25.72	25.72	412.0
2016-12-08	ASHR	ETF	25.33	25.44	25.27	25.28	886200.0
2016-12-08	ASHX	ETF	23.92	23.92	23.92	23.92	2000.0
2016-12-08	ATMP	ETF	22.57	22.69	22.43	22.66	181400.0
2016-12-08	BAB	ETF	29.26	29.39	29.18	29.25	291704.0
2016-12-08	BAL	ETF	47.1	47.1	46.5	46.62	9413.0
2016-12-08	BBC	ETF	19.22	19.74	19.1	19.71	8581.0
2016-12-08	BBH	ETF	106.1	107.18	104.92	106.96	171400.0
2016-12-08	BBP	ETF	33.13	33.784	32.058	33.784	16300.0

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

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