'Here' as PROJECT_NAME,

'Here'as address_name,

'Defi' as label_type

from near.core.dim_address_labels

UNION all

select 'game.hot.tg' as address,

'Hot' as project_name,

'Hot' as address_name,

'Game' as label_type,

UNION all

select address,

PROJECT_NAME,

address_name,

from near.core.dim_address_labels)

,

new as ( select min(block_timestamp) as min,

from near.core.fact_actions_events_function_call a join label_type b on a.receiver_id = b.address

where signer_id not in (select address from near.core.dim_address_labels)

and RECEIPT_SUCCEEDED = 'TRUE'

and label_type not in ('token_contract','chadmin','cex','operator','token')

group by 2)

,

final as (select DISTINCT signer_id

from new

where min::date >= '2024-01-01'

,

intract as (select signer_id,

count(DISTINCT block_timestamp::date) as days

from near.core.fact_actions_events_function_call a join label_type b on a.receiver_id = b.address

where signer_id in (select signer_id from final)

and RECEIPT_SUCCEEDED = 'TRUE'

and label_type not in ('token_contract','chadmin','cex','operator','token')