select

distinct t.tx_receiver as 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

),

power_users as (

select

tx_signer as address,

count(distinct date(block_timestamp)) as active_days

from near.core.fact_transactions

where date(block_timestamp) between '{{Start_date}}' and '{{End_date}}'

group by 1

having active_days > {{Active_days}}

),

top_dapps as (

select

c.contract_group as dapp,

count(distinct t.tx_signer) as address

from

near.core.fact_transactions t

join

power_users

on t.tx_signer = power_users.address

left join

contracts c

on t.tx_receiver = c.address

where date(t.block_timestamp) between '{{Start_date}}' and '{{End_date}}'

group by 1