select date_trunc('day', block_timestamp) as day, count(distinct TX_HASH) as hash, count(distinct TX_SIGNER) as address, sum (TRANSACTION_FEE/1e24) as Fees,
case when TX_RECEIVER='zomland.near' then 'Zomland' else 'Other tokens' end as Type
from near.core.fact_transactions
where tx_status = 'Success'
group by Type, day