PREVIEW / etf_daily / 2013-07-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-12.parquet
  size:    41 KB
  rows:    999

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-12	SPY	ETF	167.39	167.93	167.13	167.51	104212700.0
2013-07-12	QQQ	ETF	75.02	75.35	74.82	75.3	31417850.0
2013-07-12	IWM	ETF	102.48	103.11	102.47	102.68	28584000.0
2013-07-12	DIA	ETF	154.42	154.76	153.89	154.17	6349800.0
2013-07-12	GLD	ETF	123.52	124.3	123.32	124.13	6583800.0
2013-07-12	TLT	ETF	108.34	108.47	107.34	107.72	4730800.0
2013-07-12	AADR	ETF	34.19	34.68	33.47	33.84	1200.0
2013-07-12	AAXJ	ETF	56.12	56.12	55.76	55.94	370500.0
2013-07-12	ACTV	ETF	8.6	8.779	8.6	8.61	149666.0
2013-07-12	ACWI	ETF	52.0	52.13	51.92	52.04	817600.0
2013-07-12	ACWV	ETF	61.82	61.91	61.57	61.85	45600.0
2013-07-12	ACWX	ETF	42.34	42.4	42.22	42.31	328003.0
2013-07-12	ADRE	ETF	34.72	34.77	34.5	34.62	38200.0
2013-07-12	AFK	ETF	28.3	28.4119	28.211	28.4119	24019.0
2013-07-12	AGG	ETF	107.14	107.14	106.68	106.81	616300.0
2013-07-12	AGQ	ETF	69.68	70.32	69.2	69.96	309675.0
2013-07-12	AGZ	ETF	110.9	111.116	110.83	110.8501	19545.0
2013-07-12	AIA	ETF	43.68	43.68	43.451	43.59	16663.0
2013-07-12	AIQ	ETF	16.53	16.78	16.53	16.69	44546.0
2013-07-12	AIVI	ETF	41.43	41.43	41.27	41.42	20500.0
2013-07-12	ALTL	ETF	29.579	29.579	29.562	29.562	965.0
2013-07-12	AMJ	ETF	48.37	48.55	47.93	48.23	777719.0
2013-07-12	AMLP	ETF	90.85	90.95	90.4	90.75	419420.0
2013-07-12	ANGL	ETF	26.75	26.75	26.61	26.61	400.0
2013-07-12	AOA	ETF	41.0	41.05	40.93	41.04	36000.0
2013-07-12	AOK	ETF	31.09	31.09	31.0136	31.02	19351.0
2013-07-12	AOM	ETF	32.86	32.86	32.7701	32.82	54354.0
2013-07-12	AOR	ETF	36.21	36.23	36.13	36.22	35755.0
2013-07-12	ARB	ETF	46.33	46.4	46.32	46.38	75420.0
2013-07-12	ARGT	ETF	16.61	16.61	16.61	16.61	600.0
2013-07-12	ASEA	ETF	17.16	17.2	17.11	17.16	4000.0
2013-07-12	ATMP	ETF	26.98	26.98	26.74	26.76	20100.0
2013-07-12	AVIV	ETF	25.77	26.243	25.77	25.92	111878.0
2013-07-12	AWAY	ETF	31.44	31.589	31.02	31.13	1312174.0
2013-07-12	BAB	ETF	28.01	28.12	27.96	28.08	385829.0
2013-07-12	BAL	ETF	54.18	54.59	54.06	54.58	12715.0
2013-07-12	BALT	ETF	3.7222	3.78	3.7	3.72	327152.0
2013-07-12	BBH	ETF	75.63	77.94	75.48	77.54	198600.0
2013-07-12	BCM	ETF	39.873	39.873	39.873	39.873	330.0
2013-07-12	BFOR	ETF	6.51	6.5325	6.5075	6.5325	172400.0
2013-07-12	BIB	ETF	26.8375	28.245	26.7282	27.98	267696.0
2013-07-12	BICK	ETF	21.22	21.35	21.22	21.27	4194.0
2013-07-12	BIL	ETF	91.58	91.6	91.58	91.58	254550.0
2013-07-12	BIS	ETF	1284.8	1290.72	1220.8	1230.0	536.0
2013-07-12	BIV	ETF	83.54	83.63	83.2	83.26	628300.0
2013-07-12	BIZD	ETF	20.35	20.35	20.17	20.21	13400.0
2013-07-12	BJK	ETF	41.26	41.37	41.21	41.23	4600.0
2013-07-12	BKF	ETF	34.4	34.46	34.2441	34.37	109127.0
2013-07-12	BKLN	ETF	24.92	24.92	24.85	24.92	3962100.0
2013-07-12	BLV	ETF	84.51	84.64	83.97	84.3	78100.0

> showing 50 of 999 rows — these rows as CSV

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