PREVIEW / etf_daily / 2014-12-29

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-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
2014-12-29	SPY	ETF	208.22	208.97	208.14	208.72	79643900.0
2014-12-29	QQQ	ETF	104.94	105.25	104.875	105.02	17073772.0
2014-12-29	IWM	ETF	120.63	121.38	120.61	121.05	27692500.0
2014-12-29	DIA	ETF	179.88	180.38	179.81	180.11	2530900.0
2014-12-29	GLD	ETF	114.61	114.64	113.23	113.67	12963700.0
2014-12-29	TLT	ETF	124.91	125.66	124.81	125.34	4070700.0
2014-12-29	AADR	ETF	37.36	37.36	37.36	37.36	200.0
2014-12-29	AAXJ	ETF	61.03	61.15	60.91	60.95	366500.0
2014-12-29	ACWI	ETF	59.41	59.56	59.29	59.42	1271200.0
2014-12-29	ACWV	ETF	69.32	69.57	69.32	69.46	49400.0
2014-12-29	ACWX	ETF	43.61	43.68	43.51	43.54	981587.0
2014-12-29	ADRE	ETF	35.78	35.94	35.75	35.75	22849.0
2014-12-29	AFK	ETF	25.99	26.47	25.955	26.19	53346.0
2014-12-29	AGG	ETF	109.94	110.05	109.83	109.97	2199200.0
2014-12-29	AGQ	ETF	39.83	39.89	38.12	38.45	294000.0
2014-12-29	AGZ	ETF	113.07	113.49	112.88	113.1	34709.0
2014-12-29	AGZD	ETF	24.595	24.67	24.595	24.67	4400.0
2014-12-29	AIA	ETF	47.35	47.45	47.149	47.31	44119.0
2014-12-29	AIQ	ETF	21.33	21.7	21.26	21.69	12169.0
2014-12-29	AIRR	ETF	18.45	18.68	18.45	18.55	31600.0
2014-12-29	AIVI	ETF	43.78	43.98	43.67	43.81	33300.0
2014-12-29	ALTL	ETF	38.2041	38.2041	38.19	38.19	457.0
2014-12-29	AMJ	ETF	45.85	46.5599	45.73	46.37	1119166.0
2014-12-29	AMLP	ETF	87.5	88.45	87.35	88.15	614860.0
2014-12-29	AMZA	ETF	228.31	230.98	228.31	230.4	290.0
2014-12-29	ANGL	ETF	26.19	26.36	26.19	26.23	2000.0
2014-12-29	AOA	ETF	46.8	46.9	46.76	46.77	32600.0
2014-12-29	AOK	ETF	32.79	32.8	32.7201	32.76	60023.0
2014-12-29	AOM	ETF	35.38	35.3899	35.31	35.37	101030.0
2014-12-29	AOR	ETF	40.46	40.49	40.3813	40.44	45564.0
2014-12-29	ARGT	ETF	18.94	18.95	18.89	18.95	12500.0
2014-12-29	ARKG	ETF	21.64	21.64	21.37	21.47	3900.0
2014-12-29	ARKK	ETF	20.469	20.469	20.42	20.427	1500.0
2014-12-29	ARKQ	ETF	20.47	20.47	19.98	19.98	1800.0
2014-12-29	ARKW	ETF	20.81	20.83	20.81	20.82	700.0
2014-12-29	ASEA	ETF	15.88	15.91	15.79	15.85	12600.0
2014-12-29	ASHR	ETF	36.07	36.16	35.92	35.95	553200.0
2014-12-29	ASHS	ETF	35.43	35.43	35.24	35.29	19100.0
2014-12-29	ATMP	ETF	30.76	31.13	30.62	31.13	66500.0
2014-12-29	AVIV	ETF	34.98	35.54	34.98	35.42	103828.0
2014-12-29	AWAY	ETF	29.03	29.46	28.77	28.96	639779.0
2014-12-29	BAB	ETF	30.22	30.41	30.22	30.36	119290.0
2014-12-29	BAL	ETF	42.22	42.42	42.1401	42.42	5463.0
2014-12-29	BALT	ETF	2.44	2.515	2.43	2.44	355875.0
2014-12-29	BAR	ETF	2.774	2.774	2.735	2.735	5120.0
2014-12-29	BBC	ETF	27.97	27.97	27.3	27.4599	13290.0
2014-12-29	BBH	ETF	116.85	117.7	115.97	117.46	182600.0
2014-12-29	BBP	ETF	26.37	26.55	26.2	26.321	8400.0
2014-12-29	BCHP	ETF	18.11	18.23	18.11	18.17	3944.0
2014-12-29	BCM	ETF	32.46	32.46	31.98	32.19	144179.0

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

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