PREVIEW / etf_daily / 2015-02-06

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-06.parquet
  size:    48 KB
  rows:    1,172

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-06	SPY	ETF	206.56	207.24	204.92	205.55	125672000.0
2015-02-06	QQQ	ETF	103.92	104.17	102.76	103.13	34169256.0
2015-02-06	IWM	ETF	120.1	120.82	119.35	119.81	31694900.0
2015-02-06	DIA	ETF	178.82	179.36	177.48	178.09	7211900.0
2015-02-06	GLD	ETF	119.15	119.52	117.95	118.64	13206900.0
2015-02-06	TLT	ETF	132.05	132.35	130.59	130.96	13685600.0
2015-02-06	AADR	ETF	37.47	37.47	37.24	37.24	1400.0
2015-02-06	AAXJ	ETF	63.17	63.17	62.64	62.8	1288200.0
2015-02-06	ACWI	ETF	59.43	59.64	59.03	59.18	751500.0
2015-02-06	ACWV	ETF	71.37	71.37	70.54	70.62	182500.0
2015-02-06	ACWX	ETF	43.88	44.05	43.65	43.74	440669.0
2015-02-06	ADRE	ETF	36.18	36.18	35.8334	35.8334	14993.0
2015-02-06	AFK	ETF	26.27	26.28	25.97	26.06	51161.0
2015-02-06	AGG	ETF	111.41	111.41	111.03	111.06	2531300.0
2015-02-06	AGQ	ETF	43.44	43.79	41.63	42.7	442800.0
2015-02-06	AGZ	ETF	114.18	114.5	114.17	114.5	27751.0
2015-02-06	AGZD	ETF	24.47	24.565	24.47	24.555	19800.0
2015-02-06	AIA	ETF	48.71	48.7951	48.47	48.48	27794.0
2015-02-06	AIQ	ETF	23.44	23.99	23.31	23.63	19183.0
2015-02-06	AIRR	ETF	17.7	17.96	17.7	17.79	29600.0
2015-02-06	AIVI	ETF	44.28	44.41	43.99	44.13	15100.0
2015-02-06	AMJ	ETF	46.32	46.5	45.72	46.17	1908707.0
2015-02-06	AMLP	ETF	88.0	88.0	86.8	87.3	870480.0
2015-02-06	AMZA	ETF	222.1	222.1	220.8	221.8	440.0
2015-02-06	ANGL	ETF	27.15	27.16	26.98	27.04	14000.0
2015-02-06	AOA	ETF	46.93	46.93	46.57	46.65	36700.0
2015-02-06	AOK	ETF	32.76	32.76	32.53	32.53	52405.0
2015-02-06	AOM	ETF	35.54	35.54	35.12	35.13	28079.0
2015-02-06	AOR	ETF	40.73	40.73	40.17	40.19	93335.0
2015-02-06	ARGT	ETF	19.03	19.2	19.01	19.01	7300.0
2015-02-06	ARKG	ETF	22.74	22.74	22.475	22.475	5500.0
2015-02-06	ARKK	ETF	20.948	20.948	20.792	20.792	6000.0
2015-02-06	ARKQ	ETF	19.38	19.42	19.322	19.322	2900.0
2015-02-06	ARKW	ETF	21.45	21.47	21.45	21.47	1100.0
2015-02-06	ASEA	ETF	15.85	15.85	15.79	15.82	3300.0
2015-02-06	ASHR	ETF	33.89	33.9	33.6	33.67	1114900.0
2015-02-06	ASHS	ETF	35.98	35.98	35.8	35.86	14100.0
2015-02-06	ATMP	ETF	31.0	31.0	29.68	30.47	49000.0
2015-02-06	AVIV	ETF	38.74	38.74	36.47	36.81	571855.0
2015-02-06	AWAY	ETF	26.73	27.36	26.63	27.18	2343675.0
2015-02-06	BAB	ETF	30.85	30.85	30.5001	30.6	992813.0
2015-02-06	BAL	ETF	41.55	42.15	41.51	42.14	5085.0
2015-02-06	BALT	ETF	1.83	1.83	1.75	1.79	908826.0
2015-02-06	BAR	ETF	3.112	3.127	3.0001	3.07	60580.0
2015-02-06	BBC	ETF	28.91	28.91	27.5301	27.6509	5174.0
2015-02-06	BBH	ETF	121.89	122.59	119.34	119.75	222100.0
2015-02-06	BBP	ETF	28.78	28.78	27.72	27.72	3500.0
2015-02-06	BCM	ETF	31.766	31.899	31.7001	31.84	3658.0
2015-02-06	BFOR	ETF	7.95	8.0	7.9325	7.95	95200.0
2015-02-06	BIB	ETF	69.085	70.4513	67.0	67.445	549934.0

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

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