COUNT(*) AS "Total Contracts Created"

, COUNT(DISTINCT signer_id) AS "Creators"

, COUNT(CASE WHEN BLOCK_TIMESTAMP::date >= current_date - 7

THEN 1 END) AS "Last 7 Days Contract"

, COUNT(DISTINCT CASE WHEN BLOCK_TIMESTAMP::date >= current_date - 7

THEN signer_id END) AS "Last 7 Days Creators"

, COUNT(CASE WHEN BLOCK_TIMESTAMP::date >= current_date - 30

THEN 1 END) AS "Last 30 Days Contract"

, COUNT(DISTINCT CASE WHEN BLOCK_TIMESTAMP::date >= current_date - 30

THEN signer_id END) AS "Last 30 Days Creators"

, COUNT(CASE WHEN BLOCK_TIMESTAMP::date >= '2024-01-01'

THEN 1 END) AS "2024 Contract"

, COUNT(DISTINCT CASE WHEN BLOCK_TIMESTAMP::date >= '2024-01-01'

THEN signer_id END) AS "2024 Creators"

FROM near.core.fact_actions_events

WHERE action_name = 'DeployContract'

LIMIT 1000