Message-ID: <5722700.1075845333765.JavaMail.evans@thyme> Date: Fri, 27 Apr 2001 16:29:51 -0700 (PDT) From: colin.tonks@enron.com To: matt.smith@enron.com Subject: US Gas Phy EPNG SoCal Topk 28-30Apr01 USD/MM Cc: mike.grigsby@enron.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bcc: mike.grigsby@enron.com X-From: Tonks, Colin X-To: Smith, Matt X-cc: Grigsby, Mike X-bcc: X-Folder: \Smith, Matt\Smith, Matt\Inbox X-Origin: SMITH-M X-FileName: Smith, Matt.pst 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