PREVIEW / etf_daily / 2016-12-01

all etf daily files

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

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-01	SPY	ETF	220.73	220.73	219.15	219.57	79040500.0
2016-12-01	QQQ	ETF	117.46	117.47	115.29	115.47	39796590.0
2016-12-01	IWM	ETF	132.25	132.55	130.29	130.97	39815900.0
2016-12-01	DIA	ETF	191.84	192.16	191.57	191.9	8323900.0
2016-12-01	GLD	ETF	111.11	111.99	110.63	111.54	10237000.0
2016-12-01	TLT	ETF	118.51	118.99	117.64	118.73	21715700.0
2016-12-01	AADR	ETF	40.45	40.45	39.75	39.75	4200.0
2016-12-01	AAXJ	ETF	57.08	57.13	56.72	56.86	1278600.0
2016-12-01	ACSI	ETF	26.56	26.5777	26.48	26.5081	8690.0
2016-12-01	ACTX	ETF	26.5502	28.8513	18.8802	22.4202	4766.0
2016-12-01	ACWF	ETF	24.23	24.23	24.0117	24.0117	292.0
2016-12-01	ACWI	ETF	58.59	58.63	58.22	58.29	10381000.0
2016-12-01	ACWV	ETF	72.44	72.44	71.8	71.92	401500.0
2016-12-01	ACWX	ETF	39.95	39.95	39.7	39.74	1149325.0
2016-12-01	ADRE	ETF	33.32	33.32	32.45	32.45	8344.0
2016-12-01	AFK	ETF	19.44	19.5	19.2297	19.29	11951.0
2016-12-01	AFTY	ETF	14.17	14.181	14.17	14.181	1500.0
2016-12-01	AGG	ETF	107.75	107.79	107.47	107.68	4691900.0
2016-12-01	AGGY	ETF	49.63	49.64	49.47	49.53	6700.0
2016-12-01	AGNG	ETF	15.265	15.265	15.265	15.265	100.0
2016-12-01	AGQ	ETF	34.26	35.57	33.96	34.83	206400.0
2016-12-01	AGZ	ETF	112.53	112.7	112.26	112.57	36335.0
2016-12-01	AGZD	ETF	23.95	24.07	23.95	24.065	6600.0
2016-12-01	AIA	ETF	48.34	48.36	48.19	48.23	28878.0
2016-12-01	AIQ	ETF	7.5497	7.6	7.35	7.5	15085.0
2016-12-01	AIRR	ETF	23.06	23.25	23.01	23.07	207200.0
2016-12-01	AIVI	ETF	36.37	36.52	36.26	36.41	27000.0
2016-12-01	ALTY	ETF	14.64	14.64	14.579	14.579	2800.0
2016-12-01	AMJ	ETF	30.62	30.6701	29.61	29.65	4352405.0
2016-12-01	AMLP	ETF	62.7	62.7	60.5	60.6	2511660.0
2016-12-01	AMZA	ETF	110.2	110.2	106.44	107.15	21700.0
2016-12-01	ANGL	ETF	28.58	28.58	28.45	28.49	1380400.0
2016-12-01	AOA	ETF	46.88	46.91	46.5	46.62	196800.0
2016-12-01	AOK	ETF	32.49	32.49	32.2	32.28	108999.0
2016-12-01	AOM	ETF	35.01	35.07	34.92	35.0	243642.0
2016-12-01	AOR	ETF	40.22	40.26	40.0196	40.14	264323.0
2016-12-01	ARGT	ETF	23.09	23.09	22.84	22.84	6700.0
2016-12-01	ARKG	ETF	17.8	17.8	17.32	17.32	1200.0
2016-12-01	ARKK	ETF	19.64	19.64	19.64	19.64	200.0
2016-12-01	ARKQ	ETF	21.11	21.11	21.055	21.055	1300.0
2016-12-01	ARKW	ETF	25.16	25.274	25.16	25.18	500.0
2016-12-01	ASEA	ETF	13.03	13.12	13.0	13.05	1500.0
2016-12-01	ASHR	ETF	26.09	26.19	26.08	26.18	771200.0
2016-12-01	ASHS	ETF	35.0	35.0	34.9	34.99	9700.0
2016-12-01	ATMP	ETF	23.2	23.2	22.15	22.33	277200.0
2016-12-01	BAB	ETF	29.18	29.265	29.03	29.12	221125.0
2016-12-01	BAL	ETF	47.05	47.45	46.48	46.54	23445.0
2016-12-01	BBC	ETF	20.02	20.04	19.1957	19.1957	8678.0
2016-12-01	BBH	ETF	109.42	109.42	106.83	107.06	61100.0
2016-12-01	BBP	ETF	34.29	34.29	33.05	33.061	8500.0

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

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