PREVIEW / etf_daily / 2013-07-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-30.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-30	SPY	ETF	169.1	169.28	168.19	168.59	85209600.0
2013-07-30	QQQ	ETF	75.5	75.95	75.35	75.63	24104507.0
2013-07-30	IWM	ETF	103.69	103.87	103.11	103.48	26311000.0
2013-07-30	DIA	ETF	155.4	155.58	154.42	154.91	4211000.0
2013-07-30	GLD	ETF	127.95	128.31	127.22	128.12	4487700.0
2013-07-30	TLT	ETF	107.71	107.76	107.05	107.31	3635400.0
2013-07-30	AADR	ETF	33.7	33.89	33.7	33.89	1600.0
2013-07-30	AAXJ	ETF	56.57	56.58	56.16	56.24	226200.0
2013-07-30	ACTV	ETF	8.67	8.82	8.6	8.7	328588.0
2013-07-30	ACWI	ETF	52.46	52.58	52.16	52.28	511900.0
2013-07-30	ACWV	ETF	62.04	62.09	61.65	61.77	27400.0
2013-07-30	ACWX	ETF	42.75	42.84	42.46	42.53	285156.0
2013-07-30	ADRE	ETF	35.64	35.64	35.25	35.32	22182.0
2013-07-30	AFK	ETF	28.95	29.0	28.7	28.93	51682.0
2013-07-30	AGEM	ETF	21.2001	21.2001	21.2001	21.2001	200.0
2013-07-30	AGG	ETF	107.26	107.34	107.1	107.22	662400.0
2013-07-30	AGQ	ETF	68.56	69.0	68.2	68.4	166225.0
2013-07-30	AGZ	ETF	111.28	111.32	111.0001	111.31	160523.0
2013-07-30	AIA	ETF	44.41	44.588	44.1896	44.27	10637.0
2013-07-30	AIQ	ETF	19.11	19.34	18.9	18.98	29819.0
2013-07-30	AIVI	ETF	42.54	42.58	42.3	42.4	44000.0
2013-07-30	ALTL	ETF	29.7147	29.7147	29.7147	29.7147	150.0
2013-07-30	AMJ	ETF	46.64	46.7	46.23	46.4	398368.0
2013-07-30	AMLP	ETF	89.6	90.15	88.8	89.2	490080.0
2013-07-30	ANGL	ETF	27.17	27.17	26.91	26.91	1500.0
2013-07-30	AOA	ETF	41.33	41.33	41.15	41.25	17700.0
2013-07-30	AOK	ETF	31.22	31.22	31.1101	31.16	24991.0
2013-07-30	AOM	ETF	33.02	33.02	32.9	32.97	25291.0
2013-07-30	AOR	ETF	36.38	36.439	36.271	36.37	70084.0
2013-07-30	ARB	ETF	45.81	45.87	45.69	45.82	179046.0
2013-07-30	ARGT	ETF	17.45	17.45	17.45	17.45	3000.0
2013-07-30	ASEA	ETF	17.03	17.04	16.92	16.92	32800.0
2013-07-30	ATMP	ETF	26.7	26.7	26.32	26.41	14000.0
2013-07-30	AVIV	ETF	25.17	25.46	25.14	25.2	70043.0
2013-07-30	AWAY	ETF	30.03	30.62	29.65	30.55	1233630.0
2013-07-30	BAB	ETF	27.81	27.85	27.73	27.77	206934.0
2013-07-30	BAL	ETF	54.52	55.22	54.39	54.54	5200.0
2013-07-30	BALT	ETF	3.98	4.0	3.78	3.81	187820.0
2013-07-30	BBH	ETF	78.22	79.22	78.01	79.09	76600.0
2013-07-30	BFOR	ETF	6.555	6.5675	6.5375	6.5625	47600.0
2013-07-30	BIB	ETF	28.55	29.1475	28.55	29.125	81016.0
2013-07-30	BICK	ETF	21.79	21.82	21.76	21.82	1325.0
2013-07-30	BIL	ETF	91.58	91.6	91.58	91.58	172400.0
2013-07-30	BIS	ETF	1189.2	1207.2	1168.0	1179.6	74.0
2013-07-30	BIV	ETF	83.69	83.75	83.53	83.58	311200.0
2013-07-30	BIZD	ETF	20.47	20.47	20.35	20.39	9000.0
2013-07-30	BJK	ETF	41.9	42.0	41.8	41.89	9100.0
2013-07-30	BKF	ETF	35.08	35.16	34.72	34.76	35093.0
2013-07-30	BKLN	ETF	24.94	24.95	24.92	24.95	2921000.0
2013-07-30	BLV	ETF	84.48	84.56	84.1	84.17	78200.0

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

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