PREVIEW / etf_daily / 2016-12-02

all etf daily files

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

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-02	SPY	ETF	219.67	220.25	219.26	219.68	74840300.0
2016-12-02	QQQ	ETF	115.57	116.16	115.22	115.7	32876845.0
2016-12-02	IWM	ETF	130.94	131.47	130.52	130.9	24054100.0
2016-12-02	DIA	ETF	191.91	191.98	191.43	191.74	2773600.0
2016-12-02	GLD	ETF	111.89	112.32	111.78	112.14	7416500.0
2016-12-02	TLT	ETF	119.17	120.21	119.14	119.6	12487500.0
2016-12-02	AADR	ETF	40.27	40.27	39.81	39.81	2300.0
2016-12-02	AAXJ	ETF	56.62	56.85	56.5	56.62	669100.0
2016-12-02	ACSI	ETF	26.65	26.65	26.53	26.56	8930.0
2016-12-02	ACTX	ETF	21.2402	22.4202	15.2221	19.7652	4758.0
2016-12-02	ACWI	ETF	58.27	58.51	58.24	58.39	1726000.0
2016-12-02	ACWV	ETF	71.94	72.28	71.94	72.07	337600.0
2016-12-02	ACWX	ETF	39.66	39.91	39.66	39.83	1214635.0
2016-12-02	ADRE	ETF	32.43	32.6889	32.43	32.55	4059.0
2016-12-02	AFK	ETF	19.55	19.55	19.3321	19.51	8057.0
2016-12-02	AFTY	ETF	14.2	14.2	14.125	14.125	1600.0
2016-12-02	AGG	ETF	107.93	108.2	107.85	108.02	4269200.0
2016-12-02	AGGY	ETF	49.61	49.82	49.61	49.78	129600.0
2016-12-02	AGNG	ETF	15.265	15.265	15.265	15.265	100.0
2016-12-02	AGQ	ETF	34.97	36.06	34.87	35.67	282600.0
2016-12-02	AGZ	ETF	113.07	113.15	110.31	112.88	16916.0
2016-12-02	AGZD	ETF	24.0	24.05	24.0	24.05	19800.0
2016-12-02	AIA	ETF	47.81	48.08	47.81	47.99	32586.0
2016-12-02	AIQ	ETF	7.45	7.7	7.45	7.5	7543.0
2016-12-02	AIRR	ETF	23.22	23.22	22.87	22.91	78900.0
2016-12-02	AIVI	ETF	36.25	36.56	36.25	36.48	22700.0
2016-12-02	ALTY	ETF	14.636	14.636	14.636	14.636	400.0
2016-12-02	AMJ	ETF	29.85	30.09	29.63	29.79	3113737.0
2016-12-02	AMLP	ETF	60.7	61.4	60.5	61.0	2094240.0
2016-12-02	AMZA	ETF	107.2	108.6	107.2	107.9	48800.0
2016-12-02	ANGL	ETF	28.6	28.69	28.53	28.66	1836700.0
2016-12-02	AOA	ETF	46.57	46.73	46.57	46.69	144400.0
2016-12-02	AOK	ETF	32.27	32.38	32.2269	32.31	91989.0
2016-12-02	AOM	ETF	35.0	35.1	34.88	35.05	247951.0
2016-12-02	AOR	ETF	40.03	40.22	40.03	40.22	186679.0
2016-12-02	ARGT	ETF	22.8	23.07	22.76	22.97	10300.0
2016-12-02	ARKG	ETF	17.594	17.594	17.594	17.594	800.0
2016-12-02	ARKK	ETF	19.795	19.795	19.795	19.795	100.0
2016-12-02	ARKQ	ETF	21.03	21.03	20.98	20.98	700.0
2016-12-02	ARKW	ETF	24.61	24.61	24.46	24.475	4000.0
2016-12-02	ASEA	ETF	13.12	13.26	13.12	13.14	8100.0
2016-12-02	ASHR	ETF	25.9	25.97	25.85	25.93	868400.0
2016-12-02	ASHS	ETF	34.69	34.69	34.36	34.43	38800.0
2016-12-02	ASHX	ETF	24.284	24.284	24.284	24.284	100.0
2016-12-02	ATMP	ETF	22.26	22.63	22.21	22.4	117000.0
2016-12-02	BAB	ETF	29.25	29.33	29.18	29.27	183675.0
2016-12-02	BAL	ETF	46.67	47.03	46.0982	46.74	21252.0
2016-12-02	BBC	ETF	19.05	19.634	19.05	19.488	45777.0
2016-12-02	BBH	ETF	106.76	108.13	106.3	107.31	62700.0
2016-12-02	BBP	ETF	33.07	33.64	32.62	33.45	16700.0

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

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