PREVIEW / etf_daily / 2014-10-23

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-23.parquet
  size:    46 KB
  rows:    1,131

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
2014-10-23	SPY	ETF	194.62	196.2	194.26	194.93	154944000.0
2014-10-23	QQQ	ETF	97.32	98.36	97.17	97.82	48123778.0
2014-10-23	IWM	ETF	110.04	111.58	109.77	110.88	60795100.0
2014-10-23	DIA	ETF	166.05	167.36	166.01	166.45	7029700.0
2014-10-23	GLD	ETF	118.71	118.82	117.88	118.52	6417500.0
2014-10-23	TLT	ETF	120.04	120.18	119.06	119.6	10936300.0
2014-10-23	AAXJ	ETF	61.48	61.72	61.34	61.43	622300.0
2014-10-23	ACWI	ETF	57.7	58.02	57.53	57.75	1512400.0
2014-10-23	ACWV	ETF	67.12	67.35	66.92	67.14	187400.0
2014-10-23	ACWX	ETF	43.88	44.17	43.88	43.99	430537.0
2014-10-23	ADRE	ETF	38.65	38.65	38.03	38.05	8936.0
2014-10-23	AFK	ETF	29.58	29.6518	29.482	29.482	10516.0
2014-10-23	AGG	ETF	110.36	110.36	110.13	110.23	1863100.0
2014-10-23	AGQ	ETF	46.45	47.0	46.22	46.81	136400.0
2014-10-23	AGZ	ETF	113.08	113.39	112.84	112.96	26423.0
2014-10-23	AGZD	ETF	24.795	24.8	24.73	24.8	8200.0
2014-10-23	AIA	ETF	46.72	46.9199	46.7	46.73	13735.0
2014-10-23	AIQ	ETF	22.62	22.965	22.5	22.68	16238.0
2014-10-23	AIRR	ETF	18.09	18.39	17.99	18.2	40500.0
2014-10-23	AIVI	ETF	44.94	45.15	44.86	44.96	29200.0
2014-10-23	AMJ	ETF	50.39	51.27	50.39	50.97	774241.0
2014-10-23	AMLP	ETF	93.3	93.9	93.2	93.45	717220.0
2014-10-23	AMZA	ETF	245.54	253.0	241.5	243.0	3860.0
2014-10-23	ANGL	ETF	27.68	27.68	27.68	27.68	500.0
2014-10-23	AOA	ETF	45.01	45.33	45.01	45.11	75100.0
2014-10-23	AOK	ETF	32.45	32.45	32.356	32.39	13604.0
2014-10-23	AOM	ETF	34.71	34.83	34.706	34.76	66866.0
2014-10-23	AOR	ETF	39.23	39.36	39.1501	39.23	75445.0
2014-10-23	ARGT	ETF	19.66	19.81	19.66	19.76	2600.0
2014-10-23	ARKQ	ETF	19.37	19.54	19.37	19.45	3900.0
2014-10-23	ARKW	ETF	19.56	19.6	19.56	19.6	5200.0
2014-10-23	ASEA	ETF	16.59	16.59	16.56	16.56	3700.0
2014-10-23	ASHR	ETF	25.34	25.36	25.22	25.22	525300.0
2014-10-23	ASHS	ETF	32.99	32.99	32.57	32.65	8200.0
2014-10-23	ATMP	ETF	31.37	31.52	31.21	31.36	45900.0
2014-10-23	AVIV	ETF	29.19	29.24	28.95	29.13	236558.0
2014-10-23	AWAY	ETF	33.1	33.69	32.7701	33.39	928659.0
2014-10-23	BAB	ETF	29.95	29.95	29.813	29.87	61805.0
2014-10-23	BAL	ETF	41.65	42.2921	41.42	42.18	9415.0
2014-10-23	BALT	ETF	3.73	3.88	3.68	3.77	534940.0
2014-10-23	BAR	ETF	3.206	3.206	3.1431	3.186	73530.0
2014-10-23	BBH	ETF	108.14	110.2	107.9	109.72	149600.0
2014-10-23	BCM	ETF	36.088	36.178	36.088	36.178	233.0
2014-10-23	BFOR	ETF	7.49	7.585	7.49	7.5325	62000.0
2014-10-23	BIB	ETF	53.205	56.075	53.185	55.515	811730.0
2014-10-23	BICK	ETF	24.3294	24.3294	24.27	24.27	610.0
2014-10-23	BIL	ETF	91.48	91.5	91.48	91.48	218100.0
2014-10-23	BIS	ETF	455.6	458.008	434.0	440.4	20167.0
2014-10-23	BIV	ETF	85.45	85.48	85.22	85.36	258700.0
2014-10-23	BIZD	ETF	19.09	19.14	18.91	18.91	13300.0

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

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