PREVIEW / etf_daily / 2013-07-31

all etf daily files

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

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-31	SPY	ETF	168.94	169.85	168.49	168.71	142388700.0
2013-07-31	QQQ	ETF	75.77	76.2099	75.63	75.77	25007599.0
2013-07-31	IWM	ETF	103.89	104.68	103.61	103.66	38330400.0
2013-07-31	DIA	ETF	155.12	156.03	154.56	154.84	11784600.0
2013-07-31	GLD	ETF	127.76	128.92	126.13	127.96	16015300.0
2013-07-31	TLT	ETF	106.06	107.92	105.85	107.7	10483100.0
2013-07-31	AAXJ	ETF	56.07	56.45	55.67	55.89	441200.0
2013-07-31	ACTV	ETF	8.7	8.77	8.5	8.53	596715.0
2013-07-31	ACWI	ETF	52.34	52.67	52.18	52.29	1044300.0
2013-07-31	ACWV	ETF	61.86	62.03	61.59	61.7	37000.0
2013-07-31	ACWX	ETF	42.51	42.86	42.42	42.56	595545.0
2013-07-31	ADRE	ETF	35.3	35.5345	35.11	35.4	30136.0
2013-07-31	AFK	ETF	29.0	29.17	28.6901	29.0771	49687.0
2013-07-31	AGEM	ETF	21.1955	21.3779	21.1955	21.3779	674.0
2013-07-31	AGG	ETF	106.81	107.32	106.77	107.3	1361900.0
2013-07-31	AGQ	ETF	68.2	71.2	66.12	69.08	626150.0
2013-07-31	AGZ	ETF	110.77	111.309	110.77	111.23	36930.0
2013-07-31	AIA	ETF	43.97	44.38	43.946	44.01	52240.0
2013-07-31	AIQ	ETF	18.93	19.76	18.93	19.69	109962.0
2013-07-31	AIVI	ETF	42.36	42.69	42.15	42.36	61400.0
2013-07-31	AMJ	ETF	46.5	46.8199	46.2	46.26	353938.0
2013-07-31	AMLP	ETF	89.45	89.75	89.0	89.15	556240.0
2013-07-31	ANGL	ETF	27.2	27.21	26.99	26.99	300.0
2013-07-31	AOA	ETF	41.35	41.51	41.23	41.31	26200.0
2013-07-31	AOK	ETF	31.27	31.27	31.08	31.2	19219.0
2013-07-31	AOM	ETF	33.0	33.074	32.9	33.01	99276.0
2013-07-31	AOR	ETF	36.369	36.4923	36.3313	36.43	20851.0
2013-07-31	ARB	ETF	45.88	46.11	45.82	45.96	153423.0
2013-07-31	ARGT	ETF	17.48	17.5	17.48	17.48	1500.0
2013-07-31	ASEA	ETF	16.88	16.94	16.82	16.93	6800.0
2013-07-31	ATMP	ETF	26.53	26.62	26.51	26.54	20700.0
2013-07-31	AVIV	ETF	25.19	25.19	24.75	24.9	228461.0
2013-07-31	AWAY	ETF	30.6	30.605	29.66	30.11	974706.0
2013-07-31	BAB	ETF	27.64	27.83	27.56	27.77	240668.0
2013-07-31	BAL	ETF	54.32	54.74	54.32	54.74	8121.0
2013-07-31	BALT	ETF	3.78	3.85	3.76	3.76	82637.0
2013-07-31	BBH	ETF	79.19	79.55	78.95	79.09	57800.0
2013-07-31	BCM	ETF	39.28	39.69	39.26	39.69	5875.0
2013-07-31	BFOR	ETF	6.5725	6.6375	6.5725	6.605	182400.0
2013-07-31	BIB	ETF	29.4525	29.85	29.25	29.4725	163144.0
2013-07-31	BICK	ETF	21.73	21.89	21.65	21.74	4751.0
2013-07-31	BIL	ETF	91.6	91.6	91.58	91.6	238800.0
2013-07-31	BIS	ETF	1174.8	1174.8	1148.8	1149.04	101.0
2013-07-31	BIV	ETF	83.2	83.73	83.12	83.66	475300.0
2013-07-31	BIZD	ETF	20.34	20.42	20.32	20.42	3700.0
2013-07-31	BJK	ETF	42.02	42.19	41.88	41.94	4800.0
2013-07-31	BKF	ETF	34.73	34.9391	34.45	34.61	81117.0
2013-07-31	BKLN	ETF	24.94	24.96	24.92	24.95	3791900.0
2013-07-31	BLV	ETF	83.36	84.54	83.32	84.31	62700.0
2013-07-31	BMVP	ETF	19.96	19.96	19.957	19.957	2620.0

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

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