select

from_address AS user,

min(block_timestamp)::Date AS Timedate

from base.core.fact_transactions group by 1

),

new2 AS (

select

Date_trunc('Day',Timedate)::DATE AS DAY,

count(user) AS New_users,

sum(New_users) over (order by Day) AS CUM_users

from new group by 1

),

main AS (

select

Date_trunc('Day',BLOCK_TIMESTAMP)::DATE AS DAY,

count(*) AS TX,

sum(TX) over (order by Day ) AS Cum_TX,

count(DISTINCT From_address) AS Active_Users

from base.core.fact_transactions

group by 1)

select

Day,New_users,CUM_users,TX,Cum_TX,Active_Users-New_users AS Retained_users from main inner join new2 using(DAY)