with
base as (
select
tx_signer as address,
count(distinct date(block_timestamp)) as active_days
from near.core.fact_transactions
where date(block_timestamp) between '{{Start_date}}' and '{{End_date}}'
group by 1
)
select
active_days as days_active_in_quarter,
count(active_days) as number_of_addresses
from
base
group by 1
order by 1 asc