PREVIEW / etf_daily / 2014-06-27

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-27.parquet
  size:    44 KB
  rows:    1,090

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-27	SPY	ETF	194.98	195.88	194.89	195.82	71445100.0
2014-06-27	QQQ	ETF	93.21	93.765	93.19	93.75	22881506.0
2014-06-27	IWM	ETF	117.06	118.51	117.03	118.34	38525100.0
2014-06-27	DIA	ETF	167.76	168.25	167.34	168.17	3092200.0
2014-06-27	GLD	ETF	126.88	127.17	126.65	126.66	4200300.0
2014-06-27	TLT	ETF	113.68	113.82	113.17	113.24	7216500.0
2014-06-27	AADR	ETF	38.74	38.75	38.64	38.65	19500.0
2014-06-27	AAXJ	ETF	62.35	62.68	62.32	62.64	1554300.0
2014-06-27	ACWI	ETF	59.91	60.22	59.91	60.22	664600.0
2014-06-27	ACWV	ETF	66.52	66.68	66.41	66.65	72500.0
2014-06-27	ACWX	ETF	47.89	48.011	47.8	48.011	99099.0
2014-06-27	ADRE	ETF	38.93	39.11	38.85	39.1	13270.0
2014-06-27	AFK	ETF	32.93	32.93	32.63	32.75	50192.0
2014-06-27	AGG	ETF	109.45	109.5	109.35	109.39	668200.0
2014-06-27	AGQ	ETF	71.25	71.98	70.9	70.96	217900.0
2014-06-27	AGZ	ETF	112.66	113.0384	112.56	112.64	10885.0
2014-06-27	AGZD	ETF	25.005	25.045	24.95	25.0	16600.0
2014-06-27	AIA	ETF	48.22	48.27	48.2	48.27	14191.0
2014-06-27	AIQ	ETF	27.28	27.65	27.1	27.11	98636.0
2014-06-27	AIRR	ETF	19.28	19.33	19.28	19.32	6700.0
2014-06-27	AIVI	ETF	50.54	50.73	50.39	50.73	18200.0
2014-06-27	AMJ	ETF	51.75	52.2	51.75	52.07	500122.0
2014-06-27	AMLP	ETF	94.3	94.75	94.15	94.6	1111420.0
2014-06-27	ANGL	ETF	28.48	28.49	28.19	28.35	11800.0
2014-06-27	AOA	ETF	46.97	47.15	46.97	47.15	22300.0
2014-06-27	AOK	ETF	33.0	33.07	33.0	33.07	9720.0
2014-06-27	AOM	ETF	35.65	35.72	35.63	35.72	26733.0
2014-06-27	AOR	ETF	40.34	40.45	40.3001	40.45	38926.0
2014-06-27	ARGT	ETF	22.13	22.13	21.92	21.99	2900.0
2014-06-27	ASEA	ETF	16.72	16.74	16.7	16.74	4900.0
2014-06-27	ASHR	ETF	22.22	22.31	22.22	22.31	54300.0
2014-06-27	ASHS	ETF	25.95	26.05	25.84	25.94	16000.0
2014-06-27	ATMP	ETF	31.4	31.56	31.37	31.48	20300.0
2014-06-27	AVIV	ETF	28.34	28.72	28.25	28.38	837594.0
2014-06-27	AWAY	ETF	34.73	35.29	34.1	34.46	3446532.0
2014-06-27	BAB	ETF	29.31	29.34	29.21	29.21	40432.0
2014-06-27	BAL	ETF	50.56	50.6099	50.47	50.47	2069.0
2014-06-27	BALT	ETF	6.08	6.14	5.81	5.81	5473729.0
2014-06-27	BBH	ETF	95.21	95.44	94.47	95.4	37300.0
2014-06-27	BCHP	ETF	20.5699	20.5699	20.5699	20.5699	350.0
2014-06-27	BCM	ETF	41.941	41.956	41.941	41.956	1073.0
2014-06-27	BFOR	ETF	7.78	7.835	7.78	7.825	26000.0
2014-06-27	BIB	ETF	46.015	46.3755	45.46	46.3	288536.0
2014-06-27	BICK	ETF	26.5101	26.5101	26.42	26.42	324.0
2014-06-27	BIL	ETF	91.54	91.54	91.52	91.54	210550.0
2014-06-27	BIS	ETF	573.2	580.8	570.4	570.4	3419.0
2014-06-27	BIV	ETF	84.78	84.83	84.67	84.72	172000.0
2014-06-27	BIZD	ETF	20.64	20.85	20.64	20.74	78100.0
2014-06-27	BJK	ETF	50.18	50.19	49.83	50.1	38900.0
2014-06-27	BKF	ETF	38.48	38.6632	38.42	38.65	31814.0

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

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