PREVIEW / etf_daily / 2014-01-30

all etf daily files

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

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-30	SPY	ETF	178.83	179.81	178.26	179.23	118938100.0
2014-01-30	QQQ	ETF	85.99	86.8	85.88	86.5	66863622.0
2014-01-30	IWM	ETF	112.33	113.65	112.04	113.0	40851600.0
2014-01-30	DIA	ETF	158.3	158.77	157.37	158.17	7864700.0
2014-01-30	GLD	ETF	119.67	120.22	119.6	119.77	8746500.0
2014-01-30	TLT	ETF	107.47	107.67	107.11	107.56	5956900.0
2014-01-30	AADR	ETF	35.92	36.09	35.92	36.09	600.0
2014-01-30	AAXJ	ETF	56.18	56.34	55.91	56.02	1592100.0
2014-01-30	ACWI	ETF	55.39	55.6	55.21	55.48	1044400.0
2014-01-30	ACWV	ETF	61.22	61.49	61.21	61.32	119300.0
2014-01-30	ACWX	ETF	44.33	44.473	44.22	44.36	331058.0
2014-01-30	ADRE	ETF	34.05	34.105	33.84	33.97	19403.0
2014-01-30	AFK	ETF	30.17	30.17	29.8117	30.0	18325.0
2014-01-30	AGG	ETF	107.76	107.88	107.71	107.87	3074400.0
2014-01-30	AGQ	ETF	60.78	61.5	60.5	61.04	728200.0
2014-01-30	AGZ	ETF	111.68	111.68	111.4701	111.52	13041.0
2014-01-30	AGZD	ETF	24.985	24.985	24.985	24.985	400.0
2014-01-30	AIA	ETF	44.01	44.172	43.86	43.97	14356.0
2014-01-30	AIQ	ETF	27.73	28.17	27.72	28.06	28458.0
2014-01-30	AIVI	ETF	46.09	46.45	46.05	46.31	12700.0
2014-01-30	ALTL	ETF	32.079	32.169	32.079	32.169	335.0
2014-01-30	AMJ	ETF	46.08	46.35	45.8201	46.12	435835.0
2014-01-30	AMLP	ETF	88.4	88.8	88.25	88.25	975960.0
2014-01-30	ANGL	ETF	27.24	27.24	27.1	27.1	3400.0
2014-01-30	AOA	ETF	43.4	43.6	43.36	43.53	59100.0
2014-01-30	AOK	ETF	31.81	31.88	31.79	31.84	22410.0
2014-01-30	AOM	ETF	33.95	34.0177	33.901	34.0	30943.0
2014-01-30	AOR	ETF	37.87	37.9498	37.78	37.9	9169.0
2014-01-30	ARGT	ETF	17.35	17.69	17.35	17.64	14500.0
2014-01-30	ASEA	ETF	14.77	14.8	14.68	14.73	44800.0
2014-01-30	ASHR	ETF	23.04	23.12	22.92	22.92	113200.0
2014-01-30	ATMP	ETF	27.21	27.22	27.14	27.15	19000.0
2014-01-30	AVIV	ETF	24.59	25.06	24.4	24.5	85525.0
2014-01-30	AWAY	ETF	40.18	41.35	40.07	40.96	1014024.0
2014-01-30	BAB	ETF	28.05	28.07	27.97	28.01	89983.0
2014-01-30	BAL	ETF	54.36	54.36	53.9	53.9	7553.0
2014-01-30	BALT	ETF	5.51	5.5396	5.37	5.4	742258.0
2014-01-30	BBH	ETF	97.49	98.8	97.11	98.23	207100.0
2014-01-30	BCM	ETF	38.83	38.89	38.78	38.78	179768.0
2014-01-30	BFOR	ETF	7.16	7.24	7.16	7.215	134800.0
2014-01-30	BIB	ETF	44.86	46.0	44.425	45.445	547960.0
2014-01-30	BICK	ETF	22.81	22.81	22.67	22.72	2138.0
2014-01-30	BIL	ETF	91.56	91.56	91.54	91.56	170050.0
2014-01-30	BIS	ETF	685.2	685.6	660.0	667.6	2472.0
2014-01-30	BIV	ETF	83.32	83.41	83.23	83.37	232900.0
2014-01-30	BIZD	ETF	21.09	21.11	21.08	21.09	2600.0
2014-01-30	BJK	ETF	50.74	51.57	50.74	51.16	13100.0
2014-01-30	BKF	ETF	34.61	34.6999	34.2907	34.34	63674.0
2014-01-30	BKLN	ETF	24.88	24.9	24.85	24.89	2468100.0
2014-01-30	BLV	ETF	85.13	85.32	84.95	85.29	55700.0

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

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