select

created_block_timestamp::date as date,

count(distinct address) as number_of_contracts_deployed,

-- sum(number_of_contracts_deployed) over(order by date asc) as total_number_of_contracts_deployed,

count(distinct creator_address) as number_of_deployers,

-- sum(number_of_deployers) over(order by date asc) as total_number_of_deployers,

from ethereum.core.dim_contracts

where 1=1

and date >= '{{Start_date}}'

and date <= '{{End_date}}'

group by date

order by date desc