Enron Mail

From: dutch.quigley@enron.com To: colin.tonks@enron.com Subject: Cc: Bcc: Date: Mon, 13 Aug 2001 13:16:15 -0700 (PDT) select REF_PERIOD_ENGLISH_SHORT_DESC,BUY_SELL_CD,reference_period_end_dtm,sum(transaction_qty) from eol.TRADING_TRANSACTIONS WHERE TO_CHAR(transaction_dtm,'DD-MON-YYYY') = TO_CHAR(SYSDATE,'DD-MON-YYYY') and ref_period_english_short_desc like 'US Gas Swap%Nymex%' GROUP BY REF_PERIOD_ENGLISH_SHORT_DESC,BUY_SELL_CD,reference_period_end_dtm order by reference_period_end_dtm,BUY_SELL_CD