Matt, I think I cracked the query to give a counterparty based position of the SoCal product you requested. Can you (or Mike) varify the following numbers (COB 04/27/2001) ? I was unable at this point to net the volumes in one sweep .....

-Colin

Product: US Gas Phy       EPNG SoCal Topk         28-30Apr01      USD/MM

Reliant Energy Services, Inc.	B	2-Apr-01	30000	3	
Reliant Energy Services, Inc.	S	2-Apr-01	20000	2	
Reliant Energy Services, Inc.	B	3-Apr-01	90000	9	
Reliant Energy Services, Inc.	S	3-Apr-01	80000	8	
Reliant Energy Services, Inc.	S	4-Apr-01	30000	3	
Reliant Energy Services, Inc.	B	6-Apr-01	10000	1	
Reliant Energy Services, Inc.	S	9-Apr-01	130000	13	
Reliant Energy Services, Inc.	S	10-Apr-01	10000	1	
Reliant Energy Services, Inc.	B	16-Apr-01	10000	1	
Reliant Energy Services, Inc.	B	17-Apr-01	10000	1	
Reliant Energy Services, Inc.	B	20-Apr-01	30000	3	
Reliant Energy Services, Inc.	S	20-Apr-01	40000	4	
Reliant Energy Services, Inc.	B	23-Apr-01	30000	3	
Reliant Energy Services, Inc.	S	23-Apr-01	120000	12	
Reliant Energy Services, Inc.	S	24-Apr-01	120000	12	
Reliant Energy Services, Inc.	B	25-Apr-01	10000	1	
Reliant Energy Services, Inc.	S	25-Apr-01	60000	6	
Reliant Energy Services, Inc.	B	26-Apr-01	10000	1	
Reliant Energy Services, Inc.	S	27-Apr-01	140000	14	


SELECT EOL.TRADING_COUNTERPARTIES.COUNTERPARTY_NAME, EOL.TRADING_TRANSACTIONS.BUY_SELL_CD, trunc(EOL.TRADING_TRANSACTIONS.TRANSACTION_DTM), Sum (EOL.TRADING_TRANSACTIONS.TRANSACTION_QTY) AS NET_VOLUME, COUNT(*) AS NUM_TRANS FROM EOL.TRADING_COUNTERPARTIES, EOL.TRADING_TRANSACTIONS WHERE EOL.TRADING_COUNTERPARTIES.COUNTERPARTY_ID = EOL.TRADING_TRANSACTIONS.COUNTERPARTY_ID AND (EOL.TRADING_TRANSACTIONS.MARKET_PRODUCT_ID = 27762) GROUP BY trunc(EOL.TRADING_TRANSACTIONS.TRANSACTION_DTM), EOL.TRADING_COUNTERPARTIES.COUNTERPARTY_NAME, EOL.TRADING_TRANSACTIONS.BUY_SELL_CD HAVING (EOL.TRADING_COUNTERPARTIES.COUNTERPARTY_NAME LIKE 'Reliant%') AND (trunc(EOL.TRADING_TRANSACTIONS.TRANSACTION_DTM) >= { ts '2001-04-01 00:00:00' }) ORDER BY EOL.TRADING_COUNTERPARTIES.COUNTERPARTY_NAME,  EOL.TRADING_TRANSACTIONS.BUY_SELL_CD