PREVIEW / etf_daily / 2015-02-13

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-13.parquet
  size:    47 KB
  rows:    1,156

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-02-13	SPY	ETF	209.07	209.84	208.76	209.78	93670400.0
2015-02-13	QQQ	ETF	106.3	106.93	106.101	106.91	29030249.0
2015-02-13	IWM	ETF	120.91	121.69	120.65	121.53	20446900.0
2015-02-13	DIA	ETF	180.0	180.54	179.76	180.34	3998200.0
2015-02-13	GLD	ETF	118.05	118.58	117.79	117.98	4108900.0
2015-02-13	TLT	ETF	129.51	129.53	128.09	128.19	8325200.0
2015-02-13	AADR	ETF	38.29	38.29	37.93	37.93	1000.0
2015-02-13	AAXJ	ETF	63.45	63.69	63.17	63.66	1400900.0
2015-02-13	ACWI	ETF	60.19	60.45	60.19	60.44	629300.0
2015-02-13	ACWV	ETF	71.32	71.49	70.41	71.3	71700.0
2015-02-13	ACWX	ETF	44.57	44.69	44.525	44.67	456515.0
2015-02-13	ADRE	ETF	36.64	36.8999	36.64	36.885	15110.0
2015-02-13	AFK	ETF	25.3	25.44	25.19	25.37	43791.0
2015-02-13	AGG	ETF	110.95	110.97	110.71	110.76	1706200.0
2015-02-13	AGQ	ETF	45.21	46.19	45.04	45.47	293800.0
2015-02-13	AGZ	ETF	114.03	114.62	113.8101	114.28	34995.0
2015-02-13	AGZD	ETF	24.555	24.565	24.52	24.555	11400.0
2015-02-13	AIA	ETF	49.01	49.1866	48.948	49.06	38731.0
2015-02-13	AIQ	ETF	25.11	25.17	24.74	24.99	15467.0
2015-02-13	AIRR	ETF	18.1	18.2	17.97	18.17	50500.0
2015-02-13	AIVI	ETF	44.79	45.01	44.79	45.0	32500.0
2015-02-13	ALTL	ETF	37.89	37.89	37.81	37.82	1037.0
2015-02-13	AMJ	ETF	45.61	46.2496	45.61	45.77	675125.0
2015-02-13	AMLP	ETF	85.45	86.1	85.2	85.45	883760.0
2015-02-13	AMZA	ETF	223.0	223.2	221.5	222.0	810.0
2015-02-13	ANGL	ETF	27.48	27.48	26.93	27.22	5300.0
2015-02-13	AOA	ETF	47.35	47.5	47.23	47.36	32300.0
2015-02-13	AOK	ETF	32.68	32.7499	32.68	32.72	33856.0
2015-02-13	AOM	ETF	35.46	35.5399	35.36	35.36	51905.0
2015-02-13	AOR	ETF	40.55	40.72	40.38	40.71	83319.0
2015-02-13	ARGT	ETF	19.88	19.96	19.79	19.94	8700.0
2015-02-13	ARKG	ETF	22.89	22.89	22.69	22.8	1000.0
2015-02-13	ARKK	ETF	21.27	21.46	21.27	21.45	1900.0
2015-02-13	ARKQ	ETF	20.079	20.11	20.06	20.11	11900.0
2015-02-13	ARKW	ETF	21.9	21.9	21.823	21.832	1500.0
2015-02-13	ASEA	ETF	15.93	15.93	15.87	15.87	4000.0
2015-02-13	ASHR	ETF	35.54	35.78	35.54	35.67	487300.0
2015-02-13	ASHS	ETF	37.65	37.84	37.65	37.81	700.0
2015-02-13	ATMP	ETF	30.43	30.84	30.43	30.48	18200.0
2015-02-13	AVIV	ETF	36.53	36.53	36.01	36.45	174804.0
2015-02-13	AWAY	ETF	29.55	29.82	29.2	29.68	1972354.0
2015-02-13	BAB	ETF	30.58	30.5897	30.43	30.43	220742.0
2015-02-13	BAL	ETF	43.01	43.14	42.81	43.1204	16919.0
2015-02-13	BALT	ETF	1.66	1.77	1.66	1.74	580227.0
2015-02-13	BAR	ETF	3.002	3.002	2.988	2.993	17360.0
2015-02-13	BBC	ETF	28.85	28.982	28.6191	28.982	4900.0
2015-02-13	BBH	ETF	121.86	122.5	120.52	122.45	83100.0
2015-02-13	BBP	ETF	28.97	28.97	28.11	28.36	2600.0
2015-02-13	BCM	ETF	32.35	32.36	32.28	32.35	16410.0
2015-02-13	BFOR	ETF	8.06	8.1	8.06	8.095	163200.0

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

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