with daily_content as (
select
date_trunc('day', block_timestamp) as day,
count(distinct tx_hash) as no_created
from base.core.fact_transactions
where to_address = '0x777777c338d93e2c7adf08d102d45ca7cc4ed021' -- ERC1155 factory
and status = 'SUCCESS'
group by day
order by day
)
select
round(avg(no_created)) as total_daily_average
from daily_content