select

distinct el.contract_address as contract,

case

when dl.project_name is not null then dl.project_name

when el.contract_address = '0xf9ad3f5eab7e9214387c75d58ce40d3a6d05b930' then 'project galaxy'

when el.contract_address in ('0x3b3e4b4741e91af52d0e9ad8660573e951c88524','0x51af494f1b4d3f77835951fa827d66fc4a18dae8','0xc22fbb3133df781e6c25ea6acebe2d2bb8cea2f9') then 'woofi'

else el.contract_address

end as dapp

from

avalanche.core.fact_decoded_event_logs el

left join

avalanche.core.dim_labels dl

on el.contract_address = dl.address

),

power_users as (

select

from_address as address,

count(distinct date(block_timestamp)) as active_days

from avalanche.core.fact_transactions

where date(block_timestamp) >= current_date - interval '{{Days}} days'

group by 1

having active_days > {{Active_Days}}

select

date(ft.block_timestamp) as date,

c.dapp as dapp,

count(distinct ft.tx_hash) as transactions,

count(distinct ft.from_address) as addresses

from

avalanche.core.fact_transactions ft

join

power_users

on ft.from_address = power_users.address

left join

avalanche.core.fact_decoded_event_logs el