SELECT SOURCE_CHAIN,
date_trunc('{{interval}}',block_timestamp) as date,
count(DISTINCT tx_hash) as n_txs,
sum(n_txs)over(partition by SOURCE_CHAIN order by date)
FROM(
SELECT SOURCE_CHAIN,
block_timestamp,
tx_hash
FROM axelar.defi.ez_bridge_squid
UNION
SELECT SOURCE_CHAIN,
block_timestamp,
tx_hash
FROM axelar.defi.ez_bridge_satellite
)
GROUP BY 1,2
order
by
2 DESC, 1