PREVIEW / etf_daily / 2017-01-26

all etf daily files

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

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-26	SPY	ETF	229.4	229.71	229.01	229.33	59970700.0
2017-01-26	QQQ	ETF	125.59	125.82	125.3438	125.56	16052150.0
2017-01-26	IWM	ETF	137.34	137.5	136.42	136.66	22255600.0
2017-01-26	DIA	ETF	200.6	200.97	200.42	200.72	3999700.0
2017-01-26	GLD	ETF	113.24	113.51	112.83	113.26	5390500.0
2017-01-26	TLT	ETF	118.91	119.26	118.33	119.2	7827900.0
2017-01-26	AADR	ETF	45.49	45.49	44.26	44.47	15400.0
2017-01-26	AAXJ	ETF	59.05	59.17	58.91	58.91	938200.0
2017-01-26	ACSI	ETF	27.48	27.48	27.35	27.35	4650.0
2017-01-26	ACTX	ETF	85.5508	107.086	85.5508	103.8409	2704.0
2017-01-26	ACWF	ETF	25.92	25.95	25.92	25.95	319.0
2017-01-26	ACWI	ETF	61.41	61.45	61.27	61.31	2160100.0
2017-01-26	ACWV	ETF	73.87	73.99	73.83	73.89	137300.0
2017-01-26	ACWX	ETF	42.15	42.18	42.01	42.06	1137744.0
2017-01-26	ADRE	ETF	35.62	35.62	35.3698	35.4501	9782.0
2017-01-26	AFK	ETF	21.56	21.7464	21.2	21.4668	8153.0
2017-01-26	AFTY	ETF	13.78	13.81	13.78	13.78	6500.0
2017-01-26	AGG	ETF	107.86	108.03	107.71	107.99	2046300.0
2017-01-26	AGGY	ETF	49.38	49.496	49.33	49.496	6800.0
2017-01-26	AGQ	ETF	35.61	35.97	35.19	35.55	116300.0
2017-01-26	AGZ	ETF	112.65	112.65	112.2901	112.57	20548.0
2017-01-26	AGZD	ETF	24.065	24.1	24.0	24.065	16200.0
2017-01-26	AIA	ETF	49.69	49.8192	49.6495	49.7	11640.0
2017-01-26	AIQ	ETF	9.7	9.7	9.65	9.65	8537.0
2017-01-26	AIRR	ETF	24.65	24.65	24.28	24.42	397900.0
2017-01-26	AIVI	ETF	38.78	38.84	38.7	38.78	11000.0
2017-01-26	ALTY	ETF	15.26	15.44	15.26	15.44	2200.0
2017-01-26	AMJ	ETF	33.6	33.93	33.49	33.88	4091817.0
2017-01-26	AMLP	ETF	66.1	66.1	65.65	66.05	2159460.0
2017-01-26	AMZA	ETF	112.6	113.3	112.4	113.1	64670.0
2017-01-26	ANGL	ETF	29.35	29.36	29.3	29.35	239800.0
2017-01-26	AOA	ETF	48.6	48.6	48.45	48.51	76000.0
2017-01-26	AOK	ETF	32.76	32.8099	32.72	32.8	103372.0
2017-01-26	AOM	ETF	35.7	35.7	35.5765	35.67	75207.0
2017-01-26	AOR	ETF	41.42	41.42	41.2547	41.28	150565.0
2017-01-26	ARGT	ETF	26.16	26.16	25.81	25.81	16100.0
2017-01-26	ARKG	ETF	17.72	17.746	17.72	17.74	700.0
2017-01-26	ARKK	ETF	22.325	22.336	22.1	22.11	5800.0
2017-01-26	ARKQ	ETF	23.91	23.91	23.52	23.57	9400.0
2017-01-26	ARKW	ETF	27.77	27.77	27.61	27.706	3000.0
2017-01-26	ASEA	ETF	13.65	13.65	13.57	13.57	2200.0
2017-01-26	ASET	ETF	26.09	26.09	26.013	26.04	3682.0
2017-01-26	ASHR	ETF	24.9	24.9	24.82	24.85	370200.0
2017-01-26	ASHS	ETF	33.31	33.31	33.13	33.15	2600.0
2017-01-26	ATMP	ETF	24.59	24.66	24.47	24.63	73300.0
2017-01-26	BAB	ETF	29.03	29.06	28.9315	29.01	203331.0
2017-01-26	BAL	ETF	49.23	49.48	49.0	49.0	8142.0
2017-01-26	BBC	ETF	19.27	19.4391	19.05	19.2758	5665.0
2017-01-26	BBH	ETF	111.63	112.31	110.98	111.04	73400.0
2017-01-26	BBP	ETF	34.29	34.552	33.97	34.224	7600.0

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

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