PREVIEW / etf_daily / 2014-01-27

all etf daily files

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

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-01-27	SPY	ETF	179.06	179.52	177.12	178.01	180843100.0
2014-01-27	QQQ	ETF	86.77	86.89	85.25	85.9	63676475.0
2014-01-27	IWM	ETF	113.78	113.84	111.15	111.79	60368200.0
2014-01-27	DIA	ETF	158.71	159.11	157.51	158.02	14215300.0
2014-01-27	GLD	ETF	121.65	122.06	120.72	120.96	7528600.0
2014-01-27	TLT	ETF	107.22	107.6	106.7	106.73	9218200.0
2014-01-27	AADR	ETF	36.3	36.3	35.67	35.9	6000.0
2014-01-27	AAXJ	ETF	55.93	56.1	55.36	55.76	1095200.0
2014-01-27	ACWI	ETF	55.62	55.62	54.91	55.21	1306000.0
2014-01-27	ACWV	ETF	61.62	61.62	61.01	61.28	43600.0
2014-01-27	ACWX	ETF	44.59	44.59	44.04	44.29	259621.0
2014-01-27	ADRE	ETF	34.02	34.1	33.61	33.95	70418.0
2014-01-27	AFK	ETF	30.3	30.3996	30.0	30.06	30573.0
2014-01-27	AGG	ETF	107.53	107.64	107.34	107.35	1335000.0
2014-01-27	AGQ	ETF	65.14	65.58	63.48	63.72	1018800.0
2014-01-27	AGZ	ETF	111.3	111.44	111.27	111.27	15580.0
2014-01-27	AGZD	ETF	24.985	24.985	24.985	24.985	10000.0
2014-01-27	AIA	ETF	44.22	44.4	43.8	44.09	111836.0
2014-01-27	AIQ	ETF	28.755	28.755	27.6	27.75	26954.0
2014-01-27	AIVI	ETF	46.3	46.48	45.88	46.2	15600.0
2014-01-27	ALTL	ETF	31.888	31.888	31.834	31.834	1108.0
2014-01-27	AMJ	ETF	46.03	46.14	45.2	45.67	463848.0
2014-01-27	AMLP	ETF	88.35	88.6	87.1	87.75	1072240.0
2014-01-27	ANGL	ETF	27.14	27.14	27.09	27.09	800.0
2014-01-27	AOA	ETF	43.58	43.59	43.1	43.3	132900.0
2014-01-27	AOK	ETF	31.81	31.839	31.7001	31.73	85662.0
2014-01-27	AOM	ETF	34.01	34.01	33.7801	33.83	43768.0
2014-01-27	AOR	ETF	37.83	37.91	37.61	37.67	185261.0
2014-01-27	ARGT	ETF	17.5	17.76	17.0	17.67	30900.0
2014-01-27	ASEA	ETF	14.73	14.77	14.54	14.68	4900.0
2014-01-27	ASHR	ETF	23.2	23.27	23.0	23.13	267700.0
2014-01-27	ATMP	ETF	26.85	27.13	26.65	26.95	34500.0
2014-01-27	AVIV	ETF	24.32	24.35	23.92	24.01	63299.0
2014-01-27	AWAY	ETF	41.02	41.33	39.82	39.98	996338.0
2014-01-27	BAB	ETF	27.97	28.12	27.95	28.0	212929.0
2014-01-27	BAL	ETF	54.3831	54.5	52.6371	52.82	28601.0
2014-01-27	BALT	ETF	5.17	5.42	5.1	5.3	1063674.0
2014-01-27	BBH	ETF	95.53	95.7	92.21	93.86	323400.0
2014-01-27	BCM	ETF	39.07	39.07	38.87	38.87	35349.0
2014-01-27	BFOR	ETF	7.2	7.2275	7.075	7.135	501600.0
2014-01-27	BIB	ETF	43.105	43.6055	39.6705	41.345	2245614.0
2014-01-27	BICK	ETF	22.77	22.77	22.38	22.607	8413.0
2014-01-27	BIL	ETF	91.54	91.56	91.54	91.54	332700.0
2014-01-27	BIS	ETF	706.4	763.196	696.0	736.4	5813.5
2014-01-27	BIV	ETF	83.03	83.15	82.92	83.0	6110500.0
2014-01-27	BIZD	ETF	20.99	21.01	20.69	20.86	18300.0
2014-01-27	BJK	ETF	50.51	51.23	50.0	50.55	26700.0
2014-01-27	BKF	ETF	34.43	34.617	34.01	34.31	112482.0
2014-01-27	BKLN	ETF	24.92	24.92	24.9	24.91	2474700.0
2014-01-27	BLV	ETF	84.81	84.95	84.53	84.58	81600.0

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

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