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

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'

)

GROUP BY date

UNION

SELECT

'TRANSFERS' as type,

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

count(DISTINCT tx_hash) as n_txs

FROM axelar.defi.ez_bridge_satellite

GROUP BY date

ORDER BY 1 DESC