PREVIEW / etf_daily / 2015-10-22

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-22.parquet
  size:    48 KB
  rows:    1,202

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
2015-10-22	SPY	ETF	202.98	205.51	201.85	205.26	174911700.0
2015-10-22	QQQ	ETF	108.48	109.8	108.171	109.71	42778702.0
2015-10-22	IWM	ETF	114.41	115.42	113.73	114.72	36882600.0
2015-10-22	DIA	ETF	172.56	174.91	172.47	174.8	8553100.0
2015-10-22	GLD	ETF	111.52	112.21	111.43	111.69	3436400.0
2015-10-22	TLT	ETF	124.1	124.78	123.51	124.26	6934100.0
2015-10-22	AADR	ETF	38.51	38.51	37.86	37.86	1900.0
2015-10-22	AAXJ	ETF	57.5	58.33	57.5	58.25	644300.0
2015-10-22	ACTX	ETF	7.6701	8.8501	7.0801	8.8501	879.0
2015-10-22	ACWI	ETF	57.4	58.02	57.4	57.91	4892900.0
2015-10-22	ACWV	ETF	70.24	71.0	70.24	70.93	51500.0
2015-10-22	ACWX	ETF	41.8	42.22	41.8	42.08	351108.0
2015-10-22	ADRE	ETF	30.05	30.47	30.05	30.3	4968.0
2015-10-22	AFK	ETF	20.603	21.08	20.6	21.07	18175.0
2015-10-22	AFTY	ETF	16.05	16.23	16.05	16.21	5900.0
2015-10-22	AGG	ETF	109.9	110.05	109.83	109.94	2276300.0
2015-10-22	AGGY	ETF	50.098	50.264	50.098	50.264	300.0
2015-10-22	AGQ	ETF	35.75	36.28	35.65	36.01	69200.0
2015-10-22	AGZ	ETF	114.15	114.26	113.8701	114.14	25534.0
2015-10-22	AGZD	ETF	23.955	24.03	23.955	23.965	4000.0
2015-10-22	AIA	ETF	46.08	46.52	46.08	46.47	37693.0
2015-10-22	AIQ	ETF	9.89	9.89	9.02	9.24	34283.0
2015-10-22	AIRR	ETF	16.14	16.51	16.14	16.4	7600.0
2015-10-22	AIVI	ETF	40.85	41.21	40.85	41.16	176900.0
2015-10-22	ALTY	ETF	14.66	14.67	14.66	14.66	1200.0
2015-10-22	AMJ	ETF	32.93	33.08	32.04	32.46	3039130.0
2015-10-22	AMLP	ETF	67.5	67.95	65.7	66.45	1822360.0
2015-10-22	AMZA	ETF	145.3	145.3	138.0	140.6	3640.0
2015-10-22	ANGL	ETF	26.11	26.15	26.09	26.1	10100.0
2015-10-22	AOA	ETF	45.82	46.13	45.78	45.96	68000.0
2015-10-22	AOK	ETF	32.2	32.3199	32.1859	32.3023	143344.0
2015-10-22	AOM	ETF	34.71	34.8367	34.686	34.82	70431.0
2015-10-22	AOR	ETF	39.5	39.7955	39.5	39.75	80036.0
2015-10-22	ARGT	ETF	17.26	17.6	17.26	17.6	1400.0
2015-10-22	ARKG	ETF	19.0	19.0	18.839	18.839	800.0
2015-10-22	ARKK	ETF	19.37	19.449	19.32	19.449	1100.0
2015-10-22	ARKQ	ETF	18.454	18.454	18.454	18.454	200.0
2015-10-22	ARKW	ETF	22.01	22.01	22.01	22.01	100.0
2015-10-22	ASEA	ETF	13.46	13.55	13.46	13.54	6900.0
2015-10-22	ASHR	ETF	35.45	36.01	35.41	35.94	1997500.0
2015-10-22	ASHS	ETF	42.48	42.8	42.18	42.67	38300.0
2015-10-22	ASHX	ETF	25.29	25.3	25.29	25.3	200.0
2015-10-22	ATMP	ETF	22.59	22.62	22.01	22.27	130600.0
2015-10-22	AWAY	ETF	28.83	30.6	28.826	30.38	1665817.0
2015-10-22	BAB	ETF	29.32	29.3684	29.2266	29.33	84441.0
2015-10-22	BAL	ETF	43.04	43.04	41.6787	41.99	19642.0
2015-10-22	BBC	ETF	26.66	27.33	25.65	26.31	15891.0
2015-10-22	BBH	ETF	116.47	118.6	114.78	117.95	333600.0
2015-10-22	BBP	ETF	28.94	29.24	28.696	28.79	5900.0
2015-10-22	BCHP	ETF	18.38	18.39	18.38	18.39	1000.0

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

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