PREVIEW / etf_daily / 2015-05-19

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-19.parquet
  size:    48 KB
  rows:    1,180

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
2015-05-19	SPY	ETF	213.24	213.57	212.69	213.03	72114600.0
2015-05-19	QQQ	ETF	110.18	110.35	109.76	109.94	14212896.0
2015-05-19	IWM	ETF	124.8	125.05	124.31	124.88	23256800.0
2015-05-19	DIA	ETF	182.92	183.28	182.37	182.93	2766600.0
2015-05-19	GLD	ETF	116.55	116.73	115.65	115.89	5052100.0
2015-05-19	TLT	ETF	118.27	119.84	118.13	118.49	8435300.0
2015-05-19	AADR	ETF	40.46	40.46	40.43	40.43	1300.0
2015-05-19	AAXJ	ETF	67.85	67.93	67.73	67.88	859600.0
2015-05-19	ACTX	ETF	3.54	3.54	2.95	3.54	1739.0
2015-05-19	ACWI	ETF	62.73	62.9	62.68	62.75	780500.0
2015-05-19	ACWV	ETF	73.75	73.95	73.62	73.85	141400.0
2015-05-19	ACWX	ETF	47.41	47.49	47.33	47.38	531128.0
2015-05-19	ADRE	ETF	37.0	37.0	36.84	36.87	6779.0
2015-05-19	AFK	ETF	27.05	27.05	26.72	26.8	16789.0
2015-05-19	AFTY	ETF	22.08	22.21	21.985	22.19	90600.0
2015-05-19	AGG	ETF	109.46	109.71	109.39	109.4	1664400.0
2015-05-19	AGQ	ETF	45.13	45.26	42.38	43.65	394300.0
2015-05-19	AGZ	ETF	113.15	113.48	113.1201	113.2499	51754.0
2015-05-19	AGZD	ETF	24.49	24.545	24.425	24.425	7600.0
2015-05-19	AIA	ETF	53.37	53.37	53.2	53.2755	15609.0
2015-05-19	AIQ	ETF	20.825	20.83	20.51	20.55	8139.0
2015-05-19	AIRR	ETF	18.49	18.49	18.31	18.35	6100.0
2015-05-19	AIVI	ETF	46.38	46.45	46.19	46.38	12900.0
2015-05-19	ALTL	ETF	37.402	37.402	37.402	37.402	197.0
2015-05-19	AMJ	ETF	45.13	45.27	44.87	45.04	691997.0
2015-05-19	AMLP	ETF	84.6	84.75	84.2	84.45	551300.0
2015-05-19	AMZA	ETF	227.9	227.9	224.0	225.0	1130.0
2015-05-19	ANGL	ETF	27.63	27.63	27.61	27.62	9200.0
2015-05-19	AOA	ETF	48.93	48.95	48.77	48.84	24700.0
2015-05-19	AOK	ETF	33.1	33.1	32.968	33.0	34174.0
2015-05-19	AOM	ETF	36.02	36.02	35.8	35.8	41624.0
2015-05-19	AOR	ETF	41.6	41.68	41.5501	41.61	52844.0
2015-05-19	ARGT	ETF	21.99	22.04	21.93	21.98	7400.0
2015-05-19	ARKG	ETF	23.11	23.15	23.11	23.11	1200.0
2015-05-19	ARKK	ETF	21.28	21.28	21.26	21.26	800.0
2015-05-19	ARKQ	ETF	20.01	20.055	19.99	20.04	1000.0
2015-05-19	ARKW	ETF	23.07	23.1	23.05	23.1	1000.0
2015-05-19	ASEA	ETF	16.0	16.0	15.93	15.96	4600.0
2015-05-19	ASHR	ETF	49.1	49.38	49.0	49.32	1679500.0
2015-05-19	ASHS	ETF	59.09	60.48	59.09	60.4	41500.0
2015-05-19	ATMP	ETF	30.77	30.77	30.53	30.58	22100.0
2015-05-19	AWAY	ETF	28.46	28.98	28.1	28.21	1082648.0
2015-05-19	BAB	ETF	28.93	29.0	28.73	28.93	105335.0
2015-05-19	BAL	ETF	43.61	43.68	43.4601	43.54	8718.0
2015-05-19	BALT	ETF	1.45	1.49	1.42	1.43	308011.0
2015-05-19	BAR	ETF	2.857	2.857	2.857	2.857	1540.0
2015-05-19	BBC	ETF	34.42	34.42	33.7401	33.87	15267.0
2015-05-19	BBH	ETF	134.3	134.7	133.57	134.04	84300.0
2015-05-19	BBP	ETF	32.25	32.279	32.0	32.15	5000.0
2015-05-19	BCHP	ETF	20.72	20.7299	20.59	20.68	8610.0

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

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