PREVIEW / etf_daily / 2015-01-29

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-29.parquet
  size:    47 KB
  rows:    1,159

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-01-29	SPY	ETF	200.38	202.3	198.68	201.99	173585400.0
2015-01-29	QQQ	ETF	100.84	102.0779	99.96	101.89	46539734.0
2015-01-29	IWM	ETF	117.02	118.32	116.09	118.3	39299900.0
2015-01-29	DIA	ETF	172.16	174.07	171.06	173.9	9615200.0
2015-01-29	GLD	ETF	121.99	122.29	120.26	120.76	11998000.0
2015-01-29	TLT	ETF	136.12	136.67	135.46	135.87	8881400.0
2015-01-29	AADR	ETF	36.59	36.59	36.59	36.59	100.0
2015-01-29	AAXJ	ETF	63.21	63.26	62.69	63.23	961300.0
2015-01-29	ACWI	ETF	58.13	58.59	57.81	58.52	2817800.0
2015-01-29	ACWV	ETF	70.61	70.88	70.13	70.83	1481500.0
2015-01-29	ACWX	ETF	43.36	43.59	43.1898	43.55	583487.0
2015-01-29	ADRE	ETF	36.42	36.42	35.829	36.01	2805.0
2015-01-29	AFK	ETF	25.19	25.32	24.75	24.89	230206.0
2015-01-29	AGG	ETF	111.93	112.06	111.82	111.98	1752600.0
2015-01-29	AGQ	ETF	46.6	46.69	42.76	43.86	658000.0
2015-01-29	AGZ	ETF	114.26	114.86	114.252	114.68	11798.0
2015-01-29	AGZD	ETF	24.43	24.54	24.41	24.435	16200.0
2015-01-29	AIA	ETF	48.84	48.89	48.43	48.89	18067.0
2015-01-29	AIQ	ETF	23.45	23.89	22.59	23.84	9718.0
2015-01-29	AIRR	ETF	16.86	17.09	16.73	17.06	76400.0
2015-01-29	AIVI	ETF	43.81	44.02	43.63	43.96	42800.0
2015-01-29	AMJ	ETF	44.05	44.34	43.09	44.24	1828129.0
2015-01-29	AMLP	ETF	85.45	85.45	83.75	85.0	1022180.0
2015-01-29	AMZA	ETF	210.0	210.1	209.6	209.6	120.0
2015-01-29	ANGL	ETF	26.73	26.89	26.54	26.54	4800.0
2015-01-29	AOA	ETF	46.39	46.58	46.08	46.55	38500.0
2015-01-29	AOK	ETF	32.79	32.8299	32.6717	32.81	35947.0
2015-01-29	AOM	ETF	35.31	35.38	35.17	35.36	71032.0
2015-01-29	AOR	ETF	40.19	40.31	39.96	40.31	114174.0
2015-01-29	ARGT	ETF	18.2	18.24	18.13	18.21	27500.0
2015-01-29	ARKG	ETF	22.18	22.56	22.18	22.53	1800.0
2015-01-29	ARKK	ETF	20.334	20.39	20.08	20.39	900.0
2015-01-29	ARKQ	ETF	18.96	19.09	18.96	19.09	1500.0
2015-01-29	ARKW	ETF	20.0	20.55	20.0	20.55	3300.0
2015-01-29	ASEA	ETF	15.7	15.71	15.57	15.7	3900.0
2015-01-29	ASHR	ETF	35.68	35.79	35.31	35.74	1262200.0
2015-01-29	ASHS	ETF	37.24	37.31	37.14	37.31	4300.0
2015-01-29	ATMP	ETF	28.77	29.21	28.59	29.17	420500.0
2015-01-29	AVIV	ETF	40.03	40.15	39.52	40.11	153499.0
2015-01-29	AWAY	ETF	26.7	26.82	25.88	25.9	1442182.0
2015-01-29	BAB	ETF	31.1	31.19	31.03	31.072	133578.0
2015-01-29	BAL	ETF	40.689	40.78	40.4426	40.5	2123.0
2015-01-29	BALT	ETF	1.49	1.56	1.45	1.51	837404.0
2015-01-29	BAR	ETF	3.356	3.356	3.144	3.201	101610.0
2015-01-29	BBC	ETF	29.02	29.1701	28.5	29.1701	3857.0
2015-01-29	BBH	ETF	121.73	123.47	120.49	123.37	203100.0
2015-01-29	BBP	ETF	28.076	28.12	27.67	28.108	2100.0
2015-01-29	BCHP	ETF	17.99	18.0301	17.99	18.0301	618.0
2015-01-29	BCM	ETF	30.1	30.166	30.1	30.14	7626.0
2015-01-29	BFOR	ETF	7.7025	7.7675	7.665	7.7675	36400.0

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

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