PREVIEW / etf_daily / 2014-06-30

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-30.parquet
  size:    44 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-30	SPY	ETF	195.7	196.17	195.53	195.72	70201200.0
2014-06-30	QQQ	ETF	93.71	94.14	93.67	93.91	19764915.0
2014-06-30	IWM	ETF	118.16	118.88	117.83	118.81	34195600.0
2014-06-30	DIA	ETF	167.91	168.35	167.65	167.89	6488400.0
2014-06-30	GLD	ETF	126.53	128.04	126.37	128.04	18123400.0
2014-06-30	TLT	ETF	113.56	113.8	113.09	113.52	5593100.0
2014-06-30	AADR	ETF	38.53	38.96	38.53	38.92	47200.0
2014-06-30	AAXJ	ETF	62.95	62.99	62.64	62.69	158500.0
2014-06-30	ACWI	ETF	60.11	60.32	60.11	60.26	1314100.0
2014-06-30	ACWV	ETF	66.91	66.91	66.62	66.8	28700.0
2014-06-30	ACWX	ETF	48.0	48.09	47.92	48.02	181627.0
2014-06-30	ADRE	ETF	39.07	39.1199	39.0263	39.1199	6719.0
2014-06-30	AFK	ETF	32.63	32.99	32.63	32.97	17377.0
2014-06-30	AGG	ETF	109.47	109.5	109.36	109.4	1046900.0
2014-06-30	AGQ	ETF	69.66	71.76	69.35	71.76	332700.0
2014-06-30	AGZ	ETF	112.65	112.93	112.58	112.67	20643.0
2014-06-30	AGZD	ETF	24.965	25.02	24.96	25.02	27800.0
2014-06-30	AIA	ETF	48.25	48.4099	48.24	48.25	8817.0
2014-06-30	AIQ	ETF	26.63	27.5	26.63	27.0	161757.0
2014-06-30	AIRR	ETF	19.28	19.42	19.28	19.41	20900.0
2014-06-30	AIVI	ETF	50.63	50.73	50.48	50.67	35800.0
2014-06-30	AMJ	ETF	52.12	52.39	51.9501	52.38	473703.0
2014-06-30	AMLP	ETF	94.65	95.0	94.35	95.0	709080.0
2014-06-30	ANGL	ETF	28.3	28.41	28.2	28.22	2800.0
2014-06-30	AOA	ETF	47.15	47.19	47.09	47.19	13800.0
2014-06-30	AOK	ETF	33.08	33.09	33.016	33.08	40179.0
2014-06-30	AOM	ETF	35.73	35.75	35.68	35.72	13549.0
2014-06-30	AOR	ETF	40.45	40.475	40.3904	40.47	23598.0
2014-06-30	ARGT	ETF	21.94	22.17	21.89	22.17	9000.0
2014-06-30	ASEA	ETF	16.85	16.85	16.74	16.75	7100.0
2014-06-30	ASHR	ETF	22.5	22.52	22.41	22.47	350300.0
2014-06-30	ASHS	ETF	26.24	26.27	26.08	26.18	19900.0
2014-06-30	ATMP	ETF	31.73	31.73	31.41	31.56	49300.0
2014-06-30	AVIV	ETF	28.44	28.44	28.04	28.17	319258.0
2014-06-30	AWAY	ETF	34.51	35.39	34.51	34.82	1191148.0
2014-06-30	BAB	ETF	29.26	29.35	29.23	29.32	72549.0
2014-06-30	BAL	ETF	50.46	50.58	49.58	49.58	7794.0
2014-06-30	BALT	ETF	5.82	5.99	5.75	5.98	1577639.0
2014-06-30	BBH	ETF	95.34	96.0	95.27	95.38	45000.0
2014-06-30	BCHP	ETF	20.67	20.67	20.617	20.617	630.0
2014-06-30	BCM	ETF	41.602	41.66	41.571	41.571	4099.0
2014-06-30	BFOR	ETF	7.82	7.865	7.82	7.8575	50000.0
2014-06-30	BIB	ETF	46.48	46.88	46.055	46.405	302440.0
2014-06-30	BICK	ETF	26.63	26.6399	26.5808	26.59	1481.0
2014-06-30	BIL	ETF	91.52	91.54	91.52	91.52	89300.0
2014-06-30	BIS	ETF	567.6	574.0	562.8	569.6	2882.0
2014-06-30	BIV	ETF	84.74	84.78	84.61	84.69	129400.0
2014-06-30	BIZD	ETF	20.9	21.07	20.85	21.07	28600.0
2014-06-30	BJK	ETF	50.18	50.48	48.07	50.45	39400.0
2014-06-30	BKF	ETF	38.68	38.68	38.49	38.5485	18771.0

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

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