select tx_receiver as contract,
sum(gas_used) / power(10, 12) as gas_used, sum(transaction_fee) / power(10, 24) as transaction_fee from flipside_prod_db.mdao_near.transactions
where block_timestamp >= CURRENT_DATE - 7
group by 1
order by 2 desc
limit 10