PREVIEW / etf_daily / 2014-10-27

all etf daily files

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

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-27	SPY	ETF	195.73	196.45	195.03	196.16	82954000.0
2014-10-27	QQQ	ETF	98.4	98.87	98.02	98.69	29545673.0
2014-10-27	IWM	ETF	110.42	111.09	109.51	111.01	31133700.0
2014-10-27	DIA	ETF	167.23	168.06	166.97	167.88	5062900.0
2014-10-27	GLD	ETF	118.18	118.37	118.01	118.06	2443600.0
2014-10-27	TLT	ETF	119.89	120.27	119.66	119.94	3391900.0
2014-10-27	AADR	ETF	36.25	36.25	36.25	36.25	400.0
2014-10-27	AAXJ	ETF	60.93	61.16	60.85	61.13	548300.0
2014-10-27	ACWI	ETF	57.71	57.99	57.55	57.92	1492600.0
2014-10-27	ACWV	ETF	67.27	67.68	67.14	67.62	28400.0
2014-10-27	ACWX	ETF	43.81	44.07	43.69	44.02	223862.0
2014-10-27	ADRE	ETF	37.87	37.8936	37.42	37.8936	12683.0
2014-10-27	AFK	ETF	29.62	29.62	29.19	29.23	38146.0
2014-10-27	AGG	ETF	110.28	110.33	110.19	110.31	1073100.0
2014-10-27	AGQ	ETF	46.49	46.86	46.31	46.32	80600.0
2014-10-27	AGZ	ETF	113.28	113.43	112.92	113.3	11911.0
2014-10-27	AGZD	ETF	24.74	24.74	24.715	24.735	7800.0
2014-10-27	AIA	ETF	46.44	46.44	46.276	46.429	9024.0
2014-10-27	AIQ	ETF	22.29	23.53	21.5	23.19	40343.0
2014-10-27	AIRR	ETF	18.26	18.26	18.0	18.15	28500.0
2014-10-27	AIVI	ETF	44.78	45.01	44.63	44.88	17100.0
2014-10-27	ALTL	ETF	35.06	35.06	35.06	35.06	628.0
2014-10-27	AMJ	ETF	51.1	51.115	49.82	50.75	2474034.0
2014-10-27	AMLP	ETF	93.35	93.8	92.6	93.55	942980.0
2014-10-27	AMZA	ETF	246.7	246.7	241.3	245.3	1420.0
2014-10-27	ANGL	ETF	27.98	28.88	27.55	27.55	2800.0
2014-10-27	AOA	ETF	45.28	45.28	45.0	45.27	41700.0
2014-10-27	AOK	ETF	32.34	32.449	32.34	32.44	35636.0
2014-10-27	AOM	ETF	34.85	34.85	34.695	34.81	53380.0
2014-10-27	AOR	ETF	39.24	39.34	39.19	39.3	27802.0
2014-10-27	ARGT	ETF	19.84	19.84	19.37	19.75	13100.0
2014-10-27	ARKQ	ETF	19.39	19.39	19.27	19.39	7400.0
2014-10-27	ARKW	ETF	19.74	19.74	19.65	19.66	7200.0
2014-10-27	ASEA	ETF	16.51	16.51	16.41	16.45	5100.0
2014-10-27	ASHR	ETF	25.01	25.05	24.77	24.88	429200.0
2014-10-27	ASHS	ETF	32.99	32.99	32.78	32.85	12100.0
2014-10-27	ATMP	ETF	31.26	31.41	30.87	31.24	26600.0
2014-10-27	AVIV	ETF	29.06	29.56	28.98	29.56	111545.0
2014-10-27	AWAY	ETF	33.94	34.42	33.7	34.24	874350.0
2014-10-27	BAB	ETF	29.88	29.98	29.8501	29.93	77934.0
2014-10-27	BAL	ETF	42.72	42.97	42.41	42.477	3613.0
2014-10-27	BALT	ETF	3.91	3.91	3.56	3.58	1014519.0
2014-10-27	BAR	ETF	3.036	3.221	3.036	3.132	609210.0
2014-10-27	BBH	ETF	111.69	113.01	110.87	112.93	93700.0
2014-10-27	BCHP	ETF	18.11	18.11	18.03	18.03	5607.0
2014-10-27	BFOR	ETF	7.525	7.55	7.4225	7.55	128800.0
2014-10-27	BIB	ETF	57.7	58.215	56.145	58.215	514726.0
2014-10-27	BICK	ETF	24.012	24.2315	24.012	24.09	4301.0
2014-10-27	BIL	ETF	91.48	91.5	91.48	91.48	1660850.0
2014-10-27	BIS	ETF	422.4	434.0	418.592	418.8	9540.5

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

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