with addresses as

select from_address, min(block_timestamp) as first_transaction_sent

from polygon.core.fact_transactions

group by from_address

having first_transaction_sent >= '{{Start_date}}'

),

first_transaction as

select * from polygon.core.fact_transactions

where 1=1

and block_timestamp >= '{{Start_date}}'

and from_address in ( select from_address from addresses)

qualify(row_number() over (partition by from_address order by block_timestamp asc)=1)

),

top_200 as (

select dl.project_name,

count(distinct ft.from_address) as number_of_users,

row_number() over (order by number_of_users desc) as rn

from first_transaction ft

inner join polygon.core.dim_labels dl

on ft.to_address=dl.address

where dl.label_type not in ('token','cex','chadmin')

group by dl.project_name