event_inputs:depositReceiver as new_user,

min(block_timestamp::date) as join_date

from ethereum.core.fact_event_logs left join ethereum.core.dim_contracts on event_inputs:rootToken = address

where

block_timestamp >= '2022-06-6' and --because polygon data started since Jun 6th

contract_address = '0x40ec5b33f54e0e8a33a975908c5ba1c14e5bbbdf' and symbol is not null

group by 1

),

first_tx as (

select row_number() over (partition by from_address order by block_timestamp asc) as rank, to_address, block_timestamp::date as date

from new_user join polygon.core.fact_transactions on from_address = new_user

where date > join_date

select

project_name,

count(*)

from first_tx join polygon.core.dim_labels on to_address = address

where

rank = 1

group by 1

order by 2 desc

limit 50