-- forked from Avalanche daily new addresses @ https://flipsidecrypto.xyz/edit/queries/d937f294-c80e-4e30-b38c-4b4d7f7f7594
with
first_interaction as (
select
min(date(block_timestamp)) as first_date,
from_address as address
from
ethereum.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