PREVIEW / etf_daily / 2013-07-26

all etf daily files

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

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-26	SPY	ETF	168.22	169.16	167.52	169.11	107814600.0
2013-07-26	QQQ	ETF	74.67	75.38	74.55	75.37	20885522.0
2013-07-26	IWM	ETF	103.96	104.17	103.36	104.12	23036800.0
2013-07-26	DIA	ETF	154.48	155.25	153.67	155.16	3859300.0
2013-07-26	GLD	ETF	128.11	128.97	126.78	128.78	6148500.0
2013-07-26	TLT	ETF	108.04	108.28	107.64	108.14	6795500.0
2013-07-26	AADR	ETF	33.83	33.88	33.79	33.88	400.0
2013-07-26	AAXJ	ETF	56.65	57.04	56.4	57.01	92400.0
2013-07-26	ACTV	ETF	8.67	8.8	8.6	8.78	467798.0
2013-07-26	ACWI	ETF	52.47	52.66	52.21	52.66	1174700.0
2013-07-26	ACWV	ETF	61.82	62.05	61.6	62.05	13300.0
2013-07-26	ACWX	ETF	42.94	43.06	42.69	43.06	660413.0
2013-07-26	ADRE	ETF	35.83	35.85	35.48	35.83	201192.0
2013-07-26	AFK	ETF	29.06	29.072	28.7601	29.072	18981.0
2013-07-26	AGEM	ETF	21.3934	21.5155	21.3934	21.5155	731.0
2013-07-26	AGG	ETF	107.35	107.37	107.22	107.26	771600.0
2013-07-26	AGQ	ETF	70.44	71.2	68.08	70.64	469800.0
2013-07-26	AGZ	ETF	111.29	111.35	111.111	111.182	9087.0
2013-07-26	AIA	ETF	44.28	44.48	44.11	44.48	34916.0
2013-07-26	AIQ	ETF	18.96	19.035	18.87	18.98	51120.0
2013-07-26	AIVI	ETF	42.64	42.81	42.49	42.81	22700.0
2013-07-26	AMJ	ETF	47.04	47.3599	46.797	46.94	557077.0
2013-07-26	AMLP	ETF	89.65	90.15	89.35	89.9	426500.0
2013-07-26	AOA	ETF	41.28	41.4	41.13	41.4	10500.0
2013-07-26	AOK	ETF	31.19	31.22	31.118	31.22	12929.0
2013-07-26	AOM	ETF	32.99	33.03	32.9	33.02	5819.0
2013-07-26	AOR	ETF	36.409	36.49	36.28	36.49	16478.0
2013-07-26	ARB	ETF	45.87	45.93	45.66	45.72	585057.0
2013-07-26	ARGT	ETF	17.47	17.51	17.46	17.51	1700.0
2013-07-26	ASEA	ETF	17.26	17.26	17.14	17.18	5300.0
2013-07-26	ATMP	ETF	26.72	26.78	26.62	26.72	16800.0
2013-07-26	AVIV	ETF	25.84	25.84	25.25	25.39	54122.0
2013-07-26	AWAY	ETF	31.53	32.5	30.5	31.72	3402193.0
2013-07-26	BAB	ETF	27.67	27.84	27.67	27.74	167140.0
2013-07-26	BAL	ETF	54.92	54.97	54.42	54.62	7300.0
2013-07-26	BALT	ETF	3.91	4.05	3.91	4.02	119953.0
2013-07-26	BBH	ETF	78.38	78.74	77.7	78.72	55000.0
2013-07-26	BCM	ETF	39.6499	39.75	39.6499	39.75	3968.0
2013-07-26	BFOR	ETF	6.5475	6.555	6.515	6.555	174400.0
2013-07-26	BIB	ETF	28.645	28.9375	28.1352	28.9375	78220.0
2013-07-26	BICK	ETF	22.08	22.13	21.969	22.13	1882.0
2013-07-26	BIL	ETF	91.62	91.62	91.58	91.58	378550.0
2013-07-26	BIS	ETF	1210.0	1219.56	1182.0	1188.872	65.5
2013-07-26	BIV	ETF	83.75	83.81	83.67	83.7	464100.0
2013-07-26	BIZD	ETF	20.42	20.5	20.42	20.5	3800.0
2013-07-26	BJK	ETF	41.55	41.9	41.55	41.9	2400.0
2013-07-26	BKF	ETF	35.41	35.62	35.07	35.59	274530.0
2013-07-26	BKLN	ETF	24.93	24.96	24.91	24.94	4078300.0
2013-07-26	BLV	ETF	84.35	84.73	84.22	84.68	63000.0
2013-07-26	BMVP	ETF	19.773	19.867	19.72	19.866	990.0

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

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