PREVIEW / etf_daily / 2016-05-24

all etf daily files

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

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-24	SPY	ETF	206.17	208.24	206.14	207.87	93537800.0
2016-05-24	QQQ	ETF	106.92	108.59	106.885	108.46	29931309.0
2016-05-24	IWM	ETF	111.31	113.22	111.27	112.94	41124300.0
2016-05-24	DIA	ETF	175.76	177.23	175.65	176.86	2797000.0
2016-05-24	GLD	ETF	118.17	118.23	117.25	117.3	12772000.0
2016-05-24	TLT	ETF	129.97	130.19	129.24	129.86	5968200.0
2016-05-24	AADR	ETF	37.92	38.53	37.92	38.07	2100.0
2016-05-24	AAXJ	ETF	51.52	51.97	51.5	51.88	404800.0
2016-05-24	ACTX	ETF	5.9001	5.9001	5.015	5.015	325.0
2016-05-24	ACWF	ETF	22.925	22.925	22.9	22.905	1000.0
2016-05-24	ACWI	ETF	56.04	56.59	56.03	56.5	2649300.0
2016-05-24	ACWV	ETF	72.95	73.4	72.82	73.33	967700.0
2016-05-24	ACWX	ETF	39.42	39.72	39.35	39.67	502268.0
2016-05-24	ADRE	ETF	29.89	30.1599	29.89	30.1001	5345.0
2016-05-24	AFK	ETF	19.77	20.08	19.77	19.87	39453.0
2016-05-24	AFTY	ETF	12.17	12.31	12.17	12.25	32100.0
2016-05-24	AGG	ETF	110.56	110.56	110.34	110.46	1759800.0
2016-05-24	AGGY	ETF	50.68	50.688	50.55	50.55	13200.0
2016-05-24	AGQ	ETF	36.31	36.79	35.8	35.9	194600.0
2016-05-24	AGZ	ETF	114.51	114.78	114.4599	114.54	19559.0
2016-05-24	AIA	ETF	41.34	41.4997	41.33	41.47	22568.0
2016-05-24	AIQ	ETF	7.21	7.37	7.15	7.29	13148.0
2016-05-24	AIRR	ETF	17.829	17.896	17.829	17.89	800.0
2016-05-24	AIVI	ETF	38.13	38.38	38.09	38.31	12300.0
2016-05-24	ALTY	ETF	14.57	14.57	14.57	14.57	200.0
2016-05-24	AMJ	ETF	31.1	31.28	30.56	30.63	2693624.0
2016-05-24	AMLP	ETF	62.35	62.8	61.1	61.35	2481780.0
2016-05-24	AMZA	ETF	111.2	111.3	108.3	108.6	38990.0
2016-05-24	ANGL	ETF	26.84	26.89	26.77	26.89	32600.0
2016-05-24	AOA	ETF	45.08	45.56	45.08	45.51	33900.0
2016-05-24	AOK	ETF	32.23	32.388	32.21	32.36	53644.0
2016-05-24	AOM	ETF	34.67	34.8899	34.67	34.84	81256.0
2016-05-24	AOR	ETF	39.29	39.55	39.25	39.55	66079.0
2016-05-24	ARGT	ETF	20.64	20.68	20.47	20.53	33000.0
2016-05-24	ARKG	ETF	17.204	17.5	17.204	17.5	300.0
2016-05-24	ARKK	ETF	18.938	18.938	18.92	18.92	200.0
2016-05-24	ARKQ	ETF	18.891	18.98	18.891	18.964	300.0
2016-05-24	ARKW	ETF	21.27	21.457	21.27	21.45	3700.0
2016-05-24	ASHR	ETF	22.92	23.28	22.91	23.27	1033800.0
2016-05-24	ASHS	ETF	31.87	32.08	31.87	31.99	21000.0
2016-05-24	ASHX	ETF	20.82	20.91	20.82	20.91	740.0
2016-05-24	ATMP	ETF	21.47	21.47	20.98	21.07	28000.0
2016-05-24	BAB	ETF	30.59	30.59	30.41	30.47	470091.0
2016-05-24	BAL	ETF	41.2	41.94	41.2	41.71	1534.0
2016-05-24	BBC	ETF	19.64	19.82	19.5299	19.7999	17780.0
2016-05-24	BBH	ETF	106.43	108.07	105.99	107.93	88300.0
2016-05-24	BBP	ETF	26.864	27.1	26.856	27.096	7200.0
2016-05-24	BCM	ETF	26.403	26.403	26.403	26.403	1897.0
2016-05-24	BDCZ	ETF	20.0199	20.0301	19.91	19.96	3100.0
2016-05-24	BFOR	ETF	7.4775	7.6075	7.4775	7.5975	69200.0

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

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