with tab1 as (select proposer, min(block_timestamp::date) as first_tx
from flow.core.fact_transactions
where tx_succeeded='true'
group by 1
order by 1)
select date_trunc('{{Time_Frame}}',first_tx) as "Date", count(distinct proposer) as "New User"
from tab1
group by 1
order by 1