PREVIEW / etf_daily / 2013-12-17

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-17.parquet
  size:    43 KB
  rows:    1,058

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
2013-12-17	SPY	ETF	179.38	179.41	178.25	178.65	89886000.0
2013-12-17	QQQ	ETF	85.32	85.53	84.99	85.15	24454893.0
2013-12-17	IWM	ETF	111.45	111.54	110.62	111.35	32399800.0
2013-12-17	DIA	ETF	159.27	159.29	158.39	158.78	6001100.0
2013-12-17	GLD	ETF	118.96	119.9	118.37	118.65	8589100.0
2013-12-17	TLT	ETF	102.61	103.4	102.59	103.29	6014400.0
2013-12-17	AADR	ETF	36.42	36.45	36.25	36.29	51800.0
2013-12-17	AAXJ	ETF	59.65	59.7	59.34	59.35	702200.0
2013-12-17	ACWI	ETF	55.89	55.89	55.59	55.69	1157800.0
2013-12-17	ACWV	ETF	63.02	63.02	62.69	62.69	71000.0
2013-12-17	ACWX	ETF	45.25	45.25	45.063	45.13	604729.0
2013-12-17	ADRE	ETF	36.89	36.968	36.62	36.62	11301.0
2013-12-17	AFK	ETF	30.95	30.95	30.54	30.71	7965.0
2013-12-17	AGG	ETF	106.77	106.96	106.73	106.91	1381500.0
2013-12-17	AGQ	ETF	65.52	67.72	65.52	66.0	359925.0
2013-12-17	AGZ	ETF	111.04	111.2799	111.0	111.06	22845.0
2013-12-17	AIA	ETF	47.13	47.13	46.78	46.88	36902.0
2013-12-17	AIQ	ETF	24.23	24.23	22.92	23.63	53922.0
2013-12-17	AIVI	ETF	45.81	45.88	45.7	45.73	20900.0
2013-12-17	ALTL	ETF	31.71	31.82	31.67	31.82	5728.0
2013-12-17	AMJ	ETF	43.65	44.09	43.51	43.72	457912.0
2013-12-17	AMLP	ETF	85.9	85.9	85.3	85.45	582300.0
2013-12-17	ANGL	ETF	27.22	27.22	26.95	26.95	4100.0
2013-12-17	AOA	ETF	43.46	43.46	43.27	43.39	65100.0
2013-12-17	AOK	ETF	31.69	31.73	31.66	31.725	37981.0
2013-12-17	AOM	ETF	33.8838	33.93	33.83	33.91	72799.0
2013-12-17	AOR	ETF	37.8	37.839	37.7001	37.8	28836.0
2013-12-17	ARGT	ETF	19.73	20.12	19.66	20.12	1900.0
2013-12-17	ASEA	ETF	15.74	15.77	15.7	15.72	22900.0
2013-12-17	ASHR	ETF	24.85	24.86	24.57	24.66	225800.0
2013-12-17	ATMP	ETF	25.83	25.85	25.68	25.79	12200.0
2013-12-17	AVIV	ETF	23.98	23.98	23.71	23.92	76799.0
2013-12-17	AWAY	ETF	37.85	38.8199	37.52	38.66	948642.0
2013-12-17	BAB	ETF	27.46	27.48	27.381	27.4448	186302.0
2013-12-17	BAL	ETF	52.3799	52.54	52.0501	52.0501	9949.0
2013-12-17	BALT	ETF	5.63	5.64	5.19	5.32	1500191.0
2013-12-17	BBH	ETF	84.73	84.73	83.18	83.51	113200.0
2013-12-17	BCM	ETF	39.52	39.52	39.462	39.5	151667.0
2013-12-17	BFOR	ETF	7.225	7.2275	7.17	7.205	201600.0
2013-12-17	BIB	ETF	34.545	34.545	33.1875	33.6125	214012.0
2013-12-17	BICK	ETF	24.21	24.23	24.21	24.221	679.0
2013-12-17	BIL	ETF	91.56	91.58	91.56	91.56	112400.0
2013-12-17	BIS	ETF	940.0	947.96	924.4	931.4	235.5
2013-12-17	BIV	ETF	83.14	83.36	83.14	83.36	264600.0
2013-12-17	BIZD	ETF	20.96	21.01	20.88	20.95	6500.0
2013-12-17	BJK	ETF	52.54	52.58	52.28	52.33	21800.0
2013-12-17	BKF	ETF	37.27	37.295	37.068	37.09	96269.0
2013-12-17	BKLN	ETF	24.78	24.79	24.75	24.79	2323800.0
2013-12-17	BLV	ETF	82.47	82.57	82.15	82.51	72700.0
2013-12-17	BMVP	ETF	22.077	22.123	22.053	22.096	4454.0

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

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