PREVIEW / etf_daily / 2014-02-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-06.parquet
  size:    43 KB
  rows:    1,059

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-02-06	SPY	ETF	175.58	177.48	175.22	177.48	132877600.0
2014-02-06	QQQ	ETF	84.94	85.88	84.92	85.77	32338053.0
2014-02-06	IWM	ETF	108.88	109.97	108.85	109.51	57611700.0
2014-02-06	DIA	ETF	154.7	156.15	154.7	156.14	10426200.0
2014-02-06	GLD	ETF	121.38	121.51	120.78	121.24	4745800.0
2014-02-06	TLT	ETF	106.97	107.02	106.52	106.7	5708700.0
2014-02-06	AADR	ETF	35.99	36.3	35.99	36.26	1500.0
2014-02-06	AAXJ	ETF	55.49	56.09	55.42	56.09	810400.0
2014-02-06	ACWI	ETF	54.43	55.15	54.41	55.15	1346100.0
2014-02-06	ACWV	ETF	60.49	60.85	60.49	60.81	31300.0
2014-02-06	ACWX	ETF	43.73	44.28	43.73	44.25	249866.0
2014-02-06	ADRE	ETF	33.42	33.99	33.42	33.93	14253.0
2014-02-06	AFK	ETF	29.77	30.1099	29.77	30.09	7078.0
2014-02-06	AGG	ETF	107.62	107.67	107.55	107.65	1127700.0
2014-02-06	AGQ	ETF	66.13	66.5	65.23	65.61	340500.0
2014-02-06	AGZ	ETF	111.68	112.76	111.55	111.6116	18690.0
2014-02-06	AIA	ETF	43.27	43.739	43.25	43.7255	26292.0
2014-02-06	AIQ	ETF	27.68	27.94	27.65	27.79	23031.0
2014-02-06	AIVI	ETF	45.73	46.19	45.73	46.15	18500.0
2014-02-06	ALTL	ETF	31.87	31.87	31.87	31.87	400.0
2014-02-06	AMJ	ETF	46.05	46.65	46.05	46.6	394833.0
2014-02-06	AMLP	ETF	87.45	87.75	87.1	87.5	651040.0
2014-02-06	ANGL	ETF	26.89	26.97	26.89	26.97	2600.0
2014-02-06	AOA	ETF	42.87	43.18	42.87	43.18	14000.0
2014-02-06	AOK	ETF	31.65	31.73	31.626	31.73	11467.0
2014-02-06	AOM	ETF	33.78	33.85	33.7701	33.85	18400.0
2014-02-06	AOR	ETF	37.49	37.67	37.481	37.6619	23286.0
2014-02-06	ARGT	ETF	16.95	17.57	16.95	17.43	2000.0
2014-02-06	ASEA	ETF	14.92	14.97	14.86	14.95	1300.0
2014-02-06	ASHR	ETF	22.7	22.88	22.7	22.88	526700.0
2014-02-06	ATMP	ETF	27.27	27.44	27.27	27.4	29300.0
2014-02-06	AVIV	ETF	23.67	23.77	23.5	23.6	81274.0
2014-02-06	AWAY	ETF	38.47	39.63	38.29	39.6	866148.0
2014-02-06	BAB	ETF	28.16	28.21	28.1	28.13	71310.0
2014-02-06	BAL	ETF	54.014	54.42	54.0	54.06	10528.0
2014-02-06	BALT	ETF	5.83	6.41	5.82	6.05	1610495.0
2014-02-06	BBH	ETF	94.7	95.09	93.7	93.89	95700.0
2014-02-06	BCM	ETF	39.36	39.46	39.29	39.31	27382.0
2014-02-06	BFOR	ETF	6.9825	7.085	6.9825	7.0825	202400.0
2014-02-06	BIB	ETF	41.26	41.645	40.3361	40.71	409600.0
2014-02-06	BICK	ETF	22.59	22.6401	22.59	22.6401	876.0
2014-02-06	BIL	ETF	91.54	91.56	91.54	91.54	253150.0
2014-02-06	BIS	ETF	730.0	745.596	722.8	741.28	1735.0
2014-02-06	BIV	ETF	83.3	83.37	83.25	83.35	234900.0
2014-02-06	BIZD	ETF	20.66	20.75	20.65	20.67	3500.0
2014-02-06	BJK	ETF	50.43	51.26	50.43	51.26	15400.0
2014-02-06	BKF	ETF	33.91	34.5728	33.91	34.49	165225.0
2014-02-06	BKLN	ETF	24.86	24.89	24.85	24.88	2503300.0
2014-02-06	BLV	ETF	85.12	85.28	84.84	84.99	108700.0
2014-02-06	BMVP	ETF	21.7203	21.8487	21.7203	21.8459	3597.0

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

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