currency

curr_id	description
USD	United States Dollar

(1 row)

bank

bank_id	description
YB	Your Bank

(1 row)

summary_fund_cv

Fund ID	Bank ID	curr_id	abbrev	name	wht	s_adj	derived	date	Total Number of Shares	Total Cost Basis	Average Cost Basis per Share	Total Market Value
1	YB	USD	ETF	Exchange Traded Fund	0.00	f		2001-03-01	150	2642.51	17.6167	3300.00

(1 row)

share_purchase_cjv

curr_id	abbrev	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share (fees?)
USD	ETF	1	1999-02-01	20	100	0.25
USD	ETF	1	2000-06-01	16	200	0.15

(2 rows)

share_redemption_cjv

curr_id	abbrev	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share (fees?)
USD	ETF	1	2001-03-01	22	150	0.2

(1 row)

fund_income_cjv

curr_id	abbrev	Fund ID	Revenue Type	Distributed by Fund Manager?	Record Date	Income per Share	Pay Date

(0 rows)

reinvested_fund_income_cjv

curr_id	abbrev	Fund ID	date	price_ps	Number of Shares	Basis Adj. per Share (fees?)	Revenue Type	Distributed by Fund Manager?	Record Date	Income per Share	Pay Date

(0 rows)

summary_cjv

curr_id	abbrev	row_id	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share	action	Sale Date	Other Basis Adj. per Share	Simple Cost Basis per Share	price	Simple Cost Basis	Total Number of Shares	Sale Price	Capital Gain, FIFO Method	Total Cost Basis	Average Cost Basis per Share	Average Basis of These Shares	Capital Gain, ACB Method	Long Term / Short Term
USD	ETF	1771381	1	1999-02-01	20	100	0.25	BUY	2001-03-01	0	20.45	2000.00	2045.00	100	2200.00	155.00	2045.00	20.4500	1761.67	438.33	LTCG
USD	ETF	1771382	1	2000-06-01	16	50	0.15	BUY	2001-03-01	0	16.35	800.00	817.50	150	1100.00	282.50	2862.50	19.0833	880.84	219.16	STCG
USD	ETF	1771383	1	2000-06-01	16	150	0.15	BUY		0	16.15	2400.00	2422.50	300			5285.00	17.6167
USD	ETF	1771384	1	2001-03-01	22	150	0.2	SELL						150	3300.00		2642.51	17.6167	2642.51	657.49

(4 rows)

summary_cg_fifo_cjv

curr_id	abbrev	Fund ID	date	Number of Shares	Sale Date	Sale Price	Simple Cost Basis	Capital Gain, FIFO Method	Long Term / Short Term
USD	ETF	1	1999-02-01	100	2001-03-01	2200.00	2045.00	155.00	LTCG
USD	ETF	1	2000-06-01	50	2001-03-01	1100.00	817.50	282.50	STCG

(2 rows)

summary_cg_acb_cjv

curr_id	abbrev	Fund ID	date	Number of Shares	Sale Date	Sale Price	Average Basis of These Shares	Capital Gain, ACB Method	Long Term / Short Term
USD	ETF	1	1999-02-01	100	2001-03-01	2200.00	1761.67	438.33	LTCG
USD	ETF	1	2000-06-01	50	2001-03-01	1100.00	880.84	219.16	STCG

(2 rows)
DROP CREATE

summary_fund_income_pcjv

curr_id	year	abbrev	sum(Net Income)

(0 rows)
DROP CREATE

summary_cg_fifo_pcjv

curr_id	year	abbrev	Sale Date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Simple Cost Basis)	sum(Capital Gain, FIFO Method)
USD	2001	ETF	2001-03-01	LTCG	100	2200.00	2045.00	155.00
USD	2001	ETF	2001-03-01	STCG	50	1100.00	817.50	282.50
USD	2001	ETF			150	3300.00	2862.50	437.50
USD	2001				150	3300.00	2862.50	437.50
USD					150	3300.00	2862.50	437.50

(5 rows)
DROP CREATE

summary_cg_acb_pcjv

curr_id	year	abbrev	Sale Date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Average Basis of These Shar	sum(Capital Gain, ACB Method)
USD	2001	ETF	2001-03-01	LTCG	100	2200.00	1761.67	438.33
USD	2001	ETF	2001-03-01	STCG	50	1100.00	880.84	219.16
USD	2001	ETF			150	3300.00	2642.51	657.49
USD	2001				150	3300.00	2642.51	657.49
USD					150	3300.00	2642.51	657.49

(5 rows)
DROP CREATE

detailed_summary_cg_acb_pcjv

curr_id	year	abbrev	Sale Date	date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Average Basis of These Shar	sum(Capital Gain, ACB Method)
USD	2001	ETF	2001-03-01	1999-02-01	LTCG	100	2200.00	1761.67	438.33
USD	2001	ETF	2001-03-01	2000-06-01	STCG	50	1100.00	880.84	219.16
USD	2001	ETF	2001-03-01			150	3300.00	2642.51	657.49
USD	2001	ETF				150	3300.00	2642.51	657.49
USD	2001					150	3300.00	2642.51	657.49
USD						150	3300.00	2642.51	657.49

(6 rows)