PREVIEW / etf_daily / 2013-09-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-30.parquet
  size:    41 KB
  rows:    1,018

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-09-30	SPY	ETF	167.48	168.54	167.15	168.01	143937000.0
2013-09-30	QQQ	ETF	78.27	79.09	78.0	78.88	28031856.0
2013-09-30	IWM	ETF	105.43	106.84	105.24	106.61	45771700.0
2013-09-30	DIA	ETF	150.79	151.54	150.45	151.0	9426100.0
2013-09-30	GLD	ETF	127.95	129.14	127.7	128.18	8979000.0
2013-09-30	TLT	ETF	106.66	106.9	106.18	106.4	8438800.0
2013-09-30	AADR	ETF	35.49	35.58	35.31	35.34	1900.0
2013-09-30	AAXJ	ETF	58.21	58.34	57.9	58.28	338800.0
2013-09-30	ACTV	ETF	14.385	14.385	14.31	14.31	47732280.0
2013-09-30	ACWI	ETF	53.88	54.09	53.69	53.92	898400.0
2013-09-30	ACWV	ETF	61.5	61.99	61.47	61.81	42700.0
2013-09-30	ACWX	ETF	44.68	44.96	44.68	44.82	830530.0
2013-09-30	ADRE	ETF	36.94	37.2	36.94	36.96	26842.0
2013-09-30	AFK	ETF	29.9	30.0	29.9	29.951	21921.0
2013-09-30	AGEM	ETF	22.2301	22.28	22.2301	22.28	604.0
2013-09-30	AGG	ETF	107.29	107.33	107.15	107.2	1439500.0
2013-09-30	AGQ	ETF	78.96	83.0	78.6	80.2	437025.0
2013-09-30	AGZ	ETF	111.21	111.24	111.04	111.24	34120.0
2013-09-30	AIA	ETF	46.51	46.61	46.12	46.4582	16067.0
2013-09-30	AIQ	ETF	24.47	27.74	24.47	27.69	266658.0
2013-09-30	AIVI	ETF	45.27	45.53	45.27	45.47	16300.0
2013-09-30	AMJ	ETF	44.06	44.68	44.04	44.6	428433.0
2013-09-30	AMLP	ETF	87.6	88.0	87.25	87.95	408720.0
2013-09-30	ANGL	ETF	26.27	26.6	26.25	26.51	3200.0
2013-09-30	AOA	ETF	41.85	42.06	41.8	41.99	18400.0
2013-09-30	AOK	ETF	31.35	31.4	31.34	31.3749	19002.0
2013-09-30	AOM	ETF	33.27	33.38	33.27	33.34	13873.0
2013-09-30	AOR	ETF	36.78	36.91	36.761	36.87	12655.0
2013-09-30	ARGT	ETF	19.73	20.0	19.73	19.82	1300.0
2013-09-30	ASEA	ETF	16.25	16.51	16.22	16.3	43300.0
2013-09-30	ATMP	ETF	26.38	26.38	25.99	26.07	28300.0
2013-09-30	AVIV	ETF	23.08	23.232	22.74	22.8	53235.0
2013-09-30	AWAY	ETF	28.74	28.92	27.96	27.96	1322483.0
2013-09-30	BAB	ETF	27.21	27.36	27.21	27.29	110700.0
2013-09-30	BAL	ETF	55.95	56.01	55.56	55.79	19027.0
2013-09-30	BALT	ETF	5.17	5.2	4.87	4.89	988379.0
2013-09-30	BBH	ETF	82.15	83.45	82.09	82.74	92900.0
2013-09-30	BFOR	ETF	6.7875	6.825	6.7425	6.8025	353600.0
2013-09-30	BIB	ETF	32.2075	33.16	32.125	32.5925	125320.0
2013-09-30	BICK	ETF	23.54	23.5431	23.484	23.484	1000.0
2013-09-30	BIL	ETF	91.58	91.6	91.58	91.58	480950.0
2013-09-30	BIS	ETF	1012.0	1052.4	1006.0	1020.8	762.5
2013-09-30	BIV	ETF	83.43	83.54	83.31	83.5	166000.0
2013-09-30	BIZD	ETF	20.35	20.58	20.35	20.55	8000.0
2013-09-30	BJK	ETF	47.24	47.44	47.17	47.41	8000.0
2013-09-30	BKF	ETF	37.08	37.33	37.08	37.24	111480.0
2013-09-30	BKLN	ETF	24.7	24.7	24.67	24.68	1688100.0
2013-09-30	BLV	ETF	83.18	83.28	82.81	83.02	43800.0
2013-09-30	BMVP	ETF	20.03	20.21	20.0	20.21	1690.0
2013-09-30	BND	ETF	80.83	80.89	80.74	80.88	1218500.0

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

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