PREVIEW / etf_daily / 2016-01-26

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-26.parquet
  size:    50 KB
  rows:    1,249

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-01-26	SPY	ETF	188.42	190.53	188.02	190.2	141036800.0
2016-01-26	QQQ	ETF	102.65	103.59	101.76	103.15	36143916.0
2016-01-26	IWM	ETF	99.52	101.4	99.18	101.1	33349600.0
2016-01-26	DIA	ETF	159.5	161.72	159.49	161.54	5945200.0
2016-01-26	GLD	ETF	106.32	107.43	106.26	107.29	8443400.0
2016-01-26	TLT	ETF	125.99	126.46	125.75	126.08	5692600.0
2016-01-26	AADR	ETF	35.9	35.9	35.9	35.9	200.0
2016-01-26	AAXJ	ETF	48.06	48.58	48.06	48.47	852700.0
2016-01-26	ACTX	ETF	5.9001	7.0801	5.664	7.0801	616.0
2016-01-26	ACWF	ETF	21.19	21.327	21.18	21.3212	2080.0
2016-01-26	ACWI	ETF	51.27	51.93	51.23	51.9	4443600.0
2016-01-26	ACWV	ETF	66.21	66.79	66.21	66.68	127900.0
2016-01-26	ACWX	ETF	36.21	36.66	36.16	36.64	912515.0
2016-01-26	ADRE	ETF	26.13	26.43	26.07	26.43	9676.0
2016-01-26	AFK	ETF	15.62	15.83	15.53	15.8	76997.0
2016-01-26	AFTY	ETF	11.69	11.75	11.69	11.72	17700.0
2016-01-26	AGG	ETF	108.9	109.0	108.77	108.92	2604100.0
2016-01-26	AGGY	ETF	49.46	49.52	49.4	49.4	393300.0
2016-01-26	AGQ	ETF	29.07	29.92	29.05	29.75	240100.0
2016-01-26	AGZ	ETF	113.75	113.817	113.68	113.73	42561.0
2016-01-26	AGZD	ETF	23.815	23.815	23.715	23.715	1400.0
2016-01-26	AIA	ETF	37.85	38.17	37.824	38.17	72842.0
2016-01-26	AIQ	ETF	7.2	7.4301	6.85	7.07	37118.0
2016-01-26	AIRR	ETF	14.43	14.53	14.41	14.53	3100.0
2016-01-26	AIVI	ETF	35.79	36.25	35.75	36.22	15800.0
2016-01-26	ALTY	ETF	12.878	12.878	12.878	12.878	400.0
2016-01-26	AMJ	ETF	24.06	24.74	23.22	24.44	7031851.0
2016-01-26	AMLP	ETF	49.1	50.1	47.0	49.6	3202020.0
2016-01-26	AMZA	ETF	82.2	84.59	78.0	84.5	8780.0
2016-01-26	ANGL	ETF	23.58	24.0	23.58	23.91	597000.0
2016-01-26	AOA	ETF	41.95	42.33	41.93	42.31	84300.0
2016-01-26	AOK	ETF	31.019	31.06	30.9301	31.06	19478.0
2016-01-26	AOM	ETF	33.0	33.1999	33.0	33.17	212600.0
2016-01-26	AOR	ETF	37.03	37.24	36.9401	37.18	421100.0
2016-01-26	ARGT	ETF	16.3	16.54	16.16	16.51	9500.0
2016-01-26	ARKG	ETF	17.69	17.69	17.6	17.6	200.0
2016-01-26	ARKK	ETF	17.05	17.05	17.05	17.05	100.0
2016-01-26	ARKQ	ETF	16.118	16.12	16.118	16.12	600.0
2016-01-26	ARKW	ETF	19.42	19.42	19.324	19.324	400.0
2016-01-26	ASEA	ETF	11.57	11.61	11.57	11.61	1500.0
2016-01-26	ASET	ETF	23.1	23.14	23.1	23.14	900.0
2016-01-26	ASHR	ETF	22.0	22.11	21.92	22.01	3170700.0
2016-01-26	ASHS	ETF	30.09	30.51	30.09	30.34	60100.0
2016-01-26	ASHX	ETF	20.06	20.16	19.98	20.14	15210.0
2016-01-26	ATMP	ETF	16.03	16.44	15.76	15.92	44700.0
2016-01-26	BAB	ETF	29.75	29.817	29.71	29.75	204753.0
2016-01-26	BAL	ETF	40.75	40.75	40.445	40.56	3708.0
2016-01-26	BBC	ETF	20.96	21.0	20.02	20.66	11937.0
2016-01-26	BBH	ETF	108.28	108.48	105.96	107.6	77200.0
2016-01-26	BBP	ETF	25.11	25.6	25.0	25.38	2200.0

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

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