PREVIEW / etf_daily / 2014-06-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-24.parquet
  size:    45 KB
  rows:    1,102

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-06-24	SPY	ETF	195.53	196.5	194.48	194.7	96237000.0
2014-06-24	QQQ	ETF	92.79	93.57	92.43	92.7	31945762.0
2014-06-24	IWM	ETF	117.74	118.91	116.65	116.76	41788300.0
2014-06-24	DIA	ETF	168.83	169.33	167.67	167.87	4861700.0
2014-06-24	GLD	ETF	127.22	127.32	126.73	126.98	6350200.0
2014-06-24	TLT	ETF	112.15	112.65	111.82	112.58	9698300.0
2014-06-24	AADR	ETF	38.93	38.93	38.66	38.72	16000.0
2014-06-24	AAXJ	ETF	62.67	62.88	62.3	62.34	443300.0
2014-06-24	ACWI	ETF	61.0	61.23	60.69	60.73	1001500.0
2014-06-24	ACWV	ETF	67.41	67.48	67.06	67.12	55700.0
2014-06-24	ACWX	ETF	48.99	49.06	48.69	48.73	139308.0
2014-06-24	ADRE	ETF	38.91	39.176	38.6801	38.74	5678.0
2014-06-24	AFK	ETF	32.87	33.0	32.52	32.52	65142.0
2014-06-24	AGG	ETF	108.96	109.05	108.88	109.03	740800.0
2014-06-24	AGQ	ETF	71.03	71.47	70.18	70.47	420400.0
2014-06-24	AGZ	ETF	112.36	112.54	112.28	112.377	9230.0
2014-06-24	AGZD	ETF	25.015	25.015	25.015	25.015	400.0
2014-06-24	AIA	ETF	47.78	47.79	47.446	47.54	18392.0
2014-06-24	AIQ	ETF	27.03	30.0	27.03	28.45	26532.0
2014-06-24	AIRR	ETF	19.36	19.42	19.118	19.118	12800.0
2014-06-24	AIVI	ETF	50.87	50.93	50.61	50.66	17900.0
2014-06-24	AMJ	ETF	51.23	51.7993	51.162	51.49	736383.0
2014-06-24	AMLP	ETF	93.5	94.25	93.5	93.85	611480.0
2014-06-24	ANGL	ETF	28.49	28.49	28.35	28.35	1300.0
2014-06-24	AOA	ETF	47.28	47.28	46.87	46.89	21400.0
2014-06-24	AOK	ETF	33.01	33.0597	32.9508	32.97	18280.0
2014-06-24	AOM	ETF	35.6899	35.73	35.56	35.6	66507.0
2014-06-24	AOR	ETF	41.99	41.99	40.22	40.22	19462.0
2014-06-24	ARGT	ETF	22.57	22.59	21.94	22.06	38600.0
2014-06-24	ASEA	ETF	16.63	16.77	16.63	16.66	6200.0
2014-06-24	ASHR	ETF	22.21	22.22	22.06	22.07	235700.0
2014-06-24	ASHS	ETF	25.64	25.64	25.47	25.47	5700.0
2014-06-24	ATMP	ETF	31.02	31.19	31.0	31.0	36400.0
2014-06-24	AVIV	ETF	28.94	29.08	28.81	29.02	212000.0
2014-06-24	AWAY	ETF	33.26	34.49	33.1	34.14	2356559.0
2014-06-24	BAB	ETF	29.07	29.22	29.03	29.16	65519.0
2014-06-24	BAL	ETF	52.3435	52.47	51.7601	51.7601	4481.0
2014-06-24	BALT	ETF	6.53	6.57	6.01	6.07	981971.0
2014-06-24	BBH	ETF	95.25	96.62	94.61	94.95	325000.0
2014-06-24	BCHP	ETF	20.646	20.6799	20.646	20.6799	545.0
2014-06-24	BCM	ETF	42.069	42.069	42.069	42.069	295.0
2014-06-24	BFOR	ETF	7.7975	7.86	7.7475	7.755	73600.0
2014-06-24	BIB	ETF	46.365	47.345	45.4102	45.82	780248.0
2014-06-24	BICK	ETF	26.72	26.72	26.72	26.72	1276.0
2014-06-24	BIL	ETF	91.54	91.54	91.52	91.54	86900.0
2014-06-24	BIS	ETF	568.0	582.4	556.8	577.96	12947.0
2014-06-24	BIV	ETF	84.37	84.45	84.23	84.45	173600.0
2014-06-24	BIZD	ETF	20.36	20.42	20.24	20.32	181700.0
2014-06-24	BJK	ETF	48.59	49.13	48.51	48.79	5400.0
2014-06-24	BKF	ETF	38.97	39.359	38.86	38.89	200512.0

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

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