date_trunc('day', block_timestamp) as day,

COUNT(DISTINCT message_value:contract) active_contracts

FROM terra.core.ez_messages

GROUP BY 1