PREVIEW / etf_daily / 2012-08-31

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-31.parquet
  size:    38 KB
  rows:    935

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-08-31	SPY	ETF	141.29	141.82	140.36	141.16	151970400.0
2012-08-31	QQQ	ETF	68.2	68.45	67.47	68.16	42127927.0
2012-08-31	IWM	ETF	81.48	81.53	80.34	81.12	34088500.0
2012-08-31	DIA	ETF	130.64	131.4	130.04	130.88	5447700.0
2012-08-31	GLD	ETF	161.14	164.22	159.56	164.22	18024200.0
2012-08-31	TLT	ETF	125.78	127.72	125.73	127.72	9192600.0
2012-08-31	AAXJ	ETF	53.1	53.33	52.76	53.1	295200.0
2012-08-31	ACTV	ETF	10.91	11.32	10.78	11.26	1355675.0
2012-08-31	ACWI	ETF	45.65	45.69	45.2	45.46	624600.0
2012-08-31	ACWV	ETF	55.93	56.03	55.79	55.97	14400.0
2012-08-31	ACWX	ETF	38.18	38.28	37.82	38.06	192690.0
2012-08-31	ADRE	ETF	37.61	37.86	37.44	37.69	13364.0
2012-08-31	AFK	ETF	29.54	29.66	29.26	29.66	3546.0
2012-08-31	AGEM	ETF	21.3	21.35	21.3	21.34	1122.0
2012-08-31	AGG	ETF	112.1	112.43	112.07	112.37	1203400.0
2012-08-31	AGQ	ETF	187.32	200.24	181.6	200.16	884275.0
2012-08-31	AGZ	ETF	113.79	113.99	113.77	113.95	33662.0
2012-08-31	AIA	ETF	42.01	42.174	41.8	42.09	6855.0
2012-08-31	AIQ	ETF	6.675	6.9	6.675	6.8	4255.0
2012-08-31	AIVI	ETF	39.73	39.8	39.45	39.61	18900.0
2012-08-31	AMJ	ETF	39.65	39.73	39.36	39.64	614599.0
2012-08-31	AMLP	ETF	81.55	81.85	81.4	81.7	236040.0
2012-08-31	ANGL	ETF	26.35	26.65	26.35	26.65	2800.0
2012-08-31	AOA	ETF	36.03	36.09	35.89	36.05	6700.0
2012-08-31	AOK	ETF	30.29	30.29	30.2336	30.29	28239.0
2012-08-31	AOM	ETF	31.23	31.34	31.21	31.31	54787.0
2012-08-31	AOR	ETF	33.25	33.29	33.22	33.254	3521.0
2012-08-31	ARB	ETF	35.96	35.96	34.79	35.17	144274.0
2012-08-31	ASEA	ETF	16.2	16.28	16.13	16.16	14600.0
2012-08-31	AWAY	ETF	23.64	23.9	23.3	23.66	279218.0
2012-08-31	BAB	ETF	30.27	30.48	30.27	30.4265	223943.0
2012-08-31	BAL	ETF	50.71	51.08	50.71	51.0	12274.0
2012-08-31	BALT	ETF	3.18	3.19	3.06	3.08	55705.0
2012-08-31	BBH	ETF	50.81	50.95	50.6	50.95	12200.0
2012-08-31	BCM	ETF	46.06	46.06	46.06	46.06	200.0
2012-08-31	BIB	ETF	14.3275	14.4038	14.0237	14.2963	88408.0
2012-08-31	BICK	ETF	22.15	22.29	22.1196	22.2683	2097.0
2012-08-31	BIL	ETF	91.62	91.64	91.62	91.62	183450.0
2012-08-31	BIS	ETF	2824.0	2870.16	2824.0	2832.0	18.1
2012-08-31	BIV	ETF	89.75	90.09	89.63	90.04	198600.0
2012-08-31	BJK	ETF	32.15	32.32	32.11	32.26	24900.0
2012-08-31	BKF	ETF	35.64	35.82	35.42	35.66	137245.0
2012-08-31	BKLN	ETF	24.81	24.82	24.77	24.77	413900.0
2012-08-31	BLV	ETF	96.79	97.8	96.61	97.72	34200.0
2012-08-31	BMVP	ETF	15.933	15.997	15.932	15.997	2947.0
2012-08-31	BND	ETF	84.93	85.18	84.89	85.18	1176500.0
2012-08-31	BNO	ETF	40.965	41.345	40.71	41.27	25200.0
2012-08-31	BOIL	ETF	795400.0	830000.0	794400.0	822200.0	9.4
2012-08-31	BOND	ETF	107.41	107.72	107.36	107.68	471068.0
2012-08-31	BRF	ETF	39.01	39.43	38.85	39.2	155727.0

> showing 50 of 935 rows — these rows as CSV

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