PREVIEW / etf_daily / 2016-09-02

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-02.parquet
  size:    52 KB
  rows:    1,305

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-09-02	SPY	ETF	218.39	218.87	217.7	218.37	79293900.0
2016-09-02	QQQ	ETF	117.32	117.56	116.68	117.12	18088215.0
2016-09-02	IWM	ETF	124.01	124.53	123.63	124.51	23083300.0
2016-09-02	DIA	ETF	184.94	185.42	184.32	184.86	2652800.0
2016-09-02	GLD	ETF	126.29	126.57	125.58	126.57	11318600.0
2016-09-02	TLT	ETF	138.96	139.05	138.17	138.63	8397000.0
2016-09-02	AADR	ETF	40.4	40.88	40.12	40.63	37700.0
2016-09-02	AAXJ	ETF	59.66	59.88	59.54	59.82	1455200.0
2016-09-02	ACTX	ETF	2.36	3.54	2.36	3.54	1947.0
2016-09-02	ACWI	ETF	59.07	59.28	59.07	59.22	2177300.0
2016-09-02	ACWV	ETF	76.44	76.71	76.32	76.55	193100.0
2016-09-02	ACWX	ETF	41.57	41.7	41.46	41.67	367015.0
2016-09-02	ADRE	ETF	34.69	34.719	34.65	34.6999	6390.0
2016-09-02	AFK	ETF	19.9501	20.81	19.95	20.48	8781.0
2016-09-02	AFTY	ETF	13.69	13.69	13.66	13.671	2700.0
2016-09-02	AGG	ETF	112.44	112.44	112.18	112.31	1730900.0
2016-09-02	AGGY	ETF	52.073	52.66	52.02	52.08	23400.0
2016-09-02	AGQ	ETF	48.94	50.0	48.31	49.68	275500.0
2016-09-02	AGZ	ETF	115.69	115.69	115.31	115.53	7196.0
2016-09-02	AGZD	ETF	24.025	24.025	23.9	23.9	1000.0
2016-09-02	AIA	ETF	49.04	49.13	48.96	49.07	35720.0
2016-09-02	AIQ	ETF	6.28	6.4	6.22	6.29	14206.0
2016-09-02	AIRR	ETF	19.83	19.89	19.781	19.844	4100.0
2016-09-02	AIVI	ETF	39.26	39.38	39.23	39.35	5600.0
2016-09-02	ALTY	ETF	15.85	15.85	15.58	15.708	1700.0
2016-09-02	AMJ	ETF	31.15	31.4	31.0	31.36	640675.0
2016-09-02	AMLP	ETF	63.15	63.3	62.6	63.05	917780.0
2016-09-02	AMZA	ETF	114.4	116.3	114.2	115.6	8130.0
2016-09-02	ANGL	ETF	28.72	28.76	28.64	28.66	125300.0
2016-09-02	AOA	ETF	47.48	47.7	47.48	47.63	26100.0
2016-09-02	AOK	ETF	33.35	33.4299	33.304	33.38	19164.0
2016-09-02	AOM	ETF	36.13	36.1699	36.0	36.1	41526.0
2016-09-02	AOR	ETF	41.18	41.22	41.0701	41.18	41201.0
2016-09-02	ARGT	ETF	22.83	23.08	22.8	23.07	54200.0
2016-09-02	ARKG	ETF	18.17	18.214	18.06	18.214	2700.0
2016-09-02	ARKK	ETF	20.63	20.693	20.62	20.693	1300.0
2016-09-02	ARKQ	ETF	21.26	21.27	21.18	21.18	800.0
2016-09-02	ARKW	ETF	24.42	24.59	24.42	24.54	1400.0
2016-09-02	ASEA	ETF	14.1	14.11	14.02	14.02	1500.0
2016-09-02	ASHR	ETF	25.15	25.15	25.08	25.12	825200.0
2016-09-02	ASHS	ETF	34.93	34.94	34.76	34.77	19400.0
2016-09-02	ATMP	ETF	22.68	22.85	22.65	22.84	27100.0
2016-09-02	BAB	ETF	31.61	31.65	31.5456	31.6	344376.0
2016-09-02	BAL	ETF	45.09	45.09	44.55	44.9256	21539.0
2016-09-02	BBC	ETF	20.18	20.18	19.911	19.92	13674.0
2016-09-02	BBH	ETF	114.14	114.42	113.35	113.7	38800.0
2016-09-02	BBP	ETF	30.098	30.44	30.098	30.36	7300.0
2016-09-02	BCM	ETF	25.59	25.63	25.59	25.63	469.0
2016-09-02	BFOR	ETF	8.12	8.145	8.105	8.145	41200.0
2016-09-02	BIB	ETF	46.19	46.52	45.47	45.81	452520.0

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

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