select
trunc(block_timestamp,'day') as "Date",
count(distinct decoded_log:proxy) as "# of contracts deployed"
from polygon.core.fact_decoded_event_logs x
where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
AND event_name ilike '%proxydeployed%'
and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
group by 1 order by 1 asc