PREVIEW / etf_daily / 2017-01-20

all etf daily files

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

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-20	SPY	ETF	226.7	227.31	225.97	226.74	129168600.0
2017-01-20	QQQ	ETF	123.51	123.83	122.92	123.25	22091039.0
2017-01-20	IWM	ETF	133.75	134.88	133.75	134.44	29286100.0
2017-01-20	DIA	ETF	197.53	198.2	197.31	197.96	6999000.0
2017-01-20	GLD	ETF	114.65	115.76	114.32	115.05	12261500.0
2017-01-20	TLT	ETF	119.84	120.31	119.29	119.94	16953200.0
2017-01-20	AADR	ETF	43.95	43.95	43.69	43.71	3300.0
2017-01-20	AAXJ	ETF	57.45	57.55	57.25	57.46	401100.0
2017-01-20	ACSI	ETF	27.15	27.16	27.07	27.12	11200.0
2017-01-20	ACTX	ETF	57.2305	61.9506	53.6905	61.9506	1800.0
2017-01-20	ACWI	ETF	60.43	60.54	60.31	60.49	1611100.0
2017-01-20	ACWV	ETF	73.4	73.69	73.37	73.6	159100.0
2017-01-20	ACWX	ETF	41.36	41.46	41.3	41.42	1049686.0
2017-01-20	ADRE	ETF	34.44	34.53	34.3748	34.53	1983.0
2017-01-20	AFK	ETF	21.33	21.33	21.022	21.2999	4184.0
2017-01-20	AFTY	ETF	13.71	13.72	13.708	13.72	3600.0
2017-01-20	AGG	ETF	107.94	108.12	107.83	108.08	3525000.0
2017-01-20	AGGY	ETF	49.58	49.641	49.5	49.64	22200.0
2017-01-20	AGQ	ETF	36.54	37.14	36.13	36.79	125200.0
2017-01-20	AGZ	ETF	112.61	112.81	112.481	112.69	13123.0
2017-01-20	AGZD	ETF	24.07	24.145	24.01	24.11	23600.0
2017-01-20	AIA	ETF	48.53	48.5628	48.3766	48.52	17729.0
2017-01-20	AIQ	ETF	9.65	9.7	9.6	9.65	27429.0
2017-01-20	AIRR	ETF	23.5	23.59	23.383	23.41	50400.0
2017-01-20	AIVI	ETF	38.43	38.49	38.36	38.43	9700.0
2017-01-20	ALTY	ETF	15.255	15.29	15.255	15.255	1700.0
2017-01-20	AMJ	ETF	32.06	32.17	31.92	31.98	1623806.0
2017-01-20	AMLP	ETF	63.65	63.85	63.5	63.5	1014140.0
2017-01-20	AMZA	ETF	108.9	109.0	108.4	109.0	27290.0
2017-01-20	ANGL	ETF	29.2	29.2	29.05	29.16	485300.0
2017-01-20	AOA	ETF	47.88	47.99	47.85	47.95	87600.0
2017-01-20	AOK	ETF	32.6	32.68	32.5801	32.64	102182.0
2017-01-20	AOM	ETF	35.39	35.5181	35.39	35.47	287004.0
2017-01-20	AOR	ETF	40.91	41.0	40.8801	40.96	276701.0
2017-01-20	ARGT	ETF	25.2	25.36	25.14	25.25	54800.0
2017-01-20	ARKG	ETF	17.77	17.77	17.72	17.72	300.0
2017-01-20	ARKK	ETF	22.04	22.04	21.81	21.849	13600.0
2017-01-20	ARKQ	ETF	23.34	23.34	23.154	23.22	31000.0
2017-01-20	ARKW	ETF	26.976	27.034	26.976	27.0	23800.0
2017-01-20	ASEA	ETF	13.27	13.27	13.23	13.23	1100.0
2017-01-20	ASET	ETF	25.9	25.9	25.9	25.9	878.0
2017-01-20	ASHR	ETF	24.56	24.67	24.56	24.67	1032400.0
2017-01-20	ASHS	ETF	32.57	32.65	32.55	32.65	4100.0
2017-01-20	ASHX	ETF	19.2188	19.2188	19.1799	19.1799	550.0
2017-01-20	ATMP	ETF	23.47	23.65	23.34	23.34	42200.0
2017-01-20	BAB	ETF	29.14	29.14	29.0	29.11	68927.0
2017-01-20	BAL	ETF	48.22	48.23	47.98	48.0	5197.0
2017-01-20	BBC	ETF	19.15	19.16	19.0	19.15	7948.0
2017-01-20	BBH	ETF	112.06	112.71	111.4	111.52	51900.0
2017-01-20	BBP	ETF	34.728	34.728	34.36	34.39	4400.0

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

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