PREVIEW / etf_daily / 2013-12-06

all etf daily files

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

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-06	SPY	ETF	180.67	181.11	180.15	180.94	127728000.0
2013-12-06	QQQ	ETF	86.105	86.18	85.59	86.0	36842888.0
2013-12-06	IWM	ETF	112.62	113.1	112.19	112.48	36471900.0
2013-12-06	DIA	ETF	159.53	160.18	159.13	160.16	6345300.0
2013-12-06	GLD	ETF	118.86	119.26	118.01	118.55	7909500.0
2013-12-06	TLT	ETF	102.56	102.99	102.36	102.92	7352000.0
2013-12-06	AADR	ETF	36.95	36.95	36.28	36.51	4400.0
2013-12-06	AAXJ	ETF	60.5	60.94	60.47	60.84	527900.0
2013-12-06	ACWI	ETF	56.5	56.62	56.3	56.55	465300.0
2013-12-06	ACWV	ETF	63.5	63.99	63.5	63.98	14100.0
2013-12-06	ACWX	ETF	45.69	45.9684	45.69	45.93	363891.0
2013-12-06	ADRE	ETF	37.49	37.73	37.42	37.67	198878.0
2013-12-06	AFK	ETF	30.72	31.14	30.47	30.93	20757.0
2013-12-06	AGG	ETF	106.53	106.71	106.48	106.63	2883600.0
2013-12-06	AGQ	ETF	64.12	64.92	63.16	63.68	285975.0
2013-12-06	AGZ	ETF	111.09	111.31	111.02	111.02	19601.0
2013-12-06	AIA	ETF	48.69	49.12	48.69	48.94	4447.0
2013-12-06	AIQ	ETF	23.87	27.659	23.47	23.87	23366.0
2013-12-06	AIVI	ETF	46.29	46.46	45.94	46.42	27400.0
2013-12-06	ALTL	ETF	32.26	32.26	31.96	32.04	2500.0
2013-12-06	AMJ	ETF	44.45	44.82	44.13	44.42	674151.0
2013-12-06	AMLP	ETF	86.6	86.6	85.9	86.45	481340.0
2013-12-06	ANGL	ETF	27.08	27.08	26.83	26.83	1900.0
2013-12-06	AOA	ETF	43.73	43.86	43.67	43.83	36900.0
2013-12-06	AOK	ETF	31.8	31.82	31.7852	31.8	4711.0
2013-12-06	AOM	ETF	34.05	34.08	34.0	34.08	45216.0
2013-12-06	AOR	ETF	38.0	38.1	37.989	38.08	32101.0
2013-12-06	ARGT	ETF	19.71	19.78	19.68	19.7	1200.0
2013-12-06	ASEA	ETF	16.18	16.23	16.06	16.19	11200.0
2013-12-06	ASHR	ETF	25.88	25.9	25.78	25.79	465200.0
2013-12-06	ATMP	ETF	26.02	26.34	25.97	26.34	43700.0
2013-12-06	AVIV	ETF	24.95	25.27	24.53	24.55	148472.0
2013-12-06	AWAY	ETF	39.78	39.78	38.6	39.36	1030334.0
2013-12-06	BAB	ETF	27.42	27.51	27.42	27.49	121674.0
2013-12-06	BAL	ETF	49.93	50.46	49.88	50.369	7207.0
2013-12-06	BALT	ETF	5.59	5.59	5.3	5.37	1010489.0
2013-12-06	BBH	ETF	87.21	87.49	86.09	87.29	46100.0
2013-12-06	BCM	ETF	39.501	39.61	39.501	39.6	20861.0
2013-12-06	BFOR	ETF	7.305	7.305	7.2425	7.27	279200.0
2013-12-06	BIB	ETF	37.2475	37.4	35.37	36.3325	186980.0
2013-12-06	BICK	ETF	24.75	24.91	24.75	24.9	402.0
2013-12-06	BIL	ETF	91.58	91.58	91.56	91.58	188750.0
2013-12-06	BIS	ETF	881.2	888.04	863.6	874.4	305.5
2013-12-06	BIV	ETF	82.95	83.09	82.86	83.02	274700.0
2013-12-06	BIZD	ETF	21.21	21.3	21.21	21.27	8600.0
2013-12-06	BJK	ETF	51.37	51.55	51.08	51.48	29600.0
2013-12-06	BKF	ETF	38.15	38.5	38.0701	38.42	312969.0
2013-12-06	BKLN	ETF	24.84	24.85	24.82	24.84	2154200.0
2013-12-06	BLV	ETF	81.6	81.86	81.53	81.81	114100.0
2013-12-06	BMVP	ETF	22.3733	22.3733	22.2567	22.3233	2613.0

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

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