count(txn_hash),

sum(gas_used)/power(10,12) as sum_gas_used,

sum(transaction_fee)/power(10,24) as sum_fee,

tx_receiver

-- tx_signer

from

flipside_prod_db.mdao_near.transactions

where

block_timestamp::date >= CURRENT_DATE - 7

and block_timestamp::date < CURRENT_DATE

group by

tx_receiver

order by

sum_fee desc

10000