select

distinct t.tx_receiver as contract_address,

case

when l.project_name is not null then l.project_name

else t.tx_receiver

end as contract_group

from

near.core.fact_transactions t

left join

near.core.dim_address_labels l

on t.tx_receiver = l.address

)

select

date(t.block_timestamp) as date,

c.contract_group as contract_group,

count(distinct t.tx_hash) as transactions,

count(distinct t.tx_signer) as addresses

from

near.core.fact_transactions t

left join

contracts c

on t.tx_receiver = c.contract_address

where

date >= current_date - interval '{{Days}} days'

group by 1,2

order by 1 desc, 3 desc