SELECT

from_address as user,

min(block_timestamp)::date as min_date

FROM blast.core.fact_transactions

GROUP BY 1

new_user as (

SELECT

min_date as wallet_date,

count(DISTINCT from_address) as new_wallets

FROM total_user

GROUP BY 1

SELECT

date_trunc('day', block_timestamp) as date,

new_wallets as "new_users",

user as old_user

FROM new_user as b

JOIN total_user t on b.new_wallets = t.User

WHERE b.block_timestamp > t.min_date

GROUP BY 1