PREVIEW / etf_daily / 2012-06-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-13.parquet
  size:    38 KB
  rows:    928

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
2012-06-13	SPY	ETF	132.53	133.36	131.62	132.07	172223900.0
2012-06-13	QQQ	ETF	62.38	62.85	61.92	62.13	50841084.0
2012-06-13	IWM	ETF	76.09	76.54	75.0	75.34	62715800.0
2012-06-13	DIA	ETF	125.34	125.94	124.48	124.89	4687100.0
2012-06-13	GLD	ETF	157.61	157.65	156.42	157.12	10109800.0
2012-06-13	TLT	ETF	124.85	126.28	124.38	125.86	11100000.0
2012-06-13	AAXJ	ETF	51.65	51.89	51.34	51.37	332600.0
2012-06-13	ACTV	ETF	14.86	15.34	14.82	15.23	656985.0
2012-06-13	ACWI	ETF	42.75	43.09	42.57	42.66	194700.0
2012-06-13	ACWV	ETF	53.61	53.69	53.58	53.58	400.0
2012-06-13	ACWX	ETF	36.18	36.394	36.002	36.09	132359.0
2012-06-13	ADRE	ETF	36.72	37.0482	36.63	36.71	16754.0
2012-06-13	AFK	ETF	27.21	27.41	27.13	27.33	31815.0
2012-06-13	AGEM	ETF	20.36	20.36	20.36	20.36	800.0
2012-06-13	AGG	ETF	110.99	111.22	110.85	111.2	2650900.0
2012-06-13	AGQ	ETF	171.4	172.28	168.76	169.24	209650.0
2012-06-13	AGZ	ETF	113.28	113.48	113.26	113.48	16366.0
2012-06-13	AIA	ETF	40.74	40.94	40.59	40.59	19048.0
2012-06-13	AIQ	ETF	4.8705	4.9495	4.6	4.826	7125.0
2012-06-13	AIS	ETF	3.22	3.29	3.18	3.19	750674.0
2012-06-13	AIVI	ETF	37.06	37.35	36.99	37.03	44800.0
2012-06-13	AMJ	ETF	36.3	36.66	36.26	36.39	765656.0
2012-06-13	AMLP	ETF	78.35	78.65	78.05	78.25	232980.0
2012-06-13	ANGL	ETF	25.04	25.15	24.91	25.15	7700.0
2012-06-13	AOA	ETF	34.16	34.32	34.07	34.07	4100.0
2012-06-13	AOK	ETF	29.58	29.662	29.56	29.6	25394.0
2012-06-13	AOM	ETF	30.3999	30.4783	30.31	30.37	13987.0
2012-06-13	AOR	ETF	31.99	32.0447	31.96	31.99	3767.0
2012-06-13	ARB	ETF	33.62	34.07	33.37	33.58	113945.0
2012-06-13	ARGT	ETF	15.5	15.5	15.5	15.5	500.0
2012-06-13	ASEA	ETF	15.0	15.13	14.98	15.1	10300.0
2012-06-13	AWAY	ETF	20.41	21.08	19.62	19.85	661627.0
2012-06-13	BAB	ETF	29.88	30.05	29.82	30.01	169131.0
2012-06-13	BAL	ETF	46.1	46.97	45.97	46.73	15290.0
2012-06-13	BALT	ETF	3.24	3.24	3.16	3.19	115062.0
2012-06-13	BBH	ETF	45.05	45.05	44.5	44.5	7200.0
2012-06-13	BCM	ETF	40.28	40.4682	40.279	40.4149	3112.0
2012-06-13	BIB	ETF	11.8725	11.8866	11.7898	11.8866	7160.0
2012-06-13	BICK	ETF	22.29	22.51	22.2301	22.3101	3657.0
2012-06-13	BIL	ETF	91.64	91.66	91.64	91.66	59550.0
2012-06-13	BIS	ETF	3564.8	3651.2	3537.6	3651.2	24.7
2012-06-13	BIV	ETF	88.34	88.52	88.32	88.42	342600.0
2012-06-13	BJK	ETF	31.79	31.81	31.46	31.46	3500.0
2012-06-13	BKF	ETF	35.37	35.75	35.28	35.4	76716.0
2012-06-13	BKLN	ETF	24.24	24.27	24.14	24.23	181700.0
2012-06-13	BLV	ETF	94.12	94.87	93.97	94.73	61400.0
2012-06-13	BMVP	ETF	14.54	14.6767	14.5033	14.5034	3697.0
2012-06-13	BND	ETF	84.15	84.3	84.07	84.28	1212900.0
2012-06-13	BNO	ETF	34.275	34.77	34.17	34.185	167000.0
2012-06-13	BOIL	ETF	620000.0	630000.0	605000.0	611600.0	8.8

> showing 50 of 928 rows — these rows as CSV

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