tags as (

select address, initcap(project_name) as project_name

from near.core.dim_address_labels

union all

select 'claim.sweat', 'Sweat')

select

ifnull(PROJECT_NAME,ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)) as project,

count(distinct ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)) as signers,

count(*) as txs,

count(distinct ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)) as receivers,

FROM near.core.fact_transactions

left join tags

on address=ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)

WHERE DATE_TRUNC('month', block_timestamp) = '2025-03-01'

group by 1

order by 2 desc

limit 1000