all_user as (

SELECT

block_timestamp,

tx_hash,

to_address,

from_address,

row_number() over (partition by from_address order by block_timestamp) as rank

FROM base.core.fact_transactions

WHERE STATUS = 'SUCCESS'

AND block_timestamp :: date >= dateadd(day, -{{past_days}}, current_date())

SELECT

project_name,

count(DISTINCT from_address) as Active_users

FROM all_user a

LEFT JOIN base.core.dim_labels b

on a.to_address = b.address

AND label_type not in ('token', 'chadmin')

GROUP by 1

HAVING project_name is not null

order by 2 desc

limit 100