'Evmos' as chain,

msg_type,

count(distinct a.tx_id) as num_tx

from evmos.core.fact_msg_attributes a

where tx_succeeded = 'TRUE'

and date_trunc('day',block_timestamp) >= '2023-01-01'

group by 1, 2