with contracts as (select tx_receiver as contract, sum(gas_used) / power(10, 12) as gas
from flipside_prod_db.mdao_near.transactions group by 1 order by 2 desc limit 50)
select
block_timestamp::date as date, tx_receiver as contract, sum(gas_used) / power(10, 12) as gas,
count(distinct txn_hash) as number_of_txs,
count(distinct tx_signer) as number_of_users
from flipside_prod_db.mdao_near.transactions where date >= '2022-01-01'
and tx_receiver in (select distinct contract from contracts)
group by 1,2