PREVIEW / etf_daily / 2016-12-28

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-28.parquet
  size:    53 KB
  rows:    1,361

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-28	SPY	ETF	226.57	226.59	224.27	224.4	64095000.0
2016-12-28	QQQ	ETF	121.06	121.19	119.795	119.88	17975235.0
2016-12-28	IWM	ETF	136.89	136.98	134.83	135.25	22712400.0
2016-12-28	DIA	ETF	199.52	199.56	198.0	198.08	3818100.0
2016-12-28	GLD	ETF	108.4	108.91	108.29	108.86	5091200.0
2016-12-28	TLT	ETF	117.86	118.88	117.7	118.53	7578600.0
2016-12-28	AADR	ETF	41.45	41.45	40.15	40.65	2300.0
2016-12-28	AAXJ	ETF	54.61	54.67	54.32	54.4	1897200.0
2016-12-28	ACSI	ETF	27.35	27.35	27.15	27.15	4924.0
2016-12-28	ACTX	ETF	19.4702	21.8302	17.7002	18.8802	1380.0
2016-12-28	ACWI	ETF	59.5	59.55	59.11	59.15	1761800.0
2016-12-28	ACWV	ETF	72.7	72.7	72.2	72.2	269100.0
2016-12-28	ACWX	ETF	40.06	40.13	39.97	39.99	1087576.0
2016-12-28	ADRE	ETF	32.29	32.39	32.101	32.27	11938.0
2016-12-28	AFK	ETF	19.37	19.52	19.245	19.245	70867.0
2016-12-28	AFTY	ETF	12.92	12.92	12.91	12.91	1000.0
2016-12-28	AGG	ETF	107.33	107.6	107.3	107.51	5609600.0
2016-12-28	AGGY	ETF	49.13	49.52	49.13	49.36	42500.0
2016-12-28	AGNG	ETF	15.332	15.332	15.332	15.332	600.0
2016-12-28	AGQ	ETF	32.1	32.66	31.98	32.56	160900.0
2016-12-28	AGZ	ETF	112.02	112.3336	111.94	112.28	27871.0
2016-12-28	AGZD	ETF	24.0	24.115	24.0	24.07	19600.0
2016-12-28	AIA	ETF	46.05	46.0604	45.81	45.87	23008.0
2016-12-28	AIQ	ETF	9.55	9.65	9.55	9.575	32784.0
2016-12-28	AIRR	ETF	24.43	24.43	23.8	23.88	75700.0
2016-12-28	AIVI	ETF	37.22	37.25	37.07	37.14	19300.0
2016-12-28	ALTY	ETF	14.835	14.9	14.78	14.78	6400.0
2016-12-28	AMJ	ETF	31.68	31.91	31.48	31.5	1455293.0
2016-12-28	AMLP	ETF	63.6	63.65	63.15	63.25	1098720.0
2016-12-28	AMZA	ETF	114.6	114.6	112.6	113.0	39670.0
2016-12-28	ANGL	ETF	28.98	28.98	28.74	28.86	135000.0
2016-12-28	AOA	ETF	47.61	47.61	47.11	47.17	145700.0
2016-12-28	AOK	ETF	32.49	32.49	32.3901	32.43	56052.0
2016-12-28	AOM	ETF	35.31	35.31	35.09	35.15	144085.0
2016-12-28	AOR	ETF	40.69	40.69	40.41	40.47	252413.0
2016-12-28	ARGT	ETF	22.92	22.92	22.63	22.63	99700.0
2016-12-28	ARKG	ETF	17.338	17.338	17.338	17.338	100.0
2016-12-28	ARKK	ETF	20.48	20.48	20.29	20.29	3400.0
2016-12-28	ARKQ	ETF	22.71	22.71	22.29	22.29	2600.0
2016-12-28	ARKW	ETF	25.68	25.68	25.36	25.37	4100.0
2016-12-28	ASEA	ETF	12.81	12.81	12.69	12.69	2000.0
2016-12-28	ASET	ETF	25.35	26.34	25.25	25.26	2900.0
2016-12-28	ASHR	ETF	23.52	23.52	23.46	23.46	474800.0
2016-12-28	ASHS	ETF	32.42	32.42	32.37	32.4	2900.0
2016-12-28	ASHX	ETF	18.99	19.0599	18.98	18.98	1067.0
2016-12-28	ATMP	ETF	23.72	23.87	23.51	23.53	107600.0
2016-12-28	BAB	ETF	28.88	29.13	28.88	29.11	159857.0
2016-12-28	BAL	ETF	45.74	45.81	45.692	45.7966	1706.0
2016-12-28	BBC	ETF	19.06	19.06	18.65	18.67	4455.0
2016-12-28	BBH	ETF	109.14	109.14	108.12	108.19	44900.0

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

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