Enron email

Algorithmic Indexing

13 Aug 2001, 20:16 UTC

(no subject)

From
Dutch Quigley dutch.quigley@enron.com
To
Colin Tonks
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