with
first_interaction as (
select
min(date(block_timestamp)) as first_date,
from_address as address
from
avalanche.core.fact_transactions
group by
2
)
select
first_date as date,
count(address) as new_addresses
from
first_interaction
where
date >= current_date - interval '{{Days}} days'
group by
1
order by
1 asc