select sender,

min(block_timestamp) as first_transfer_date

from axelar.core.fact_transfers

where tx_succeeded = TRUE

group by sender

),

daily_new_users as (

select first_transfer_date::date as day,

coalesce(count(distinct sender), 0) as new_users_t,

iff(new_users_t is null, 0, new_users_t) as new_users_y,

iff(new_users_y = 0, 0, new_users_y) as new_users

from users_first_transfer

group by day

),

cumulative_new_users as (

select day,

sum(new_users) over (order by day) as cumulative_new_users

from daily_new_users

),

daily_active_users as (

select block_timestamp::date as day,

count(distinct sender) as active_users

from axelar.core.fact_transfers

where tx_succeeded = TRUE

group by day

),

cumulative_active_users as (

select day,

sum(active_users) over (order by day) as cumulative_active_users

from daily_active_users

),

all_st as (

select day,

new_users,

cumulative_new_users,