date_trunc('{{interval}}',block_timestamp) as date,

count(DISTINCT message_value:contract::string) as contract_address,

count(DISTINCT tx_id) as n_txns

FROM terra.core.fact_messages

GROUP BY date