with tab2 as (with tab1 as (select from_address, min(block_timestamp) as first_tx
from blast.core.fact_transactions
where status='SUCCESS'
group by 1)
select date_trunc('hour',first_tx) as "Date", count(distinct from_address) as "New Users"
from tab1
where first_tx::date>='2024-02-29'
group by 1)
select round(avg("New Users")) as "Average New Users"
from tab2