block_timestamp::date as date

,count(DISTINCT tx_id) as contracts

from terra.core.ez_messages

where block_timestamp::date>='2022-12-25' and block_timestamp::date<='2022-12-31'

and message_type ilike '%MsgInstantiateContract%'

group by date

order by date desc