PREVIEW / etf_daily / 2014-05-27

all etf daily files

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

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-05-27	SPY	ETF	191.06	191.58	190.95	191.52	72010000.0
2014-05-27	QQQ	ETF	90.28	91.02	90.2	91.001	29725231.0
2014-05-27	IWM	ETF	112.71	113.84	112.65	113.58	46373900.0
2014-05-27	DIA	ETF	166.45	166.6	166.13	166.47	2561300.0
2014-05-27	GLD	ETF	122.98	123.07	121.75	121.85	10895800.0
2014-05-27	TLT	ETF	112.85	113.4	112.4	113.36	6658300.0
2014-05-27	AADR	ETF	38.51	38.51	38.2	38.2	300.0
2014-05-27	AAXJ	ETF	61.98	61.99	61.59	61.75	381400.0
2014-05-27	ACWI	ETF	59.65	59.79	59.59	59.79	952100.0
2014-05-27	ACWV	ETF	66.11	66.33	66.11	66.25	21800.0
2014-05-27	ACWX	ETF	48.22	48.22	47.99	48.14	165434.0
2014-05-27	ADRE	ETF	38.54	38.58	38.18	38.23	13582.0
2014-05-27	AFK	ETF	33.41	33.46	32.96	33.21	22222.0
2014-05-27	AGG	ETF	109.25	109.33	109.1	109.33	762600.0
2014-05-27	AGQ	ETF	59.59	59.59	58.69	59.03	445400.0
2014-05-27	AGZ	ETF	112.46	112.55	112.44	112.4601	8851.0
2014-05-27	AGZD	ETF	24.7	24.955	24.7	24.94	5600.0
2014-05-27	AIA	ETF	48.28	48.28	48.045	48.1	21283.0
2014-05-27	AIQ	ETF	29.83	31.04	29.632	29.81	22438.0
2014-05-27	AIRR	ETF	19.01	19.25	19.01	19.14	23600.0
2014-05-27	AIVI	ETF	51.34	51.34	50.95	51.18	47600.0
2014-05-27	AMJ	ETF	49.07	49.42	48.95	49.07	1583707.0
2014-05-27	AMLP	ETF	91.25	91.3	90.65	90.9	468400.0
2014-05-27	ANGL	ETF	28.12	28.12	27.98	27.98	900.0
2014-05-27	AOA	ETF	46.15	46.17	46.05	46.12	23400.0
2014-05-27	AOK	ETF	32.78	32.79	32.7	32.7726	23750.0
2014-05-27	AOM	ETF	35.27	35.31	35.22	35.31	39436.0
2014-05-27	AOR	ETF	39.75	39.78	39.69	39.77	20175.0
2014-05-27	ARGT	ETF	19.51	19.54	19.32	19.44	8600.0
2014-05-27	ASEA	ETF	16.69	16.7	16.61	16.65	3900.0
2014-05-27	ASHR	ETF	22.05	22.05	21.9	21.95	73000.0
2014-05-27	ASHS	ETF	25.81	25.81	25.49	25.55	8200.0
2014-05-27	ATMP	ETF	29.61	29.66	29.52	29.58	102000.0
2014-05-27	AVIV	ETF	27.8	28.07	27.77	27.98	203053.0
2014-05-27	AWAY	ETF	32.77	33.09	32.28	32.72	795950.0
2014-05-27	BAB	ETF	29.34	29.38	29.2748	29.35	74244.0
2014-05-27	BAL	ETF	52.92	52.93	52.21	52.36	10316.0
2014-05-27	BALT	ETF	6.83	7.02	6.83	6.86	346773.0
2014-05-27	BBH	ETF	89.14	90.81	89.14	90.8	97300.0
2014-05-27	BCHP	ETF	20.43	20.43	20.33	20.4	4165.0
2014-05-27	BCM	ETF	41.18	41.24	41.17	41.2292	5105.0
2014-05-27	BFOR	ETF	7.52	7.585	7.52	7.555	171600.0
2014-05-27	BIB	ETF	39.5	40.6649	39.35	40.65	708800.0
2014-05-27	BICK	ETF	25.7	25.724	25.66	25.724	795.0
2014-05-27	BIL	ETF	91.52	91.54	91.52	91.52	87000.0
2014-05-27	BIS	ETF	677.6	678.0	652.4	652.4	14410.5
2014-05-27	BIV	ETF	84.78	84.79	84.53	84.71	207200.0
2014-05-27	BIZD	ETF	19.79	19.96	19.78	19.84	20900.0
2014-05-27	BJK	ETF	49.72	49.97	49.66	49.9	12600.0
2014-05-27	BKF	ETF	37.99	38.02	37.5601	37.65	149087.0

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

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