with table1 as (select date_trunc('{{Time_Frame}}', block_timestamp) as "Date", count(distinct signer_id) as "Total User"

from near.social.fact_decoded_actions

group by 1

order by 1),

table2 as (with tab1 as (select signer_id as user, min(block_timestamp::date) as first_tx

from near.social.fact_decoded_actions

group by 1

order by 1)

select date_trunc('{{Time_Frame}}',first_tx) as "Date", count(distinct user) as "New User"

from tab1

group by 1

order by 1)

select table1."Date" as "Date", "Total User", "New User", "Total User"-"New User" as "Active User"

from table1 left join table2 on table1."Date"=table2."Date"

order by 1