with daily as (
select BLOCK_TIMESTAMP::date as day,count(distinct FROM_ADDRESS) as total_unique_addresses
from polygon.core.fact_transactions
where BLOCK_TIMESTAMP::date>='2022-07-1'
group by day
order by day
)
select sum (total_unique_addresses) as total_unique_addresses, avg(total_unique_addresses) average_daliy_unique_addresses
from daily