PREVIEW / etf_daily / 2013-09-13

all etf daily files

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

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-13	SPY	ETF	169.13	169.46	168.74	169.33	72727800.0
2013-09-13	QQQ	ETF	78.11	78.145	77.64	78.06	16932448.0
2013-09-13	IWM	ETF	104.59	104.83	104.1	104.81	29478700.0
2013-09-13	DIA	ETF	153.34	153.8	153.21	153.69	4829600.0
2013-09-13	GLD	ETF	127.16	127.96	126.21	127.82	12060400.0
2013-09-13	TLT	ETF	103.51	103.83	103.23	103.55	6106200.0
2013-09-13	AADR	ETF	34.96	35.16	34.88	34.88	54700.0
2013-09-13	AAXJ	ETF	58.04	58.52	58.04	58.48	1365100.0
2013-09-13	ACTV	ETF	10.23	10.6	10.21	10.35	401546.0
2013-09-13	ACWI	ETF	53.41	53.59	53.32	53.56	536100.0
2013-09-13	ACWV	ETF	61.24	61.46	61.24	61.46	60900.0
2013-09-13	ACWX	ETF	44.31	44.42	44.15	44.4	264257.0
2013-09-13	ADRE	ETF	37.01	37.18	37.01	37.12	229114.0
2013-09-13	AFK	ETF	29.13	29.65	29.13	29.46	15632.0
2013-09-13	AGEM	ETF	22.4	22.41	22.22	22.31	22500.0
2013-09-13	AGG	ETF	105.64	105.76	105.61	105.69	655300.0
2013-09-13	AGQ	ETF	82.48	85.2	80.56	85.08	502200.0
2013-09-13	AGZ	ETF	110.21	110.21	109.99	110.04	12618.0
2013-09-13	AIA	ETF	46.59	46.74	46.59	46.69	12843.0
2013-09-13	AIQ	ETF	23.4	24.365	23.398	24.175	54934.0
2013-09-13	AIVI	ETF	44.72	44.92	44.64	44.89	22500.0
2013-09-13	AMJ	ETF	44.25	44.39	43.44	43.64	2568298.0
2013-09-13	AMLP	ETF	86.9	87.05	85.9	86.15	737900.0
2013-09-13	ANGL	ETF	26.34	26.35	26.34	26.35	900.0
2013-09-13	AOA	ETF	41.57	41.75	41.57	41.71	27000.0
2013-09-13	AOK	ETF	31.11	31.14	31.08	31.13	26902.0
2013-09-13	AOM	ETF	33.0499	33.09	33.0	33.08	36471.0
2013-09-13	AOR	ETF	36.5403	36.61	36.52	36.61	28140.0
2013-09-13	ARB	ETF	47.5	47.5	47.45	47.46	211021.0
2013-09-13	ARGT	ETF	19.14	19.14	18.93	19.1	3300.0
2013-09-13	ASEA	ETF	16.27	16.29	16.23	16.28	9500.0
2013-09-13	ATMP	ETF	25.55	25.55	25.38	25.46	21900.0
2013-09-13	AVIV	ETF	22.33	22.76	22.29	22.47	50699.0
2013-09-13	AWAY	ETF	31.85	31.999	31.4	31.65	873885.0
2013-09-13	BAB	ETF	26.82	26.99	26.82	26.89	84055.0
2013-09-13	BAL	ETF	54.22	54.39	53.92	54.03	19801.0
2013-09-13	BALT	ETF	5.2	5.24	5.06	5.11	415272.0
2013-09-13	BBH	ETF	82.55	82.55	81.86	82.5	29100.0
2013-09-13	BCM	ETF	40.723	40.723	40.723	40.723	259.0
2013-09-13	BFOR	ETF	6.7025	6.72	6.685	6.7175	199200.0
2013-09-13	BIB	ETF	31.7475	32.1425	31.4013	32.14	52444.0
2013-09-13	BICK	ETF	23.45	23.45	23.371	23.45	380.0
2013-09-13	BIL	ETF	91.6	91.6	91.58	91.6	355250.0
2013-09-13	BIS	ETF	1070.0	1070.0	1047.6	1047.6	240.0
2013-09-13	BIV	ETF	81.7	81.9	81.69	81.83	228900.0
2013-09-13	BIZD	ETF	20.4	20.44	20.37	20.41	2900.0
2013-09-13	BJK	ETF	46.28	46.41	46.12	46.41	4600.0
2013-09-13	BKF	ETF	37.09	37.4	36.99	37.35	186791.0
2013-09-13	BKLN	ETF	24.74	24.74	24.72	24.74	2060200.0
2013-09-13	BLV	ETF	81.16	81.23	80.8	81.23	63100.0

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

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