PREVIEW / etf_daily / 2016-12-07

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-07.parquet
  size:    54 KB
  rows:    1,355

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-12-07	SPY	ETF	221.52	224.67	221.38	224.6	110738100.0
2016-12-07	QQQ	ETF	116.64	118.51	116.2919	118.36	26622442.0
2016-12-07	IWM	ETF	134.59	136.18	134.18	135.9	31825800.0
2016-12-07	DIA	ETF	192.47	195.69	192.42	195.48	7241300.0
2016-12-07	GLD	ETF	112.13	112.5	111.77	111.83	4901800.0
2016-12-07	TLT	ETF	119.82	120.62	119.82	120.4	10392200.0
2016-12-07	AADR	ETF	40.75	40.94	40.54	40.85	22000.0
2016-12-07	AAXJ	ETF	57.27	57.82	57.12	57.68	1068200.0
2016-12-07	ACSI	ETF	26.86	27.26	26.8475	27.24	10935.0
2016-12-07	ACTX	ETF	21.2402	22.4202	20.6502	22.4202	810.0
2016-12-07	ACWF	ETF	24.24	24.5421	24.24	24.5421	521.0
2016-12-07	ACWI	ETF	59.15	59.96	59.14	59.92	2294700.0
2016-12-07	ACWV	ETF	72.27	73.18	72.27	73.13	159800.0
2016-12-07	ACWX	ETF	40.57	41.045	40.5429	40.97	860887.0
2016-12-07	ADRE	ETF	33.04	33.45	33.04	33.44	16647.0
2016-12-07	AFK	ETF	19.67	20.24	19.67	20.2	65229.0
2016-12-07	AFTY	ETF	13.9	13.9	13.88	13.89	4200.0
2016-12-07	AGG	ETF	108.22	108.38	108.2	108.37	3796800.0
2016-12-07	AGGY	ETF	49.6	49.74	49.6	49.717	7100.0
2016-12-07	AGNG	ETF	15.1	15.144	15.1	15.144	400.0
2016-12-07	AGQ	ETF	37.22	37.9	37.13	37.5	275000.0
2016-12-07	AGZ	ETF	112.58	113.07	112.58	112.83	36171.0
2016-12-07	AGZD	ETF	23.89	24.055	23.89	24.0	25200.0
2016-12-07	AIA	ETF	48.48	48.9902	48.4591	48.94	16541.0
2016-12-07	AIQ	ETF	8.1	8.85	7.95	8.0	133072.0
2016-12-07	AIRR	ETF	23.62	23.88	23.542	23.831	215000.0
2016-12-07	AIVI	ETF	37.23	37.72	37.23	37.7	21900.0
2016-12-07	ALTY	ETF	15.21	15.21	14.81	14.82	3500.0
2016-12-07	AMJ	ETF	29.79	29.965	29.62	29.89	1666110.0
2016-12-07	AMLP	ETF	60.6	61.05	60.25	60.95	1803480.0
2016-12-07	AMZA	ETF	107.8	107.8	106.8	107.7	15490.0
2016-12-07	ANGL	ETF	28.86	28.97	28.84	28.97	200200.0
2016-12-07	AOA	ETF	47.27	47.73	47.18	47.68	125300.0
2016-12-07	AOK	ETF	32.53	32.64	32.4501	32.61	96526.0
2016-12-07	AOM	ETF	35.21	35.52	35.1925	35.51	261742.0
2016-12-07	AOR	ETF	40.52	40.8999	40.5001	40.85	528933.0
2016-12-07	ARGT	ETF	23.48	23.5	23.33	23.47	30200.0
2016-12-07	ARKG	ETF	17.16	17.16	17.08	17.09	1100.0
2016-12-07	ARKK	ETF	20.03	20.08	19.94	20.08	1100.0
2016-12-07	ARKQ	ETF	21.68	21.68	21.68	21.68	100.0
2016-12-07	ARKW	ETF	25.089	25.14	25.089	25.116	500.0
2016-12-07	ASEA	ETF	13.29	13.4	13.29	13.39	2400.0
2016-12-07	ASET	ETF	25.654	25.654	25.654	25.654	876.0
2016-12-07	ASHR	ETF	25.48	25.6	25.43	25.58	740300.0
2016-12-07	ASHS	ETF	34.35	34.68	34.35	34.67	3600.0
2016-12-07	ATMP	ETF	22.43	22.55	22.24	22.55	134400.0
2016-12-07	BAB	ETF	29.39	29.42	29.2901	29.37	191413.0
2016-12-07	BAL	ETF	46.84	46.9614	46.321	46.81	6902.0
2016-12-07	BBC	ETF	20.19	20.19	19.16	19.56	28220.0
2016-12-07	BBH	ETF	106.91	107.26	104.64	106.42	116400.0

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

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