date_trunc('month', block_timestamp::date) as day,

count(*) as "Number of Monthly Deployed Contract Events",

sum("Number of Monthly Deployed Contract Events") over (order by day asc) as "Total Number of Deployed Contract Events"

from

near.core.fact_actions_events

where

action_name='DeployContract'

group by

day

order by

day asc