PREVIEW / etf_daily / 2016-10-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-21.parquet
  size:    51 KB
  rows:    1,292

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-10-21	SPY	ETF	213.88	214.08	212.76	213.98	89089100.0
2016-10-21	QQQ	ETF	117.8	118.22	117.41	118.15	15707804.0
2016-10-21	IWM	ETF	120.26	121.37	120.1	121.07	21093700.0
2016-10-21	DIA	ETF	180.6	181.45	180.23	181.22	5607600.0
2016-10-21	GLD	ETF	120.9	120.93	120.55	120.83	6707800.0
2016-10-21	TLT	ETF	133.52	133.72	132.87	133.31	9222700.0
2016-10-21	AADR	ETF	41.47	41.88	41.47	41.83	1200.0
2016-10-21	AAXJ	ETF	59.6	59.93	59.56	59.86	192100.0
2016-10-21	ACTX	ETF	12.3901	12.3901	10.0301	12.3901	1584.0
2016-10-21	ACWF	ETF	23.6655	23.6655	23.6655	23.6655	133.0
2016-10-21	ACWI	ETF	58.2	58.48	58.14	58.44	669200.0
2016-10-21	ACWV	ETF	73.9	74.08	73.73	74.03	100700.0
2016-10-21	ACWX	ETF	40.88	41.08	40.82	41.08	1593249.0
2016-10-21	ADRE	ETF	35.75	35.9	35.63	35.8501	5206.0
2016-10-21	AFK	ETF	20.25	20.35	20.2425	20.316	7827.0
2016-10-21	AFTY	ETF	13.59	13.61	13.5	13.5	7100.0
2016-10-21	AGG	ETF	111.8	111.9	111.69	111.83	1776900.0
2016-10-21	AGGY	ETF	51.74	51.82	51.71	51.81	22800.0
2016-10-21	AGQ	ETF	39.89	40.04	39.57	39.99	138200.0
2016-10-21	AGZ	ETF	115.24	115.25	114.81	115.12	26481.0
2016-10-21	AGZD	ETF	23.99	23.99	23.99	23.99	200.0
2016-10-21	AIA	ETF	49.38	49.745	49.28	49.69	59134.0
2016-10-21	AIQ	ETF	7.8	7.95	7.8	7.9	7923.0
2016-10-21	AIRR	ETF	19.68	19.81	19.59	19.775	3600.0
2016-10-21	AIVI	ETF	37.7	37.95	37.7	37.92	19200.0
2016-10-21	ALTY	ETF	15.21	15.27	15.198	15.255	5700.0
2016-10-21	AMJ	ETF	31.47	31.47	31.201	31.33	1701021.0
2016-10-21	AMLP	ETF	63.1	63.35	63.0	63.3	1012420.0
2016-10-21	AMZA	ETF	108.1	109.8	108.1	109.4	4990.0
2016-10-21	ANGL	ETF	29.19	29.24	29.15	29.24	49000.0
2016-10-21	AOA	ETF	46.65	46.91	46.65	46.91	20500.0
2016-10-21	AOK	ETF	33.0	33.1099	33.0	33.1	26361.0
2016-10-21	AOM	ETF	35.61	35.68	35.54	35.68	60062.0
2016-10-21	AOR	ETF	40.5	40.6	40.4519	40.58	33511.0
2016-10-21	ARGT	ETF	24.25	24.42	24.18	24.32	26600.0
2016-10-21	ARKG	ETF	17.74	17.74	17.67	17.67	1400.0
2016-10-21	ARKK	ETF	20.42	20.53	20.42	20.53	1000.0
2016-10-21	ARKQ	ETF	21.19	21.25	21.07	21.25	1500.0
2016-10-21	ARKW	ETF	24.97	24.97	24.699	24.96	3500.0
2016-10-21	ASEA	ETF	13.81	13.84	13.74	13.84	1100.0
2016-10-21	ASHR	ETF	24.76	24.8	24.68	24.7	702800.0
2016-10-21	ASHS	ETF	34.86	34.9	34.84	34.9	5800.0
2016-10-21	ATMP	ETF	23.26	23.26	23.09	23.22	15500.0
2016-10-21	BAB	ETF	30.94	30.99	30.82	30.97	94362.0
2016-10-21	BAL	ETF	45.65	45.85	45.55	45.7713	10148.0
2016-10-21	BBC	ETF	19.93	20.04	19.9251	19.9251	1419.0
2016-10-21	BBH	ETF	107.48	107.48	106.52	106.84	47200.0
2016-10-21	BBP	ETF	30.66	30.66	30.359	30.36	6000.0
2016-10-21	BCM	ETF	26.7	26.7	26.6698	26.6733	4926.0
2016-10-21	BFOR	ETF	7.8775	7.925	7.865	7.925	26400.0

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

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