PREVIEW / etf_daily / 2012-08-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-08.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-08	SPY	ETF	139.85	140.65	139.81	140.49	89754700.0
2012-08-08	QQQ	ETF	66.48	66.762	66.37	66.62	20723495.0
2012-08-08	IWM	ETF	79.6	80.19	79.54	79.82	28011700.0
2012-08-08	DIA	ETF	130.94	131.84	130.89	131.55	3003900.0
2012-08-08	GLD	ETF	156.49	156.86	156.26	156.48	3620500.0
2012-08-08	TLT	ETF	126.16	126.39	125.04	125.16	7250700.0
2012-08-08	AAXJ	ETF	53.96	54.3	53.87	54.06	353700.0
2012-08-08	ACTV	ETF	11.25	11.53	11.25	11.49	393160.0
2012-08-08	ACWI	ETF	45.23	45.58	45.23	45.43	322700.0
2012-08-08	ACWV	ETF	55.8	55.8	55.6	55.74	10300.0
2012-08-08	ACWX	ETF	38.25	38.55	38.21	38.46	109994.0
2012-08-08	ADRE	ETF	38.59	39.06	38.59	38.97	27883.0
2012-08-08	AFK	ETF	29.03	29.06	28.9001	28.98	5430.0
2012-08-08	AGEM	ETF	21.85	22.06	21.85	22.05	20237.0
2012-08-08	AGG	ETF	111.94	111.94	111.7	111.72	550400.0
2012-08-08	AGQ	ETF	156.8	159.4	156.32	156.96	174650.0
2012-08-08	AGZ	ETF	113.5	113.69	113.41	113.4101	47838.0
2012-08-08	AIA	ETF	43.17	43.306	43.16	43.17	8662.0
2012-08-08	AIQ	ETF	6.0	6.0	5.25	5.4	14585.0
2012-08-08	AIVI	ETF	39.06	39.45	39.06	39.4	15400.0
2012-08-08	AMJ	ETF	39.57	39.6	39.29	39.29	872258.0
2012-08-08	AMLP	ETF	81.25	81.3	80.85	80.95	411360.0
2012-08-08	ANGL	ETF	26.18	26.18	26.09	26.09	1000.0
2012-08-08	AOA	ETF	35.76	35.9	35.76	35.88	14800.0
2012-08-08	AOK	ETF	30.21	30.21	30.17	30.2	5545.0
2012-08-08	AOM	ETF	31.0791	31.21	31.0791	31.162	18883.0
2012-08-08	AOR	ETF	33.12	33.18	33.1	33.15	41289.0
2012-08-08	ARB	ETF	35.83	36.22	35.75	35.84	56868.0
2012-08-08	ARGT	ETF	17.42	17.52	17.42	17.52	450.0
2012-08-08	ASEA	ETF	16.37	16.45	16.36	16.39	1800.0
2012-08-08	AWAY	ETF	23.98	24.6899	23.72	24.07	90525.0
2012-08-08	BAB	ETF	30.23	30.23	30.09	30.12	166817.0
2012-08-08	BAL	ETF	49.87	50.3599	49.8	50.2	20691.0
2012-08-08	BALT	ETF	3.32	3.41	3.3	3.31	105536.0
2012-08-08	BBH	ETF	49.91	49.91	49.59	49.75	29800.0
2012-08-08	BCM	ETF	44.34	44.359	44.279	44.359	747.0
2012-08-08	BIB	ETF	13.9012	13.9012	13.625	13.625	28464.0
2012-08-08	BICK	ETF	23.13	23.38	23.13	23.3728	6381.0
2012-08-08	BIL	ETF	91.64	91.64	91.62	91.62	205650.0
2012-08-08	BIS	ETF	2976.0	2976.016	2960.0	2976.016	15.6
2012-08-08	BIV	ETF	89.43	89.46	89.2	89.23	156800.0
2012-08-08	BJK	ETF	31.13	31.23	31.08	31.15	4400.0
2012-08-08	BKF	ETF	36.89	37.26	36.86	37.09	56868.0
2012-08-08	BKLN	ETF	24.71	24.73	24.7	24.73	271900.0
2012-08-08	BLV	ETF	96.8	96.87	96.05	96.15	72100.0
2012-08-08	BMVP	ETF	15.84	15.91	15.8	15.87	14506.0
2012-08-08	BND	ETF	84.69	84.74	84.6	84.63	948500.0
2012-08-08	BNO	ETF	39.89	40.14	39.64	39.735	99000.0
2012-08-08	BOIL	ETF	949200.0	970000.0	931200.0	956600.0	5.6
2012-08-08	BOND	ETF	106.81	107.04	106.78	106.89	413344.0

> showing 50 of 935 rows — these rows as CSV

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