PREVIEW / etf_daily / 2014-12-08

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-08.parquet
  size:    46 KB
  rows:    1,148

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-08	SPY	ETF	207.52	208.12	205.93	206.61	108588200.0
2014-12-08	QQQ	ETF	105.11	105.57	104.075	104.63	32685756.0
2014-12-08	IWM	ETF	117.27	118.37	115.85	116.22	32295000.0
2014-12-08	DIA	ETF	178.96	179.54	177.97	178.54	5568000.0
2014-12-08	GLD	ETF	114.97	116.16	114.46	115.78	5224500.0
2014-12-08	TLT	ETF	121.42	122.84	121.14	122.57	6021800.0
2014-12-08	AADR	ETF	38.05	38.05	38.05	38.05	200.0
2014-12-08	AAXJ	ETF	62.35	62.44	62.07	62.15	828200.0
2014-12-08	ACWI	ETF	60.22	60.22	59.7	59.83	1268800.0
2014-12-08	ACWV	ETF	69.75	69.84	69.41	69.61	380500.0
2014-12-08	ACWX	ETF	44.76	44.89	44.5107	44.59	575609.0
2014-12-08	ADRE	ETF	37.22	37.46	36.65	36.74	17313.0
2014-12-08	AFK	ETF	27.3	27.33	26.841	26.91	53101.0
2014-12-08	AGG	ETF	109.81	110.0	109.56	109.89	984100.0
2014-12-08	AGQ	ETF	41.22	41.94	40.81	41.72	81700.0
2014-12-08	AGZ	ETF	112.9	112.9	112.458	112.728	16521.0
2014-12-08	AGZD	ETF	24.77	24.86	24.74	24.86	5400.0
2014-12-08	AIA	ETF	48.07	48.07	47.67	47.77	23319.0
2014-12-08	AIQ	ETF	21.61	21.66	21.0	21.5	31401.0
2014-12-08	AIRR	ETF	18.27	18.39	17.93	17.93	23300.0
2014-12-08	AIVI	ETF	45.37	45.41	45.11	45.18	49800.0
2014-12-08	AMJ	ETF	47.57	47.7	45.0	45.39	2457772.0
2014-12-08	AMLP	ETF	89.0	89.4	86.15	86.55	1591540.0
2014-12-08	AMZA	ETF	237.5	237.5	223.0	223.1	660.0
2014-12-08	ANGL	ETF	27.04	27.05	26.83	26.85	7900.0
2014-12-08	AOA	ETF	46.91	46.99	46.6	46.7	83700.0
2014-12-08	AOK	ETF	32.82	32.82	32.71	32.7201	19880.0
2014-12-08	AOM	ETF	35.48	35.48	35.33	35.34	110140.0
2014-12-08	AOR	ETF	40.4	40.51	40.26	40.31	177035.0
2014-12-08	ARGT	ETF	20.41	20.41	20.08	20.1	18800.0
2014-12-08	ARKG	ETF	20.67	20.69	20.5	20.5	1200.0
2014-12-08	ARKK	ETF	20.09	20.09	19.68	19.73	900.0
2014-12-08	ARKQ	ETF	20.05	20.05	20.05	20.05	300.0
2014-12-08	ARKW	ETF	20.319	20.319	20.06	20.06	600.0
2014-12-08	ASEA	ETF	16.15	16.15	16.0	16.02	12000.0
2014-12-08	ASHR	ETF	36.14	36.32	35.12	35.15	1724100.0
2014-12-08	ASHS	ETF	36.7	36.7	36.12	36.25	27800.0
2014-12-08	ATMP	ETF	30.76	30.78	29.51	29.66	47600.0
2014-12-08	AVIV	ETF	33.86	34.53	33.86	33.93	137648.0
2014-12-08	AWAY	ETF	32.03	32.19	31.19	31.31	876064.0
2014-12-08	BAB	ETF	29.93	30.08	29.896	30.03	107286.0
2014-12-08	BAL	ETF	40.9001	40.935	40.4901	40.4946	6039.0
2014-12-08	BALT	ETF	2.85	2.865	2.45	2.5	915757.0
2014-12-08	BBH	ETF	120.36	122.74	120.21	121.35	188000.0
2014-12-08	BCHP	ETF	18.6099	18.6099	18.4	18.43	2267.0
2014-12-08	BCM	ETF	33.73	33.756	33.6254	33.66	7618.0
2014-12-08	BFOR	ETF	7.9225	7.95	7.82	7.8275	37200.0
2014-12-08	BIB	ETF	65.51	68.84	65.51	67.615	598986.0
2014-12-08	BICK	ETF	24.4427	24.4427	24.4427	24.4427	308.0
2014-12-08	BIL	ETF	91.5	91.5	91.48	91.5	511500.0

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

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