PREVIEW / etf_daily / 2013-07-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-16.parquet
  size:    41 KB
  rows:    1,005

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-07-16	SPY	ETF	168.26	168.36	167.07	167.52	88702100.0
2013-07-16	QQQ	ETF	75.54	75.59	75.18	75.37	31747092.0
2013-07-16	IWM	ETF	103.62	103.67	102.82	103.06	38630800.0
2013-07-16	DIA	ETF	154.6	154.74	153.93	154.3	3594600.0
2013-07-16	GLD	ETF	124.76	125.21	124.33	124.89	5577300.0
2013-07-16	TLT	ETF	108.43	108.76	108.27	108.66	3650200.0
2013-07-16	AAXJ	ETF	56.15	56.42	56.06	56.39	283500.0
2013-07-16	ACTV	ETF	8.7	8.83	8.64	8.81	1340485.0
2013-07-16	ACWI	ETF	52.23	52.27	51.98	52.15	1227200.0
2013-07-16	ACWV	ETF	62.13	62.13	61.79	61.95	61900.0
2013-07-16	ACWX	ETF	42.5	42.61	42.44	42.609	619638.0
2013-07-16	ADRE	ETF	35.06	35.06	34.8	34.95	18723.0
2013-07-16	AFK	ETF	28.71	28.825	28.568	28.74	15023.0
2013-07-16	AGEM	ETF	21.36	21.36	21.09	21.12	805.0
2013-07-16	AGG	ETF	107.14	107.22	107.07	107.21	585900.0
2013-07-16	AGQ	ETF	70.4	71.0	70.12	70.88	321150.0
2013-07-16	AGZ	ETF	111.1	111.17	110.97	111.045	16113.0
2013-07-16	AIA	ETF	43.62	43.7	43.58	43.7	53211.0
2013-07-16	AIQ	ETF	16.88	16.92	16.75	16.92	72370.0
2013-07-16	AIVI	ETF	41.68	41.78	41.58	41.76	30400.0
2013-07-16	ALTL	ETF	29.68	29.696	29.512	29.512	2370.0
2013-07-16	AMJ	ETF	48.74	48.74	47.75	47.95	1101783.0
2013-07-16	AMLP	ETF	91.5	91.8	90.1	90.3	677480.0
2013-07-16	ANGL	ETF	26.68	26.76	26.51	26.68	1800.0
2013-07-16	AOA	ETF	41.2	41.5	41.0	41.07	28200.0
2013-07-16	AOK	ETF	31.16	31.16	31.0501	31.13	18545.0
2013-07-16	AOM	ETF	32.97	32.97	32.86	32.8808	65572.0
2013-07-16	AOR	ETF	36.3	36.3599	36.2	36.23	23278.0
2013-07-16	ARB	ETF	46.49	46.55	46.3	46.3	306274.0
2013-07-16	ARGT	ETF	16.79	16.79	16.79	16.79	100.0
2013-07-16	ASEA	ETF	17.14	17.19	17.08	17.18	11800.0
2013-07-16	ATMP	ETF	27.07	27.32	26.55	26.57	10300.0
2013-07-16	AVIV	ETF	26.02	26.195	25.76	25.83	117312.0
2013-07-16	AWAY	ETF	31.86	32.5	31.5501	31.81	1165853.0
2013-07-16	BAB	ETF	28.01	28.1125	27.98	28.04	122541.0
2013-07-16	BAL	ETF	54.62	54.62	53.76	54.03	13508.0
2013-07-16	BALT	ETF	3.77	3.7702	3.66	3.75	49344.0
2013-07-16	BBH	ETF	77.26	77.38	75.94	76.42	77800.0
2013-07-16	BCM	ETF	40.06	40.078	40.0	40.078	3186.0
2013-07-16	BFOR	ETF	6.62	6.62	6.4875	6.505	228800.0
2013-07-16	BIB	ETF	28.21	28.21	27.1625	27.3627	156268.0
2013-07-16	BICK	ETF	21.54	21.55	21.411	21.55	8921.0
2013-07-16	BIL	ETF	91.6	91.6	91.58	91.58	146050.0
2013-07-16	BIS	ETF	1231.6	1265.96	1231.6	1262.0	116.0
2013-07-16	BIV	ETF	83.64	83.66	83.5	83.58	649700.0
2013-07-16	BIZD	ETF	20.4	20.4	20.28	20.36	3700.0
2013-07-16	BJK	ETF	41.59	41.63	41.38	41.59	3100.0
2013-07-16	BKF	ETF	35.0	35.0	34.69	34.91	106270.0
2013-07-16	BKLN	ETF	24.83	24.86	24.81	24.83	1390700.0
2013-07-16	BLNG	ETF	36.48	36.48	36.48	36.48	300.0

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

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