PREVIEW / etf_daily / 2016-05-26

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-26.parquet
  size:    50 KB
  rows:    1,251

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-05-26	SPY	ETF	209.44	209.71	208.97	209.34	55280700.0
2016-05-26	QQQ	ETF	109.35	109.7	109.09	109.56	21885871.0
2016-05-26	IWM	ETF	113.77	114.02	113.25	113.47	15157200.0
2016-05-26	DIA	ETF	178.49	178.69	177.82	178.08	2263200.0
2016-05-26	GLD	ETF	117.57	117.63	116.39	116.58	5893500.0
2016-05-26	TLT	ETF	129.81	130.45	129.8	130.04	5419300.0
2016-05-26	AADR	ETF	38.3	38.3	37.95	38.03	600.0
2016-05-26	AAXJ	ETF	52.75	52.82	52.56	52.67	958400.0
2016-05-26	ACTX	ETF	5.192	5.31	4.72	4.72	56.0
2016-05-26	ACWF	ETF	23.13	23.1499	23.13	23.1499	940.0
2016-05-26	ACWI	ETF	57.06	57.17	56.95	57.08	1229300.0
2016-05-26	ACWV	ETF	73.69	73.87	73.59	73.77	188500.0
2016-05-26	ACWX	ETF	40.14	40.27	40.09	40.18	1966815.0
2016-05-26	ADRE	ETF	30.33	30.48	30.33	30.388	3241.0
2016-05-26	AFK	ETF	20.59	20.92	20.21	20.4399	12998.0
2016-05-26	AFTY	ETF	12.223	12.23	12.2	12.2	3900.0
2016-05-26	AGG	ETF	110.64	110.73	110.56	110.65	1614800.0
2016-05-26	AGGY	ETF	50.74	50.81	50.68	50.684	3600.0
2016-05-26	AGQ	ETF	37.2	37.43	36.22	36.31	165800.0
2016-05-26	AGZ	ETF	114.56	114.83	114.4599	114.8	44424.0
2016-05-26	AGZD	ETF	23.935	23.935	23.93	23.935	6600.0
2016-05-26	AIA	ETF	42.06	42.17	42.03	42.1286	13581.0
2016-05-26	AIQ	ETF	7.36	7.36	7.01	7.15	24847.0
2016-05-26	AIRR	ETF	18.16	18.16	18.05	18.061	5600.0
2016-05-26	AIVI	ETF	38.83	38.89	38.77	38.82	11100.0
2016-05-26	ALTY	ETF	14.57	14.57	14.57	14.57	200.0
2016-05-26	AMJ	ETF	30.57	30.69	29.98	30.14	1574208.0
2016-05-26	AMLP	ETF	62.35	62.5	60.95	61.15	1546680.0
2016-05-26	AMZA	ETF	110.5	110.5	107.5	108.2	12100.0
2016-05-26	ANGL	ETF	27.05	27.05	26.92	26.95	60600.0
2016-05-26	AOA	ETF	45.86	45.92	45.77	45.9	17200.0
2016-05-26	AOK	ETF	32.49	32.54	32.42	32.52	69625.0
2016-05-26	AOM	ETF	35.0	35.0499	34.8601	34.99	60041.0
2016-05-26	AOR	ETF	39.91	39.91	39.71	39.77	86291.0
2016-05-26	ARGT	ETF	20.75	20.87	20.62	20.84	82900.0
2016-05-26	ARKG	ETF	17.61	17.61	17.61	17.61	100.0
2016-05-26	ARKK	ETF	19.14	19.22	19.14	19.22	1100.0
2016-05-26	ARKQ	ETF	19.15	19.15	19.149	19.149	1000.0
2016-05-26	ARKW	ETF	21.5	21.5	21.5	21.5	200.0
2016-05-26	ASEA	ETF	12.83	12.98	12.82	12.85	2300.0
2016-05-26	ASHR	ETF	23.17	23.26	23.0	23.04	359000.0
2016-05-26	ASHS	ETF	31.87	31.89	31.74	31.74	25200.0
2016-05-26	ASHX	ETF	20.753	20.753	20.7508	20.7508	290.0
2016-05-26	ATMP	ETF	20.81	20.81	20.45	20.58	13600.0
2016-05-26	BAB	ETF	30.54	30.67	30.5	30.64	352575.0
2016-05-26	BAL	ETF	42.55	42.7899	42.55	42.647	2211.0
2016-05-26	BBC	ETF	20.25	20.25	20.04	20.04	2540.0
2016-05-26	BBH	ETF	108.05	109.14	108.0	108.35	135200.0
2016-05-26	BBP	ETF	27.2	27.2	27.01	27.01	2200.0
2016-05-26	BCM	ETF	26.5901	26.68	26.5901	26.68	10633.0

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

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