PREVIEW / etf_daily / 2014-01-31

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-31.parquet
  size:    43 KB
  rows:    1,067

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-31	SPY	ETF	177.01	179.29	176.92	178.18	194677900.0
2014-01-31	QQQ	ETF	85.54	86.68	85.45	86.27	45196915.0
2014-01-31	IWM	ETF	111.25	113.0	111.17	112.16	49293400.0
2014-01-31	DIA	ETF	156.23	157.7	155.85	156.75	10693100.0
2014-01-31	GLD	ETF	120.65	120.86	119.46	120.09	7983100.0
2014-01-31	TLT	ETF	108.2	108.41	107.85	108.28	14690900.0
2014-01-31	AADR	ETF	35.73	36.34	35.73	36.24	1400.0
2014-01-31	AAXJ	ETF	55.44	56.1	55.34	55.93	341400.0
2014-01-31	ACWI	ETF	54.75	55.28	54.57	54.95	1262500.0
2014-01-31	ACWV	ETF	60.8	61.38	60.44	61.1	85100.0
2014-01-31	ACWX	ETF	43.64	44.076	43.51	43.84	275045.0
2014-01-31	ADRE	ETF	33.48	33.9	33.404	33.64	96579.0
2014-01-31	AFK	ETF	29.85	30.069	29.48	29.9536	21304.0
2014-01-31	AGG	ETF	108.0	108.07	107.91	108.07	3195200.0
2014-01-31	AGQ	ETF	61.92	62.33	60.54	60.84	984000.0
2014-01-31	AGZ	ETF	111.85	112.9499	111.6608	111.71	12898.0
2014-01-31	AGZD	ETF	24.955	24.955	24.955	24.955	6800.0
2014-01-31	AIA	ETF	43.36	43.92	43.36	43.82	24574.0
2014-01-31	AIQ	ETF	27.51	28.96	27.51	28.7	42378.0
2014-01-31	AIVI	ETF	45.44	45.91	45.35	45.68	17900.0
2014-01-31	AMJ	ETF	45.8	46.75	45.56	46.6	969440.0
2014-01-31	AMLP	ETF	87.75	89.25	87.7	89.0	780460.0
2014-01-31	ANGL	ETF	27.0	27.0	27.0	27.0	400.0
2014-01-31	AOA	ETF	43.06	43.47	43.06	43.26	38700.0
2014-01-31	AOK	ETF	31.73	31.82	31.72	31.79	11461.0
2014-01-31	AOM	ETF	33.71	33.97	33.71	33.87	41821.0
2014-01-31	AOR	ETF	37.6	37.8599	37.5	37.68	16063.0
2014-01-31	ARGT	ETF	17.25	17.52	17.21	17.39	9600.0
2014-01-31	ASEA	ETF	14.63	14.77	14.63	14.73	9000.0
2014-01-31	ASHR	ETF	22.95	22.95	22.73	22.92	147100.0
2014-01-31	ATMP	ETF	26.93	27.46	26.93	27.36	59200.0
2014-01-31	AVIV	ETF	24.24	24.61	24.19	24.39	73693.0
2014-01-31	AWAY	ETF	40.5	41.63	40.28	40.86	774059.0
2014-01-31	BAB	ETF	28.23	28.23	28.11	28.22	160272.0
2014-01-31	BAL	ETF	53.94	54.2201	53.89	53.92	4116.0
2014-01-31	BALT	ETF	5.31	5.88	5.17	5.79	1235077.0
2014-01-31	BBH	ETF	97.06	97.87	96.28	96.88	105700.0
2014-01-31	BCM	ETF	38.42	38.8	38.42	38.6701	60885.0
2014-01-31	BFOR	ETF	7.17	7.2275	7.075	7.185	164000.0
2014-01-31	BIB	ETF	44.455	45.0	43.6551	44.025	417674.0
2014-01-31	BICK	ETF	22.42	22.6196	22.42	22.6196	1032.0
2014-01-31	BIL	ETF	91.56	91.56	91.54	91.54	336200.0
2014-01-31	BIS	ETF	690.8	698.796	675.2	690.4	2091.0
2014-01-31	BIV	ETF	83.43	83.59	83.41	83.5	170800.0
2014-01-31	BIZD	ETF	20.86	20.95	20.81	20.86	3000.0
2014-01-31	BJK	ETF	50.97	51.66	50.45	51.62	9800.0
2014-01-31	BKF	ETF	33.94	34.4692	33.87	34.25	61213.0
2014-01-31	BKLN	ETF	24.9	24.91	24.88	24.91	2061000.0
2014-01-31	BLV	ETF	85.56	85.76	85.35	85.7	326700.0
2014-01-31	BMVP	ETF	21.833	22.233	21.833	22.17	5819.0

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

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