SOURCE_CHAIN,

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

count(DISTINCT tx_hash) as n_txs

FROM axelar.defi.ez_bridge_squid

GROUP BY 2,3

UNION

SELECT

'TRANSFERS' as type,

SOURCE_CHAIN,

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

count(DISTINCT tx_hash) as n_txs

FROM axelar.defi.ez_bridge_satellite

GROUP BY 2,3