with acquired_transaction as
(
select
from_address,
(block_timestamp) as acquired_time
from ethereum.core.fact_transactions
where block_timestamp between '2023-01-01' and '2024-01-01'
and nonce=1
)
select date_trunc('month',acquired_time) as month, count(distinct from_address) as acquired_users
from acquired_transaction
group by month
order by month asc