tx_hash AS "contract_id", -- tx_hash is the unique identifier for the contract deployment transaction

DATE_TRUNC('day', CURRENT_TIMESTAMP) - DATE_TRUNC('day', MIN(block_timestamp)) AS "contract_age",

COUNT(DISTINCT tx_hash) AS "total_deployments"

near.core.fact_actions_events

action_name = 'DeployContract'

AND receipt_succeeded = TRUE

AND signer_id NOT IN ('lockup.near', 'deposit.aurora', 'near')

GROUP BY

tx_hash

ORDER BY

"contract_age" DESC;