PREVIEW / etf_daily / 2017-01-11

all etf daily files

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

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-11	SPY	ETF	226.36	227.1	225.59	227.1	74650000.0
2017-01-11	QQQ	ETF	122.63	122.93	122.02	122.93	20685983.0
2017-01-11	IWM	ETF	136.23	136.79	135.42	136.33	27428800.0
2017-01-11	DIA	ETF	198.63	199.57	198.15	199.33	5209800.0
2017-01-11	GLD	ETF	112.87	114.19	112.17	113.5	9918700.0
2017-01-11	TLT	ETF	121.94	122.69	121.41	122.16	9402500.0
2017-01-11	AADR	ETF	43.2	43.4	42.67	43.4	6700.0
2017-01-11	AAXJ	ETF	57.45	57.78	57.22	57.67	2003600.0
2017-01-11	ACSI	ETF	27.17	27.26	27.1275	27.26	5839.0
2017-01-11	ACTX	ETF	28.9103	29.5003	27.7302	28.4383	1497.0
2017-01-11	ACWF	ETF	24.8332	24.87	24.8157	24.8157	890.0
2017-01-11	ACWI	ETF	60.25	60.57	60.1	60.57	1508800.0
2017-01-11	ACWV	ETF	73.33	73.65	73.25	73.65	136000.0
2017-01-11	ACWX	ETF	41.17	41.46	41.07	41.46	940021.0
2017-01-11	ADRE	ETF	33.91	34.4	33.8692	34.37	15221.0
2017-01-11	AFK	ETF	20.91	21.0	20.5	20.99	28429.0
2017-01-11	AFTY	ETF	13.22	13.23	13.22	13.23	500.0
2017-01-11	AGG	ETF	108.53	108.93	108.42	108.57	4465500.0
2017-01-11	AGGY	ETF	49.84	49.955	49.741	49.836	5300.0
2017-01-11	AGQ	ETF	34.9	35.93	34.52	35.41	122900.0
2017-01-11	AGZ	ETF	112.7815	113.25	112.62	112.94	24788.0
2017-01-11	AGZD	ETF	24.125	24.155	24.08	24.08	9600.0
2017-01-11	AIA	ETF	48.31	48.76	48.28	48.66	187960.0
2017-01-11	AIQ	ETF	9.75	9.75	9.7	9.75	11678.0
2017-01-11	AIRR	ETF	23.69	23.85	23.51	23.77	72100.0
2017-01-11	AIVI	ETF	37.9	38.3	37.9	38.24	9300.0
2017-01-11	ALTY	ETF	15.15	15.35	15.15	15.337	800.0
2017-01-11	AMJ	ETF	31.64	31.9709	31.6088	31.89	1233033.0
2017-01-11	AMLP	ETF	63.45	63.75	63.35	63.7	1251780.0
2017-01-11	AMZA	ETF	108.6	109.21	108.5	108.85	34820.0
2017-01-11	ANGL	ETF	29.17	29.19	29.12	29.17	245900.0
2017-01-11	AOA	ETF	47.99	48.06	47.8	48.06	51500.0
2017-01-11	AOK	ETF	32.77	32.8	32.7	32.76	40717.0
2017-01-11	AOM	ETF	35.52	35.63	35.45	35.63	158509.0
2017-01-11	AOR	ETF	41.09	41.12	40.91	41.12	211427.0
2017-01-11	ARGT	ETF	25.17	25.2	24.79	24.99	63900.0
2017-01-11	ARKG	ETF	18.212	18.212	17.555	18.15	2500.0
2017-01-11	ARKK	ETF	21.9	21.95	21.648	21.78	16900.0
2017-01-11	ARKQ	ETF	23.0	23.0	22.87	22.91	2400.0
2017-01-11	ARKW	ETF	26.87	27.0	26.83	26.992	2200.0
2017-01-11	ASEA	ETF	13.29	13.33	13.19	13.33	2400.0
2017-01-11	ASET	ETF	25.83	25.91	25.83	25.9022	659.0
2017-01-11	ASHR	ETF	24.08	24.2	24.04	24.09	1103100.0
2017-01-11	ASHS	ETF	33.3	33.3	33.1	33.1	2700.0
2017-01-11	ATMP	ETF	23.44	23.69	23.33	23.68	114400.0
2017-01-11	BAB	ETF	29.41	29.45	29.3	29.38	98113.0
2017-01-11	BAL	ETF	48.4379	48.4379	48.1259	48.2	8102.0
2017-01-11	BBC	ETF	20.32	20.32	19.2758	19.47	32987.0
2017-01-11	BBH	ETF	115.79	116.19	112.09	113.08	127400.0
2017-01-11	BBP	ETF	36.92	36.92	34.83	35.1	19500.0

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

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