select

min(date_trunc('week', block_timestamp)) as date1,

message_value:contract

from terra.core.ez_messages

where message_type like '%Contract%'

group by 2

select

count(*)

from tab1