PREVIEW / etf_daily / 2015-02-05

all etf daily files

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

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-05	SPY	ETF	204.86	206.3	204.77	206.12	97953200.0
2015-02-05	QQQ	ETF	103.13	103.83	102.87	103.76	23605516.0
2015-02-05	IWM	ETF	118.77	120.25	118.6	119.94	32337100.0
2015-02-05	DIA	ETF	177.28	178.64	177.09	178.55	6037800.0
2015-02-05	GLD	ETF	120.98	121.83	120.61	121.79	6879900.0
2015-02-05	TLT	ETF	134.0	134.23	133.11	133.32	8334600.0
2015-02-05	AADR	ETF	37.51	37.67	37.49	37.58	3500.0
2015-02-05	AAXJ	ETF	63.27	63.63	63.18	63.59	745800.0
2015-02-05	ACWI	ETF	59.33	59.7	59.27	59.68	1474700.0
2015-02-05	ACWV	ETF	71.2	71.5	71.02	71.47	68900.0
2015-02-05	ACWX	ETF	44.05	44.34	43.98	44.325	240974.0
2015-02-05	ADRE	ETF	36.39	36.54	36.36	36.524	23476.0
2015-02-05	AFK	ETF	26.37	26.6	26.3625	26.57	70346.0
2015-02-05	AGG	ETF	111.79	111.85	111.57	111.71	2409600.0
2015-02-05	AGQ	ETF	44.72	45.73	43.99	45.73	176100.0
2015-02-05	AGZ	ETF	114.7799	114.7799	114.46	114.52	23885.0
2015-02-05	AGZD	ETF	24.38	24.5	24.36	24.425	19800.0
2015-02-05	AIA	ETF	49.08	49.23	49.0	49.23	19752.0
2015-02-05	AIQ	ETF	23.66	23.66	23.29	23.57	18320.0
2015-02-05	AIRR	ETF	17.508	17.74	17.508	17.72	30700.0
2015-02-05	AIVI	ETF	44.43	44.8	44.41	44.8	12500.0
2015-02-05	AMJ	ETF	45.52	46.36	45.36	46.3	611461.0
2015-02-05	AMLP	ETF	87.15	87.75	86.5	87.5	1091940.0
2015-02-05	AMZA	ETF	222.0	223.7	221.0	223.3	310.0
2015-02-05	ANGL	ETF	27.01	27.1	26.54	27.0	14200.0
2015-02-05	AOA	ETF	46.85	47.0	46.51	47.0	27700.0
2015-02-05	AOK	ETF	32.7	32.8599	32.67	32.82	39844.0
2015-02-05	AOM	ETF	35.37	35.45	35.31	35.45	78325.0
2015-02-05	AOR	ETF	40.5	40.54	40.366	40.51	83518.0
2015-02-05	ARGT	ETF	19.17	19.3	19.09	19.19	41500.0
2015-02-05	ARKG	ETF	22.37	22.54	22.27	22.54	900.0
2015-02-05	ARKK	ETF	20.649	20.84	20.649	20.84	1000.0
2015-02-05	ARKQ	ETF	19.32	19.326	19.313	19.326	1700.0
2015-02-05	ARKW	ETF	21.24	21.33	21.24	21.33	1400.0
2015-02-05	ASEA	ETF	15.85	15.89	15.85	15.89	900.0
2015-02-05	ASHR	ETF	34.88	34.93	34.6	34.91	865800.0
2015-02-05	ASHS	ETF	37.08	37.12	37.02	37.09	3600.0
2015-02-05	ATMP	ETF	30.29	30.64	30.14	30.52	24400.0
2015-02-05	AVIV	ETF	38.5	38.84	38.13	38.84	513678.0
2015-02-05	AWAY	ETF	25.93	26.76	25.93	26.73	1001038.0
2015-02-05	BAB	ETF	30.99	30.99	30.8539	30.8601	137063.0
2015-02-05	BAL	ETF	41.8691	42.4257	41.77	42.21	10273.0
2015-02-05	BALT	ETF	1.7	1.84	1.68	1.82	1138553.0
2015-02-05	BAR	ETF	3.264	3.296	3.2001	3.24	23480.0
2015-02-05	BBC	ETF	27.3	28.2074	27.3	28.2074	3744.0
2015-02-05	BBH	ETF	119.61	121.75	119.6	121.57	182000.0
2015-02-05	BBP	ETF	27.54	28.118	27.54	28.076	1300.0
2015-02-05	BCHP	ETF	18.75	18.75	18.75	18.75	2000.0
2015-02-05	BCM	ETF	31.83	31.892	31.779	31.82	2952.0
2015-02-05	BFOR	ETF	7.875	7.95	7.875	7.9425	78400.0

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

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