PREVIEW / etf_daily / 2017-01-09

all etf daily files

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

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-09	SPY	ETF	226.91	227.07	226.42	226.46	46939700.0
2017-01-09	QQQ	ETF	122.03	122.55	121.95	122.33	18909234.0
2017-01-09	IWM	ETF	135.54	135.72	134.5	134.8	24077900.0
2017-01-09	DIA	ETF	199.09	199.27	198.75	198.76	2303500.0
2017-01-09	GLD	ETF	112.39	113.04	112.18	112.67	5674600.0
2017-01-09	TLT	ETF	121.88	122.0	121.46	121.83	8839100.0
2017-01-09	AADR	ETF	42.58	42.6	42.42	42.42	2100.0
2017-01-09	AAXJ	ETF	56.51	56.74	56.5	56.58	878000.0
2017-01-09	ACSI	ETF	27.1	27.14	27.1	27.1	6450.0
2017-01-09	ACTX	ETF	28.3203	29.5003	25.3702	27.1402	2116.0
2017-01-09	ACWF	ETF	24.5635	25.29	24.5635	24.65	3889.0
2017-01-09	ACWI	ETF	60.22	60.33	60.15	60.24	1474600.0
2017-01-09	ACWV	ETF	73.62	73.62	73.39	73.42	155900.0
2017-01-09	ACWX	ETF	41.03	41.14	40.975	41.06	1762288.0
2017-01-09	ADRE	ETF	33.59	33.7	33.4975	33.65	13295.0
2017-01-09	AFK	ETF	20.47	20.73	20.35	20.73	13450.0
2017-01-09	AFTY	ETF	13.348	13.348	13.32	13.32	1100.0
2017-01-09	AGG	ETF	108.54	108.54	108.43	108.47	3030500.0
2017-01-09	AGGY	ETF	49.831	49.89	49.81	49.89	6400.0
2017-01-09	AGQ	ETF	34.72	35.2	34.49	34.7	131900.0
2017-01-09	AGZ	ETF	112.94	112.955	112.73	112.73	15019.0
2017-01-09	AGZD	ETF	24.105	24.105	24.01	24.065	30400.0
2017-01-09	AIA	ETF	47.52	47.65	47.52	47.55	132503.0
2017-01-09	AIQ	ETF	9.65	9.7	9.65	9.7	20046.0
2017-01-09	AIRR	ETF	23.71	23.71	23.212	23.24	105600.0
2017-01-09	AIVI	ETF	37.94	38.04	37.89	37.96	31000.0
2017-01-09	ALTY	ETF	15.31	15.311	15.28	15.311	2300.0
2017-01-09	AMJ	ETF	32.43	32.43	31.94	32.01	1740757.0
2017-01-09	AMLP	ETF	64.3	64.3	63.65	63.7	1813540.0
2017-01-09	AMZA	ETF	109.6	110.0	108.7	109.1	73860.0
2017-01-09	ANGL	ETF	29.12	29.12	29.07	29.1	142800.0
2017-01-09	AOA	ETF	47.89	47.9	47.78	47.8	236500.0
2017-01-09	AOK	ETF	32.66	32.7544	32.63	32.63	125324.0
2017-01-09	AOM	ETF	35.5	35.53	35.43	35.5	665538.0
2017-01-09	AOR	ETF	41.08	41.08	40.89	40.94	933285.0
2017-01-09	ARGT	ETF	24.31	24.49	24.23	24.45	42700.0
2017-01-09	ARKG	ETF	18.23	18.38	18.16	18.38	2700.0
2017-01-09	ARKK	ETF	21.5	21.68	21.5	21.645	25000.0
2017-01-09	ARKQ	ETF	22.78	22.95	22.74	22.9	5000.0
2017-01-09	ARKW	ETF	26.77	26.78	26.62	26.72	2200.0
2017-01-09	ASEA	ETF	13.09	13.22	13.09	13.16	8400.0
2017-01-09	ASHR	ETF	24.38	24.38	24.22	24.28	403500.0
2017-01-09	ASHS	ETF	33.7	33.7	33.42	33.57	2400.0
2017-01-09	ASHX	ETF	19.1299	19.13	19.12	19.13	1058.0
2017-01-09	ATMP	ETF	23.87	24.03	23.8	23.84	109300.0
2017-01-09	BAB	ETF	29.37	29.4299	29.34	29.39	177397.0
2017-01-09	BAL	ETF	48.7084	48.81	48.03	48.0501	2530.0
2017-01-09	BBC	ETF	20.09	20.2199	19.86	20.21	3404.0
2017-01-09	BBH	ETF	114.38	115.48	113.63	115.32	156800.0
2017-01-09	BBP	ETF	35.09	36.197	35.09	36.107	20000.0

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

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