select count(StageName) from OpportunityHistory where StageName = 'x' and CreatedDate = THIS_WEEK

SELECT count(id), newvalue, oldvalue from OpportunityFieldHistory where Field = 'StageName' and NewValue = 'x' and OldValue != 'x'

SELECT Stagename, SUM(amount) FROM Opportunity GROUP BY Stagename