with one as (select
date_trunc('day',block_timestamp) as day,
count(distinct from_address) as unique_address_per_day
from polygon.core.fact_transactions
where block_timestamp between '2022-07-01' and '2022-07-12'
group by 1)
select
day,
unique_address_per_day
from one
group by 1, 2