count(DISTINCT tx_id) as n_txs

FROM (

SELECT tx_id ,

block_timestamp

FROM axelar.core.fact_msg_attributes

WHERE ATTRIBUTE_VALUE = 'Event_ContractCallWithToken'

UNION

SELECT tx_id ,

block_timestamp

FROM axelar.core.fact_msg_attributes

WHERE ATTRIBUTE_VALUE = 'Event_ContractCall'

)

UNION

SELECT

'TRANSFERS' as type,

count(DISTINCT tx_hash) as n_txs

FROM axelar.defi.ez_bridge_satellite

ORDER BY type