PREVIEW / etf_daily / 2016-08-02

all etf daily files

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

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-08-02	SPY	ETF	216.65	216.83	214.57	215.55	92295500.0
2016-08-02	QQQ	ETF	115.68	115.77	114.22	114.96	21278383.0
2016-08-02	IWM	ETF	121.16	121.21	119.1	119.48	28691000.0
2016-08-02	DIA	ETF	183.7	183.88	182.31	182.97	5139500.0
2016-08-02	GLD	ETF	130.04	130.55	129.94	130.27	7652800.0
2016-08-02	TLT	ETF	137.83	139.26	137.5	138.33	10051200.0
2016-08-02	AAXJ	ETF	57.52	57.65	57.02	57.36	571300.0
2016-08-02	ACTX	ETF	3.54	4.72	3.54	3.599	1220.0
2016-08-02	ACWI	ETF	58.13	58.13	57.56	57.8	922900.0
2016-08-02	ACWV	ETF	77.9	77.91	77.43	77.63	107800.0
2016-08-02	ACWX	ETF	40.27	40.29	39.995	40.16	1529293.0
2016-08-02	ADRE	ETF	33.0	33.0	32.443	32.61	2045.0
2016-08-02	AFK	ETF	20.15	20.87	20.15	20.6405	17752.0
2016-08-02	AFTY	ETF	13.06	13.08	13.02	13.07	8300.0
2016-08-02	AGG	ETF	112.36	112.46	112.19	112.22	3643900.0
2016-08-02	AGGY	ETF	51.87	51.99	51.841	51.91	4900.0
2016-08-02	AGQ	ETF	56.95	57.26	56.41	56.55	301500.0
2016-08-02	AGZ	ETF	115.82	115.82	115.531	115.75	10089.0
2016-08-02	AGZD	ETF	23.82	23.82	23.82	23.82	400.0
2016-08-02	AIA	ETF	47.18	47.2102	46.8	46.995	17654.0
2016-08-02	AIQ	ETF	5.82	6.21	5.76	5.77	22889.0
2016-08-02	AIRR	ETF	19.224	19.224	19.087	19.12	3400.0
2016-08-02	AIVI	ETF	38.39	38.41	38.16	38.29	14000.0
2016-08-02	ALTY	ETF	15.54	15.6	15.5	15.528	4100.0
2016-08-02	AMJ	ETF	30.95	31.29	30.46	30.93	5263051.0
2016-08-02	AMLP	ETF	63.4	63.5	61.7	63.0	1917240.0
2016-08-02	AMZA	ETF	108.1	111.79	107.7	109.0	8950.0
2016-08-02	ANGL	ETF	27.94	27.94	27.81	27.91	91800.0
2016-08-02	AOA	ETF	46.85	46.85	46.53	46.58	38300.0
2016-08-02	AOK	ETF	33.16	33.189	33.06	33.06	46640.0
2016-08-02	AOM	ETF	35.74	35.74	35.5501	35.6	109552.0
2016-08-02	AOR	ETF	40.58	40.65	40.41	40.5	67112.0
2016-08-02	ARGT	ETF	22.22	22.35	22.04	22.27	40200.0
2016-08-02	ARKG	ETF	18.625	18.625	18.625	18.625	500.0
2016-08-02	ARKK	ETF	20.154	20.213	20.154	20.213	700.0
2016-08-02	ARKQ	ETF	20.51	20.58	20.51	20.58	1000.0
2016-08-02	ARKW	ETF	24.34	24.34	23.86	23.9	1000.0
2016-08-02	ASEA	ETF	14.0	14.0	13.85	13.92	4600.0
2016-08-02	ASHR	ETF	23.96	24.07	23.96	24.05	661900.0
2016-08-02	ASHS	ETF	33.91	33.92	33.77	33.77	5300.0
2016-08-02	ASHX	ETF	21.835	21.835	21.835	21.835	115.0
2016-08-02	ATMP	ETF	22.12	22.2	21.67	21.96	19000.0
2016-08-02	BAB	ETF	31.52	31.6199	31.36	31.58	223777.0
2016-08-02	BAL	ETF	49.57	49.63	48.8	49.35	7344.0
2016-08-02	BBC	ETF	20.28	20.28	19.8	20.17	7650.0
2016-08-02	BBH	ETF	117.84	118.45	115.45	117.51	175900.0
2016-08-02	BBP	ETF	31.76	31.76	30.647	31.25	34900.0
2016-08-02	BCM	ETF	25.35	25.4	25.29	25.4	11472.0
2016-08-02	BFOR	ETF	7.9725	7.9725	7.865	7.8925	26800.0
2016-08-02	BIB	ETF	50.64	52.15	48.66	50.7	1244601.0

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

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