WITH tbl AS (

SELECT

CREATED_BLOCK_TIMESTAMP,

creator_address AS "Address",

COUNT(*) as "Total Contracts deployed"

FROM monad.testnet.dim_contracts

GROUP BY 1,2

SELECT

date_trunc (day, CREATED_BLOCK_TIMESTAMP) as date,

sum ("Total Contracts deployed") as "Total Contracts Deployed",

sum ("Total Contracts Deployed") over (order by date) as "Cumulative Deployed Contracts"

from tbl

where date > '2025-02-18 00:00:00.000'

group by 1

order by 1