PREVIEW / etf_daily / 2016-04-27

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-27.parquet
  size:    50 KB
  rows:    1,257

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-04-27	SPY	ETF	208.47	209.81	208.05	209.35	77329400.0
2016-04-27	QQQ	ETF	107.34	107.83	106.69	107.58	33059790.0
2016-04-27	IWM	ETF	114.48	115.05	113.9	114.81	24360300.0
2016-04-27	DIA	ETF	179.12	180.65	178.99	180.25	3569300.0
2016-04-27	GLD	ETF	118.97	119.7	118.43	119.04	7976400.0
2016-04-27	TLT	ETF	127.92	128.82	127.62	128.52	8380100.0
2016-04-27	AADR	ETF	38.96	38.96	38.96	38.96	200.0
2016-04-27	AAXJ	ETF	54.75	55.37	54.71	55.23	1009300.0
2016-04-27	ACTX	ETF	4.13	4.72	3.953	3.953	924.0
2016-04-27	ACWI	ETF	57.34	57.71	57.24	57.59	1078600.0
2016-04-27	ACWV	ETF	73.83	74.26	73.58	74.11	102000.0
2016-04-27	ACWX	ETF	40.76	41.035	40.72	40.99	341917.0
2016-04-27	ADRE	ETF	31.7	32.058	31.7	32.058	10713.0
2016-04-27	AFK	ETF	20.04	20.5	19.9979	20.21	44522.0
2016-04-27	AFTY	ETF	12.83	12.88	12.77	12.8	18900.0
2016-04-27	AGG	ETF	110.53	110.69	110.33	110.68	2337100.0
2016-04-27	AGGY	ETF	50.71	50.79	50.69	50.79	7400.0
2016-04-27	AGQ	ETF	40.79	41.22	39.95	40.74	315100.0
2016-04-27	AGZ	ETF	114.5	114.51	114.268	114.47	12590.0
2016-04-27	AGZD	ETF	23.905	23.905	23.905	23.905	600.0
2016-04-27	AIA	ETF	43.82	44.1506	43.77	44.1506	10273.0
2016-04-27	AIQ	ETF	7.02	7.16	7.0	7.03	7740.0
2016-04-27	AIRR	ETF	18.23	18.37	18.2	18.35	2300.0
2016-04-27	AIVI	ETF	39.48	39.74	39.48	39.69	17900.0
2016-04-27	AMJ	ETF	29.87	30.34	29.61	30.02	2934567.0
2016-04-27	AMLP	ETF	60.35	61.8	60.25	61.1	2382340.0
2016-04-27	AMZA	ETF	103.0	105.9	102.6	104.8	6570.0
2016-04-27	ANGL	ETF	27.09	27.17	27.02	27.14	82000.0
2016-04-27	AOA	ETF	46.03	46.23	45.91	46.17	25300.0
2016-04-27	AOK	ETF	32.49	32.59	32.4201	32.59	35668.0
2016-04-27	AOM	ETF	35.06	35.12	34.91	35.1	90018.0
2016-04-27	AOR	ETF	39.94	40.0195	39.78	39.96	159561.0
2016-04-27	ARGT	ETF	20.62	20.85	20.62	20.83	31400.0
2016-04-27	ARKG	ETF	18.23	18.23	18.2	18.21	600.0
2016-04-27	ARKK	ETF	19.51	19.51	19.47	19.47	300.0
2016-04-27	ARKQ	ETF	19.541	19.541	19.541	19.541	100.0
2016-04-27	ARKW	ETF	21.1	21.1	20.95	21.068	1400.0
2016-04-27	ASEA	ETF	13.38	13.5	13.38	13.5	2500.0
2016-04-27	ASHR	ETF	23.95	24.16	23.95	24.1	747400.0
2016-04-27	ASHS	ETF	33.51	33.74	33.51	33.68	42900.0
2016-04-27	ATMP	ETF	20.74	20.8	20.53	20.63	66800.0
2016-04-27	BAB	ETF	29.92	30.07	29.92	30.01	234991.0
2016-04-27	BAL	ETF	42.31	42.57	42.28	42.57	2292.0
2016-04-27	BBC	ETF	20.57	20.6028	20.1558	20.51	3525.0
2016-04-27	BBH	ETF	111.28	111.32	109.63	110.17	49100.0
2016-04-27	BBP	ETF	26.75	26.781	26.368	26.69	2300.0
2016-04-27	BCM	ETF	26.14	26.23	25.9	26.2033	123056.0
2016-04-27	BFOR	ETF	7.75	7.7825	7.725	7.7775	28000.0
2016-04-27	BIB	ETF	47.2	47.23	45.52	46.04	602987.0
2016-04-27	BICK	ETF	20.7399	20.7399	20.7399	20.7399	408.0

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

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