PREVIEW / etf_daily / 2017-01-24

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-24.parquet
  size:    54 KB
  rows:    1,370

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
2017-01-24	SPY	ETF	226.4	228.08	226.27	227.6	95555300.0
2017-01-24	QQQ	ETF	123.59	124.37	123.3847	124.18	17640869.0
2017-01-24	IWM	ETF	134.34	136.28	134.22	135.93	34313800.0
2017-01-24	DIA	ETF	197.79	199.22	197.62	198.84	5205800.0
2017-01-24	GLD	ETF	115.69	116.02	114.94	115.27	5798800.0
2017-01-24	TLT	ETF	120.77	121.13	119.8	120.31	8395000.0
2017-01-24	AADR	ETF	44.43	44.43	44.13	44.13	6500.0
2017-01-24	AAXJ	ETF	58.34	58.66	58.34	58.47	492600.0
2017-01-24	ACSI	ETF	27.08	27.22	27.0625	27.22	7833.0
2017-01-24	ACTX	ETF	87.0258	103.2509	85.5508	95.5809	6168.0
2017-01-24	ACWI	ETF	60.49	60.92	60.46	60.83	1641100.0
2017-01-24	ACWV	ETF	73.69	73.89	73.61	73.87	108100.0
2017-01-24	ACWX	ETF	41.61	41.8367	41.61	41.78	591862.0
2017-01-24	ADRE	ETF	35.24	35.3744	35.1134	35.3	10987.0
2017-01-24	AFK	ETF	21.49	21.7199	21.2	21.64	16895.0
2017-01-24	AFTY	ETF	13.88	13.88	13.73	13.73	3600.0
2017-01-24	AGG	ETF	108.33	108.4	108.1	108.21	2049500.0
2017-01-24	AGGY	ETF	49.628	49.662	49.53	49.53	13500.0
2017-01-24	AGNG	ETF	15.559	15.577	15.55	15.577	500.0
2017-01-24	AGQ	ETF	37.19	37.7	36.55	36.9	123100.0
2017-01-24	AGZ	ETF	112.82	112.97	112.7	112.84	35751.0
2017-01-24	AIA	ETF	49.0	49.2527	49.0	49.14	15366.0
2017-01-24	AIQ	ETF	9.65	9.7	9.65	9.65	8407.0
2017-01-24	AIRR	ETF	23.31	24.0	23.31	23.95	120400.0
2017-01-24	AIVI	ETF	38.61	38.84	38.61	38.82	8400.0
2017-01-24	ALTY	ETF	15.308	15.41	15.308	15.41	3100.0
2017-01-24	AMJ	ETF	31.87	32.81	31.87	32.73	3609682.0
2017-01-24	AMLP	ETF	63.75	64.6	63.55	64.4	1999720.0
2017-01-24	AMZA	ETF	108.9	110.6	108.57	110.4	56230.0
2017-01-24	ANGL	ETF	29.23	29.25	29.18	29.24	351000.0
2017-01-24	AOA	ETF	48.07	48.27	48.06	48.26	284900.0
2017-01-24	AOK	ETF	32.73	32.76	32.7101	32.75	125844.0
2017-01-24	AOM	ETF	35.49	35.63	35.49	35.63	164357.0
2017-01-24	AOR	ETF	41.04	41.1868	41.01	41.14	462620.0
2017-01-24	ARGT	ETF	25.81	25.98	25.78	25.86	116900.0
2017-01-24	ARKG	ETF	17.39	17.56	17.356	17.56	3100.0
2017-01-24	ARKK	ETF	21.88	22.06	21.863	22.06	4000.0
2017-01-24	ARKQ	ETF	23.29	23.39	23.233	23.39	4600.0
2017-01-24	ARKW	ETF	27.2	27.399	27.15	27.399	4200.0
2017-01-24	ASEA	ETF	13.47	13.54	13.47	13.54	500.0
2017-01-24	ASHR	ETF	24.71	24.8	24.69	24.74	1067200.0
2017-01-24	ASHS	ETF	32.75	33.02	32.75	32.96	8500.0
2017-01-24	ASHX	ETF	19.07	19.23	19.07	19.23	865.0
2017-01-24	ATMP	ETF	23.71	24.02	23.68	23.99	74200.0
2017-01-24	BAB	ETF	29.14	29.2299	29.07	29.12	152806.0
2017-01-24	BAL	ETF	49.32	49.32	47.75	48.4213	18951.0
2017-01-24	BBC	ETF	18.6147	19.03	18.49	19.03	3403.0
2017-01-24	BBH	ETF	111.23	111.23	109.43	110.44	56900.0
2017-01-24	BBP	ETF	33.25	33.932	33.25	33.932	15300.0
2017-01-24	BCM	ETF	27.8796	27.91	27.84	27.87	1397.0

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

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