PREVIEW / etf_daily / 2014-05-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-28.parquet
  size:    45 KB
  rows:    1,098

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-28	SPY	ETF	191.52	191.82	191.06	191.38	66723000.0
2014-05-28	QQQ	ETF	90.97	91.1	90.645	90.72	30478074.0
2014-05-28	IWM	ETF	113.33	113.46	112.53	112.99	37055400.0
2014-05-28	DIA	ETF	166.54	166.55	165.95	166.09	3681500.0
2014-05-28	GLD	ETF	121.47	121.7	120.92	121.2	6736800.0
2014-05-28	TLT	ETF	114.1	114.84	114.09	114.76	10361000.0
2014-05-28	AADR	ETF	38.21	38.28	38.21	38.28	500.0
2014-05-28	AAXJ	ETF	61.98	62.23	61.95	62.16	849700.0
2014-05-28	ACWI	ETF	59.77	59.77	59.57	59.68	367700.0
2014-05-28	ACWV	ETF	66.25	66.3	66.0	66.23	22700.0
2014-05-28	ACWX	ETF	48.05	48.11	47.95	48.06	76812.0
2014-05-28	ADRE	ETF	38.42	38.4501	38.29	38.43	8140.0
2014-05-28	AFK	ETF	33.39	33.42	32.9075	33.09	27956.0
2014-05-28	AGG	ETF	109.49	109.69	109.43	109.63	692300.0
2014-05-28	AGQ	ETF	58.57	59.11	58.4	58.61	187500.0
2014-05-28	AGZ	ETF	112.3801	112.7199	112.3801	112.67	4662.0
2014-05-28	AGZD	ETF	24.95	24.985	24.95	24.985	1600.0
2014-05-28	AIA	ETF	48.43	48.49	48.35	48.439	44628.0
2014-05-28	AIQ	ETF	29.61	30.27	29.11	29.91	38926.0
2014-05-28	AIRR	ETF	19.27	19.27	19.0	19.07	41200.0
2014-05-28	AIVI	ETF	50.94	50.96	50.82	50.94	20400.0
2014-05-28	ALTL	ETF	34.53	34.53	34.5278	34.5278	326.0
2014-05-28	AMJ	ETF	49.01	49.18	48.89	49.09	280459.0
2014-05-28	AMLP	ETF	91.1	91.15	90.5	90.8	588920.0
2014-05-28	ANGL	ETF	28.01	28.06	27.96	28.06	6600.0
2014-05-28	AOA	ETF	46.06	46.18	46.03	46.17	43200.0
2014-05-28	AOK	ETF	32.82	32.83	32.7601	32.81	16125.0
2014-05-28	AOM	ETF	35.31	35.32	35.23	35.29	29945.0
2014-05-28	AOR	ETF	39.79	39.7998	39.68	39.72	17326.0
2014-05-28	ARGT	ETF	19.51	19.51	19.47	19.47	2800.0
2014-05-28	ASEA	ETF	16.61	16.69	16.59	16.64	17200.0
2014-05-28	ASHR	ETF	22.26	22.29	22.13	22.14	81000.0
2014-05-28	ASHS	ETF	25.85	25.92	25.8	25.8	11500.0
2014-05-28	ATMP	ETF	29.45	29.65	29.45	29.63	17400.0
2014-05-28	AVIV	ETF	27.91	28.04	27.51	27.81	233807.0
2014-05-28	AWAY	ETF	32.66	32.665	30.5	31.2	3538107.0
2014-05-28	BAB	ETF	29.47	29.54	29.4304	29.51	82561.0
2014-05-28	BAL	ETF	52.43	52.43	51.55	52.2129	8410.0
2014-05-28	BALT	ETF	6.95	6.95	6.65	6.65	435146.0
2014-05-28	BBH	ETF	90.91	90.99	90.23	90.24	78700.0
2014-05-28	BCHP	ETF	20.29	20.368	20.29	20.3299	3964.0
2014-05-28	BCM	ETF	41.15	41.229	41.06	41.14	36209.0
2014-05-28	BFOR	ETF	7.55	7.5675	7.525	7.5575	90400.0
2014-05-28	BIB	ETF	40.92	40.96	40.175	40.253	369952.0
2014-05-28	BICK	ETF	25.81	25.9	25.81	25.85	8581.0
2014-05-28	BIL	ETF	91.54	91.54	91.52	91.54	89300.0
2014-05-28	BIS	ETF	648.0	662.0	646.4	658.8	6899.0
2014-05-28	BIV	ETF	84.99	85.14	84.82	85.06	157000.0
2014-05-28	BIZD	ETF	19.82	19.89	19.75	19.84	14200.0
2014-05-28	BJK	ETF	49.75	50.13	49.73	50.1	25500.0

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

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