PREVIEW / etf_daily / 2014-01-17

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-17.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-17	SPY	ETF	184.1	184.45	183.32	183.64	107848700.0
2014-01-17	QQQ	ETF	88.12	88.3701	87.67	87.88	36908236.0
2014-01-17	IWM	ETF	116.31	116.43	115.69	115.93	28722300.0
2014-01-17	DIA	ETF	163.79	164.59	163.61	164.08	8013200.0
2014-01-17	GLD	ETF	120.35	121.02	120.2	120.93	7923400.0
2014-01-17	TLT	ETF	104.86	105.52	104.79	105.48	7588600.0
2014-01-17	AADR	ETF	37.49	37.49	37.3	37.31	2800.0
2014-01-17	AAXJ	ETF	58.45	58.47	58.06	58.18	752600.0
2014-01-17	ACWI	ETF	57.33	57.33	57.05	57.13	907000.0
2014-01-17	ACWV	ETF	62.92	63.15	62.76	62.84	22100.0
2014-01-17	ACWX	ETF	46.11	46.11	45.88	45.97	327398.0
2014-01-17	ADRE	ETF	35.66	35.6601	35.47	35.53	13878.0
2014-01-17	AFK	ETF	30.76	30.949	30.61	30.87	12435.0
2014-01-17	AGG	ETF	107.18	107.3	107.1	107.25	588700.0
2014-01-17	AGQ	ETF	68.2	69.2	68.0	68.16	493000.0
2014-01-17	AGZ	ETF	110.9862	111.0699	110.95	111.04	17930.0
2014-01-17	AGZD	ETF	25.1	25.1	25.015	25.025	14000.0
2014-01-17	AIA	ETF	46.22	46.22	45.91	46.0299	21386.0
2014-01-17	AIQ	ETF	27.25	27.57	26.69	27.36	19834.0
2014-01-17	AIVI	ETF	47.37	47.55	47.24	47.26	14600.0
2014-01-17	ALTL	ETF	32.8573	32.8573	32.8573	32.8573	755.0
2014-01-17	AMJ	ETF	45.56	45.65	45.27	45.36	302609.0
2014-01-17	AMLP	ETF	87.55	87.85	87.25	87.3	474440.0
2014-01-17	ANGL	ETF	27.19	27.19	27.11	27.11	1900.0
2014-01-17	AOA	ETF	44.63	44.63	44.45	44.47	37900.0
2014-01-17	AOK	ETF	32.18	32.18	32.07	32.1	39380.0
2014-01-17	AOM	ETF	34.37	34.42	34.33	34.35	40541.0
2014-01-17	AOR	ETF	38.5	38.582	38.451	38.52	35261.0
2014-01-17	ARGT	ETF	19.28	19.28	19.28	19.28	200.0
2014-01-17	ASEA	ETF	15.12	15.15	15.12	15.14	1700.0
2014-01-17	ASHR	ETF	22.96	22.96	22.75	22.91	209200.0
2014-01-17	ATMP	ETF	26.87	26.93	26.84	26.84	19200.0
2014-01-17	AVIV	ETF	24.08	24.29	23.8793	24.03	64572.0
2014-01-17	AWAY	ETF	41.96	42.32	41.41	41.59	905295.0
2014-01-17	BAB	ETF	27.66	27.689	27.59	27.67	111560.0
2014-01-17	BAL	ETF	54.524	54.74	54.5199	54.69	6883.0
2014-01-17	BALT	ETF	6.26	6.39	6.09	6.18	714766.0
2014-01-17	BBH	ETF	96.0	96.51	95.54	95.87	163100.0
2014-01-17	BCM	ETF	39.15	39.198	39.124	39.124	12480.0
2014-01-17	BFOR	ETF	7.435	7.445	7.3825	7.3975	162400.0
2014-01-17	BIB	ETF	44.8525	45.4975	44.3859	44.795	458212.0
2014-01-17	BICK	ETF	23.9	23.9499	23.86	23.9499	2234.0
2014-01-17	BIL	ETF	91.56	91.56	91.54	91.54	600450.0
2014-01-17	BIS	ETF	690.4	693.6	680.0	692.24	1007.5
2014-01-17	BIV	ETF	82.69	82.8	82.61	82.8	268400.0
2014-01-17	BIZD	ETF	21.25	21.26	21.2	21.2	10200.0
2014-01-17	BJK	ETF	54.85	55.0	54.63	54.79	24000.0
2014-01-17	BKF	ETF	36.12	36.152	35.9	36.03	263021.0
2014-01-17	BKLN	ETF	24.91	24.93	24.91	24.93	1903300.0
2014-01-17	BLV	ETF	83.75	83.99	83.7	83.96	24200.0

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

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