with smart_contracts as (

select

date_trunc('day', created_block_timestamp) as day,

count(distinct address) as total_contracts_deployed

from ethereum.core.dim_contracts

group by day

order by day asc